






















































Listing Information | |
---|---|
Price | $2,595,000 |
Listing Number | 1765294 |
Driving Directions |
---|
Beechmont to Asbury to Ayers; home is on private drive. |
View Property on Map

Agent Remarks |
---|
Spectacular & pristine custom built home sited on over 2 verdant acres in exclusive Riverview Estates of Coldstream*Over 7600 SF of high-end one floor living w/exceptional craftsmanship at every turn*Impeccably appointed w/only the finest fit/finish*Soaring tray ceilings w/custom millwork*Thoughtfully designed open flrplan*1st fl primary ste w/lux BA + custom walk-in*Gourmet KIT open to fam rm*Great rm w/fab wet bar*Sprawling fin LL*Attached 3-car GAR*2 Trex decks*Luxury living at its finest. |
General Information | |
---|---|
Property Type | Residential |
Style | Single Family |
County | Hamilton |
Subdivision | Anderson Twp |
Zip Code | 45255 |
School District | Forest Hills Local S |
Listing Number | 1765294 |
Bedroom Information | ||
---|---|---|
Beds | 4 | |
Master Bedroom | 22 x 16 | L: 1 |
Bedroom 2 | 19 x 15 | L: 1 |
Bedroom 3 | 21 x 13 | L: Lower |
Bedroom 4 | 16 x 15 | L: Lower |
Bathroom Information | ||
---|---|---|
Baths | 3.2 | |
Bath 1 | Full | L: 1 |
Bath 2 | Full | L: 1 |
Bath 3 | Partial | L: 1 |
Bath 4 | Full | L: Lower |
Property Features | |
---|---|
Basement | Full |
Garage | Attached, Side, Oversized, Heated |
Cars | 3 |
Parking | Driveway |
Windows | Wood, Insulated, Picture, Casement, Double Pane |
Heating | Gas, Forced Air, Program Thermostat, Zoned |
Cooling | Central Air, Ceiling Fans |
Fireplace | Marble, Gas, Stone |
Additional Information | |
---|---|
Levels | 1 Story |
Construction | Brick, Stone |
Architecture | Ranch, Transitional |
Lot Dimensions | 170 x 519 |
Gas | Natural |
Water | Public |
Sewer | Public |
Foundation | Poured |
Occupancy | Negotiable |
Semi-Annual Taxes | $26,543.49 |
Room Information | ||
---|---|---|
Rooms | 12 | |
Entry | 12 x 10 | L: |
Dining | 25 x 14 | L: 1 |
Kitchen | 32 x 23 | L: 1 |
Family | 20 x 20 | L: 1 |
Great Room | 29 x 19 | L: 1 |
Recreation Room | 57 x 17 | L: Lower |
Study | 20 x 14 | L: 1 |
Laundry | 12 x 8 | L: 1 |
Additional Features | |
---|---|
Master Bedroom Info | Wall-to-Wall Carpet, Other, Bath Adjoins, Walk-in Closet, Window Treatment |
Master Bath Info | Marb/Gran/Slat, Double Vanity, Shower, Tub, Ceramic Tile, Built-In Shower Seat, Double Shower |
Basement Details | Concrete Floor, Part Finished, Walkout, Fireplace, WW Carpet |
Entry Features | Double Doors, Transom/Sidelit, Other, Wood Floors, Open Foyer |
Dining Room Features | Other, Wood Floors, Chandelier, Window Treatments |
Kitchen Features | Pantry, Wood Cabinets, Window Treatment, Marble/Granite/Slate, Wood Floor, Eat-In, Gourmet, Island, Counter Bar |
Family Room Features | Wall-to-Wall Carpet, Walkout, Fireplace, Window Treatment |
Great Room Features | Fireplace, Other, Wood Floor, Walkout, Wet Bar |
Appliances | Other, Dishwasher, Refrigerator, Microwave, Garbage Disposal, Gas Cooktop, Double Oven, Convection Oven, Wine Cooler |
Other Features | Ceiling Fan, 220 Volt, Cable TV, Smoke Alarm, Recess Lights |
HOA Fee - Annual | $1,000.00 |
Request more info about this property:
This listing courtesy of Bob Dorger (513-518-8080), Comey & Shepherd (513-561-5800). All Information is believed accurate, but is NOT guaranteed.

The data relating to the real estate for sale on this web site comes
in part from the Broker Reciprocity program of the MLS of Greater
Cincinnati, Inc. Real estate listings held by brokerage firms other
than Cincinnati Condo Connection are marked with the Broker Reciprocity logo
or Broker Reciprocity house icon. The properties displayed may not be
all the properties available through Broker Reciprocity.