Skip to main content
Back to Search Results
|

2200 W Comet Road, New Franklin, OH 44216

Show All 50 Photos
For Sale

$1,975,000

6 beds • 5 baths • 1 half baths • 6,159 sqft

Estimated Payment

$      /mo. †

APR for 30 years

Change Loan Terms

  • Single Family Detached
    Property type

  • $320.67
    Price per square foot

  • 1-5 Years Old
    Age

  • Pool, Hot Tub Spa
    Amenities

Explore this Property

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 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!
MLS# 5163665

Courtesy Of RE/MAX Trends Realty

(234) 251-0555

Property Features

  • Age
    1-5 Years Old
  • Amenities
    Deck, Porch, Patio, Pool, Ceiling Fan, Hot Tub Spa, Security System, Security System, Garden
  • Appliances
    Dryer, Dishwasher, Freezer, Microwave, Range, Refrigerator, Washer
  • Cooling System
    Ceiling Fan(s)
  • Fireplace
    Fireplace
  • Heating System
    Forced Air
  • Lot Size
    27.79 Acres
  • Roof Type
    Metal, Asphalt
  • Rooms
    Living Room, Laundry Room, Dining Room, Bonus Room

Map and Directions

Directions to 2200 W Comet Road, New Franklin, OH 44216

Home seller CENTURY 21 HomeStar

Get to know the neighborhood. A local affiliated CENTURY 21 office will help you set up tours, give advice, and negotiate with sellers.

CENTURY 21 HomeStar

(440) 449-9100
Learn More About Us

Mortgage Calculator

$
$ %
Loan Term
%
Invalid number

$ /year
$ /year
$ /month

Monthly Payment Breakdown

  • Principle and Interest
    $0
  • Property Taxes
    $0
  • Hazard Insurance
    $0
  • Private Mortgage Insurance
    $0
  • HOA Dues
    $0
  • Total Monthly Payment:
    $0

Calculators provided for estimating purposes only. Consult with your lender to determine precise payment requirements.

An Equal Opportunity Company

Copyright © 2025 MLS Now. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified. Information being provided is 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 being provided is 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.

Data powered by Attom Data Solutions. Copyright© 2025. Information deemed reliable but not guaranteed.

This information is provided for general informational purposes only and should not be relied on in making any home-buying decisions. School information does not guarantee enrollment. Contact a local real estate professional or the school district(s) for current information on schools. This information is not intended for use in determining a person's eligibility to attend a school or to use or benefit from other city, town or local services.

† Based on a 30-year fixed rate of 3.38% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Interest rates are also subject to credit and property approval based on secondary market guidelines. The rates shown are based on average rates for our best qualified customers. Your individual rate may vary. Rates may differ for FHA, VA or jumbo loans.