Thoughtfully renovated all brick ranch on a quiet no outlet street, conveniently located between Madisonville and Columbia Township. Extensive upgrades inside and out, blending classic character with modern improvements. The main level offers three bedrooms, refinished hardwood floors, coved ceilings, and a stone surround gas fireplace. The renovated kitchen serves as the centerpiece of the home, while the finished lower level adds valuable flex rooms, a wet bar, and walkout access to a renewed paver patio. Significant updates include a newer roof, Andersen windows throughout, refreshed bathroom, upgraded electrical panel, lighting, flooring, landscaping and more! A well maintained, move in ready home with major renovations already completed!
For sale
Price cut: $14.9K (6/18)
$325,000
5801 Maphet St, Cincinnati, OH 45227
3beds
1,902sqft
Single Family Residence
Built in 1963
7,710 Square Feet Lot
$-- Zestimate®
$171/sqft
$-- HOA
What's special
All brick ranchThree bedroomsFinished lower levelRefreshed bathroomWet barCoved ceilingsRenovated kitchen
- 50 days |
- 2,024 |
- 172 |
Zillow last checked:
Listing updated:
Listed by:
Adam A Schupp 513-460-5336,
Sibcy Cline, Inc. 513-385-0900,
Mark Schupp 513-543-1477,
Sibcy Cline, Inc.
Source: Cincy MLS,MLS#: 1877338
Originating MLS: Cincinnati Area Multiple Listing Service

Loading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 1
- 1/2 bathrooms: 1
Primary bedroom
- Features: Wall-to-Wall Carpet
- Level: First
- Area: 165
- Dimensions: 15 x 11
Bedroom 2
- Level: First
- Area: 143
- Dimensions: 13 x 11
Bedroom 3
- Level: First
- Area: 100
- Dimensions: 10 x 10
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: First
Bathroom 2
- Features: Partial
- Level: Lower
Dining room
- Features: Chandelier, Wood Floor
- Level: First
- Area: 110
- Dimensions: 11 x 10
Family room
- Features: Walkout, Laminate Floor
- Area: 405
- Dimensions: 27 x 15
Kitchen
- Features: Solid Surface Ctr, Laminate Floor
- Area: 85
- Dimensions: 17 x 5
Living room
- Features: Fireplace, Wood Floor
- Area: 221
- Dimensions: 17 x 13
Office
- Features: Laminate Floor
- Level: Lower
- Area: 176
- Dimensions: 16 x 11
Heating
- Forced Air, Gas
Cooling
- Central Air
Appliances
- Included: Dishwasher, Microwave, Oven/Range, Refrigerator, Gas Water Heater
Features
- Windows: Aluminum Frames, Slider, Insulated Windows
- Basement: Full,Partially Finished,Walk-Out Access
- Number of fireplaces: 1
- Fireplace features: Stone, Gas, Living Room
Interior area
- Total structure area: 1,902
- Total interior livable area: 1,902 sqft
Video & virtual tour
Property
Parking
- Total spaces: 2
- Parking features: Off Street, Driveway, Garage Door Opener
- Attached garage spaces: 2
- Has uncovered spaces: Yes
Features
- Levels: One
- Stories: 1
- Patio & porch: Patio
Lot
- Size: 7,710 Square Feet
- Dimensions: 49 x 120
Details
- Parcel number: 5200214012400
- Zoning description: Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Brick
- Foundation: Block
- Roof: Shingle
Condition
- New construction: No
- Year built: 1963
Utilities & green energy
- Electric: 220 Volts
- Gas: Natural
- Sewer: Public Sewer
- Water: Public
Community & HOA
HOA
- Has HOA: No
Location
- Region: Cincinnati
Financial & listing details
- Price per square foot: $171/sqft
- Tax assessed value: $198,370
- Annual tax amount: $4,766
- Date on market: 5/8/2026
- Listing terms: No Special Financing
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 6/18/2026 | Price change | $325,000-4.4%$171/sqft |
Source: | ||
| 6/4/2026 | Price change | $339,900-1.4%$179/sqft |
Source: | ||
| 5/26/2026 | Price change | $344,900-1.4%$181/sqft |
Source: | ||
| 5/8/2026 | Listed for sale | $349,900+80.4%$184/sqft |
Source: | ||
| 4/21/2020 | Sold | $194,000-11.4%$102/sqft |
Source: | ||
| 2/27/2020 | Pending sale | $219,000$115/sqft |
Source: Coldwell Banker West Shell - Central Regional Office #1650493 Report a problem | ||
| 2/11/2020 | Price change | $219,000-12%$115/sqft |
Source: Coldwell Banker West Shell - Central Regional Office #1650493 Report a problem | ||
| 2/3/2020 | Listed for sale | $249,000$131/sqft |
Source: Coldwell Banker West Shell #1650493 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $4,644 -1.9% | $69,430 |
| 2023 | $4,736 -15.2% | $69,430 +2.3% |
| 2022 | $5,586 +17.6% | $67,900 |
| 2021 | $4,749 | $67,900 |
| 2020 | $4,749 +128.2% | $67,900 +111.5% |
| 2019 | $2,081 +4.5% | $32,109 |
| 2018 | $1,990 | $32,109 |
| 2017 | $1,990 +12.4% | $32,109 +1.9% |
| 2016 | $1,770 | $31,500 |
| 2015 | $1,770 +2.1% | $31,500 |
| 2014 | $1,733 -1.3% | $31,500 |
| 2013 | $1,756 -0.2% | $31,500 |
| 2012 | $1,759 -30.9% | $31,500 -26.1% |
| 2011 | $2,544 +4.8% | $42,651 -2% |
| 2010 | $2,428 +3.9% | $43,519 |
| 2009 | $2,337 -0.1% | $43,519 |
| 2008 | $2,341 -4.8% | $43,519 +2% |
| 2007 | $2,459 -3.7% | $42,665 |
| 2006 | $2,552 +12.6% | $42,665 |
| 2005 | $2,266 +9.6% | $42,665 +22.6% |
| 2003 | $2,067 +9.9% | $34,790 |
| 2002 | $1,880 +1.6% | $34,790 +10.7% |
| 2001 | $1,851 +7% | $31,430 |
| 2000 | $1,729 | $31,430 |
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.All 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: 45227
Nearby schools
GreatSchools rating
- 4/10John P Parker Elementary SchoolGrades: PK-7Distance: 0.5 mi
- 5/10Shroder Paideia High SchoolGrades: 8-12Distance: 0.8 mi
- 6/10Clark Montessori High SchoolGrades: 7-12Distance: 2.7 mi
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.
- Ohio
- Hamilton County
- Cincinnati
- 45227
- 5801 Maphet St






