9747 N RTE N, COLUMBIA, MO 65203
New Listing
$699,000
Property Type:
Residential
Bedrooms:
4
Baths:
3
Square Footage:
3,428
Lot Size (sq. ft.):
86,684
Status:
Active
Current Price:
$699,000
List Date:
1/24/2026
Last Modified:
1/27/2026
Description
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.
Supplements: *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.
More Information MLS# 431909
General Property Description
# of Bedrooms Above Grade: 3
Attached/Detached: Detached
# of Baths-Half: 0
Primary Style: Ranch
Garage Capacity: 3
Sq Ft Source: County Records
# of Acres: 1.99
Age Description: 31-40 Yrs
Appx Fin Sq Ft Main #: 2228
Appx Fin Sq Ft Lower #: 1200
Appx Fin Sq Ft Upper #: 0
Appx Fin Other Sq Ft #: 0
Basement: Yes
Appx UnFin Sq Ft Main #: 0
Appx UnFin Sq Ft Lower #: 0
Appx UnFin Sq Ft Upper #: 0
Appx UnFin Other Sq Ft #: 0
Appx UnFin Sq Ft Total #: 0
Type: Single Family Residence
# of Bedrooms: 4
Baths Full: 3
Total Bathrooms: 3
Appx Fin Sq Ft Total #: 3428
Year Built: 1994
Location Tax & Legal
Cross Street: Stanley Poe
Zoning: Single Family Res
School District: Columbia
Elementary Sch: Rock Bridge
Middle/Jr High Sch: Gentry
Senior Sch: Rock Bridge
HOA/Condo: No
Legal Description: PT SE SE (TR 1 SUR 406-971) (TR 1A SUR 2353-83) BENEFICIARY DEED
Auction: No
Land Lease: No
Land Lease Descrip: N/A
Located within City of Columbia: No
Remarks & Misc
Directions: Providence south to 163 past Rock Bridge State Park; take a right at Pierpoint General Store on Rte N house is on the right side
Status Change Info
List Price/Sqft: 203.91
Status: Active
Status Change Date: 2026-01-23
Licensee Per/Int Dis
Not Applicable: 1
Rooms
Full Bathroom: 1
Full Bathroom Level: Main
Property Disclosure
Property Disclosure To Be Provided: No
Foundation Type
Part Bsmt Part Fin: 1
Walkout Basement: 1
Foundation Access
Walkout: 1
Foundation Material
Poured Concrete: 1
Cooling
Central Electric: 1
Heating
Forced Air: 1
Arch./Style
Traditional: 1
Exterior Features
Windows-Vinyl: 1
Deck
Back: 1
Dining
Formal Dining: 1
Kit/Din Combo: 1
Energy Audit
Energy Audit Completed: No
Fireplace
In Living Room: 1
Flooring
Vinyl: 1
Contract Information
Current Price: $699,000
List Date: 2026-01-23
List Price: $699,000
Location, Tax & Legal
Street No #: 9747
Street Direction: N
Street: RTE N
County: Boone
State/Province: MO
Zip Code: 65203
Subdivision: COLUMBIA
Mapping ID #: 2060323000140101
Property Features
Foundation Type: Part Bsmt Part Fin; Walkout Basement
Cooling: Central Electric
Deck: Back
Dining: Formal Dining; Kit/Din Combo
Exterior Features: Windows-Vinyl
Fireplace: In Living Room
Flooring: Vinyl
Foundation Access: Walkout
Foundation Material: Poured Concrete
Heating: Forced Air
Rooms: Full Bathroom
Room Information
Full Bathroom
Level: Main
Full Bathroom
Level: Main
Full Bathroom
Level: Main
Listing Office:
Weichert, Realtors - House of Brokers
Listing Agent:
Stacey Swalla
Co Listing Agent: Scott Jones
Last Updated: January - 27 - 2026
Information deemed reliable but not guaranteed.