Urban farmers dream. Private retreat on 1+ acres. Sit back and enjoy the surrounding nature and abundant wildlife. Terrific location in Columbia Township on the border of Kenwood & Madeira. Large, updated kitchen featuring quartz counter tops an slate appliances. Two updated bathrooms. New hot water heater and furnace.
Single-familyProperty Type
1941Year Built
1.13 acresLot Size
$222Est. Price/Sq.Ft.
2 car garageParking
Listed by Tracy Sunderhaus• Hand In Hand Realty, LLC
•513-373-5856 (agent)
•tracy.sunderhaus@gmail.com (agent)
•513-832-8998 (broker)
•richwebberrealestate@gmail.com (broker)
Bought with Julie Swindell• RE/MAX Preferred Group
Endless possibilities in this traditional Cape Cod. Terrific location in Columbia Township on the border of Kenwood, Madeira, & Silverton. A private retreat on 1+ acres.
Cincy MLS #1232406
Jan 26, 2011
Listing Removed
—
Jul 26, 2010
Listed
$170,000
$93/sq ft
Public Records
Aug 6, 1999
Sold
$500,000
$272/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$6,337 (+2.8%)
$28,648 + $71,166
$99,814
2024
$6,165 (−2.0%)
$28,648 + $71,166
$99,814
2023
$6,290 (+4.6%)
$28,648 + $71,166
$99,814
2022
$6,011 (+3.4%)
$21,693 + $57,803
$79,496
2021
$5,815 (−2.0%)
$21,693 + $57,057
$78,750
2020
$5,937 (+8.0%)
$21,693 + $57,057
$78,750
2019
$5,499 (−0.1%)
$20,465 + $44,506
$64,971
2018
$5,506 (+4.2%)
$20,465 + $44,506
$64,971
2017
$5,283 (+12.8%)
$20,465 + $44,506
$64,971
2016
$4,684 (+12.2%)
$19,541 + $38,787
$58,328
2014
$4,176
$19,541 + $38,787
$58,328
Tax history for 6697 Stewart Rd
Year
Property tax
Land + Additions
Assessment*
2025
$6,337 (+2.8%)
$28,648 + $71,166
$99,814
2024
$6,165 (−2.0%)
$28,648 + $71,166
$99,814
2023
$6,290 (+4.6%)
$28,648 + $71,166
$99,814
2022
$6,011 (+3.4%)
$21,693 + $57,803
$79,496
2021
$5,815 (−2.0%)
$21,693 + $57,057
$78,750
2020
$5,937 (+8.0%)
$21,693 + $57,057
$78,750
2019
$5,499 (−0.1%)
$20,465 + $44,506
$64,971
2018
$5,506 (+4.2%)
$20,465 + $44,506
$64,971
2017
$5,283 (+12.8%)
$20,465 + $44,506
$64,971
2016
$4,684 (+12.2%)
$19,541 + $38,787
$58,328
2014
$4,176
$19,541 + $38,787
$58,328
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
4
Baths
1.5
Stories
1.5
Lot width
—
Lot depth
—
Lot size
1.13 Acres
Year renovated
—
Sq. Ft.
1,822
Year built
1941
Style
Single Family Residential
County
Hamilton County
APN
5200221004000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 19, 2026.
B
Residential District
The purpose of the B Districts established, is to protect and support the development of single-family housing in conjunction with appropriate accessory uses and public and institutional uses. The standards of these districts are intended to maintain a suitable environment for family living at various densities and in various types on housing, including single-family detached and clustered housing under specified conditions which provides flexibility in the organization of site elements and building location.
Property details
Parking
Garage Information
Garage Spaces: 2
Parking Information
Attached
Interior
Room Information
Rooms Total: 8
Basement: Full, Concrete, Partially Finished
Bathroom Information
Bathrooms Half: 1
Bathrooms Full: 2
Interior Features
Interior Features: Eat-in Kitchen
Appliances: Dishwasher, Oven, Refrigerator, Gas Water Heater
Flooring: Wood, Tile
Fireplace Features: Wood Burning, Living Room
Fireplaces Total: 1
Exterior
Building Information
Construction Materials: Brick, Wood Siding
Year Built: 1941
Exterior Information
Roof: Shingle
Patio And Porch Features: Covered, Deck, Patio
Window Features: Wood Frames
Land Information
Foundation Details: Block
Lot Features
Lot Size Dimensions: 1.1260 ACS
Lot Size Area: 49049.0
Lot Size Units: Square Feet
Property Information
Above Grade Finished Area: 1836.0
Living Area: 1836.0
Financial
Tax Information
Tax Annual Amount: 5268.0
Utilities
Heating & Cooling Information
Heating: Natural Gas, Forced Air
Cooling: Central Air
Utility Information
Water Source: Public
Sewer: Public Sewer
Public facts
Beds: 4
Baths: 1.5
Sq. Ft.: 1,822
Stories: 1.5
Lot Size: 1.13 acres
Style: Single Family Residential
Year Built: 1941
Year Renovated: —
County: Hamilton County
APN: 5200221004000
Home facts updated by county records on Oct 19, 2026
Other
Listing Information
BuyerAgencyCompensation: $3
Around this home
Schools
K - 12
Preschool & daycare
Silverton Paideia Elementary School
Public PreK-6 • Assigned • 0.4mi
6/10
Shroder Paideia High School
Public 8-12 • Assigned • 1.8mi
5/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
4/10 Heat Factor
7 days above 103° expected this year, 19 days in 30 years
2/10 Wind Factor
1% chance of strong winds in next 30 years
4/10 Air Factor
4 unhealthy days expected this year, 5 days in 30 years
Provided by First Street
Historical weather
Cincinnati, OH • 45236
Average low and high temperatures (°F)
35°
18°
44°
26°
63°
39°
70°
48°
72°
54°
83°
65°
87°
70°
83°
63°
82°
57°
68°
47°
55°
39°
44°
29°
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.2 hours in
June and 3.1 hours in December, placing it below the
U.S. average for solar exposure.
9.2 hrs
3.1 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$387,000 – $469,000
Reach more buyers when you sell with Redfin. Save up to $4,071 in fees.3 minutes to get started.