30
$450,000
4 bd · 3 ba · 2,272 sqft
8577 Noelle Drive, Colerain Twp, OH
Misha L Houston · RE/MAX Preferred Group
Est. $4,053/mo$361/sqft · 13 days on Realty
4
Beds
2
Baths
1,732
Sqft
1920
Built
Off the grid right in the city. An awesome urban agricultural oasis. A money-making mini-farm consisting of 2 Homes, 5 buildings, more than 3 Acres. 70 fruit tree Orchard. Solar. Geothermal, Generator and a well. 2912 Compton Rd - The Farmhouse A 1,732-square-foot residence, benefitting from substantial creative investment in the house itself and in energy efficiency, resilience, sustainability and productive use of the land, including established blueberry, raspberry, blackberry, asparagus and rhubarb beds, extensive perennial food plantings, and a coppiced willow hedge, The home features an updated bathroom and kitchen with granite and slate countertops. Hybrid combo electric and gas stove 2956 Compton Rd.: The Elderberry Lodge. The adjoining 1.1-acre property is a completely separate residence, now a successful Air B&B providing instant income of over $25K More than the sum of it's parts. A rare opportunity. Nourishing - Self-Sustaining - Unique COME LOOK - MAKE OFFER
Listing agent
Mark Miller
Courtesy of OwnerLand Realty, Inc.
mark@cincyland.com
MLS of Greater Cincinnati (CincyMLS) · Listing 1899403
$125,000
Estimated monthly payment
$4,053/mo
Loan amount $500,000. Estimate only — your actual rate and payment depend on credit, location, and lender.
2025 roll
School ratings (A+ to F) from HJN community data.
Houston Educational Service and Early Childhood Center
PK-PK · Regular · Northwest Local School District
227 students · 25.2:1 student–teacher
Taylor Elementary School
KG-5 · Regular · Northwest Local School District
797 students · 18.1:1 student–teacher
Heaven's Treasures Academy
PK-5 · Regular
33 students · 16.5:1 student–teacher
Our Lady of Grace Catholic School
KG-8 · Regular
400 students · 18.2:1 student–teacher
Colerain High School
9-12 · Regular · Northwest Local School District
1,591 students · 22.5:1 student–teacher
Mount Healthy South Elementary School
1-6 · Regular · Mount Healthy City School District
604 students · 25.2:1 student–teacher
Mount Healthy High School
9-12 · Regular · Mount Healthy City School District
865 students · 24.7:1 student–teacher
Mount Healthy Junior High School
7-8 · Regular · Mount Healthy City School District
407 students · 19.4:1 student–teacher
MLS of Greater Cincinnati (CincyMLS)This content last refreshed on 2026-11-18 22:23:42 UTC. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.
30
$450,000
4 bd · 3 ba · 2,272 sqft
8577 Noelle Drive, Colerain Twp, OH
Misha L Houston · RE/MAX Preferred Group
Price Reduced49$488,800
5 bd · 4 ba · 2,918 sqft
5391 Stonetrace Drive, Colerain Twp, OH
Mika M Walker · Coldwell Banker Realty
57$525,000
4 bd · 4 ba · 3,480 sqft
2860 Pearse Street, Colerain Twp, OH
Bryan J Smith · eXp Realty


Rings at ½ mile and 1 mile. Basemap © OpenMapTiles © OpenStreetMap contributors.
2 license-plate readers mapped within ½ mile of this home, both identified as Flock Safety devices. Nearest: 0.2 mi southeast.
| Device type | Within ½ mi | Within 1 mi |
|---|---|---|
| License-plate readers | 2 | 5 |
| of which Flock Safety | 2 | 5 |
Community-reported via OpenStreetMap; may be incomplete. Data as of . © OpenStreetMap contributors (ODbL)
License-plate readers (ALPR) are fixed cameras that photograph passing vehicles and read their plates. Records are typically shared with the agency or association that operates the camera.
Flock Safety is a company whose plate-reader cameras are used by police departments, cities, HOAs and businesses. Its devices are usually solar-powered and pole-mounted.
Within 2 miles of this home: 38+ restaurants and cafés, 7 grocery stores, 17 parks and green spaces, and 31+ transit stops.
Place data from OpenStreetMap.
Starbucks
Colerain Avenue
Waffle House
American restaurant
Subway
Colerain Avenue
Penn Station
Fusabowl
Asian restaurant
Wingstop
Colerain Avenue
Graeter's
Charleys Philly Steaks
ALDI
Colerain Avenue
Walmart Supercenter
Colerain Avenue
Kroger
Springdale Road
Family Groceries
Meijer
Stone Creek Boulevard
La Canasta
Kroger Food & Drug
Hamilton Avenue
Farbach-Werner Nature Preserve
Poole Road
Skyline Park
Northbrook Civic Association Playfield
Civic Association Playfields
Brickyard Pond
Reagan Highway Wetlands
Wert Park
Forest Avenue Wetland Park
Colerain Ave & Poole Rd
Colerain Ave & Round Top Rd
Colerain Ave & Sunnyside Dr
8800 Colerain Ave
9336 Colerain Ave
9343 Colerain Ave
Colerain Ave & Joseph Rd
Colerain Rd & Sovereign Dr