Skip main navigation
Coming soon
  • $625,000

    2404 Limerick Ln, Columbia, MO 65203

    5beds
    4,532sqft
    : 
    Single Family Residence
    Built in 1987
    0.9 Acres Lot
    $712,500 Zestimate®
    $138/sqft
    $-- HOA

    What's special

    Nestled in a premier, convenient southwest neighborhood, this custom-built home by Harold Smith and designed by Gordon Thompson offers a rare blend of space, character, and privacy. Constructed with brick on all sides, this 4,500+ sq. ft. home sits on a beautifully wooded and level .9-acre lot. Its open, unique floor plan features expansive entertaining areas, two fireplaces, and four main-level bedrooms. Extra-large windows and a stunning solarium flood the home with natural light—perfect for plant lovers. A private office and dedicated craft room provide space for work and creativity, while the two-level deck offers a peaceful retreat. Additional highlights include a three-car garage, two kitchens, a main-level laundry room, and many major updates already completed. A truly special home designed for comfort, style, effortless entertaining, and an appreciation for nature
    7 days
    on Zillow
    |
    1,166
    |
    41
    |

    Zillow last checked: 7 hours ago

    Listing updated: April 25, 2025 at 01:54pm

    Listed by:

    Donna Hepburn 573-268-8569,

    RE/MAX Boone Realty 573-442-6121,

    Donna Neil 573-876-2806,

    RE/MAX Boone Realty

    Source: CBORMLS,MLS#: 426513MLS Logo
    Travel times

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 4
    • Full bathrooms: 3
    • 1/2 bathrooms: 1
    Full bathroom
    • Level: Main
    Full bathroom
    • Level: Main
    Full bathroom
    • Level: Lower
    Half bathroom
    • Level: Main
    Heating
    • Heat Pump, Forced Air, Electric, Natural Gas
    Cooling
    • Heat Pump, Central Electric
    Appliances
    • Included: Water Softener Owned, Humidifier
    • Laundry: Sink, Main Level, Washer/Dryer Hookup
    Features
    • High Speed Internet, Tub/Shower, Stand AloneShwr/MBR, Walk-In Closet(s), Ceiling/PaddleFan(s), Central Vacuum, Smart Thermostat, Eat-in Kitchen, Formal Dining, Cabinets-Custom Blt, Wood Cabinets, Kitchen Island, Pantry, Quartz Counters
    • Flooring: Wood, Carpet, Tile, Vinyl
    • Windows: Window Treatments, Wood Frames, Vinyl Frames
    • Has fireplace: Yes
    • Fireplace features: Air Circulating, Basement, Family Room, Wood Burning, Screen
    Interior area
    • Total structure area: 4,532
    • Total interior livable area: 4,532 sqft
    • Finished area below ground: 1,900

    Property

    Parking
    • Total spaces: 3
    • Parking features: Attached, Garage Faces Side, Paved, Garage Door Opener
    • Attached garage spaces: 3
    Features
    • Patio & porch: Deck, Front Porch
    • Fencing: None
    Lot
    • Size: 0.9 Acres
    • Dimensions: 189.41 × 208.67
    • Features: Rolling Slope, Sprinkler-In Ground, Curbs and Gutters, Cul-De-Sac
    • Residential vegetation: Partially Wooded
    Details
    • Parcel number: 165040004025.00 01
    • Lease amount: $0
    • Zoning description: R-1 One- Family Dwelling*

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Ranch
    • Property subtype: Single Family Residence
    Materials
    • Foundation: Concrete Perimeter
    • Roof: ArchitecturalShingle
    Condition
    • Year built: 1987
    Details
    • Builder name: Harold Smith (Smitty

    Utilities & green energy

    • Electric: City
    • Gas: Gas-Natural
    • Sewer: City
    • Utilities for property: Natural Gas Connected, Trash-City, Cable Available, Cable Connected

    Community & HOA

    Community
    • Features: Lake
    • Security: Prewired, Security System, Smoke Detector(s)
    • Subdivision: Stoneybrook Sub
    HOA
    • Has HOA: No
    Location
    • Region: Columbia

    Financial & listing details

    • Price per square foot: $138/sqft
    • Tax assessed value: $474,800
    • Annual tax amount: $6,085
    • Date on market: 4/18/2025
    • Loading