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 = 1517 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 = 1517 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 = 1517 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;

14381 State Hwy E
Pattonsburg, MO 64670
Dylan Heitz with United Country Nelson Real Estate, original listing - (660) 425-2288

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $399,900
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2288 Square Feet
Agency: United Country Nelson Real Estate
Agency Phone: (660) 425-2288

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Garage: Garage
Property Type: Residential-Farm
Year Built: 1928
Notes: Listing # 7804 What an incredible opportunity to own your slice of country paradise! Located just off Hwy. 69 and a very short drive to I-35, this home boasts an incredible location and wonderful country charm. It is roughly 45 minutes from the doorstep to Kansas City. The 1928 built farmhouse has been very well taken care of. Over the past several years, updates such as Smart Siding, windows, fascia, soffits, roof, added on 2 car garage, and more have been completed on the exterior. The interior has had extensive work on the main level. With new wiring, drywall, fixtures, paint, custom oak cabinetry with granite tops, and walls being opened up, this home is ready to move into! There are a number of outbuildings. The most recent one was constructed in 2015 and is 30'x15'. It is insulated and climate controlled. It has ample storage in the attic. There is also a 100'x30' outbuilding that is being used as a workshop on one side and livestock pens on the other. A nice 24'x24' carport building with concrete and electric is on the other side of the property. Features Include: - 1928 built farmhouse - Numerous updates/additions on the house - 6.26 acres m/l lot - New roof 2024 - Smart siding, vinyl windows - Custom Oak cabinetry with granite tops - Opened up walls on main level - Incredible stairway - 2015 two car garage and sunroom added on - Asphalt driveway - 2015 a 30'x24' building constructed - 30'x100' outbuilding - Storm shelter - Multiple other outbuildings located on premises
MlsNumber: --
ListingId: 11368228


Listing Provided By: United Country Nelson Real Estate, original listing
Phone: (660) 425-2288
Office Phone: (660) 425-2288
Agent Name: Dylan Heitz
Disclaimer: Copyright © 2024 My State MLS. 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