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!
For sale
$550,000
12000 N Rye Way, Columbia, MO 65202
5beds
3,889sqft
Single Family Residence
Built in ----
10.09 Acres Lot
$-- Zestimate®
$141/sqft
$-- HOA
What's special
Massive storageSprawling ranch living spaceLarge bedroomsWet barEntertainment areaDouble ovensEndless cabinetry
- 1 day |
- 489 |
- 21 |
Zillow last checked:
Listing updated:
Listed by:
David W Ursery 573-447-4300,
CoMo Realty 573-447-4300,
Alison Sherman 573-691-7630,
CoMo Realty
Source: MMBOR,MLS#: 436607
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Full bathroom
- Level: Main
Full bathroom
- Level: Main
Full bathroom
- Level: Lower
Half bathroom
- Level: Main
Cooling
- Central Electric
Appliances
- Included: Refrigerator, Microwave, Dishwasher
Features
- Breakfast Room, Eat-in Kitchen, Formal Dining, Kit/Din Combo, Cabinets-Custom Blt, Granite Counters, Wood Cabinets, Kitchen Island
- Flooring: Wood, Carpet, Tile
- Has basement: Yes
- Has fireplace: Yes
- Fireplace features: Basement, Free Standing, Wood Burning
Interior area
- Total structure area: 3,889
- Total interior livable area: 3,889 sqft
- Finished area below ground: 1,280
Property
Parking
- Total spaces: 2
- Parking features: Attached
- Attached garage spaces: 2
- Has uncovered spaces: Yes
Features
- Patio & porch: Covered, Concrete, Back, Front Porch
- Fencing: Partial,Privacy,Barbed Wire,Wood
Lot
- Size: 10.09 Acres
Details
- Parcel number: 2090035000170001
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Foundation: Concrete Perimeter
Community & HOA
Community
- Subdivision: Columbia
HOA
- Has HOA: No
Location
- Region: Columbia
Financial & listing details
- Price per square foot: $141/sqft
- Annual tax amount: $4,048
- Date on market: 8/14/2026
Estimated market value
Zestimate®
Not available
Estimated sales range
Not available
Rent Zestimate®
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 8/14/2026 | Listed for sale | $550,000$141/sqft |
Source: | ||
Public tax history
Tax history is unavailable.
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 65202
Getting around
Nearby schools
GreatSchools rating
- 8/10Rock Bridge Elementary SchoolGrades: PK-5Distance: 5.8 mi
- 7/10Ann Hawkins Gentry Middle SchoolGrades: 6-8Distance: 6.6 mi
- 9/10Rock Bridge Senior High SchoolGrades: 9-12Distance: 6.4 mi
Schools provided by the listing agent
- Elementary: Rock Bridge
- Middle: Gentry
- High: Rock Bridge
Source: MMBOR. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- $476,5005 bd3 ba-- sqft12000 S Route N #B, Columbia, MO 65203Off Market
Save - $540,2005 bd3 ba2.4k sqft12000 S Route N, Columbia, MO 65203Off Market
Save - $592,8005 bd3 ba3.8k sqft12000 S Rte N, Columbia, MO 65201Off Market
Save - $352,600-- bd-- ba-- sqftS Rte N, Columbia, MO 65203Off Market
Save - $659,8004 bd3 ba2.7k sqft11930 S Rte N, Columbia, MO 65201Off Market
Save - $212,600-- bd-- ba-- sqft11800 S Rte N, Columbia, MO 65201Off Market
Save - $629,0003 bd4 ba2.6k sqft11970 S Rte N, Columbia, MO 65201Pending
Save - $603,3003 bd4 ba2.6k sqft11970 S Route N, Columbia, MO 65203Off Market
Save
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.



