Name: REMAX Affiliates
Address: 4895 Houston Road, Florence, KY, 41042
Telephone: 859-372-6000

KENTUCKY

offices & agents contact us member login home page

OHIO

Serving all of Northern Kentucky and Greater Cincinnati

search my home watch communities/schools national search homes around the globe about us careers

Legend:

New Listing

Open House

Virtual Tour

Under Contract

7934 Ayers Rd Anderson Twp OH 45255

Custom built 5 bedroom / 5+2 bath upper echelon home in exclusive Riverview Estates of Coldstream. Exceptional craftsmanship and detailed finishes throughout including artisan granite and marble and signature lighting. Gorgeously appointed formal areas. Luxury 1st floor master suite with spa bath. Solid wood study with stone fireplace. Gourmet kitchen with custom hand-made flush-fit wood cabinets and commercial grade Thermador appliances, open to hearth room with stone fireplace and custom built-ins. Spectacular finished lower level with exquisite wet bar, media room with stone fireplace and custom temperature and humidity controlled 1,500+ bottle octagonal wine cellar. Attached side-entry 4-car garage. Stamped concrete circle drive. Meticulously maintained with extensive improvements and upgrades throughout. A true natural beauty majestically sited on a handsomely landscaped 1.33 acre lot.

The elegant and inviting open foyer greets you with a double-door entry, stunning chandelier with additional recessed lighting, a spacious coat closet, and a gorgeous tile floor.

The formal dining room is gorgeously appointed with a recessed ceiling trimmed in crown molding, a beautiful chandelier, floor-to ceiling windows (trimmed with the perfect moulding and millwork), and marble tile floors. The dining room is conveniently open to the living room and adjacent to the first floor butler's pantry / wet bar in this practical open floor plan home.

The chic and spacious living room offers the perfect balance of elegance and comfort - boasting a striking coffered beam ceiling with recessed lighting, a wall of floor-to-ceiling windows with scallop accents and gorgeous mouldings, a handsome gas fireplace (one of four in this home) with beautiful mantle, built-in cabinetry with lighted shelving and gleaming wide-plank hardwood floors.

The incredible gourmet cook's kitchen caters to your every culinary whim - featuring a recessed ceiling with recessed and pendant lighting, custom handmade floor-to-ceiling flush-fit wood cabinetry, an artisan tile backsplash and dazzling granite countertops. The state-of-the-art commercial grade appliances include a 36" Thermador 6-burner gas range, Thermador double convection wall oven, Thermador built-in double-door refrigerator/freezer, Bosch built-in dishwasher, four (4) Jenn-Air refrigerated drawers and a Thermador wine cooler. A sizable island with counter-bar seating, spacious walk-in pantry, generous breakfast area and gleaming wide-plank hardwood floors round out this dream kitchen, which is thoughtfully open to a warm and welcoming hearth room.

The butler's pantry is both practical and beautiful and is centrally located adjoining the kitchen, dining and living rooms. Key features include a bar sink, custom ceiling-high cabinetry trimmed with crown molding, dazzling granite countertops and backsplash, a Thermador wine refrigerator, 2 refrigerated drawers, a Scotsman ice maker and built-in Bosch dishwasher.

The handsome hearth room / great room is spectacularly appointed with a striking coffered ceiling, recessed lighting, built-in entertainment center with cabinetry and lighted shelving, a floor-to-ceiling stone fireplace, wood floors with a dazzling marble inlay and walkout access to the rear patio.

The sophisticated study boasts a French door entry, coffered beam ceiling with recessed and chandelier lighting, distinguished solid wood panel walls with a wall of scalloped windows, floor-to-ceiling stone fireplace, wet bar and wall-to-wall carpet.

The luxurious yet comfortable first floor master suite is superbly appointed with a 14' octagon turret ceiling, recessed lighting, wall of windows, private walkout access to the rear terrace, ensuite coffee bar/wet bar, a fabulous spa-inspired ensuite bath, room-sized (16'x11') walk-in closet with custom organization and wall-to-wall carpet.

The heavenly ensuite master bath allows you to have a day at the spa right in your own home. Key features include a recessed ceiling, dual vanities with custom built-ins, a comfortable and well-lit dressing area, custom plantation shutter window treatments, an over-sized garden whirlpool tub, glass walk-in double shower with steam and built-in shower seat and heated tile floors.

The sizable 16x11 master closet will accommodate the wardrobe of a true fashioista and boasts custom shelving and cabinetry with a convenient island dresser.

The grand center staircase features intricate carved banisters with a generous landing and custom wrought-iron balusters.

The generously proportioned 36'x14' second floor loft area is the perfect flex space for a second home office or cozy den - featuring custom built-in dual desks and built-in cabinetry.

Bedroom #2 on the second floor (or an alternative 2nd floor master) boasts recessed lighting, a sizable walk-in closet with organization and ensuite bath.

The ensuite bath that adjoins bedroom #2 on the second floor features a floor-to-ceiling tile walk-in shower with glass doors, vanity with granite top and tile floor.

Overnight guests will feel right at home when visiting - all bedrooms feature ample recessed lighting, walk-in closets with organization and ensuite full baths.

This spectacular finished lower level is worthy of a champagne toast and has been fastidiously improved with upgrades aplenty, making this remarkable retreat an entertainer's delight. Key features include an exquisite fully-equipped pub-style wet bar with gorgeous granite top, U-line beverage fridge and ice maker and an adjacent custom-built temperature and humidity controlled 1,500-2,000 bottle wine cellar. The spacious media room with stone fireplace is open to a family room with custom built-in theater-style entertainment center and adjoining billiards area. A generously proportioned 5th bedroom suite and abundant storage/utility area round out the lower level. Cheers!

The stamped concrete circle drive leads to an attached oversized side-entry 4-car garage.

Enjoy outdoor living and entertainment on the sprawling rear terrace, complete with covered area to escape the sun. The terrace overlooks the lush, level, tree-lined rear lawn.

This home is a true natural beauty, majestically sited on a lush 1.33 acre lot. The grounds are meticulously landscaped and perfectly pruned, with an expansive, deep and level rear yard offering plenty of space for whatever your heart desires.

Listing Information
Price	$1,895,000
Listing Number	1687041

Driving Directions
Beechmont to Asbury to Ayers Rd.

View Property on Map

Agent Remarks
Spectacular custom built home on 1.33 verdant acres in exclusive Riverview Estates of ColdstreamExceptional craftsmanship w/quality & luxury at every turnThoughtfully designed open flrplanOnly the finest fit/finish1st fl master steGourmet KIT open to hearth rmMagnificent LL w/wet bar/wine cellar*Meticulously maintained & extensively improved.

Property Information

Mortgage Calculator

More Information

General Information
Property Type	Residential
Style	Single Family
County	Hamilton
Subdivision	Anderson Twp
Zip Code	45255
School District	Forest Hills Local S
Listing Number	1687041

Bedroom Information
Beds	5
Master Bedroom	28 x 17	L: 1
Bedroom 2	25 x 15	L: 2
Bedroom 3	20 x 15	L: 2
Bedroom 4	16 x 14	L: 2
Bedroom 5	14 x 13	L: 1

Bathroom Information
Baths	5.2
Bath 1	Full	L: 1
Bath 2	Partial	L: 1
Bath 3	Full	L: 2
Bath 4	Full	L: 2

Property Features
Basement	Full
Garage	Attached, Side, Oversized
Cars	4
Parking	On Street, Driveway
Windows	Wood, Insulated, Casement, Double Pane
Heating	Gas, Forced Air, Program Thermostat, Zoned
Cooling	Central Air, Ceiling Fans
Fireplace	Ceramic, Gas, Stone

Additional Information
Levels	2 Story
Construction	Brick, Stone
Architecture	Traditional
Lot Dimensions	170x335
Gas	Natural
Water	Public
Sewer	Public
Foundation	Poured
Occupancy	Negotiable
Semi-Annual Taxes	$20,341.23

Room Information
Rooms	15
Entry	18 x 10	L:
Living	17 x 17	L: 1
Dining	16 x 14	L: 1
Kitchen	30 x 26	L: 1
Family	27 x 15	L: Lower
Great Room	19 x 17	L: 1
Recreation Room	17 x 16	L: Lower
Study	15 x 12	L: 1
Laundry	14 x 8	L: 1

Additional Features
Master Bedroom Info	Wall-to-Wall Carpet, Walkout, Other, Bath Adjoins, Walk-in Closet, Dressing Area, Window Treatment, Vaulted Ceiling
Master Bath Info	Whirlpool, Marb/Gran/Slat, Double Vanity, Shower, Ceramic Tile, Heated Floors, Built-In Shower Seat, Double Shower, Steam
Basement Details	Other, Part Finished, Fireplace, WW Carpet
Entry Features	Double Doors, Marble/Granite/Slate, Transom/Sidelit, Other, Ceramic Tile, Open Foyer, Closet
Living Room Features	Other, Wood Floors, Fireplace, Bookcase
Dining Room Features	Other, Chandelier
Kitchen Features	Pantry, Wood Cabinets, Walkout, Marble/Granite/Slate, Wood Floor, Eat-In, Gourmet, Island, Counter Bar, Butler's Pantry
Family Room Features	Wall-to-Wall Carpet, Fireplace, Bookcase, Wet Bar
Great Room Features	Fireplace, Other, Wood Floor, Bookcases
Appliances	Oven/Range, Other, Dishwasher, Refrigerator, Microwave, Garbage Disposal, Convection Oven, Wine Cooler, Warming Drawer
Other Features	Ceiling Fan, 220 Volt, Smoke Alarm, Recess Lights
HOA Fee - Annual	$567.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 RE/MAX Affiliates 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.

Local Communities Home Search

Alexandria (KY) Burlington (KY) Covington (KY) Edgewood (KY) Erlanger (KY) Florence (KY) Ft. Mitchell (KY) Ft. Thomas (KY) Grant County (KY) Hebron (KY) Highland Hts (KY) Independence (KY) Newport (KY) Pendleton County (KY) Richwood (KY) Union (KY) Villa Hills (KY) Anderson Twp (OH) Blue Ash (OH) Cincinnati (OH) Indian Hill (OH) Kenwood (OH) Mason (OH) West Chester (East) (OH) West Chester (West) (OH) Western Hills (OH) ... MORE COMMUNITIES

Useful Tools

"My Home Watch" Service Housing Trends Relocation Services Neighborhood Info

Featured Searches

Open Houses Virtual Tours Foreclosures Bank Owned New Construction

Affiliate Services

Stockton Mortgage Excel Title 2-10 Home Warranty DBL Law Gateway Potter Insurance Anneken Huey & Moser CPA

Our Company

Offices & Agents Our History Career Opportunities Contact Us

home page terms of use privacy statement agent login agent intranet agent tools contact us

Florence, KY
4895 Houston Road
Florence, KY 41042
Phone 859-372-6000
Fax 859-372-6005

Cincinnati, OH
4212 Airport Rd, Ste 209
Cincinnati, OH 45226
Phone 513-421-0345
Fax 513-618-5888

Highland Heights, KY
2893 Alexandria Pike
Highland Heights, KY 41076
Phone 859-441-5333
Fax 859-781-4204

Falmouth, KY
879 Ridgeway Ave.
Falmouth, KY 41040
Phone 859-654-5000
Fax 859-654-5006

Each office is independently owned and operated.