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 & plenty f 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.
For sale
$699,900
9747 S Rte N, Columbia, MO 65203
8beds
3,428sqft
Est.:
Single Family Residence
Built in 1994
1.99 Acres Lot
$-- Zestimate®
$204/sqft
$-- HOA
What's special
- 17 days |
- 877 |
- 28 |
Zillow last checked: 8 hours ago
Listing updated: January 26, 2026 at 12:06pm
Listed by:
Stacey Swalla 573-999-5583,
Weichert, Realtors - House of Brokers
Source: JCMLS,MLS#: 10072179
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 8
- Bathrooms: 6
- Full bathrooms: 6
Laundry
- Level: Main
Heating
- Has Heating (Unspecified Type)
Cooling
- Central Air
Appliances
- Included: Dishwasher, Refrigerator
Features
- Basement: Walk-Out Access,Full
Interior area
- Total structure area: 3,428
- Total interior livable area: 3,428 sqft
- Finished area above ground: 3,428
- Finished area below ground: 1,200
Property
Parking
- Details: Main
Lot
- Size: 1.99 Acres
Details
- Parcel number: 2060323000140101
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Brick, Wood Siding
Condition
- Year built: 1994
Utilities & green energy
- Sewer: Septic Tank
- Water: Public
Community & HOA
Community
- Subdivision: COLUMBIA
Location
- Region: Columbia
Financial & listing details
- Price per square foot: $204/sqft
- Tax assessed value: $240,600
- Date on market: 1/24/2026
Estimated market value
Not available
Estimated sales range
Not available
$2,923/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 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: | ||
Public tax history
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% |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$4,106/mo
Principal & interest
$3389
Property taxes
$472
Home insurance
$245
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
- Loading
- Loading





