$385,000
SOLD AUG 26, 2025
Last list price

2509 Lloyd Dr Columbia, MO 65203

3 Beds
2.5 Baths
2,318 Sq Ft
1988 Built

Recently Sold

$166 Per Sq Ft

4 Days on Market

Highlights

  • Partially Wooded Lot
  • Traditional Architecture
  • No HOA
  • Jefferson Middle School Rated A-
  • Quartz Countertops
  • Covered Patio or Porch

About This Home

As of August 2025

Welcome to your next home in one of Columbia's most desirable neighborhoods—just steps from MKT Trail and a private entrance to Twin Lakes Dog Park! This fully renovated 3-bed, 2.5-bath home (2021) features concrete siding, energy-efficient windows, updated doors, trim, stylish flooring, plush carpet, neutral paint, and a cozy wood-burning fireplace. Washer/dryer and new fridge included! Enjoy a fenced, wooded backyard with a new concrete patio and storage shed. Located 8 minutes from campus and no HOA fees! Don't miss this one!

Last Agent to Sell the Property

Vicki Brocksmith

Berkshire Hathaway HomeServices | Vision Real Estate License #2003025782 Listed on: 07/25/2025

Berkshire Hathaway HomeServices | Vision Real Estate

Last Buyer's Agent

Nick Parry

Weichert, Realtors - House of Brokers License #2022038257

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,303

Year Built

  • Built in 1988 | Remodeled

Lot Details

  • East Facing Home
  • Wood Fence
  • Back Yard Fenced
  • Aluminum or Metal Fence
  • Lot Has A Rolling Slope
  • Partially Wooded Lot

Parking

  • 2 Car Attached Garage
  • Driveway

Home Design

  • Traditional Architecture
  • Brick Veneer
  • Concrete Foundation
  • Poured Concrete
  • Architectural Shingle Roof

Interior Spaces

  • 2-Story Property
  • Paddle Fans
  • Wood Burning Fireplace
  • Vinyl Clad Windows
  • Window Treatments
  • Breakfast Room
  • Formal Dining Room
  • Smart Thermostat
  • Finished Basement

Kitchen

  • Eat-In Kitchen
  • Electric Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Quartz Countertops
  • Disposal

Flooring

  • Carpet
  • Laminate
  • Vinyl

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet

Laundry

  • Dryer
  • Washer

Outdoor Features

  • Covered Patio or Porch
  • Storage Shed

Schools

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

Utilities

  • Whole House Fan
  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Programmable Thermostat
  • Water Softener is Owned

Community Details

  • No Home Owners Association
  • Hillshire Est Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1650400060640001

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,303

Year Built

Built in 1988 | Remodeled

Lot Details

0

Parking

2

Listing Details

  • Directions: Chapel Hill Road, south on Martinshire, right on Kyle to Lloyd Drive.
  • Lot Size: 74.22 × 126.30
  • Prop. Type: Residential
  • Full Bathroom Level: Upper
  • Half Bathroom Level: Lower
  • Year Built: 1988
  • Property Sub Type: Single Family Residence
  • Road Surface Type: Paved, Public Maintained
  • Subdivision Name: HILLSHIRE EST
  • Above Grade Finished Sq Ft: 1618.0
  • Architectural Style: 2 Story
  • New Construction: No
  • Garage Type Attached: Yes
  • Cooling:Central Electric: Yes
  • Exterior Finish:Concrete BoardFiber Cement: Yes
  • Foundation Material:Poured Concrete: Yes
  • ArchStyle:Traditional: Yes
  • Dining:Breakfast Room: Yes
  • TopoLot Description:Partially Wooded: Yes
  • Roof:ArchitecturalShingle: Yes
  • Flooring:Carpet: Yes
  • Flooring:Laminate: Yes
  • Heat Fuel:Natural Gas: Yes
  • Heat Type:Forced Air: Yes
  • Patio:Back3: Yes
  • Dining:Eat-In Kitchen: Yes
  • Dining:Formal Dining: Yes
  • Utilities:Electric-City: Yes
  • Utilities:Sewage-City: Yes
  • Utilities:Water-City: Yes
  • Flooring:Vinyl3: Yes
  • Heat Fuel:Electricity: Yes
  • Patio:Covered3: Yes
  • Fence:Backyard: Yes
  • Fence Material:Wood5: Yes
  • Outbuildings:LawnStorage Shed: Yes
  • Baths-Half:Lower Level2: 1
  • Fence:Full: Yes
  • Exterior Finish:Brick Veneer: Yes
  • Fence Material:Metal4: Yes
  • Foundation Type:Part Bsmt Full Fin: Yes
  • Special Features: None

Interior Features

  • Flooring: Carpet, Laminate, Vinyl
  • Interior Amenities: Window Treatmnts All, Walk in Closet(s), Smart Thermostat, Breakfast Room, Eat-in Kitchen, Formal Dining, Cabinets-Wood, Kitchen Island, Pantry, Counter-Quartz
  • Appliances: Water Softener Owned
  • Basement YN: Yes
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Below Grade Sq Ft: 700.0
  • Fireplace Features: Wood Burning
  • Fireplace: Yes
  • Living Area: 2318.0
  • Window Features: Windows-Vinyl
  • InteriorFeatures:CeilingPaddleFan(s): Yes
  • InteriorFeatures:Walk in Closet(s): 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
  • InteriorFeatures:Programmable Thermostat(s): Yes
  • InteriorFeatures:Remodeled: Yes
  • InteriorFeatures:Window Treatmnts All: Yes
  • KitchenFeatures:Refrigerator: Yes
  • Fireplace:Wood Burning: Yes
  • InteriorFeatures:Water Softener Owned: Yes
  • KitchenFeatures:Range-Electric: Yes
  • KitchenFeatures:Counter-Quartz: Yes
  • KitchenFeatures:Vent Fan: Yes
  • InteriorFeatures:Dryer3: Yes
  • InteriorFeatures:Washing Machine2: Yes
  • InteriorFeatures:Whole House Fan: Yes

Exterior Features

  • Exterior Features: Driveway-Paved
  • Roof: ArchitecturalShingle
  • Fencing: Backyard, Full, Metal, Wood
  • Lot Features: Rolling Slope
  • Direction Faces: East
  • Foundation Details: Poured Concrete
  • Other Structures: Lawn/Storage Shed
  • Patio And Porch Features: Back, Covered
  • Property Condition: Remodeled
  • Exterior Features:Driveway-Paved: Yes
  • Exterior Features:Windows-Vinyl: Yes

Garage/Parking

  • Garage Spaces: 2.0
  • Parking Features: Attached
  • General Property Description:Garage Capacity: 2

Utilities

  • Utilities: Water-City, Sewage-City, Electric-City, Trash-City
  • Cooling: Central Electric, Whole House Fan, Ceiling/PaddleFan(s)
  • Heating: Forced Air, Electric, Natural Gas
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • 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
  • Parcel #: 1650400060640001
  • Zoning Description: R-1 One- Family Dwelling*

Tax Info

  • Tax Annual Amount: 2303.35
  • Tax Year: 2024

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Nov 22, 2022
Sold by
Brammeier Rachel Brocksmith and Brammeier Benjamin J
Bought by
Bjb And Rbb Revocable Trust

Purchase Details

Listed on
Jan 27, 2014
Closed on
Mar 27, 2014
Sold by
Volkart Alan H and Volkart Elizabeth E
Bought by
Brocksmith Rachel Lauren
Seller's Agent
Jackie Bulgin
Weichert, Realtors - House of Brokers
Buyer's Agent
Vicki Brocksmith
Berkshire Hathaway HomeServices | Vision Real Estate
List Price
$191,900

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.13%
Original Mortgage
$153,600
Interest Rate
4.32%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jan 25, 2006
Sold by
Volkart Alan H and Volkart Elizabeth E
Bought by
Volkart Alan H and Volkart Elizabeth E
Source: Public Records

Similar Homes in Columbia, MO

  • 3005 Meghann Dr, Columbia, MO 65203

    $375,000

    • 4 Beds
    • 3 Baths
    • 3,070 Sq Ft
    • 3005 Meghann Dr
    • Columbia, MO

    Welcome to this conveniently located SW Columbia home—near Fairview Park, Bonnie View Nature Sanctuary, Twin Lakes Dog Park, and with easy access to the MKT Trail—this well-maintained, one-owner home combines classic design with a beautiful natural setting.Inside, you'll find a traditional, compartmentalized floor plan featuring a formal dining room perfect for gatherings and a finished

    Dennis Jordan American Jewell Realty LLC

    Section Image
  • 1710 Kassem Dr, Columbia, MO 65202

    $340,000

    • 3 Beds
    • 2 Baths
    • 1,506 Sq Ft
    • 1710 Kassem Dr
    • Columbia, MO

    A house with room to expand! Built in 2020, this home offers an open-concept layout, split-bedroom design, and a bright kitchen on the main level.But the REAL appeal: The full walkout basement. Already equipped with plumbing rough-ins and full-size windows. Over 1,500 sq ft of blank canvas is ready for your vision - whether that's a home theater, guest suite, gym, workshop, or more. With

    Billy Dexheimer North Star Real Estate

    Section Image
  • 5805 Harvest Leaf Dr, Columbia, MO 65202

    $382,000

    • 3 Beds
    • 2 Baths
    • 1,722 Sq Ft
    • 5805 Harvest Leaf Dr
    • Columbia, MO

    NEW CONSTRUCTION by Shannon James in Arbor Pointe's newest phase! This stunning 3BR/2BA home on Harvest Leaf features exceptional trim work, open concept design with split bedroom layout, and 3-car garage. Backs to serene woods while being walkable to park, pool & Alpha Hart Lewis Elementary. High-quality build with outstanding color scheme. Quick highway access - just 10 minutes to downtown

    Kyle Edwards Berkshire Hathaway HomeServices | Vision Real Estate

    Section Image
  • 1706 Marylee Ct, Columbia, MO 65203

    $300,000

    • 3 Beds
    • 2 Baths
    • 1,559 Sq Ft
    • 1706 Marylee Ct
    • Columbia, MO

    Neat as a pin and close to everything, this 3-bed, 2-bath single-owner home is ready for you to come fall in love! Featuring in-ground sprinklers, split-bedroom design, a gas fireplace in the living room and hard-wearing wood-look vinyl flooring in the main living spaces. Washer/dryer and all kitchen appliances convey.

    Gary Meyer Weichert, Realtors - House of Brokers

    Section Image
  • 1201 Fieldcrest, Columbia, MO 65203

    $465,000

    • 5 Beds
    • 3 Baths
    • 3,334 Sq Ft
    • 1201 Fieldcrest
    • Columbia, MO

    Remarkable home that lives LARGE! So many beautiful moments here...original wood floors; updates galore including kitchen and baths; 2 living areas; 3 car tandem garage; garage shop area with 1/2 bath to finish; amazing indoor/outdoor living area on patio with French doors making fall entertaining so enjoyable! Don't miss out on this SW beauty!

    Beth Arey Arey Real Estate

    Section Image
  • 1305 Jake Ln, Columbia, MO 65203

    $310,000

    • 3 Beds
    • 3 Baths
    • 2,068 Sq Ft
    • 1305 Jake Ln
    • Columbia, MO

    Welcome to this incredible home, built to stand the test of time and nestled in one of Columbia's most desirable southwest neighborhoods. Featuring brand-new flooring and fresh paint throughout, it's ready for you to make it your own. The spacious layout includes a boastful primary suite, oversized windows that flood the home with natural light, and a second living area offering flexibility for

    Megan Walters EXP Realty LLC

    Section Image
  • 2706 Chambray Rd, Columbia, MO 65203

    $429,900

    • 5 Beds
    • 3 Baths
    • 2,667 Sq Ft
    • 2706 Chambray Rd
    • Columbia, MO

    Beautiful 5-bedroom, 3-bath ranch with a walk-out lower level, brick and polymer siding exterior, and spacious 3-car garage! The main floor features a large primary suite with an en suite bath and generous walk-in closet, complemented by a second bedroom, full bath, and convenient laundry room. The open-concept living and dining area is bathed in natural light from a wall of windows and showcases

    Michelle Gerdin MORE, REALTORS

    Section Image
  • 3804 Addison Dr, Columbia, MO 65203

    $299,999

    • 3 Beds
    • 2 Baths
    • 1,815 Sq Ft
    • 3804 Addison Dr
    • Columbia, MO

    Discover the charm of 3804 Addison Dr, a beautifully designed 3-bedroom, 2-bath, one-owner, home in Columbia, MO. This single-family residence offers a spacious and inviting layout. The home features a two-car attached garage, central air conditioning, and a cozy living room with a gas fireplace. The primary suite boasts a jetted tub and separate shower, providing a relaxing retreat. The kitchen

    Dara Williams Weichert, Realtors - House of Brokers

    Section Image

Range of Values:

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

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Type Sale Price Title Company
Warranty Deed -- --
Deed -- None Available
Interfamily Deed Transfer -- None Available
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $155,850 New Conventional
Previous Owner $153,600 New Conventional
Previous Owner $60,000 Credit Line Revolving
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/26/2025 08/26/25 Sold -- -- --
07/29/2025 07/29/25 Pending -- -- --
07/25/2025 07/25/25 For Sale $385,000 +100.6% $166 / Sq Ft
03/28/2014 03/28/14 Sold -- -- --
02/19/2014 02/19/14 Pending -- -- --
01/27/2014 01/27/14 For Sale $191,900 -- $90 / Sq Ft
Source: Columbia Board of REALTORS®

Tax History Compared to Growth

Source: Public Records

Tax History

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
2024 $2,303 $34,143 $4,921 $29,222
2023 $2,284 $34,143 $4,921 $29,222
2022 $2,113 $31,616 $4,921 $26,695
2021 $2,117 $31,616 $4,921 $26,695
2020 $2,087 $29,282 $4,921 $24,361
2019 $2,087 $29,282 $4,921 $24,361
2018 $1,946 $0 $0 $0
2017 $1,922 $27,113 $4,921 $22,192
2016 $1,973 $27,113 $4,921 $22,192
2015 $1,820 $27,113 $4,921 $22,192
2014 $1,830 $27,113 $4,921 $22,192
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Columbia Board of REALTORS®

MLS Number: 428719

Columbia Board of REALTORS®

APN: 16-504-00-06-064-00-01