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 of storage space. *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,000
9747 N Rte N, Columbia, MO 65203
4beds
3,428sqft
Est.:
Single Family Residence
Built in 1994
1.99 Acres Lot
$-- Zestimate®
$204/sqft
$-- HOA
What's special
Brand-new back deckShow-stopping islandPlenty of storage spaceGuest bedroomSleek finishesDream kitchenAll the upgrades
- 1 day |
- 376 |
- 24 |
Zillow last checked: 8 hours ago
Listing updated: January 23, 2026 at 05:33pm
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#: 431909
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 3
Full bathroom
- Level: Main
Full bathroom
- Level: Main
Full bathroom
- Level: Main
Heating
- Forced Air
Cooling
- Central Electric
Features
- Formal Dining, Kit/Din Combo
- Flooring: Vinyl
- Basement: Walk-Out Access
- Has fireplace: Yes
- Fireplace features: Living Room
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
Details
- Parcel number: 2060323000140101
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Foundation: Concrete Perimeter
Condition
- Year built: 1994
Community & HOA
Community
- Subdivision: Columbia
HOA
- Has HOA: No
Location
- Region: Columbia
Financial & listing details
- Price per square foot: $204/sqft
- Date on market: 1/24/2026
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 1/24/2026 | Listed for sale | $699,000$204/sqft |
Source: | ||
Public tax history
Public tax history
Tax history is unavailable.BuyAbility℠ payment
Est. payment
$4,110/mo
Principal & interest
$3393
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
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.




