37 Photos

$347,500

147 Vista Vallarta Drive

St Andrews Place, Union, Missouri, 63084

MLS® 26063585 · Listed by HD Real Estate LLC

3 bedrooms3 bathrooms2426.00 sqftResidential0 days on marketBuilt 2016Lot 12632.40$2,557 taxes (2025)2 garageElectric,Forced Air · Central AirBathroom,Full,Sleeping Area,Walk-Out Access basement

About this property

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.

Ask Maryam about this home

Your details go directly to Maryam and are never shared.

Estimated value

$354,164

Estimated range: $302,186 – $406,143 · 15% confidence

Estimated value by month

Estimated value trend from Nov 2025 ($256,087) to Oct 2026 ($354,164)Nov 2025Oct 2026

This is an automated estimate based on MLS® market data — not an appraisal or a substitute for professional advice.

Curious what your own home is worth? Get a free estimate →

Comparable recent sales

Sold records the MLS® data provider selected as comparable to this home — nearby recent sales at a similar price, bed count, and property type. Locations are shown at the neighborhood level only.

SoldJul 27, 2026

$349,000

Listed at $349,000

The Overlook At Weber Farms, Washington, Missouri

3 bd · 3 ba · 2272.00 sqft · Residential

SoldSep 24, 2026

$315,000

Listed at $310,000

Villages/Brickyard 1, Hillsboro, Missouri

3 bd · 2 ba · 2368.00 sqft · Residential

SoldJul 26, 2026

$375,000

Listed at $369,900

Vlgs At Springhurst #5, O'Fallon, Missouri

3 bd · 4 ba · 2393.00 sqft · Residential

SoldSep 5, 2026

$359,000

Listed at $359,000

Saratoga #1, Lake St Louis, Missouri

3 bd · 4 ba · 2440.00 sqft · Residential

SoldAug 20, 2026

$375,000

Listed at $375,000

Discovery Village #2, Wentzville, Missouri

3 bd · 3 ba · 2512.00 sqft · Residential

SoldJul 6, 2026

$370,000

Listed at $379,900

Mayfield Farms Estates 02, Imperial, Missouri

3 bd · 3 ba · 2350.00 sqft · Residential

Similar properties

MLS® data for this listing last updated Oct 4, 2026.

Market snapshot

The St Andrews Place, Union market

Closed sales in St Andrews Place, Union over the last 12 months.

$323,500

Median sold price

47

Avg. days on market

16

Homes sold

Median sold price by month

Median sold price trend from Oct 2025 ($325,000) to Jun 2026 ($327,900)Oct 2025Jun 2026