Skip main navigation
Off market
  • $1,916,300

    2504 Vistaview Ter, Columbia, MO 65203

    5beds
    7,352sqft
    SingleFamily
    Built in 1986
    1.27 Acres Lot
    $1,916,300 Zestimate®
    $261/sqft
    $4,567 Estimated rent

    Owner options

    List your home for rent

    $4,567/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $4,567/mo

    Rent Zestimate®

    Refinance and save

    $11,345/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $11,345/mo

    Est. payment

    What's special

    This 7352 square foot single family home has 5 bedrooms and 4.0 bathrooms. This home is located at 2504 Vistaview Ter, Columbia, MO 65203.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 4
    • Full bathrooms: 3
    • 1/2 bathrooms: 1
    Heating
    • Forced air, Gas
    Cooling
    • Central
    Appliances
    • Included: Dishwasher, Garbage disposal, Microwave, Range / Oven, Refrigerator
    Features
    • Flooring: Tile, Concrete, Hardwood, Slate
    • Basement: Finished
    • Has fireplace: Yes
    Interior area
    • Total interior livable area: 7,352 sqft

    Property

    Parking
    • Parking features: Garage - Attached
    Features
    • Exterior features: Stone, Stucco
    • Has spa: Yes
    Lot
    • Size: 1.27 Acres
    Details
    • Parcel number: 1660300040070001
    • Zoning: Single Family Res

    Construction

    Type & style
    • Home type: SingleFamily
    Materials
    • Foundation: Other
    Condition
    • Year built: 1986

    Utilities & green energy

    • Utilities for property: Gas-Natural, Electric-City, Sewage-City, Trash-City, Water-City

    Community & neighborhood

    Location
    • Region: Columbia

    Other

    Other facts
    • Interior/Features: Bar-Wet Bar, Cable Ready, FireplaceScreenDr(s), Laundry-Main Floor, Smoke Detector(s), Stand AloneShwr/MBR, Tub/Built In Jetted, Utility Sink, Walk in Closet(s), Washer/DryerConnectn, Cedar Closet(s), Ceiling/PaddleFan(s), Remodeled, Security System, Tub/Shower, Wired for Sec Sys, Bar, Data Wiring, Window Treatmnts All, Cable Available, Tub-Portable Hot Tub, Dual Zone Control HVAC, Additional Laundry Hookup(s), Humidifier, Main Lvl Master Bdrm, Attic Fan
    • Cooling: Central Electric
    • Fireplace: In Family Room, Gas, Wood Burning, In Master Bedroom
    • Dining: Formal Dining, Eat-In Kitchen
    • Flooring: Tile, Wood, Slate, Ceramic, Concrete, Stone
    • Kitchen/Features: Cabinets-Custom Blt, Cooktop-Gas, Counter-SolidSurface, Dishwasher-Built In, Garbage Disposal, Island, Microwave Oven, Range-Gas, Refrigerator, Vent Fan, Cooktop-Electric, Range-Electric, Pantry, Vent-Down Draft, Wall Oven(s), Double Oven, Stand-alone Ice Maker Unit
    • Exterior Features: Driveway-Paved, Pool-In Ground, Balcony, Sprinkler-In Ground, Security Cameras
    • Restriction/Easement: Deed Restrictions, Subdiv Restrictions
    • Roof: ArchitecturalShingle
    • Arch./Style: Contemporary, Traditional
    • Utilities: Gas-Natural, Electric-City, Sewage-City, Trash-City, Water-City
    • Foundation Material: Poured Concrete
    • Foundation Type: Full Bsmt Part Fin, Walkout Basement
    • Foundation Access: Inside Entrance, Outside Entrance, Walkout
    • Deck: Back, Covered, Screened
    • Heat Type: Forced Air, High Efficiency Furnace
    • Heat Fuel: Natural Gas
    • Rooms: Dining Room, Family Room, Kitchen, Living Room, Master Bedroom, Recreation Room, Utility Room, Great Room, Exercise Room, Non-Conforming Bedroom, Bedroom 2, Bedroom 3, Workshop, Bedroom 4, Bedroom 5, Master Bathroom, Sunroom, Office
    • Primary Style: Ranch
    • Zoning: Single Family Res
    • School District: Columbia
    • Basement: Yes
    • Senior Sch: Rock Bridge
    • Fence: Backyard, Full
    • Street/Roads: Public Maintained, Curbs and Gutters, Cul-de-sac
    • Patio: Back, Covered, Concrete
    • Fence Material: Wood, Metal
    • Topo/Lot Description: Rolling, Stream(s), Heavily Wooded
    • Porch: Covered, Screened, Back
    • Exterior Finish: Stone Veneer, Stucco
    • House Faces: SW
    • Licensee Per/Int Dis: Not Applicable
    • Type: Single Family Residence
    • Sq Ft Source: County Records
    • Legal Description: Lake Woodrail No 8 Lot 93
    • Rooms: Master Bath Level: Main
    • Rooms: Master Bedroom Level: Main
    • Rooms: Kitchen Level: Main
    • Rooms: Dining Room Level: Main
    • Rooms: Living Room Level: Main
    • Rooms: Bedroom 4 Level: Lower
    • Rooms: Recreation Room Level: Lower
    • Rooms: Office/Study Level: Main
    • Rooms: Great Room Level: Main
    • Rooms: Bedroom 2 Level: Lower
    • Rooms: Bedroom 3 Level: Lower
    • Rooms: Family Room Level: Lower
    • Rooms: Utility Room Level: Lower
    • Rooms: Bedroom 5 Level: Lower
    • Rooms: Sun Room Level: Main
    • Rooms: Non-Conforming Bedroom Level: Lower
    • Rooms: Workshop Level: Lower
    • Rooms: Exercise Room Level: Lower