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.
Pending
Price cut: $19K (5/7)
$670,000
9747 S Rte N, Columbia, MO 65203
4beds
3,428sqft
Single Family Residence
Built in 1994
1.99 Acres Lot
$651,400 Zestimate®
$195/sqft
$-- HOA
What's special
Cozy fireplaceBrand-new back deckDramatic islandGuest bedroomAbundant storageSleek modern finishesDream kitchen
- 71 days |
- 861 |
- 56 |
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
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: $195/sqft
- Tax assessed value: $240,600
- Annual tax amount: $3,214
- Date on market: 4/10/2026
Estimated market value
$651,400
$619,000 - $684,000
$3,256/mo
Price history
| Date | Event | Price |
|---|---|---|
| 6/11/2026 | Pending sale | $670,000$195/sqft |
Source:  CBORMLS #433803 Report a problem | ||
| 5/7/2026 | Price change | $670,000-2.8%$195/sqft |
Source: CBORMLS #433803 Report a problem | ||
| 4/10/2026 | Listed for sale | $689,000$201/sqft |
Source: CBORMLS #433803 Report a problem | ||
| 3/26/2026 | Listing removed | $689,000$201/sqft |
Source:  JCMLS #10072179 Report a problem | ||
| 3/9/2026 | Pending sale | $689,000$201/sqft |
Source: JCMLS #10072179 Report a problem | ||
| 2/25/2026 | Price change | $689,000-1.6%$201/sqft |
Source: JCMLS #10072179 Report a problem | ||
| 1/24/2026 | Listed for sale | $699,900$204/sqft |
Source: JCMLS #10072179 Report a problem | ||
| 1/21/2026 | Listing removed | $699,900$204/sqft |
Source: CBORMLS #426174 Report a problem | ||
| 11/11/2025 | Price change | $699,900-4.8%$204/sqft |
Source: CBORMLS #426174 Report a problem | ||
| 10/21/2025 | Price change | $735,000-2%$214/sqft |
Source: CBORMLS #426174 Report a problem | ||
| 9/7/2025 | Price change | $750,000-3.2%$219/sqft |
Source: CBORMLS #426174 Report a problem | ||
| 6/19/2025 | Price change | $775,000-1.3%$226/sqft |
Source: CBORMLS #426174 Report a problem | ||
| 4/18/2025 | Listed for sale | $784,900$229/sqft |
Source: JCMLS #10070008 Report a problem | ||
| 1/9/2015 | Sold | -- |
Source: CBORMLS #347235 Report a problem | ||
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$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
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
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Columbia Topics
