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

19305 South 1125 Road
Stockton, MO 65785

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $489,900
Beds: 4
Baths: 3
Status: Active
SqFt: 3208
Agency: Missouri Home, Farm & Land Realty LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 26 acre(s)
Property Type: Residential
Year Built: 1945
Notes: 3,208 total sq. ft. Home with walk-out Basement, Multiple out Buildings on 26.20 Productive Acres!! Come home to the country and enjoy everything this small Hobby Farm has to offer! Land is currently being used to raise goats but would accommodate a few Cows, chickens, horses or whatever your heart desires. The 3 Bedroom, 3 Bath Home offers a large yard with mature trees, garden spots and completes your perfect little piece of Paradise. The original part of the home was built in 1945 but has since added a walk-out basement plus a 12x28 kitchen/dining room to the main level. The basement was recently partially finished. Perks of the home include Lots of Custom Cabinetry throughout, multiple rooms of wood flooring, some triple pane windows, dual fuel heating, there is also a space downstairs that is finished and has a closet that could be used for an office or a non-conforming bedroom, plus a 12x12 room partially finished to make it whatever you would like. Add a laundry room on the main floor and basement plus a 2 Car Heated Garage round out the Home. Outside you will find a deck on the front and back of home, a detached 20x24 1 car Garage, 30x40 Quonset Hut Workshop, 40x48 metal barn, 45x66 metal barn, 28x36 out building, fenced pasture and 3 stocked ponds! Located just 1/4 mile off Blacktop! 10 Minutes to Stockton, Home of Beautiful Stockton Lake!
MlsNumber: 60265974


Listing Provided By: Missouri Home, Farm & Land Realty LLC, original listing
Name: Missouri Home, Farm & Land Realty LLC
Phone: (417) 327-6483
Office Name: Missouri Home, Farm & Land Realty, LLC
Office Phone: (417) 327-6483
Agent Name: Jacquetta R Hensley
Disclaimer: Copyright © 2024 Southern Missouri Regional MLS, LLC (SOMO). 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