NOT LISTED FOR SALE

5104 Rosewood Ct Columbia, MO 65203

Cedar Lake Neighborhood

Estimated Value: $449,000 - $581,000

5 Beds
3.5 Baths
3,515 Sq Ft
$141/Sq Ft Est. Value

Last Sold June 12, 2023

Current estimated payment $2,947/month

Highlights

  • Heated Floors
  • Community Lake
  • Traditional Architecture
  • Mill Creek Elementary School Rated A-
  • Deck
  • Main Floor Primary Bedroom

About This Home

As of June 2023

Wonderful 2 story walk out in fabulous Cedar Lake area! New roof & HVAC, and stunning quartz countertops in the spacious kitchen. Gorgeous backyard with mature trees, garden area, and peaceful privacy. Steps to the lake for boating, fishing & swimming. Full mother in law suite in the basement!

Last Agent to Sell the Property

Heidi Barnhouse

RE/MAX Boone Realty License #2019046579 Listed on: 05/17/2023

RE/MAX Boone Realty

Last Buyer's Agent

Heidi Barnhouse

RE/MAX Boone Realty License #2019046579 Listed on: 05/17/2023

RE/MAX Boone Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,686

Year Built

  • Built in 1994

Lot Details

  • Lot Dimensions are 100.16x145
  • Cul-De-Sac
  • Northwest Facing Home
  • Wood Fence
  • Back Yard Fenced
  • Cleared Lot
  • Zoning described as R-S Single Family Residential

Parking

  • 3 Car Attached Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Traditional Architecture
  • Brick Veneer
  • Concrete Foundation
  • Poured Concrete
  • Architectural Shingle Roof
  • Radon Mitigation System
  • Vinyl Construction Material

Interior Spaces

  • 1.5-Story Property
  • Wet Bar
  • Ceiling Fan
  • Paddle Fans
  • Wood Burning Fireplace
  • Gas Fireplace
  • Vinyl Clad Windows
  • Family Room with Fireplace
  • Living Room with Fireplace
  • Breakfast Room
  • Formal Dining Room
  • Attic Fan

Kitchen

  • Electric Cooktop
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Quartz Countertops
  • Utility Sink
  • Disposal

Flooring

  • Wood
  • Carpet
  • Heated Floors
  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Primary Bedroom on Main
  • Split Bedroom Floorplan
  • Walk-In Closet
  • Bathtub with Shower
  • Shower Only

Laundry

  • Laundry on main level
  • Washer and Dryer Hookup

Partially Finished Basement

  • Walk-Out Basement
  • Interior Basement Entry
  • Sump Pump

Home Security

  • Storm Doors
  • Fire and Smoke Detector

Outdoor Features

  • Deck
  • Covered Patio or Porch

Schools

  • Mill Creek Elementary School
  • Gentry Middle School
  • Rock Bridge High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • High Speed Internet
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Cedar Lake Subdivision
  • Community Lake

Listing and Financial Details

  • Assessor Parcel Number 1691800021000001

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,686

Year Built

Built in 1994

Lot Details

0

Parking

3

Listing Details

  • Directions: Bethel to S Cedar Lake West to Dustin L on Dustin to Rosewood Ct
  • Lot Size: 100.16x145
  • Prop. Type: Residential
  • Year Built: 1994
  • BathsFull34LowerLevel: 1
  • BathsFull34MainLevel: 1
  • BathsFull34UpperLevel: 1
  • Property Sub Type: Single Family Residence
  • Road Surface Type: Paved, Public Maintained, Curbs and Gutters, Cul-de-sac
  • Subdivision Name: CEDAR LAKE
  • Above Grade Finished Sq Ft: 2915.0
  • Architectural Style: 1.5 Story
  • Garage Type Attached: Yes
  • Cooling:Central Electric: Yes
  • Foundation Access:Walkout: Yes
  • Foundation Material:Poured Concrete: Yes
  • ArchStyle:Traditional: Yes
  • Deck:Back: Yes
  • Dining:Breakfast Room: 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
  • Foundation Access:Inside Entrance: Yes
  • Dining:Formal Dining: Yes
  • TopoLot Description:Cleared: Yes
  • Utilities:Electric-City: Yes
  • Utilities:Sewage-City: Yes
  • Utilities:Water-City: Yes
  • Flooring:Vinyl3: Yes
  • Flooring:Wood2: Yes
  • Heat Fuel:Electricity: Yes
  • Heat Type:Floor: Yes
  • StreetRoads:Cul-de-sac: Yes
  • Fence:Backyard: Yes
  • Exterior Finish:Vinyl2: Yes
  • Porch:Covered2: Yes
  • Porch:Front2: Yes
  • Fence Material:Wood5: Yes
  • Fence:Full: Yes
  • Exterior Finish:Brick Veneer: Yes
  • Special Features: None

Interior Features

  • Flooring: Wood, Carpet, Tile, Vinyl
  • Interior Amenities: High Spd Int Access, Utility Sink, Tub/Shower, Stand AloneShwr/MBR, Split Bedroom Design, Sump Pump, Laundry-Main Floor, Walk in Closet(s), Main Lvl Master Bdrm, Radon Mit System, Bar-Wet Bar, Ceiling/PaddleFan(s), Cable Ready, Attic Fan, Additional Laundry Hookup(s), Storm Door(s), Smoke Detector(s), Garage Dr Opener(s), Breakfast Room, Formal Dining, Cabinets-Wood, Kitchen Island, Pantry, Counter-Quartz
  • Basement YN: Yes
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 600.0
  • Fireplace Features: In Living Room, Gas, In Family Room, Wood Burning
  • Fireplace: Yes
  • Living Area: 3515.0
  • Fireplace:Gas: Yes
  • 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:Split Bedroom Design: Yes
  • InteriorFeatures:TubShower: 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
  • Fireplace:In Living Room: Yes
  • InteriorFeatures:Bar-Wet Bar: Yes
  • InteriorFeatures:Radon Mit System: Yes
  • InteriorFeatures:Stand AloneShwrMBR: Yes
  • InteriorFeatures:Utility Sink: Yes
  • KitchenFeatures:Refrigerator: Yes
  • Fireplace:Wood Burning: Yes
  • KitchenFeatures:Range-Electric: Yes
  • KitchenFeatures:Counter-Quartz: Yes
  • KitchenFeatures:Vent Fan: Yes
  • InteriorFeatures:Storm Door(s): Yes
  • KitchenFeatures:Cooktop-Electric: Yes
  • InteriorFeatures:Additional Laundry Hookup(s): Yes
  • InteriorFeatures:Sump Pump: Yes
  • InteriorFeatures:Attic Fan: Yes

Exterior Features

  • Exterior Features: Community Lake, Driveway-Paved, Windows-Vinyl
  • Roof: ArchitecturalShingle
  • Fencing: Backyard, Full, Wood
  • Lot Features: Cleared
  • Direction Faces: Northwest
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Deck, Front Porch
  • Exterior Features:Driveway-Paved: Yes
  • Exterior Features:Windows-Vinyl: Yes
  • Exterior Features:Community Lake: Yes

Garage/Parking

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

Utilities

  • Utilities: Water-City, Gas-Natural, Sewage-City, Electric-City, Trash-City
  • Cooling: Central Electric
  • Heating: Forced Air, Floor, Electric, Natural Gas
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Association: No

Schools

  • Elementary School: Mill Creek
  • 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 #: 1691800021000001
  • Zoning Description: R-S Single Family Residential

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 17, 2023
Closed on
Jun 12, 2023
Sold by
Beattie James and Beattie Barbara
Bought by
Scheltmeyer Derek and Casto Clare
Seller's Agent
Heidi Barnhouse
RE/MAX Boone Realty
Buyer's Agent
Heidi Barnhouse
RE/MAX Boone Realty
List Price
$380,000
Current Estimated Value
$495,662

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
12.54%
Original Mortgage
$361,000
Outstanding Balance
$351,417
Interest Rate
6.43%
Mortgage Type
New Conventional
Estimated Equity
$144,245
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
Scheltmeyer Derek -- Boone Central Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Scheltmeyer Derek $361,000
Closed Beattie James $190,000
Previous Owner Beattie James $50,000
Previous Owner Beattie James $207,543
Previous Owner Beattie James $207,324
Previous Owner Beattie James $209,156
Previous Owner Beattie James $215,247
Previous Owner Beattie James $212,802
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/12/2023 06/12/23 Sold -- -- --
05/17/2023 05/17/23 Pending -- -- --
05/17/2023 05/17/23 For Sale $380,000 -- $108 / 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 $3,686 $62,567 $5,985 $56,582
2024 $3,686 $54,644 $5,985 $48,659
2023 $3,656 $54,644 $5,985 $48,659
2022 $3,382 $50,597 $5,985 $44,612
2021 $3,388 $50,597 $5,985 $44,612
2020 $3,338 $46,846 $5,985 $40,861
2019 $3,338 $46,846 $5,985 $40,861
2018 $3,113 $0 $0 $0
2017 $3,075 $43,377 $5,985 $37,392
2016 $3,070 $43,377 $5,985 $37,392
2015 $2,819 $43,377 $5,985 $37,392
2014 $2,828 $43,377 $5,985 $37,392
Source: Public Records

Agents Affiliated with this Home

  • Heidi Barnhouse

    Seller's Agent in 2023

    Heidi Barnhouse

    RE/MAX

    (573) 864-2708

    1 in this area

    197 Total Sales

    Heidi Barnhouse
    Section Image
See All Agents

Map

Source: Columbia Board of REALTORS®

MLS Number: 413589

Columbia Board of REALTORS®

APN: 16-918-00-02-100-00-01

Missouri Boone County Columbia 65203 Cedar Lake

5104 Rosewood Ct, Columbia, MO

This home is located at 5104 Rosewood Ct, Columbia, MO 65203 since 17 May 2023 and is currently estimated at $495,662, approximately $141 per square foot. This property was built in 1994. 5104 Rosewood Ct is a home located in Boone County with nearby schools including Mill Creek Elementary School, Ann Hawkins Gentry Middle School, and Rock Bridge High School.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Columbia Board of REALTORS® IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

Nearby Homes