5624 Lightpost Dr, Columbia, MO, 65201
About This Home
Welcome to 5624 Lightpost Drive, a 2023 custom-designed masterpiece in the prestigious The Club at Old Hawthorne Golf Course community, perfectly positioned on the lake at the fifth hole. This stunning estate seamlessly blends timeless sophistication with modern innovation, offering breathtaking views and an unparalleled living experience. The main level welcomes you with an open-concept design that flows effortlessly through the living, dining, and gourmet kitchen spaces. High ceilings and expansive windows flood the home with natural light while showcasing panoramic golf course and lake views. The chef's kitchen features GE Café appliances, a Smeg built-in coffee maker, seed glass cabinetry accents, and a thoughtfully designed prep kitchen for seamless entertaining. Step outside to discover the crown jewel: a resort-style pool and spa with mesmerizing fire and water features, surrounded by a marble stone deck engineered to stay cool underfoot. The screened porch with retractable TV and outdoor kitchen beneath an electrical gazebo creates the perfect setting for year-round outdoor living. Two master suites provide luxurious retreats, featuring mirror-on-mirror bath finishes and spa-inspired amenities. A three-level elevator ensures effortless access throughout the home, while dual laundry rooms add practical luxury. The lower level transforms into an entertainer's paradise with a bar featuring an ice maker, beverage fridge, and drawer microwave. Golf simulator-ready storage rooms with tall ceilings await your finishing touches. The epoxy black garage floors and whisper-quiet openers complete the attention to detail found throughout. 5624 Lightpost Drive is more than a home, it is a one-of-a-kind statement of elegance and luxury in the heart of Old Hawthorne.
Getting Around
Car-Dependent
Very Limited Transit
Somewhat BikeableSchools
Construction
Condition
- Year built: 2023
Materials
- Foundation: Concrete Perimeter
- Roof: ArchitecturalShingle,Metal
Other
- Builder name: Girard Homes
Type & Style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subType: Single Family Residence
Interior
Appliances
- Appliances included: Dryer,Humidifier
- Laundry features: Washer/Dryer Hookup,Additional Laundry Hookup(s)
Basement
- Has basement: Yes
Bedroom
- Level: Lower
- Area: 1103221
- Dimensions: 911 x 1211
Bedroom2
- Level: Main
- Area: 154
- Dimensions: 14 x 11
Bedroom3
- Level: Main
- Area: 156
- Dimensions: 12 x 13
Bedroom4
- Level: Upper
- Area: 70048
- Dimensions: 176 x 398
Bedroom5
- Level: Lower
- Area: 24915
- Dimensions: 165 x 151
Bedrooms & Bathrooms
- Bedrooms: 6
- Bathrooms: 6
- Full bathrooms: 6
Bonus Room
- Level: Lower
- Area: 16188
- Dimensions: 114 x 142
Dining Room
- Level: Main
- Area: 140
- Dimensions: 14 x 10
Features
- High Speed Internet,Stand AloneShwr/MBR,Split Bedroom Design,Soaking Tub,Walk-In Closet(s),Wet Bar,Wired for Data,Elevator,Smart Thermostat,Eat-in Kitchen,Formal Dining,Cabinets-Custom Blt,Wood Cabinets,Kitchen Island,Quartz Counters
- Window features: Some Window Treatments
- Flooring: Wood,Carpet,Concrete,Tile
- Fireplace features: Master Bedroom,Living Room
- Fireplace: Yes
- Finished area below ground: 2,186
Foyer
- Level: Main
- Area: 88
- Dimensions: 8 x 11
Full Bathroom
- Level: Main
Full Bathroom
- Level: Main
Full Bathroom
- Level: Main
Full Bathroom
- Level: Upper
Full Bathroom
- Level: Lower
Full Bathroom
- Level: Lower
Garage
- Level: Main
Heating & Cooling
- Heating features: Mini-Split,High Efficiency Furnace,Forced Air,Natural Gas
- Cooling features: Central Electric,Mini-Split
Interior Area
- Total structure area: 6,061
- Total interior livable area: 6,061 sqft
Kitchen
- Level: Main
- Area: 216
- Dimensions: 12 x 18
Living Room
- Level: Main
- Area: 306
- Dimensions: 17 x 18
Master Bedroom
- Level: Main
- Area: 240
- Dimensions: 15 x 16
Office
- Level: Main
- Area: 117
- Dimensions: 13 x 9
Other
- Level: Lower
- Area: 114660
- Dimensions: 126 x 910
Other
- Level: Main
Other
- Level: Main
Other
- Level: Main
Other
- Level: Main
Other
- Level: Upper
Other
- Level: Lower
- Area: 108783
- Dimensions: 153 x 711
Other
- Level: Lower
- Area: 31948
- Dimensions: 196 x 163
Other
- Level: Lower
- Area: 13420
- Dimensions: 110 x 122
Other
- Level: Lower
- Area: 126375
- Dimensions: 125 x 1011
Other
- Level: Lower
Other
- Level: Lower
Property
Details
- Parcel number: 1750200040250001
- Zoning description: R-S Single Family Residential
Features
- Patio & porch: Covered,Screened,Back,Deck,Front Porch
- Exterior features: Exterior Audio Wiring
- Fencing: Back Yard,Full,Metal
Lot
- Lot size: 0.84 Acres
- Features: Cleared
- Lot size dimensions: 191.33 x 192.31
Parking
- Total spaces: 3
- Parking features: Attached,Paved
- Has garage: Yes
- Attached garage spaces: 3
- Covered spaces: 3
Climate Risk is Financial Risk
Every home has a financial story beyond the listing price. Below, you’ll see the climate risks that could affect this property — and in Bills & Affordability, how those risks may influence repairs, insurance, utilities, and long-term value.
Biggest Threats for This Home
- Heat Wave
- Inland Flooding
- Lightning
- Strong Wind
- Tornado
- Winter Weather
- Cold Wave
- Hail
- Ice Storm
How This Home’s Risks Compare
FEMA Declared Disasters Across Missouri Counties
Understanding the Costs
Financial advisors generally recommend spending no more than 30% of your gross household income on housing costs. In practice, many households stretch to 35% or beyond — especially in high-cost markets.
Estimated Costs Today
| Monthly | Annual | |
|---|---|---|
| Mortgage | $11,124 | $133,488 |
| Home Insurance * | $1,224 | $14,688 |
| Property Taxes | $1,503 | $18,036 |
| Electricity | $462 | $5,554 |
| Total | $14,313 | $171,756 |
Income You'd Need if You Spent...
Missouri FAIR Plan Programs
How Costs Could Change Over Time
Climate risk is quickly impacting all of the major home ownership costs. Adjust the growth rates and percentage of income spent on housing below to see how your housing costs could change over the next 10 years — and what income you'd need to keep up.
Comparing Against the Market
Price Per Sq Ft
vs Other Active Listings
Avg $/sqft
vs Homes Sold Last Month
Median $/sqft
Current Market Trends
Median Price Per Square Foot
The median price per square foot of homes sold in this area each month. Compare this to this listing's price per square foot to gauge whether the home is priced in line with recent sales.
Historicals for This Listing
Zestimate History ($/sqft)
Price History
| Date | Event | Price |
|---|---|---|
| 2026-02-06 | Listed for sale | $2,200,000 |
View on Zillow