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

22474 State Hwy N
Squires, MO 65755
Brock W. Utecht with Whitetail Properties Real Estate, original listing - (217) 285-9000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,500,000
Beds: 2
Baths: Full: 1
Status: Active
SqFt: --
Agency: Whitetail Properties Real Estate
Agency Phone: (217) 285-9000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Farm-Farm
Year Built: --
Notes: Incredible opportunity to own a large recreational tract in the heart of the Ozarks. This all-wooded tract has a very diverse timber stand with mature white pines, white oaks, red oaks, and hickory standing tall. There would be some immediate return on your investment with some selective timber harvests. As you roll through the well-maintained trails, you'll find the majority of the property is highly usable and accessible. With a surprising number of acres having workable soils, the possibilities are endless. The ridges and draws are loaded with game trails. Whitetail deer, wild turkeys and black bears roam freely on this property along with small game galore. The natural beauty of the property is only enhanced by the natural spring area located in the southwest quarter of the property. Situated a secluded 200 yards into the property sits a 2 bedroom, 1 bath home. It has been well maintained and comes furnished. The home is very livable and will make an excellent residence or hunting camp. The property is located in an area known for outdoor experiences. World-class trout fishing Is available just a few miles down the road at Rockbridge Trout Resort. Thousands of acres of Mark Twain National Forest (Glade Top Trail) are only minutes away as well. The lake life is alive and well on Bull Shoals Lake, 30 miles away. Whether you're looking for a timber investment property, an exceptional hunting property, or just a quiet, secluded place to call home, this property has a lot to offer. The Utecht Land Team is equipped and ready to help you tour this exceptional property. Call today.
MlsNumber: --
ListingId: 11350015


Listing Provided By: Whitetail Properties Real Estate, original listing
Phone: (417) 766-5595
Office Phone: (217) 285-9000
Agent Name: Brock W. Utecht
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