25067 Castlebar Court, Columbia Station, OH 44028

$1,800,000
Active for Sale
4 Beds
5F 3H Baths
6309 SF
Built In 2005
 
Listing ID 11797201
Property Type Residential
County Lorain
Township Columbia Twp
Total Tax $28,312
Tax ID 12-00-044-000-072
FEMA Flood Map fema.gov/portal
Year Built 2005
Virtual Tour
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 with a waterslide cascading through natural stone, expansive patios, and lush landscaping, creating the ultimate private oasis. A heated four-car garage completes this remarkable estate!
Property Details
  • 4 Total Bedrooms
  • 5 Full Baths
  • 3 Half Baths
  • 6309 SF (AG)
  • 6309 SF (Total)
  • 2.70 Acres
  • Built in 2005
  • Colonial Style
  • Full Basement
  • Lower Level: Partly Finished, Walk Out
Interior Features
  • Oven/Range
  • Refrigerator
  • Dishwasher
  • Microwave
  • Washer
  • Dryer
  • Laundry
  • 4 Fireplaces
  • Forced Air
  • Gas Fuel
  • Central A/C
Exterior Features
  • Masonry - Brick Construction
  • Vinyl Siding
  • Asphalt Shingles Roof
  • Attached Garage
  • 4 Garage Spaces
  • Community Water
  • Private Septic
  • Pool: In Ground
  • Deck
  • Patio
  • Cul de Sac
  • Subdivision: Hughes Sub
  • Shed
Taxes and Fees
  • $28,312 Total Tax
  • Tax Year 2025
Listed By
Howard Hanna
Office: 216-831-9310
Request More Information
Request Showing
Role Agent Buyer
Your Preferred Date & Time
Showing Type:

Mortgage Calculator

Estimate your mortgage payment, including the principal and interest, taxes, insurance, HOA, and PMI.

The amount you plan to offer for a home.
Cash you can pay when you close.
Varies depending on lender and credit score.
Affects interest rates. 30- or 15-year loans are standard.
Amortization Schedule

Advanced Options

Percentage of home's value. Varies by area.
Based on average insurance costs nationally.
Required if down payment is less than 20%. Rate depends on lender and credit score.
Fees paid in some shared complexes for maintenance.
Listing data is deemed reliable but is NOT guaranteed accurate.
Contact Us
Who Would You Like to Contact Today?

I want to contact an agent about this property!

I wish to provide feedback about the website functionality

Contact Agent
Your Name:
Email:
Phone:
Message:
Security: What is 6 minus 4?