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.
Price cut: $250K (8/4)
$1,950,000
5624 Lightpost Dr, Columbia, MO 65201
6beds
6,061sqft
Single Family Residence
Built in 2023
0.84 Acres Lot
$1,847,300 Zestimate®
$322/sqft
$70/mo HOA
What's special
Resort-style pool and spaSpa-inspired amenitiesBreathtaking viewsOpen-concept designMirror-on-mirror bath finishesThoughtfully designed prep kitchenSeed glass cabinetry accents
- 209 days
- 524
- 20
Zillow last checked:
Listing updated:
Listed by:
Susan Horak 573-442-6121,
REMAX Boone Realty 573-442-6121,
Molly Horak 573-447-2146,
REMAX Boone Realty
Source: MMBOR,MLS#: 432161
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 6
- Full bathrooms: 6
Primary bedroom
- Level: Main
- Area: 240
- Dimensions: 15 x 16
Bedroom
- Description: Bedroom 6
- Level: Lower
- Area: 1103221
- Dimensions: 911 x 1211
Bedroom 2
- Level: Main
- Area: 154
- Dimensions: 14 x 11
Bedroom 3
- Level: Main
- Area: 156
- Dimensions: 12 x 13
Bedroom 4
- Level: Upper
- Area: 70048
- Dimensions: 176 x 398
Bedroom 5
- Level: Lower
- Area: 24915
- Dimensions: 165 x 151
Full bathroom
- Level: Main
Full bathroom
- Level: Main
Full bathroom
- Level: Main
Full bathroom
- Level: Upper
Full bathroom
- Level: Lower
Full bathroom
- Level: Lower
Other
- Level: Lower
- Area: 114660
- Dimensions: 126 x 910
Bonus room
- Level: Lower
- Area: 16188
- Dimensions: 114 x 142
Dining room
- Level: Main
- Area: 140
- Dimensions: 14 x 10
Foyer
- Level: Main
- Area: 88
- Dimensions: 8 x 11
Garage
- Level: Main
Kitchen
- Level: Main
- Area: 216
- Dimensions: 12 x 18
Living room
- Level: Main
- Area: 306
- Dimensions: 17 x 18
Office
- Level: Main
- Area: 117
- Dimensions: 13 x 9
Other
- Description: Scullery
- Level: Main
Other
- Description: Screened Porch
- Level: Main
Other
- Description: Rear Deck
- Level: Main
Other
- Description: Mudroom
- Level: Main
Other
- Description: Upper Unfinished Storage
- Level: Upper
Other
- Description: Bar
- Level: Lower
- Area: 108783
- Dimensions: 153 x 711
Other
- Description: Game Room
- Level: Lower
- Area: 31948
- Dimensions: 196 x 163
Other
- Description: Dining Area
- Level: Lower
- Area: 13420
- Dimensions: 110 x 122
Other
- Description: Pool Room
- Level: Lower
- Area: 126375
- Dimensions: 125 x 1011
Other
- Description: Mechanical Room
- Level: Lower
Other
- Description: Lower Unfinished Storage
- Level: Lower
Heating
- Mini-Split, High Efficiency Furnace, Forced Air, Natural Gas
Cooling
- Central Electric, Mini-Split
Appliances
- Included: Refrigerator, Microwave, Disposal, Dishwasher, Dryer, Humidifier
- Laundry: Washer/Dryer Hookup, Additional Laundry Hookup(s)
Features
- High Speed Internet, Stand AloneShwr/MBR, Split Bedroom Design, Soaking Tub, Walk-In Closet(s), Wet Bar, Elevator, Smart Thermostat, Eat-in Kitchen, Formal Dining, Cabinets-Custom Blt, Wood Cabinets, Kitchen Island, Quartz Counters
- Flooring: Wood, Carpet, Concrete, Tile
- Basement: Walk-Out Access
- Has fireplace: Yes
- Fireplace features: Master Bedroom, Living Room
Interior area
- Total structure area: 6,061
- Total interior livable area: 6,061 sqft
- Finished area below ground: 2,186
Video & virtual tour
Property
Parking
- Total spaces: 3
- Parking features: Attached, Paved
- Attached garage spaces: 3
Features
- Patio & porch: Covered, Screened, Back, Deck, Front Porch
- Exterior features: Exterior Audio Wiring
- Fencing: Back Yard,Full,Metal
Lot
- Size: 0.84 Acres
- Dimensions: 191.33 x 192.31
- Features: Cleared
Details
- Additional structures: None
- Parcel number: 1750200040250001
- Zoning description: R-S Single Family Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Single Family Residence
Materials
- Foundation: Concrete Perimeter
- Roof: Metal
Condition
- Year built: 2023
Details
- Builder name: Girard Homes
Utilities & green energy
- Utilities for property: Trash-City
Community & HOA
Community
- Subdivision: Gates At Old Hawthorne
HOA
- Has HOA: Yes
- HOA fee: $70 monthly
Location
- Region: Columbia
Financial & listing details
- Price per square foot: $322/sqft
- Tax assessed value: $892,300
- Annual tax amount: $11,101
- Date on market: 2/6/2026
- Road surface type: Paved
Estimated market value
$1,847,300
$1.75M - $1.94M
$7,178/mo
Price history
| Date | Event | Price |
|---|---|---|
| 8/4/2026 | Price change | $1,950,000-11.4%$322/sqft |
Source: | ||
| 2/6/2026 | Listed for sale | $2,200,000$363/sqft |
Source: | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $169,537 +14.5% |
| 2024 | $9,989 +2.6% | $148,063 +1.7% |
| 2023 | $9,737 +152.7% | $145,540 +152.4% |
| 2022 | $3,854 +404.9% | $57,665 +405.8% |
| 2021 | $763 -6% | $11,400 |
| 2020 | $812 0% | $11,400 |
| 2019 | $812 -0.7% | $11,400 |
| 2018 | $818 +1.2% | $11,400 |
| 2017 | $808 +0.2% | $11,400 |
| 2016 | $807 | $11,400 |
| 2015 | $807 +8.9% | $11,400 |
| 2014 | $741 | $11,400 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 65201
Nearby schools
Schools provided by the listing agent
- Elementary: Cedar Ridge
- Middle: Oakland
- High: Battle
Source: MMBOR. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.




