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;

22529 State Hwy Dd Highway
Gallatin, MO 64640
Matt Grooms with The Real Estate Store LLC, original listing - (816) 399-2929

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,200,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2240 Square Feet
Agency: The Real Estate Store LLC
Agency Phone: (816) 399-2929

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 170 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Prime Hunting Property for Sale - A Sportsman's Dream<br /> This exceptional hunting property spans over 170 acres of diverse terrain and trails, offering the perfect setting for outdoor enthusiasts and hunters. Nestled in a secluded, tranquil location, the land boasts a mix of dense woodlands, open fields, and picturesque creek beds, creating an ideal habitat for wildlife, including deer, turkey, waterfowl, etc. Property has been managed to grow large bucks including multiple locations for food plots and hunting stands.<br /> Key Features:<br /> -170 Acres of diverse hunting terrain, including mature forests and open clearings. Abundant wildlife, perfect for hunters seeking a private retreat.<br /> -Modular home that could be used as a cabin or full time residence, located on the property with 3 bedrooms, set atop of a poured unfinished basement with 2 car garage.<br /> -2 large outbuildings accompany the property for storage of equipment, machinery, vehicles etc.<br /> -Creeks and ponds offer water sources and potential fishing opportunities, as well as, sources of water for gaming wildlife.<br /> -Established hunting blinds, tree stands, and trails to enhance your hunting experience.<br /> -Easy access via blacktop road, ensuring year-round accessibility. The property is located very close to Lake Viking.<br /> -Perfect for year-round hunting or a weekend getaway with your family and friends.<br /> <br /> Whether you're an experienced hunter or looking for a serene place to enjoy nature, this property offers a rare opportunity to own a piece of paradise designed for the outdoorsman. Don't miss out on this unique chance to secure your very own hunting haven!
MlsNumber: --
ListingId: 2539116


Listing Provided By: The Real Estate Store LLC, original listing
Phone: (816) 289-5681
Office Phone: (816) 399-2929
Agent Name: Matt Grooms
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