













































Property Attributes
- MLS#1651720
- TypeSingle Family
- CountyHAMILTON
- CityAnderson Twp
- AreaAnderson Twp.
- NeighborhoodRiverview Estates at Coldstream CC
- Zip45255
- StyleTraditional,Transitional
- Price$ 2,195,000
- Bedrooms5
- Full Bathrooms5
- Half Bathrooms1
- Lot Size1.08 Acres
Listing Provided Courtesy Of:
Ralph Fruechtemeyer with Zicka Realty Co. - 513-677-3435
Data Source:
MLS of Greater Cincinnati, Inc.
Property Description
Zicka Homes presents our newest custom home! Elegant manor house style welcomes a bright and openly flowing interior. Open concept includes Great Room, gourmet Kitchen with huge pantry and dining area that exits to a covered deck. 1st floor Master suite. Finished LL / 4 bedrooms upstairs each with bath & walk-in closets.
Price History | |
---|---|
2/14/2020 | Listed $2,250,000 |
9/16/2020 | 3% - $2,195,000 |
General Features
Appliances | Dishwasher, Double Oven, Garbage Disposal, Gas Cooktop, Microwave |
---|---|
Architectural Style | Traditional, Transitional |
Association Y/N | Yes |
Auction | No |
Builder | Zicka Homes |
Carport Spaces | 0.0 |
City | Anderson Twp |
Close Price | 0.0 |
Construction Materials | Brick, Stone |
Cooling | Central Air |
County | Hamilton |
Days on Market | 427 |
Directions | Beechmont Ave to South on Asbury, Past Coldstream Country Club to Left on Ayers at Stop Sign, Left on Coldstream Club Dr. |
Exterior Features | Covered Deck/Patio |
Garage Spaces | 4.0 |
Gas Y/N | Natural |
HOA Fee | 800.0 |
HOA Fee Frequency | Annually |
Heating | Gas |
High School District | Forest Hills Local S |
Interior Features | 9Ft + Ceiling, French Doors, Multi Panel Doors |
Lease Considered Y/N | Yes |
Levels | Two |
MLS Area | Hamilton-E07 |
Miscellaneous | Smoke Alarm |
New Construction | Yes |
Occupancy | At Closing |
Price Per Square Foot | 0.0 |
Property SubType | Single Family Residence |
Property Type | Residential |
Roof | Shingle |
Sewer | Public Sewer |
Status | Active |
Street Name | Coldstream Club |
Subdivision Name | Riverview Estates at Coldstream CC |
Suburb | Anderson Twp. |
Total Rooms | 13 |
Township | Anderson |
Unit | 22 |
Validated | 1 |
Interior Features
Basement | Full |
---|---|
Basementfeat | Bath Rough-In, Finished, Walkout |
Bath1 | Partial |
Bath1level | 1 |
Bath2 | Full |
Bath2level | 1 |
Bath3 | Full |
Bath3level | 2 |
Bath4 | Full |
Bath4level | 2 |
Bathlvl1type | Full, Partial |
Bathroomlevel1 | Yes |
Bedroom 2 Area | 260 |
Bedroom 3 Area | 182 |
Bedroom2 | 20x13 Level: 2 |
Bedroom2dim | 20 x 13 |
Bedroom2len | 20 |
Bedroom2wid | 13 |
Bedroom3 | 13x14 Level: 2 |
Bedroom3dim | 13 x 14 |
Bedroom3len | 13 |
Bedroom3wid | 14 |
Bedroom4 | 16x15 Level: 2 |
Bedroom4area | 240 |
Bedroom4dim | 16 x 15 |
Bedroom4len | 16 |
Bedroom4wid | 15 |
Bedroom5 | 13x15 Level: 2 |
Bedroom5area | 195 |
Bedroom5dim | 13 x 15 |
Bedroom5len | 13 |
Bedroom5wid | 15 |
Bedroomlevel1 | Yes |
Dining Room | 14x21 Level: 1 |
Dining Room Area | 294 |
Dining Room Dimensions | 14 x 21 |
Diningroomfeat | Walkout |
Diningroomlen | 14 |
Diningroomwid | 21 |
Entry | 14x11 Level: 1 |
Entryfoyer | Double Doors, Open Foyer |
Entrylen | 14 |
Entrywid | 11 |
Fireplace Features | Gas |
Full Baths | 5 |
Greatroom | 20x21 Level: 1 |
Half Baths | 1 |
Kitchen | 17x21 Level: 1 |
Kitchen Features | Gourmet, Island, Marble/Granite/Slate, Pantry |
Kitchenarea | 357 |
Kitchendim | 17 x 21 |
Kitchenlen | 17 |
Kitchenwid | 21 |
Laundryroom | 9x10 Level: 1 |
Laundryroomarea | 90 |
Laundryroomdim | 9 x 10 |
Laundryroomlen | 9 |
Laundryroomwid | 10 |
Living Area | 0.0 |
Master Bedroom | 20x19 Level: 1 |
Masterbathroom | Built-In Shower Seat, Double Vanity, Marb/Gran/Slate, Shower, Tub |
Masterbedfeat | Bath Adjoins, Walk-in Closet, WW Carpet |
Masterbedroomarea | 380 |
Masterbedroomdim | 20 x 19 |
Masterbedroomlen | 20 |
Masterbedroomwid | 19 |
Street Suffix | Drive |
Studyfeatures | French Doors |
Studylibden | 16x12 Level: 1 |
Studylibdenarea | 192 |
Studylibdendim | 16 x 12 |
Studylibdenlen | 16 |
Studylibdenwid | 12 |
Total Bedrooms | 5 |
Total Fireplaces | 1 |
Window Features | Insulated |
Exterior Features
Foundation Details | Poured |
---|---|
Garage/Carport | Garage Attached |
Landdescription | 1 to 4.9 Acres |
Lot Dimensions | 150 x 315 |
Lot Size Acres | 1.08 |
Lot Size Square Feet | 47045.0 |
Lot Size Units | Acres |
Water Source | Public |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Master On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool