Save
Ask
Tour
Hide
$129,900
127 Days On Site
5970 Colerain Avenue 20Green Twp, OH 45239
For Sale|Condominium|Active
2
Beds
2
Total Baths
2
Full Baths
870
SqFt
$149
/SqFt
2001
Built
County:
Hamilton
Listing courtesy of Bobbie Bean of Eurie Realty
Call Now: 513-600-8844
Is this the listing for you? We can help make it yours.
513-600-8844
Save
Ask
Tour
Hide
Mortgage Calculator
Monthly Payment (Est.)
$593Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.
Immaculate 2-Bed, 2-Bath Condo in Hidden Lagoon - Turnkey Investment or Dream Home Step into luxury with this beautifully remodeled (2022) 2-bedroom, 2 full-bath condo in the sought-after Hidden Lagoon Condominiums. Currently operating as a successful short-term rental, this property offers an excellent investment opportunity or a stunning primary residence. Centrally located with easy access to everything, it features a spacious primary ensuite, abundant natural light, and a private balcony, perfect for relaxing or entertaining. With nothing left to do but move in or start earning, this is the perfect blend of comfort and convenience.
Save
Ask
Tour
Hide
Listing Snapshot
Price
$129,900
Days On Site
127 Days
Bedrooms
2
Inside Area (SqFt)
870 sqft
Total Baths
2
Full Baths
2
Partial Baths
N/A
Lot Size
N/A
Year Built
2001
MLS® Number
1855508
Status
Active
Property Tax
N/A
HOA/Condo/Coop Fees
$295
Sq Ft Source
N/A
Friends & Family
Recent Activity
| 4 months ago | Listing updated with changes from the MLS® | |
| 4 months ago | Listing first seen on site |
General Features
Levels
OneThree Or More
Number Of Stories
3
Parking
Off Street
Property Sub Type
Condominium
Sewer
Public Sewer
Style
Traditional
Utilities
Natural Gas Available
Water Source
Public
Zoning
Residential
Interior Features
Appliances
RangeOvenGas Water HeaterDishwasherMicrowaveRefrigerator
Basement
None
Cooling
Central Air
Heating
Forced Air
Interior
Walk-In Closet(s)
Bathroom 1
Level - First
Bathroom 2
Level - First
Bedroom 2
Dimensions - 12 x 9Level - FirstArea - 108
Dining Room
Dimensions - 9 x 8Level - FirstArea - 72
Kitchen
Dimensions - 9 x 7Area - 63
LaundryRoom
Level - First
Living Room
Dimensions - 16 x 13Area - 208
Master Bedroom
Dimensions - 14 x 14Level - FirstArea - 196
Save
Ask
Tour
Hide
Exterior Features
Construction Details
BrickWood Siding
Exterior
Balcony
Roof
Shingle
Community Features
Association Dues
295
MLS Area
Hamilton-W08
School District
Northwest Local SD
Schools
School District
Northwest Local SD
Elementary School
Unknown
Middle School
Unknown
High School
Unknown
Listing courtesy of Bobbie Bean of Eurie Realty
Listing information is provided by Participants of the Cincy MLS. 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. Copyright 2026, Cincy MLS.
Last checked: 2026-01-22 10:05 PM UTC
Listing information is provided by Participants of the Cincy MLS. 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. Copyright 2026, Cincy MLS.
Last checked: 2026-01-22 10:05 PM UTC
Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Did you know? You can invite friends and family to your search. They can join your search, rate and discuss listings with you.