Horan Rosenhagen Real Estate
  • Home
  • Buy
    1. All Listings
    2. Featured Listings
  • Sell
    1. Sell My Home
    2. Home Valuation
    3. Recent Sold
  • Rent
    1. Rental Listings
  • About
    1. Our Team
    2. About Us
    3. Contact Us
    4. Reviews
  • Market Snapshot
  • Register
  • /
  • Sign In
Price
  • Any
  • $ 100,000
  • $ 150,000
  • $ 200,000
  • $ 400,000
  • $ 800,000
  • Any
  • $ 200,000
  • $ 300,000
  • $ 400,000
  • $ 600,000
  • $ 1,000,000
    Beds Tap two numbers to select a range
    Any
    1
    2
    3
    4
    5+
    Baths Tap two numbers to select a range
    Any
    1
    2
    3
    4
    5+
  • List
  • Mixed
  • Map
ZIP Code: 45247
Virtual Tour
Map
18 Properties Available

18 Properties Available

  • Default
  • Price-High To Low
  • Price-Low To High
  • Newest Listings
  • Beds (Most)
  • Baths (Most)
  • Year Built (Newest)
  • Square Feet (Biggest)
7605 Sun Ridge Ln, Colerain Twp, OH 45247
1/44
Coming Soon

$410,000

3 Beds2 Baths1,761 SqFt

7605 Sun Ridge Ln, Colerain Twp, OH 45247

Listed by ERA REAL Solutions Realty. LLC

Cincinnati MLS (CincyMLS)
6297 Daleview Rd, Colerain Twp, OH 45247
1/63
Coming Soon

$799,000

4 Beds6 Baths4,164 SqFt

6297 Daleview Rd, Colerain Twp, OH 45247

Listed by Sibcy Cline, Inc.

Cincinnati MLS (CincyMLS)
5528 Whispering Way, Green Twp, OH 45247
1/83
Pending

$375,000

3 Beds3 Baths2,886 SqFt

5528 Whispering Way, Green Twp, OH 45247

Listed by eXp Realty

Cincinnati MLS (CincyMLS)
6525 Schweitzerhoff Rd, Green Twp, OH 45247
1/55
Active

$335,000

4 Beds2 Baths2,516 SqFt

6525 Schweitzerhoff Rd, Green Twp, OH 45247

Listed by Coldwell Banker Realty

Cincinnati MLS (CincyMLS)
8092 Redhaven Ct, Colerain Twp, OH 45247
1/51
Pending

$285,000

3 Beds2 Baths1,127 SqFt

8092 Redhaven Ct, Colerain Twp, OH 45247

Listed by Huff Realty

Cincinnati MLS (CincyMLS)
7226 Creekview Dr #12, Colerain Twp, OH 45247
1/19
Active
3D

$123,900

2 Beds2 Baths880 SqFt

7226 Creekview Dr #12, Colerain Twp, OH 45247

Listed by eXp Realty

Cincinnati MLS (CincyMLS)
6134 Blue Lake Dr, Green Twp, OH 45247
1/39
Pending

$259,900

3 Beds2 Baths1,426 SqFt

6134 Blue Lake Dr, Green Twp, OH 45247

Listed by Sibcy Cline, Inc.

Cincinnati MLS (CincyMLS)
3678 Paramount Ridge Ln, Green Twp, OH 45247
1/48
Price Dropped by $10K

$240,000

4 Beds1 Bath1,231 SqFt

3678 Paramount Ridge Ln, Green Twp, OH 45247

Listed by Key Realty, LTD.

Cincinnati MLS (CincyMLS)
5460 Lakefront Dr, Green Twp, OH 45247
1/61
Pending
3D

$434,900

3 Beds3 Baths2,180 SqFt

5460 Lakefront Dr, Green Twp, OH 45247

Listed by Hoeting, REALTORS

Cincinnati MLS (CincyMLS)
5323 North Bend Crossing, Green Twp, OH 45247
1/26
Pending

$219,900

2 Beds2 Baths1,263 SqFt

5323 North Bend Crossing, Green Twp, OH 45247

Listed by Comey & Shepherd

Cincinnati MLS (CincyMLS)
8356 Ashhollow Dr, Colerain Twp, OH 45247
1/30
Price Dropped by $15K

$344,900

4 Beds4 Baths1,989 SqFt

8356 Ashhollow Dr, Colerain Twp, OH 45247

Listed by Lohmiller Real Estate

Cincinnati MLS (CincyMLS)
5770 Haubner Rd, Green Twp, OH 45247
1/71
Pending

$332,500

3 Beds2 Baths1,552 SqFt

5770 Haubner Rd, Green Twp, OH 45247

Listed by Keller Williams Advisors

Cincinnati MLS (CincyMLS)
7412 Hunters Creek Ln, Colerain Twp, OH 45247
1/52
Price Dropped by $25K
3D

$350,000

3 Beds3 Baths2,426 SqFt

7412 Hunters Creek Ln, Colerain Twp, OH 45247

Listed by Keller Williams Seven Hills Re

Cincinnati MLS (CincyMLS)
6976 Aspen Point Ct, Green Twp, OH 45247
1/32
Price Dropped by $19K

$320,000

3 Beds3 Baths1,776 SqFt

6976 Aspen Point Ct, Green Twp, OH 45247

Listed by Coldwell Banker Realty

Cincinnati MLS (CincyMLS)
6594 Springdale Rd, Colerain Twp, OH 45247
1/57
Price Dropped by $5K

$519,999

4 Beds3 Baths2,997 SqFt

6594 Springdale Rd, Colerain Twp, OH 45247

Listed by eXp Realty

Cincinnati MLS (CincyMLS)
6046 Gaines Rd, Green Twp, OH 45247
1/79
Pending

$499,500

5 Beds4 Baths3,661 SqFt

6046 Gaines Rd, Green Twp, OH 45247

Listed by Comey & Shepherd

Cincinnati MLS (CincyMLS)
4576 Runningfawn Dr, Green Twp, OH 45247
1/56
Price Dropped by $20K

$420,000

4 Beds4 Baths2,228 SqFt

4576 Runningfawn Dr, Green Twp, OH 45247

Listed by Coldwell Banker Realty

Cincinnati MLS (CincyMLS)
5225 Ivy Rose Ln, Green Twp, OH 45247
1/33
Price Dropped by $10K
3D

$729,900

4 Beds4 Baths3,138 SqFt

5225 Ivy Rose Ln, Green Twp, OH 45247

Listed by HMS Real Estate

Cincinnati MLS (CincyMLS)
  • 1

explore listings

  • Open House
  • Price Reduced
  • Virtual Tour
  • 3D Tour
default
  • Home
  • Rent
    1. Rental Listings
  • Buy
    1. All Listings
    2. Featured Listings
  • About
    1. Our Team
    2. About Us
    3. Contact Us
    4. Reviews
  • Sell
    1. Sell My Home
    2. Home Valuation
    3. Recent Sold
  • Market Snapshot
Horan Rosenhagen Real Estate
Horan Rosenhagen

+1(859) 415-4477 admin@horanrosenhagen.com

920 Monmouth St, Newport, KY 41071

Get My App

Powered by Lofty Inc. Copyright 2026. All Rights Reserved.

Terms of Service & Privacy Policy | Cookie Policy | Cookie Preferences | Property Listings | Sitemap | Accessibility

IDX information is provided exclusively for consumers’ personal, non-commercial use and that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed to be accurate. Listing information updated daily.
default
  • Home
  • Rent
    1. Rental Listings
  • Buy
    1. All Listings
    2. Featured Listings
  • About
    1. Our Team
    2. About Us
    3. Contact Us
    4. Reviews
  • Sell
    1. Sell My Home
    2. Home Valuation
    3. Recent Sold
  • Market Snapshot
Horan Rosenhagen Real Estate
Horan Rosenhagen

+1(859) 415-4477 admin@horanrosenhagen.com

920 Monmouth St, Newport, KY 41071

Get My App

Powered by Lofty Inc. Copyright 2026. All Rights Reserved.

Terms of Service & Privacy Policy | Cookie Policy | Cookie Preferences | Property Listings | Sitemap | Accessibility

IDX information is provided exclusively for consumers’ personal, non-commercial use and that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed to be accurate. Listing information updated daily.