Property Attributes
- MLS#5239588
- TypeSingle Family
- Listing Status Active
- CountyLorain
- CityColumbia Station
- NeighborhoodEmerald Woods
- Zip44028
- Style
- Year Built2025
- Price$ 606,090
- Bedrooms2
- Full Bathrooms2
- Half Bathrooms0
- Sqr Footage2363
- Lot Size0.16 Acres
Data Source:
MLSNow
Property Description
Experience luxury first-floor living at The Retreat at Emerald Woods by owning this model home! Conveniently located in Columbia Station, enjoy a peaceful and serene lifestyle with countless retail, dining, and recreational activities located within a close proximity. This new home construction community is one of the most sought-after neighborhoods in Lorain County. Our spacious Palmary model home floor plan at 23864 Heatherstone Trail offers the perfect blend of luxury and functionality. The open concept home features a large entertainer’s kitchen with built-in appliances and a walk-in pantry, a spacious gathering and café area, flex room, and a covered porch. With 2 bedrooms, 2 baths, and an attached two-car extended garage, the Palmary floor plan ensures you have the space you need to live your dreams.
| Price History | |
|---|---|
| 8/25/2026 | Listed $606,090 |
General Features
| Sewer | Public Sewer |
|---|---|
| Heating | Forced Air,Gas |
| Cooling | Central Air |
| Possession | Delivery Of Deed |
| Roof | Asphalt |
| Appliances | Built-In Oven,Cooktop,Dishwasher,Disposal,Microwave |
| HOA Fee | 400 |
| Garage Spaces | 2 |
| Association Fee Includes | Association Management,Common Area Maintenance,Insurance,Maintenance Grounds,Reserve Fund,Snow Removal |
| Patio/Porch Features | Covered,Patio |
| Architectural Style | Ranch |
| Security Features | Carbon Monoxide Detector(s),Smoke Detector(s) |
| Construction Materials | Batts Insulation,Blown-In Insulation,Frame,Stone Veneer,Vinyl Siding |
| Pets Allowed | Yes |
| Year Built | 2025 |
| Stories Count | 1 |
| Township | Columbia Twp |
| Levels | One and One Half,One |
| Property Subtype | Single Family Residence |
| Tax Year | 2025 |
| Community Features | Street Lights,Sidewalks |
| HOA Fee 2 | 135 |
| Assoc Fee Paid Per | Annually |
| County | Lorain |
| New Construction | true |
| Property Type | Residential |
| HOA | true |
| Attached Garage | true |
| Subdivision Name | Emerald Woods |
| Garage Y/N | true |
| Full Baths | 2 |
| Status | Active |
| Directions | From Downtown Cleveland Get on Interstate 90 West Take Interstate 71 South to US-42 S/Pearl Road. Take exit 234. |
| ModificationTimestamp | 2026-09-11T19:45:11.547-00:00 |
| City | Columbia Station |
| Association Name | Emerald Woods HOA |
| High School District | Columbia LSD - 4705 |
| Lot Size Units | Acres |
| Carport Y/N | false |
| HOA Fee 2 Frequency | Monthly |
| Land Lease Y/N | false |
| Home Warranty Y/N | true |
| Property Condition | New Construction |
| Living Area Units | Square Feet |
| Builder Name | Pulte Homes of Ohio, LLC |
| Standard Status | Active |
| Middle/Junior School District | Columbia LSD - 4705 |
| Elementary School District | Columbia LSD - 4705 |
| Year Built Source | Builder |
| Property Sub Type Additional | Single Family Residence |
| PostalCity | COLUMBIA STATION |
Interior Features
| Basement (Y/N) | false |
|---|---|
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Fireplace Y/N | false |
| Above Grade Finished Area | 2363 |
| Laundry Features | Washer Hookup,Electric Dryer Hookup,Main Level,Laundry Room,Laundry Tub,Sink |
| Total Bedrooms | 2 |
| Main Level Bedrooms | 2 |
| Main Level Bathrooms | 2 |
| Above Grade Finished Area Source | Builder |
| Total Baths | 2 |
Exterior Features
| Parking Features | Attached,Driveway,Garage Faces Front,Garage,Garage Door Opener |
|---|---|
| Water Source | Public |
| Lot Size Area | 0.16 |
| Foundation Details | Slab |
| Lot Size Acres | 0.16 |
| 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
© MLS Now, INC - Northern Ohio Regional Multiple Listing Service 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
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