My Office's Listings - Michael Cummiskey

$5,000,000 ^(USD)

Liberty Twp Area Land

Pending

6099 Millikin Road Liberty Twp, OH 45011

Bed

0 Baths

sqft

MLS# 1869092

A rare chance to own one of Butler County's most picturesque properties - the former Kern Nursery - offering exceptional potential for development, investment, or private enjoyment. Spanning ~86 acres, the landscape is both scenic and highly usable, featuring a blend of rolling hills, level building areas, mature natural surroundings and peaceful ponds. Whether you envision a neighborhood concept, equestrian use, or simply preserving a large piece of countryside, the property provides flexibility and long-term value. Zoned RA-1, the land supports a range of residential and agricultural uses. Large, contiguous acreage of this size and character is increasingly difficult to find. Located in the highly regarded Lakota Local Schools district. Sanitary sewer is not currently on site; an easement will be required for connection to the county system. Red barn will be removed prior to sale. Offer deadline March 18th (seller reserves the right to accept an offer at any time).

Listing Courtesy of

CincyMLS / Listed By: Michael Hines, Coldwell Banker Realty

$4,911,000 ^(USD)

Indian Hill Area Single Family Home

Active

3 Noel Lane Indian Hill, OH 45243

5 Bed

5.1 Baths

0 sqft

MLS# 1864271

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

Listing Courtesy of

CincyMLS / Listed By: Michael Hines, Coldwell Banker Realty

$3,700,000 ^(USD)

Hamilton Twp Area Single Family Home

Active

9870 Christian Court Hamilton Twp, OH 45140

5 Bed

4.2 Baths

8126 sqft

MLS# 1885333

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

Listing Courtesy of

CincyMLS / Listed By: Rick Finn, Coldwell Banker Realty

$3,470,000 ^(USD)

Hamilton Twp Area Single Family Home

Active

3191 McIntire Road Hamilton Twp, OH 45152

5 Bed

5.1 Baths

7882 sqft

MLS# 1887134

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

Listing Courtesy of

CincyMLS / Listed By: Hillary Justice, Coldwell Banker Realty

$3,250,000 ^(USD)

Indian Hill Area Single Family Home

Pending

6625 N Clippinger Drive Indian Hill, OH 45243

5 Bed

5.1 Baths

6092 sqft

MLS# 1878702

Build with Classic Living Homes on a private, tree lined street in Indian Hill. Approx. 6,100 sq ft, including 1,591 sq ft finished lower level on a 1 acre lot. The main level features a dramatic foyer, expansive great room, private study, and open-concept kitchen with oversized island, walk-in pantry, and seamless flow into the dining area and covered outdoor living spaces including a screened porch and patio with fireplace. Spacious 1st floor primary suite offers a spa-like bath, dressing area, and large walk-in closet. Flexible multi use room, laundry/mudroom, plus attached 1 and 2 car garages. Upstairs includes generously sized secondary bedrooms with ensuite and adjoining bath access. Finished lower level offers media, recreation, exercise, and storage space. Designed for comfortable living and entertaining alike. Or work with Classic Living Homes to design something perfect for you!

Listing Courtesy of

CincyMLS / Listed By: Michael Hines, Coldwell Banker Realty

$3,199,000 ^(USD)

Indian Hill Area Single Family Home

Active

4440 Miami Road Indian Hill, OH 45243

5 Bed

5 Baths

5263 sqft

MLS# 1888974

Unlock the excitement of starting fresh in a new build by Legendary Homes. Over an acre and surrounded by mature trees, this wooded lot is the perfect setting for the incredible 5,263 finished sf build. With 5 bedrooms, 5 baths, & 10ft first floor ceilings. First floor primary ensuite w/ large W.I.C, office, great room w/ fireplace, gourmet eat-in kitchen, private office and expansive covered porch w/ gas fireplace and vews of the creek. On the 2nd level there is a common loft w/ built-ins, 3 bedrooms, an ensuite bath & a jack-n-jill bath and W.I.Cs. In the lower level is full bath, bar, family room & game area. The 3 car garage gives you plenty of storage for cars, bikes, lawn equipment, storage etc. Construction has started. Spring 2027 Completion.

Listing Courtesy of

CincyMLS / Listed By: Patrick Gunning, Coldwell Banker Realty

$2,799,000 ^(USD)

Hamilton Twp Area Single Family Home

Active

9702 Christian Court Hamilton Twp, OH 45140

4 Bed

4.1 Baths

6096 sqft

MLS# 1885431

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

Listing Courtesy of

CincyMLS / Listed By: Michael Hines, Coldwell Banker Realty

$2,495,000 ^(USD)

Indian Hill Area Single Family Home

Pending

7255 Brill Road Indian Hill, OH 45243

4 Bed

4.1 Baths

4729 sqft

MLS# 1886567

Welcome to 7255 Brill Rd, a meticulously maintained & updated 4-bedroom, 4.5-bathroom home situated on over one acre in a coveted walkable neighborhood of Indian Hill. This exceptional property features one of the most breathtaking backyard oases in the Village. Enjoy resort-style living with a pristine, new heated gunite pool & hot tub, complemented by elegant bluestone decking. The spectacular new poolhouse is an entertainer's dream, complete with a fully equipped outdoor kitchen, dining pavilion, cozy gas fireplace, & convenient half bath. Inside, the gourmet kitchen boasts marble countertops, butler's pantry, separate wine/beverage fridges & a nugget ice machine. The luxurious primary suite offers a private balcony, two walk-in closets, & a spa-like bath w/ double vanity, soaker tub, & custom shower. An expansive 4-car garage includes attic storage easily accessible via elevator. Please leave offers open for 48 hrs & no escalation addendums. Seller desires possession until 10/15.

Listing Courtesy of

CincyMLS / Listed By: William "Bill" Draznik, Coldwell Banker Realty

$2,389,000 ^(USD)

Montgomery Area Single Family Home

Pending

62 Gaslight Lane Montgomery, OH 45249

4 Bed

4.2 Baths

0 sqft

MLS# 1855670

Exclusive chance to build on the LAST LOT in the coveted Vintage Club. This Classic Living Homes plan offers 6,000+ finished sq ft, 4 bedrooms, 6 baths and checks every box. A grand foyer leads to a private office and an open staircase. The great room impresses with soaring ceilings, a floor to ceiling stone fireplace & sliding doors to the backyard. Prepare meals in the gourmet kitchen w/ high end appliances, quartz countertops and a walk in pantry. First floor primary sanctuary w/ serene bathroom and enormous WIC. Also on the main level is a flex room; use as a second office, media room, craft room etc. Upstairs, two bedrooms share a Jack & Jill bath, while a third enjoys an ensuite. The expansive LL adds a wet bar, family, rec & exercise rooms. A screened porch with outdoor fireplace extends from the dining area, perfect for entertaining or enjoying fresh air without the hassle of bugs. Take advantage of the community pool in the summer as well as the clubhouse and gym year round!

Listing Courtesy of

CincyMLS / Listed By: Michael Hines, Coldwell Banker Realty

$1,925,000 ^(USD)

Madeira Area Single Family Home

Active

7474 Dawson Road Madeira, OH 45243

5 Bed

5.1 Baths

0 sqft

MLS# 1874032

Discover refined living in the heart of Madeira with this newly constructed custom home by Frazier Homes. Offering over 5,000 sq ft of refined living space, this truly luxury residence blends timeless design with modern functionality. Soaring 10-ft ceilings, wide-plank hardwoods, and walls of windows create a bright, open feel throughout. The chef's kitchen features high end cabinetry, Thermador® appliances, and hidden walk-in pantry. The space flows seamlessly into the great room, dining area, and covered veranda; ideal for everyday living and entertaining. Four spacious bedroom suites offer spa-like baths and large walk-in closets. The finished lower level includes a fifth bedroom suite and flexible space for a gym, media room, or recreation. Complete with a 3-car side-entry garage with EV readiness, all just moments from Madeira's top-rated schools, parks, shops, and dining and minutes to major highways.

Listing Courtesy of

CincyMLS / Listed By: Paige von Hoffmann, Coldwell Banker Realty

$1,899,000 ^(USD)

Montgomery Area Single Family Home

Active

10420 Grandoaks Lane Montgomery, OH 45242

5 Bed

5.1 Baths

5824 sqft

MLS# 1880184

A unique opportunity to build a custom luxury home with Classic Living Homes on a private, wooded lot in the heart of Montgomery. Set on a picturesque cul-de-sac street, this homesite offers the rare combination of privacy, mature trees, sidewalk streets and convenience just minutes from Downtown Montgomery, local parks, shops, dining, and easy access to I-71. This sample plan features timeless architecture, generous living spaces, a first-floor primary suite, covered outdoor living, flexible lower-level space, and room to personalize the home to fit your lifestyle. The final build will be custom, giving buyers the ability to select finishes, details, and design elements that make the home their own. Classic Living Homes is building two new homes side by side, and the lot to the left is already sold. A beautiful setting, a trusted builder, and a rare chance to create something special in one of Montgomery's most desirable locations.

Listing Courtesy of

CincyMLS / Listed By: Michael Hines, Coldwell Banker Realty

$1,800,000 ^(USD)

Cincinnati Area Land

Active

2531 Grandin Road Cincinnati, OH 45208

Bed

0 Baths

sqft

MLS# 1876017

One of the last opportunities to build an estate-scale residence on nearly 3/4 acre along Grandin Road, one of Hyde Park's most coveted streets. Exceptional river-view, new-build-ready homesite in one of Cincinnati's most prestigious neighborhoods. The lot's natural topography is well suited for a walkout basement design, allowing a future home to capture sweeping views of the Ohio River Valley below. The homesite offers a scale and setting well suited for a significant custom residence, allowing for an architecturally distinctive home that responds to the surrounding landscape and elevated views. Less than a mile from the Cincinnati Country Club, a short distance to Hyde Park Square, and minutes from downtown; the ultimate in convenience and tranquility. Offered at a compelling value relative to tear-down opportunities, without the cost, delay, and uncertainty of demolition.

Listing Courtesy of

CincyMLS / Listed By: Michael Hinckley, Coldwell Banker Realty

$1,800,000 ^(USD)

Miami Twp Area Single Family Home

Pending

421 Trailside Woods Court Miami Twp, OH 45140

5 Bed

6 Baths

5185 sqft

MLS# 1885075

J&K Custom Homes is proud to introduce an exquisite, SOLD new home designed specifically for our clients. With planned completion in the Summer 2027, every detail of this home was thoughtfully designed with our clients, the J&K Custom Homes team, and Bowerman Myers Architects. Let us design a home with you on one of our remaining Trailside home sites. Here's a few of our favorite features: this design features an open-concept floor plan with a gourmet kitchen, oversized island, spacious dining area, great room with fireplace, and screened porch for seamless indoor/outdoor living. The main-level primary suite includes a spa-inspired bath and generous walk-in closet, along with a private study, laundry, mudroom, and walk-in pantry. Upstairs features two en-suite bedrooms with walk-in closets. The finished lower level offers a large rec room, exercise room, two additional bedrooms, two full baths, and abundant unfinished storage.

Listing Courtesy of

CincyMLS / Listed By: Michael Hines, Coldwell Banker Realty

$1,776,000 ^(USD)

Miami Twp Area Single Family Home

Active

425 Trailside Woods Court Miami Twp, OH 45140

4 Bed

4.1 Baths

0 sqft

MLS# 1877703

Breaking ground soon! Trailside Estates off Wards Corner Rd near I275, Miamiville, Milford, Loveland and Indian Hill. Be part of this new community of luxury homes. This sprawling ranch plan by J&K Custom Homes has 4 bedrooms, 4.5 baths, and 5,100+ sq ft of thoughtfully crafted space. The open layout flows from the gourmet kitchen with high-end appliances and quartz surfaces to a spacious great room with fireplace, built-ins, and patio access. Hardwood floors, tall ceilings, and premium finishes throughout. Main level highlights include a luxe primary suite, walkout dining room to a covered deck with outdoor fireplace, a den (or office / optional 5th bedroom), and a 3-car garage. The finished lower level is sure to impress: two bedrooms, two full baths, a rec room w/ wet bar, home office, media room, golf simulator, and a gym. This home truly has it all! Construction expected to be finished by early Spring/Summer 2027.

Listing Courtesy of

CincyMLS / Listed By: Michael Hines, Coldwell Banker Realty

$1,750,000 ^(USD)

Miami Twp Area Single Family Home

Pending

417 Trailside Woods Court Miami Twp, OH 45140

4 Bed

4.1 Baths

5152 sqft

MLS# 1862697

Brand-new development! Trailside Estates off Wards Corner Rd near I-275, Miamiville, Milford, Loveland, and Indian Hill. Enjoy this expansive J&K Custom Homes ranch or design your own. This home has 4 bedrooms, 4.5 baths, and 5,100+ sq ft of thoughtfully crafted space. The open layout flows from the gourmet kitchen with high-end appliances and quartz surfaces to a spacious great room with fireplace, built-ins, and patio access. Hardwood floors, tall ceilings, and premium finishes throughout. Main level highlights include a luxe primary suite, walkout dining room to a covered deck with outdoor fireplace, a den (or office / optional 5th bdrm), and a 3-car garage. The finished lower level is sure to impress: two bedrooms, two full baths, a rec room w/ wet bar, home office, media room, golf simulator, and a gym. This home truly has it all!

Listing Courtesy of

CincyMLS / Listed By: Michael Hines, Coldwell Banker Realty

$1,749,900 ^(USD)

Rising Sun Area Single Family Home

Pending

7788 White Road Rising Sun, IN 47040

5 Bed

3.1 Baths

5298 sqft

MLS# 1858862

Escape to your own private paradise on 40 breathtaking acres surrounded by nature. This extraordinary property features a serene pond, wooded trails, and multiple structures blending rustic charm with modern comfort. The lodge-style main home offers panoramic water views and a stunning fountain and waterfall flowing through the circle drive into the pond, creating an unforgettable setting. Currently a successful short-term rental property, the estate includes a fully restored 1800s log cabin, a large workshop, and an oversized garage with an apartmentperfect for guests or caretakers. Outdoor living shines with multiple decks, a covered dock house, and beautifully landscaped spaces ideal for gatherings, relaxation, or recreation. Enjoy fishing, hiking, kayaking, and wildlife watchingall just a short drive from Cincinnati and CVG. A one-of-a-kind property with endless potential as a private estate, income-producing getaway, or family retreat.

Listing Courtesy of

CincyMLS / Listed By: Adam Hayhow, Coldwell Banker Realty

$1,679,000 ^(USD)

Cincinnati Area Single Family Home

Active

2945 Three Oaks Ln Cincinnati, OH 45209

3 Bed

3.2 Baths

4131 sqft

MLS# 1871445

Don't miss one of our FAVORITE designs to date, located in Foundry Park at Three Oaks (Homearama 2025). This Classic Living Homes custom build boasts an elegant exterior with a thoughtfully designed interior. Spanning four stories and 4,131 sqft, this home offers unparalleled luxury and convenience. This unique lot includes a private courtyard on the ground level, while an elevator ensures effortless access to all floors. Don't miss the screened-in porch, ideally situated just off the gourmet kitchen, dining area, and great room, perfect for seamless indoor-outdoor living. The 3rd floor is home to the generous primary suite, a second suite and laundry room. On the 4th floor, you'll find a spacious media loft, flex room/wine room, and access to the huge rooftop deck. Located in vibrant Oakley, this home is just blocks from the lively restaurants, bars, and shops along Madison Rd and minutes from the amenities at Factory 52. This is urban living at its finest AND tax abatement eligible.

Listing Courtesy of

CincyMLS / Listed By: Michael Hines, Coldwell Banker Realty

$1,644,000 ^(USD)

Montgomery Area Single Family Home

Pending

9500 Todd Drive Montgomery, OH 45242

4 Bed

3.1 Baths

4802 sqft

MLS# 1843583

Build with Classic Living Homes, steps from Swaim Park and the vibrant shops and restaurants of downtown Montgomery. This exceptional home is over 4,800sqft and features a stunning great room with a coffered ceiling and a cozy fireplace, setting the tone for elegant yet functional living. The gourmet kitchen features quartz countertops and a hidden butler's pantry w/ a second sink, perfect for discreet prep work or bulky countertop appliances. Just beyond the formal dining room, a office/den reveals a secret door leading to a hidden room, ideal for storing a safe, important documents, or just a private retreat. All four bdrms upstairs, including a luxurious primary suite with a spa like ensuite bath and walk-in closet. A versatile loft area provides the perfect space for homework or 2nd office. Step outside to a covered porch off the great room, perfect for relaxing evenings or weekend gatherings! Build this house or adjust the plan to fit your needs! Option to add elevator.

Listing Courtesy of

CincyMLS / Listed By: Michael Hines, Coldwell Banker Realty

$1,600,000 ^(USD)

Madeira Area Single Family Home

Pending

7317 Euclid Avenue Madeira, OH 45243

5 Bed

4.2 Baths

0 sqft

MLS# 1854513

This one of a kind custom Everlasting Estates LLC build is luxury living at its finest. With over 5,800 sq.ft. your dream home boasts 10 ft. ceilings throughout with an expansive and open 18 ft. coffered ceiling great room, finished basement with wet bar, 4 car garage, second floor walkout/roof deck, and several other custom finishes. The desirable location is in Madeira central business district and is walking distance to restaurants, library and shopping. Currently under construction. *Back on due to Buyer unable to obtain financing*

Listing Courtesy of

CincyMLS / Listed By: Leah Thamann, Coldwell Banker Realty

$1,595,000 ^(USD)

Miami Twp Area Single Family Home

Active

6695 Loveland Miamiville Road Miami Twp, OH 45140

5 Bed

4.1 Baths

5034 sqft

MLS# 1886348

Five Daughters Construction build on 1.5 acres. To be Built. Loveland City schools in Miami Township. Over 5,000sf of finished space. First floor primary bedroom. Massive covered porch and wooded views. Custom amish made kitchen cabinets & oversized pantry. mud room with built-ins. Home office. Finished basement including full bathroom. Rare acreage and close proximity to shops and restaurants in downtown Loveland.

Listing Courtesy of

CincyMLS / Listed By: Patrick Gunning, Coldwell Banker Realty

$1,595,000 ^(USD)

Madeira Area Single Family Home

Active

6041 Johnson Street Madeira, OH 45243

5 Bed

5 Baths

3237 sqft

MLS# 1865505

New Construction from Legendary Homes. Starting construction soon in Madeira! This incredible home features approx. 3,237sf, 9' ceilings, first floor primary, 2-story great room with gas fireplace, gourmet eat-in kitchen, 1st floor study & flex room, sizable primary suite, oversized 2 car garage with side entry garage door for golf cart storage, covered rear patio with gas fireplace, finished basement with wet bar, basement bedroom & ensuite. Set on a spacious lot near Kenwood Country Club with easy shopping & highway access. Expected completion end of 2026.

Listing Courtesy of

CincyMLS / Listed By: Patrick Gunning, Coldwell Banker Realty

$1,589,000 ^(USD)

Hamilton Twp Area Single Family Home

Active

0 Heath Court Hamilton Twp, OH 45140

5 Bed

5.1 Baths

4883 sqft

MLS# 1864311

Contemporary two-story home by J&K Custom Homes in the desirable Chimney Ridge neighborhood. Actively under construction with completion planned for Fall 2026! Offering 5 bedrooms, 5.5 baths, and 4,800+ finished sf, this home truly has it all. The welcoming entry features a home office to the right and, to the left, a hallway leading to the powder bath and a convenient 1st floor bedroom. The great room showcases a beamed ceiling, fireplace, and floating shelves, flowing seamlessly into the gourmet kitchen with top-of-the-line appliances, quartz countertops and backsplash, plus a wet bar. Enjoy hardwood floors throughout the main level, 9-foot ceilings, and a walk-in butler's pantry. The primary suite boasts a large walk-in closet and spa-like bath. The upstairs bedrooms have their own ensuite baths and walk in closets. The finished basement offers a rec room and fifth bedroom w/ full bath. A spacious three-car attached garage connects to a back hall with cubbies and coat closets.

Listing Courtesy of

CincyMLS / Listed By: Michael Hines, Coldwell Banker Realty

$1,525,000 ^(USD)

Loveland Area Single Family Home

Pending

19 Chimney Ridge Drive Loveland, OH 45140

5 Bed

3.1 Baths

3527 sqft

MLS# 1828593

Beautiful, contemporary two story home by J&K Custom Homes located in the Chimney Ridge neighborhood. With 5 bedrooms, 3.5 bathrooms, and 3,800 square feet, this home checks all the boxes. Upon entering, you'll find a home office to your right and to your left, a hallway to the pwdr bath, coat closet and a flex use room. The beamed ceiling great room features a fireplace, floating shelves and flows directly into a gourmet kitchen with top-of-the-line appliances, quartz countertops/backsplash and a separate walk-in wet bar. Hardwood flooring throughout main level, 9ft ceilings and walk in butler's pantry. Primary suite features a huge walk in closet & luxurious primary bath. Bedroom 2 features an attached bath, bedrooms 3 and 4 share a jack and jill with dual vanities. Finished rec room & 5th bdrm/flex room in basement. Spacious, 3 car attached garage with direct entrance into back hall with coat closets and cubbies. Or, work with the builder to customize a plan that works for you!

Listing Courtesy of

CincyMLS / Listed By: Michael Hines, Coldwell Banker Realty

$1,489,000 ^(USD)

Anderson Twp Area Single Family Home

Pending

807 Birney Lane Anderson Twp, OH 45230

5 Bed

4.1 Baths

5456 sqft

MLS# 1886020

A rare offering in Anderson Township's Watch Hill area, this extraordinary estate sits on nearly 2 manicured acres and showcases timeless architecture, rich history, and exceptional craftsmanship. Built in 1937 by renowned builders Kopf & Kopf and designed by acclaimed architect Luigi Marioni, the home has been thoughtfully expanded to accommodate convenient first-floor living. The addition features a second kitchen and a luxurious primary suite, creating incredible flexibility for multigenerational living, extended guests, or private accommodations. The residence now offers two kitchens and two primary suites, while every bedroom enjoys the comfort and privacy of an adjoining bath. Outside, the grounds are highlighted by a circular driveway, mature landscaping, an original concrete swimming pool, and a slate roof that complements the home's historic character. A truly rare opportunity to own one of Cincinnati's architecturally significant estates.

Listing Courtesy of

CincyMLS / Listed By: Adam Hayhow, Coldwell Banker Realty

$1,475,000 ^(USD)

Cincinnati Area Condo

Active

26 E Sixth Street Cincinnati, OH 45202

3 Bed

3.1 Baths

2061 sqft

MLS# 1876722

Welcome to your urban oasis right in the heart of the central business district, just a hop, skip, and a jump from the Fountain District! This amazing urban loft boasts incredible custom finishes throughout the 3-story condominium, including a private rooftop deck. Imagine a massive 30 x 21 great room that flows seamlessly into the dining area and gourmet kitchen, plus a wine storage area, three bedrooms all with en suite full baths, and a family room on the top floor that features a bar and a walkout to the private deck perfect for entertaining! This property has a truly unique floor plan with 15-foot ceilings, and it also includes two indoor parking spots and some lovely upgrades.

Listing Courtesy of

CincyMLS / Listed By: Brian Tiffany, Coldwell Banker Realty

$1,450,000 ^(USD)

Terrace Park Area Single Family Home

Active

811 Myrtle Avenue Terrace Park, OH 45174

5 Bed

4.1 Baths

4517 sqft

MLS# 1886813

A masterfully reimagined Michaelson Homes custom renovation, with meticulous attention to detail define every space! Situated on the coveted 800 block of Myrtle, steps to parks, school, & bike trail, this extraordinary home offers refined living in the heart of Terrace Park. The expanded chef's kitchen showcases bespoke cabinetry, premium appliances, an oversized eat-in gathering space, soaring ceilings, and a bay window overlooking the professionally landscaped, fenced yard. The vaulted family room with gas fireplace opens to the inviting pub room with wet bar and wine fridges offering sophisticated entertaining or office space. The beautifully appointed laundry room is designed for effortless organization, while the mudroom features abundant storage & both have heated floors. 1st floor primary suite w/ spa-inspired bath & oversized walk-in closet. 4 additional bedrooms and 2 full baths upstairs, a fin LL with full bath, & an oversized 2-car garage complete this exceptional offering!

Listing Courtesy of

CincyMLS / Listed By: Amy Roe, Coldwell Banker Realty

$1,400,000 ^(USD)

Deerfield Twp Area Single Family Home

Active

2558 Western Row Road Deerfield Twp., OH 45039

3 Bed

3 Baths

3482 sqft

MLS# 1884790

Private 7-acre estate in Deerfield Township! Completely renovated 4-bed, 2.5-bath home with soaring ceilings and walls of windows overlooking rolling views. Resort backyard features a stunning in-ground pool, fire pit, babbling brook, and sports field. Detached boat barn + room for horses. Kings Local Schools. The ultimate blend of seclusion and convenience minutes to the Little Miami River!

Listing Courtesy of

CincyMLS / Listed By: Patrick Gunning, Coldwell Banker Realty

$1,399,000 ^(USD)

Newport Area Single Family Home

Active

765 E 11 Street Newport, KY 41071

3 Bed

4 Baths

0 sqft

MLS# 636653

Experience elevated living with Ashford Custom Homes' latest luxury build. Perched on Wiedemann hill in the Northern Lights subdivision, you're promised unparalleled, panoramic views of the Cincinnati skyline. With an elevator linking all levels, the home showcases wide-plank hardwoods, a gourmet chef's kitchen, a stylish wet bar, a secluded home office, and an expansive rooftop deck—perfectly blending luxury, function, and convenience. The second level is designed for entertaining, featuring an open-concept flow from the kitchen through the dining and living areas to a covered deck with breathtaking views. The primary suite lives on its own floor for ultimate privacy, while two additional bedrooms below. The walkout lower level offers a family room, half bath, and a second office or flex space. All of this in an unbeatable location—just 10 minutes to Paycor Stadium and The Banks and moments from Newport Pavilion.

Listing Courtesy of NORTHERN KENTUCKY / Listed By: Michael Hines, Coldwell Banker Realty

Cincinnati Area Single Family Home

Active

4454 Water Oak Circle Cincinnati, OH 45209

3 Bed

3.2 Baths

3479 sqft

MLS# 1862618

Classic Living is bringing its signature luxury style to Foundry Park at Three Oaks, the exclusive community that hosted Homearama 2025. Experience the best of urban living in Oakley, blocks from the vibrant restaurants and shops of Madison Road, and minutes from the new Factory 52 development. This thoughtfully designed (LEED Certified, tax abatement eligible) 3,400+ sf home features 3 bedrooms, 3 full baths, and 2 half baths with a modern, open-concept layout ideal for entertaining. Navigate all 3 levels with ease using the elevator. The main floor includes a welcoming great room w/ custom built-ins and a fireplace, along with a spacious kitchen boasting a large island and walk-in pantry. Two generous bedroom suites upstairs along w/ a convenient laundry room. The family room on the third level is perfect for gatherings. The LL is a great flex space: use as 3rd bedroom or home office, a third full bath, and direct garage entry. Or work with the builder to design your dream house!

Listing Courtesy of

CincyMLS / Listed By: Michael Hines, Coldwell Banker Realty

$1,295,000 ^(USD)

Goshen Township Area Land

Pending

0 St Rt 48 128.19ac Goshen Township, OH 45122

Bed

0 Baths

sqft

MLS# 1529986

Excellent ingress/egress for Development of Residential SF or PUD. Partially cleared/wooded 50/50 +/-.

Listing Courtesy of

CincyMLS / Listed By: Robert Nally, Coldwell Banker Realty

$1,295,000 ^(USD)

Deerfield Twp Area Single Family Home

Active

9867 Kensington Lane Deerfield Twp., OH 45040

4 Bed

3.1 Baths

0 sqft

MLS# 1858567

Build with Fry Homes on the LAST available lot in the coveted Kensington subdivision. Over half an acre set back on a private, flag lot (no direct neighbor on one side). This Fry Home build features 3,306 finished sqft, four bedrooms and 3.5 baths. Enjoy a generous home office, expansive great room, gourmet kitchen and a first floor primary wing. The dining area opens onto the large, covered back porch. Level two features 3 bedrooms, 2 full baths and an open loft area. Still time to make this home your own or design a plan perfect for YOU.

Listing Courtesy of

CincyMLS / Listed By: Bob Hines, Coldwell Banker Realty

$1,290,000 ^(USD)

Cincinnati Area Single Family Home

Active

548 Liberty Hill Cincinnati, OH 45202

3 Bed

3.1 Baths

4305 sqft

MLS# 1882173

One of the finest homes in Mt. Auburn's historic Prospect Hill. Double lot with signature landscaping/ gardens. Charming outdoor living spaces. Grand room sizes, high ceilings, and impossible to replicate architectural details. Reclaimed antique hardwood floors, custom cabinetry, and high end finishes throughout. Elevator to all floors. Two car garage. City views. Close to all that downtown, OTR, and Covington have to offer. Sophisticated, warm, and inviting city living at it's absolute best. A rare opportunity.

Listing Courtesy of

CincyMLS / Listed By: Michael Franz, Coldwell Banker Realty

$1,289,000 ^(USD)

Cincinnati Area Single Family Home

Pending

4466 Water Oak Circle Cincinnati, OH 45209

3 Bed

3.2 Baths

3479 sqft

MLS# 1854933

Classic Living is bringing its signature luxury style to Foundry Park at Three Oaks, the exclusive community hosting Homearama 2025. Experience the best of urban living in Oakley, just blocks from the vibrant restaurants and shops of Madison Road, and minutes from the new Factory 52 development. This thoughtfully designed, tax abated, 3,400+ sf. home features 3 bedrooms, 3 full baths, and 2 half baths with a modern, open-concept layout ideal for entertaining. Navigate all 3 levels with ease using the elevator. The main floor includes a welcoming great room w/ custom built-ins and a fireplace, along with a spacious kitchen boasting a large island and walk-in pantry. Two generous bedroom suites upstairs along with a convenient laundry room. The rooftop level offers a family room, full bath, and access to a sprawling covered outdoor living area, perfect for gatherings. The lower level is a great flex space, use as third bedroom or home office, a 3rd full bath, and direct garage entry.

Listing Courtesy of

CincyMLS / Listed By: Michael Hines, Coldwell Banker Realty

$1,260,000 ^(USD)

Symmes Twp Area Single Family Home

Pending

11403 Avant Lane Symmes Twp, OH 45249

4 Bed

3.1 Baths

0 sqft

MLS# 1828398

Experience the luxury of Fry Homes in the sought-after Hartland community with this stunning new construction, ranch-style home. Set in a prime location in Sycamore Schools w/ a well-established neighborhood, Hartland offers expansive lots and picturesque tree-lined streets. This plan features 2,200sf on the main level AND another 1,300 Sf of finished space in the basement. An expansive great room featuring a cozy fireplace welcomes you and seamlessly flows into the gourmet kitchen and dining area. Just off the dining area, enjoy a covered back deck. Don't miss the convenient laundry room and mudroom. The 1st flr primary suite has a spa like bathroom and walk-in closet. Two more bedrooms on the main floor share a well-appointed hall bath, while the fourth bedroom in the lower level has access to a third full bath. The LL features a large family room and a versatile flex-use room; perfect for an office, gym etc. Build this home or modify the plan to suit your needs! Agent owned.

Listing Courtesy of

CincyMLS / Listed By: Michael Hines, Coldwell Banker Realty

$1,252,642 ^(USD)

Cincinnati Area Single Family Home

Pending

212 W Fifteenth St D Cincinnati, OH 45202

7 Bed

6 Baths

sqft

MLS# 1530869

Single family town home in OTR! High end, luxury urban living at its best. Built by Homearama Builder, Daniels Homes. 2 car garage, 2+ bedrooms, covered deck. Still time to make custom selections & options. Great location - walk to Washington Park, OTR restaurants&Findlay Market. Optional fin ground level & elevator. Expected completion winter '1

Listing Courtesy of

CincyMLS / Listed By: Cathy Heckman, Coldwell Banker Realty

$1,250,000 ^(USD)

Cincinnati Area Single Family Home

Active

1430 Riverside Drive Cincinnati, OH 45202

3 Bed

3.1 Baths

3268 sqft

MLS# 1875868

Welcome to your turn-key Riverside home in Twain's Point. End-unit, luxury upgrades thruout, lock & leave lifestyle. Riverfront park system at your doorstep: walking paths, pickle ball, bike lanes. Moments to dwntwn dining, shopping, events, employers. Fabulous views of Ohio River, hills of KY, Cincy Skyline! Gourmet kit w/island, cntr bar, granite, new Sub-Zero refrig, gas cooktop, wine cooler. Entertaining is a breeze w/ open/bright liv/din space, 2 private balconies & patio. Hdwd flrs thruout main living & upstairs bdrm level. Stunningly upgraded primary bathroom w/ dble vanity, walk-in shower, soak tub, heated flrs. New custom blinds in primary ste w/ fireplace, built-ins. End-unit, bonus rooms include main floor office/study w/ built-in bookshelves & 15x12 1st flr exer/wrkshp/hobby/storage. 2 car+ gar w/ custom cabinet, refrig. 3,200+ SF w/3 ensuite bdrms/full ba, 1/2 ba main liv level, crown molding, builtin, 2FP Great value considering Lux options on river in EE!

Listing Courtesy of

CincyMLS / Listed By: Tim Hinde, Coldwell Banker Realty

$1,250,000 ^(USD)

Cincinnati Area Single Family Home

Active

221 W Fifteenth Street Cincinnati, OH 45202

4 Bed

3.1 Baths

0 sqft

MLS# 1890294

Welcome to 221 W 15th Street! This luxury home offers 4 bedrooms and 3.5 bathrooms with exceptional entertaining spaces throughout. The open-concept first floor features hardwood floors, a gourmet kitchen with stainless steel appliances and oversized island, formal dining area, and covered deck. The second floor showcases a spacious primary suite with a private walkout overlooking downtown, luxurious en-suite bath with double vanities, abundant storage, and an impressive walk-in closet. Two additional bedrooms, full bath, and laundry complete the level. The third-floor rooftop deck offers stunning city views. Finished lower level includes a fourth bedroom, full bath, additional living space, and access to the garage. Ideally located near Findlay Market, Washington Park, Music Hall, and TQL Stadium.

Listing Courtesy of

CincyMLS / Listed By: Megan Stacey, Coldwell Banker Realty

$1,225,000 ^(USD)

Blue Ash Area Single Family Home

Pending

4049 Retreat Drive Blue Ash, OH 45241

3 Bed

3 Baths

3868 sqft

MLS# 1888752

The Retreat at Summit Park. Like New, Craftsman home. Summerhill floor plan with no detail left undone. Natural light fills the entire home, with wooded views from both levels. Gourmet kitchen with full-height cabinets, pantry, induction cooktop, granite counters and large island. Open floor plan allows for easy living and entertaining. 10' ceilings on main level with 9' ceilings in lower level. Deck features power blinds, heaters and a gas line rough-in. Gutter guards, closet systems and brand new carpet throughout the entire lower level and stairs plus freshly painted exterior trim, are just a few of the recent updates. EV charger in the spacious 2-car garage.

Listing Courtesy of

CincyMLS / Listed By: Molly Eynon, Coldwell Banker Realty

$1,214,448 ^(USD)

Union Twp Area Single Family Home

Pending

3205 Garden View Court Union Twp, OH 45152

3 Bed

3.1 Baths

0 sqft

MLS# 1860572

Experience the perfect blend of modern comfort and sustainable living in this gorgeous new Pendragon Homes build, located in a unique community-supported agriculture (CSA) neighborhood. Here, fresh, locally grown produce and a welcoming community are part of everyday life all while enjoying the ease and beauty of a brand new, low maintenance home.

Listing Courtesy of

CincyMLS / Listed By: Jason Curlee, Coldwell Banker Realty

$1,200,000 ^(USD)

Goshen Twp Area Single Family Home

Active

6650 Simons Lane Goshen Twp, OH 45140

5 Bed

3 Baths

0 sqft

MLS# 1884989

Situated at the end of a long private drive, this extraordinary 20-acre property offers the perfect blend of history, privacy, and endless possibilities. Built in 1830, the charming farmhouse features 4 bedrooms, including a spacious first-floor primary suite with vaulted ceilings, hardwood floors, and walkout access, plus 2 full baths on the main level and a generous family room addition. Step outside and enjoy your own private retreat with an in-ground pool, hot tub, stocked pond, barn, chicken coop, and beautiful open spaces. Whether you're dreaming of a hobby farm, private estate, multigenerational living, or simply a peaceful escape, this one-of-a-kind property offers a lifestyle that's nearly impossible to find. Come experience the possibilities.

Listing Courtesy of

CincyMLS / Listed By: Amy Vilardo, Coldwell Banker Realty

$1,195,000 ^(USD)

Blue Ash Area Single Family Home

Active

5000 Belleview Avenue Blue Ash, OH 45242

5 Bed

4.1 Baths

4403 sqft

MLS# 1878471

New construction by John Henry Homes in the heart of Blue Ash! The Willow offers approx. 4,403 finished sq ft with 5 bedrooms, 4 full baths, and thoughtfully designed living spaces throughout, including a finished lower level for added entertaining and flex space. Features include 9' ceilings on the first floor, hardwood flooring, a gourmet kitchen with quartz countertops and stainless steel appliances, private study with French doors, formal dining room plus breakfast area, and a luxurious primary suite with raised tray ceiling and walk-in shower. Step outside to a covered patio with outdoor fireplace, creating the perfect year round gathering space. Tile baths and laundry add to the upscale feel throughout. Situated on a flat, .56 acre lot on a beautiful tree-lined street. Just minutes to the Blue Ash YMCA!

Listing Courtesy of

CincyMLS / Listed By: Bob Hines, Coldwell Banker Realty

$1,181,000 ^(USD)

Cincinnati Area Single Family Home

Active

6944 Old Stone Ridge Cincinnati, OH 45233

3 Bed

2.1 Baths

0 sqft

MLS# 1872134

Custom Ranch style home by Dennis Ott Builders in Old Stone Ridge. Designed for both everyday living and entertaining, this open floorplan features 9+ ft ceilings, spacious great room with fireplace flows to gourmet eat-in kitchen with island bar & dining space with walkout to covered deck. First floor primary suite includes adjoining full bath with double vanities & walk-in closet; private 1st floor study. Finished walk-out lower level features expansive family room, 2 additional bedrooms & full bathroom. Other lots available to build your dream home!

Listing Courtesy of

CincyMLS / Listed By: Ronald "Ron" Bisher, Coldwell Banker Realty

$1,175,000 ^(USD)

Mason Area Single Family Home

Active

5018 Ainsley Drive Mason, OH 45040

5 Bed

4 Baths

0 sqft

MLS# 1878297

Fabulous new Drees Brennan MODEL home on a coveted cul-de-sac just minutes from premier shopping/ dining/ VOA Park/ scenic bike trails/ I-71 & I-75! Luxurious 1st floor primary suite plus guest suite - walkout finished lower level with finished bedroom #5 & bath - wonderful 1st floor covered terrace with fireplace - 9' ceilings - Quartz counters - French doors - volume ceilings - neutral decor - thoughtfully designed for multi generational living - immediate occupancy too! Leave offers open for 48 hours, seller reserves the right to accept an offer prior. No escalation clauses.

Listing Courtesy of

CincyMLS / Listed By: Michael Hinckley, Coldwell Banker Realty

$1,149,900 ^(USD)

Mason Area Single Family Home

Pending

5433 Birch View Drive Mason, OH 45040

5 Bed

4.2 Baths

5341 sqft

MLS# 1885345

Designed for gathering, entertaining, and everyday living, this exceptional five-level home offers over 4,300 sq ft above grade plus nearly 1,000 sq ft of finished lower-level living space. The open-concept kitchen features custom cabinetry, stainless steel appliances, a large island, butler's pantry, and expanded morning room that flows into the soaring two-story family room with a floor-to-ceiling cultured stone fireplace. A private guest suite with a full bath, just a half-flight from the main living area, offers flexible space for guests, a home office, or extended stays. Upstairs, the owner's retreat features dual walk-in closets and a spa-inspired bath, plus three additional bedrooms, a loft, and second-floor laundry. The finished lower level offers a wet bar, half bath, and recreation area. Outside, enjoy a covered patio, built-in outdoor kitchen, stone fireplace, gas fire pit, seating wall, and expansive patio in Crooked Tree Preserve, served by Mason City Schools.

Listing Courtesy of

CincyMLS / Listed By: Jennifer "Jenna" Obrock, Coldwell Banker Realty

$1,100,000 ^(USD)

Cincinnati Area Multi-Family Home

Active

916 York Street Cincinnati, OH 45214

Bed

0 Baths

5424 sqft

MLS# 1878960

Historic Italianate Estate with Carriage House has been restored, reimagined and built to perform! Few properties deliver both architectural excellence & income-producing potential in equal measure. This remarkable double-lot property represents a complete transformation: taken to the studs, reimagined by a professional designer, & meticulously restored inside & out to honor its character while meeting every expectation of modern luxury living. The main residence offers 2 generously appointed units. The carriage house provides 2 additional apartments. 4 income streams within one distinguished address. Rare to find this amount of outdoor space that is well-suited for the lifestyle of today's discerning tenants. Whether envisioned as a turnkey investment portfolio, a multi-generational family compound, or a boutique short-term rental, the possibilities are endless! Situated in Cincinnati's historic urban core, with tree-lined streets, vibrant culture, and full city convenience!

Listing Courtesy of

CincyMLS / Listed By: Rick Finn, Coldwell Banker Realty

$1,100,000 ^(USD)

Cincinnati Area Single Family Home

Pending

2969 Walworth Ave Lt 24 Cincinnati, OH 45226

3 Bed

3.1 Baths

sqft

MLS# 1674029

Site of HOMEARAMA® 2020! Save & build an incredible, 1st class home by Sterling Homes, Cincinnati's most loved custom builder! Includes ~3,100sf, river & city views, elevator, rear entry 3 car garage, huge entertaining spaces & gorgeous front elevation - all within a brand new community, Walworth Junction! Build or customize this plan with Sterling!

Listing Courtesy of

CincyMLS / Listed By: Michael Hines, Coldwell Banker Realty

$1,079,680 ^(USD)

Union Twp Area Single Family Home

Pending

1017 Garden View Court Union Twp, OH 45152

3 Bed

3 Baths

0 sqft

MLS# 1862192

Embrace a lifestyle that celebrates fresh, locally grown produce and a strong sense of community, all while enjoying the ease and elegance of a brand-new, low-maintenance residence. As a resident, you'll enjoy the added benefit of the CSA program, providing fresh, in-season produce weekly for just $850 per year. This farm-to-table community is conveniently located only minutes from local dining and shopping, offering both tranquility and accessibility. Looking for something different? Choose from one of Pendragon Homes' multiple floor plans, or customize, to find what suits your needs best!

Listing Courtesy of

CincyMLS / Listed By: Jason Curlee, Coldwell Banker Realty

$1,050,000 ^(USD)

Clearcreek Twp Area Single Family Home

Pending

118 Creekwood Court Clearcreek Twp., OH 45066

6 Bed

4.1 Baths

5801 sqft

MLS# 1886360

Nestled on a private one-acre homesite backing to a peaceful greenbelt, Creekwood Manor seamlessly blends timeless architecture with modern luxury. A stately brownstone and ledgestone exterior, sweeping driveway, and dramatic two-story entry set the stage for over 5,800 square feet of beautifully designed living space. Inside, soaring ceilings, hardwood floors, walls of windows, and custom millwork create an elegant yet inviting atmosphere. The gourmet kitchen features cherry cabinetry, granite countertops, premium appliances, and opens to the impressive great room. A luxurious main-level primary suite, expansive lower-level recreation room with wet bar, and flexible guest spaces provide exceptional comfort. Outdoors, enjoy professionally landscaped grounds, a stamped-concrete patio, outdoor kitchen, stone fire pit, pergolas, and a covered gazebo. Ideally located in Stone Ridge near downtown Springboro, parks, shopping, dining, and top-rated schools.

Listing Courtesy of

CincyMLS / Listed By: Varun Varma, Coldwell Banker Realty

$1,050,000 ^(USD)

Madeira Area Single Family Home

Active

7845 Euclid Avenue Madeira, OH 45243

3 Bed

3 Baths

2926 sqft

MLS# 1869604

To be Built. Welcome to Laurel Crossing! This unique development includes 5 new detached ranches and 5 new detached homes all within short walking distance to downtown Madeira. The new Ranches are 2,946 sq/ft, include 3bdrs, 3 baths, 2 car garage, all custom finishes incl large kitchen island w Thermador, finished LL & abundant landscaping. Madeira-always rated Top 3 Burbs in Cincinnati in Cincy Magazine! See 7832 Laurel for the Townhome plans & selections. The final ranch available in the community.

Listing Courtesy of

CincyMLS / Listed By: Patrick Gunning, Coldwell Banker Realty

$1,050,000 ^(USD)

Anderson Twp Area Single Family Home

Active

2121 Clough Chase Drive Anderson Twp, OH 45244

4 Bed

4.1 Baths

4081 sqft

MLS# 1888903

So many features in this beautiful new build from Five Daughters Construction. Over 4,100 finished sqft of open concept living. Soaring 18' Great Room ceilings & massive windows overlooking private wooded view. 9' ceilings in basement and 1st floor. The walkout finished basement is perfect for entertaining and accompanies a full bath. Spacious composite deck overlooks yard. Also spacious & private side yard can be converted into fire pit or garden. Immediate Occupancy

Listing Courtesy of

CincyMLS / Listed By: Patrick Gunning, Coldwell Banker Realty

$999,900 ^(USD)

Deerfield Twp Area Single Family Home

Active

8050 Duke Boulevard Deerfield Twp., OH 45040

4 Bed

4.1 Baths

0 sqft

MLS# 1890343

Why spend the next 9-12 months building and pay today's construction costs when this home is already done? Built by Fischer Homes just two years ago, this Mitchell floor plan comes loaded with nearly $200,000 in upgrades including a brand-new deck added this year. The same home you'd design if you started from scratch minus the wait. The finished lower level offers flexible living space with rough-ins ready for a future wet bar, and the low-maintenance yard keeps weekends free for what matters. Just minutes from I-71, Tylersville Road, Deerfield Towne Center, and Mason's best dining and shopping. Move-in ready, upgraded top to bottom, and priced below what it would cost to build the same home today (Approx $150,000 less). This is smarter than new construction without compromising on a single upgrade.

Listing Courtesy of

CincyMLS / Listed By: Michelle de la Vega, Coldwell Banker Realty

$999,000 ^(USD)

Cincinnati Area Multi-Family Home

Active

3636 Besuden Court Cincinnati, OH 45208

Bed

0 Baths

0 sqft

MLS# 1871872

Rare opportunity to acquire two 4-unit buildings (8 total units) in the heart of Hyde Park. 3636 & 3640 Besuden Ct are being sold together, offering a turnkey investment with strong rental appeal. Each unit features 1 bedroom, 1 full bath, spacious living room, dining area, kitchen, private balcony, and access to lower-level storage and laundry. All utilities are separately metered, providing added convenience and expense control. Situated on a quiet no-outlet street, yet just minutes from Hyde Park Square, Rookwood Commons & Pavilion, popular restaurants, shopping, and entertainment. Excellent access to bus lines and major highways enhances tenant demand. Consistently high occupancy history makes this a solid addition to any investment portfolio. Ideal for investors seeking stable cash flow in one of Cincinnati's most desirable neighborhoods.

Listing Courtesy of

CincyMLS / Listed By: Laura Benson, Coldwell Banker Realty

$995,000 ^(USD)

Cincinnati Area Single Family Home

Active

336 Boal Street Cincinnati, OH 45202

3 Bed

3.1 Baths

2648 sqft

MLS# 1884542

Luxury, technology, and style fill this 4-story Prospect Hill home. The showpiece kitchen, renovated in 18, features elite Thermador Professional, Miele, and Liebherr appliances, a quiet, powerful external blower for the hood, quartz countertops, heated floors, and soft-close cabinetry/drawers. New hardwood floors throughout, smart home tech: Nest suite of doorbell, ext. camera, keyless entry, smoke/CO detectors, thermostats, and voice-com. Lutron lights in the kitchen and dining area. A custom temp-controlled wine cellar protects your collection. Offering 3 bdrms, 3 full bths, 1 half bth, and a 2-car tandem garage, this modern residence is meant for comfort and entertaining. Host guests in the backyard or take in the city views from the rooftop deck. Situated just outside downtown Cincinnati, this home is a rare home within a city. Enjoy shopping, eateries, coffee shops, and theaters, all within minutes of your doorstep. Major interstates are minutes away, making commuting a breeze.

Listing Courtesy of

CincyMLS / Listed By: Doug Spitz, Coldwell Banker Realty

$995,000 ^(USD)

Union Twp Area Single Family Home

Active

946 Lavender Way Union Twp, OH 45152

5 Bed

3.1 Baths

3466 sqft

MLS# 1878781

Experience sustainable luxury living in Ohio's first agri-community, Aberlin Springs, surrounded by preserved forests and scenic meadows. This stunning custom Pendragon home sits on a beautiful half-acre lot designed for exceptional indoor-outdoor living. Open-concept layout with soaring 10-foot ceilings and walls of windows fill the home with natural light. Gourmet kitchen features quartz countertops, double dishwashers, wine fridge, and oversized butler's pantry. Dramatic stone fireplace anchors the inviting living space. Spacious primary suite offers a soaking tub, glass-enclosed shower, dual vanities, and walk-in closet. Semi-finished lower level with bedroom, full bath, and egress creates ideal guest or flex space. Geothermal HVAC and water heater plus Sonos speakers throughout. Enjoy gardens, pool, trails, fishing, farm market & more!

Listing Courtesy of

CincyMLS / Listed By: Jason Curlee, Coldwell Banker Realty

$995,000 ^(USD)

Cincinnati Area Single Family Home

Pending

6322 Grand Vista Avenue Cincinnati, OH 45213

5 Bed

3.2 Baths

4983 sqft

MLS# 1889175

Grand Vista: One of Pleasant Ridge's most coveted streets where homes rarely hit market! This stately 111 year old gem offers nearly 5k finished sq.ft., timeless architecture & elevated modern luxury. Restored hardwood floors, new windows & preserved historic details create a refined backdrop. The updated kitchen has ample cabinetry & luxury appliances, while the large sunroom offers a cozy space with views of the back patio & gorgeous professional landscaping. The primary suite is a true sanctuary with 2 walk in closets, built-ins, double headed shower, soaking tub, double vanity & substantial quartz counters. The formal dining room centering the home is perfect for holiday dinners. Sunlight pours into the sunken family room & wet bar. Formal living room for entertaining. A remodeled 3rd floor bath compliments the flexible guest suite + 3rd floor office. Zoned HVAC, 1st floor laundry, basement w/ gym, 2nd family room, bonus laundry hook ups. Electric in detached garage. A must see!

Listing Courtesy of

CincyMLS / Listed By: Scott Oyler, Coldwell Banker Realty

$982,997 ^(USD)

Union Twp Area Single Family Home

Pending

3223 Garden View Circle Union Twp, OH 45152

4 Bed

4 Baths

3832 sqft

MLS# 1888655

Discover the ideal combination of contemporary style and eco-friendly living in this beautiful new Pendragon Homes build, nestled within a one-of-a-kind community-supported agriculture (CSA) neighborhood. Enjoy the everyday benefits of fresh, locally grown produce and a connected, welcoming community, all while relaxing in the comfort of a brand-new, low-maintenance home. Sold before sent.

Listing Courtesy of

CincyMLS / Listed By: Jason Curlee, Coldwell Banker Realty

$964,900 ^(USD)

Madeira Area Single Family Home

Active

8120 Maxfield Lane Madeira, OH 45243

5 Bed

4.1 Baths

0 sqft

MLS# 1835803

Welcome to The Logan by John Henry Homes, nestled on a peaceful street in Madeira. This new build offers approximately 3,670 finished square feet, featuring 5 bedrooms and 4.5 baths. The main level boasts elegant wainscoting in the foyer, a cozy fireplace in the great room, and a gourmet kitchen with quartz countertops, full-overlay Aristokraft cabinets with soft-close doors and drawers, stainless steel appliances, walk in pantry and hardwood flooring throughout. Upstairs, you'll find 4 spacious bedrooms, including a luxurious primary suite with a raised tray ceiling and a walk-in shower, 3 full baths and a convenient laundry room. The finished lower level offers 9-foot ceilings, a 5th bedroom, a 4th full bath, a versatile media/family room, and ample storage space.

Listing Courtesy of

CincyMLS / Listed By: Michael Hines, Coldwell Banker Realty

$950,000 ^(USD)

Terrace Park Area Single Family Home

Active

727 Miami Avenue Terrace Park, OH 45174

5 Bed

3.2 Baths

3740 sqft

MLS# 1877676

Perched on the Little Miami River with exceptional water views, this stunning Terrace Park home blends everyday comfort with unforgettable scenery. A dramatic 2-story great room is flooded with natural light and showcases the breathtaking backdrop, while hardwood floors add warmth throughout the main living areas. Spacious eat-in kitchen opens to comfortable gathering areas, ideal for daily living and entertaining. Desirable first-floor primary suite, plus 3 additional bedrooms for a total of 4 bedrooms, 3 full and 2 half baths, and a fantastic custom walk-in closet. Finished walkout lower level extends the living space and opens to a deck perfectly positioned to enjoy the views. Additional highlights include first-floor laundry, attached 2-car garage, fenced yard, and an exceptional village location close to all Terrace Park has to offer!

Listing Courtesy of

CincyMLS / Listed By: Amy Roe, Coldwell Banker Realty

$950,000 ^(USD)

Cincinnati Area Single Family Home

Active

5739 Sanctuary Place Cincinnati, OH 45230

3 Bed

2.1 Baths

3672 sqft

MLS# 1888982

Live as though you are floating above the river where serene water views become part of the design. A beautiful stone facade, stamped concrete drive & grand double-door entry set an elegant tone. Inside, wood floors, custom blinds & an elevator connect each thoughtfully designed level. The open 2nd floor kitchen & living area features a wall of windows + top floor deck, granite counters & a five-burner gas range. The spacious primary suite offers a tray ceiling, spa-like bath with tiled walk in shower, double vanity & generous walk-in closet. All 3 bedrooms offer great space with ample linen & storage space throughout. The expansive 1st floor office opens to the lower level Trex deck overlooking the river & could easily serve as a second family room. An oversized garage adds dedicated storage & workspace, completing this refined riverfront retreat. Why wake up to traffic when you can wake up to the river! Tax abated!

Listing Courtesy of

CincyMLS / Listed By: Scott Oyler, Coldwell Banker Realty

$935,000 ^(USD)

Madeira Area Single Family Home

Active

7834 Laurel Avenue Madeira, OH 45243

4 Bed

3.1 Baths

2800 sqft

MLS# 1867616

PRICE REDUCTION! 4.5% Interest rate available for qualified Buyers! Just Completed! Welcome to Laurel Crossing! This unique Legendary Homes development includes 5 new detached ranches and 5 new detached Townhomes all within short walking distance to downtown Madeira. The new Townhomes are approx 2900 sq/ft, include 3/4 bdrs, 3.5 baths, 2 car garage, custom finishes incl large kitchen island w/Thermador Appliances, fin LL & abundant landscaping, optional elevator. Madeira - always rated Top 3 Burbs in Cincy Magazine! See 7831 Euclid for Ranch plans & selections.

Listing Courtesy of

CincyMLS / Listed By: Comey & Shepherd

$924,900 ^(USD)

Blue Ash Area Single Family Home

Active

4722 Alpine Avenue Blue Ash, OH 45242

5 Bed

4.1 Baths

3519 sqft

MLS# 1872729

Don't miss the Logan by John Henry Homes, offering approximately 3,519 finished square feet with 5 bedrooms, 4.5 baths plus an 8 year tax abatement in Blue Ash. The main level features elegant wainscoting in the foyer, a cozy fireplace in the great room, and a gourmet kitchen with quartz countertops, Aristokraft soft-close cabinetry, stainless steel appliances, a walk-in pantry, and hardwood floors. Upstairs includes four spacious bedrooms, highlighted by a primary suite with a tray ceiling and walk-in shower, plus two other full baths and a convenient laundry room. The finished lower level offers 9-ft ceilings, a fifth bedroom, full bath, media/family room, and ample storage. Enjoy a covered patio off the dining area. Ideally located just minutes from the restaurants and shops of downtown Blue Ash, this home is only a block from the YMCA and offers quick, convenient access to Cross County Highway for an easy commute anywhere you need to go. Estimated completion early 2027.

Listing Courtesy of

CincyMLS / Listed By: Bob Hines, Coldwell Banker Realty

$900,000 ^(USD)

Blue Ash Area Single Family Home

Active

9491 Railroad Avenue Blue Ash, OH 45242

4 Bed

2.1 Baths

0 sqft

MLS# 1880325

This is your chance to own a brand new home in the heart of Blue Ash, located in the CRA Tax Abatement Zone and eligible for the 8-year tax abatement. The existing home on the property will be torn down, giving way to a beautiful 4-bedroom, 2.5-bath new build with a first-floor primary suite, soaring vaulted ceilings in the great room, and an open-concept kitchen complete with a breakfast nook. Need extra space? The bonus room above the 2-car garage is the perfect flex space whether you need a second primary suite, a playroom, or a private retreat. You'll also have the option to work with the builder on your finishes to add a personal touch.

Listing Courtesy of

CincyMLS / Listed By: Real Of Ohio

$898,900 ^(USD)

Madeira Area Single Family Home

Active

7327 Osceola Drive Madeira, OH 45243

5 Bed

4.1 Baths

2710 sqft

MLS# 1871930

Welcome to The Logan by John Henry Homes. This new home will be approximately 3,519 finished sf, featuring 5 bedrooms and 4.5 baths and sit on a quiet, residential street in Madeira. Elegant wainscoting in the foyer, a cozy fireplace in the great room, and a gourmet kitchen featuring quartz countertops, full overlay Aristokraft cabinets with soft-close doors/drawers, stainless steel appliances, a walk-in pantry, and hardwood flooring throughout. Upstairs, you'll find four spacious bedrooms, including a lovely primary suite with a tray ceiling and a walk in shower, along with three full baths and a conveniently located laundry room. The finished lower level offers 9ft ceilings, a fifth bedroom, a fourth full bath, a versatile media or family room, and plenty of storage space. Enjoy indoor/outdoor living on the covered patio accessed via the dining room. Estimated completion early 2027.

Listing Courtesy of

CincyMLS / Listed By: Bob Hines, Coldwell Banker Realty

$895,000 ^(USD)

Cincinnati Area Single Family Home

Active

77 Peete Street Cincinnati, OH 45202

4 Bed

4 Baths

0 sqft

MLS# 1888698

Build Your Dream Home with Breathtaking City Views! Rare opportunity to design a fully custom home on a premium lot with stunning city skyline views. This is your chance to create a residence tailored entirely to your lifestyle from floor plan and room count to finishes, fixtures, and architectural details. Envision floor-to-ceiling windows framing the city lights, a chef's kitchen built for entertaining, a private rooftop terrace, or a spa-inspired primary suite the choice is yours. Work hand-in-hand with an experienced design team and Christopher Michael Homes to bring your vision to life. Prime location offers convenient access to downtown, dining, and entertainment while providing a peaceful retreat above it all. Whether you dream of sleek modern minimalism or timeless elegant luxury, this blank-canvas opportunity lets you build not just a house, but a home that's uniquely yours. Don't just buy a home design the one you've always imagined.

Listing Courtesy of

CincyMLS / Listed By: Katherine "Katie" McCarty, Coldwell Banker Realty

$875,000 ^(USD)

Cincinnati Area Single Family Home

Pending

253 St Peters Street Cincinnati, OH 45226

3 Bed

2.1 Baths

2799 sqft

MLS# 1874074

Welcome to luxury Riverside living in this custom-built, LEED Gold tax abated home in Cincinnati's Historic East End with sweeping views of the Ohio River and eastern skyline. The open-concept main living area features rich hardwood flooring, abundant natural light, and warm architectural touches incl exposed brick. The gourmet kitchen is both functional and refined, showcasing quartz surfaces, a generous island with counter seating, SS appl, soft-close cabs, double pantry & grilling deck. Primary suite with adj spa bath & walk-in closet, all 3 beds feat blackout blinds. The top level includes flex rec space/office & an expansive rooftop deck with opening pergola, raised garden bed w/spigot and the views!! Addtl highlights: pre-built elevator shaft, 46' x 23' 4-car gar with Nitro Garage floor tile, and steps from Schmidt Recreation Complex, boat launch, Ohio to Erie trail, and the thriving East End Bus Dist with dining & entertainment. Superior energy effic & savings w/LEED Gold Cert!

Listing Courtesy of

CincyMLS / Listed By: Tim Hinde, Coldwell Banker Realty

$854,975 ^(USD)

Union Twp Area Single Family Home

Pending

3163 Rosemary Court Union Twp, OH 45152

3 Bed

2.2 Baths

0 sqft

MLS# 1874070

Discover the ideal combination of contemporary style and eco-friendly living in this beautiful new Pendragon Homes build, nestled within a one-of-a-kind community-supported agriculture (CSA) neighborhood. Enjoy the everyday benefits of fresh, locally grown produce and a connected, welcoming community, all while relaxing in the comfort of a brand-new, low-maintenance home. The York Plan showcases an airy open-concept design with vaulted ceilings, generous living spaces, and carefully considered details throughout. This home strikes the perfect balance of functionality, comfort, and efficiency. Thoughtful, eco-conscious upgrades include geothermal heating and cooling plus a whole-house water filtration system, delivering healthier air, cleaner water, and a more sustainable lifestyle. Need something a little different? Reach out to see how we can design a plan perfect for you.

Listing Courtesy of

CincyMLS / Listed By: Jason Curlee, Coldwell Banker Realty

$849,900 ^(USD)

Liberty Twp Area Single Family Home

Active

7025 Welney Run Liberty Twp, OH 45044

5 Bed

4 Baths

0 sqft

MLS# 1889245

Builder/Agent - Ready Now - The Aria by John Henry Homes at Caravel on gorgeous site! Incredible 2 story design with approximately 3750sf, 5 bedrooms, 4 full baths, 2 car side entry garage with 3rd carriage, 2nd floor bonus room, 11' beamed great room ceilings, gourmet kitchen, mudroom with cubbies, 9' lower level, raised tray in primary, spa like luxury shower in primary and covered patio. Decorator finishes are all high end an include tile baths, hardwood 1st floor, upgraded carpeting and pad, upgraded stair rail, full overlay Aristokraft cabinets, upgraded quartz countertops in kitchen, extended kitchen cabinets at island and breakfast, smooth ceilings, upgraded Moen faucets, custom Kichler lighting package.

Listing Courtesy of

CincyMLS / Listed By: Joshua "Josh" Blatt, Coldwell Banker Realty

$849,000 ^(USD)

Hamilton Twp Area Single Family Home

Active

0 Schlottman Road Hamilton Twp, OH 45039

3 Bed

2 Baths

2062 sqft

MLS# 1870424

Don't miss this ranch by Ashford Homes! Set on a rural lot, it offers the perfect blend of peaceful surroundings while still being a convenient distance to several city centers. The thoughtfully designed layout features 3 bedrooms, 2 full baths, and the opportunity to expand with an unfinished lower level. The private primary suite includes a spacious en-suite bath and walk-in closet. A welcoming entry opens to the great room with a fireplace, flowing seamlessly into the gourmet kitchen, dining area, and covered back porch. A dedicated study or home office adds flexibility for work or hobbies. Located less than 10 minutes from downtown Loveland's shops and restaurants, you'll enjoy quiet country living without sacrificing nearby amenities. The property is part of a larger parcel recently divided into three separate lots, giving you the opportunity to choose the perfect setting. Or work with the builder to design what works for you!

Listing Courtesy of

CincyMLS / Listed By: Laura Wogen, Coldwell Banker Realty

$849,000 ^(USD)

Columbia Twp Area Single Family Home

Active

5960 Woodland Lane Columbia Twp, OH 45227

3 Bed

3 Baths

0 sqft

MLS# 1843659

Introducing a brand-new, FINISHED luxury home by Ashford Homes in Woodland Vistas, just moments from Kenwood & Madeira & with a 10 YR tax abatement. Spanning 2,566 sqft, this residence is ideal for those seeking to right size. With 3 spacious bedrooms and 3 full baths, this home combines luxury & convenience. On the entry level, enjoy a private office, storage rooms, & a guest suite w/ a walk-in closet & ensuite bath. For added convenience, an optional elevator can be installed, enhancing the home's accessibility. The 2nd floor boasts a gourmet kitchen w/ quartz countertops, under-cabinet lighting, and a bright, open living space framed by a wall of windows, offering stunning vista views. Step onto the covered porch to enjoy year-round scenery. The primary suite features a large walk-in closet, double vanity with built-in storage, a soaking tub, & a separate shower. Experience the best of an easy living lifestyle. There are steps to Primary Level, but option for Elevator.

Listing Courtesy of

CincyMLS / Listed By: Michael Hines, Coldwell Banker Realty

$824,900 ^(USD)

Cincinnati Area Single Family Home

Pending

7020 Wallace Ave Cincinnati, OH 45243

4 Bed

3.1 Baths

2784 sqft

MLS# 1760157

March 2024 completion! See attached flyer for financing incentive. The Logan by John Henry Homes located in Madeira, seconds away from the shops and restaurants in downtown Madeira. Approx 2,784sf, 4br, 3 full baths, 9' unfinished lower level, 9' 1st, wainscoting in foyer, gourmet kitchen, quartz countertops, hardwood first floor, stainless steel appliances, luxurious walk-in shower & raised tray ceiling in owner's suite, tile baths and laundry, full overlay Aristokraft cabinets with quiet close doors and drawers.

Listing Courtesy of

CincyMLS / Listed By: Michael Hines, Coldwell Banker Realty

$824,500 ^(USD)

Thornwilde Area Single Family Home

Active

1880 Whetherstone Ridge Hebron, KY 41048

5 Bed

4 Baths

5178 sqft

MLS# 644930

Welcome to 1880 Whetherstone Ridge in the heart of Hebron! Nestled on a picturesque 1-acre lot in the highly desirable Thornwilde community, this custom-built 5-bedroom, 4-bathroom home offers the perfect blend of space, comfort, privacy, and exceptional neighborhood amenities.

Designed for both everyday living and effortless entertaining, the main level features a spacious family room, an inviting living room, and an open-concept kitchen that serves as the heart of the home.

The finished lower level is an entertainer's dream, featuring a private movie theater, a full bedroom and bathroom, full kitchen and expansive flex space ideal for hosting guests, creating a private in-law suite, or continuing the home's successful Airbnb setup, offering an excellent opportunity for supplemental rental income.

Step outside to your own private retreat, where a large deck overlooks the flat, serene backyard complete with a firepit and scenic walking trails--perfect for relaxing or gathering with family and friends.

Offering the peaceful feel of a private retreat while remaining just minutes from everyday conveniences, this exceptional home combines the best of tranquil living with the sought-after lifestyle and amenities of the Thornwilde community.

Listing Courtesy of NORTHERN KENTUCKY / Listed By: Traci Nestheide, Coldwell Banker Realty

$815,000 ^(USD)

Cincinnati Area Single Family Home

Active

3 Bed

4 Baths

3354 sqft

MLS# 643778

Fully renovated in 2023, this exceptional Newport home blends historic character with modern luxury on a rare double lot just minutes from downtown Cincinnati, offering over 3,300 square feet across three finished levels. Original double doors welcome you into a light-filled interior featuring 10+ foot ceilings, exposed brick, chevron hardwood floors, six decorative fireplaces, and a hard-to-find open floor plan. The chef's kitchen offers a 10-foot island, six-burner gas range, pot filler, wine refrigerator, and built-in bench seating. Upstairs, the primary suite features a walk-in closet and spa-like bath with dual vanities, soaking tub, and separate shower. The showstopper is the third floor, complete with a full bath, bar area, and direct access to a private rooftop deck with skyline views of downtown Cincinnati. Ample off-street parking, room for a future garage, and extensive updates throughout make this a rare opportunity!

Listing Courtesy of NORTHERN KENTUCKY / Listed By: Varun Varma, Coldwell Banker Realty

$699,900 ^(USD)

Cincinnati Area Single Family Home

Active

3023 Lavinia Avenue Cincinnati, OH 45208

3 Bed

3.1 Baths

2668 sqft

MLS# 1888696

Elevated finishes and distinctive details in this newer LEED Gold Certified home with 8 years left on the tax abatement (full year taxes only $1,213!). Filled with lots of sunlight and an ideal floor plan. The eat-in Kitchen with Quartz island and high end appliances flows beautifully into the Living Room with tray ceiling and new custom smart blinds. The generous Primary Suite offers a walk-in closet, double vanity and dual shower. The lower level features a Fitness Room, Full Bath, Family Room with wet bar (2 beverage refrigerators), and walkout to 6 person hot tub! Modern, custom, and move-in ready. All of this in a fantastic walkable location!

Listing Courtesy of

CincyMLS / Listed By: Rick Finn, Coldwell Banker Realty