NOT LISTED FOR SALE

2409 Sparkleberry Ct Columbia, MO 65201

Estimated Value: $798,000 - $844,000

5 Beds
4.5 Baths
5,142 Sq Ft
$159/Sq Ft Est. Value

Last Sold June 13, 2025

Current estimated payment $4,956/month

5 Days on Market

Highlights

  • Community Lake
  • Deck
  • Partially Wooded Lot
  • Jefferson Middle School Rated A-
  • Recreation Room
  • Traditional Architecture

About This Home

As of June 2025

This exquisite luxury home spans over 5,000 sq ft on a prime corner cul-de-sac lot in Bluff Creek Estates.A grand staircase greets you at the entry, flanked by a formal dining room and study.The chef-inspired kitchen features top-tier stainless steel appliances, a gas cooktop, and stunning quartz countertops-perfect for both everyday meals and entertaining.The main floor master suite offers a private sitting room, exercise room, and a newly renovated bath with custom cabinetry and elegant fixtures.Four spacious bedrooms filled with natural light, each featuring a walk-in closetThe home also boasts a brand-new roof installed in 2024, ensuring lasting quality.

Last Agent to Sell the Property

Jennifer Zhang

RE/MAX Boone Realty License #2016035211 Listed on: 03/27/2025

RE/MAX Boone Realty

Last Buyer's Agent

Billy Dexheimer

North Star Real Estate License #2015019891

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,125

Year Built

  • Built in 1995

Lot Details

  • 0.62 Acre Lot
  • Lot Dimensions are 131.80 x 204.35
  • Cul-De-Sac
  • South Facing Home
  • Level Lot
  • Sprinkler System
  • Partially Wooded Lot
  • Vegetable Garden

HOA Fees

  • $33 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Traditional Architecture
  • Concrete Foundation
  • Poured Concrete
  • Architectural Shingle Roof
  • Synthetic Stucco Exterior

Interior Spaces

  • Wet Bar
  • Paddle Fans
  • Screen For Fireplace
  • Gas Fireplace
  • Vinyl Clad Windows
  • Window Treatments
  • Family Room with Fireplace
  • Living Room
  • Formal Dining Room
  • Home Office
  • Recreation Room
  • First Floor Utility Room
  • Laundry on main level
  • Utility Room
  • Attic Fan

Kitchen

  • Eat-In Kitchen
  • Built-In Double Oven
  • Gas Cooktop
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Quartz Countertops
  • Built-In or Custom Kitchen Cabinets
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Primary Bedroom on Main
  • Walk-In Closet
  • Bathroom on Main Level
  • Hydromassage or Jetted Bathtub
  • Bathtub with Shower
  • Shower Only

Partially Finished Basement

  • Walk-Out Basement
  • Fireplace in Basement

Home Security

  • Home Security System
  • Fire and Smoke Detector

Outdoor Features

  • Deck
  • Patio
  • Front Porch

Schools

  • New Haven Elementary School
  • Gentry Middle School
  • Rock Bridge High School

Utilities

  • Humidifier
  • Whole House Fan
  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Water Softener is Owned
  • Cable TV Available

Community Details

  • Built by Oakstone
  • Bluffcreek Est Subdivision
  • Community Lake

Listing and Financial Details

  • Assessor Parcel Number 17-702-00-07-059.00 01

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,125

Year Built

Built in 1995

Lot Details

0

HOA Fees

$33 per month

Parking

3

Listing Details

  • Directions: Bluff Creek Dr. Left to Lacewood Dr. left to Sparkleberry Ct.
  • Lot Size: 131.80 X 204.35
  • Prop. Type: Residential
  • Bedroom 2 Level: Upper
  • Dining Room Level: Main
  • Full Bathroom Level: Lower
  • Half Bathroom Level: Main
  • Kitchen Level: Main
  • Living Room Level: Main
  • Primary Bedroom Level: Main
  • Year Built: 1995
  • BathsFull34LowerLevel: 1
  • BathsFull34MainLevel: 1
  • BathsFull34Total: 4
  • BathsFull34UpperLevel: 2
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.62
  • Road Surface Type: Paved, Public Maintained, Curbs and Gutters, Cul-de-sac
  • Subdivision Name: BLUFFCREEK EST
  • Above Grade Finished Sq Ft: 4005.0
  • Architectural Style: 15 Story
  • Garage Type Attached: Yes
  • Cooling:Central Electric: Yes
  • Foundation Access:Walkout: 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
  • Patio:Back3: Yes
  • Baths-Half:Main Level2: 1
  • Baths-Half:Total2: 1
  • Rooms:Dining Room: Yes
  • Rooms:Living Room: Yes
  • Rooms:Office: Yes
  • Rooms:Recreation Room2: Yes
  • Foundation Type:Full Bsmt Part Fin: Yes
  • Exterior Finish:Synthetic Stucco: Yes
  • Dining:Eat-In Kitchen: Yes
  • Dining:Formal Dining: Yes
  • Utilities:Electric-City: Yes
  • Utilities:Sewage-City: Yes
  • Utilities:Water-City: Yes
  • Flooring:Wood2: Yes
  • StreetRoads:Cul-de-sac: Yes
  • Porch:Front2: Yes
  • TopoLot Description:Level: Yes
  • Special Features: None

Interior Features

  • Bedroom 3 Level: Upper
  • Bedroom 4 Level: Upper
  • Bedroom 5 Level: Lower
  • Office Level: Main
  • Utility Room Level: Main
  • Flooring: Wood, Carpet, Tile
  • Interior Amenities: Tub/Shower, Stand AloneShwr/MBR, Tub/Built In Jetted, WindowTreatmnts Some, Walk in Closet(s), Main Lvl Master Bdrm, Bar-Wet Bar, Attic Fan, FireplaceScreenDr(s), 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: 4
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 1137.0
  • Fireplace Features: In Basement, Gas, In Family Room
  • Fireplace: Yes
  • Living Area: 5142.0
  • Window Features: Windows-Vinyl
  • Fireplace:Gas: Yes
  • Fireplace:In Family Room: Yes
  • InteriorFeatures:CeilingPaddleFan(s): 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
  • 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
  • InteriorFeatures:Bar-Wet Bar: Yes
  • InteriorFeatures:Cable Available: Yes
  • InteriorFeatures:Humidifier: Yes
  • InteriorFeatures:Security System: Yes
  • InteriorFeatures:Stand AloneShwrMBR: Yes
  • InteriorFeatures:TubBuilt In Jetted: Yes
  • KitchenFeatures:Cooktop-Gas: Yes
  • KitchenFeatures:Refrigerator: Yes
  • InteriorFeatures:Water Softener Owned: Yes
  • InteriorFeatures:FireplaceScreenDr(s): Yes
  • KitchenFeatures:Counter-Quartz: Yes
  • KitchenFeatures:Double Oven: Yes
  • KitchenFeatures:Vent Fan: Yes
  • KitchenFeatures:Wall Oven(s): Yes
  • InteriorFeatures:WindowTreatmnts Some: Yes
  • Fireplace:In Basement: Yes
  • InteriorFeatures:Attic Fan: Yes
  • InteriorFeatures:Whole House Fan: Yes

Exterior Features

  • Builder Name: Oakstone
  • Exterior Features: Vegetable Garden, Driveway-Paved
  • Roof: ArchitecturalShingle
  • Lot Features: Sprinkler-In Ground, Level
  • Direction Faces: South
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Back, 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:Vegetable Garden: 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

Utilities

  • Utilities: Cable Available, Water-City, Gas-Natural, Sewage-City, Electric-City, Trash-City
  • Cooling: Central Electric, Whole House Fan, Ceiling/PaddleFan(s)
  • Heating: Forced Air, Natural Gas
  • Laundry Features: Laundry-Main Floor
  • Security: Security System, Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Community Features: Community Lake
  • Association Fee: 400.0
  • Association Fee Frequency: Annual
  • Association: Yes

Schools

  • Elementary School: New Haven
  • 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: 26933.0
  • Parcel #: 17-702-00-07-059.00 01
  • Zoning Description: R-1 One- Family Dwelling*

Tax Info

  • Tax Annual Amount: 7125.41
  • Tax Year: 2024

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 27, 2025
Closed on
Jun 30, 2025
Sold by
Ward Patrick and Ward Carolyn
Bought by
Marie Devlin Trust and Ward
Seller's Agent
Jennifer Zhang
RE/MAX Boone Realty
Buyer's Agent
Billy Dexheimer
North Star Real Estate
List Price
$819,000
Views
70
Current Estimated Value
$816,552

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-4.70%
Original Mortgage
$830,000
Outstanding Balance
$829,287
Interest Rate
6.76%
Mortgage Type
New Conventional
Estimated Equity
-$10,787

Purchase Details

Listed on
Mar 27, 2025
Closed on
Jun 13, 2025
Sold by
Liu Zhenguo and Hao Hong
Bought by
Ward Patrick and Ward Carolyn
Seller's Agent
Jennifer Zhang
RE/MAX Boone Realty
Buyer's Agent
Billy Dexheimer
North Star Real Estate
List Price
$819,000
Views
70

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$830,000
Outstanding Balance
$829,287
Interest Rate
6.76%
Mortgage Type
New Conventional
Estimated Equity
-$10,787

Purchase Details

Listed on
Apr 14, 2017
Closed on
Feb 26, 2018
Sold by
Kingsley Clint Daniel and Kingsley Paula
Bought by
Liu Zhenguo and Hao Hong
Seller's Agent
Paul Smith
Weichert, Realtors - House of Brokers
Buyer's Agent
Thaddeus Usovsky
RE/MAX Boone Realty
List Price
$569,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.07%
Original Mortgage
$432,000
Interest Rate
3.99%
Mortgage Type
New Conventional

Purchase Details

Listed on
Apr 30, 2014
Closed on
Jul 14, 2014
Sold by
Steinmann William C and Steinmann Helen C
Bought by
Kingsley Clint Daniel and Kingsley Paula
Seller's Agent
Ted Webber
RE/MAX Boone Realty
Buyer's Agent
Paul Smith
Weichert, Realtors - House of Brokers
List Price
$535,000

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.59%
Original Mortgage
$408,000
Interest Rate
4.17%
Mortgage Type
New Conventional

Purchase Details

Closed on
Nov 30, 2006
Sold by
Putnam Mark L and Putnam Rose Jacquelien
Bought by
Steinmann William C and Steinmann Helen C

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$325,000
Interest Rate
6.3%
Mortgage Type
New Conventional
Source: Public Records

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 Buyer Sale Price Title Company
Marie Devlin Trust -- None Listed On Document
Marie Devlin Trust -- None Listed On Document
Ward Patrick -- Boone Central Title
Ward Patrick -- Boone Central Title
Liu Zhenguo -- Boone Central Title Co
Kingsley Clint Daniel -- None Available
Steinmann William C -- Boone Central Title Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Ward Patrick $830,000
Closed Ward Patrick $830,000
Previous Owner Liu Zhenguo $432,000
Previous Owner Kingsley Clint Daniel $408,000
Previous Owner Steinmann William C $325,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/13/2025 06/13/25 Sold -- -- --
04/01/2025 04/01/25 Pending -- -- --
03/27/2025 03/27/25 For Sale $819,000 +43.7% $159 / Sq Ft
02/26/2018 02/26/18 Sold -- -- --
01/04/2018 01/04/18 Pending -- -- --
04/14/2017 04/14/17 For Sale $569,900 +6.5% $112 / Sq Ft
07/15/2014 07/15/14 Sold -- -- --
06/10/2014 06/10/14 Pending -- -- --
04/30/2014 04/30/14 For Sale $535,000 -- $106 / 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
2025 $7,125 $120,935 $9,918 $111,017
2024 $7,125 $105,621 $9,918 $95,703
2023 $7,067 $105,621 $9,918 $95,703
2022 $6,787 $101,555 $9,918 $91,637
2021 $6,800 $101,555 $9,918 $91,637
2020 $6,958 $97,641 $9,918 $87,723
2019 $6,958 $97,641 $9,918 $87,723
2018 $7,007 $0 $0 $0
2017 $6,922 $97,641 $9,918 $87,723
2016 $6,910 $97,641 $9,918 $87,723
2015 $6,346 $97,641 $9,918 $87,723
2014 $6,367 $97,641 $9,918 $87,723
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: 425934

Columbia Board of REALTORS®

APN: 17-702-00-07-059-00-01