Nestled along Missouri Route N, this secluded 10-acre retreat offers a sprawling ranch living space, around the bend from the Missouri River, just minutes from highly desirable Cooper's Landing, live music, the Katy Trail, and Pierpont Store. Inside, discover custom woodworking, a massive knotty pine kitchen with endless cabinetry and double ovens, an executive office with built-ins and a secret door, and two primary suites featuring large suite baths. The lower level boasts an entertainment area, wet bar, large bedrooms, massive storage, and wood stove backup. Previously set up for horses w pasture near the historic barn and silo. In need of a little TLC, this home is ready for your custom finishes. Offered strictly as-is and priced accordingly, a rare chance to create your dream estate!
As the MLS and public records start to fill up, we'll list the details here.
Public record
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
—
Year renovated
—
Finished Sq. Ft.
—
Unfinished Sq. Ft.
—
Total Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Boone County
APN
2090035000170001
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 25, 2026.
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
4/10 Heat Factor
7 days above 106° expected this year, 18 days in 30 years
2/10 Wind Factor
Minor risk of severe winds over next 30 years
1/10 Air Factor
0 unhealthy days expected this year, 0 days in 30 years
Provided by First Street
Historical weather
Columbia, MO • 65203
Average low and high temperatures (°F)
37
19
48
27
66
41
70
51
75
55
84
67
88
72
86
65
82
60
73
51
56
39
46
29
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
97/ 100
Exceptional sunlight
Sunscore
This home ranks in the top 26% for direct sun exposure in Columbia. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
10.2 hrs
6.7 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 12000 N Rte
$565,558
$16K over list price of $550K
Nearby comparable homes
The Redfin Estimate uses 5 recent nearby sales, priced between $250K to $680K.