Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1497 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1497 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1497 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

7 Mission Hills Drive
St Joseph, MO 64507

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $850,000
Beds: 5
Baths: 6
Status: Pending
SqFt: 4972
Agency: Berkshire Hathaway HomeServices Stein & Summers Re

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 2016
Notes: Welcome to your dream home nestled on nearly 3 acres just outside of St. Joseph, MO. This sprawling residence offers a perfect blend of luxury, comfort, and functionality, making it an ideal retreat for modern living. As you step inside, you'll be greeted by an expansive open floor plan that seamlessly connects the main living areas. The tall ceilings and large windows flood the space with natural light, highlighting the beauty of the surroundings. The heart of the home is undoubtedly the stunning kitchen, featuring Italian marble countertops, top-of-the-line appliances, and ample storage space. Whether you're hosting intimate gatherings or just making breakfast, this kitchen is sure to inspire your inner chef. The main floor also includes two additional bedrooms and the primary suite, offering luxury, relaxation, and rejuvenation. Venture downstairs to discover even more living space, including two conforming bedrooms, each with their own en-suite bathrooms. A second living area provides a cozy retreat for movie nights or casual gatherings, while a fully equipped bar invites you to entertain in style. Plus, there's plenty of room for pursuing hobbies or creating a home office to suit your needs. Step outside to your own private paradise, where a picturesque inground pool awaits on the expansive patio area. Whether you're lounging poolside on a sunny day or hosting summer barbecues with friends, this outdoor space is sure to impress. With road access on both the front and side of the property, the possibilities are endless. Whether you dream of adding a workshop, a second garage, or simply expanding your outdoor living space, this property offers the flexibility to bring your vision to life. Don't miss your chance to own this exceptional ranch home offering luxurious living, unparalleled amenities, and endless possibilities. Schedule your private showing today and start living the lifestyle you deserve!
MlsNumber: 2479359


Listing Provided By: Berkshire Hathaway HomeServices Stein & Summers Re, original listing
Name: Berkshire Hathaway HomeServices Stein & Summers Re
Phone: (816) 232-2000
Office Name: BHHS Stein & Summers
Office Phone: (816) 232-2000
Agent Name: Brycen Haggard
Disclaimer: Copyright © 2024 Heartland Multiple Listing Service. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App