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

117 Flintlock Rd
Windyville, MO 65783
Tyler Zimmerman with Prime Real Estate Investments LLC, original listing - (417) 859-4868

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $989,000
Beds: 2
Baths: Full: 1
Status: Active
SqFt: 1835 Square Feet
Agency: Prime Real Estate Investments LLC
Agency Phone:

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 74 acre(s)
Garage: Garage
Property Type: Residential-Cabin
Year Built: 2000
Notes: This opportunity doesn't come often! A stunning cabin that lies in the middle of approximately 74.88 scenic acres near Bennett Spring State Park. This cabin sits on an Ozark bluff and has a breath taking view. The property has been used as a highly sought after vacation rental for 15 years and the income that has been produced for this unit is unbelievable! The finished rustic lodge can sleep numerous guest and features 2 bedrooms, 1 bath in open floor plan layout. The bedrooms each have king beds. The loft area consist of two 2 twin beds and 2 full size beds as well. There are two high quality rollaway beds that make this location a pleasant experience for multiple families. The large grand room has a stunning wood burning fireplace and give it that cozy lodge feel. You will also notice the large screened in front porch that allows you to experience nature but keeps the bugs away as well! The property has a private well and private septic tank. The HVAC system is forced air and is very efficient with the wood burning fireplace option as well. The aerial view of the property will show the outdoor firepit with 4 Adirondack polywood chairs, large outdoor grill and the gorgeous Niangua River. This property has approximately a quarter of a mile of river frontage and provides amenities such as tubes, lifejackets, chairs, etc. to fully experience what the Niangua River has to offer its guest! This property lies at the end of a dead end private drive and secluded from surrounding properties. If you are looking for a property you can visit periodically with your personal family and make a great income while you are away, this is a rare opportunity so don't wait to view. Give me a call to schedule a showing or for any questions!
MlsNumber: --
ListingId: 11349853


Listing Provided By: Prime Real Estate Investments LLC, original listing
Phone: (417) 859-4868
Office Phone: (417) 859-4868
Agent Name: Tyler Zimmerman
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