Master on Main
2504 Vistaview Terr COLUMBIA, MO
$ 1,695,000
Property Attributes
  • MLS#393514
  • TypeSingle Family
  • CountyBOONE
  • AreaSouthwest
  • NeighborhoodLake Woodrail
  • Zip65203
  • StyleContemporary,Traditional
  • Price$ 1,695,000
  • Bedrooms5
  • Full Bathrooms3
  • Half Bathrooms1
  • Sqr Footage7352
  • Lot Size1.27 Acres
Listing Provided Courtesy Of:
Sara Harper with House of Brokers Realty, Inc.
Property Description

Resting on a bluff overlooking a wildlife reserve and the convergence of the Hinkson & Flat Branch Creeks, this exquisitely updated home features amenities beyond the imagination. Wifi access points, commercial grade LED lighting and whole home entertainment controllable by tablet, smartphone or Apple watch make up this affluent smart home. A combination of natural stone, 8 inch plank walnut an porcelain make up the flooring. the kitchen features walnut custom cabinetry, quartz countertops with porcelain tile backsplash, a commercial Wolfe range, and Subzero fridge and wine refrigerator. The Master bath features a stand alone tub and a stand alone shower overlooking the woods from floor to ceiling. The master closet features its own washer and dryer. A lower level gym overlooks an

Elementary School Middle School High School
Russell Boulevard Elementary School Jefferson Middle School Rock Bridge High School
Price History
6/19/2020 Listed $1,695,000

General Features

Cooling Central Electric
Elementary School Russell Boulevard
Exterior Features Balcony, Driveway-Paved, Pool-In Ground, Security Cameras, Sprinkler-In Ground
Fireplaces Gas, In Family Room, In Master Bedroom, Wood Burning
Flooring Ceramic, Concrete, Slate, Stone, Tile, Wood
Full Baths 3
Half Baths 1
Heating Forced Air, High Efficiency Furnace
High School Rock Bridge
Interior Features Additional Laundry Hookup(s), Attic Fan, Bar, Bar-Wet Bar, Cable Available, Cable Ready, Cedar Closet(s), Ceiling/PaddleFan(s), Data Wiring, Dual Zone Control HVAC, FireplaceScreenDr(s), Humidifier
Middle School Jefferson
Roof ArchitecturalShingle
Utilities Electric-City, Gas-Natural, Sewage-City, Trash-City, Water-City
Zoning Single Family Res

Interior Features

Basement Yes

Exterior Features

Latitude 38.925699
Longitude -92.357992
Fence Backyard, Full
Foundation Full Bsmt Part Fin, Walkout Basement
Garage Capacity 2
Garage Type Attached
House Faces SW
Patio Back, Concrete, Covered
Porch Back, Covered, Screened


  • Foreclosure
  • Views
  • Short Sale
  • New Construction
  • Adult 55+
  • Lease To Own
  • No HOA Fees
  • Furnished
  • Master On Main
  • Air Conditioning
  • Seller Finance
  • Green
  • Fixer Upper
  • Horse
  • Golf
  • Fireplace
  • Deck
  • Garage
  • Basement
  • Pool

Property vs Zip Code Average in 65203

AVG $540K
AVG 215
Year Built
AVG 1989
AVG 29
Data Provided by Walkscore ® not using MLS data

Looking for a more comfortable experience?

Download our mobile app for a personalized browsing experience.