NOT LISTED FOR SALE

5514 Fremont Ct Columbia, MO 65203

Estimated Value: $676,000 - $704,000

5 Beds
3.5 Baths
3,206 Sq Ft
$214/Sq Ft Est. Value

Last Sold October 15, 2021

Current estimated payment $4,333/month

76 Days on Market

Highlights

  • Community Lake
  • Covered Deck
  • Granite Countertops
  • Beulah Ralph Elementary School Rated A-
  • Ranch Style House
  • Community Pool

About This Home

As of October 2021

BOM due to buyer financing....SHOW STOPPER! Come see this AMAZING NEW home in SW Columbia!! Sitting on a BEAUTUFUL cul de sac lot, offering 5 bedrooms 3 bathrooms and a 3 car garage! From the GORGEOUS kitchen and LARGE WALK IN PANTRY to the STUNNING master bathroom with a jetted tub to relax in. and basement bar for you to entertain in, you are sure to fall in love with every room in this house! Schedule your appointment TODAY!

Last Agent to Sell the Property

Karla Hill, P.C.

Weichert, Realtors - First Tier License #2009021674 Listed on: 09/13/2021

Co-Listed By

Mike Hill

Weichert, Realtors - House of License #2004013721

Last Buyer's Agent

Gary Meyer

Weichert, Realtors - House of License #1999022761

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,204

Year Built

  • Built in 2021

Lot Details

  • Cul-De-Sac
  • Sprinkler System
  • Cleared Lot

HOA Fees

  • $33 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Garage Door Opener
  • Driveway
  • Open Parking

Home Design

  • Ranch Style House
  • Traditional Architecture
  • Concrete Foundation
  • Poured Concrete
  • Architectural Shingle Roof
  • Radon Mitigation System

Interior Spaces

  • Wired For Data
  • Bar
  • Paddle Fans
  • Electric Fireplace
  • Vinyl Clad Windows
  • Living Room with Fireplace
  • Formal Dining Room
  • Partially Finished Basement
  • Walk-Out Basement
  • Fire and Smoke Detector
  • Laundry on main level

Kitchen

  • Gas Range
  • <<microwave>>
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Disposal

Flooring

  • Carpet
  • Laminate
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Split Bedroom Floorplan
  • Shower Only
  • Garden Bath

Outdoor Features

  • Covered Deck
  • Covered patio or porch

Schools

  • Beulah Ralph Elementary School
  • John Warner Middle School
  • Rock Bridge High School

Utilities

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

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Assessor Parcel Number 2010000021170001

Community Details

Overview

  • $500 Initiation Fee
  • Built by Dynamic Builders
  • Steeplechase Est Subdivision
  • Community Lake

Recreation

  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,204

Year Built

Built in 2021

Lot Details

0

HOA Fees

$33 per month

Parking

3

Listing Details

  • Directions: Scott Blvd. to Thornbrook Ridge, left on Newbury, left on Fremont
  • Lot Size: 134.88 × 138.18
  • Prop. Type: Residential
  • Year Built: 2021
  • BathsFull34LowerLevel: 1
  • BathsFull34MainLevel: 2
  • BathsFull34Total: 3
  • BathsFull34UpperLevel: 0
  • Property Sub Type: Single Family Residence
  • Road Surface Type: Paved, Public Maintained, Curbs and Gutters, Cul-de-sac
  • Co List Office Mls Id: 10740
  • Co List Office Phone: 573-256-8601
  • Subdivision Name: STEEPLECHASE EST
  • Above Grade Finished Sq Ft: 2062.0
  • Architectural Style: Ranch
  • Garage Type Attached: Yes
  • Cooling:Central Electric: Yes
  • Exterior Finish:Concrete BoardFiber Cement: Yes
  • Foundation Access:Walkout: Yes
  • Foundation Material:Poured Concrete: Yes
  • ArchStyle:Traditional: Yes
  • Deck:Back: Yes
  • Deck:Covered: Yes
  • Roof:ArchitecturalShingle: Yes
  • Flooring:Carpet: Yes
  • Flooring:Laminate: 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
  • Foundation Type:Full Bsmt Part Fin: Yes
  • Dining:Formal Dining: Yes
  • Dining:KitDin Combo: Yes
  • TopoLot Description:Cleared: Yes
  • Utilities:Electric-City: Yes
  • Utilities:Sewage-City: Yes
  • Utilities:Water-City: Yes
  • Patio:Covered3: Yes
  • StreetRoads:Cul-de-sac: Yes
  • Porch:Covered2: Yes
  • Porch:Front2: Yes
  • Baths-Half:Lower Level2: 0
  • Baths-Half:Upper Level2: 0
  • Special Features: None

Interior Features

  • Flooring: Carpet, Laminate, Tile
  • Interior Amenities: High Spd Int Access, Stand AloneShwr/MBR, Split Bedroom Design, Tub-Garden, Main Lvl Master Bdrm, Bar, Data Wiring, Radon Mit Ready, Home Warranty, Formal Dining, Kit/Din Combo, Granite Counters, Cabinets-Wood, Kitchen Island
  • Basement YN: Yes
  • Full Bathrooms: 3
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 1144.0
  • Fireplace Features: In Living Room
  • Fireplace: Yes
  • Living Area: 3206.0
  • Window Features: Windows-Vinyl
  • 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:Tub-Garden: Yes
  • KitchenFeatures:Cabinets-Wood: Yes
  • KitchenFeatures:Dishwasher-Built In: Yes
  • KitchenFeatures:Garbage Disposal: Yes
  • KitchenFeatures:Island: Yes
  • KitchenFeatures:Microwave Oven: Yes
  • KitchenFeatures:Range-Gas: Yes
  • Fireplace:In Living Room: Yes
  • InteriorFeatures:Cable Available: Yes
  • InteriorFeatures:Data Wiring: Yes
  • InteriorFeatures:Stand AloneShwrMBR: Yes
  • KitchenFeatures:Counter-Granite: Yes
  • InteriorFeatures:Home Warranty: Yes
  • InteriorFeatures:Radon Mit Ready: Yes
  • InteriorFeatures:Bar: Yes
  • Fireplace:Electric3: Yes

Exterior Features

  • Builder Name: Dynamic Builders
  • Exterior Features: Driveway-Paved
  • Roof: ArchitecturalShingle
  • Lot Features: Sprinkler-In Ground, Cleared
  • Pool Features: Pool-Community
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Back, Covered, 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:Pool-Community: Yes

Garage/Parking

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

Utilities

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

Condo/Co-op/Association

  • Community Features: Community Lake
  • Association #2 Fee: 500.0
  • Association Fee: 400.0
  • Association Fee Frequency: Annual
  • Association: Yes

Schools

  • Elementary School: Beulah Ralph
  • Junior High Dist: Columbia
  • High School: Rock Bridge
  • Middle Or Junior School: John Warner

Lot Info

  • Land Lease Amount Frequency: N/A
  • Land Lease: No
  • Parcel #: 2010000021170001
  • Zoning Description: R-1 One- Family Dwelling*

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Jun 23, 2022
Sold by
Chadha Rohit and Singh Priyanka
Bought by
Chadha-Singh Family Revocable Trust and Chadha
Current Estimated Value
$684,829

Purchase Details

Listed on
Sep 13, 2021
Closed on
Oct 15, 2021
Sold by
Dynamic Builders Llc
Bought by
Chadha Rohit and Singh Priyanka
Seller's Agent
Karla Hill, P.C.
Weichert, Realtors - First Tier
Buyer's Agent
Gary Meyer
Weichert, Realtors - House of
List Price
$689,900
Sold Price
$575,000
Premium/Discount to List
-$114,900
-16.65%

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.77%
Original Mortgage
$488,750
Interest Rate
2.8%
Mortgage Type
New Conventional

Purchase Details

Closed on
Oct 14, 2020
Sold by
The Columbia Development Group Llc
Bought by
Dynamic Builders Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$429,250
Interest Rate
2.9%
Mortgage Type
Construction
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
Chadha-Singh Family Revocable Trust -- None Listed On Document
Chadha-Singh Family Revocable Trust -- None Listed On Document
Chadha-Singh Family Revocable Trust -- None Listed On Document
Chadha Rohit -- Boone Central Title Company
Dynamic Builders Llc -- Boone Central Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Chadha Rohit $488,750
Previous Owner Dynamic Builders Llc $429,250
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
10/15/2021 10/15/21 Sold -- -- --
09/16/2021 09/16/21 Pending -- -- --
07/01/2021 07/01/21 For Sale $689,900 -- $215 / 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 $6,204 $91,960 $14,250 $77,710
2023 $6,153 $91,960 $14,250 $77,710
2022 $5,910 $88,426 $14,250 $74,176
2021 $1,911 $28,538 $14,250 $14,288
2020 $508 $7,125 $7,125 $0
2019 $508 $7,125 $7,125 $0
2018 $511 $0 $0 $0
2017 $505 $7,125 $7,125 $0
2016 $0 $0 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Columbia Board of REALTORS®

MLS Number: 401010

Columbia Board of REALTORS®

APN: 20-100-00-02-117-00-01