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','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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','flhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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','flhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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;

2 Fieldcrest Lane
St Joseph, MO 64506

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $694,900
Beds: 4
Baths: 4
Status: Active
SqFt: 5400
Agency: Berkshire Hathaway HomeServices Stein & Summers Re

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential
Year Built: 1980
Notes: Situated on a sprawling 5-acre lot within the city limits, this property offers the ultimate blend of luxury, comfort, and serenity. This large 1.5-story home features 4 bedrooms and 4 full baths, with approximately 5000 square feet of finished living space. The recently remodeled kitchen is now an inviting open concept space adorned with custom cabinets, top-of-the-line appliances, sleek quartz countertops, and a hidden pantry. Dual large islands provide ample seating for up to 6 guests. The kitchen includes an additional dining area with bay windows that overlook the front yard. The recently updated great room features a vaulted beamed ceiling and a brick fireplace with custom lighting, creating a warm and welcoming ambiance. Wide plank hardwood floors flow seamlessly throughout the home, adding a touch of timeless charm. On the main floor, you'll find the master suite alongside another bedroom and full bathroom. Upstairs, there are two additional bedrooms and an office area, accompanied by a full bathroom. Entertaining is made easy in the lower-level family room which underwent a previous remodel, featuring a second fireplace, a full bathroom, and a non-conforming 5th bedroom. The home features a recently screened-in covered patio overlooking the backyard. Additionally, there's a second oversized “patio” area in the backyard, previously utilized as a basketball court, ideal for outdoor recreation. This impressive residence also includes newer windows throughout, recently purchased new screens, and a spacious 3-car garage.
MlsNumber: 2480532


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: Julie Hesselmann
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