1022 Queen Ann Dr, Columbia, MO, 65201
About This Home
Beautiful lakefront ranch in central Columbia with 3,620 finished sqft! Freshly painted with all-new flooring throughout. Main level features 3 bedrooms, 2 full baths, a large living room, spacious hearth room, and a sunroom with stunning lake views. The primary suite offers deck access, two closets, and a private bath with a tiled shower. Enjoy the expansive deck overlooking the lake—ideal for relaxing or entertaining while surrounded by nature and wildlife. The finished walkout lower level includes a full wet bar, family room, rec room, 2 additional bedrooms, a full bath, and tons of space to spread out. There's also 918 sqft of unfinished storage space. Prime location just minutes to Mizzou with nearby walking trails. A rare combination of space, setting, and convenience in town
Getting Around
Car-Dependent
Very Limited Transit
Somewhat BikeableSchools
Construction
Condition
- Year built: 1962
Materials
- Foundation: Concrete Perimeter
- Roof: ArchitecturalShingle
Type & Style
- Home type: SingleFamily
- Property subType: Single Family Residence
Interior
Appliances
- Appliances included: Microwave,Disposal,Dishwasher
- Laundry features: Washer/Dryer Hookup
Basement
- Has basement: Yes
- Basement: Walk-Out Access
Bedroom2
- Level: Main
- Area: 143.8656
- Dimensions: 10.16 x 14.16
Bedroom3
- Level: Main
- Area: 86.2025
- Dimensions: 8.41 x 10.25
Bedroom4
- Level: Lower
- Area: 178.7553
- Dimensions: 13.41 x 13.33
Bedroom5
- Level: Lower
- Area: 186.5331
- Dimensions: 13.41 x 13.91
Bedrooms & Bathrooms
- Bedrooms: 5
- Bathrooms: 3
- Full bathrooms: 3
Dining Room
- Level: Main
- Area: 93.5089
- Dimensions: 9.67 x 9.67
Family Room
- Level: Lower
- Area: 695.88
- Dimensions: 36 x 19.33
Features
- Stand AloneShwr/MBR,Walk-In Closet(s),Wet Bar,Breakfast Room,Formal Dining,Laminate Counters,Wood Cabinets
- Flooring: Laminate,Tile
- Fireplace features: Kitchen,Basement,Wood Burning,Screen
- Fireplace: Yes
- Finished area below ground: 1,613
Full Bathroom
- Level: Main
Full Bathroom
- Level: Main
Full Bathroom
- Level: Lower
Hearth Room
- Level: Main
- Area: 261.9172
- Dimensions: 13.67 x 19.16
Heating & Cooling
- Heating features: Heat Pump,Natural Gas
- Cooling features: Heat Pump,Central Electric
Interior Area
- Total structure area: 3,620
- Total interior livable area: 3,620 sqft
Kitchen
- Level: Main
- Area: 114.5625
- Dimensions: 11.75 x 9.75
Living Room
- Level: Main
- Area: 273.07
- Dimensions: 20.75 x 13.16
Master Bedroom
- Level: Main
- Area: 160.6514
- Dimensions: 13.58 x 11.83
Recreation Room
- Level: Lower
- Area: 272.685
- Dimensions: 20.58 x 13.25
Sunroom
- Level: Main
- Area: 286.8278
- Dimensions: 18.41 x 15.58
Property
Details
- Parcel number: 1741000050340001
- Zoning description: R-1 One- Family Dwelling*
Features
- Patio & porch: Covered,Back,Deck,Front Porch
- On waterfront: Yes
- Residential vegetation: Partially Wooded
Lot
- Lot size: 0.77 Acres
- Features: Level,Rolling Slope
- Lot size dimensions: 208.50 x 161 IRR
Parking
- Total spaces: 2
- Parking features: Attached,Paved
- Has garage: Yes
- Attached garage spaces: 2
- Covered spaces: 2
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
- Heat Wave
- Inland Flooding
- Ice Storm
- Lightning
- Strong Wind
- Tornado
- Winter Weather
- Cold Wave
- Earthquake
- Hail
How This Home’s Risks Compare
FEMA Declared Disasters Across Missouri Counties
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
| Monthly | Annual | |
|---|---|---|
| Mortgage | $2,654 | $31,848 |
| Home Insurance * | $292 | $3,504 |
| Property Taxes | $358 | $4,296 |
| Electricity | $276 | $3,317 |
| Total | $3,580 | $42,960 |
Income You'd Need if You Spent...
Missouri FAIR Plan Programs
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.
Comparing Against the Market
Price Per Sq Ft
vs Other Active Listings
Avg $/sqft
vs Homes Sold Last Month
Median $/sqft
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
| Date | Event | Price |
|---|---|---|
| 2026-03-25 | Price change | $524,900 |
| 2025-10-16 | Listed for sale | $559,000 |
| 2013-04-10 | Sold | -- |
| 2013-02-10 | Price change | $298,000 |
| 2012-08-23 | Listed for sale | $339,000 |
View on Zillow