Address
25067 Castlebar Court, Columbia Station, OH
Price
$ 1,650,000
Property Attributes
- MLS#5211902
- TypeSingle Family
- Listing Status Active
- CountyLORAIN
- CityColumbia Station
- NeighborhoodHughes Sub
- Zip44028
- StyleColonial
- Year Built2005
- Taxes$ 28312
- Price$ 1,650,000
- Bedrooms4
- Full Bathrooms5
- Half Bathrooms3
- Sqr Footage6309
- Lot Size2.7 Acres
Data Source:
MLSNow
Property Description
Set on 3 lush acres at the end of a prestigious cul-de-sac, this extraordinary custom estate defines luxury living. Showcasing impeccable craftsmanship and magnificent finishes throughout, the residence offers an open, light-filled floor plan with soaring 10-foot ceilings, 8-foot doors, rich hardwood floors, and dramatic architectural detail at every turn. A grand two-story foyer with a sweeping staircase introduces the stunning interiors, flowing seamlessly into the elegant dining room, sophisticated library, and breathtaking great room anchored by a striking stone fireplace and custom built-ins. The superb gourmet kitchen is designed for both everyday living and entertaining, featuring custom cabinetry, granite countertops, a spacious center island, and professional-grade appliances. The lavish first-floor owner’s suite is a private retreat complete with a fireplace, dual walk-in closets, and a spa-inspired glamour bath. Upstairs, three oversized ensuite bedrooms and an expansive loft provide exceptional comfort and versatility. The spectacular walk-out lower level is truly unparalleled, offering a full kitchen, state-of-the-art theater room, billiards and gaming areas, fitness studio, steam shower, full bath, and an impressive stone fireplace. Designed for resort-style living, the serene backyard overlooks a magnificent in-ground pool, expansive patios, and lush landscaping, creating the ultimate private oasis. A heated four-car garage completes this remarkable estate!
| Price History | |
|---|---|
| 5/28/2026 | Listed $1,800,000 |
| 7/17/2026 | 9$1,650,000 |
General Features
| Sewer | SepticTank |
|---|---|
| Heating | ForcedAir,Gas |
| Cooling | CentralAir |
| Possession | DeliveryOfDeed |
| Roof | Asphalt,Fiberglass |
| Appliances | BuiltInOven,Cooktop,Dryer,Dishwasher,Microwave,Refrigerator,Washer |
| Garage Spaces | 4.0 |
| Patio/Porch Features | Deck,Patio |
| Architectural Style | Colonial |
| Pool Features | InGround,Waterfall |
| Construction Materials | Brick,VinylSiding |
| Year Built | 2005 |
| Township | Columbia Twp |
| Levels | ThreeOrMore |
| Property Subtype | SingleFamilyResidence |
| Tax Year | 2025 |
| County | Lorain |
| New Construction | No |
| Property Type | Residential |
| HOA | No |
| Attached Garage | Yes |
| Subdivision Name | Hughes Sub |
| Garage Y/N | Yes |
| Other Structures | Sheds |
| Full Baths | 5 |
| Status | Active |
| Directions | 82 to West River Road to Castlebar |
| City | Columbia Station |
| Senior Community Y/N | No |
| High School District | Columbia LSD - 4705 |
| Lot Size Units | Acres |
| Carport Y/N | No |
| Property Attached Y/N | No |
| Land Lease Y/N | No |
| Tax Annual Amount | 28312.0 |
| Home Warranty Y/N | Yes |
| Lease Renewal Y/N | No |
| Additional Parcels Y/N | No |
| Lease Considered Y/N | No |
| Rent Control Y/N | No |
| Virtual Tour | https://https//www.zillow.com/view-imx/01e8847a-d634-4d4c-a9ec-3c2335f7ca05?wl=true&setAttribution=mls&initialViewType=pano |
| Living Area Units | SquareFeet |
| Standard Status | Active |
| Middle/Junior School District | Columbia LSD - 4705 |
| Elementary School District | Columbia LSD - 4705 |
| Year Built Source | PublicRecords |
| Property Sub Type Additional | SingleFamilyResidence |
| MobileHomeRemainsYN | No |
| PostalCity | COLUMBIA STATION |
Interior Features
| Interior Amenities | JettedTub |
|---|---|
| Basement | Full,PartiallyFinished,WalkOutAccess |
| Total Fireplaces | 4 |
| Basement (Y/N) | Yes |
| Air Conditioning Y/N | Yes |
| Heating Y/N | Yes |
| Fireplace Y/N | Yes |
| Above Grade Finished Area | 6309.0 |
| Half Baths | 3 |
| Laundry Features | MainLevel,LaundryRoom |
| Total Bedrooms | 4 |
| Below Grade Finished Area | 4051.0 |
| Main Level Bedrooms | 1 |
| Main Level Bathrooms | 3 |
| Below Grade Finished Area Source | Realist |
| Above Grade Finished Area Source | Realist |
| Total Baths | 8 |
Exterior Features
| Parking Features | Attached,Garage |
|---|---|
| Lot Features | CulDeSac |
| Water Source | Public |
| Lot Size Area | 2.7 |
| Spa | No |
| Lot Size Acres | 2.7 |
| Lot Size Source | PublicRecords |
| Waterfront Y/N | No |
| Crops Included Y/N | No |
| Horse Y/N | No |
| Irrigation Water Rights Y/N | No |
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
Property vs Single Family Average in 44028
Price
Taxes
Year Built
Visits
© 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
