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

1704 Brookfield Mnr, Columbia, MO, 65203

5beds
3baths
4,464sqft
$689,900
$155price/sqft
$4,680/moest. monthly cost
$187,200/yrincome needed

About This Home

PRICE IMPROVEMENT! Look no further than this beautifully designed ranch in Heritage Estates. Built for entertaining, this standout home offers an inviting layout and exceptional space inside and out. The main level features 3 bedrooms & 2 baths, formal dining, a formal living room, a cozy hearth room with fireplace, and a 3-seasons room just off the kitchen. The oversized primary suite includes a spacious bathroom and walk-in closet. Downstairs, the open layout is perfect for hosting with room for a pool table, gatherings around the wet bar, 2 additional bedrooms, a full bath, and a non-conforming bedroom or private home office with exterior access. Outside, the low-maintenance deck and beautiful lot make this SW Columbia home truly stand out!

Getting Around

4
WalkingCar-Dependent
0
TransitVery Limited Transit
20
BikeSomewhat Bikeable

Schools

10/10
9/10
9/10

Construction

Condition

  • Year built: 2001

Materials

  • Foundation: Concrete Perimeter
  • Roof: ArchitecturalShingle

Type & Style

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

Interior

Appliances

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

Basement

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

Bedroom2

  • Level: Main
  • Area: 150.0625
  • Dimensions: 12.25 x 12.25

Bedroom3

  • Level: Main
  • Area: 159.045
  • Dimensions: 11.5 x 13.83

Bedroom4

  • Level: Basement
  • Area: 149.382
  • Dimensions: 12.9 x 11.58

Bedroom5

  • Level: Basement
  • Area: 139.3386
  • Dimensions: 13.17 x 10.58

Bedrooms & Bathrooms

  • Bedrooms: 5
  • Bathrooms: 3
  • Full bathrooms: 3

Dining Room

  • Level: Main
  • Area: 154.1939
  • Dimensions: 12.17 x 12.67

Features

  • High Speed Internet,Tub/Shower,Stand AloneShwr/MBR,Walk-In Closet(s),Wet Bar,Smart Thermostat,Eat-in Kitchen,Formal Dining,Solid Surface Counters,Wood Cabinets,Kitchen Island,Pantry
  • Window features: Window Treatments
  • Flooring: Wood,Carpet,Tile
  • Fireplace features: Living Room,Gas,Family Room
  • Fireplace: Yes
  • Finished area below ground: 1,925

Full Bathroom

  • Level: Main

Full Bathroom

  • Level: Main

Full Bathroom

  • Level: Basement

Heating & Cooling

  • Heating features: High Efficiency Furnace,Forced Air,Natural Gas
  • Cooling features: Central Electric,Mini-Split

Interior Area

  • Total structure area: 4,464
  • Total interior livable area: 4,464 sqft

Master Bedroom

  • Level: Main
  • Area: 288.4
  • Dimensions: 20 x 14.42

Other

  • Level: Basement
  • Area: 368
  • Dimensions: 23 x 16

Property

Details

  • Parcel number: 1680000050380001
  • Zoning description: R-1 One- Family Dwelling*

Features

  • Patio & porch: Concrete,Back,Deck
  • Has spa: Yes
  • Spa features: Tub/Built In Jetted

Lot

  • Lot size: 0.45 Acres
  • Lot size dimensions: 120 x 162

Parking

  • Total spaces: 3
  • Parking features: Built-In
  • 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

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

How This Home’s Risks Compare

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

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 $3,488$41,856
Home Insurance *$381$4,572
Property Taxes $471$5,652
Electricity $340$4,090
Total$4,680$56,160
*Does not include cost of any FAIR Plan premiums

Income You'd Need if You Spent...

35% on housing$160,457/yr
40% on housing$140,400/yr
45% on housing$124,800/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

$155This listing

vs Other Active Listings

Avg $/sqft

ZIP 65203$191
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-26Price change$735,000
2026-03-28Listed for sale$749,900
2009-08-02Listing removed$374,900
2009-06-20Price change$374,900
2009-03-01Price change$379,900
2009-01-09Listed for sale$399,900
2008-11-20Listing removed$419,900
2008-05-25Price change$419,900
2008-03-15Listed for sale$437,900

For Sale by Agent

AgentBennett Arey
BrokerageArey Real Estate

Similar Homes