Refine Search
Sort by
$2,799,000
4 Beds 5 Baths 1892301 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 1892245 MLS
Pics coming soon. Set amid 42 acres of pristine grounds, this distinguished Tudor estate embodies timeless architecture, gracious proportions and enduring elegance, with select views toward the river. Offering over 7,000 sq. ft., the residence is defined by grand, oversized rooms, exquisite hardwood floors and exceptional craftsmanship. The impressive chef's kitchen is designed for both everyday living and elegant entertaining, while the luxurious primary suite features a beautifully appointed bath and remarkable dressing closet. A game room provides additional space to gather and entertain. Immerse yourself in the saltwater pool and enjoy your own tennis/pickleball courts. The stately carriage house offers a private apartment and substantial garage space, it also offers exceptional versatility for guests, a collector's garage or additional pursuits. Thoughtful improvements complement the character of this exceptional country estate. Proof of funds or preapproval required for showing

1104 Us Rt 52, Ohio Twp

$2,750,000
4 Beds 5 Baths 1888900 MLS
Set on 10 acres, this custom home offers refined design, complete privacy, & spaces created for gathering. Craftsmanship takes center stage with quarter sawn white oak floors, soaring 11 ft ceilings & a level of quality that is rare. The home's open interior provides warmth & flows beautifully from one space to the next, anchored by a professionally appointed kitchen with premium appliances & finishes worthy of its surroundings. 4 spacious bedrooms and 3.5 baths provide comfort + flexibility, while every room reflects the attention to detail found throughout the home. Outdoors, the gunite saltwater pool anchors an exceptional backyard retreat complete with a separate pool house that offers endless possibilities for overnight guests, multigenerational living, a private office or extended entertaining space. With attached & detached garages, there'ss room for vehicles, recreational equipment, & storage, & the surrounding acreage offers freedom + privacy without sacrificing convenience.

3556 Centerville Road, Sugarcreek Twp

$2,750,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,750,000
5 Beds 6 Baths 1862002 MLS
9798 Christian Court is completed! 2026 Homerama - A rare opportunity to own a premier John Hill Construction custom estate. Experience luxury and craftmanship in this stunning home situated on a picturesque two-acre homesite in Bothe Farms. Enjoy expansive outdoor living all just 3 miles from all that downtown Loveland has to offer. The Legacy, a 7000 square foot home, offers thoughtfully planned living spaces, including a first-floor primary suite and a second main-level ensuite bedroom ideal for guests. A few notable features include: butler pantry, zero-step entry from the garage, dog shower, outdoor covered living area with fireplace and grill, beautiful architectural designs and designer finishes. Pictures and video available to interested buyers, contact listing agent. Take advantage of over $150K in Homearama discounts.

9798 Christian Court, Hamilton Twp

$2,675,000
1889362 MLS
Attention investors! This tax-saving portfolio is an LLC containing 12 spectacular single-family homes and is now available! Buy the LLC and pay less fees! Each home has been meticulously well maintained, updated, leased, and presents a highly profitable, long-term, low-risk asset for your portfolio, collectively priced well below their market value-instant income, instant equity! Most homes are centrally located within a few minutes of each other for added convenience. Opportunity Proposal, additional information for each property, and financial information available upon request. Addresses included: 2638 Allaire Ave, 3401 Blue Rock Rd, 9149 Depalma Dr, 3315 Lapland Dr, 3257 Lapland Dr, 5281 Orchardridge Ct, 3154 Rockacres Dr, 9031 Round Top Rd, 1149 Jennie Lane, 5470 Vogel Rd, 5941 Willow Oak, and 3442 Jessup Rd.

5281 Orchardridge Court, Green Twp

$2,622,000
3 Beds 5 Baths 1890576 MLS
Welcome to Sandymar Drive, one of Sycamore Township and Indian Hill schools' premier streets. This homesite is the exceptional opportunity you've been waiting for to design a new luxury home with J&K Custom Homes on a rare wide, estate-like lot, seconds from Montgomery, Kenwood Town Center and the Village of Indian Hill. This unique loop neighborhood-style street feels private yet inviting. The lot offers a secluded, wooded backdrop with a creek winding along the rear. The thoughtful design pairs timeless architecture with modern living, featuring a 1st flr primary suite, expansive kitchen and great room, scullery, private study, screened deck with fireplace and an amazing view of the woods, mudroom and separate 2 and 1-car garages. Upstairs are two generous bedroom suites. The lot was recently cleared. Construction to begin fall 2026. There is still time to personalize the plan. Curious what the finished interiors could look like? Ask for details on other recently completed J&K Homes!

8800 Sandymar Drive, Sycamore Twp

$2,600,000
620712 MLS
**Development Land Tract in Williamstown, KY** Welcome to an unparalleled opportunity in the heart of Williamstown, Kentucky. This pristine development land tract presents a strategic investment in a prime location, poised for transformative growth. Spanning acres of untapped potential, this development land offers a blank canvas for visionary developers and investors. Situated amidst scenic landscapes and growing infrastructure, it promises an ideal setting for residential, commercial, or mixed-use projects. With immediate access to interstate I-75 and urban amenities, this parcel is a gateway to endless possibilities. Explore the boundless prospects for expansion and innovation on this promising plot of land in Williamstown. Seize the chance to shape the future of this thriving community with this exceptional development land tract. Inquire now to embark on a journey towards unlocking the full potential of this prime real estate opportunity!

1445 Barnes Road, Williamstown

$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
638627 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 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
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
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,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,495,000
1881568 MLS
Approximately 50acres offering a rare blend of open, usable land and natural beauty in a highly desirable location. Expansive clearings provide ideal space for pasture, crops, or a private estate, while approximately 21 acres of mature woods add privacy and scenic appeal. The property is bordered by tree lines on three sides, creating a peaceful, secluded setting. Benefiting from silty soils that promote natural drainage, the land allows for efficient runoff toward Todds Fork Creek, an advantage for agricultural use and land management. The creek winds through the south eastern portion, enhancing the landscape with opportunities for recreation, wildlife, and conservation. With ~135 feet of road frontage, access and future potential are well supported. Located just 15 miles from downtown Loveland and only 6 miles to Fort Ancient Eartworks & Nature Preserve, this exceptional acreage offers a unique opportunity to create, invest, or preserve.

Roachester Road, Salem Twp

$2,450,000
3 Beds 4 Baths 646602 MLS
Boutique waterfront living experience that rises above the rest. Unobstructed city and river views from two balconies, one partially covered. All new, custom built in 2021, this luxurious home features an expansive, light filled floorplan with 3,409 square feet. It showcases 9 ½ ft. ceilings, French white oak wood flooring throughout, walls of glass, custom moldings and millwork, Hunter Douglas Powerview Smart Shades. Phillips Hue smart lights. A long list of features is included in 'additional features.' World-class amenities including a superb clubhouse, exercise room, and a pool that will make your friends envious. 24 hour doorman, bicycle garage, great walkability. The Purple People Bridge, Newport on the Levee, Bellevue and the Hofbrauhaus are all just a short walk away. Luxury endures and this refined, sophisticated home will enliven your senses every time you walk through the door. Yearly Pilot Program Taxes $33,575.00. Agents please see agent remarks regarding showings.

400 Riverboat Row, Newport

$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
3 Beds 4 Baths 643959 MLS
Experience Luxury Penthouse Living at its finest in the prestigious SouthShore community, where breathtaking panoramic Cincinnati skyline views take center stage! This extraordinary 3-bedroom, 3.5-bath residence offers nearly 4,500 square feet of sophisticated open-concept living designed to seamlessly blend indoor elegance with outdoor enjoyment. Showcasing exceptional craftsmanship and high-end finishes throughout, this stunning home features Italian marble flooring, 10'+ ceilings, floor-to-ceiling windows, a designer chef's kitchen with premium appliances and custom wood cabinetry, spa-inspired baths, Control4 smart home automation, surround sound throughout, programmable automatic shades, custom built-ins/closets, tankless water heater, newer HVAC, and a Murphy bed for added flexibility. Three expansive covered terraces--including a built-in gas line for grilling--provide the perfect setting for entertaining while enjoying spectacular river and skyline views. Residents enjoy world-class amenities including a resort-style pool and spa, fitness center, clubhouse, outdoor firepit, Zen garden, bicycle garage, and secure building with 24/7 attendant service. Additional RARE luxuries include Four Dedicated Parking Spaces, an electric vehicle charging station, three private storage units, and an exclusive heated workshop. Ideally located just steps from Newport on the Levee, downtown Cincinnati, premier dining, entertainment, sporting venues, and shopping--complete walkability. A truly one-of-a-kind opportunity to own one of Northern Kentucky's most impressive luxury residences!

400 Riverboat Row, Newport

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.