9747 S RTE N, COLUMBIA, MO 65203
$699,900
Property Type:
Residential
Bedrooms:
4
Baths:
3
Square Footage:
3,580
Lot Size (sq. ft.):
86,684
Status:
Active
Current Price:
$699,900
List Date:
4/18/2025
Last Modified:
1/05/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 roo
Supplements: of 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. * SELLER WILL CONSIDER A TRADE OR LEASE PURCHASE OPTION.
More Information MLS# 426174
General Property Description
Attached/Detached: Detached
# of Baths-Half: 0
Primary Style: Ranch
Garage Capacity: 3
Sq Ft Source: Appraiser
# of Acres: 1.99
Age Description: 31-40 Yrs
Appx Fin Sq Ft Main #: 2393
Appx Fin Sq Ft Lower #: 1187
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 #: 1186
Appx UnFin Sq Ft Upper #: 0
Appx UnFin Other Sq Ft #: 0
Appx UnFin Sq Ft Total #: 1186
House Faces: SE
Type: Single Family Residence
# of Bedrooms: 4
Baths Full: 3
Total Bathrooms: 3
Appx Fin Sq Ft Total #: 3580
Year Built: 1994
Location Tax & Legal
Cross Street: Stanley Poe
Zoning: Single Family Res
Actual Taxes $: 3004.82
Tax Yr: 2024
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 1A SUR 2353-83
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 right at Pierpont General Store on Rte N, house on right side
Status Change Info
List Price/Sqft: 195.5
Status: Active
Status Change Date: 2025-12-31
Licensee Per/Int Dis
Not Applicable: 1
Columbia Pub Schools
Elementary School 2025/2026: Rock Bridge
Middle School 2025/2026: Gentry
High School 2025/2026: Rock Bridge
Rooms
Bedroom 2: 1
Bedroom 2 Level: Main
Bedroom 3: 1
Bedroom 3 Level: Main
Bedroom 4: 1
Bedroom 4 Level: Lower
Dining Room: 1
Dining Room Level: Main
Full Bathroom: 1
Full Bathroom Level: Main
Kitchen: 1
Kitchen Level: Main
Living Room: 1
Living Room Level: Main
Master Bedroom: 1
Master Bedroom Level: Main
Property Disclosure
Property Disclosure To Be Provided: No
Foundation Type
Full Bsmt Part Fin: 1
Cooling
Central Electric: 1
Exterior Finish
Brick Veneer: 1
Wood Product: 1
Road Responsibility
Public Maintained Road: 1
Road Surface Type
Paved: 1
Foundation Access
Outside Entrance: 1
Possession
At Closing: 1
Heating
Propane: 1
Foundation Material
Poured Concrete: 1
Restriction/Easement
Recorded Plat: 1
Arch./Style
Traditional: 1
Deck
Back: 1
Dining
Eat-In Kitchen: 1
Formal Dining: 1
Topo/Lot Description
Cleared: 1
Partially Wooded: 1
Exterior Features
Driveway-Dirt/Gravel: 1
Windows-Vinyl: 1
Roof
ArchitecturalShingle: 1
Utilities
Electric-Boone County Electric: 1
Sewage-Septic Tank: 1
Water-District: 1
Fireplace
In Living Room: 1
Zoning
R-1 One- Family Dwelling*: 1
Flooring
Tile: 1
Vinyl: 1
Baths Full-3/4
Lower Level: 1
Main Level: 2
Total: 3
Contract Information
Current Price: $699,900
List Date: 2025-04-04
List Price: $699,900
Location, Tax & Legal
Area: Boone Southwest
Street No #: 9747
Street Direction: S
Street: RTE N
County: Boone
State/Province: MO
Zip Code: 65203
Subdivision: COLUMBIA
Mapping ID #: 2060323000140101
Property Features
Road Responsibility: Public Maintained Road
Road Surface Type: Paved
Foundation Type: Full Bsmt Part Fin
Cooling: Central Electric
Deck: Back
Dining: Eat-In Kitchen; Formal Dining
Exterior Features: Driveway-Dirt/Gravel; Windows-Vinyl
Exterior Finish: Brick Veneer; Wood Product
Fireplace: In Living Room
Flooring: Tile; Vinyl
Foundation Access: Outside Entrance
Foundation Material: Poured Concrete
Heating: Propane
Possession: At Closing
Roof: ArchitecturalShingle
Rooms: Bedroom 2; Bedroom 3; Bedroom 4; Dining Room; Full Bathroom; Kitchen; Living Room; Master Bedroom
Utilities: Electric-Boone County Electric; Sewage-Septic Tank; Water-District
Zoning: R-1 One- Family Dwelling*
Room Information
Full Bathroom
Level: Main
Length: 16.40
Length: 16.40
Width: 14.00
Width: 14.00
Remarks: Master Bath
Full Bathroom
Level: Main
Full Bathroom
Level: Lower
Master Bedroom
Level: Main
Length: 17.00
Length: 17.00
Width: 15.00
Width: 15.00
Bedroom 2
Level: Main
Length: 12.30
Length: 12.30
Width: 11.50
Width: 11.50
Bedroom 3
Level: Main
Length: 12.40
Length: 12.40
Width: 13.60
Width: 13.60
Bedroom 4
Level: Lower
Length: 13.00
Length: 13.00
Width: 12.00
Width: 12.00
Dining Room
Level: Main
Length: 15.60
Length: 15.60
Width: 12.60
Width: 12.60
Living Room
Level: Main
Length: 19.00
Length: 19.00
Width: 12.50
Width: 12.50
Kitchen
Level: Main
Length: 17.00
Length: 17.00
Width: 19.00
Width: 19.00
Listing Office:
Weichert, Realtors - House of Brokers
Listing Agent:
Stacey Swalla
Last Updated: January - 05 - 2026
Information deemed reliable but not guaranteed.
