The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Yes MLS. Real estate listings held by brokerage firms other than the owner of this site are marked with the Internet Data Exchange logo and detailed information about them includes the name of the listing broker(s). IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed. Copyright © 2025 Yes MLS. All rights reserved.
This content last refreshed on 12/14/2025 5:32 PM. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.
Information is deemed reliable but is not guaranteed.
Listing Courtesy of: realtoramandashafer@gmail.com, 330-324-7454 - Amanda Shafer - RE/MAX Trends Realty 234-251-0555
$1,975,000 affordable loan icon Calculate Payment

2200 W Comet Road New Franklin, OH 44216

Down payment assistance icon
Single Family Residence
6 Beds
6 Baths
6,159 Sq. Ft.
27.79 Acre Lot

Property Activity

Time on Site
days
Days on Market
Views
Saves
Last updated on 12/14/2025 5:32 PM
Welcome to this extraordinary equestrian dream home—a private luxury retreat offering over 6,000 sq ft of finished living space and the finest amenities for both people and horses. From the moment you arrive, you’ll sense the craftsmanship and thoughtful design that make this property one-of-a-kind.... The main level is anchored by multiple fireplaces creating warmth and ambiance throughout the open floor plan. The first-floor primary suite provides a serene escape with elegant finishes, while the culinary kitchen is every chef’s dream—featuring custom cabinetry, a butler’s pantry, and state-of-the-art appliances. A spacious first-floor laundry with built-in custom cabinetry and a charming Dutch door opens to the screened porch, perfect for morning coffee or evening sunsets. The finished walk-out lower level includes a private bedroom suite, ideal for guests or extended family, and offers access to the patios and covered porches that surround much of the home with each one capturing stunning views of the farm. Above the attached heated three-car garage, discover a large private apartment with its own covered deck overlooking the property, ideal for in-law suite, guest, or staff quarters. The attached garage also features a dog washing station, while the detached garage offers oversized doors for RVs or boats, plus a car lift, and fully finished heated man cave. Equestrians will fall in love with the well-appointed horse barn, complete with four stalls—each with air-mattress flooring and individual all-weather paddocks accessed through Dutch doors. The stables also include a heated tack room, feed room, utility area, wash rack, and hay storage. Over 3.5 acres of safely fenced pasture provide turnout space with water access to every field. This remarkable property blends luxury living and equestrian excellence in a truly breathtaking setting. Discover this truly stunning, private, well-loved, and perfectly maintained property before it's gone! Continue reading
MLS#
5175367
Property Type
Single Family
Bedrooms
6
Bathrooms
5 Full/1 Half
Year Built
2021
Square Feet
6,159 sq. ft
Lot Size
27.79

Receive an email as soon as the price changes

Receive an email

as soon as the price changes
Get Price Alerts
price alerts icon

Get Price Alerts

Don't miss your chance. Receive an email as soon as the price changes.

Notify Me

Get email alerts when
a home price changes

Sign up
view of kitchen

Walk Score measures the walkability of any address, Transit Score measures access to public transit on a scale of 1-100.

Source: Walk Score®

Unlock In-Depth Property Insights with the Xome® Home Report

Listing Courtesy of: realtoramandashafer@gmail.com, 330-324-7454 - Amanda Shafer - RE/MAX Trends Realty 234-251-0555
Andrea D. Conner, License BRKP.2017002935, Xome Inc., License REC.2015001703, [email protected], 844-400-XOME (9663), 2939 Vernon Place, Suite 300, Cincinnati, OH 45219