NOT LISTED FOR SALE

2404 Limerick Ln Columbia, MO 65203

Columbia Area

Estimated Value: $547,000 - $687,144

5 Beds
3.5 Baths
4,532 Sq Ft
$139/Sq Ft Est. Value

Sale Details

Date Sold: May 22, 2025

Current estimated payment $3,980 / mo

2 Days on Market

Highlights

  • Community Lake
  • Deck
  • Partially Wooded Lot
  • Russell Boulevard Elementary School Rated 10
  • Ranch Style House
  • Wood Flooring

About This Home

As of May 2025

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

Last Agent to Sell the Property

Donna Hepburn

REMAX Boone Realty License #1999111783 Listed on: 05/02/2025

REMAX Boone Realty

Co-Listed By

Donna Neil

REMAX Boone Realty License #1999128608

Last Buyer's Agent

DENISE PAYNE

Iron Gate Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,086

Year Built

  • Built in 1987

Lot Details

  • 39,204 Sq Ft Lot
  • Cul-De-Sac
  • West Facing Home
  • Lot Has A Rolling Slope
  • Sprinkler System
  • Partially Wooded Lot

Parking

  • 3 Car Attached Garage
  • Side Facing Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Ranch Style House
  • Traditional Architecture
  • Brick Veneer
  • Concrete Foundation
  • Poured Concrete
  • Architectural Shingle Roof

Interior Spaces

  • Central Vacuum
  • Paddle Fans
  • Wood Burning Fireplace
  • Circulating Fireplace
  • Screen For Fireplace
  • Vinyl Clad Windows
  • Window Treatments
  • Wood Frame Window
  • Family Room with Fireplace
  • Formal Dining Room

Kitchen

  • Eat-In Kitchen
  • Convection Oven
  • Electric Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Quartz Countertops
  • Built-In or Custom Kitchen Cabinets
  • Utility Sink
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet
  • Bathroom on Main Level
  • Bathtub with Shower
  • Shower

Laundry

  • Laundry on main level
  • Washer and Dryer Hookup

Partially Finished Basement

  • Interior Basement Entry
  • Fireplace in Basement

Home Security

  • Home Security System
  • Smart Thermostat
  • Fire and Smoke Detector

Outdoor Features

  • Deck
  • Front Porch

Schools

  • Russell Boulevard Elementary School
  • Gentry Middle School
  • Rock Bridge High School

Utilities

  • Humidifier
  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Heat Pump System
  • Programmable Thermostat
  • Water Softener is Owned
  • High Speed Internet
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Built by Harold Smith (Smitty
  • Stoneybrook Sub Subdivision
  • Community Lake

Listing and Financial Details

  • Assessor Parcel Number 16-504-00-04-025.00 01

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,086

Year Built

Built in 1987

Lot Details

0.9 Acres

Parking

3

Listing Details

  • Directions: South on Forum, right on Chapel Hill, left on Limerick Lane
  • Lot Size: 189.41 × 208.67
  • Prop. Type: Residential
  • Full Bathroom Level: Main
  • Half Bathroom Level: Main
  • Year Built: 1987
  • BathsFull34LowerLevel: 1
  • BathsFull34MainLevel: 2
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.9
  • Road Surface Type: Public Maintained, Curbs and Gutters, Cul-de-sac
  • Subdivision Name: STONEYBROOK SUB
  • Above Grade Finished Sq Ft: 2632.0
  • Architectural Style: Ranch
  • Garage Type Attached: Yes
  • Cooling:Central Electric: Yes
  • Foundation Material:Poured Concrete: Yes
  • ArchStyle:Traditional: Yes
  • Deck:Back: Yes
  • TopoLot Description:Partially Wooded: Yes
  • Roof:ArchitecturalShingle: Yes
  • Utilities:Gas-Natural: Yes
  • Flooring:Carpet: Yes
  • Flooring:Tile: Yes
  • Heat Fuel:Natural Gas: Yes
  • Heat Type:Forced Air: Yes
  • Baths-Half:Main Level2: 1
  • Foundation Type:Full Bsmt Part Fin: Yes
  • Cooling:Heat Pump(s): Yes
  • Foundation Access:Inside Entrance: Yes
  • Dining:Eat-In Kitchen: Yes
  • Dining:Formal Dining: Yes
  • Utilities:Electric-City: Yes
  • Utilities:Sewage-City: Yes
  • Flooring:Vinyl3: Yes
  • Flooring:Wood2: Yes
  • Heat Fuel:Electricity: Yes
  • Heat Type:Heat Pump(s)2: Yes
  • StreetRoads:Cul-de-sac: Yes
  • Porch:Front2: Yes
  • Exterior Finish:Brick Veneer: Yes
  • Special Features: None

Interior Features

  • Flooring: Wood, Carpet, Tile, Vinyl
  • Interior Amenities: High Spd Int Access, Tub/Shower, Stand AloneShwr/MBR, Window Treatmnts All, Walk in Closet(s), Washer/DryerConnectn, Main Lvl Master Bdrm, Central Vacuum, FireplaceScreenDr(s), Smart Thermostat, Eat-in Kitchen, Formal Dining, Cabinets-Custom Blt, Cabinets-Wood, Kitchen Island, Pantry, Counter-Quartz
  • Appliances: Water Softener Owned, Humidifier
  • Basement YN: Yes
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 1900.0
  • Fireplace Features: Air Circulating, In Basement, In Family Room, Wood Burning
  • Fireplace: Yes
  • Living Area: 4532.0
  • Window Features: Windows-Wood, Windows-Vinyl
  • Fireplace:In Family Room: Yes
  • InteriorFeatures:Cable Ready: Yes
  • InteriorFeatures:CeilingPaddleFan(s): Yes
  • InteriorFeatures:High Spd Int Access: Yes
  • InteriorFeatures:Laundry-Main Floor: Yes
  • InteriorFeatures:Main Lvl Master Bdrm: Yes
  • InteriorFeatures:Smoke Detector(s): Yes
  • InteriorFeatures:TubShower: Yes
  • InteriorFeatures:Walk in Closet(s): Yes
  • InteriorFeatures:WasherDryerConnectn: Yes
  • KitchenFeatures:Cabinets-Custom Blt: Yes
  • KitchenFeatures:Cabinets-Wood: Yes
  • KitchenFeatures:Dishwasher-Built In: Yes
  • KitchenFeatures:Garbage Disposal: Yes
  • KitchenFeatures:Island: Yes
  • KitchenFeatures:Microwave Oven: Yes
  • Kitchen Features Pantry: Yes
  • Fireplace:Air Circulating: Yes
  • InteriorFeatures:Cable Available: Yes
  • InteriorFeatures:Central Vacuum: Yes
  • InteriorFeatures:Humidifier: Yes
  • InteriorFeatures:Programmable Thermostat(s): Yes
  • InteriorFeatures:Security System: Yes
  • InteriorFeatures:Stand AloneShwrMBR: Yes
  • InteriorFeatures:Utility Sink: Yes
  • InteriorFeatures:Window Treatmnts All: Yes
  • KitchenFeatures:Refrigerator: Yes
  • Fireplace:Wood Burning: Yes
  • InteriorFeatures:Water Softener Owned: Yes
  • KitchenFeatures:Range-Electric: Yes
  • InteriorFeatures:FireplaceScreenDr(s): Yes
  • KitchenFeatures:Convection Oven: Yes
  • KitchenFeatures:Counter-Quartz: Yes
  • KitchenFeatures:Vent Fan: Yes
  • InteriorFeatures:Wired for Sec Sys: Yes
  • Fireplace:In Basement: Yes

Exterior Features

  • Builder Name: Harold Smith (Smitty
  • Exterior Features: Driveway-Paved
  • Roof: ArchitecturalShingle
  • Fencing: None
  • Lot Features: Sprinkler-In Ground, Rolling Slope
  • Direction Faces: West
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Deck, Front Porch
  • Exterior Features:Driveway-Paved: Yes
  • Exterior Features:Sprinkler-In Ground: Yes
  • Exterior Features:Windows-Vinyl: Yes
  • Exterior Features:Community Lake: Yes
  • Exterior Features:Windows-Wood: Yes

Garage/Parking

  • Garage Spaces: 3.0
  • Parking Features: Garage Dr Opener(s), Attached
  • General Property Description:Garage Capacity: 3
  • InteriorFeatures:Garage Dr Opener(s): Yes
  • Garage Type:Side Entry: Yes

Utilities

  • Utilities: Cable Available, Cable Ready, Gas-Natural, Sewage-City, Electric-City, Trash-City
  • Cooling: Heat Pump(s), Central Electric, Ceiling/PaddleFan(s)
  • Heating: Heat Pump(s), Forced Air, Electric, Natural Gas
  • Laundry Features: Utility Sink, Laundry-Main Floor
  • Security: Wired for Sec Sys, Security System, Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Community Features: Community Lake
  • Association: No

Schools

  • Elementary School: Russell Boulevard
  • Junior High Dist: Columbia
  • High School: Rock Bridge
  • Middle Or Junior School: Gentry

Lot Info

  • Land Lease Amount Frequency: N/A
  • Land Lease: No
  • Lot Size Sq Ft: 39204.0
  • Parcel #: 16-504-00-04-025.00 01
  • Zoning Description: R-1 One- Family Dwelling*

Tax Info

  • Tax Annual Amount: 6085.87
  • Tax Year: 2024

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
May 2, 2025
Closed on
May 22, 2025
Sold by
Bought by
Seller's Agent
Donna Hepburn
REMAX Boone Realty
Buyer's Agent
DENISE PAYNE
Iron Gate Real Estate
List Price
$625,000
Views
21
Current Estimated Value
$628,786

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
1.93%
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
-- Boone Central Title
-- None Available
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
05/22/2025 05/22/25 Sold -- -- --
05/05/2025 05/05/25 Pending -- -- --
05/02/2025 05/02/25 For Sale $625,000 -- $138 / Sq Ft
Source: Columbia Board of REALTORS®

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $6,763 $103,284 $12,274 $91,010
2024 $6,086 $90,212 $12,274 $77,938
2023 $6,036 $90,212 $12,274 $77,938
2022 $5,582 $83,524 $12,274 $71,250
2021 $5,593 $83,524 $12,274 $71,250
2020 $5,511 $77,341 $12,274 $65,067
2019 $5,512 $77,341 $12,274 $65,067
2018 $5,337 $0 $0 $0
2017 $5,272 $74,366 $12,274 $62,092
2016 $5,411 $74,366 $12,274 $62,092
2015 $4,992 $74,366 $12,274 $62,092
2014 -- $74,366 $12,274 $62,092
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Columbia Board of REALTORS®

MLS Number: 426513

Columbia Board of REALTORS®

APN: 16-504-00-04-025-00-01

Your Personal Tour Guide

Ask me questions while you tour the home.