Feature Properties

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

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

$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

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

$2,650,000

5 Beds ⋅ 6 Baths ⋅ 1876163 MLS

Welcome to your new home private retreat..... Where architecture excellence meets serene sophistication. Light-filled home with walls of windows everywhere. Every detail from chef gourmet kitchen and spa inspired primary suite to the seamless indoor-outdoor entertaining spaces with pool & spa reflects commitment to luxury and comfort. Positioned on one of the most prestigious area streets, this residence offers unmatched privacy, elegance and elevated lifestyle. Gated entry, treed 3 acre lot...just minutes away from everything. Will not last !

6220 Hawk Ridge Lane, Indian Hill

$2,650,000

5 Beds ⋅ 6 Baths ⋅ 1853936 MLS

One of a Kind property where Words Cannot Describe the Feel of this Truly Remarkable Place. Custom Home on Rolling 40 acres Situated at the Edge of the Appalachian Mountains Overlooking Brush Creek Valley with 2000' of Deep Water River Frontage. Located in the Heart of Protected Nature Conservancy Land Holdings Makes This Something Very Unique. Breathtaking Contemporary Home Features 7000 sq ft 5 Bed/6 Bath Open Floor Plan with Huge Great Room Overlooking your Private 3 Acre Lake & Oasis. Amazing 2nd Story Balcony w/Expansive Long-Range Views of Surrounding Untouched Hill Country. Enormous Patio Runs up to Waters Edge w/Outdoor Kitchen, Pavilion, Dock & Beach area. Added Business/Rental Opportunity if Desired w/Additional 2 Bed Creek Side Cabin w/Screened in Porch & Deck. As well as 30x80 Custom Greenhouse that is State approved for Events. Unbelievable Property with Too Many Features to List. Additional Adjacent 87ac of land with Smaller Home plus Cabin Possibly Available.

1805 Waggoner Riffle Road, West Union

$2,600,000

4 Beds ⋅ 4 Baths ⋅ 1885279 MLS

Opportunities like this only come once in a lifetime. One Listing, BUT SO MUCH ELSE! Two Homes, Two Ponds, and 23 acres of rolling meadows and woods. Home #1 is 4 bedrooms, 3.5 bathrooms, 2 car garage with an indoor pool. Home #2 is a 3 bedroom, 1 full bath, 1 car garage, Bonus, you get a 30 x 50 4 stall horse/animal barn, 6000+ sq ft office/shop combo with 3 phase electric, large dock roll-up doors, over-head cranes, meeting rooms, etc.

6788 E Us Rt 22 & 3, Salem Twp

$2,500,000

5 Beds ⋅ 7 Baths ⋅ 1883321 MLS

Welcome to 568 Locust Run. This 6000 sq ft estate exemplifies the signature craftsmanship of Imbus Builders, a premier custom home-builder renowned in the Greater Cincinnati area. Every detail of this custom masterpiece highlights their philosophy of thoughtful planning, From the moment you walk into the foyer, you are met with the open floor plan, great room, gourmet kitchen, with adjoining butler's pantry. Vast walls of high-performance glass flood the interior with natural light. The expansive Primary suite has an adjoining bath, walk in closet and dressing room, along with a personal laundry room. The garage is built for the car enthusiast, easily accommodating 8 cars, with room for lifts or a grand shop. Follow the steps down to the lower level with 2000 more sq ft of living space. Two more, full bath, bedrooms, a huge family room and flex space that could be used as a gym with a room for a sauna. pick some of the final finishes for your turnkey property.

568 Locust Run Road, Pierce Twp

$2,500,000

4 Beds ⋅ 8 Baths ⋅ 1881562 MLS

Beautiful resort-like home on 3 acres in the heart Indian Hill Village. Your own staycation home situated on a quiet culdesac street. This exceptional home boasts over 7,500 sqft of luxury and natural tranquility just minutes away from all the conveniences. Gourmet kitchen walks out to patio with private pool surrounded by serene parklike wooded setting. First floor primary suite with sitting room and fireplace. Expansive recreation room, theatre room and extra kitchen great for entertaining. Simply Marvelous!

5775 Sugarun Lane, Indian Hill

$2,500,000

4 Beds ⋅ 2 Baths ⋅ 642073 MLS

A rare legacy offering in Burlington (4 miles to RT 18) where history, land, and opportunity align in a way that's increasingly hard to replicate. Set across 20 breathtaking acres, this extraordinary estate is more than a property, it's a living piece of Boone County history. The iconic farmhouse, recognized in film productions and a national ice cream commercial, carries a presence that is both timeless and unforgettable. Offering 4 bedrooms and 2 baths, the home welcomes you with a grand entry and a statement staircase that immediately sets the tone. Inside, character unfolds at every turn with 8 fireplaces, a warm and inviting country kitchen with its own hearth, and remarkably preserved craftsmanship including 16-inch thick walls and a solid, enduring foundation. A newer roof (2023) adds confidence while honoring the integrity of the home's past. Beyond the residence, the land tells its own story. A collection of barns and outbuildings including a pegged Amish-built barn with 7 stalls and expansive loft, a historic tobacco barn with stripping room and hay storage, a traditional mule barn, utility barn, and additional run-in sheds create a setting ideal for equestrian pursuits, hobby farming, or a working agricultural operation. Rolling pastures and a scenic sheep field overlook the home, offering a setting that feels both private and cinematic--perfect for hosting events, gatherings, or simply enjoying the quiet beauty of the land. The E Bend Alpaca Shop (negotiable), complete with inventory, branding, name, and established database, introduces a turnkey business opportunity for those looking to blend lifestyle with income. With a natural water source, usable acreage, and an unmatched setting, this is not simply a home, it's a generational property. A place to preserve, to build upon, and to create something truly meaningful for years to come.

7812 E Bend Road, Burlington

$2,500,000

4 Beds ⋅ 7 Baths ⋅ 642050 MLS

Welcome to where Quiet Grandeur Meets Natural Beauty! In the exclusive enclave of Waterford Estates, discover a residence defined by finesse, privacy, and quiet distinction. Set amidst nearly 10 acres of pristine woodland and curated gardens, this remarkable estate is a true sanctuary. Expansive interiors transition seamlessly to multiple outdoor living spaces. Masterfully designed with custom craftsmanship throughout featuring an exquisite layout with updates on all levels, 5 fireplaces, custom builtins, 2 offices/study, all en-suite bedrooms, extensive finished lower level with full kitchen, custom bar, game area & possible fifth/sixth bedrooms. A magical pool highlights the property with cascading waterfall & hot tub, two beautiful gazebos (one screened in) off the decking and a serene four-seasons room that extends the experience of creating intimate spaces for relaxation or celebration. A refined carriage house adds flexibility for guests & creative ventures including additional storage and garage space. Prime location, pleasantly convenient to shopping, dining, I-71/75, CVG Airport & Downtown Cincinnati. Here, life unfolds with grace...elevated, intentional and timeless!

1960 Edenderry Drive, Fort Mitchell

$2,500,000

3 Beds ⋅ 1 Baths ⋅ 638625 MLS

Exceptional 187+/- Acre Farm*Discover the perfect blend of natural beauty, tranquility & functionality with this farm*Nestled in a serene, country setting, this property features rolling pastures, wooded areas & tons of super highway trails, offering an idyllic retreat for farming, recreation or development*The land is graced with multiple ponds, enhancing both the scenery & utility for livestock or wildlife*A charming, modest 3-bedroom farmhouse sits at the heart of the property, offering a cozy place to call home or a perfect base for weekend getaways. Whether you choose to renovate the farmhouse or build your dream estate, the opportunities here are endless. With its rich, fertile soil & abundant water sources, this property is ideal for agricultural use, livestock, or equestrian pursuits*The wooded sections & natural water features make it a haven for outdoor enthusiasts, providing excellent opportunities for hunting, fishing, hiking, or simply enjoying the peaceful surroundings*Located in a private yet convenient area, this farm offers easy access to the expressway while providing the space & privacy you crave.

3386 Ky-467, Glencoe

$2,500,000

5 Beds ⋅ 6 Baths ⋅ 1848112 MLS

Magnificent Tudor Estate on 42+ secluded acres, reminiscent of the Biltmore in Asheville. Elegant interior has grand room sizes, paneled wood walls, beautiful hardwood and slate flooring. 2015 kitchen remodel by Dahlman & Bohl. Stunning great room with wood paneled ceiling walks out to patio and pool. Primary suite boasts luxury bath & walk-in closet with abundant built-ins. Panoramic vistas. Carriage house with apartment. Garage space for 12 cars. Tennis Court. Unbelievable entertaining options. Extensive List of Improvements in Other Documents.

1104 Us Rt 52, Ohio Twp

$2,499,900

3 Beds ⋅ 2 Baths ⋅ 1876407 MLS

Opportunities at large tracts that are 90% tillable are hard to come by and this 151 Acres in Brown County checks that box and more. Paired with a newly renovated 3 Bedroom, 2 Full Bath, Home w/ 2 car attached garage, multiple outbuildings, approximately 135 tillable acres and nearly 1.5 miles of blacktop road frontage! Updates include a New HVAC system, 40 yr metal roof and porch ceilings, updated kitchen w/ new cabinets, countertops, appliances, and flooring throughout. Beyond the house is a 64x48 Metal Pole Barn w/ 40x48 finished concrete floor shop w/ electric, 14x12 opening w/ sliding doors and 12x9 garage door on the front w/ remainder of barn open in the back, and a 60x90 older barn nearby as well. Conveniently located just 1 mile from SR 32, 1/3 of a mile from US 62, and 8 miles to Russellville. Rare combination of high percentage income producing tillable w/ great access that would be ideal for farming or investment!

11732 Martin Alexander Road, Eagle Twp

$2,499,000

4 Beds ⋅ 4 Baths ⋅ 1887127 MLS

Modern farmhouse meets luxury retreat at this like-new, 2-year-old estate. Set on a beautifully landscaped property with its own private pond, fountain, and one-of-a-kind entertainment barn, this 4-bedroom, 3.5-bath home offers the perfect blend of sophistication, comfort, and privacy. Inside, an open floor plan is anchored by a chef-inspired kitchen featuring premium appliances, quartz countertops, and an oversized center island designed for effortless entertaining. Vaulted ceilings, and sun-filled living spaces create an inviting atmosphere, while the first-floor primary suite offers a private retreat for everyday living. Step outside to a resort-style pool and expansive patio overlooking tranquil pond and countryside views. The standout feature is the custom entertainment barncrafted as the ultimate gathering space with a bourbon bar, wine-tasting area, and inviting lounge designed for unforgettable evenings with family and friends. Every detail has been thoughtfully curated.

4640 St Rt 133, Jackson Twp

$2,499,000

4 Beds ⋅ 5 Baths ⋅ 1877589 MLS

With 6,314 sq ft of beautiful living space + 8000 additional sq ft for all your horses, tack & toys, this meticulously maintained equestrian property is specifically designed & equipped to cater to the needs of horses & their owners. This ranch was originally built in 1878, rebuilt in 1984 & today shows elegant enhancements, all sitting on a peaceful countryside setting of 5.92 acres. Designed w/a warm, rustic ambiance surrounded by custom-hewn wood floors, exposed beams & quality millwork w/5 bedrooms, 4 full baths & 1 half bath. Includes a 1,728 sq ft insulated all-steel 6 horse barn w/ year-round walkouts, wash stall, sand arena & rotating pastures. For the horse owner there is a beautiful in-ground pool, massive new deck, fishpond & a fully occupied happy chicken coop for a true ranch lifestyle. Located 1.5 miles from Historic Milford & only 13 miles from downtown Cincinnati, this ranch is in the Milford SD & 35 mins from CVG.

675 Hobby Horse Lane, Miami Twp

$2,490,000

5 Beds ⋅ 4 Baths ⋅ 1887671 MLS

Spectacular architectural transformation on executive lot of prestigious South Drake Road. Experience the perfect fusion of dramatic craftsmanship and natural serenity in this fully reimagined gem. Open concept living where rustic warmth meets contemporary sophistication. Walls of windows flood the house with natural light and views of the gorgeous lawn and magnificent historical trees. Featuring a luxurious chef's kitchen and a seamless flow into stone and custom carpentry at every turn. Complete with inground swimming pool, pool house, horse barns and professional equine arena. An ideal park like sanctuary for an Indian Hill Family to cherish for years. The Owner is a licensed realtor and kichen/bath designer.

5025 Drake Rd, Indian Hill

$2,450,000

3 Beds ⋅ 2 Baths ⋅ 644603 MLS

Luxury Modern Farmhouse Estate 110 acres with additional 143 acres available, accessed by private 1/2 mile paved drive, this exceptional sanctuary offers a stunning custom timberframe, ultra efficient geothermal home with 4+car garage and 40x64 premium shop with lake views, soaring ceilings, chef's kitchen, complete privacy surrounded by a stocked 3 acre lake, ~5 miles of trails, 20 years of land management for cultivating trophy whitetail deer and wild turkey, mature timber, rolling pasture, and abundant wildlife. Located just 30 miles from Louisville and 45 miles from Cincinnati, the property delivers the perfect balance of privacy and convenience, creating the potential for a remarkable 253-acre legacy property with recreational enjoyment (hunting/fishing,hiking, ATV,horseback riding).

1093 Sulphur Bedford Road, Bedford

$2,450,000

5 Beds ⋅ 7 Baths ⋅ 644597 MLS

Elegant European Manor Estate with Subtle French Provincial Influences, Set on 3.6 Beautiful Landscaped Acres & Offering Over 11,500+ SQ FT w/ Three Finished Levels. A Stately Brick & Stone Exterior, Defined by Arched Windows, Limestone Accents, & a Circular Drive Anchored by a Grand Multi-Tiered Fountain, Creates a Striking & Unforgettable Arrival. Inside, a Dramatic Two-Story Foyer with Sweeping Curved Staircase, Marble Flooring, & 10-Foot Mahogany Entry Door with Leaded Glass & Arched Transom Sets the Tone for Exceptional Craftsmanship. Exquisite Millwork, Elaborate Moldings, Statement Fireplaces, & Custom Bars are Complemented by Architectural Elements Sourced from Abroad. The Sunken Great Room is a True Showpiece with Hand-Finished Oak Paneling, Triple Arched Windows, & an Inglenook Fireplace Inspired by Ashford Castle in Ireland. The Kitchen Blends Warmth & Refinement with Custom Cabinetry, European Tile Accents, Generous Island, & Extraordinary Butler's Pantry with Illuminated Glass Display Cabinetry & Leaded Glass Transom. The Adjoining Keeping Room Features a Soaring Stone Fireplace & Reclaimed Beams, Creating a Dramatic Gathering Space with Old-World Charm. A Breathtaking Conservatory, Imported from England & Assembled by Craftsmen, Features a Vaulted Glass Ceiling & Panoramic Garden Views. A Screened Porch Extends Outdoor Living. The Home Offers 5-6 Bedrooms, 7 Baths, & 2 Studies. A Private Art Studio Apartment Above the Four-Car Garage Offers Flexibility for Guests or Creative Use. Outdoor Living Includes a Resort-Style In-Ground Pool with Limestone Coping & Lion Head Fountain, Cabana, Firepit, Curated Gardens, Chef-Inspired Herb & Vegetable Garden, Raised Beds, Winding Stone Paths, & a Waterfall-Fed Goldfish Pond with Stone Bridge, Creating a Serene Setting. Located Minutes from CVG Airport & Downtown Cincinnati, w/i the Award-Winning New Haven Elementary, Gray Middle, & Ryle High School District. See Photo Descriptions for Additional Detail.

12274 Gaines Way, Walton

$2,400,000

4 Beds ⋅ 5 Baths ⋅ 641905 MLS

Welcome to your new Riverview lifestyle. Have you always dreamed of building your custom home on the river with breathtaking panoramic views? That opportunity has arrived. Discover Rivers Pointe Estates -- a premier master-planned community offering miles of scenic walking trails, protected conservation areas, and amenities unlike anything else in the region. Enjoy the perfect balance of privacy and convenience, just minutes from the airport, major interstates, and downtown Cincinnati. Now is the time to secure your homesite and begin designing the riverfront home you've always envisioned. HOME SHOWN IS FOR DEPICTION ONLY. THIS WOULD BE NEW CONSTRUCTION!!! Schedule your private tour today and start building your dream.

1 Rivers Pointe Drive, Hebron

$2,400,000

4 Beds ⋅ 5 Baths ⋅ 641285 MLS

Welcome to the former model home in the breathtaking Park Pointe Development. This Exceptionally Designed Home Offers Exquisite Panoramic Views of Downtown Cincinnati from Multiple Levels. Spacious Open Concept and Soaring Ceilings Enhance this Unique Floor Plan. The Sleek, Modern Design is Ultra Flexible - Offers 4 Bedrooms, 3.5 Bath, Chef's Kitchen with Luxury Gourmet Appliances, Stunning Quartz Waterfall Island, Designer Lighting & Plumbing Fixtures, Expansive Cabinetry, Appliance Garage, Huge Pantry, Wet Bar, Study, Flex Room, Finished Lower Level, and a 3 Car Tandem Garage. The Built-in Elevator makes this Floor-plan Easily Accessible at Any Level. Outdoor Living Space Features a Gas Fireplace and a Built-in Gas Grill - Perfect for Entertaining Family and Friends! For further details or to schedule a private tour, please contact listing agents.

1164 Vistapointe Drive, Park Hills

$2,400,000

4 Beds ⋅ 5 Baths ⋅ 1865570 MLS

Homearama 2026 Showcase Estate. Designed and built by Eagle Custom Homes, this timeless estate offers 6,000 SF of refined living on 2 private acres, delivering classic architecture paired w/thoughtful modern livability. Featuring three spacious bdrm suites on the main level, each with its own on-suite bath for comfort and privacy. Ten-foot ceilings throughout enhance the home's openness and natural light, while the chef's kitchen - appointed w/Thermador appliances and quartz countertops -is paired w/dedicated Scullery ideal for food prep, caterers, and keeping the main kitchen pristine while entertaining. Refined architectural detailing, abundant light, and a seamless connection to the private covered outdoor porch elevate the Great Room and main-level living experience. Oversized 4-car gar offers exceptional space, storage and access to LL, while the home's timeless materials and carefully curated finishes reflect the craftsmanship expected in a Homearama showcase estate. Agent/Owner

9750 Christian Court, Hamilton Twp

$2,334,225

4 Beds ⋅ 3 Baths ⋅ 642504 MLS

The Wilshire is a one-of-a-kind architectural marvel. The moment you step inside, you will be greeted by soaring 11-foot ceilings, with special areas featuring tray ceilings and exposed wood beams. The gourmet kitchen is truly exceptional, boasting an oversized island that's perfect for both cooking and gathering. It also includes a dedicated dining area and a butler's pantry that is sure to impress. A lovely powder room and guest closet are conveniently located on the first level, a private study or flex room is tucked away off the dining area. The primary wing offers a private sanctuary, complete with a spacious bedroom, a luxurious ensuite bathroom, and a large custom walk-in closet. For added convenience, the primary suite is located next to the laundry room. The great room opens to a magnificent, covered porch, which features its own fireplace. This outdoor space is perfect for entertaining all year round. The lower level provides additional living space, featuring two to three bedrooms, a full bathroom, and a large recreation room that opens to a covered patio. You will also find numerous storage areas throughout. Additional features include a family entrance from the garage with extra storage for coats and off-season gear

2740 River Birch Drive, Villa Hills

$2,300,000

3 Beds ⋅ 6 Baths ⋅ 1878266 MLS

Set on 23 breathtaking acres, this extraordinary estate embodies the pinnacle of luxury living, exceptional craftsmanship, and serene natural beauty. Thoughtfully curated with the finest materials and high-end finishes throughout, every detail reflects a commitment to quality and timeless design. The main residence showcases expansive, light-filled interiors that strike a perfect balance between sophistication and comfort. A separate cottage and barn enhance the property's versatility, with the barn presenting an exceptional opportunity for equestrian use - easily convertible and surrounded by sweeping, level pastureland. Whether you envision a refined private retreat, an equestrian haven, or a peaceful escape immersed in nature, this remarkable property offers an unparalleled lifestyle experience. *Cottage and Barn specs are not included in the listing.

1865 State Route 247, Hillsboro

Ask Us About Our Office Listings

Featured Properties