Refine Search
Map
Sort by
$20,000,000
2 Beds ⋅ 1 Baths ⋅ 612163 MLS
Value is in the land. Property being sold with 7562 Alexandria Pike. 3 homes 2 barns and a dry house. Picturesque property features approximately 63 acres of gently rolling land in a prime location between Highway 27 and Highway AA. The surrounding properties that touch the farm include highway commercial, commercial, and CCRC (continuous care retirement community) making it a prime location for commercial development and endless possibilities. Seller is willing to subdivide or lease portions of the property. The property boasts an impressive 420 feet of frontage that touches the double AA highway, over 400 feet of frontage that touches Highway 27 and over 900 feet of frontage on Enzweiler Road. With its prime location at the corner of Highway 27 and Enzweiler, this property offers unbeatable exposure for any commercial enterprise. Don't miss out on this once-in-a-lifetime opportunity to own a piece of history and a prime piece of land in a sought-after location. Contact us today to schedule a viewing.

12 Enzweiler Road, Alexandria
$9,995,000
6 Beds ⋅ 9 Baths ⋅ 1885472 MLS
The best awaits you in this custom to-be-built estate situated on a nearly 5 acre lot at the end of a cul-de-sac with full privacy! Top level finishes and smart technology perfectly blended with traditional craftsmanship using exceptional materials. Stunning entertaining spaces both inside and out!

8440 Beacon Hill Road, Indian Hill
$6,625,000
5 Beds ⋅ 2 Baths ⋅ 640573 MLS
Unique Opportunity to Own 25.4 Acres in the Heart of Burlington! Restore the Home to Your Own, Create Your Own Family & Friends Compound, Potential for Commercial-Business-Mixed Use Zoning, or Just Hold Onto the Land as an Investment! This Property Currently Features a 5,000+ SF Home Originally Built in 1840, Multiple Outbuildings & Barns, and 1,300 Feet of Frontage on Bullittsville Road with Water-Sewer-Electric-Natural Gas-High Speed Internet All Available! Located Just Minutes from CVG Cincinnati/Northern Kentucky Airport, Turfway Park, & Downtown Cincinnati!

5695 Bullittsville Road, Burlington
$5,385,000
5 Beds ⋅ 5 Baths ⋅ 1888436 MLS
A rare opportunity to create a custom, Cotswold-inspired estate in the heart of Indian Hill - This proposed design by Daley Design & Build showcases timeless architecture with modern livability, & exceptional craftsmanship - The builder is ready to work closely with a buyer to modify the design, floor plan, finishes & specifications to meet their lifestyle, taste & budget - Set on a private lot in the Indian Hill School District - Bring your vision to life and create a timeless estate uniquely your own.

5880 Crabtree Lane, Indian Hill
$5,200,000
4 Beds ⋅ 5 Baths ⋅ 642814 MLS
Welcome to 1152 Bellavista Dr. located in Park Pointe, NKY's premier gated community known for its Luxury Living w/incredible panoramic Cincinnati Skyline Views! This architecturally striking custom home offers over 5,600 SF of sophisticated living space w/a refined Miami-styled aesthetic. Your guests are sure to be impressed w/the dramatic water feature-floating stepping stone entrance to the grand pivot entry door! This showpiece was thoughtfully designed for elevated living & exceptional entertaining. Dramatic 18' ceilings, floor-to-ceiling Pella windows, integrated LED ceiling illumination, designer fixtures, sleek linear gas fireplaces, & a stunning floating staircase w/frameless glass railing create an unforgettable first impression. The contemporary pocketing sliding glass wall system opens to a seamless indoor/outdoor expansive multi-level entertaining space including a covered Trex deck, stamped concrete patio, & rooftop terrace. The elevated Chef's Kitchen showcases ultra-lux porcelain waterfall countertops w/a refined European design, custom Italian modern luxury cabinetry, Bosch, Wolf & Thermador appliances, oversized Butler's Pantry w/direct access from garage, plus a full wet bar with accent-lit shelving, ice maker, and beverage chiller. The luxurious Primary offers a boutique hotel-inspired spa experience complete w/a generous dbl vanity, frameless glass shower, freestanding tub, extraordinary custom Hermes-influenced WIC. The LL features a glass wine room, lounge area, flex/exercise room, & fully equipped Pool House-Bar with wine chiller, dishwasher, ice maker, & dual glass wall systems opening to both the fin LL & outdoor entertaining spaces. Resort-caliber amenities include a Heated Gunite pool w/sun shelf, swim-up bar, automated cover, grill station, irrigation, rooftop terrace, & multiple outdoor gathering spaces delivering a private resort experience while capturing sweeping skyline views! A truly rare offering unlike anything else in NKY!

1152 Bellavista Drive, Park Hills
$4,911,000
5 Beds ⋅ 6 Baths ⋅ 1864271 MLS
Spectacular luxury home by Daley Design + Build, set on a secluded lot off a private drive and backing to protected green space. The current plan features over 6,200 finished square feet across the first, second, and lower levels. Collaborate with Daley Design + Build to customize every detail to your vision. This exceptional homesite provides the perfect backdrop for a private, year-round retreat. Build this plan or work with the team to design a home tailored entirely to you.

3 Noel Lane, Indian Hill
$4,900,000
5 Beds ⋅ 5 Baths ⋅ 1881495 MLS
Daley Design & Build presents an exceptional custom two story home set on over five private, wooded acres in the heart of Indian Hill. Thoughtfully designed for effortless one-floor living, this new construction opportunity offers over 6,000 square feet of beautifully finished space, featuring 5 bedrooms and 4.5 baths. Enjoy multiple outdoor entertaining areas overlooking serene natural surroundings, perfect for relaxing or hosting guests. The finished lower level expands the living space with a private guest suite and an expansive recreation room ideal for everyday living and entertaining alike. Every detail is expertly curated with high-end finishes and custom craftsmanship, creating a truly spectacular retreat. Daley Design & Build can build this plan as shown in the renderings or work with you to personalize and design the perfect home for your lifestyle.

9280 Indian Hill Road, Indian Hill
$4,900,000
5 Beds ⋅ 7 Baths ⋅ 641654 MLS
One of the region's most extraordinary estates, this custom masterpiece by Toebben Builders is truly exceptional. Spanning over 16,000 square feet, this like-new residence showcases exquisite architectural detail and superior craftsmanship throughout. Re-creating this elegant and inviting home today would come at a significantly higher cost. From the moment you arrive, the symmetric double limestone staircases make a grand statement. Designed for both lavish entertaining and comfortable everyday living, the home features an atrium-style indoor pool, stunning chef's kitchen, luxurious spa-inspired baths, private theater, game room, hibachi grill, and even a private shooting range. Additional highlights include geothermal HVAC systems, a 5+ car garage, advanced security, and fully integrated smart home technology -- delivering the ultimate in comfort, efficiency, and peace of mind. Located in one of Northern Kentucky's most sought-after neighborhoods, just 15 minutes from downtown, this estate offers refined luxury living without sacrificing convenience. A rare opportunity for the most discerning buyer -- this is truly a must-see.

943 Squire Oaks Drive, Villa Hills
$4,850,000
6 Beds ⋅ 7 Baths ⋅ 1885489 MLS
Opportunities like this are exceptionally rare. Privately situated on nearly 5 acres in prestigious Riverview Estates at Coldstream, this iconic estate offers over 10,000 sq ft of luxury living with what may be the most coveted panoramic Ohio River view in all of Cincinnati. Originally part of the historic Chaswil Farm, the property helped pioneer one of the region's most exclusive luxury communities. Designed for elevated entertaining and executive living, the home features a hidden third-story private theatre/media retreat, custom wine cellar, expansive entertaining spaces, and a heated 4-car garage. Unmatched privacy, breathtaking sunsets, and sweeping 180-degree river vistas create a true legacy property just minutes from downtown, private aviation, and elite country clubs.

7803 Ayers Road, Anderson Twp
$3,950,000
7 Beds ⋅ 12 Baths ⋅ 1863170 MLS
Timeless Colonial Revival estate originally built for the Kroger family and beautifully updated. 7.07 acres Features include refinished hardwood floors, a newer chef's kitchen with premium appliances, multiple gathering rooms, and a gorgeous paneled study. The expansive primary suite offers a luxe bath, sitting area, and dream closet. With five additional bedrooms, bonus spaces, and play areas, the home is both elegant and functional. Outdoors, enjoy gardens, terraces, a stone-surround pool, covered patio, and charming pool house. Recent updates include new landscaping, a golf cart garage, and updated pool house lighting. All Offers open for 48 hours. No escalation clauses.

9675 Cunningham Road, Indian Hill
$3,885,000
5 Beds ⋅ 8 Baths ⋅ 1881460 MLS
Elegant, classic home in a private setting on 3.6 acres. Tall ceilings, extensive custom built-ins, & hardwood flooring add timeless elegance. The chef's kitchen is equipped with top-tier appliances: Liebherr, Dacor, Fisher & Paykel, & Miele, & is highlighted by a stunning Rookwood Pottery tile backsplash. Walk out from the kitchen to the inviting veranda & expansive rear yard. The great room offers a lovely gas FP with a marble & wood mantel, while the cozy FR includes built-ins & a gas-start fireplace. The serene primary suite features a tray ceiling, gas FP, dressing area, & luxe bath. The lower level includes a FR, wine rm, pub bar, exercise rm, game area, & abundant storage. Outside, the rear veranda with bead-board ceiling overlooks a park-like backyard with beautiful vista views. A deep 4-car garage & partially fenced yard complete this exceptional, lovingly maintained home. Offers open for 48hrs. No escalation clauses. Pre-Qual letter required for showings. No yard sign.

6650 Alberly Lane, Indian Hill
$3,795,000
5 Beds ⋅ 5 Baths ⋅ 1886392 MLS
Exceptional opportunity on prestigious Grandin Lane in Hyde Park featuring breathtaking river and city views. Designed for elegant entertaining and everyday living, this swanky, sophisticated home offers expansive windows, multiple walkouts on every level, stylish neutral decor, gorgeous woodwork, hardwood floors, and custom built-ins throughout. Stunning white kitchen with breakfast room opens to gracious living and dining spaces highlighted by 4 fireplaces and two wet bars. Private primary suite features custom closets, and a glamour bath. Lower level includes a custom wine cellar and large recreation room leading to a tranquil gunite pool with built-in hot tub surrounded by lush landscaping and privacy. Elevator access to all 3 levels. Oversized 3-car garage with custom flooring and built-ins. Top-of-the-line updated mechanics complete this extraordinary 5-bedroom residence. Seller preferred occupancy 8/15/2026.

20 Grandin Lane, Cincinnati
$3,750,000
5 Beds ⋅ 9 Baths ⋅ 1886932 MLS
Welcome to an extraordinary private estate, built by Rhoads & set on more than 25 breathtaking acres where luxury, nature, and exceptional craftsmanship meet. Tucked behind a gated entrance at the end of a long private drive, this remarkable property is centered around a stunning 3-acre stocked pond, creating a peaceful & picturesque setting unlike any other. From the moment you step inside, you're greeted by soaring walls of windows that span the rear of the home, capturing spectacular water views from nearly every room. Rich architectural details including intricate millwork, boxed wood ceilings, exposed wood beams,& a sweeping staircase. Designed for both everyday living and entertaining, the open-concept floor plan flows seamlessly. Car enthusiasts will appreciate the attached 3 car garage, as well as the detached 5 car garage equipped with a vehicle lift. Down the drive, a beautiful heated barn, pastures and hiking trails. A truly one of a kind Waynesville estate!

8495 St Rt 48, Clearcreek Twp.
$3,740,000
5 Beds ⋅ 6 Baths ⋅ 1887134 MLS
An exceptional 24 acre custom estate where timeless craftsmanship, thoughtful design, and modern innovation come together. Extensively renovated and expanded with a stunning 2021 addition, every detail reflects superior quality and intentional living. The thoughtfully designed floor plan offers a luxurious first-floor primary suite along with an additional second-floor ensuite, providing exceptional flexibility for family and guests. Built for beauty and efficiency, the home features geothermal heating and cooling, solar energy, and an integrated Control4 smart home system. Exceptional millwork, premium finishes, and seamless indoor-outdoor living define the residence. Resort-style amenities include heated saltwater pool with beautifully appointed pool house, stocked pond, climate controlled 30' x 60' barn/workshop and a vintage barn. A rare opportunity to own a meticulously engineered estate where craftsmanship, technology, and luxury living exist in perfect harmony.

3191 Mcintire Road, Hamilton Twp
$3,700,000
5 Beds ⋅ 6 Baths ⋅ 1885333 MLS
Welcome to a Homearama showcase by Justin Doyle Homes where modern organic design meets quiet luxury across 8,126 sq ft of pure intention. Soft light fills every room, layered with warm neutrals, natural stone & rich texture. The Great Rm, with its beamed ceiling, opens to covered outdoor living, while the kitchen's arched stone range hood anchors a space made for gathering. The pool, hot tub, and sports court create a backyard everyone will want to be at, from lazy summer afternoons by the water to friendly games under the lights. The primary suite, with dual walk-in closets and spa bath, feels like your own escape. Upstairs, 3 bedrms, a loft & a playroom give family room to spread out. The lower level theater, exercise rm, rec rm, & guest suite turn everyday living into something extraordinary. Set on 2.3 country acres yet minutes from downtown Loveland, this is a home built not just to impress, but to hold every special memory you'll make in it.

9870 Christian Court, Hamilton Twp
$3,600,000
4 Beds ⋅ 6 Baths ⋅ 1881664 MLS
Set in the prestigious Meadows at Peterloon, this exceptional Indian Hill residence blends luxury, craftsmanship, and comfort. Custom details include built-ins, designer tilework, and a private golf simulator. The flexible floor plan offers two bedrooms on the main level and two lower-level suites. Outdoor living shines with a screened porch featuring vaulted tongue-and-groove ceilings, a stone fireplace, mounted TV, infrared heaters, and an outdoor kitchen. A resort-style pool and stamped concrete terrace are surrounded by water features, mature trees, and beautifully curated landscaping. Additional amenities include a Hearth Room with mini bar, refrigerator and freezer drawers, a lower-level rec room with bar/kitchenette, Control4 automation, heated primary bath floors, and a dog wash.

5 Old Orchard Lane, Indian Hill
$3,600,000
5 Beds ⋅ 8 Baths ⋅ 1867257 MLS
New construction by Brookstone Homes featuring the Tranquility floorplan in The Estates at Bothe Farms, site of HOMEARAMA 2026. This luxury show home sits on a private 3.5-acre lot with 5 bedrooms, 8 full baths, and private guest quarters with elevator. This home can be purchased fully furnished! Zero-entry first floor (including the owner's suite). Dramatic circular oak staircase. Open-concept kitchen with luxury appliances, butler's pantry, walk-in pantry, and wine room, flowing into a two-story family room with stone fireplace and walk-out access to the Veranda and Lanai. The second floor features three ensuite bedrooms, library, office, and balcony. Finished walk-out basement includes 10' ceilings, sports bar, golf simulator, billiards room, well appointed cigar lounge/study, and family room. Outdoor living includes an in-ground pool, outdoor kitchen, fireplace, and multiple patios. Over $400K in show discounts. This home offers so many luxuries to list!

9774 Christian Court, Loveland
$3,399,000
10 Beds ⋅ 12 Baths ⋅ 644708 MLS
This 813± acre tract in Lewis County, Kentucky, presents a rare opportunity to own a large continuous block of land with a mix of features suitable for recreation, hunting, agriculture, or long-term investment. Large single-tract properties of this scale are increasingly uncommon in the region. The land consists of approximately 40± acres of productive tillable ground, adaptable for row crops, hay production, or wildlife food plots. The balance of the property is primarily timbered acreage with rolling ridges, wooded hollows, and natural funnels that provide excellent wildlife habitat. A pond on the property adds a reliable water source for wildlife, livestock, and recreation. The diversity of terrain supports whitetail deer, turkey, and small game, making the property well-suited for hunting and habitat management. The newly built 8,550± square foot lodge-style residence highlights the tract. This four-level home includes three levels above grade and a walkout basement below grade. The design features an open and spacious floor plan with large common areas that can serve multiple purposes, alongside private living quarters. The home has 10 bedrooms, 10 full bathrooms, and 2 half bathrooms, offering flexibility for retreats, gatherings, or long-term residential use. The kitchen area remains unfinished, allowing the future owner to select appliances and finishes to suit their needs. Other improvements include an older barn that provides storage potential and could benefit from updates. An internal trail system is in place throughout the acreage, offering access by ATV, UTV, horseback, or foot. These established trails would benefit from cleanup and maintenance for easier travel. For hunting and land management, the property includes a 360° elevated hunting blind and a Veil deer feeder, creating established setups for pursuing game. Access is available both from the main entrance near the residence and through a secondary easement.

9361 Kentucky 344, Vanceburg
$3,300,000
4 Beds ⋅ 5 Baths ⋅ 1879770 MLS
Extraordinary one owner custom built Hensley ranch blends exceptional craftsmanship with timeless architectural design. Soaring coved ceilings, rich hardwood, custom built-ins & intricate millwork define the interiors. Walls of windows & French doors span the rear of the home, opening to terraces overlooking the resort-style saltwater pool & beautifully landscaped grounds. Great Room with floor-to-ceiling stone fireplace flows seamlessly into the Chef's Kitchen with custom cabinetry, professional-grade appliances, oversized island & breakfast area. Finished walkout lower level designed for entertaining with a stone wine cellar, media spaces & two walkout en suite bedrooms. Outside, the awe-inspired setting continues with covered entertaining areas overlooking the water, and an exceptional outdoor kitchen beneath a richly finished wood-paneled ceiling. A gated motor court & extensive garage space complete this extraordinary estate.

6784 Rose Mallow Drive, West Chester
$3,250,000
6 Beds ⋅ 9 Baths ⋅ 1886145 MLS
First time on the market since its full renovation and 6,500 SF addition in 2001. Just 10 minutes from downtown Cincinnati, yet a world apart, this 10.6-acre estate in California, Ohio offers ultimate privacy and breathtaking details. Perched high on a hill, it captures sweeping views of the Ohio River Valley and unforgettable sunsets. A stone-column gated entry and tree-lined drive set the tone for the exceptional lifestyle that awaits. Inside, the home's heart is a chef's kitchen designed for both grand entertaining and intimate gatherings. For the auto enthusiast there's garage space for 10 vehicles. The detached garage provides a professional heated detailing bay, heated workshop, and second flood storage. Outdoor living is totally private with a three-level stone terrace, pool and hot tub. Additional luxuries can be found on the feature list. Every detail has been designed to combine comfort, security, and elegance in one extraordinary property.

5 Twin Hills Ridge Drive, Cincinnati
$3,200,000
4 Beds ⋅ 5 Baths ⋅ 643314 MLS
Extraordinary award-winning custom-designed 4-story residence in NKY's premier gated luxury community, Park Pointe, offering show-stopping city views from every level. Perched atop a premier hilltop setting, this unique home features more than 5,100 SF of space that blends a highly functional floor plan with a sophisticated modern aesthetic. Visitors are welcomed by a dramatic 21' entry and a striking floating staircase with a cantilevered 2nd floor, creating visual connections throughout the home while maximizing natural light and views from every angle. Thoughtfully engineered with a structural steel framework and 24'' deep floor trusses to achieve expansive open spaces, design flexibility, and uninterrupted sightlines. Premium fixtures and finishes were integrated throughout, including dramatic NanaWall accordion glass wall systems to create an indoor-outdoor experience, and a 4-story elevator for convenient access & age-in-place lifestyle. The chef's kitchen seamlessly connects the living spaces to the stunning skyline views and features Sub-Zero, Wolf, and Cove appliances and an oversized waterfall island with seating for 6. The luxurious primary suite is perfectly oriented toward the city skyline and includes a private deck with a spa-inspired bath appointed with curbless glass-enclosed shower, soaking tub, heated floors, and an expansive walk-in closet. The 4th floor is for elevated entertaining with 2 accordion wall systems that fully open to create an incredible indoor-outdoor environment. Watch the game, prepare meals at the covered grilling station, gather around the bar or relax at the gas fire pit while enjoying fireworks over the city for an unmatched experience. Retreat to the lower-level wellness area complete with a fitness room and sauna for rejuvenation. Unique lot with 270-degree unobstructed views, a yard and rear-access 3-car garage. 10 mins to downtown Cincy and 15 mins to CVG

1204 Vistapointe Drive, Park Hills
$3,100,000
4 Beds ⋅ 7 Baths ⋅ 1876176 MLS
Unparalleled 2026 Homearama Showcase estate by Old World Custom Homes, offering approx. 6,750 sqft of meticulously designed living space on 2+ exclusive acres. Tour the model home just 5 minutes away @ 10475 Harrison Rd! Every detail reflects refined craftsmanship & intentional design. Open, light filled spaces blend with private retreats for a home that's both striking & functional. Gourmet kitchen with double islands, scullery & prep area anchors the main level, flowing to a lounge + covered patio with fireplace for seamless indoor/outdoor living. 1st floor primary suite + sauna offers a true escape, while all additional bedrooms feature ensuite baths + walk in closets. Finished lower level with bar, fam room & lounge. 3 car garage with attached gym space. Offerings of this caliber do not come often - designed to impress, a statement in craftsmanship & ready for life lasting memories.

9822 Christian Court, Hamilton Twp
$2,999,000
5 Beds ⋅ 7 Baths ⋅ 1887603 MLS
Situated on a private cul-de-sac in sought-after Indian Hill, this original-owner custom build offers more than 10,000 finished sq ft designed for comfortable everyday living & entertaining alike. The thoughtfully designed floor plan features a desirable first-floor primary suite, an additional main-level bedroom, for a total of five spacious bedrooms with adjoining bathrooms. Expansive living spaces continue throughout the home, providing exceptional flexibility for family & guests including a spectacular lower-level walkout with phenomenal space for entertaining & recreation. Enjoy the peace and privacy of over 3 acres while being just minutes from Montgomery's restaurants, shopping, and everyday conveniences. Don't miss your opportunity to live in one of Cincinnati's premier communities known for its top-rated schools!

8625 Fawnmeadow Lane, Indian Hill
$2,999,000
4 Beds ⋅ 5 Baths ⋅ 642676 MLS
Perched on nearly seven acres! This Ft. Thomas Mid-Century Modern retreat sits high above the Ohio River in a setting of total privacy. Wake up to the sun rises over calming sparkling waters and beautiful sunsets watching abundant wildlife. Experience it all while sitting on the extra large screened in porch, or the expansive deck that spans the entire home. Despite the wildlife seclusion, you are only minutes from downtown Cincinnati, with a driveway capable of handling ten cars and a detached two-car garage. The Frank Lloyd Wright-inspired interior is a masterclass in local Mid-Century vibes, highlighted by Rookwood Tile and Italian Terrazzo. Airy tongue-and-groove ceilings complement the comforting warmth of geo-thermal powered radiant tubing throughout. The open kitchen is a chef's dream, featuring high-end Wolf appliances, a walk-in pantry, and custom cabinetry that hides the largest Sub-Zero refrigerator, freezer, and wine cooler. Relax in the open-concept living room by the wood-burning fireplace. Main-floor living is thoughtfully designed with a primary suite featuring walk-in closets, an ensuite bath, and an adjacent office or nursery. Your guests will enjoy total privacy with two additional first-floor bedrooms, each boasting its own ensuite. The lower level extends the footprint of the home with a bar, pool table area, and a massive 1,000-square-foot flex room perfect for a gym or studio. A fourth bedroom with a walk-in closet and ensuite rounds out the basement. Complete with modern smart home technology this home truly blends timeless design and vintage soul with contemporary modern comfort.

110 Broadview Place, Fort Thomas
$2,995,000
4 Beds ⋅ 6 Baths ⋅ 1887875 MLS
The epitome of Central Village living in the heart of Clippinger Woods, 8100 Chinquapin Lane offers well over 5700 of finished square footage with custom finishes throughout. From the time you enter this home, there is a sense of quality and design from Engler Builders in 2007. The open custom kitchen has a separate bar area, butler pantry and loads of storage and counter space. The first floor primary offers 2 separate primary baths with a connecting shower and walk-in closets. A formal 1st floor study has handmade bookcases, hardwood flooring and French doors. The lower level has over 1800 square feet of finished space with a great room and an additional recreation room, complete with a mini-kitchen and fireplace. With a full bath in the lower level, there is potential for multi-generational living space. Location, location, location. Walk to the schools, parks, stroll down the street and so close to downtown Madeira and Mariemont.

8100 Chinquapin Lane, Indian Hill
$2,800,000
6 Beds ⋅ 7 Baths ⋅ 1886131 MLS
PREMIERE location, off of Brill Rd, this beautiful setting is unmatched! Sitting on over 3 flat acres of privacy yet still only minutes away from shopping, restaurants, top rated schools, parks & more. This custom built home captivates the moment you walk in the door with its unique architectural details & spacious layout. Perfect for your quiet family moments to entertaining your closest family & friends with multiple walkouts from the kitchen, living room, & family room, allowing all to move seamlessly from inside to the patio, pool, & yard with ease. Water Heater (2026), First floor air conditioning unit & blower assembly (2022), Roof (2021), Kitchen appliances Subzero, Thermador (2021), Pool Heater (2021) & more updates!

5475 Waring Drive, Indian Hill
$2,799,000
4 Beds ⋅ 5 Baths ⋅ 1885431 MLS
Sterling Homes introduces The Albert for HOMEARAMA® 2026. Save hundreds of thousands of dollars in Homearama discounts and call this home by the end of September. What more could you ask for? Maybe FULLY FURNISHED, golf simulator, theater room w/ surround sound by Hanson A.V., selections by Bishop Design, and a wellness room! Set on over two private acres in The Estates at Bothe Farms, Sterling Homes presents a timeless European design that's sophisticated, welcoming, and effortlessly livable. From soaring vaulted ceilings and rich architectural details to custom millwork and warm natural finishes, this home is designed to leave a lasting impression. Key features include four bedrooms, a first-floor primary suite, a vaulted great room, a golf simulator, a fitness room with a dry sauna, three fireplaces, multiple dry bars, a butler's pantry w/ second fridge & sink, a private office, a welcoming front coffee porch, and 6,096 sqft designed for exceptional everyday living and entertaining.

9702 Christian Court, Hamilton Twp
$2,750,000
5 Beds ⋅ 6 Baths ⋅ 1862002 MLS
Less than a month to completion, book your showings now. 2026 Homearama opportunity - A rare opportunity to own a premier John Hill Construction custom estate. Experience luxury and craftsmanship in this stunning estate situated on a picturesque two-acre homesite in the tranquil setting of Bothe Farms. Enjoy expansive outdoor living and exceptional privacy, all just 2 miles from downtown Loveland. This 6000+ sq ft home offers thoughtfully planned living spaces, including a first-floor primary suite and an additional main-level ensuite bedroom ideal for guests. Notable features include: zero-step entry from the garage, dog shower in the mudroom, outdoor covered living area with fireplace and grill, beautiful architectural designs and designer finishes throughout. Over $150K in Homearama discounts.

9798 Christian Court, Hamilton Twp
$2,750,000
6 Beds ⋅ 7 Baths ⋅ 638209 MLS
Magnificent English Tudor home boasting over four acres and nestled in a beautiful, wooded setting overlooking a lake front in Triple Crown. This 6 bedroom, 5 full and 2 half bath home was planned to showcase hand craftmanship in the tradition of the Arts and Crafts era begun in England the latter half of the 19th century. This two-story distinctive brick home has a multi gabled roof featuring dormers, small pane windows with three tall chimneys. Two tiers of steps lead to an oversized mahogany door with leaded restoration glass panels. The entry foyer floor has a custom wooden design inlay. Hardwood floors run throughout the first level. This home has 5 wood burning fireplaces, handcrafted cabinetry throughout and a primary suite which includes a sitting room, walk in closet and luxurious bath. The kitchen is designed with custom cabinetry, granite countertops, ''Wolf'' gas range cooktop on the center island, ''Sub-Zero'' refrigerator and double ovens. The living room has newly added remote custom draperies. Finished lower level with parquet oak flooring, custom bar, wine cellar, steam room and much more. An English Garden with fishponds and a waterfall leading to a spectacular gunite pool are just a few of the amazing features in the rear of the home. This house is certainly a must see for the right buyers.

10730 Omaha Trace, Union
$2,665,000
5 Beds ⋅ 6 Baths ⋅ 641952 MLS
NEW BUILD: 2025 Home Show Showcase Home! Designed around the power of five: 5 oversized garage spaces, 5 spacious bedrooms, 5 full baths (plus a half). Set on more than an acre with sweeping views of Triple Crown golf course hole #4 and the lake. Enjoy a covered deck with outdoor fireplace, perfect for year-round living. Inside, discover soaring ceilings, Bosch appliances, a spa-inspired primary suite, a grilling deck, and a huge walk-through pantry. The lower level is built for entertaining w/stunning bar area and ample gathering space, plus room to add a golf simulator. Located just steps from the new Publix and Triple Crown's premier amenities:luxury, lifestyle, and location in one exceptional home.

521 Affirmed Avenue, Union

The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity™ program of the Multiple Listing Service of Greater Cincinnati. Real estate listings held by brokerage firms other than our company are marked with the Broker Reciprocity™ logo (the small house as shown to the left) and detailed information about them includes the name of the listing brokers. This data is up-to-date as of . Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved. Information deemed reliable but not guaranteed.