Skip main navigation
Off market
  • $613,200

    5515 Fremont Ct, Columbia, MO 65203

    5beds
    2,829sqft
    Single Family Residence
    Built in 2020
    0.48 Acres Lot
    $613,200 Zestimate®
    $217/sqft
    $3,115 Estimated rent

    Home value

    $613,200

    $583,000 - $644,000

    $3,115/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $3,115/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $3,115/mo

    Rent Zestimate®

    Refinance and save

    $3,781/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $3,781/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Experience the feel of a custom-built home in this thoughtfully designed property located in Steeplechase Estates. Tucked away on a quiet cul-de-sac, this 5-bedroom ranch walk-out offers a functional layout ideal for both everyday living and entertaining. Situated on over half an acre, the oversized lot provides plenty of outdoor space, with a neighborhood pool just a short walk away. Inside you'll find a well-appointed kitchen and a lower-level bar perfect for hosting. Additional features include high-end finishes throughout, a split-bedroom design for added privacy, and a covered deck with beautiful lake views and stunning sunsets.

    This property is not currently displayed as for sale or rent on Zillow. This may be different from what's on other websites or public sources.

    Zillow last checked:

    Listing updated:

    Source: Zillow Rentals

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 3
    • Full bathrooms: 3
    Heating
    • Heat Pump
    Cooling
    • Central Air
    Appliances
    • Included: Dishwasher, Dryer, Freezer, Microwave, Oven, Refrigerator, Washer
    • Laundry: In Unit
    Features
    • Flooring: Carpet, Hardwood
    • Furnished: Yes
    Interior area
    • Total interior livable area: 2,829 sqft

    Property

    Parking
    • Parking features: Attached
    • Has attached garage: Yes
    • Details: Contact manager
    Lot
    • Size: 0.48 Acres
    Details
    • Parcel number: 2010000021210001

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence
    Materials
    • Stone
    Condition
    • Year built: 2020

    Community & HOA

    Community
    • Deposit fee: $3,100
    Location
    • Region: Columbia

    Financial & listing details

    • Price per square foot: $217/sqft
    • Tax assessed value: $454,900
    • Date on market: 6/7/2026
    • Date available: 06/30/2026
    • Lease term: 1 Year

    Price history

    DateEventPrice
    8/26/2026Listing removed$625,000$221/sqft
    Source: JCMLS #10073329 Report a problem
    7/28/2026Listed for sale$625,000$221/sqft
    Source: MMBOR #435213 Report a problem
    7/12/2026Pending sale$625,000$221/sqft
    Source: MMBOR #435213 Report a problem
    7/6/2026Listing removed$3,100$1/sqft
    Source: Zillow Rentals Report a problem
    6/7/2026Listed for rent$3,100$1/sqft
    Source: Zillow Rentals Report a problem
    5/31/2026Price change$625,000-2.3%$221/sqft
    Source: MMBOR #433956 Report a problem
    4/28/2026Listed for sale$640,000$226/sqft
    Source: MMBOR #433956 Report a problem
    4/20/2026Pending sale$640,000$226/sqft
    Source: MMBOR #433956 Report a problem
    4/17/2026Listed for sale$640,000+13.3%$226/sqft
    Source: MMBOR #433956 Report a problem
    7/20/2023Sold--
    Source: MMBOR #413973 Report a problem
    6/2/2023Listed for sale$565,000$200/sqft
    Source: MMBOR #413973 Report a problem
    7/9/2020Sold--
    Source: Agent Provided Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025-- $86,431 +14.5%
    2024$5,093 +0.8%$75,487
    2023$5,050 +4.1%$75,487 +4%
    2022$4,851 -0.2%$72,580
    2021$4,860 +349.8%$72,580 +378.7%
    2020$1,080 +100%$15,162 +100%
    2019$540 -0.7%$7,581
    2018$544 +1.2%$7,581
    2017$537 $7,581
    2016-- --
    Find assessor info on the county website

    Neighborhood: 65203

    Nearby schools

    GreatSchools rating
    Sell for more on Zillow
    Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
    $613,200
    2% more
    +$12,264
    With Zillow Showcase(estimated)
    $625,464
    Sell for more on Zillow
    Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
    $613,200
    2% more
    +$12,264
    With Zillow Showcase(estimated)
    $625,464