Skip main navigation
For sale
Price cut: $250K (8/4)
$1,950,000

5624 Lightpost Dr, Columbia, MO 65201

6beds
6,061sqft
: 
$12,251/mo
Get pre-qualified
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
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.
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#: 432161MLS Logo

    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

      DateEventPrice
      8/4/2026Price change$1,950,000-11.4%$322/sqft
      Source: MMBOR #432161 Report a problem
      2/6/2026Listed for sale$2,200,000$363/sqft
      Source: MMBOR #432161 Report a problem

      Public tax history

      YearProperty taxesTax 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.
      All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
      HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
      See how much you could borrow to make a competitive offer.

      Climate risks

      Neighborhood: 65201

      Getting around

      0 / 100
      Car-Dependent
      17 / 100
      Somewhat Bikeable

      Nearby schools

      GreatSchools rating
      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.

      A local agent can set up tours, give advice and negotiate with sellers.

      A local lender can help you make sure your offer is ready when you are.

      Browse local experts