See other homes in:
Primary listing photo
Listing photo 2
Listing photo 3
Listing photo 4
Listing photo 5

841 S Rte #Uu, Columbia, MO, 65203

6beds
5baths
6,962sqft
$1,749,000
$251price/sqft
$11,535/moest. monthly cost
$461,400/yrincome needed

About This Home

Welcome to a truly special property--where timeless New England Shingle-style design meets thoughtful updates and modern comfort--all set on a private 10.78-acre setting in Columbia, MO. This 6-bedroom, 4.5-bath home has just undergone an extensive refresh, including beautifully remodeled bathrooms, new paint, updated flooring, and exterior improvements, giving it a fresh, move-in-ready feel while preserving its original craftsmanship and character. Built by the current owner, the home reflects careful planning and attention to detail throughout. Rich mahogany-stained custom woodwork creates a warm, inviting atmosphere, while the updated finishes bring a clean, elevated look to the living spaces. The kitchen remains a standout feature with granite countertops, custom solid mahogany cabinetry, and GE Monogram appliances--blending function and style for everyday living and entertaining. The setting is just as impressive as the home itself. A private lake anchors the property, surrounded by a mix of wooded areas and open space, offering both beauty and usability. The inground pool--complete with chiller, heater, and UV filter--extends your outdoor enjoyment across the seasons, while the expansive deck provides the perfect place to take it all in. Inside, you'll find multiple spaces designed for both relaxation and entertaining, including a lower-level wine room, three wood-burning fireplaces, and a full interior and exterior speaker system. High-end finishes like imported travertine tile and organic barnwood hickory flooring tie everything together, creating a balance of comfort and luxury. From the paved driveway to the classic shingle-style exterior, every detail has been carefully considered. With its recent updates, private setting, and unique design, this is a rare opportunity to own a property that offers both character and modern livability just minutes from Columbia.

Getting Around

0
WalkingCar-Dependent
0
TransitVery Limited Transit
2
BikeSomewhat Bikeable

Schools

5/10
Smithton Middle SchoolGrades 6-83.0 mi
7/10
David H. Hickman High SchoolGrades PK,9-126.0 mi

Construction

Condition

  • Year built: 1990

Materials

  • Foundation: Concrete Perimeter
  • Roof: ArchitecturalShingle

Other

  • Builder name: Smarr

Type & Style

  • Home type: SingleFamily
  • Property subType: Single Family Residence

Interior

Appliances

  • Appliances included: Refrigerator,Disposal,Dishwasher
  • Laundry features: Washer/Dryer Hookup

Basement

  • Has basement: Yes
  • Basement: Walk-Out Access

Bedrooms & Bathrooms

  • Bedrooms: 6
  • Bathrooms: 5
  • Full bathrooms: 5

Features

  • Split Bedroom Design,Wired for Sound,Walk-In Closet(s),Bar,Wet Bar,Cedar Closet(s),Formal Dining,Cabinets-Custom Blt,Wood Cabinets,Kitchen Island,Quartz Counters
  • Window features: Some Window Treatments
  • Flooring: Wood,Carpet,Tile
  • Fireplace features: Living Room,Family Room,Wood Burning,Recreation Room
  • Fireplace: Yes
  • Finished area below ground: 1,680

Full Bathroom

  • Level: Main

Full Bathroom

  • Level: Main

Full Bathroom

  • Level: Upper

Full Bathroom

  • Level: Upper

Full Bathroom

  • Level: Lower

Heating & Cooling

  • Heating features: Heat Pump,Forced Air,Propane
  • Cooling features: Heat Pump,Central Electric

Interior Area

  • Total structure area: 6,962
  • Total interior livable area: 6,962 sqft

Property

Details

  • Parcel number: 1560013000010301
  • Zoning description: R-S Single Family Residential

Features

  • Patio & porch: Deck
  • Exterior features: Balcony
  • On waterfront: Yes
  • Residential vegetation: Partially Wooded

Lot

  • Lot size: 10.78 Acres
  • Features: Cleared,Rolling Slope

Parking

  • Total spaces: 3
  • Parking features: Attached,Paved
  • Has garage: Yes
  • Attached garage spaces: 3
  • Covered spaces: 3

Climate Risk is Financial Risk

Every home has a financial story beyond the listing price. Below, you’ll see the climate risks that could affect this property — and in Bills & Affordability, how those risks may influence repairs, insurance, utilities, and long-term value.

Biggest Threats for This Home

  • Lightning
    LightningRelatively High
  • Tornado
    TornadoRelatively High
  • Winter Weather
    Winter WeatherRelatively High
  • Cold Wave
    Cold WaveModerate
  • Heat Wave
    Heat WaveModerate
  • Inland Flooding
    Inland FloodingModerate
  • Ice Storm
    Ice StormModerate
  • Strong Wind
    Strong WindModerate

How This Home’s Risks Compare

Lightning
Tornado
Winter Weather
Cold Wave
Heat Wave
Inland Flooding
Ice Storm
Strong Wind

FEMA Declared Disasters Across Missouri Counties

Flood

Understanding the Costs

Financial advisors generally recommend spending no more than 30% of your gross household income on housing costs. In practice, many households stretch to 35% or beyond — especially in high-cost markets.

Estimated Costs Today

MonthlyAnnual
Mortgage $8,843$106,116
Home Insurance *$966$11,592
Property Taxes $1,195$14,340
Electricity $531$6,379
Total$11,535$138,420
*Does not include cost of any FAIR Plan premiums

Income You'd Need if You Spent...

35% on housing$395,485/yr
40% on housing$346,050/yr
45% on housing$307,600/yr

Missouri FAIR Plan Programs

Missouri Property Insurance Placement Facility

Covered
WildfireWildfire
HailHail
WindWind
Visit Website →
Current Policies
Residential: 2,041Commercial: 84
Total Premiums$2.35M
Total Exposure$198.26M

How Costs Could Change Over Time

Climate risk is quickly impacting all of the major home ownership costs. Adjust the growth rates and percentage of income spent on housing below to see how your housing costs could change over the next 10 years — and what income you'd need to keep up.

Insurance Growth Rate5-year average: 8.9%
8.9%
0%30.0%
Electricity Growth Rate10-year average: 2.9%
2.9%
0%15.0%
Property Taxes Growth Rate2-year average: 1.2%
1.2%
0%15.0%
Income Spent on Housing
30%
30%45%

Comparing Against the Market

Price Per Sq Ft

$251This listing

vs Other Active Listings

Avg $/sqft

ZIP 65203$190
Boone County$189

vs Homes Sold Last Month

Median $/sqft

ZIP 65203$174
Boone County$175

Current Market Trends

Median Price Per Square Foot

The median price per square foot of homes sold in this area each month. Compare this to this listing's price per square foot to gauge whether the home is priced in line with recent sales.

Historicals for This Listing

Zestimate History ($/sqft)

Price History

DateEventPrice
2026-04-04Listed for sale$1,860,000
2025-11-07Listing removed$1,870,000
2025-05-04Listed for sale$1,870,000
2025-05-01Listing removed$1,870,000
2025-04-06Price change$1,870,000
2025-03-05Listed for sale$1,945,000
2025-02-11Listing removed$1,945,000
2024-08-01Listed for sale$1,945,000

For Sale by Agent

AgentRyan Cunningham
BrokerageIron Gate Real Estate

Similar Homes