Welcome home to this charming Cape Cod offering nearly 1,700 sq ft of living space! This well-maintained 3-bedroom, 2-full bath home features an updated kitchen with newer countertops, backsplash, and flooring, along with refreshed bathrooms that add modern appeal. The spacious primary suite includes a private full bath, sitting area, skylights, and generous closet space. Beautiful hardwood floors, a cozy fireplace, and built-in bookcases add warmth and character to the large living room. Enjoy gatherings in the formal dining room or relax on the wrap-around deck overlooking the fenced backyard. Additional features include an unfinished basement offering storage or future potential, a garage, and a unique setting tucked back from the road for added privacy. Conveniently located near shopping, dining, and major highways. Move-in ready and waiting for its next owner!
For sale
Price cut: $4.1K (7/10)
$264,900
5651 Colerain Ave, Cincinnati, OH 45239
3beds
1,696sqft
Single Family Residence
Built in 1939
0.28 Acres Lot
$-- Zestimate®
$156/sqft
$-- HOA
What's special
Wrap-around deckSpacious primary suiteBeautiful hardwood floorsOverlooking the fenced backyardRefreshed bathroomsNewer countertopsUpdated kitchen
- 35 days |
- 1,832 |
- 141 |
Likely to sell faster than
Zillow last checked:
Listing updated:
Listed by:
Harold Brown 513-391-2355,
Coldwell Banker Realty 513-891-8500
Source: Cincy MLS,MLS#: 1881477
Originating MLS: Cincinnati Area Multiple Listing Service

Loading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Features: Bath Adjoins, Vaulted Ceiling(s), Sitting Room, Skylight
- Level: Second
- Area: 324
- Dimensions: 27 x 12
Bedroom 2
- Level: First
- Area: 154
- Dimensions: 14 x 11
Bedroom 3
- Level: First
- Area: 143
- Dimensions: 13 x 11
Bedroom 4
- Area: 0
- Dimensions: 0 x 0
Bedroom 5
- Area: 0
- Dimensions: 0 x 0
Primary bathroom
- Features: Tile Floor, Tub w/Shower
Bathroom 1
- Features: Full
- Level: Second
Bathroom 2
- Features: Full
- Level: First
Bathroom 3
- Features: Partial
- Level: Basement
Dining room
- Features: Wood Floor
- Level: First
- Area: 154
- Dimensions: 14 x 11
Family room
- Area: 0
- Dimensions: 0 x 0
Kitchen
- Features: Quartz Counters, Tile Floor, Walkout, Wood Cabinets
- Area: 99
- Dimensions: 11 x 9
Living room
- Features: Bookcases, Fireplace, Wood Floor
- Area: 240
- Dimensions: 20 x 12
Office
- Area: 0
- Dimensions: 0 x 0
Heating
- Forced Air, Gas
Cooling
- Central Air
Appliances
- Included: Gas Water Heater
Features
- Windows: Vinyl, Insulated Windows
- Basement: Full,Unfinished,Walk-Out Access,Glass Blk Wind
- Fireplace features: Living Room
Interior area
- Total structure area: 1,696
- Total interior livable area: 1,696 sqft
Property
Parking
- Total spaces: 2
- Parking features: Garage - Attached
- Attached garage spaces: 2
Features
- Stories: 1
Lot
- Size: 0.28 Acres
Details
- Parcel number: 2310003002400
- Zoning description: Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Cape Cod
- Property subtype: Single Family Residence
Materials
- Brick
- Foundation: Concrete Perimeter
- Roof: Shingle
Condition
- New construction: No
- Year built: 1939
Utilities & green energy
- Gas: Natural
- Sewer: Public Sewer
- Water: Public
Community & HOA
HOA
- Has HOA: No
Location
- Region: Cincinnati
Financial & listing details
- Price per square foot: $156/sqft
- Tax assessed value: $205,000
- Annual tax amount: $4,480
- Date on market: 6/6/2026
- Listing terms: No Special Financing
Estimated market value
Zestimate®
Not available
Estimated sales range
Not available
Rent Zestimate®
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 7/10/2026 | Price change | $264,900-1.5%$156/sqft |
Source: | ||
| 6/6/2026 | Listed for sale | $269,000+31.2%$159/sqft |
Source: | ||
| 5/27/2022 | Sold | $205,000+10.9%$121/sqft |
Source: | ||
| 4/28/2022 | Pending sale | $184,900$109/sqft |
Source: | ||
| 4/27/2022 | Listed for sale | $184,900+68.1%$109/sqft |
Source: | ||
| 8/30/2013 | Sold | $110,000-4.3%$65/sqft |
Source: | ||
| 8/29/2013 | Pending sale | $114,900$68/sqft |
Source: Comey & Shepherd Realtors #1362255 Report a problem | ||
| 8/27/2013 | Listed for sale | $114,900$68/sqft |
Source: Comey & Shepherd Realtors #1362255 Report a problem | ||
| 8/7/2013 | Pending sale | $114,900$68/sqft |
Source: Comey & Shepherd Realtors #1362255 Report a problem | ||
| 6/18/2013 | Listed for sale | $114,900-10.2%$68/sqft |
Source: Comey & Shepherd Realtors #1362255 Report a problem | ||
| 4/17/2006 | Sold | $128,000+18.6%$75/sqft |
Source: | ||
| 12/11/2000 | Sold | $107,900$64/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $4,346 -2.2% | $71,750 |
| 2023 | $4,443 +86.3% | $71,750 +110.6% |
| 2022 | $2,385 +1.8% | $34,069 |
| 2021 | $2,342 | $34,069 |
| 2020 | $2,342 +5.9% | $34,069 +16% |
| 2019 | $2,212 +5.4% | $29,368 0% |
| 2018 | $2,099 | $29,369 |
| 2017 | $2,099 -16.3% | $29,369 -23.7% |
| 2016 | $2,507 | $38,500 |
| 2015 | $2,507 -0.7% | $38,500 |
| 2014 | $2,525 +8.2% | $38,500 +10.1% |
| 2013 | $2,335 +1.8% | $34,969 |
| 2012 | $2,294 +3.1% | $34,969 |
| 2011 | $2,226 -17% | $34,969 -21.9% |
| 2010 | $2,680 +3.8% | $44,800 |
| 2009 | $2,583 +1.8% | $44,800 |
| 2008 | $2,537 +20.2% | $44,800 +5.2% |
| 2007 | $2,111 +1.1% | $42,595 |
| 2006 | $2,088 -0.8% | $42,595 |
| 2005 | $2,104 +6.7% | $42,595 +16.2% |
| 2003 | $1,973 +6.6% | $36,645 |
| 2002 | $1,850 -12.9% | $36,645 -7.4% |
| 2001 | $2,123 +30.1% | $39,585 |
| 2000 | $1,631 | $39,585 |
Find assessor info on the county website
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Principal & interest
$1,547Mortgage insurance
$0Property taxes
$170Home insurance
$105HOA fees
$0Utilities
Not includedAll calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: Mt. Airy
Nearby schools
GreatSchools rating
- 4/10Mt. Airy Elementary SchoolGrades: PK-6Distance: 0.2 mi
- 4/10Aiken New Tech High SchoolGrades: 7-12Distance: 1.4 mi
- 3/10James N. Gamble Montessori High SchoolGrades: 7-12Distance: 4 mi
- $281,1005 bd3 ba3.4k sqft5657 Colerain Ave, Cincinnati, OH 45239Off Market
Save 
- $213,6003 bd2 ba2k sqft5645 Colerain Ave, Cincinnati, OH 45239Off Market
Save - $218,5001 bd1 ba984 sqft5645 Colerain Ave #2, Cincinnati, OH 45239Off Market
Save - $323,6004 bd3 ba2.7k sqft2604 Mount Airy Ave, Cincinnati, OH 45239Off Market
Save 
- $229,6003 bd3 ba1.6k sqft5641 Colerain Ave, Cincinnati, OH 45239Off Market
Save - $195,8003 bd2 ba1.6k sqft5663 Colerain Ave, Cincinnati, OH 45239Off Market
Save - $297,9003 bd2 ba2.3k sqft2599 Mount Airy Ave, Cincinnati, OH 45239Off Market
Save - $173,3003 bd1 ba1.4k sqft5637 Colerain Ave, Cincinnati, OH 45239Off Market
Save
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
Similar homes
- $275,0003 bd1 ba1.6k sqft3247 Autumn Ln, Cincinnati, OH 45239For Sale
Save 
MLS ID #1882747, Joe M Sabato, Sibcy Cline, Inc.. Cincy MLS - $289,9994 bd3 ba1.8k sqft2888 Mount Airy Ave, Cincinnati, OH 45239For Sale
Save 
MLS ID #1875620, Robert R Smith, Coldwell Banker Realty. Cincy MLS - $204,0003 bd2 ba1.5k sqft5682 Colerain Ave, Cincinnati, OH 45239For Sale
Save 
MLS ID #1873563, Julia Wallner, ERA REAL Solutions Realty, LLC. Cincy MLS - $245,0003 bd2 ba1.2k sqft2677 Altura Dr, Cincinnati, OH 45239For Sale
Save 
MLS ID #1877352, Brandon M Willis, Keller Williams Seven Hills Re. Cincy MLS - $265,0003 bd2 ba1.8k sqft4615 Mayhew Ave, Delhi, OH 45238For Sale
Save
MLS ID #1876234, Anthony Vanjohnson, eXp Realty. Cincy MLS - $259,9004 bd2 ba2.2k sqft886 Sabino Ct, Cincinnati, OH 45231For Sale
Save
MLS ID #1886339, Tracy K Winkler, Comey & Shepherd. Cincy MLS - $240,0003 bd2 ba1.5k sqft8710 Mockingbird Ln, Cincinnati, OH 45231For Sale
Save
MLS ID #1886153, Emily Rothan, Coldwell Banker Realty. Cincy MLS - $249,0004 bd2 ba1.6k sqft4481 Andreas Ave, Cincinnati, OH 45211For Sale
Save
MLS ID #1885646, Leah Slicer, Coldwell Banker Realty. Cincy MLS - $325,0003 bd2 ba1.8k sqft6764 Fath Ct, Cincinnati, OH 45239For Sale
Save
MLS ID #1883451, Paige Bond, Realty First. Cincy MLS - $385,0004 bd3 ba2k sqft3294 Wheatcroft Dr, Cincinnati, OH 45239For Sale
Save
MLS ID #1885751, Jason A. Sheppard, Coldwell Banker Realty. Cincy MLS - $269,9004 bd2 ba1.8k sqft5244 Arrow Ave, Cincinnati, OH 45247For Sale
Save
MLS ID #1885123, Kristin Moore, Lohmiller Real Estate. Cincy MLS - $265,0003 bd2 ba1.4k sqft3820 Superior Ave, Cincinnati, OH 45236For Sale
Save
MLS ID #1885567, Michael Dunn, Comey & Shepherd. Cincy MLS - $224,9003 bd2 ba1k sqft6027 Springdale Rd, Cincinnati, OH 45247For Sale
Save
MLS ID #1886184, Adam J Hayhow, Coldwell Banker Realty. Cincy MLS - $265,0004 bd3 ba2.4k sqft6348 Meis Ave, Cincinnati, OH 45224For Sale
Save
MLS ID #1882021, Erin Tarantino, Coldwell Banker Realty. Cincy MLS - $269,9003 bd2 ba1.7k sqft7314 Scottwood Ave, Cincinnati, OH 45237For Sale
Save
MLS ID #1883004, Cory D Behm, Transaction Alliance LLC. Cincy MLS - $265,0003 bd2 ba2k sqft1035 Cheyenne Dr, Cincinnati, OH 45216For Sale
Save
MLS ID #1882469, Lily Cunningham, The Barazi Group LLC. Cincy MLS - $272,9003 bd3 ba2.2k sqft6556 Montevista Dr, Cincinnati, OH 45224For Sale
Save
MLS ID #1878910, Bradley Babiak, RE/MAX Preferred Group. Cincy MLS - $215,0003 bd2 ba1.4k sqft3223 Struble Rd, Cincinnati, OH 45251For Sale
Save
MLS ID #1885174, Shannon M Hartkemeyer, Plum Tree Realty. Cincy MLS - $234,9004 bd2 ba1.6k sqft9108 Orangewood Dr, Cincinnati, OH 45231For Sale
Save
MLS ID #1883509, Kammon Wilcoxson, Keller Williams Seven Hills Re. Cincy MLS - $222,9003 bd2 ba1.5k sqft2736 Barthas Pl, Cincinnati, OH 45239For Sale
Save
MLS ID #1873279, John W Galbraith, Galbraith, Realty LLC. Cincy MLS
- Request a tour
as early as tomorrow at 11:00 am
Contact agent
- Ohio
- Hamilton County
- Cincinnati
- 45239
- Mt. Airy
- 5651 Colerain Ave