Skip main navigation
For sale
    • $2,200,000

    5624 Lightpost Dr, Columbia, MO 65201

    6beds
    6,061sqft
    : 
    Loading
    Get pre-qualified
    Single Family Residence
    Built in 2023
    0.84 Acres Lot
    $2,086,100 Zestimate®
    $363/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.
    164 days
    |
    471
    |
    12
    |

    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: CBORMLS,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, Wired for Data, Elevator, Smart Thermostat, Eat-in Kitchen, Formal Dining, Cabinets-Custom Blt, Wood Cabinets, Kitchen Island, Quartz Counters
      • Flooring: Wood, Carpet, Concrete, Tile
      • Windows: Some Window Treatments
      • Has basement: Yes
      • 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: ArchitecturalShingle,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: $363/sqft
      • Tax assessed value: $892,300
      • Annual tax amount: $11,101
      • Date on market: 2/6/2026
      • Road surface type: Paved

        Estimated market value

        $2,086,100

        $1.98M - $2.19M

        $6,987/mo

        Price history

        DateEventPrice
        2/6/2026Listed for sale$2,200,000$363/sqft
        Source: CBORMLS #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.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        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: CBORMLS. 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

        Similar homes

              Nearby cities

              Nearby neighborhoods

              Nearby zip codes

              Other Columbia Topics

                Search
                Updates
                Favorites
                Plan
                Inbox