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

14589 Ne County Road 2763 Road
Adrian, MO 64720
Marty Siess with Realty Executives, original listing - (913) 642-4888

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $860,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 3491 Square Feet
Agency: Realty Executives
Agency Phone: (913) 642-4888

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 55 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1980
Notes: This recreational property features a pond, two miles of trails, woods, streams, and more wildlife than you can imagine. It also generates income if you grow crops or raise livestock. Most of all, it’s a home. Look out the windows, and you’ll fall in love with the views. Nearly gutted to the studs, the Sellers have spent the last eight years updating and decorating so you can enjoy horses and livestock, hunting deer or wild turkey, or exploring the mile of trails carved through the trees. The plumbing fixtures, including shower heads, faucets, sinks, and toilets, are newer. The kitchen and baths feature newer cabinets, sinks, and granite or marble countertops. Stainless Steel Appliances are under two years old. ALL light fixtures and most switches and plugs are newer. The oversized mudroom is large enough for a loveseat, chair, and an old-fashioned tub sink. The great room boasts vaulted ceilings and a stunning floor-to-ceiling brick fireplace. The primary bath has beautiful tile floors, a newer shower, and a whirlpool tub. The spacious basement rec room is perfect for pool, game nights, and drinks at the wet bar. The basement also features a non-conforming bedroom and full bath. The massive patio easily accommodates 75+ guests and is stubbed for an outdoor kitchen. The livestock barn has an automatic watering area. A breathtaking quarter-mile trail, LOVERS LANE, feels like a movie set. The property is fenced and cross-fenced for livestock and horses. The septic, furnace, A/C, and water heater are 1–3 years old. The 1.87-acre pond is 27' deep and stocked with bass, crappie, bluegill, and catfish.
MlsNumber: --
ListingId: 2528104


Listing Provided By: Realty Executives, original listing
Phone: (913) 642-4888
Office Phone: (913) 642-4888
Agent Name: Marty Siess
Disclaimer: Copyright © 2025 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