Private, polished, and perfectly located, this move in ready home delivers the full package. With a NEW ROOF, SEPTIC DRIP SYSTEM and HVAC, this home blends style, comfort, and peace of mind. Inside, the dream kitchen impresses with high end appliances, a dramatic island, and sleek modern finishes. The living room's cozy fireplace adds warmth and character, while the brand-new back deck creates the ideal space for relaxing or entertaining. The main level offers 3 spacious bedrooms and 2 full baths, including a luxurious primary suite with a spa inspired bath featuring a soaking tub and custom tile shower.
The lower level is built for fun with a guest bedroom, full bath, bar, and an expansive rec room with abundant storage. With a new roof, septic drip system and HVAC, this home blends style, comfort, and peace of mind.
Set on nearly 2 private acres in the coveted Pierpont area, you're just 2.5 miles from the beloved Pierpont General Store--live music, great food, and small town charm minutes from your door.
For sale
$689,000
9747 S Rte N, Columbia, MO 65203
4beds
3,428sqft
Est.:
Single Family Residence
Built in 1994
1.99 Acres Lot
$666,400 Zestimate®
$201/sqft
$-- HOA
What's special
Cozy fireplaceBrand-new back deckDramatic islandGuest bedroomAbundant storageSleek modern finishesDream kitchen
- 21 days |
- 1,432 |
- 95 |
Zillow last checked:
Listing updated:
Listed by:
Stacey Swalla 573-999-5583,
Weichert, Realtors - House of Brokers 573-446-6767,
Scott Jones 573-446-6767,
Weichert, Realtors - House of Brokers
Source: CBORMLS,MLS#: 433803
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 3
Primary bedroom
- Level: Main
- Area: 255
- Dimensions: 17 x 15
Bedroom 2
- Level: Main
- Area: 141.45
- Dimensions: 12.3 x 11.5
Bedroom 3
- Level: Main
- Area: 168.64
- Dimensions: 12.4 x 13.6
Bedroom 4
- Level: Lower
- Area: 156
- Dimensions: 13 x 12
Full bathroom
- Level: Main
- Area: 229.6
- Dimensions: 16.4 x 14
Full bathroom
- Level: Main
Full bathroom
- Level: Lower
Dining room
- Level: Main
- Area: 196.56
- Dimensions: 15.6 x 12.6
Kitchen
- Level: Main
- Area: 323
- Dimensions: 17 x 19
Living room
- Level: Main
- Area: 237.5
- Dimensions: 19 x 12.5
Heating
- Forced Air, Propane
Cooling
- Central Electric, Attic Fan
Appliances
- Laundry: Washer/Dryer Hookup, Additional Laundry Hookup(s)
Features
- High Speed Internet, Tub/Shower, Stand AloneShwr/MBR, Split Bedroom Design, Walk-In Closet(s), Eat-in Kitchen, Formal Dining
- Flooring: Carpet, Tile, Vinyl
- Basement: Walk-Out Access
- Has fireplace: Yes
- Fireplace features: Living Room, Gas
Interior area
- Total structure area: 3,428
- Total interior livable area: 3,428 sqft
- Finished area below ground: 1,200
Property
Parking
- Total spaces: 3
- Parking features: Attached
- Attached garage spaces: 3
Features
- Patio & porch: Deck
Lot
- Size: 1.99 Acres
- Features: Rolling Slope
Details
- Parcel number: 2060323000140101
- Zoning description: R-S Single Family Residential
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Foundation: Concrete Perimeter
- Roof: ArchitecturalShingle
Condition
- Year built: 1994
Utilities & green energy
- Gas: Propane Tank Owned
- Utilities for property: Trash-Private
Community & HOA
Community
- Subdivision: Columbia
HOA
- Has HOA: No
Location
- Region: Columbia
Financial & listing details
- Price per square foot: $201/sqft
- Tax assessed value: $240,600
- Annual tax amount: $3,214
- Date on market: 4/10/2026
Estimated market value
$666,400
$633,000 - $700,000
$3,629/mo
Price history
| Date | Event | Price |
|---|---|---|
| 4/10/2026 | Listed for sale | $689,000$201/sqft |
Source: | ||
| 3/26/2026 | Listing removed | $689,000$201/sqft |
Source: | ||
| 3/9/2026 | Pending sale | $689,000$201/sqft |
Source: | ||
| 2/25/2026 | Price change | $689,000-1.6%$201/sqft |
Source: | ||
| 1/24/2026 | Listed for sale | $699,900$204/sqft |
Source: | ||
| 1/21/2026 | Listing removed | $699,900$204/sqft |
Source: | ||
| 11/11/2025 | Price change | $699,900-4.8%$204/sqft |
Source: | ||
| 10/21/2025 | Price change | $735,000-2%$214/sqft |
Source: | ||
| 9/7/2025 | Price change | $750,000-3.2%$219/sqft |
Source: | ||
| 6/19/2025 | Price change | $775,000-1.3%$226/sqft |
Source: | ||
| 4/18/2025 | Listed for sale | $784,900$229/sqft |
Source: | ||
| 1/9/2015 | Sold | -- |
Source: | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $45,714 +10% |
| 2024 | $3,005 +0.9% | $41,553 |
| 2023 | $2,979 +8.1% | $41,553 +8% |
| 2022 | $2,757 -0.2% | $38,475 |
| 2021 | $2,761 +1.9% | $38,475 +8% |
| 2020 | $2,708 0% | $35,623 |
| 2019 | $2,708 +7.3% | $35,623 +8% |
| 2018 | $2,523 +1.2% | $32,984 |
| 2017 | $2,495 +0.2% | $32,984 |
| 2016 | $2,491 | $32,984 |
| 2015 | $2,491 +8.3% | $32,984 |
| 2014 | $2,300 | $32,984 |
| 2013 | -- | $32,984 |
| 2012 | -- | $32,984 |
| 2011 | -- | $32,984 |
| 2010 | -- | $32,984 |
| 2009 | -- | $32,984 |
| 2008 | -- | $32,984 |
| 2007 | -- | -- |
| 2003 | -- | $28,690 |
| 2002 | -- | $28,690 |
| 2001 | -- | $28,690 |
Find assessor info on the county website
Monthly payment
Est. payment
$3,814/mo
Principal & interest
$3349
Property taxes
$465
More affordability tools
Climate risks
Neighborhood: 65203
Nearby schools
GreatSchools rating
- 8/10Rock Bridge Elementary SchoolGrades: PK-5Distance: 3.8 mi
- 7/10Ann Hawkins Gentry Middle SchoolGrades: 6-8Distance: 4.7 mi
- 9/10Rock Bridge Senior High SchoolGrades: 9-12Distance: 4.5 mi
Schools provided by the listing agent
- Elementary: Rock Bridge
- Middle: Gentry
- High: Rock Bridge
Source: CBORMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
- Missouri
- Boone County
- Columbia
- 65203
- 9747 S Rte N



