9551 Brehm Road

Sold 4/30/96
Sold 4/30/96
Gallery Image 1
Sold
Last Sold Price
$245,000
4 beds2,628 sqft
9551 Brehm Road, Cincinnati, OH 45252
Single FamilyProperty Type
7.24 acresLot Size
1986Year Built
$93/sq ftPrice per sq ft
3 carsParking Spaces

Description

Custom Built Contemporary Nestled Into 7+ Acres Of Tranquil Woods! Approx 3,000 Sf Of Living Space! 3 Car Garage W/1,000 Sf! 4 Tiered Rear Attached Decking W/Breathtaking View! 2 Field Stone Wbfps! Whirlpool Master Bath!Custom Built Contemporary Nestled Into 7+ Acres Of Tranquil Woods! Approx 3,000 Sf Of Living Space! 3 Car Garage W/1,000 Sf! 4 Tiered Rear Attached Decking W/Breathtaking View! 2 Field Stone Wbfps! Whirlpool Master Bath!
  • Listed by: Mary C Balnes 513.227.1909 mary.balnes@cbws.com Brokerage DRE #0000334335 • Coldwell Banker West Shell
Listing closed: 04/30/1996 12:00 AM • Source: MLS of Greater Cincinnati, MLS#: 536082

Recent comparable sales

Median sold price

$412,000

Avg days on market

24

Sale-to-list ratio

96.9%

Cincinnati, OH

9 comparable properties found

$443,000 | 8102 Fawn Lake Court, Cincinnati, OH 45247
1/92
1

$443,000

Sold 11/26/24

4
Bedrooms
2,950
Square Feet
0.52
Acres

8102 Fawn Lake Court, Cincinnati, OH 45247

$445,000 | 6596 Springdale Road, Cincinnati, OH 45247
1/82
2

$445,000

Sold 08/26/26

4
Bedrooms
2,290
Square Feet
0.61
Acres

6596 Springdale Road, Cincinnati, OH 45247

$400,000 | 6680 Springdale Road, Cincinnati, OH 45247
1/49
3

$400,000

Sold 08/14/26

4
Bedrooms
2,754
Square Feet
1.86
Acres

6680 Springdale Road, Cincinnati, OH 45247

$312,000 | 4137 Mandrake Court, Cincinnati, OH 45251
1/30
4

$312,000

Sold 10/20/25

4
Bedrooms
2,875
Square Feet
0.28
Acres

4137 Mandrake Court, Cincinnati, OH 45251

$277,500 | 3328 Basswood Lane, Cincinnati, OH 45239
1/48
5

$277,500

Sold 09/19/25

4
Bedrooms
2,547
Square Feet
0.33
Acres

3328 Basswood Lane, Cincinnati, OH 45239

$415,000 | 8353 Ridgevalley Court, Cincinnati, OH 45247
1/43
6

$415,000

Sold 06/04/25

4
Bedrooms
2,454
Square Feet
0.32
Acres

8353 Ridgevalley Court, Cincinnati, OH 45247

$412,000 | 8266 Spring Leaf Lake Drive, Cincinnati, OH 45247
1/48
7

$412,000

Sold 08/08/25

4
Bedrooms
2,761
Square Feet
0.34
Acres

8266 Spring Leaf Lake Drive, Cincinnati, OH 45247

$364,900 | 8244 Spring Leaf Lake Drive, Cincinnati, OH 45247
1/55
8

$364,900

Sold 02/06/26

4
Bedrooms
2,374
Square Feet
0.25
Acres

8244 Spring Leaf Lake Drive, Cincinnati, OH 45247

$472,076 | 10054 Prechtel Road, Cincinnati, OH 45252
1/33
9

$472,076

Sold 12/31/25

4
Bedrooms
2,673
Square Feet
1.48
Acres

10054 Prechtel Road, Cincinnati, OH 45252

Get preapproved with Rocket Mortgage1

Location

Listing Courtesy of Coldwell Banker West Shell

Sold By Coldwell Banker West Shell

Add your commute

Payment Calculator

Get preapproved with Rocket Mortgage1

$1,491 per month

30 year fixed, 6.71% Interest

Principal and Interest

$1,266

Property Taxes

$225

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 9551 Brehm Road

Property Details
  • Taxes: $2,703 / year
  • MLS Type: Residential / Single Family Residence
  • County: Hamilton County
  • Architectural Style: Contemporary/Modern
  • View: Woods
  • Zoning: Residential
  • Zoning Details: Residential
Building Information
  • Year Built: 1986
  • Lot Size: 7.24 AC / 315,374 SF
Summary
Location and General Information
  • MLS Area Major: Hamilton-W10
  • Area Short Name: W10
  • Directions: Colerain Ave To W.On Springdale Rd To Right On Brehm Rd To Private Lane
  • FIPS Code: 61
  • Township: Colerain
  • Census Tract: 205.02
  • Public Transportation: At Northgate
Taxes and HOA
  • Association Fee Frequency: Other
  • Has Association: No
  • Other Tax Parcel ID: 5100240015400
  • Parcel Number: 510-0240-0062-00
  • Semi Annual Taxes: 1351.72
School Information
  • High School District: Northwest Local SD
  • School Name 1: Call SD 513-825-4600
  • School Type 1: District Phone
Parking
  • Garage Carport: Built in, Side, Oversized
  • Garage Spaces: 3.0
  • Parking Features: Driveway
Property
Lot Information
  • Land Description: 5 to 9.9 Acres
  • Lot Area: 279307.0
  • Lot Size Acres: 7.24
  • Lot Size Dimensions: Irregular
  • Lot Size Square Feet: 315374.0
  • Lot Size Units: Acres
  • Miscellaneous: Ceiling Fan, Smoke Alarm, 220 Volt
  • 2nd Floor Area: 884
Property and Assessments
  • Living Area: 2628.0
  • 3rd Party Approval Required: No
  • Above Grade Sq Ft: 2628
  • Assessment Amount: 0.00
  • Has Board Loaded: Yes
  • Degree Complete: Completed
  • New Construction: No
  • Single Family Description: Single Family
  • Validated: Yes
  • Year Built: 1986
Building Features
  • Foundation Details: Poured
  • Levels: Two
  • Entry Dimensions: 0 x 0
  • Has Additional Dwelling Unit: No
  • Buildings: Shed
  • Construction Materials: Stone, Cedar
Utilities
  • Sewer: Aerobic Septic
  • Water Source: Public
  • Mechanical Systems: Humidifier
Interior and Exterior Features
Exterior Features
  • Exterior Features: Patio, Balcony, Yard Lights, Wooded Lot
  • Roof: Shingle
Interior Features
  • Appliances: Oven/Range, Dishwasher, Garbage Disposal, Microwave
  • Basement: Partial
  • Basement Features: Finished, Walkout, Fireplace, WW Carpet
  • Bathroom1: Full
  • Bathroom1 Level: 2
  • Bathroom2: Full
  • Bathroom2 Level: 2
  • Bathroom3: Full
  • Bathroom3 Level: 1
  • Bathroom4: Full
  • Bathroom Level: Yes
  • Bathrooms: 5.0
  • Bathrooms Display: 5 (4 1)
  • Bathrooms Full: 4
  • Bathrooms Half: 1
  • Bedroom Level1: Yes
  • Bedrooms Total: 4
  • Basement Sq Ft: 1704
  • Cooling: Central Air
  • Entry Foyer: Tile Floor, Closet, Open Foyer
  • Fireplace Features: Stone
  • Fireplaces Total: 2
  • Heating: Electric, Forced Air, Heat Pump
  • Interior Features: Natural Woodwork, Vaulted Ceiling, Beam Ceiling
  • Primary Bathroom: Double Vanity, Skylight, Tile Floor, Jetted Tub
  • Rooms Total: 9
  • Study Features: Wall-to-Wall Carpet, French Doors, Walkout
  • Window Features: Insulated, Vinyl
Room Information
Bedroom
  • Bedroom Width: 12
  • Primary Bed Feature: Wall-to-Wall Carpet, Bath Adjoins, Walk-in Closet, Walkout
  • Primary Bedroom: 20x24 Level: 2
  • Primary Bedroom Area: 480
  • Primary Bedroom Dimensions: 20 x 24
  • Primary Bedroom Length: 20
  • Primary Bedroom Width: 24
  • Bedroom 2: 11x12 Level: 2
  • Bedroom 2 Area: 132
  • Bedroom 2 Dimensions: 11 x 12
  • Bedroom 2 Length: 11
  • Bedroom 3: 11x11 Level: 2
  • Bedroom 3 Area: 121
  • Bedroom 3 Dimensions: 11 x 11
  • Bedroom 3 Length: 11
  • Bedroom 3 Width: 11
  • Bedroom 4: 11x12 Level: 1
  • Bedroom 4 Area: 132
  • Bedroom 4 Dimensions: 11 x 12
  • Bedroom 4 Length: 11
  • Bedroom 4 Width: 12
  • Bedroom 5: 0x0 Level: Lower
  • Bedroom 5 Dimensions: 0 x 0
Breakfast Room
  • Breakfast Room Dimensions: 0 x 0
Dining Room
  • Dining Room: 11x16 Level: 1
  • Dining Room Area: 176
  • Dining Room Dimensions: 11 x 16
  • Dining Room Feat: Wood Floor
  • Dining Room Length: 11
  • Dining Room Width: 16
  • Formal Dining Room: Yes
Family Room
  • Family Room: 14x28 Level: Lower
  • Family Room Area: 392
  • Family Room Dimensions: 14 x 28
  • Family Room Feat: Wall-to-Wall Carpet, Fireplace, Walkout
  • Family Room Length: 14
  • Family Room Width: 28
Kitchen
  • Kitchen Area: 264
  • Kitchen Dimensions: 12 x 22
  • Kitchen Features: Wood Floor, Eat-In, Wood Cabinets, Pantry, Island, Walkout
  • Kitchen Length: 12
  • Kitchen Width: 22
Laundry Room
  • Laundry Room: 6x6 Level: 1
  • Laundry Room Area: 36
  • Laundry Room Dimensions: 6 x 6
  • Laundry Room Length: 6
  • Laundry Room Width: 6
Living Room
  • Living Great Room Area: 728
  • Living Great Room Dimensions: 26 x 28
  • Living Great Room Length: 26
  • Living Great Room Width: 28
  • Living Room: 26x28 Level: 1
  • Living Room Feat: Wall-to-Wall Carpet, Fireplace, Great Room
Additional Room Information
  • Flex Rooms: Loft
  • Recreation Room Dimensions: 0 x 0
  • Study/Library Den: 10x11 Level: Lower
  • Study/Library Den Area: 110
  • Study/Library Den Dimensions: 10 x 11
  • Study/Library Den Length: 10
  • Study/Library Den Width: 11
Rental
Rent Information
  • Occupancy: At Closing
  • Available Date: 10-06-1995
  • Has Lease Considered: No
  • Occupant Name: Owner
  • Sub Lease: No

Property History for 9551 Brehm Road

DateEvent & SourcePriceAppreciation
Apr 30, 1996

Sold

MLS of Greater Cincinnati #536082

$245,000—
Oct 6, 1995

Listed (Active)

MLS of Greater Cincinnati #536082

$254,875—
Apr 30, 1993

Sold

MLS of Greater Cincinnati #450243

$240,000—
DateEvent & SourcePrice
04/30/1996

Sold

MLS of Greater Cincinnati #536082

$245,000
10/06/1995

Listed (Active)

MLS of Greater Cincinnati #536082

$254,875
04/30/1993

Sold

MLS of Greater Cincinnati #450243

$240,000

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 9551 Brehm Road

Taxable ValueLand$41,003Additions$116,578Total$157,581
Tax Record2025$9,093 ($758 / month)
Home Facts
Beds4Baths3.5Total Finished SqFt2,628 SqFtAbove Grade Finished SqFt2,628 SqFtStories2Lot Size279,307 SqFtStyleSingle Family ResidenceYear Built1986CountyHAMILTONAPN510-0240-0062-00Fireplace TypeHas Fireplace

Schools near 9551 Brehm Road

This home is within Northwest Local School District.
Rating
School
Type
Grades
Distance
Colerain Elementary School
Public - K to 5
Colerain Middle School
Public - 6 to 8
Colerain High School
Public - 9 to 12
Transitions Academy
Public - 6 to 12
Rating
School
Distance
Colerain Elementary School
PublicK to 5

Colerain Middle School
Public6 to 8

Colerain High School
Public9 to 12

Transitions Academy
Public6 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

New listings in 45252

$274,900 | 4194 Intrepid Drive, Cincinnati, OH 45252
1/27
Listed By Coldwell Banker Realty

$274,900

2
Bedrooms
1,859
Square Feet

4194 Intrepid Drive, Cincinnati, OH 45252

$158,000 | 9901 Regatta Drive, Unit 105, Cincinnati, OH 45252
1/20

$158,000

2
Bedrooms
1,109
Square Feet

9901 Regatta Drive, Unit 105, Cincinnati, OH 45252

$310,000 | 5159 West Kemper Road, Cincinnati, OH 45252
1/41

$310,000

3
Bedrooms
1,798
Square Feet
1.03
Acres

5159 West Kemper Road, Cincinnati, OH 45252

$414,900 | 6067 Day Road, Cincinnati, OH 45252
1/46
Virtual Tour

$414,900

4
Bedrooms
2,405
Square Feet
1.65
Acres

6067 Day Road, Cincinnati, OH 45252

$329,900 | 4498 Day Road, Cincinnati, OH 45252
1/34
Virtual Tour

$329,900

3
Bedrooms
2,080
Square Feet
0.70
Acres

4498 Day Road, Cincinnati, OH 45252

$169,200 | 4240 Endeavor Drive, Unit 103, Cincinnati, OH 45252
1/28
Listed By Coldwell Banker Realty

$169,200

2
Bedrooms
1,238
Square Feet

4240 Endeavor Drive, Unit 103, Cincinnati, OH 45252

$300,000 | 4327 Courageous Circle, Cincinnati, OH 45252
1/33

$300,000

3
Bedrooms
2,346
Square Feet

4327 Courageous Circle, Cincinnati, OH 45252

$169,900 | 9940 Regatta Drive, Unit 302, Cincinnati, OH 45252
1/36

$169,900

2
Bedrooms
1,232
Square Feet

9940 Regatta Drive, Unit 302, Cincinnati, OH 45252

$169,000 | 4220 Endeavor Drive, Unit 101, Cincinnati, OH 45252
1/28
Virtual Tour

$169,000

2
Bedrooms
1,109
Square Feet

4220 Endeavor Drive, Unit 101, Cincinnati, OH 45252

Nearby home values

AddressSold priceBedsBathsSqftLot (Sqft)
This home: 9551 Brehm Road, Cincinnati, OH 45252
$245,000
4
2,628
315,374
5840 Orchard Hills Lane, Cincinnati, OH 45252
$140,000
3
3
2,564
262,362
5850 Orchard Hills Lane, Cincinnati, OH 45252
$145,000
4
4,685
171,931
5810 Orchard Hills Lane, Cincinnati, OH 45252
$159,500
4
4,395
236,444
9549 Brehm Road, Cincinnati, OH 45252
–
–
–
–
67,954
9571 Brehm Road, Cincinnati, OH 45252
–
3
2,324
60,418

Explore Nearby Homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Coldwell Banker West Shell

The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc.. Those listings held by brokerage firms other than Compass and its related brokerages, are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. Compass and its related brokerages, does not display the entire Cincinnati MLS Broker Reciprocity™ database on this web site. The listings of some real estate brokerage firms have been excluded. Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved