New Listing
147 Vista Vallarta Drive,Union, MO 63084
Union, MO 63084
Description
Located in Union, this 5-bedroom, 3-bath home stands out with a finished walkout basement and a backyard that backs to woods with no homes directly behind it. Built in 2016, the main level offers 3 bedrooms and 2 bathrooms, including a master suite with double vanities, soaking tub, and separate walk-in shower. The living room features a raised ceiling, and the kitchen comes equipped with stainless steel appliances. The finished walkout basement adds significant living space with 2 additional bedrooms, a full bathroom, and a large living and entertainment area. The projector and sound system stay with the home, making the space ready to enjoy. Additional features include an attached 2-car garage, brick and stone accents on the front of the home, and a yard that has recently undergone a full reseeding program. With 5 bedrooms, a finished walkout basement, and a wooded backdrop, this home offers a combination that's hard to find within the subdivision.
Details
| MLS # | 26063585 |
|---|---|
| Listing Type | For Sale |
| Style | House |
| Sub-Type | Resale |
| Status | Active |
| Year | 2016 |
| Days On Site | 2 |
| Listing Provided By | HD Real Estate LLC | Hayden Lock |
Features
| Bed(s) | 5 |
|---|---|
| Bath(s) | 3 Total |
| SQ Feet | 2,426 |
| Garage | 2 |
| Basement | Y |
| Story(s) | 1 |
| Acreage | 0.29 |
Interior
| Rooms Total | 8 |
|---|---|
| Cooling | Central Air |
| Heating | Electric, Forced Air |
| Appliances | Stainless Steel Appliance(s), Dishwasher, Microwave, Range, Refrigerator |
Exterior
| Construction Materials | Brick, Stone, Vinyl Siding |
|---|---|
| Lot Features | Back Yard, Front Yard |
Parking
| Garage Yes / No | Yes |
|---|---|
| Attached Garage Yes / No | Yes |
Utilities
| Utilities | Electricity Connected |
|---|---|
| Electric | Single Phase |
| Sewer | Public Sewer |
Taxes
| Property | 2557 |
|---|
Area Information
| State | MO |
|---|---|
| County | Franklin |
| City | Union |
| Zip Code | 63084 |
| Area | Union R 11 |
| Community Name | St Andrews Place |
| School District | Union High |
| Elementary School | Prairie Dell Elem. |
| High School | Union High |
| Listing VS Median (in St Andrews Place) | |
Price: $347,500 low | high Med: $348,750 sqft: 2,426 low | high Med: 2,313 $ / sqft: $143 low | high Med: $151 On site: 2 low | high Med: 5 | |
Market Activity 63084
Request a showing
Request a showing
Listings courtesy of Maris MLS as distributed by MLS GRID.
Based on information submitted to the MLS GRID as of October 6, 2026 at 1:33:33 PM PDT All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the “DMCA”) provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to DMCAnotice@MLSGrid.com.
Contact
Learn More About This Property
| State | MO |
|---|---|
| County | Franklin |
| City | Union |
| Zip Code | 63084 |
| Area | Union R 11 |
| Community Name | St Andrews Place |
| School District | Union High |
| Elementary School | Prairie Dell Elem. |
| High School | Union High |
| Listing VS Median (in St Andrews Place) | |
Price: $347,500 low | high Med: $348,750 sqft: 2,426 low | high Med: 2,313 $ / sqft: $143 low | high Med: $151 On site: 2 low | high Med: 5 | |
Listings courtesy of Maris MLS as distributed by MLS GRID.
Based on information submitted to the MLS GRID as of All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the “DMCA”) provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to DMCAnotice@MLSGrid.com.
