$750,000
$35K PRICE DROP

9747 South Route N Columbia, MO 65203

Estimated payment $4,246/month

Total Views 9,446
4 Beds
3 Baths
3,580 Sq Ft
$209 Price per Sq Ft

Highlights

  • Deck
  • Ranch Style House
  • No HOA
  • Ann Hawkins Gentry Middle School Rated A-
  • Partially Wooded Lot
  • Formal Dining Room

About This Home

Fully Renovated Stunner in Desirable Pierpont! This one has it all—style, space, and a location you'll love. Set on nearly 2 private acres in the coveted Pierpont area, you're just 2.5 miles from the Pierpont General Store—live music, great food, and local charm just minutes from your door.
Inside, the dream kitchen wows with high-end appliances, a show-stopping island, and sleek finishes. The cozy living room fireplace adds warmth and character, while the brand new back deck is perfect for relaxing & outdoor entertaining.
The main level features 4 spacious bedrooms and 3 full baths, including a luxurious primary suite with a spa-like bath—soaker tub, custom tile shower, and all the upgrades.
The lower level is made for fun with a guest bedroom, full bath, bar, and a huge rec room— of storage space to keep things tidy.
*Bonus: this home comes with a new septic drip system and HVAC for added peace of mind.
Private, polished, and perfectly located this move-in ready home is the total package. *

Listing Agent

Stacey Swalla

Weichert, Realtors - House of Brokers License #2007009542 Listed on: 04/18/2025

Co-Listing Agent

Savannah Chambers

Weichert, Realtors - House of Brokers License #2020041759

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,005

Year Built

  • Built in 1994

Lot Details

  • 1.99 Acre Lot
  • Southeast Facing Home
  • Cleared Lot
  • Partially Wooded Lot

Parking

  • 3 Car Attached Garage
  • Dirt Driveway

Home Design

  • Ranch Style House
  • Traditional Architecture
  • Brick Veneer
  • Concrete Foundation
  • Poured Concrete
  • Architectural Shingle Roof

Interior Spaces

  • Vinyl Clad Windows
  • Living Room with Fireplace
  • Formal Dining Room
  • Partially Finished Basement
  • Exterior Basement Entry
  • Eat-In Kitchen

Flooring

  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Bathroom on Main Level
  • 3 Full Bathrooms

Outdoor Features

  • Deck

Schools

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

Utilities

  • Central Air
  • Heating System Uses Propane
  • Municipal Utilities District Water
  • Septic Tank

Community Details

  • No Home Owners Association
  • Columbia Subdivision

Listing and Financial Details

  • Assessor Parcel Number 2060323000140101

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,005

Year Built

Built in 1994

Lot Details

0

Parking

3

Listing Details

  • Directions: Providence south to 163 past Rock Bridge State Park; take right at Pierpont General Store on Rte N, house on right side
  • Prop. Type: Residential
  • Bedroom 2 Level: Main
  • Dining Room Level: Main
  • Full Bathroom Level: Main
  • Kitchen Level: Main
  • Living Room Level: Main
  • Primary Bedroom Level: Main
  • Year Built: 1994
  • BathsFull34LowerLevel: 1
  • BathsFull34MainLevel: 2
  • BathsFull34Total: 3
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 1.99
  • Road Surface Type: Paved, Public Maintained
  • Co List Office Mls Id: 510000036
  • Subdivision Name: COLUMBIA
  • Above Grade Finished Sq Ft: 2393.0
  • Architectural Style: Ranch
  • Garage Type Attached: Yes
  • Cooling:Central Electric: Yes
  • Foundation Material:Poured Concrete: Yes
  • ArchStyle:Traditional: Yes
  • Deck:Back: Yes
  • TopoLot Description:Partially Wooded: Yes
  • Roof:ArchitecturalShingle: Yes
  • Utilities:Electric-County: Yes
  • Water District: Yes
  • Flooring:Tile: Yes
  • Rooms:Dining Room: Yes
  • Rooms:Living Room: Yes
  • Foundation Type:Full Bsmt Part Fin: Yes
  • Foundation Access:Outside Entrance: Yes
  • Dining:Eat-In Kitchen: Yes
  • Dining:Formal Dining: Yes
  • TopoLot Description:Cleared: Yes
  • Flooring:Vinyl3: Yes
  • Heat Fuel:Propane: Yes
  • Exterior Finish:Brick Veneer: Yes
  • Utilities:Sewage-Septic Tank: Yes
  • Special Features: None

Interior Features

  • Bedroom 3 Level: Main
  • Bedroom 4 Level: Lower
  • Flooring: Tile, Vinyl
  • Interior Amenities: Eat-in Kitchen, Formal Dining
  • Basement YN: Yes
  • Full Bathrooms: 3
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 1187.0
  • Fireplace Features: In Living Room
  • Fireplace: Yes
  • Living Area: 3580.0
  • Window Features: Windows-Vinyl
  • Fireplace:In Living Room: Yes

Exterior Features

  • Roof: ArchitecturalShingle
  • Lot Features: Cleared
  • Direction Faces: Southeast
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Deck
  • Exterior Features:Windows-Vinyl: Yes
  • Exterior Features:Driveway-DirtGravel: Yes

Garage/Parking

  • Garage Spaces: 3.0
  • Parking Features: Driveway-Dirt/Gravel, Attached
  • General Property Description:Garage Capacity: 3

Utilities

  • Utilities: Water-District, Electric-County, Sewage-Septic Tank
  • Cooling: Central Electric
  • Heating: Propane
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Association: No

Schools

  • Elementary School: Rock Bridge
  • 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: 86684.4
  • Parcel #: 2060323000140101
  • Zoning Description: R-1 One- Family Dwelling*

Tax Info

  • Tax Annual Amount: 3004.82
  • Tax Year: 2024

Map

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

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,005 $45,714 $3,116 $42,598
2024 $3,005 $41,553 $3,116 $38,437
2023 $2,979 $41,553 $3,116 $38,437
2022 $2,757 $38,475 $3,116 $35,359
2021 $2,761 $38,475 $3,116 $35,359
2020 $2,708 $35,623 $3,116 $32,507
2019 $2,708 $35,623 $3,116 $32,507
2018 $2,523 $0 $0 $0
2017 $2,495 $32,984 $3,116 $29,868
2016 $2,491 $32,984 $3,116 $29,868
2015 $2,300 $32,984 $3,116 $29,868
2014 -- $32,984 $3,116 $29,868
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
09/07/2025 09/07/25 Price Changed $750,000 -3.2% $209 / Sq Ft
06/19/2025 06/19/25 Price Changed $775,000 -1.3% $216 / Sq Ft
04/18/2025 04/18/25 For Sale $784,900 -- $219 / Sq Ft
Source: Columbia Board of REALTORS®

Purchase History

Date Type Sale Price Title Company
Warranty Deed -- None Listed On Document
Warranty Deed -- None Listed On Document
Interfamily Deed Transfer -- None Available
Warranty Deed -- Boone Central Title Co
Warranty Deed -- None Available
Warranty Deed -- None Available
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $600,000 Credit Line Revolving
Closed $600,000 Credit Line Revolving
Previous Owner $139,000 New Conventional
Previous Owner $145,000 New Conventional
Previous Owner $138,240 New Conventional
Source: Public Records

Source: Columbia Board of REALTORS®

MLS Number: 426174

Columbia Board of REALTORS®

APN: 20-603-23-00-014-01-01