Rock Island Realty

Ranch

147 Vista Vallarta Drive

Union, MO 63084

MLS#: 26063585

$347,500

Status: Active
Listing number: 26063585
Listing provided by: HD Real Estate LLC
Listing agent phone: None
Last update: a day ago
On site: 18 days ago
Browse Properties
St Andrews Place - Residential

Property

Beds

5

Full Baths

3

1/2 Baths

None

Year Built

2016

Sq.Footage

2,426

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.

Open Houses

Open house times are shown in the property’s local time.

  • Sunday

    October 25, 2026

    –

    In progress

    Your time:

Features & Amenities

Interior

  • Total Bedrooms

    5

  • Bathrooms

    3

  • Above Grade Finished Area

    1376.0

  • Basement YN

    YES

  • Cooling YN

    YES

  • Cooling

    Central Air

  • Fireplace YN

    NO

  • Heating YN

    YES

  • Heating

    Electric, Forced Air

  • Main Level Bedrooms

    3

  • Pet friendly

    N/A

Exterior

  • Garage

    Yes

  • Garage spaces

    2

  • Construction Materials

    Brick, Stone, Vinyl Siding

  • Pool

    No

Area & Lot

  • Lot Features

    Back Yard, Front Yard

  • Lot Size(acres)

    0.29

  • Lot Size(square feet)

    12,632

  • Property Type

    Residential

  • Property Sub Type

    Single Family Residence

  • Architectural Style

    Ranch

Price

  • Sales Price

    $347,500

  • Tax Amount

    $2,557

  • Financing Options

    Cash, Conventional, FHA, VA Loan

  • Sq. Footage

    2,426

  • Price/SqFt

    $143

HOA

  • Association

    No

School District

  • Elementary School

    Prairie Dell Elem.

  • Middle School

    Union Middle

  • High School

    Union High

Property Features

  • New Construction

    NO

  • Sewer

    Public Sewer

  • Water Source

    Public

Schedule a Showing

Showing scheduled successfully.

<
>
IN PERSON
VIA CHAT

What is 3 + 4 ?


Change time

Mortgage calculator

Estimate your monthly mortgage payment, including the principal and interest, property taxes, and HOA. Adjust the values to generate a more accurate rate.

Your payment

Principal and Interest:

$

Property taxes:

$

HOA fees:

$

Total loan payment:

$

Total interest amount:

$

Location

County

Franklin

Elementary School

Prairie Dell Elem.

Middle School

Union Middle

High School

Union High

Listing Courtesy of Hayden Lock, HD Real Estate LLC

RealHub Information is provided exclusively for consumers' personal, non-commercial use, and it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. RealHub website owner shall not be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless.

Agent Emily Kostuke

Agent / Realtor®

Emily Kostuke

Call Emily today to schedule a private showing.

(816) 916-5630

emily@homeatthelake.com


* Listings on this website come from the FMLS IDX Compilation and may be held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request.© 2024 FMLS.
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.

147 Vista Vallarta Drive

Message successfully sent.

What would you like to know?

What is 3 + 4 ?

I agree to receive email communication and understand I can unsubscribe at any time.

I agree to be contacted by Rock Island Realty via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

Related Properties

Love gardening, raising small livestock, doing yoga in the meadow, or just wanting to do a bit of hobby farming, this mid-century vintage charmer is your new address. Situated on a pretty five acres with a nice balance of open and wooded land. Home offers three-four bedrooms, a beautifully updated kitchen, a spacious four-season/multipurpose area, and a relaxing rear deck complemented by a welcoming front porch. All this country living is minutes from city services and provides easy access to the highway. Come see for yourself.
#26065684

Union

300 Echo Valley Road

4 Beds

2 Baths

1,712 Sq.Ft.

$349,500

MLS#: 26065684

Hard to fine a Ranch home on an acre in Washington School District !! Here you will find a cute ranch home with plenty of room to move around. Walk into a freshly painted home with vaulted great room and open floor plan to kitchen and dining area. The primary bedroom has a full bathroom with plenty of closet space. There are two additional bedrooms and a second full bathroom. The lower level is partially finished with a sleeping room and third full bathroom. Large laundry and plenty of storage downstairs as well. Walk out to the wooded yard. There is a large deck that overlooks the awesome firepit area. This is really nice with steps and a retaining wall almost the length of the yard. Perfect for the fall weather coming up on the outside, and on the inside you have an attic fan to keep things cool. There will be plenty of room for everyone at the holidays with and additional concrete pour with a two car over sized garage. The property goes all the way up to Hwy A , is wooded for great privacy. It is like you are in the country but only 5 min to Union and less than 10 min to Washington. Two tax ID # 17-5-150-0-014-038200 & 17-5-150-0-002-046100
#26063881

Union

19 Choiceland Court

3 Beds

3 Baths

1,834 Sq.Ft.

$309,900

MLS#: 26063881

Price reduced
Beautiful 2 story home on a quiet cul-de-sac overlooking a pond. This home features 4 bedrooms and 2.5 bathrooms, main floor laundry, and main floor primary suite with walk-in closet. The big, lovely kitchen has a barn wood look wall, beautiful center island, stainless steel appliances, and a fridge that stays! Also featuring some built-in book shelves, deck off the back overlooking the pond, and a fully fenced-in backyard! Upstairs you'll find the additional bedrooms, one of which is large with its own walk-in closet. Additional features include wood accent wall, doggie door, new garage door, barn doors, and a rough-in for an additional bathroom. At over 1900 square feet plenty of room for everyone, entertaining, and on a quiet cul de sac too! Just minutes to schools, shopping, church, pool, and in vibrant very family friendly Union. Its ready tyo go for you quick closing very possible, come see this beauty.
#26055745

Union

240 S Ridge Court

4 Beds

2 Baths

1,920 Sq.Ft.

$370,000

MLS#: 26055745

Price reduced
ANOTHER READY-NOW HOME TO CALL YOUR OWN. #UNIONMO. A VERY SPACIOUS MULTI-LEVEL HOME TO FALL IN LOVE WITH!! A Quality New Construction home with so much to offer. This floor plan delivers big bang for your buck. A stylish multi-level design with great curb appeal, featuring partial pewter board-and-batten siding in the front bump-outs, white horizontal siding, board-and-batten shutters, a wide driveway, a gorgeous craftsman front door, and more. This Home comes equipped with a 2-car oversized garage with a black door with glass windows, a nice sod lawn, a rear patio, a front porch with composite decking and a black railing system, 4 beds x 3 full baths, plenty of square footage, a large living room with an elegant ceiling fan, LVP flooring, a spacious kitchen with plentiful gray-stained cabinets & a sleek Quartz countertop design, built-in dishwasher & microwave, a single door with half glass and built-in blinds to the rear patio, and much more. The grand primary suite includes dual closets, a large gray-stained vanity, and a tub & shower. A large Lower-level 4th bed/office/play room with an entry landing from the garage, a nice closet for coats & shoes, a laundry/storage area & 3rd full bath. This home has 9' house walls throughout the main floor with an upgraded taller trim package and a 9' basement. This completed home has loads in upgrades. ELS HOMES - LOCAL BUILDER AT ITS FINEST - #ELSHOMES. YOU DON'T WANT TO MISS THIS.
#26064532

Union

112 Ventnor Avenue

4 Beds

3 Baths

1,774 Sq.Ft.

$299,900

MLS#: 26064532

Price reduced
HOME COMPLETE & READY NOW! TOTAL LIVING AREA 1,828 SQFT AND PACKED WITH ALL THE NICE UPGRADES. A VERY SPACIOUS MULTI-LEVEL HOME TO FALL IN LOVE WITH!! A Quality New Construction home with so much to offer. This floor plan delivers big bang for your buck. A stylish multi-level design with great curb appeal, featuring gray siding, pewter board & batten in the bump-out, black board & batten shutters, a wide driveway, a gorgeous craftsman front door, a composite porch with a black rail system at the front entry, & more. This home comes equipped with a 2-car oversized garage, large yard space, rear patio, 4 beds x 3 full baths, plenty of sqft, a large living room with an elegant ceiling fan, LVP flooring, a spacious kitchen with plentiful gray-stained cabinets & a sleek Quartz countertop design, built-in dishwasher & microwave, a single door with half-glass with built-in blinds to the rear patio, 9' ceilings throughout the main floor, etc. The grand primary suite includes a walk-in closet, a large gray-stained double-bowl vanity, and a shower with an elegant glass slider door. A large Lower-level 4th bed/office/play area with an entry landing from the garage, a laundry/storage/mechanical area & a third full bath. YOU DO NOT WANT TO MISS THIS ONE. ELS HOMES - LOCAL BUILDER AT ITS FINEST - #ELSHOMES
#26063261

Union

114 Ventnor Avenue

4 Beds

3 Baths

1,828 Sq.Ft.

$304,900

MLS#: 26063261

Pre-Construction. To Be Built Home ready to personalize into your dream home! BASE PRICE and PHOTOS are for 3BR, 2.5BA Berwick Two Story. Pricing will vary depending on various interior/exterior selections. This home features an incredible spacious family room, perfect for entertaining! Enjoy the expansive kitchen with lots of cabinetry and available center island. This space opens to a large dining area with access to the backyard, plus you can personalize with bay windows or built in desk. Upstairs you’ll find a large master bedroom with walk-in closet and available luxury master bath, 2 secondary bedrooms, and 2nd floor laundry. The Berwick includes 2 car garage, soffits & fascia and much more! Enjoy peace of mind with McBride Homes’ 10 year builders warranty and incredible customer service! St. Andrews Meadows offers 152 homesites with community dog park and 2 walking trails with convenient access to Veterans Memorial Park. Display photos shown.
#26063702

Union

2 Berwick at St. Andrews Manor

3 Beds

2 Baths

1,728 Sq.Ft.

$284,900

MLS#: 26063702

Pre-Construction. To Be Built Home ready to personalize into your dream home! BASE PRICE and PHOTOS are for 3BR, 2BA Maple Ranch. Pricing will vary depending on various interior/exterior selections. This beautiful home features a large great room with available vaulted ceilings and gas fireplace. Spacious dining area and open kitchen with optional center island & breakfast bar. The master suite includes a large walk-in closet private bathroom. This floor plan can have 2-3 total bedrooms, with a full hall bath included. Two car garage, main floor laundry room, and much more! Personal selections include bay windows, luxury master bath, and great room extension. Enjoy peace of mind with McBride Homes’ 10 year builders warranty and incredible customer service! St. Andrews Meadows offers 152 homesites with community dog park and 2 walking trails with convenient access to Veterans Memorial Park. Display photos shown.
#26063709

Union

2 Maple at St. Andrews Manors

3 Beds

2 Baths

1,745 Sq.Ft.

$284,900

MLS#: 26063709

Pre-Construction. To Be Built Home ready to personalize into your dream home! BASE PRICE and PHOTOS are for 4BR, 2.5BA Royal II Two Story. Pricing will vary depending on interior/exterior selections. This flexible two story home offers plenty of living space! The main floor is great for entertaining, with a kitchen that opens to the breakfast room and family room, plus a formal dining room for additional space. Second floor features the master suite with private bath and 3 secondary bedrooms with hall bath. Additional selections include luxury kitchen or a luxury master bath. The Royal II includes 2 car garage, main floor laundry, and more! Additional personal selections may include bay windows, fireplace, or great room window wall. Enjoy peace of mind with McBride Homes’ 10 year builders warranty and incredible customer service! St. Andrews Meadows offers 152 homesites with community dog park and 2 walking trails with convenient access to Veterans Memorial Park. Display photos shown.
#26063712

Union

2 Royal II at St. Andrews Mano

4 Beds

2 Baths

2,001 Sq.Ft.

$307,900

MLS#: 26063712

Pre-Construction. To Be Built Home ready to personalize into your dream home! BASE PRICE and PHOTOS are for 4BR, 2.5BA Ashford Two Story. Pricing will vary depending on interior/exterior selections. This beautiful home opens to a living room and separate formal dining room. The back of the home features an open floorplan with massive kitchen, breakfast room, and large family room. Master suite features large walk in closet and private bath. 3 secondary bedrooms, all with walk in closets! The Ashford includes a 2 car garage, main floor laundry room, soffits & fascia and much more! Personal selections may include center island, extended kitchen plan with peninsula, gas fireplace, window wall or bay windows. Enjoy peace of mind with McBride Homes’ 10 year builders warranty and incredible customer service! St. Andrews Meadows offers 152 homesites with community dog park and 2 walking trails with convenient access to Veterans Memorial Park. Display photos shown.
#26063591

Union

2 Ashford at St. Andrews Manor

4 Beds

2 Baths

2,548 Sq.Ft.

$323,900

MLS#: 26063591

Send a message

Message successfully sent.

Your message

What is 3 + 4 ?

Reason for contacting?

I agree to receive email communication and understand I can unsubscribe at any time.

I agree to be contacted by Rock Island Realty via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

Sign Out

Virtual Assistant

Would you like to take the next step with this property? We can help you schedule a showing or virtual tour, or send you more details.

Yes, I would like more information.

Thank You for Your Reply, One of Our Agents will contact you as soon as possible

No, maybe later.

Thank you, you can always contact me via email, phone number or through the contact form.

Realhub AI

Lucy - Your AI-Powered Realtor

Update Your Temporary Password

Personalize your search

Enter your email and we'll notify you immediately when new listings match what you're looking for.

or enter email address

Already have an account ? Login here

Continue your home search

I agree to receive communications and understand I can unsubscribe at any time.

I agree to be contacted by Rock Island Realty via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

Already have an account ? Login here

We use cookies

We use cookies primarily for analytics to enhance your experience. By accepting, you agree to our use of these cookies. You can manage your preferences or learn more about our cookies policy.

Privacy Policy Terms of Service