Real Estate For Sale

2504 Vistaview Terr    Columbia, MO 65203

Property Details

Price  =  $1,700,000
MLS ID  =  378898
County  =  Boone
Area  =  Southwest
Subdivision  =  Lake Woodrail
Acres  =  1.27
Basement  =  Yes
Foundation  =  Walkout
Bedrooms  =  5 Bed(s)
Full Bathrooms  =  3 Bath(s)
Half Bathrooms  =  1 Bath(s)
Finished  =  7,352 Sq Ft
Unfinished  =  0 Sq Ft
Garage Size  =  2 Car(s)
Garage Type  =  Attached
Age  =  21-30 Yrs
Year Built  =  1986
Prop Style  =  Ranch
Prop Type  =  Single Family Residence

School Information

District  =  Columbia
Elementary  =  Russell Boulevard
Middle  =  Jefferson
Senior  =  Rock Bridge

Mortgage Calculator

Home Price  =  $1,700,000
Percent Down  =  %
Down Payment  =  $59,500
Loan Term  =  Years
Interest  =  %

Monthly Payment  =  $8,772.12

Property Description

Resting on a bluff overlooking a wildlife reserve and the convergence of Hinkson & Flat Branch Creek, 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 and porcelain make up the flooring. The kitchen features walnut custom cabinetry, Quartz countertops w/ porcelain tile backsplash, a commercial Wolfe range, & Subzero fridge & wine refrigerator. The master bath features a stand alone tub & stand alone shower overlooking the woods from floor to ceiling. Master closet features its own washer & dryer. A lower level gym overlooks an English garden & waterfall.

Property Features

Exterior Features  =  Balcony,Driveway-Paved,Pool-In Ground,Security Cameras,Sprinkler-In Ground
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,Laundry-Main Floor,Main Lvl Master Bdrm,Remodeled,Security System,Skylight(s),Smoke Detector(s),Stand AloneShwr/MBR,Tub-Portable Hot Tub,Tub/Built In Jetted,Tub/Shower,Utility Sink,Walk in Closet(s),Washer/DryerConnectn,Window Treatmnts All,Wired for Audio,Wired for Sec Sys
Kitchen Features  =  Cabinets-Custom Blt,Cabinets-Wood,Convection Oven,Cooktop-Electric,Cooktop-Gas,Counter-SolidSurface,Dishwasher-Built In,Double Oven,Garbage Disposal,Island,Microwave - Convection,Microwave Oven,Pantry,Range-Electric,Range-Gas,Refrigerator,Stand-alone Ice Maker Unit,Vent Fan,Vent-Down Draft,Wall Oven(s)
Dining  =  Eat-In Kitchen,Formal Dining
Rooms  =  Bedroom 2,Bedroom 3,Bedroom 4,Bedroom 5,Dining Room,Exercise Room,Family Room,Foyer,Great Room,Kitchen,Living Room,Master Bath,Master Bedroom,Non-Conforming Bedroom,Office/Study,Recreation Room,Sun Room,Utility Room,Workshop
Exterior Finish  =  Stone Veneer,Stucco
Roof  =  ArchitecturalShingle
Cooling  =  Central Electric
Heat Type  =  Forced Air,High Efficiency Furnace
Heat Fuel  =  Natural Gas
Fireplace  =  Gas,In Living Room,In Master Bedroom,Wood Burning
Flooring  =  Ceramic,Concrete,Slate,Stone,Tile,Wood
Deck  =  Back,Covered,Screened
Patio  =  Back,Concrete,Covered
Porch  =  Back,Covered,Screened
Fence  =  Backyard,Full
Fence Material  =  Metal,Wood
Roads  =  Cul-de-sac,Curbs and Gutters,Paved,Public Maintained
Topography  =  Heavily Wooded,Rolling,Stream(s)
Zoning  =  Single Family Res
Utilities  =  Electric-City,Gas-Natural,Sewage-City,Trash-City,Water-City

Listing Agent: Sara Harper - House Of Brokers Realty, Inc.

Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, and misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Columbia, MO MLS IDX.

Realtor Contacts

Jackie Bulgin


Shannon O'Brien


Carol Denninghoff


Office Contact

Contact us at the office number listed below and a team representative will be glad to assist you.

House of Brokers Realty

1515 Chapel Hill Road   Columbia, MO 65203


Social Media

Office Location