My Company's Active Listings
$5,200,000 (USD)
Park Pointe Area Single Family Home
Active
1152 Bellavista Drive Park Hills, KY 41011
4 Bed
5 Baths
5604 sqft
MLS# 642814
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!
Listing Courtesy of NORTHERN KENTUCKY / Listed By: Tasha Klaber-Flood, Florence
$3,995,000 (USD)
Maysville Area Land
Pending
0 W Maple Leaf Road Maysville, KY 41056
Bed
0 Baths
sqft
MLS# 602056
Great location across from Walmart to develop 41+ acres! 2 Access points on West Maple Leaf Rd and 1 at intersection on AA Highway at entrance to Walmart
Listing Courtesy of NORTHERN KENTUCKY / Listed By: Pat Tenoever, Voice Of America
$3,885,000 (USD)
Indian Hill Area Single Family Home
Active
6650 Alberly Lane Indian Hill, OH 45243
5 Bed
6.2 Baths
8652 sqft
MLS# 1881460
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.
Listing Courtesy of 
CincyMLS / Listed By: Julie Back, Hyde Park
CincyMLS / Listed By: Julie Back, Hyde Park
$3,799,000 (USD)
Indian Hill Area Single Family Home
Pending
6655 Alberly Lane Indian Hill, OH 45243
6 Bed
6.2 Baths
9177 sqft
MLS# 1888419
Beautifully situated on 3.561 private acres surrounded by mature trees, this exceptional home offers open spaces & light-filled rooms with hardwood floors. The newer kitchen has top-of-the-line appliances & oversized center island, opening to the family room with built-ins, fireplace & wood-beamed ceiling. The main living room features a voluminous ceiling, fireplace & wall of French doors to the patio. Private study with fireplace & custom shelving. Serene primary suite with custom walk-in closet & luxe bath. Finished lower level offers rec areas, exercise room, office/bedroom, bar & wine cellar. Outdoor living is spectacular & is a private oasis with a large patio & covered porches overlooking the heated pool & hot tub, gazebo, outdoor fireplace & putting green. Pool house with grilling area & bath. Aerated pond. Nine-car garage! Offers open for 48 hours. No escalation clauses.
Listing Courtesy of CincyMLS / Listed By: Julie Back, Hyde Park
CincyMLS / Listed By: Julie Back, Hyde Park
$3,795,000 (USD)
Cincinnati Area Single Family Home
Active
20 Grandin Lane Cincinnati, OH 45208
5 Bed
4.1 Baths
6710 sqft
MLS# 1886392
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.
Listing Courtesy of CincyMLS / Listed By: Beth Bokon Onthank, Kenwood
CincyMLS / Listed By: Beth Bokon Onthank, Kenwood
$3,600,000 (USD)
Indian Hill Area Single Family Home
Pending
5 Old Orchard Lane Indian Hill, OH 45242
4 Bed
4.2 Baths
5791 sqft
MLS# 1881664
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.
Listing Courtesy of CincyMLS / Listed By: John Hensley, Kenwood
CincyMLS / Listed By: John Hensley, Kenwood
$3,500,000 (USD)
Indian Hill Area Single Family Home
Pending
6225 Redbird Hollow Lane Indian Hill, OH 45243
5 Bed
4.2 Baths
2549 sqft
MLS# 1814766
Build your dream home in this 5-acre private setting! Custom touches, hardwood floors & high-end appliances. Enjoy a covered rear porch & sun patio. Impressive chef's kitchen. Serene primary suite. Select our plan or bring your own ideas!
Listing Courtesy of CincyMLS / Listed By: Julie Back, Hyde Park
CincyMLS / Listed By: Julie Back, Hyde Park
$3,100,000 (USD)
Hamilton Twp Area Single Family Home
Active
9822 Christian Court Hamilton Twp, OH 45140
4 Bed
5.2 Baths
0 sqft
MLS# 1876176
Unparalleled 2026 Homearama Showcase estate by Old World Custom Homes, offering approx. 6,750 sqft of meticulously designed living space on 2+ exclusive acres. 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 heated and cooled gym space provides year round comfort and flexibility. Offerings of this caliber do not come often - designed to impress, a statement in craftsmanship & ready for life lasting memories.
Listing Courtesy of CincyMLS / Listed By: Adam Schupp, Northwest
CincyMLS / Listed By: Adam Schupp, Northwest
$2,900,000 (USD)
Indian Hill Area Single Family Home
Pending
7795 Graves Road Indian Hill, OH 45243
4 Bed
4.1 Baths
2012 sqft
MLS# 1889312
Under contract before sent. Custom Home by Joshua One Builders Being built for the buyers.
Listing Courtesy of CincyMLS / Listed By: Julie Back, Hyde Park
CincyMLS / Listed By: Julie Back, Hyde Park
$2,800,000 (USD)
Indian Hill Area Single Family Home
Pending
5475 Waring Drive Indian Hill, OH 45243
6 Bed
4.3 Baths
7351 sqft
MLS# 1886131
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!
Listing Courtesy of CincyMLS / Listed By: Katie Cousino, Kenwood
CincyMLS / Listed By: Katie Cousino, Kenwood
$2,795,000 (USD)
Cincinnati Area Single Family Home
Pending
9 Old Orchard Ln 13 Cincinnati, OH 45242
5 Bed
4.1 Baths
sqft
MLS# 1723732
Back on the Market. Custom Design a Home at the Meadows of Peterloon with Copper Creek Homes. Take advantage of this exclusive opportunity. Amazing amenities and high end finishes can be chosen. Builder glad to design to buyers taste, square footage, price and lifestyle. Schedule a meeting to investigate all the possibilities. Fabulous flat lot, Walk-ability to Montgomery shops and restaurants. The lot is $1,295,000 if buyer wants to use a different builder.
Listing Courtesy of CincyMLS / Listed By: Julie Back, Hyde Park
CincyMLS / Listed By: Julie Back, Hyde Park
$2,750,000 (USD)
Hamilton Twp Area Single Family Home
Active
9798 Christian Court Hamilton Twp, OH 45140
5 Bed
5.1 Baths
0 sqft
MLS# 1862002
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.
Listing Courtesy of CincyMLS / Listed By: Scott Richards, Kenwood
CincyMLS / Listed By: Scott Richards, Kenwood
$2,750,000 (USD)
Indian Hill Area Single Family Home
Active
8625 Fawnmeadow Lane Indian Hill, OH 45242
5 Bed
6.1 Baths
10229 sqft
MLS# 1887603
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!
Listing Courtesy of CincyMLS / Listed By: Katie Cousino, Kenwood
CincyMLS / Listed By: Katie Cousino, Kenwood
$2,499,000 (USD)
Newport Area Condo
Active
400 Riverboat Row Newport, KY 41071
3 Bed
4 Baths
4352 sqft
MLS# 643959
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!
Listing Courtesy of NORTHERN KENTUCKY / Listed By: Chris Kennedy, Florence
$2,450,000 (USD)
Washington Area Land
Active
8873 US 50 Aurora, IN 47001
0 Bed
0 Baths
0 sqft
MLS# 204194
175 +/- acres of beautifully zoned residential property. 6/10 mile of road frontage. Property also has a 1350 square foot bedford stone home that needs some work. Lots of wildlife! Great investment opportunity.
Listing Courtesy of SE INDIANA / Listed By: Brett Fehrman, Lawrenceburg
$2,400,000 (USD)
Dover Area Land
Active
480 Ac Dietrich Road Dover, KY 41034
Bed
0 Baths
sqft
MLS# 643745
Untouched potential...on an incredible 480-acre tract in highly desirable Mason County, Kentucky. Opportunities of this size and quality are becoming increasingly difficult to find, especially in a location that offers both privacy and convenience. Whether you're looking for a premier hunting property, working farm, recreational retreat, investment opportunity, or the perfect setting to build your dream home, this property offers the scale, diversity, and versatility to make it happen.
The land features a strong combination of productive tillable acreage, mature timber, open fields, rolling terrain, and established trail systems that provide access throughout much of the property. Multiple ponds are scattered across the farm, creating excellent water sources for wildlife, livestock, and recreational enjoyment. The layout of the property offers outstanding habitat for deer, turkey, and other wildlife, while the mix of woods and open ground creates countless opportunities for food plots, hunting setups, and land management improvements.
Several existing tobacco barns and fencing add both character and functionality to the farm. A driveway already extends into the property, allowing convenient access from the road and making it easy to navigate and utilize the acreage. The property consists of one large primary tract along with two additional parcels located up the road, providing additional road frontage and future flexibility for a variety of uses.
A recent survey has been completed, providing buyers with added confidence and a clear understanding of the property's boundaries and layout. With its size, road frontage, existing infrastructure, and diverse landscape, this farm offers unlimited possibilities for agricultural, recreational, residential, and investment purposes.
Properties of this caliber rarely become available in Mason County. Whether your vision includes farming, hunting, ATV riding, horseback riding, timber management, family recreation, a
The land features a strong combination of productive tillable acreage, mature timber, open fields, rolling terrain, and established trail systems that provide access throughout much of the property. Multiple ponds are scattered across the farm, creating excellent water sources for wildlife, livestock, and recreational enjoyment. The layout of the property offers outstanding habitat for deer, turkey, and other wildlife, while the mix of woods and open ground creates countless opportunities for food plots, hunting setups, and land management improvements.
Several existing tobacco barns and fencing add both character and functionality to the farm. A driveway already extends into the property, allowing convenient access from the road and making it easy to navigate and utilize the acreage. The property consists of one large primary tract along with two additional parcels located up the road, providing additional road frontage and future flexibility for a variety of uses.
A recent survey has been completed, providing buyers with added confidence and a clear understanding of the property's boundaries and layout. With its size, road frontage, existing infrastructure, and diverse landscape, this farm offers unlimited possibilities for agricultural, recreational, residential, and investment purposes.
Properties of this caliber rarely become available in Mason County. Whether your vision includes farming, hunting, ATV riding, horseback riding, timber management, family recreation, a
Listing Courtesy of NORTHERN KENTUCKY / Listed By: Madison Eisenman, Campbell County
$2,400,000 (USD)
Park Pointe Area Single Family Home
Active
1164 Vistapointe Drive Park Hills, KY 41011
4 Bed
5 Baths
0 sqft
MLS# 641285
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.
Listing Courtesy of NORTHERN KENTUCKY / Listed By: Chris Kennedy, Florence
$2,395,000 (USD)
Cincinnati Area Single Family Home
Active
327 Oregon Street Cincinnati, OH 45202
4 Bed
4.1 Baths
0 sqft
MLS# 1727764
One of the very last unlimited 15-year tax abated platinum LEED residence in Cincinnati. Unique opportunity. Breathtaking urban panoramic vista of the City, river and park. Extraordinary handcrafted luxury finishes rarely found in today's residences. Open floor plan, Stunning roof top entertainment terrace. Construction has started on these 3 homes. Still time to make selections.
Listing Courtesy of CincyMLS / Listed By: Julie Back, Hyde Park
CincyMLS / Listed By: Julie Back, Hyde Park
$2,395,000 (USD)
Cincinnati Area Single Family Home
Active
329 Oregon Street Cincinnati, OH 45202
4 Bed
4.1 Baths
0 sqft
MLS# 1727766
One of the very last unlimited 15-year tax abated platinum LEED residence in Cincinnati. Unique opportunity. Breathtaking urban panoramic vista of the City, river and park. Extraordinary handcrafted luxury finishes rarely found in today's residences. Open floor plan, Stunning roof top entertainment terrace. Construction has started on these 3 homes. Still time to make selections.
Listing Courtesy of CincyMLS / Listed By: Julie Back, Hyde Park
CincyMLS / Listed By: Julie Back, Hyde Park
$2,395,000 (USD)
Cincinnati Area Single Family Home
Active
325 Oregon Street Cincinnati, OH 45202
4 Bed
4.1 Baths
0 sqft
MLS# 1727763
One of the very last unlimited 15-year tax abated platinum LEED residence in Cincinnati. Unique opportunity. Breathtaking urban panoramic vista of the City, river and park. Extraordinary handcrafted luxury finishes rarely found in today's residences. Open floor plan, Stunning roof top entertainment terrace. Construction has started on these 3 homes. Still time to make selections.
Listing Courtesy of CincyMLS / Listed By: Julie Back, Hyde Park
CincyMLS / Listed By: Julie Back, Hyde Park
$2,299,000 (USD)
Cincinnati Area Single Family Home
Pending
1318 Edwards Road Cincinnati, OH 45208
4 Bed
3.1 Baths
0 sqft
MLS# 1859732
A premier opportunity to create your custom dream home with Joshua One Builders. Create a one-of-a-kind residence perfectly tailored to your lifestyle. The existing home will be removed, allowing for a fully customized design, or select from our exceptional architectural plans. Flexible layouts can be designed to your specifications, including an optional first-floor primary suite and optional living space above the garage. Experience exquisite craftsmanship throughout, with luxury finishes, hardwood floors, chef-caliber appliances, and a 3-car garage. Tax abated and ideally located near the square, this property offers the ultimate blend of elegance, convenience, and modern living.
Listing Courtesy of CincyMLS / Listed By: Julie Back, Hyde Park
CincyMLS / Listed By: Julie Back, Hyde Park
$2,250,000 (USD)
Cincinnati Area Single Family Home
Active
11 Weebetook Lane Cincinnati, OH 45208
6 Bed
3.2 Baths
4520 sqft
MLS# 1878974
Welcome to 11 Weebetook Lane, an exceptional and rare opportunity to reimagine an existing home or create a new luxury residence in an unparalleled location. This residence has never before been publicly offered. Situated on one of Hyde Park's most coveted private lanes, the property boasts incredible views of downtown Cincinnati and the Ohio River. Whether you choose to renovate the existing home or design and build a custom residence, the setting provides an outstanding foundation for a truly distinctive home in one of Cincinnati's most desirable locations. The current residence includes six bedrooms, three full baths, and two half baths, along with a rear addition thoughtfully designed to capture the stunning views. An elevator services the home from the basement to the primary bedroom, enhancing both convenience & accessibility. Set on approximately 1.3 acres & backing to Hillside Trust property, 11 Weebetook Lane offers privacy, scale, and long-term value. House being sold AS IS.
Listing Courtesy of CincyMLS / Listed By: Elizabeth Burk, Hyde Park
CincyMLS / Listed By: Elizabeth Burk, Hyde Park
$2,200,000 (USD)
Burlington Area Land
Active
8185 Camp Ernst Road Burlington, KY 41005
Bed
0 Baths
sqft
MLS# 642626
There are places you drive past every day without ever realizing what lies beyond them.
Discover 63+ acres in the heart of Boone County where privacy, natural beauty, and convenience come together. Long held and largely untouched, this remarkable property offers a rare opportunity to experience the quiet character and open space of the countryside, just minutes from Union, top-rated Boone County schools, shopping, dining, the Boone County Arboretum, Camp Ernst Lake, and YMCA Camp Ernst. Leave the road behind and step onto the property. The noise fades, the trees close in, and for a moment, it feels like you are a thousand miles away. Maybe you picture a private estate, family retreat, recreational getaway, homestead, or simply a place to preserve and enjoy. Whatever you imagine there is room here to make it your own. Come walk the land, listen to the quiet, and discover a side of Boone County that few people ever get to experience. Showings by appointment only. No trespassing.
Discover 63+ acres in the heart of Boone County where privacy, natural beauty, and convenience come together. Long held and largely untouched, this remarkable property offers a rare opportunity to experience the quiet character and open space of the countryside, just minutes from Union, top-rated Boone County schools, shopping, dining, the Boone County Arboretum, Camp Ernst Lake, and YMCA Camp Ernst. Leave the road behind and step onto the property. The noise fades, the trees close in, and for a moment, it feels like you are a thousand miles away. Maybe you picture a private estate, family retreat, recreational getaway, homestead, or simply a place to preserve and enjoy. Whatever you imagine there is room here to make it your own. Come walk the land, listen to the quiet, and discover a side of Boone County that few people ever get to experience. Showings by appointment only. No trespassing.
Listing Courtesy of NORTHERN KENTUCKY / Listed By: Shannon Collins, Florence
$2,100,000 (USD)
Fairborn Area Land
Active
2998 Warner Road Fairborn, OH 45324
Bed
0 Baths
sqft
MLS# 872689
A Developer's Dream. Over eighteen prime acres located minutes from Rt# 675, WPAFB & Wright State University. Close to shopping & Rt# 75. Entrances on Bell Drive & Warner Rd. Potential residential homes, condominiums, apartments, or commercial businesses. Possibilities to divide. Includes one-half-acre residential lot on Bell Drive (Lot 77). Level Topography.
Listing Courtesy of DAYTON / Listed By: Sibcy Cline Inc.
$1,999,999 (USD)
Lebanon Area Single Family Home
Active
917 Clover Lane Lebanon, OH 45036
6 Bed
5.2 Baths
7503 sqft
MLS# 1880172
Exceptional home on 4.67 private acres with pristine landscaping, saltwater pool, pool house, and remarkable indoor/outdoor living spaces. Chef's kitchen features Viking gas cooktop, GE Monogram refrigerator, Thermador oven/microwave, cherry cabinetry, granite, island, counter bar, butler's pantry, and breakfast room walkout. First-floor primary suite offers sitting room with built-ins, dry bar, fireplace, dual custom walk-in closets, and walkout. Spa-like bath with soaking tub, walk-in shower, and dual vanities. Two-story great room with fireplace and built-ins, coffered-ceiling living room, formal dining room, dual staircases, and mudroom with built-in drop zones. Upstairs includes 4 bedrooms with ensuite/shared bath layouts and walk-in closets. Finished lower level with rec room, bar, exercise room, media room, and 6th bedroom or office with full bath. Pool house includes kitchen, bath, fireplace, and built-in jacuzzi. Stunning craftsmanship and luxury details throughout!
Listing Courtesy of CincyMLS / Listed By: Jenny Howard, Lebanon
CincyMLS / Listed By: Jenny Howard, Lebanon
$1,999,000 (USD)
Indian Hill Area Single Family Home
Active
4805 Drake Road Indian Hill, OH 45243
4 Bed
3.1 Baths
5780 sqft
MLS# 1892500
Privacy galore! This beautifully appointed home is framed by mature trees, lovely landscaping, and a long private drive. Light-filled rooms, hardwood floors, custom built-ins, and thoughtful details are showcased throughout. The family room walks out to the rear covered deck, while the bright white kitchen features patio doors all leading to the deck. The peaceful primary suite offers wooded views, a walk-in closet, and a luxe bath. The loft provides the perfect retreat for reading, studying, or relaxing. The finished lower level is filled with natural light and wooded vistas and includes a wet bar, generous entertaining spaces, and a full bath. Outdoor living is exceptional with a spacious rear deck, beautiful pool, and pool house complete with a kitchen and bath sure to be a favorite gathering spot during warmer months. Attached 3-car garage plus a detached garage offering 3 additional spaces. Offers open for 48 hours. No escalation clauses.
Listing Courtesy of CincyMLS / Listed By: Julie Back, Hyde Park
CincyMLS / Listed By: Julie Back, Hyde Park
$1,950,000 (USD)
Guilford Area Single Family Home
Active
20401 Platt Road Guilford, IN 47022
4 Bed
1.1 Baths
4158 sqft
MLS# 1885915
Escape to the peace of the countryside while staying just minutes from town. This stately 1830 brick home features 4 bedrooms and is filled with historic charm and character. Situated on 153 scenic acres spanning both sides of the road, the property offers breathtaking views, privacy, and endless possibilities. Ideal as a private estate, working farm, hunting retreat, or development opportunity, this unique property is ready to fit your vision. Whether preserving it as a legacy farm or transforming it into a luxury retreat or residential community, this is a rare opportunity to own a truly exceptional piece of land with unmatched beauty and potential.
Listing Courtesy of CincyMLS / Listed By: Myra Clary, Lawrenceburg
CincyMLS / Listed By: Myra Clary, Lawrenceburg
$1,850,000 (USD)
Montgomery Area Single Family Home
Active
10820 Deerfield Road Montgomery, OH 45242
4 Bed
3.1 Baths
2030 sqft
MLS# 1891208
Welcome to a truly exceptional nature setting in the heart of Montgomery! Located directly adjacent to Johnson's Nature Preserve, this property offers an incredible backyard setting with nature,privacy,and endless opportunities to enjoy the outdoors!Build this thoughtfully designed Ranch home or work with Robert Lucke Homes to create your own custom Ranch or Two-Story design.This plan offers effortless one-level living with additional finished Lower Level space,high-end finishes,and a covered rear porch featuring a stunning stone fireplace overlooking the flat/wooded yard.Enjoy beautiful brick sidewalks that connect you to Montgomery's parks and neighborhoods!. An exceptional location and a rare opportunity to build your dream home with Robert Lucke Homes surrounded by nature!
Listing Courtesy of CincyMLS / Listed By: Andrea & Linda deStefano, Montgomery
CincyMLS / Listed By: Andrea & Linda deStefano, Montgomery
$1,815,900 (USD)
Blue Ash Area Single Family Home
Pending
5194 Arabella Circle Blue Ash, OH 45242
3 Bed
3.2 Baths
0 sqft
MLS# 1878414
A true showcase of what's possible in Arabella at Summit Park, this extraordinary custom home by WP Land Company blends stately architecture with thoughtful design across 4,700+ square feet. Designed for everyday living and elevated entertaining, the home features a rare true 3-car garage, first-floor guest suite, and expansive mudroom. Multiple outdoor terraces create seamless indoor-outdoor living throughout. The second floor highlights an exquisite primary suite, additional en-suite bedroom, and dedicated study. The third floor is the heart of the home with an impressive custom kitchen, dining area, and expansive living spaces filled with natural light. The top level delivers an entertainer's dream with a full indoor bar, media room, rooftop terrace with automatic screens, and exceptional gathering spaces. An incredibly custom residence pushing design, function, and entertaining to another level. Lot 3 Phase 2.
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery
$1,800,000 (USD)
Madeira Area Single Family Home
Pending
5804 Hickory Court Madeira, OH 45243
4 Bed
5.2 Baths
0 sqft
MLS# 1820727
Under contract before sent. 100% custom designed home By Joshua One Builders at Windridge Estates. Beautiful Home with open spaces, Designer kitchen, high end finishes, Hardwood flooring thru out. Fabulous porch with fireplace & motorized screens. Lower level walk out. Great Location, wooded lot, walkable neighborhood.
Listing Courtesy of CincyMLS / Listed By: Julie Back, Hyde Park
CincyMLS / Listed By: Julie Back, Hyde Park
$1,777,913 (USD)
Cincinnati Area Single Family Home
Pending
4452 Thirty Second Avenue Cincinnati, OH 45209
4 Bed
3.2 Baths
0 sqft
MLS# 1886169
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery
$1,750,000 (USD)
Cincinnati Area Single Family Home
Active
1826 Elm Street Cincinnati, OH 45202
2 Bed
2.1 Baths
3656 sqft
MLS# 1862396
Award-winning renovated historic row house and striking new in-fill addition conveniently located near Findlay Market in the heart of Over-the-Rhine. Winner of the 2020 Cincinnati Design Award in Building Residential Architecture. This LEED Platinum, tax-abated residence has two bedrooms & an office that easily converts to a 3rdbedroom with its own private deck. Light-filled rooms feature Maistri Italian cabinetry, Thermador appliances, granite counters, & radiant-heated floors. A custom white-oak staircase, Lutron lighting and power blinds, Sonos sound, whole-house water filtration, & three high-efficiency HVAC systems enhance everyday comfort. An elevator serves all levels, including the LL wine storage area. Over 1200 SF of outdoor spaces, including a private courtyard with Corten steel planters & two rooftop terraces with views of Findlay Market. 2 car parking w/garage & driveway. Level 2 EV charging & an 8 kWh solar array add valuable convenience & efficiency. Seller Motivated.
Listing Courtesy of CincyMLS / Listed By: Roxanne Qualls, Hyde Park
CincyMLS / Listed By: Roxanne Qualls, Hyde Park
$1,699,000 (USD)
Madeira Area Single Family Home
Active
5802 Hickory Court Madeira, OH 45243
3 Bed
3.1 Baths
0 sqft
MLS# 1763600
Your DREAM HOME awaits!! Windridge Estates a 9 Lot luxury development in Madeira. The street and utilities are in. Great location, private setting. Cul-de-sac, wooded lots, walkable neighborhood. Joshua One a premier developer & builder. Willing to build this custom home or design a home to a buyers exact taste. Enjoy high end finishes, functional/stylish/creative floor plans. To finish the basement it would be an additional $95k.
Listing Courtesy of CincyMLS / Listed By: Julie Back, Hyde Park
CincyMLS / Listed By: Julie Back, Hyde Park
$1,688,800 (USD)
Guilford Area Single Family Home
Pending
21563 Fox Road Guilford, IN 47022
6 Bed
5.3 Baths
8593 sqft
MLS# 1832179
Discover the perfect blend of classic elegance and modern sophistication in this stunning 6 br,8 bath 17,000+ sqft estate.Marvel at the intricate crown molding,11 fireplaces,beautiful reconstructed custom wood floors throughout that exude warmth and charm.The home is equipped with 7 state-of-the-art geothermal furnaces ensuring comfort & efficiency year-round.The luxurious owner's suite features a walk-in closet with built-in shelving,dressing area,kitchenette with washer & dryer,& adjoining full bath with high-end jetted tub & walk-in double shower.Finished basement featuring a family room,rec room,media room,game room,& wet bar room makes this home the perfect place to host all your gatherings!Convenience abounds with 3 laundry rooms between the main house and guest house.A covered breezeway leads you to the charming 3 bd,3 full bath guest house(see guest home details in attachments)This property combines the allure of old-world charm with modern chic living, call it home today!
Listing Courtesy of CincyMLS / Listed By: Team Hamilton, Harrison
CincyMLS / Listed By: Team Hamilton, Harrison
$1,650,000 (USD)
Triple Crown Country Club Area Single Family Home
Active
10725 Meadow Stable Lane Union, KY 41091
4 Bed
6 Baths
6300 sqft
MLS# 646140
Located on the 11th fairway of Triple Crown Country Club, this custom home is its own retreat. You will feel like you are on vacation as you sit on your expansive covered back patio, equipped with an outdoor kitchen, bathroom, and a gas fireplace looking out to the heated pool with attached hot tub and golf course. You can't get more private than this. Inside you will find 4 bedrooms, 3 full baths and two half baths. The first-floor primary suite has direct access out to the covered patio for your morning coffee and luxury spa-like bathroom with oversized walk-in shower. The 12x12 primary closet has custom built-ins and you can continue through to your primary first level laundry room. The open floorplan and architecture are breathtaking, from the coffered ceiling, curved dining beam, oak hardwood floors, to the large custom pantry. There's also a second guest suite with on-suite bath and walk-in closet located on main level. Just off the beautiful custom kitchen you will find the mud room with a second laundry washer/dryer. The open staircase leads down to the lower level. The finished lower level is an extension of the living and entertaining space with a wet bar (equipped with sink, dishwasher, and full-sized fridge), theater room, gym, wine cellar, half bath for guests, and two more bedrooms with a full bath. Just when you think you don't need any more space, the unfinished storage room(s) is massive. Imagine having this masterpiece within walking distance from Triple Crown Country Club.
Listing Courtesy of NORTHERN KENTUCKY / Listed By: Lori Gasser, Florence
$1,596,500 (USD)
Cincinnati Area Single Family Home
Pending
2940 Robertson Avenue Cincinnati, OH 45209
3 Bed
4.1 Baths
0 sqft
MLS# 1878249
Set on a picturesque lot overlooking Foundry Park, this custom‑built home combines elevated design with a layout crafted for modern living. Built by WP Land Company, this 15‑year tax‑abated residence sits just beyond the Homearama 2025 row and is moments from the shops and restaurants of Oakley Square, Rookwood, and Oakley Station. The second‑floor living room opens to a covered deck ideal for everyday relaxation, while the third‑floor primary suite features its own private covered outdoor space. The fourth floor adds versatility with an additional bedroom, a media room, and a rooftop terrace perfect for entertaining. Lot 52.
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery
$1,500,000 (USD)
Cincinnati Area Single Family Home
Active
1130 Carney Street Cincinnati, OH 45202
3 Bed
3.1 Baths
3716 sqft
MLS# 1880012
Enjoy breathtaking sweeping river views from this exceptional Mt. Adams townhome designed for luxurious living and effortless entertaining. This home features a spacious rooftop terrace, two elevators, and a ground-level guest suite/home office with French doors opening to a private garden patio. The expansive 2nd floor primary suite offers a spa-inspired ensuite bath and two walk-in closets. The 3rd living spaces showcase spectacular river views from the living room w/ balcony, elegant dining room with built-in bar, and gourmet kitchen. Additional highlights include a richly appointed wood-paneled office/study, a 2nd floor guest suite, a finished lower-level ideal for a home gym/ media rm, and a 3-car garage w/ built-in storage. Experience walkable Mt. Adams living with restaurants, parks and easy access to downtown Cincinnati.
Listing Courtesy of CincyMLS / Listed By: Megan Murray, Fairfield
CincyMLS / Listed By: Megan Murray, Fairfield
$1,500,000 (USD)
Goshen Twp Area Single Family Home
Active
6651 Saddleback Way Goshen Twp, OH 45140
4 Bed
3.1 Baths
0 sqft
MLS# 1891790
Build your dream home on a almost 2 Acre lot with deStefano Homes & Remodeling in the highly sought-after Reserves of Stone Pillars Farm! This is the last opportunity to build in this beautiful community.Choose this thoughtfully designed first-floor primary suite plan or work with deStefano Homes & Remodeling to create a custom design tailored to your lifestyle. The open floor plan features exceptional custom details, spacious living areas, and a covered rear porch perfect for relaxing or entertaining. Situated on a private corner lot, this is a rare opportunity to build a custom home in one of the area's most desirable communities. The community has 3-Miles of Bridle & walking trails!
Listing Courtesy of CincyMLS / Listed By: Andrea & Linda deStefano, Montgomery
CincyMLS / Listed By: Andrea & Linda deStefano, Montgomery
$1,500,000 (USD)
Cincinnati Area Single Family Home
Pending
2931 Iron Oak Court Cincinnati, OH 45209
3 Bed
5.1 Baths
0 sqft
MLS# 1874461
Exquisite custom home by WP Land Company in the private courtyard at Foundry Park at Three Oaks, host of Homearama 2025. 15-year tax abatement & in a prime location just minutes to Downtown Oakley, Hyde Park Square, Factory 52, Rookwood, and premier shopping and dining. Modern design with exceptional finishes, highlighted by a rooftop terrace for entertaining, multiple covered outdoor spaces, and a thoughtfully designed layout. Second-floor primary suite features dual baths with heated floors and separate walk-in closets. A truly special home. Lot #73.
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery
$1,500,000 (USD)
Montgomery Area Single Family Home
Pending
11972 Grandstone Lane Montgomery, OH 45249
4 Bed
4.2 Baths
6592 sqft
MLS# 1887946
A rare find in the Reserve of Montgomery! 1st floor primary with 3 beds, 2 full baths up with finished LL with a flex room & full bath. 1st floor study & 2nd flr loft study, both with custom built-ins. Kitchen overlooks a generous size family room with built-ins, high ceilings, stone fireplace with adjacent sunroom. Huge breakfast room with views of an awesome rear yard & covered patio. Enormous lower level, ideal for entertaining with high ceilings, bar and stone fireplace.
Listing Courtesy of CincyMLS / Listed By: Rob Winterman, Montgomery
CincyMLS / Listed By: Rob Winterman, Montgomery
$1,499,592 (USD)
Miami Twp Area Single Family Home
Active
424 Trailside Woods Court Miami Twp, OH 45140
4 Bed
3.1 Baths
0 sqft
MLS# 1861446
Build this stunning ranch or another plan by Robert Lucke Homes! Exquisite 5'' hardwood flooring, 8' interior doors, striking custom details complemented by soaring ceilings! Chef-inspired gourmet Kitchen features high-end appliances, large center island, and working pantry! Luxurious and serene Primary with an abundance of natural light and spa-like bathroom. Great Room boasts 11' ceilings, exposed beams, custom built-ins, cozy gas fireplace! Covered patio is complete with a stone fireplace! Lower Level adds more versatile living space with a Rec Room, office, two more bedrooms, and full bath. 3-car garage. Trailside Estates is a fantastic NEW community in Miami Twp. (no earnings tax!). Water, Sewer, Natural Gas.
Listing Courtesy of CincyMLS / Listed By: Andrea & Linda deStefano, Montgomery
CincyMLS / Listed By: Andrea & Linda deStefano, Montgomery
$1,478,705 (USD)
Hamilton Twp Area Single Family Home
Pending
0 Adams Road Hamilton Twp, OH 45140
4 Bed
3.1 Baths
0 sqft
MLS# 1858070
Sold Before Sent
Listing Courtesy of CincyMLS / Listed By: Lynda Pohl, Hyde Park
CincyMLS / Listed By: Lynda Pohl, Hyde Park
$1,475,000 (USD)
Cincinnati Area Single Family Home
Active
455 Flinn Avenue Cincinnati, OH 45226
3 Bed
3.1 Baths
0 sqft
MLS# 1881702
FOUNDATION POURED & CONSTRUCTION IS UNDERWAY! Est. completion 6-8 months! Exceptional new construction in one of Cincinnati's most sought-after neighborhoods. Offering 4,000+ sqft of interior space plus 972 sqft of panoramic terrace space with stunning valley views and seamless indoor-outdoor living. LEED-certified with tax abatement for energy-efficient savings. Features private elevator and build-to-suit opportunity with high-end custom finishes throughout. Fully approved through Hillside and zoning. Prime location - walk to Columbia Tusculum & Mt. Lookout Square dining/entertainment, just 8 minutes to downtown. Rare opportunity to customize your dream home in an unbeatable location!
Listing Courtesy of CincyMLS / Listed By: Elizabeth Burk, Hyde Park
CincyMLS / Listed By: Elizabeth Burk, Hyde Park
$1,450,000 (USD)
Montgomery Area Single Family Home
Active
10600 Indian Woods Drive Montgomery, OH 45242
5 Bed
4.2 Baths
4011 sqft
MLS# 1890817
A Rare Find on NEARLY 3 PRIV ACRES. Backs to Indian Hill Nature Preserve on One Side. Huge, Hard to Find, 3,500 sq ft abv gd Sprawling, Ranch. Experience Elevated Montgomery Living, Creative Design & Exceptional Flexibility. Completely Renovated w/Large, Sparkling Htd Pool& Spa. Stunning 1st Impression w/an Expansive Open Combined Kit, DR & LR w/Impressive Flr to Ceil Stone FP Under an Incredible Wooded vaulted Ceiling Creating the Perfect Gathering Space, All Overlooking a Phenomenal Resort-like Bkyrd Retreat. Tranquil Prim Bd w/Spa-like Ba &Drssing Area. Convenient 1st Flr Stdy &Lndry. Huge W/O LL is the Ideal Guest or In-law Ste feat 2 Bdrms, 2 Full Ba, FR, Kit, Exercise Rm & 2nd Lndry Rm. Bkyd Oasis feat Htd Gunite Pl, Spa, Patio w/Pergola, Lovely Gazebo &Fire Pit w/Peaceful Wd Views. 4 Car Gar. A Hm that Blends Luxury, Comfort &Privacy. Full List of Updates on MLS. Conveniently Located Near Restaurants, Shopping &Highway Access. An extraordinary, Rare Find in the Sycamore Schools.
Listing Courtesy of CincyMLS / Listed By: Diane Tafuri, Montgomery
CincyMLS / Listed By: Diane Tafuri, Montgomery
$1,425,000 (USD)
Fort Thomas Area Condo
Active
1 Highland Avenue Fort Thomas, KY 41075
2 Bed
3 Baths
0 sqft
MLS# 642216
2 BR/2.5BA/Study. Gorgeous luxe condo- heart of Ft Thomas. One-level living. Elevator to
private garage. One-of-a-kind corner ''stone tower'' feature in gather room; windows on 3 sides;
dramatic fireplace wall; access to 25x11 covered balcony facing S. to Highland Ave. Grand Kitchen with Sub-Zero/Wolf appliances/furniture-grade cabinetry/adjacent bar. Large study.
Deluxe primary BR suite (dual-sink vanities; commode rm; supersized walk-in closets.) 10-ft ceilings. Impeccable craftsmanship. Underground parking: 2 spaces + storage area. Close to restaurants/parks. 5 min. to regional arts/entertainment.
private garage. One-of-a-kind corner ''stone tower'' feature in gather room; windows on 3 sides;
dramatic fireplace wall; access to 25x11 covered balcony facing S. to Highland Ave. Grand Kitchen with Sub-Zero/Wolf appliances/furniture-grade cabinetry/adjacent bar. Large study.
Deluxe primary BR suite (dual-sink vanities; commode rm; supersized walk-in closets.) 10-ft ceilings. Impeccable craftsmanship. Underground parking: 2 spaces + storage area. Close to restaurants/parks. 5 min. to regional arts/entertainment.
Listing Courtesy of NORTHERN KENTUCKY / Listed By: Aimee Pelletier, Florence
$1,420,000 (USD)
Moores Hill Area Single Family Home
Active
11600 Long Branch Road Moores Hill, IN 47032
3 Bed
4.1 Baths
5758 sqft
MLS# 1829221
Luxury & privacy awaits in this beautiful move in ready custom ranch sitting on over 73 acres. You will never run out of things to do on this property with 2 stocked ponds, quad trails, large barn perfect for animals or workshop, and wildlife galore! This over 4500 sq ft of finished living space has so much to offer with 4 bedrooms with walk-in closets & adjoining bathrooms in each! The finished lower level includes a wet bar, mudroom, stone fireplace & 2 full baths. Wired generator installed so you will never lose power! Professional grade finishes have been done throughout this gorgeous home including hardwood floors, granite, 2 custom fireplaces, and so much more! Make this your forever home today!
Listing Courtesy of CincyMLS / Listed By: Team Hamilton, Harrison
CincyMLS / Listed By: Team Hamilton, Harrison
$1,399,900 (USD)
Blue Ash Area Condo
Pending
4240 Park Place Circle Blue Ash, OH 45242
3 Bed
2.1 Baths
0 sqft
MLS# 1872383
Extraordinary! Enjoy this fabulous view overlooking Summit Park, nowhere else can you find this! This 3BR + Study third floor Penthouse residence offers 2,669 sq ft. of luxury one-floor living. End Unit with 2 balconies. 10-foot ceilings, 12 foot in Living Room. Wolf/SubZero Appliances, Quartz counters and all the quality custom features that WP Land offers. 2 Garage Spaces in Climate Controlled underground parking garage + storage area & elevator. Within steps of walking trails, fishing pond, restaurants, and all that Summit Park lifestyle has to offer!
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery
$1,399,000 (USD)
Madeira Area Single Family Home
Pending
5801 Hickory Court Madeira, OH 45243
5 Bed
3 Baths
0 sqft
MLS# 1765333
Your Dream Home Awaits! Windridge Estates a 9 lot luxury development in Madeira. The street and utilities are in. Great Location, private setting cul-de-sac, wooded lots, walkable neighborhood. Joshua One a premier developer & builder. Will build this custom home or design a home to a buyers exact taste. Enjoy high end finishes, functional/stylish/creative floor plans. Construction beings Spring 2026.
Listing Courtesy of CincyMLS / Listed By: Julie Back, Hyde Park
CincyMLS / Listed By: Julie Back, Hyde Park
$1,399,000 (USD)
Cincinnati Area Condo
Active
2145 Luray Avenue Cincinnati, OH 45206
3 Bed
2.1 Baths
3053 sqft
MLS# 1890940
Live a carefree lifestyle in this luxury condominium with magnificent views of the Ohio River & Eden Park. Light-filled rooms, soaring ceilings, hardwood floors, & custom architectural details create an elegant living environment. The open-concept living & dining areas walk out to an expansive 500sf covered terrace, perfect for relaxing or entertaining while enjoying the views. The modern kitchen features custom cabinetry & stainless-steel appliances. The serene primary suite offers a spacious bath & generous closet space. Two additional bedrooms provide flexibility for guests, a home office, or sitting room. Secure building with 2 garage parking spaces plus community amenities including a party room & exercise room. Lovingly maintained & ideally located just minutes from Eden Park, Mt. Adams, the Woodburn Avenue District, & only 5 minutes to downtown Cincinnati. Seller prefers a quick closing with occupancy through 10/31. No escalation clauses. Offers remain open for 48hrs.
Listing Courtesy of CincyMLS / Listed By: Julie Back, Hyde Park
CincyMLS / Listed By: Julie Back, Hyde Park
$1,399,000 (USD)
Miami Twp Area Single Family Home
Active
2700 Rittenhouse Road Miami Twp, OH 45052
2 Bed
2.1 Baths
0 sqft
MLS# 1889806
Exclusively built by CW Custom Homes. 2525sqft ranch on 2+ acres. Lower level walk out, layout can offer up to 2 additional beds, bath, storage, rec space, etc at buyers expense. Covered patio with fireplace and outdoor grill space optional. Yard set up to add pool. Geothermal tax benefit. Agent is related to seller.
Listing Courtesy of CincyMLS / Listed By: Regina Weis, Green Township
CincyMLS / Listed By: Regina Weis, Green Township
$1,389,900 (USD)
Blue Ash Area Single Family Home
Active
4212 Magnolia Alley Blue Ash, OH 45242
3 Bed
3.2 Baths
0 sqft
MLS# 1878274
Coming soon to Arabella at Summit Park, this stunning 4-story rooftop patio home by WP Land Company showcases elevated design and exceptional craftsmanship. The gourmet kitchen is anchored by Wolf and Sub-Zero appliances, complemented by gorgeous custom built-ins throughout. The spacious primary suite offers a luxurious retreat. Designed for entertaining, the fourth floor features a large media room with a full bar and direct access to a covered rooftop patio built for year-round enjoyment. Included elevator provides effortless access to all levels. Model home currently under construction with estimated completion in late 2026.
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery
$1,375,000 (USD)
Blue Ash Area Single Family Home
Pending
5074 Arabella Circle Blue Ash, OH 45242
3 Bed
4.1 Baths
0 sqft
MLS# 1847404
Another custom beauty by WP Land Company in Arabella at Summit Park. This 4-story rooftop home features park views from every level, elevator access to all floors, and low-maintenance living just steps from Summit Park. Open-concept main level with high-end finishes, gourmet kitchen, & 3 en-suite bedrooms. Rooftop patio offers indoor/outdoor living with unbeatable views. A rare opportunity for luxury and convenience in Blue Ash's premier new community. Lot #11.
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery
$1,369,900 (USD)
Blue Ash Area Single Family Home
Active
4208 Magnolia Alley Blue Ash, OH 45242
3 Bed
4.1 Baths
0 sqft
MLS# 1878411
A standout new design is taking shape in Arabella at Summit Park - an impressive 4-story rooftop home by WP Land Company. Designed with an open, light-filled floorplan, this home offers expansive entertaining spaces, luxury finishes, and an included elevator providing effortless access to all levels. The main living level features 10-foot ceilings, a Wolf/Sub-Zero kitchen with walk-in pantry, spacious dining area, and seamless flow into the great room and rear deck. The bedroom level includes an expansive primary suite with dual walk-in closets, en-suite bedroom, and convenient laundry room. The fourth floor is designed for entertaining with a large media room, full bath, and dramatic rooftop terrace featuring covered and open-air living spaces. Entry level offers a private guest suite or study option, full bath, mudroom, and 2-car garage. More than 130 acres of green space, walking trails, dining, and year-round amenities at Summit Park. Estimated completion late 2026. Lot 34.
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery
$1,359,900 (USD)
Cincinnati Area Single Family Home
Pending
2923 Iron Oak Avenue Cincinnati, OH 45209
3 Bed
3.1 Baths
0 sqft
MLS# 1858169
In the Heart of Homearama'' - on the courtyard. Exquisite kitchen, study off kitchen, spacious primary, oversized laundry room off primary, 3 car garage, yoga room, bedroom with full bath and media room on rooftop. Outdoor living at its finest on 4th floor! Lot #28
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery
$1,349,900 (USD)
Blue Ash Area Single Family Home
Pending
5182 Arabella Circle Blue Ash, OH 45242
3 Bed
3.2 Baths
0 sqft
MLS# 1878400
A standout new design in Phase 2 of Arabella at Summit Park, this custom 4-story home by WP Land Company is a true showcase of sophisticated design. The main living level offers an open layout anchored by a large kitchen, expansive living and dining spaces, and a dedicated study. The third-floor features three bedrooms, including a spacious primary suite with a large walk-in closet and thoughtfully designed bathroom. An included elevator provides seamless access to all four levels. Designed with entertaining in mind, the top floor features a media room, full bar, and rooftop terrace with both covered and open-air living spaces. The entry level adds flexibility with a private fitness room and additional functional living space. Located in Arabella at Summit Park, surrounded by over 130 acres of park space, walking trails, dining, and entertainment. Lot 6 Phase 2.
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery
$1,349,900 (USD)
Blue Ash Area Condo
Pending
4212 Park Place Circle Blue Ash, OH 45242
3 Bed
2.1 Baths
0 sqft
MLS# 1808670
Extraordinary! Enjoy this fabulous view overlooking Summit Park, nowhere else can you find this! This 3BR + Study offers 2,669 sq ft. of luxury one-floor living. End unit with 2 patio terraces. 10-foot ceilings, Wolf/SubZero appliances, Quartz counters and all the quality custom features that WP Land offers. 2 Garage Spaces in Climate Controlled underground parking garage + storage area & elevator. Within steps of walking trails, fishing pond, restaurants, and all that Summit Park lifestyle has to offer!
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery
$1,349,000 (USD)
Cincinnati Area Single Family Home
Active
3506 Shaw Avenue Cincinnati, OH 45208
3 Bed
2.2 Baths
0 sqft
MLS# 1892614
Brand new luxury condo with a premier location! Move-in ready. Timeless qualities and amenities including light oak floors, crown molding, and 9-foot ceilings. Magnificent family room with a gas fireplace with limestone mantel and custom built ins. Designer kitchen has Bosch and Wolf appliances, quartz counters, walk-in pantry and eat-in island. The finished rec room is perfect for entertaining. The luxe primary bath has a heated floor. Bonus room and half bath over the garage. Mudroom! 2 Garage spaces. LEED Gold tax abatement for 15 years. $250 monthly condo fees. Minutes to the Square and Graeter's, Farmer's Market, as well as the shops and restaurants. Live a carefree, lock-and-go life! Offers open for 48 hours. No escalation clauses.
Listing Courtesy of CincyMLS / Listed By: Julie Back, Hyde Park
CincyMLS / Listed By: Julie Back, Hyde Park
$1,333,500 (USD)
Cincinnati Area Single Family Home
Pending
2906 Three Oaks Lane Cincinnati, OH 45209
3 Bed
3.2 Baths
0 sqft
MLS# 1866347
Custom built by WP Land, this modern four-story rooftop residence reflects the architectural style and lifestyle found throughout Foundry Park at Three Oaks. Features include a two-car garage, first-floor gym with full bath, hardwood floors throughout, and high-end custom finishes. This home offers multiple walkout decks, a study, dining area with wet bar, and an open kitchen built for entertaining. The primary suite includes a private walkout patio and a well-appointed ensuite bathroom. The rooftop level features a media room with indoor bar opening to a covered, heated patio and additional rooftop decking. Build your custom home in Foundry Park!
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery
$1,329,999 (USD)
Cincinnati Area Single Family Home
Pending
459 Flinn Avenue Cincinnati, OH 45226
3 Bed
3.1 Baths
0 sqft
MLS# 1831329
New construction in historic Columbia Tusculum. Panoramic views from 2 terraces. Over 4000 square feet of livable space with an additional 972 square feet of Terraces. LEED certified with tax abatement. Fully approved through Hillside and Zoning. Elevator to all floors. Opportunity to build to suit. Agent has interest in property and build.
Listing Courtesy of CincyMLS / Listed By: Peter McGarey Jr., Hyde Park
CincyMLS / Listed By: Peter McGarey Jr., Hyde Park
$1,325,000 (USD)
Sycamore Twp Area Single Family Home
Pending
7265 Timberknoll Drive Sycamore Twp, OH 45242
4 Bed
4.2 Baths
5123 sqft
MLS# 1892088
Enjoy luxury living and effortless entertaining in this exceptional Sycamore School District home offering over 5,000 SF of meticulously maintained living space! The thoughtfully designed floorplan provides an incredible flow for everyday living and entertaining. The 2nd floor features an oversized Primary Suite with updated Bath & WIC, 3 additional Bedrooms, and a dedicated workspace. The finished Lower Level offers an Exercise Room, Step-Down Media Room, Recreation Space, additional Office, and Half Bath. Step outside to your own private retreat featuring a heated pool, covered patio with bar & fireplace, grilling area, firepit, and a full Bath with built-in benches for convenient towel storage. Every detail has been thoughtfully designed, with numerous updates including a NEW ROOF & NEW MECHANICALS! Ideally located near Moeller, All Saints, and Downtown Montgomery. An exceptional home in a highly desirable locationthis one will not last!
Listing Courtesy of CincyMLS / Listed By: Andrea & Linda deStefano, Montgomery
CincyMLS / Listed By: Andrea & Linda deStefano, Montgomery
$1,311,900 (USD)
Cincinnati Area Single Family Home
Pending
2933 Iron Oak Court Cincinnati, OH 45209
3 Bed
3.2 Baths
0 sqft
MLS# 1874447
Urban living at its finest with a rare sense of privacy in the private courtyard at Foundry Park at Three Oaks, host of Homearama 2025. Custom-built by WP Land Company, this end-lot home offers exceptional natural light throughout and is designed with exquisite detail. Fourth-floor rooftop deck with adjoining media room with gorgeous vaulted ceiling creates a standout entertaining space. Eligible for 15-year tax abatement. Prime location just minutes to Downtown Oakley, Hyde Park Square, Factory 52, Rookwood, and premier shopping and dining. Lot 72.
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery
$1,300,000 (USD)
Pierce Twp Area Single Family Home
Pending
1029 Eagles Landing Pierce Twp, OH 45245
4 Bed
4.1 Baths
4571 sqft
MLS# 1883306
Luxurious Estate in much sought after Legendary Run. Welcome to your private sanctuary perfectly situated on a sprawling 1.67 acre partly wooded lot, offering the ultimate blend of privacy, luxury, and natural beauty. Designed with meticulous attention to detail, the residence has a great kitchen, pantry, 13x8 mud room, speaker system, arched window transoms, high-end furnishings. The thoughtfully designed interior features 4 spacious bedrooms, each boasting its own dedicated, private en-suite bathroom, along with walk-in closets. Large primary has a cedar closet. Expansive living spaces flow seamlessly into light-filled common areas, all beautifully accented by premium finishes and curated decor. Step outside into your personal resort. The expansive 19x15 trex deck overlooks a backyard paradise designed for hosting and relaxation. Enjoy the sparkling salt water heated swimming pool, a built-in (bromine) hot tub, fire pit and a covered patio with BBQ grill/outdoor entertainment center.
Listing Courtesy of CincyMLS / Listed By: Karen Bevins, Anderson
CincyMLS / Listed By: Karen Bevins, Anderson
$1,299,900 (USD)
Blue Ash Area Condo
Pending
4226 Park Place Circle Blue Ash, OH 45242
3 Bed
2.1 Baths
0 sqft
MLS# 1808367
Sold Before Sent! Nowhere else can you find this fabulous view overlooking Summit Park! This 3BR + Study offers 2,669 sq ft. of luxury one-floor living. End Unit with 2 balconies. 10-foot ceilings, Wolf/SubZero Appliances, Quartz counters and all the quality custom features that WP Land offers. 2 Garage Spaces in Climate Controlled underground parking garage + storage area & elevator. Within steps of walking trails, fishing pond, restaurants, and all that Summit Park lifestyle has to offer!
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery
$1,295,000 (USD)
Deerfield Twp Area Single Family Home
Pending
6551 Palmetto Drive Deerfield Twp., OH 45040
4 Bed
4.1 Baths
5004 sqft
MLS# 1888760
Experience elevated living in this beautiful Hudson Hills home!You're welcomed by refined design & a warm, sophisticated feel. The desirable FL plan features a formal dining room w/Butler pantry, a Great Room w/coffered ceiling & stone fireplace, & a gourmet kitchen w/large island, SS appliances, dbl oven, gas cooktop, & abundant cabinetry. Upstairs, the spacious primary suite BDRM & BATH offers true relaxation! The 2nd FL also features a versatile oversized LOFT & 3 additional bedrooms.The finished LL, by Neal's remodeling, adds sophistication & an exceptional living space w/rec area,full designer bar w/ice maker/dishwasher/beverage refrigerators,full bath, and flexible room for office/hobby space. Step outside to a private resort-style backyard w/a stunning pool, built-in grill w/bev frig, gazebo, & beautifully landscaped entertaining areas. Minutes from dining, shopping, & conveniences!HOA Includes Social Membership to Four Bridges CC, enjoy fitness, pool & tennis! HURRY!
Listing Courtesy of CincyMLS / Listed By: Linda deStefano, Montgomery
CincyMLS / Listed By: Linda deStefano, Montgomery
$1,295,000 (USD)
Liberty Twp Area Single Family Home
Active
5512 Charleston Woods Drive Liberty Twp, OH 45044
5 Bed
5.1 Baths
5468 sqft
MLS# 1891519
This gorgeous custom home welcomes you w/a covered front porches overlooking a peaceful pond. Inside a welcoming 2 story foyer & HW floors throughout lead to a bright open kitchen w/granite countertops a 14' island & a seamless flow to the dining room. Step outside to an entertainer's dream: paver patio inground pool outdoor FP island bar & outdoor cooking area all framed by a private tree lined backdrop. Upstairs 4 spacious bedrooms each feature updated private baths including a stunning primary suite w/a walk in closet ensuite & access to 2nd floor laundry. The finished walkout LL adds more living space w/an updated full bath new carpet fresh paint & storage. Set on 2 acres in a private neighborhood of only 14 custom homes. 6300 sq. ft. per seller. With pond views a private pool oasis & multiple entertainment areas this is a home you will not want to miss!
Listing Courtesy of CincyMLS / Listed By: Lori Hall Pollard, Voice Of America
CincyMLS / Listed By: Lori Hall Pollard, Voice Of America
$1,256,900 (USD)
Cincinnati Area Single Family Home
Active
2905 Three Oaks Lane Cincinnati, OH 45209
2 Bed
3.2 Baths
0 sqft
MLS# 1861755
Don't miss out on the LAST LOT IN PHASE 1! Introducing an exciting new home plan by WP Land at Foundry Park in Oakley the site of Homearama 2025. This home features a stunning 22' x 15' gourmet kitchen with a coffee bar, island, custom cabinetry, Thermador appliances, and quartz countertops. The great room boasts a gas fireplace with built-ins. Dining room includes a buffet for added convenience. The primary suite offers two walk-in closets, and the expansive rooftop deck over 1,000 sq. ft. of covered and uncovered space includes a built-in bar for exceptional outdoor entertaining. Lot 15.
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery
$1,251,900 (USD)
Blue Ash Area Single Family Home
Pending
4216 Magnolia Alley Blue Ash, OH 49242
3 Bed
2.3 Baths
0 sqft
MLS# 1886193
An extraordinary four-story rooftop home designed for elevated luxury living in Arabella at Summit Park. Custom designed by WP Land Company, this stunning residence showcases thoughtful design and exceptional craftsmanship throughout. Featuring three bedrooms, an open-concept floor plan, a designer kitchen with an oversized walk-in pantry, a first-floor media room, and a private top-floor study, the home is highlighted by an incredible rooftop entertaining retreat complete with an oversized outdoor kitchen and expansive rooftop patio. A one-of-a-kind custom home designed for both everyday living and unforgettable entertaining.
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery
$1,250,000 (USD)
Alexandria Area Land
Pending
10743 S Licking Pike Alexandria, KY 41001
Bed
0 Baths
sqft
MLS# 531399
46.510 Acre with R-1A & R-RE(P) fronting Old U.S.27 (approx. 1,000+ front footage). Extending back with frontage along South Licking Pike. Water and sewer at site. Prime development Land under Urban Mixed Use Comprehensive Plan. Residential home on South Licking Pike of No Value to the Land. Outstanding development potential for residential use. This property is within close proximity to Campbell County Schools and has easy access to all area services. Water & sewer at site, land lays relatively level & has wooded views, fronting both US 27 & South Licking Pike.
Listing Courtesy of NORTHERN KENTUCKY / Listed By: Kim Moore, Florence
$1,250,000 (USD)
Covington Area Condo
Active
1150 Shavano Drive Covington, KY 41011
3 Bed
3 Baths
2530 sqft
MLS# 639788
This Spectacular 2nd floor unit in the Verandas at The Views - Cutting Edge Condominium Development is a Must See! Tucked away in the Hills of Covington offering Spectacular Cincinnati Skyline Views. Luxury Ranch Style Living w/Spacious Open Concept Layout, 10'+ Ceilings, HDWD Floors, Modern Décor, Premium Finishes. End unit in the building allows for more windows and plenty of natural light. 3 full bedrooms and an Expansive Covered Terrace Perfect for Entertaining Family & Friends, Parking Garage with 2 premium spots and Private Entry Elevator Access Directly to Unit. Amenities include Clubhouse, Infinity Edge Pool, Fitness Center & more! Great Location just minutes to Downtown Dining & Entertainment. Simply Stunning...come take a look and see Our View!
Listing Courtesy of NORTHERN KENTUCKY / Listed By: Chris Kennedy, Florence
$1,225,000 (USD)
Fort Thomas Area Condo
Active
1 Highland Avenue Fort Thomas, KY 41075
3 Bed
3 Baths
0 sqft
MLS# 646062
Fantastic first floor new condo in the heart of Ft Thomas. One level living w/ elevator to private garage. Spacious 25x11 covered balcony. Open, modern, light-filled spaces w/ floor to ceiling windows and fireplace in gathering room. This unit has 13ft vaulted ceiling throughout the entire unit. The expressive designer interior finishes are the highest quality w/ wood floors throughout, Amish made cabinetry, SubZero/Wolf appliances, and Kohler fixtures. Included with each unit are 2 secure/temperature controlled parking along with storage unit. Close to dining, arts, parks, and other convenient services and just minutes to Cincinnati/Newport/Covington, Walk to all of your favorite destinations.
Listing Courtesy of NORTHERN KENTUCKY / Listed By: Aimee Pelletier, Florence
$1,224,999 (USD)
Wyoming Area Single Family Home
Pending
320 Reily Road Wyoming, OH 45215
5 Bed
5.2 Baths
6877 sqft
MLS# 1881003
Historic Beauty Backing to Stearns Woods - This rare 1893-built gem offers over 6,500 sq ft of timeless elegance on 1.99 private acres. Featuring 5 bedrooms, 5 full and 2 half baths, this home blends historic charm with modern comfort. Original hardwood floors, detailed built-ins, and dual staircases showcase classic craftsmanship throughout. The second floor includes 3 bedrooms with en-suite baths and a home office, while the third floor offers 2 more bedrooms, full bath and a multi-purpose room. A beautifully finished basement includes a full bath, half bath, exercise room, and expansive entertaining space. Enjoy peaceful outdoor living with a wraparound front porch, back patio, fountain, and a 4-car garage. Backing directly to Stearns Woods, this is a one-of-a-kind opportunity to own a true historic treasure.
Listing Courtesy of CincyMLS / Listed By: Margaret Brown, Northern Hills
CincyMLS / Listed By: Margaret Brown, Northern Hills
$1,208,900 (USD)
Blue Ash Area Single Family Home
Pending
5190 Arabella Circle Blue Ash, OH 45242
3 Bed
3.2 Baths
0 sqft
MLS# 1875360
Custom design in Summit Park. Features a beautiful black exterior with sophisticated style, 3 bedrooms featuring primary bedroom with 2 walk-in closets, rooftop with bar, outdoor patio heaters, gourmet kitchen, pantry, dining room with built ins & wine bar, 1st floor rec room, hardwood floors throughout. Phase 2 lot 4.
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery
$1,195,000 (USD)
Cincinnati Area Single Family Home
Active
3912 Edwards Rd 8 Cincinnati, OH 45209
3 Bed
3.1 Baths
3260 sqft
MLS# 1729041
Construction has begun. Rookwood Place III Urban Luxury infill. Two Single detached Townhomes. 3320 sqft, 15 Year Tax Abatement, Kitchen open to dining and living room, Spacious Roof top terrace with interior family room 2 car garage, optional elevator. Walk to: Rookwood shopping/entertainment area. Hyde Park & Oakley Squares.
Listing Courtesy of CincyMLS / Listed By: Julie Back, Hyde Park
CincyMLS / Listed By: Julie Back, Hyde Park
$1,187,000 (USD)
Crescent Springs Area Single Family Home
Active
2421 Felice Drive Crescent Springs, KY 41017
2 Bed
2 Baths
0 sqft
MLS# 642068
Build your custom dream home in Villa Hills on a gorgeous, private wooded lot in the charming Stillbrooke community! Tucked away on a quiet cul-de-sac, Lot #17 offers maintenance-free living with Ashley Builders as the exclusive builder. Open, airy floor plan featuring 10' tray ceilings, a massive kitchen island, hidden walk-in pantry, and 8' patio doors. 2 bedrooms, 2 baths, and ~2,900 sq ft of thoughtfully designed living space, plus a covered porch and the option of a fully finished lower level. Enjoy true low-maintenance living with lawn care & fertilization, irrigation start-up and shut-down, landscaping, and snow removal all included--no more yard work! Endless customization options available, with the ability to tour other Ashley-built homes to explore floor plans and high-end finishes. Contact Heimbrock Group for more details!
Listing Courtesy of NORTHERN KENTUCKY / Listed By: Kathy Heimbrock, Florence
$1,175,000 (USD)
Cincinnati Area Single Family Home
Pending
3 Pueblo St Cincinnati, OH 45202
4 Bed
4.1 Baths
sqft
MLS# 1396518
Lot# 3. Enjoy incredible panoramic views of the Cincinnati Skyline from all five levels of this spectacular hilltop retreat on top of Prospect Hill. Two rooftop terraces provide amazing space for entertaining guests. 4800 square foot custom built home minutes to downtown & Clifton. 15 year LEED certified tax abatement.
Listing Courtesy of CincyMLS / Listed By: Elizabeth Burk, Hyde Park
CincyMLS / Listed By: Elizabeth Burk, Hyde Park
$1,169,000 (USD)
Cincinnati Area Single Family Home
Active
3527 Kroger Avenue Cincinnati, OH 45226
3 Bed
3.1 Baths
3670 sqft
MLS# 1891917
Beautifully appointed home with light-filled rooms, hardwood floors, and open spaces that flow seamlessly. Gorgeous details include a coffered ceiling, exquisite lighting fixtures, and a wet bar. The study features a fireplace and custom built-ins. The luxurious primary suite offers a large walk-in closet and spa-like bath. The lower level provides plenty of space for entertaining, along with a dedicated workout area. Enjoy the beautifully landscaped rear stone patio, complete with a fireplace perfect for relaxing or entertaining outdoors. Two-car garage. Ideally located just minutes from Mt. Lookout Square and Columbia Tusculum, and only 10 minutes to downtown Cincinnati. No escalation clauses. Offers remain open for 48 hours.
Listing Courtesy of CincyMLS / Listed By: Julie Back, Hyde Park
CincyMLS / Listed By: Julie Back, Hyde Park
$1,150,000 (USD)
Indian Hill Area Single Family Home
Pending
7434 Drake Road Indian Hill, OH 45243
4 Bed
4 Baths
3550 sqft
MLS# 1889156
Tucked away on a breathtaking wooded homesite in the heart of Indian Hill, this exceptional Ranch offers the perfect blend of privacy, luxury, and natural beauty. The private wooded backyard retreat features a gorgeous heated pool, two gazebos, and a detached studio ideal for a home office, fitness space, or creative retreat. Inside, vaulted ceilings, a stunning sunroom, and an open-concept great room with a gourmet kitchen create inviting spaces for everyday living and entertaining. The finished walkout lower level adds even more versatile living space, making this one-of-a-kind home as functional as it is beautiful.
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery
$1,150,000 (USD)
Miami Twp Area Single Family Home
Pending
5504 Enterprise Drive Miami Twp, OH 45150
4 Bed
4.1 Baths
4947 sqft
MLS# 1892780
Rare opportunity to own this stunning stone-and-brick home on 4.8 acres. This 4-bedroom, 4.5-bath home offers over 5,000 sq. ft. of living space. The spacious entry is flanked by a private office and formal dining room with butler's pantry. The Great Room features soaring ceilings and an open staircase leading to a loft, 2 bedrooms, and 2 baths. The oversized first floor primary suite includes a sitting area, heated bathroom floors, soaking tub, quartz countertops, large shower, and huge walk-in closet. The chef's kitchen features a walk-in pantry and adjoins a breakfast area and sitting room with access to a covered patio. The remodeled lower level includes LVP flooring, bar area, bedroom, and full bath. Walk out to the sparkling pool and fenced pool area. Additional highlights include a deck, abundant storage, oversized 3-car garage, first-floor laundry, and mudroom. Conveniently located near I-275, Historic Old Milford, shopping, dining, and schools.
Listing Courtesy of CincyMLS / Listed By: Cathy Strief, Miami Township
CincyMLS / Listed By: Cathy Strief, Miami Township
$1,150,000 (USD)
Cincinnati Area Single Family Home
Active
510 Corporation Alley Cincinnati, OH 45202
3 Bed
3 Baths
3521 sqft
MLS# 1882820
Tucked away in historic Prospect Hill, this exceptional 3+ bedroom residence is completely redesigned for the discerning buyer demanding uncompromising luxury. The over 3500sqft, light-filled interior showcases an elevated aesthetic defined by rich, organic textures. The kitchen is anchored by the dramatic depth of premium soapstone countertops and matching backsplash. Exquisite, heritage-rich Rookwood tile, white oak flooring and modern fixtures infuse the home with custom, artisanal character throughout. Designed for private, sophisticated hosting, this home features three fully independent, lavishly appointed suites with resort-caliber finishes. The outdoor spaces occupy a rare, block-deep terraced lot with a stone patio, lush green space, covered deck, custom bocce court, and a rooftop deck with breathtaking, panoramic views of downtown Cincinnati. Additional, jaw-dropping features include secure, gated entry, 2+ car garage, and a bonus, private outdoor space on East side of home.
Listing Courtesy of CincyMLS / Listed By: Jessica Back, Voice Of America
CincyMLS / Listed By: Jessica Back, Voice Of America
$1,111,111 (USD)
Cincinnati Area Multi-Family Home
Active
2215 Ohio Avenue Cincinnati, OH 45219
Bed
0 Baths
0 sqft
MLS# 1874874
Clifton Heights Parkside Landmark. 12 Large 1 Bedroom Units, High Ceilings & Historical Details. Capital Upgrades in 2020: NEW Windows, NEW Heat and Central AC Systems, NEW Water Heaters & Upgraded Electric, New Concrete Walks, Redone & Inspected Fire Escapes & Fresh Paint. Most Units Have New Kitchens & Baths. Free City Trash Removal. Easy Rentals.
Listing Courtesy of CincyMLS / Listed By: Brendan Morrissey, Metropolitan
CincyMLS / Listed By: Brendan Morrissey, Metropolitan
$1,105,900 (USD)
Blue Ash Area Condo
Active
4234 Park Place Circle Blue Ash, OH 45242
2 Bed
2 Baths
0 sqft
MLS# 1873396
Enjoy this gorgeous residence overlooking Summit Park, nowhere else can you find this! This 2BR + Study offers luxury one-floor living. 10-foot ceilings, 12 foot in Living Room. Wolf/SubZero appliances, Quartz counters and all the quality custom features that WP Land offers. 2 Garage Spaces in Climate Controlled underground parking garage + storage area & elevator. Within steps of walking trails, fishing pond, restaurants, and all that Summit Park lifestyle has to offer!
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery
$1,100,000 (USD)
Walton Area Land
Active
12025 Chandler Drive Walton, KY 41094
Bed
0 Baths
sqft
MLS# 622815
EXCELLENT OPPORTUNITY for development perfectly timed to the explosive growth in the Boone County/Walton Industrial network! 6.1 AC of I-1 zoned, mostly flat land with utilities nearby and access to I-71/75...a major US arterial freeway. Capitalize on Boone County's Strategic Plan by grabbing this attractive parcel with tons of potential! Seller makes no guarantees regarding soil, compaction, or any other characteristic of the land.
Listing Courtesy of NORTHERN KENTUCKY / Listed By: Bob Mueller, Florence
$1,075,000 (USD)
Montgomery Area Single Family Home
Active
7919 Mitchell Farm Lane Montgomery, OH 45242
4 Bed
4 Baths
4017 sqft
MLS# 1882803
A RARE FIND! Stunning, Expansive, Cust Rnch Hm by Kurleman in the Heart of Montgomery. One Flr Living at Its Finest! Open, Light Filled Flr Pln, Soaring 10+ Ceilings, Arch Details. Sprawling LR w/Impressive Flr to Ceiling Stone FP &Wall of Windows open to Very Spacious Kit feat Huge Islnd, Gran, SS Appl & Very Lg Eating Area. Dramatic, Splendid, Angled DR w/Arch Columns. Convenient Stdy w/Frnch Drs &Cust Built-ins. Tranquil Prim Suite w/Dual Vanities, Oversized Shwr &Nice Sized WIC. Fin LL offers Amazingly Generous FR Fit for Media & Billard Rms, 2 Bdrms, 2 FULL Ba &4th Bd/Flex Rm. Priv, Lev Bkyd w/Patio, Perfect for Entertaining. Conveniently Located Near Shopping, Dining & Highway Access &Short Wlk to Charming Dwntwn Montgomery. Elegance & Comfort Best Describes this Exclusive Hm.
Listing Courtesy of CincyMLS / Listed By: Diane Tafuri, Montgomery
CincyMLS / Listed By: Diane Tafuri, Montgomery
$1,075,000 (USD)
Symmes Twp Area Single Family Home
Pending
11880 Spiral Pass Symmes Twp, OH 45249
5 Bed
3.1 Baths
4250 sqft
MLS# 1890434
Welcome to this stately home located within the prestigious Calumet Farm subdivision and Sycamore Schools situated on a .85 acre lot at the end of a private, wooded cul-de-sac! This spacious, move-in condition and updated home features an open floor plan with a remodeled gourmet kitchen that walks out to a large deck with storage below. A highlight of the home is the first floor executive study which has its own separate entrance. The expansive, finished, walk-out lower level has a large rec room, two workstations, a full bath and hobby rm. The primary suite enjoys his 'n hers closets and a luxurious bath! Additional amenities of this delightful property include zoned HVAC with two new furnaces installed '24, HWH '26, Roof '11 which has 30 year dimensional shingles plus an extensive improvements list available online! Within minutes to schools, CHCA, shopping and Harper's Point, this property enjoys a fabulous location!
Listing Courtesy of CincyMLS / Listed By: Celia Carroll, Montgomery
CincyMLS / Listed By: Celia Carroll, Montgomery
$1,062,109 (USD)
Blue Ash Area Single Family Home
Pending
5110 Arabella Cir Blue Ash, OH 45242
3 Bed
2.2 Baths
3139 sqft
MLS# 1761050
PRE-SOLD! Rooftop deck with a bar! Welcome to Arabella at Summit Park! Set park-side on 130 acres in the heart of Blue Ash,this spacious townhome excites with roughly 3100 sq. ft. high end finishes throughout including thermador appliances and site finished hardwood floors. Rear entry garage, open spaces, optional elevator, walkable to all Summit Park has to offer including restaurants/bars. Lot 20
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery
$1,025,000 (USD)
Montgomery Area Single Family Home
Active
9808 Orchard Trail Montgomery, OH 45242
3 Bed
3 Baths
3442 sqft
MLS# 1892323
Experience refined details in this beautifully appointed Camden Homes ranch, ideally positioned on a quiet cul-de-sac in Montgomery. Designed for effortless living, the main level opens to a warm & sophisticated Great Room featuring a gas FP custom built-ins coffered ceilings HW floors tailored window treatments & seamless access to a covered patio for indoor-outdoor entertainment. The gourmet kitchen is equally impressive showcasing a generous island gas cooking & premium luxury appliances. The Primary BR has a walk-out to the patio & attached bath with a luxury shower & dual closets custom built-ins by Closets by Design. Thoughtfully designed for convenience the main-floor laundry is located adjacent to the primary BR. The finished LL includes an additional BR & study a recreation room a wet bar & a gas FP with built-ins. Landscaping is all maintained by the HOA. A spacious two-car garage with epoxy floor coating completes this exceptional offering.
Listing Courtesy of CincyMLS / Listed By: Cheryl Jones, Voice Of America
CincyMLS / Listed By: Cheryl Jones, Voice Of America
$995,000 (USD)
Covington Area Land
Active
Address Not Disclosed Covington, KY 41011
Bed
0 Baths
sqft
MLS# 640807
Available building lot in the Exclusive Park Pointe development. Bring your own builder or let the team at Joshua One guide you through the process of building your dream home.
Listing Courtesy of NORTHERN KENTUCKY / Listed By: Chris Kennedy, Florence
$980,000 (USD)
Symmes Twp Area Single Family Home
Active
11840 Shenandoah Trace Symmes Twp, OH 45140
5 Bed
4.1 Baths
4297 sqft
MLS# 1887424
Meticulously maintained and updated home built by John Hueber boasting approx. 3,900 sq ft plus a Fin LL featuring a rec rm, BR and full bath located on a cul-de-sac within the sought after Sycamore School District! A highlight of the home is the Gourmet Kitchen which is open to the Vaulted FR that walks out to the fenced rear yard. The luxurious primary suite enjoys his 'n hers closets and a stunning primary bath*There are 2 additional bathrooms upstairs including an ensuite*Additional amenities include a fabulous mudroom, dual staircases and a 3 car garage! Extensive updates list available online*AC '20, HWH '19, Furn blower '22*Immediate occupancy too!
Listing Courtesy of CincyMLS / Listed By: Celia Carroll, Montgomery
CincyMLS / Listed By: Celia Carroll, Montgomery
$975,000 (USD)
Melbourne Area Single Family Home
Active
5646 New Drive Melbourne, KY 41059
3 Bed
2 Baths
0 sqft
MLS# 646338
MARTZ COTTAGES ON THE RIVER.... located just past Pendery Park in Melbourne Ky...sitting on 23.3 acres of prime investment- Has been family managed for over 60+years with some tenants residing over 30 years. This is a Diamond in the Rough. Well managed and shows a great investment but could be Much- Much-Much More...with some expanding of facilities; there is room to add more cottages & RV Lots- 10acres of River front could be utilized as well. All cottages and RV/Mobile Home lots. are rented at this time & require notice to view- All sites are tied to Public Water & have septic. Please contact listing agent to set appts. This Mobile Home is in excellent Condition and sits on an amazing site within '' Martz Cottages '' Great way to add income, this home has not been part of rental but lived in by Seller's parent. Now being offered as part of Cottage Investment. The front porch offers a view of the entire community with great yard space, a large two car detached garage and storage shed. The home offers Cathedral ceilings, large rooms and move in ready decor. Laundry offers a walkout to rear yard. Electric HVAC. This unique opportunity could be used as your investment expands. You can live in and use as your Office/ Home or add to your Rental Income. The Mobile home has a separate Title and is being transferred as part of the 23 acre Cottage Investment - Is NOT being sold separately. See Commercial listing for Martz Cottages MLS#646339 at 4068 Fry Street, Melbourne, KY
Listing Courtesy of NORTHERN KENTUCKY / Listed By: Becky "Becky" Orth, Campbell County
$965,000 (USD)
Fort Thomas Area Condo
Pending
1 Highland Avenue Fort Thomas, KY 41075
2 Bed
2 Baths
0 sqft
MLS# 644647
Gorgeous new luxury condos in the heart of Ft Thomas. One level living with elevator to private garage. This residence has a 16x11 covered balcony for viewing street life along Fort Thomas Avenue. There are 10 ft ceilings throughout and features a gathering room with a floor to ceiling bay window. The expressive designer interior finishes are the highest quality w/ wood floors throughout, Amish made cabinetry, SubZero/Wolf appliances, and Kohler fixtures. Underground parking w/ 2 spaces along with storage. Close to dining, arts, parks, and other convenient services and just minutes to Cincinnati/Newport/Covington.
Listing Courtesy of NORTHERN KENTUCKY / Listed By: Aimee Pelletier, Florence
$950,000 (USD)
Cincinnati Area Land
Active
1812 William Howard Taft Road Cincinnati, OH 45206
Bed
0 Baths
sqft
MLS# 1876059
2 lots of Wm Howard Taft. 1812 is 0.567 acres and 1816 is 0.339 acres. Total of 0.906 acres. Shared drive with 1088 WHT. Great location. Easy commute to downtown. Lots must be purchased together but may be developed separately.
Listing Courtesy of CincyMLS / Listed By: Nat Comisar, Kenwood
CincyMLS / Listed By: Nat Comisar, Kenwood
$950,000 (USD)
Mason Area Single Family Home
Active
5143 Whispering Springs Road Mason, OH 45040
5 Bed
4.1 Baths
4303 sqft
MLS# 1887825
Custom built 5 Bedroom 5 Bath updated home w/over 5,000 SF of finished living space & 3 car garage. 2 Sty Great Rm., Gourmet Kit, 1st fl. Office. Dual Staircase to 2nd fl. Private Primary Suite & 4 add. BR's. Finished walk-out LL w/entertainment area, lg wet bar & guest suite. Composite deck overlooks in-ground pool & fenced yard w/mature trees. See Attached Feature Sheet.
Listing Courtesy of CincyMLS / Listed By: Mary Beth Beacher, Voice Of America
CincyMLS / Listed By: Mary Beth Beacher, Voice Of America
$950,000 (USD)
Blue Ash Area Single Family Home
Active
11127 Huntwicke Place Blue Ash, OH 45241
5 Bed
3.1 Baths
4734 sqft
MLS# 1891894
Absolutely exquisite home in pristine condition with a contemporary flair offers approx 3,800 SF plus a finished walk out LL which features a media area, rec rm, wet bar and full bath! A highlight of the home, the remodeled gourmet kitchen is accented by a quartz waterfall island, SS appl and is open to the expansive two-story family room that walks out to the delightful deck and yard! The primary retreat enjoys a luxurious remodeled bath with dual sinks and heated floors. A bonus is the 2nd floor loft which could be used as an additional sitting room, BDRM, or flex space. There is bamboo hardwood flooring throughout the first floor, dual staircases, a first floor laundry and an extensive list of improvements and updates that is available online. Additionally, there is also a substantial side yard with ample room for play structure! Within minutes to Summit Park and the fabulous Blue Ash Rec Center, this home has it all plus has won the Blue Ash Beautification Award not once but twice!
Listing Courtesy of CincyMLS / Listed By: Celia Carroll, Montgomery
CincyMLS / Listed By: Celia Carroll, Montgomery
$949,900 (USD)
Red Stone Village Area Single Family Home
Active
2622 Twin Hills Court Union, KY 41091
4 Bed
5 Baths
0 sqft
MLS# 645173
Experience luxury living with breathtaking water and golf course views from this stunning custom home situated on 1.3 acres. Offering over 5,000 square feet of beautifully designed living space, this exceptional residence features 4 bedrooms, 4.5 baths, and an expansive open-concept floor plan ideal for both everyday living and entertaining. The first-floor primary suite provides a private retreat with pond views and dual walk-in closets. Architectural details abound, including cathedral ceilings, tray ceilings, built-in shelving, and multi-panel doors that flood the home with natural light. The gourmet kitchen is equipped with granite countertops, a gas cooktop, double ovens, and abundant workspace for the home chef. Multiple living areas are anchored by two fireplaces, creating warm and inviting gathering spaces. Step outside from either the kitchen or the walkout lower level to enjoy the hot tub overlooking the pond, where you can relax, take in the scenery, or fish right from your own backyard. New roof 2023, New hardwood floors, New Refrigerator and dishwasher, New paint, Upgraded landscaping and flower beds to name a few upgrades.
Listing Courtesy of NORTHERN KENTUCKY / Listed By: Debbie Bardonaro, Florence
$935,000 (USD)
Mariemont Area Condo
Active
3942 Miami Road Mariemont, OH 45227
2 Bed
2 Baths
1997 sqft
MLS# 1889977
Impeccably maintained 2 bedroom, 2 full bath condo offering effortless living in a prime location. The beautiful kitchen features granite countertops, an island w seating, & it opens seamlessly to a sun filled living room. The spacious dining room includes French doors leading to a versatile sitting area, currently enjoyed as a pub but perfect for a home office or additional sitting room. The inviting primary suite features a custom walk-in closet and an ensuite bath complete w a soaking tub, separate shower, & double vanity. Step outside to the balcony & relax while taking in views of the tree-lined park. Additional highlights include gleaming hardwood floors, crown molding, in-unit laundry, 2 assigned parking spaces in a secure garage, & extra storage. Just a short stroll to Mariemont's shops & restaurants. Don't miss this exceptional opportunity for easy, carefree living!
Listing Courtesy of CincyMLS / Listed By: Molly Zuckerberg, Kenwood
CincyMLS / Listed By: Molly Zuckerberg, Kenwood
$924,900 (USD)
Cincinnati Area Single Family Home
Active
4421 Pin Oak Circle Cincinnati, OH 45209
3 Bed
3.1 Baths
0 sqft
MLS# 1862306
Be among the first to own a brand-new townhome plan by WP Land Company in Foundry Park at Three Oaks. This four-story, 3-bedroom residence offers over 2,400 square feet of well-designed living space, perfectly positioned between the vibrant Homearama® 2025 Row and the community's peaceful park. Enjoy a 4th-floor rooftop level, 2-car garage, site-finished hardwood floors, Thermador appliances, and all the custom-quality finishes that define a WP Land home. Construction has not yet begun, don't miss your opportunity to personalize selections and make it your own. Lot 82.
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery
$924,900 (USD)
Cincinnati Area Single Family Home
Active
4417 Pin Oak Circle Cincinnati, OH 45209
3 Bed
3.1 Baths
0 sqft
MLS# 1844465
Brand new rooftop plan! Be among the first to own the latest townhome plan by WP Land Company in Foundry Park at Three Oaks. This four-story, 3-bedroom residence offers over 2,400 square feet of well-designed living space, perfectly positioned between the vibrant Homearama® 2025 Row and the community's peaceful park. Enjoy a 4th-floor rooftop level, 2-car garage, site-finished hardwood floors, Thermador appliances, and all the custom-quality finishes that define a WP Land home. Construction has not yet begun, don't miss your opportunity to personalize selections and make it your own. Lot 83.
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery
$905,000 (USD)
Fort Thomas Area Condo
Active
1 Highland Avenue Fort Thomas, KY 41075
2 Bed
2 Baths
2071 sqft
MLS# 642218
2BR/2BA. Modern luxury condo in the heart of Ft Thomas. One-level & elevator to private
garage. 16x11 ft. covered balcony for viewing sunsets & green space along the Woodland
neighborhood. Beautiful kitchen with Sub-Zero, Wolf appliances & furniture-grade cabinetry. Gathering room: floor-to-ceiling light-filled bay window & fireplace. Separate dining room. 10ft. ceilings throughout residence. Impeccable craftsmanship. Underground parking: 2 spaces + storage area. Close to services, restaurants & parks. 5 min to regional arts/entertainment.
garage. 16x11 ft. covered balcony for viewing sunsets & green space along the Woodland
neighborhood. Beautiful kitchen with Sub-Zero, Wolf appliances & furniture-grade cabinetry. Gathering room: floor-to-ceiling light-filled bay window & fireplace. Separate dining room. 10ft. ceilings throughout residence. Impeccable craftsmanship. Underground parking: 2 spaces + storage area. Close to services, restaurants & parks. 5 min to regional arts/entertainment.
Listing Courtesy of NORTHERN KENTUCKY / Listed By: Aimee Pelletier, Florence
$900,000 (USD)
Ludlow Falls Area Single Family Home
Active
5640 Horseshoe Bend Ludlow Falls, OH 45339
5 Bed
3.2 Baths
0 sqft
MLS# 1878612
Welcome to this exceptional custom-built home situated on 10 scenic acres, offering approximately 6,200 square feet of finished living space (PRC). With 5 bedrooms, 3 full & 2 half baths, this property combines quality construction, thoughtful updates, and incredible versatility throughout. Attached 3-car garage is extra deep and wide.The main level showcases a dramatic two-story great room with floor-to-ceiling windows and a wood-burning insert fireplace (2016) New wood laminate flooring (2022) in the living room, hallway, office, and dining room, along with fresh paint throughout much of the home. The main level also includes a dedicated office, formal dining room,& an updated laundry room with new flooring and stainless-steel work sink (2025). The remodeled kitchen (2025) features granite countertops, backsplash, stainless farmhouse sink, double oven, ceramic cooktop, bar seating, and eat-in dining space. Updated sliding doors with built-in blinds (2022) lead to the rear deck. The s
Listing Courtesy of CincyMLS / Listed By: Anne S. Goss, CRS, Vandalia
CincyMLS / Listed By: Anne S. Goss, CRS, Vandalia
$899,900 (USD)
Cincinnati Area Single Family Home
Active
4413 Pin Oak Circle Cincinnati, OH 45209
2 Bed
3.1 Baths
0 sqft
MLS# 1844462
Introducing WP Land Company's newest townhome design in Foundry Park at Three Oaks now featuring a 4th floor rooftop level for elevated living and entertaining. Perfectly positioned between the Homearama® 2025 Row and the community park, this four-story residence offers modern architecture, refined spaces, and abundant natural light. 2-car garage, site-finished hardwood floors, Thermador appliances, and all the custom-quality finishes WP Land is known for come standard. Elevator option provides added convenience and long-term accessibility. Construction has not yet begun secure your opportunity to make selections and tailor the home to your style. Lot 84
Listing Courtesy of CincyMLS / Listed By: Tim Mahoney II, Montgomery
CincyMLS / Listed By: Tim Mahoney II, Montgomery 
Heating, A/C, and Roof all replaced within the last 4 years.
A custom expansive deck system connects the home to an impressive heated two-story garage/building, originally designed with the upper level intended for apartment-style living. Whether you're dreaming of a workshop, home business, multigenerational living space, guest quarters, studio, or potential rental opportunity, the possibilities are endless.
This property is ready for its next chapter and will require some TLC. The home is currently cluttered and will need to be emptied, cleaned, and updated, making it an excellent opportunity for buyers looking to add their own style and value. Bring your ideas, creativity, and vision to transform this one-of-a-kind property into something truly special.
With its versatile layout, unique outbuilding, and desirable location, this is a rare chance to create your dream property and build equity along the way. Don't miss the opportunity to bring this great property back to life! Property sold as-is.