Last Sold Price
4 beds1,818 sqft$149/sqft
9438 Brehm Road, Cincinnati, OH 45252

Description

Custom built home with private drive! Entertain in open concept floor plan w/ vaulted ceilings. Retreat to lrg master bed w/ adj bathroom boasting whirlpool tub, dbl vanity & private toilet. On LL, enjoy accessibility to second kitchen incl appliances. Relax on back deck overlooking private yard & nature. Close to HWY, restaurants, stores & schoolsCustom built home with private drive! Entertain in open concept floor plan w/ vaulted ceilings. Retreat to lrg master bed w/ adj bathroom boasting whirlpool tub, dbl vanity & private toilet. On LL, enjoy accessibility to second kitchen incl appliances. Relax on back deck overlooking private yard & nature. Close to HWY, restaurants, stores & schools
LISTING CLOSED: 04/20/2018 12:00 AM

  1. Listed by James C Harris • Brokerage DRE #2017003224 • Keller Williams Seven Hills Re
    P: (513)-509-1888 james@asktcg.com
  2. Listed by Peter D Chabris • Keller Williams Seven Hills Re

Property Details for 9438 Brehm Road

Status
MLS #
1561884
Days on Market
80
Taxes
$3,891 / year
HOA Fees
-
Condo/Co-op Fees
-
Property Type
MLS Type
Residential / Single Family Residence
Year Built
1997
Lot Size
1.93 AC / 84,071 SF
Architectural Style
Ranch
View
City, Woods
Zoning
Residential
Zoning Details
Residential

Location

Listing Courtesy of Keller Williams Seven Hills Re

Sold By RE/MAX Victory + Affiliates

Add your commute

Building Information for 9438 Brehm Road

Stories-Year Built1997Building Size-Lot Size1.93 AC / 84,071 SF

Payment Calculator

$1,697 per month

30 year fixed, 6.55% Interest

Principal and Interest

$1,372

Property Taxes

$324

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 9438 Brehm Road

Summary
Location and General Information
  • MLS Area Major: Hamilton-W10
  • Access: Private Drive
  • Area Short Name: W10
  • Cross Street: Orchard Hills
  • Directions: Springdale to Brehm Rd., Private Drive
  • FIPS Code: 61
  • Latitude: 39.245716
  • Longitude: -84.631126
  • Census Tract: 205.02
Taxes and HOA
  • Has Association: No
  • Parcel Number: 510-0240-0204-00
  • Semi Annual Taxes: 1, 945.54
  • Tax Abatement: No
School Information
  • High School District: Northwest Local SD
  • School Name 1: Call SD 513-825-4600
  • School Type 1: District Phone
Parking
  • Garage Carport: Front, Garage Attached, Oversized
  • Garage Spaces: 2.0
  • Parking Features: Driveway
Property
Lot Information
  • Land Description: 1 to 4.9 Acres
  • Lot Area: 84071.0
  • Lot Size Acres: 1.93
  • Lot Size Dimensions: 1.93 Acres
  • Lot Size Square Feet: 84071.0
  • Lot Size Units: Acres
  • Miscellaneous: 220 Volt, Cable, Ceiling Fan, Smoke Alarm
Property and Assessments
  • Living Area: 1818.0
  • 3rd Party Approval Required: No
  • Above Grade Sq Ft: 1818
  • Assessment Amount: Of Record
  • Has Board Loaded: No
  • Complete Renovation: No
  • New Construction: No
  • Single Family Description: Single Family
  • Validated: Yes
  • Year Built: 1997
Building Features
  • Foundation Details: Poured
  • Levels: One
  • Entry: 7x9 Level: 1
  • Entry Area: 63
  • Entry Dimensions: 7 x 9
  • Entry Length: 7
  • Entry Width: 9
  • Has Additional Dwelling Unit: No
  • Lifestyle Community: Walk/Run Paths
  • Buildings: Shed
  • Construction Materials: Brick, Vinyl Siding
Utilities
  • Sewer: Public Sewer
  • Water Source: Public
  • Mechanical Systems: Garage Door Opener, Humidifier, Security System
Interior and Exterior Features
Exterior Features
  • Exterior Features: Cul de sac, Deck, Patio, Other
  • Roof: Shingle
Interior Features
  • Appliances: Dishwasher, Electric Cooktop, Garbage Disposal, Microwave, Oven/Range, Refrigerator
  • Basement: Full
  • Basement Features: Finished, Fireplace, Walkout, WW Carpet, Other
  • Bathroom1: Full
  • Bathroom1 Level: 1
  • Bathroom2: Full
  • Bathroom2 Level: 1
  • Bathroom3: Full
  • Bathroom3 Level: Lower
  • Bath Level1 Type: Full
  • Bathroom Level: Yes
  • Bathrooms: 3.0
  • Bathrooms Display: 3 (3 0)
  • Bathrooms Full: 3
  • Bedroom Level1: Yes
  • Bedrooms Total: 4
  • Basement Sq Ft: 1818
  • Cooling: Central Air
  • Entry Foyer: Closet
  • Fireplace Features: Electric, Wood
  • Fireplaces Total: 1
  • Heating: Electric, Heat Pump
  • Interior Features: 9Ft + Ceiling, Multi Panel Doors, Vaulted Ceiling, Other
  • Primary Bathroom: Built-In Shower Seat, Double Vanity, Shower, Tile Floor, Jetted Tub, Window Treatment, Other
  • Rooms Total: 12
  • Study Features: Window Treatment, Wall-to-Wall Carpet, Other
  • Water Heating: Electric
  • Window Features: Bay/Bow, Double Hung, Insulated, Picture, Slider, Vinyl
Room Information
Bedroom
  • Bedroom Width: 13
  • Primary Bed Feature: Bath Adjoins, Vaulted Ceiling, Window Treatment, Wall-to-Wall Carpet
  • Primary Bedroom: 13x17 Level: 1
  • Primary Bedroom Area: 221
  • Primary Bedroom Dimensions: 13 x 17
  • Primary Bedroom Length: 13
  • Primary Bedroom Width: 17
  • Bedroom 2: 12x13 Level: 1
  • Bedroom 2 Area: 156
  • Bedroom 2 Dimensions: 12 x 13
  • Bedroom 2 Length: 12
  • Bedroom 3: 12x13 Level: 1
  • Bedroom 3 Area: 156
  • Bedroom 3 Dimensions: 12 x 13
  • Bedroom 3 Length: 12
  • Bedroom 3 Width: 13
  • Bedroom 4: 11x11 Level: Lower
  • Bedroom 4 Area: 121
  • Bedroom 4 Dimensions: 11 x 11
  • Bedroom 4 Length: 11
  • Bedroom 4 Width: 11
  • Bedroom 5: 10x12 Level: Lower
  • Bedroom 5 Area: 120
  • Bedroom 5 Dimensions: 10 x 12
  • Bedroom 5 Length: 10
  • Bedroom 5 Width: 12
Breakfast Room
  • Breakfast Room: 9x12 Level: 1
  • Breakfast Room Area: 108
  • Breakfast Room Dimensions: 9 x 12
  • Breakfast Room Length: 9
  • Breakfast Room Width: 12
Dining Room
  • Dining Room: 11x13 Level: 1
  • Dining Room Area: 143
  • Dining Room Dimensions: 11 x 13
  • Dining Room Feat: Chandelier, Wood Floor, Other
  • Dining Room Length: 11
  • Dining Room Width: 13
  • Formal Dining Room: Yes
Family Room
  • Family Room: 13x14 Level: Lower
  • Family Room Area: 182
  • Family Room Dimensions: 13 x 14
  • Family Room Feat: Fireplace, Walkout, Wall-to-Wall Carpet
  • Family Room Length: 13
  • Family Room Width: 14
Kitchen
  • Kitchen Area: 144
  • Kitchen Dimensions: 12 x 12
  • Kitchen Features: Island, Pantry, Solid Surface Ctr, Wood Floor, Other
  • Kitchen Length: 12
  • Kitchen Width: 12
Laundry Room
  • Laundry Room: 6x9 Level: 1
  • Laundry Room Area: 54
  • Laundry Room Dimensions: 6 x 9
  • Laundry Room Length: 6
  • Laundry Room Width: 9
Living Room
  • Living Great Room Area: 320
  • Living Great Room Dimensions: 16 x 20
  • Living Great Room Length: 16
  • Living Great Room Width: 20
  • Living Room: 16x20 Level: 1
  • Living Room Feat: Fireplace, Walkout, Window Treatment, Wall-to-Wall Carpet, Other
Additional Room Information
  • Recreation Room: 15x22 Level: Lower
  • Recreation Room Area: 330
  • Recreation Room Dimensions: 15 x 22
  • Recreation Room Length: 15
  • Recreation Room Width: 22
  • Study/Library Den: 12x18 Level: Lower
  • Study/Library Den Area: 216
  • Study/Library Den Dimensions: 12 x 18
  • Study/Library Den Length: 12
  • Study/Library Den Width: 18
Rental
Rent Information
  • Occupancy: Negotiable
  • Has Lease Considered: No
  • Sub Lease: No

Property History for 9438 Brehm Road

DateEvent & SourcePriceAppreciation
Apr 20, 2018

Sold (Public Record)

Public Record #629226377

$270,000
Apr 20, 2018

Sold

MLS of Greater Cincinnati #1561884

$270,000
Dec 7, 2017

Listed (Active)

MLS of Greater Cincinnati #1561884

$279,900
DateEvent & SourcePrice
04/20/2018

Sold (Public Record)

Public Record #629226377

$270,000
04/20/2018

Sold

MLS of Greater Cincinnati #1561884

$270,000
12/07/2017

Listed (Active)

MLS of Greater Cincinnati #1561884

$279,900

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

Public Records for 9438 Brehm Road

Taxable ValueLand$24,605Additions$81,144Total$105,749
Tax Record2025$6,101 ($508 / month)
Home Facts
Beds3Baths2Total Finished SqFt1,818 SqFtAbove Grade Finished SqFt1,818 SqFtStories1Lot Size84,071 SqFtStyleSingle Family ResidenceYear Built1997Year Renovated1997CountyHAMILTONAPN510-0240-0204-00

Schools near 9438 Brehm Road

This home is within Northwest Local School District.
Rating
School
Type
Grades
Distance
Public - K to 5
Public - 6 to 8
Public - 9 to 12
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

$175,000 | 9940 Regatta Drive, Unit 302, Cincinnati, OH 45252
1/36

$175,000

2
Bedrooms
1,232
Square Feet
$169,000 | 4220 Endeavor Drive, Unit 101, Cincinnati, OH 45252
1/28
Virtual Tour

$169,000

2
Bedrooms
1,109
Square Feet
$385,000 | 10811 Colerain Avenue, Cincinnati, OH 45252
1/39

$385,000

3
Bedrooms
1,982
Square Feet
0.75
Acres
$155,000 | 9800 Regatta Drive, Unit 101, Cincinnati, OH 45252
1/28

$155,000

2
Bedrooms
1,109
Square Feet
$167,500 | 9860 Regatta Drive, Unit 305, Cincinnati, OH 45252
1/27
Listed By Coldwell Banker Realty

$167,500

2
Bedrooms
1,109
Square Feet
$175,900 | 9805 Regatta Drive, Unit 301, Cincinnati, OH 45252
1/20

$175,900

2
Bedrooms
1,164
Square Feet
$625,000 | 10960 Gosling Road, Cincinnati, OH 45252
1/37

$625,000

2
Bedrooms
2,242
Square Feet
6.94
Acres
$159,900 | 4281 Defender Drive, Unit 104, Cincinnati, OH 45252
1/26

$159,900

2
Bedrooms
1,109
Square Feet
$150,000 | 5250 Yeatman Road, Cincinnati, OH 45252
1/29

$150,000

3
Bedrooms
1,344
Square Feet
1.31
Acres

Nearby home values

AddressSold priceBedsBathsSqftLot (Sqft)
This home: 9438 Brehm Road, Cincinnati, OH 45252
$270,000
4
1,818
84,071
$226,500
3
2,179
43,560
3
2,260
43,647
$75,000
90,648
$350,000
3
2,064
43,734
3
1
1,988
123,493

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 Keller Williams Seven Hills Re

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