Property Attributes
- MLS#5243646
- TypeSingle Family
- Listing Status Active
- CountyLake
- CityConcord Twp
- NeighborhoodAscot Farms Sub
- Zip44060
- Style
- Year Built2026
- Taxes$ 15549
- Price$ 924,900
- Bedrooms4
- Full Bathrooms3
- Half Bathrooms1
- Sqr Footage3000
- Lot Size0.62 Acres
Data Source:
MLSNow
Property Description
This stunning new home in the desirable Ascot Farms subdivision offers 3,000 SF of thoughtfully designed living space on an impressive 100' x 258' lot. With no HOA restrictions, this exceptional property combines luxury, functionality and modern style. A grand 2 story foyer welcomes guests with an elegant chandelier and opens to a spacious great room featuring a dramatic floor-to-ceiling fireplace, creating the perfect gathering space for family and friends. The gourmet eat-in kitchen is sure to impress with beautiful quartz countertops, a coordinating backsplash, appliances, a coffee bar, and a walk-in pantry featuring laminate shelving and a decorative glass-panel door. The adjoining breakfast area is highlighted by a chandelier and sliding glass doors that provide easy access to the deck, making indoor and outdoor entertaining effortless. Luxury vinyl plank flooring extends throughout the entire main level, adding both durability and style. The 1st floor primary suite serves as a private retreat, complete with a vaulted ceiling, a luxurious en-suite bath featuring a separate shower, and an oversized walk-in closet. Additional main-level features include a private office with a tray ceiling and crown molding, a convenient first-floor laundry room with folding counter and utility sink, and a practical mudroom outfitted with built-in cubbies and a built-in bench for everyday organization. Upstairs, you'll find 3 generously sized bedrooms along with a versatile bonus room that can serve as a playroom, media room, or additional living space. The home's exterior is equally impressive, offering both a deck overlooking the expansive backyard. Completing this exceptional property is a 3 car side-load garage that enhances curb appeal while providing ample storage and parking. This beautifully crafted new construction home delivers the perfect blend of luxury finishes, modern conveniences, and spacious living in one of the area's most sought-after communities.
| Price History | |
|---|---|
| 9/9/2026 | Listed $924,900 |
General Features
| Sewer | Public Sewer |
|---|---|
| Heating | Forced Air |
| Cooling | Central Air |
| Possession | Negotiable |
| Roof | Shingle |
| Appliances | Dishwasher,Disposal,Microwave,Range,Refrigerator |
| Garage Spaces | 3 |
| Patio/Porch Features | Deck,Porch |
| Architectural Style | Traditional |
| Security Features | Carbon Monoxide Detector(s),Smoke Detector(s) |
| Construction Materials | Board & Batten Siding,Stone Veneer,Vinyl Siding |
| Year Built | 2026 |
| View | Neighborhood |
| Stories Count | 2 |
| Township | Concord Twp |
| Levels | Two |
| Property Subtype | Single Family Residence |
| Tax Year | 2025 |
| Accessibility | Accessible Washer/Dryer,Accessible Bedroom,Accessible Kitchen,Accessible Central Living Area,Accessible Hallway(s) |
| County | Lake |
| New Construction | true |
| Property Type | Residential |
| HOA | false |
| Attached Garage | true |
| Energy Efficient | Appliances,Doors,HVAC,Insulation,Lighting,Water Heater |
| Subdivision Name | Ascot Farms Sub |
| Facing Direction | West |
| Garage Y/N | true |
| Green Indoor Air Quality | Ventilation |
| Full Baths | 3 |
| Status | Active |
| Directions | Off Hoose Rd |
| ModificationTimestamp | 2026-09-10T17:41:46.177-00:00 |
| City | Concord Twp |
| High School District | Riverside LSD Lake- 4306 |
| Lot Size Units | Acres |
| Carport Y/N | false |
| Land Lease Y/N | false |
| Tax Annual Amount | 15549 |
| Home Warranty Y/N | true |
| Property Condition | New Construction |
| Living Area Units | Square Feet |
| Builder Name | Jemm Construction |
| Standard Status | Active |
| Middle/Junior School District | Riverside LSD Lake- 4306 |
| Elementary School District | Riverside LSD Lake- 4306 |
| Year Built Source | Builder |
| Property Sub Type Additional | Single Family Residence |
| PostalCity | MENTOR ON THE LAKE |
| Legal Description | LOT 22 TRACT 4 |
Interior Features
| Interior Amenities | Beamed Ceilings,Tray Ceiling(s),Ceiling Fan(s),Chandelier,Coffered Ceiling(s),Double Vanity,Entrance Foyer,Eat-in Kitchen,High Ceilings,Kitchen Island,Primary Downstairs,Open Floorplan,Pantry,Stone Counters,Recessed Lighting,Storage,Soaking Tub,Walk-In Closet(s) |
|---|---|
| Basement | Daylight,Concrete,Bath/Stubbed,Unfinished,Sump Pump |
| Total Fireplaces | 1 |
| Fireplace Features | Insert,Gas,Gas Log,Great Room |
| Basement (Y/N) | true |
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Window Features | Double Pane Windows,Garden Window(s),Screens |
| Fireplace Y/N | true |
| Above Grade Finished Area | 3000 |
| Half Baths | 1 |
| Laundry Features | Washer Hookup,Electric Dryer Hookup,Gas Dryer Hookup,Main Level,Laundry Room |
| Total Bedrooms | 4 |
| Main Level Bedrooms | 1 |
| Main Level Bathrooms | 2 |
| Above Grade Finished Area Source | Builder |
| Total Baths | 4 |
Exterior Features
| Exterior Amenities | Sprinkler/Irrigation,Lighting |
|---|---|
| Fencing | None |
| Parking Features | Attached,Concrete,Garage,Garage Door Opener,Lighted |
| Lot Features | Back Yard,Cleared,Front Yard,Landscaped |
| Water Source | Public |
| Lot Size Area | 0.62 |
| Foundation Details | Slab |
| Lot Size Acres | 0.62 |
| Lot Size Source | Owner |
| Waterfront Y/N | false |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
The data relating to real estate for sale on this web site comes
in part from the Broker Reciprocity™ program of the Multiple
Listing Service of Greater Cincinnati. Real estate listings held by
brokerage firms other than The Holden Agency are marked with the MLS ™ logo
(the small logo to the left) and detailed information about them includes
the name of the listing brokers. The information herein is furnished by the property owner in good faith
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided 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 on this
NORIS | Toledo Regional Association of REALTORS® All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers
Information should be deemed reliable but not guaranteed, all representations are approximate, and individual verification is recommended. Copyright ©2017 All rights reserved.