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;

1509 State Highway 64, Tunas, Missouri 65764
Tunas, MO 65764
Tyler Zimmerman with Prime Real Estate Investments LLC, original listing - (417) 859-4868

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,350,000
Beds: 10
Baths: Full: 10
Status: Active
SqFt: 6640 Square Feet
Agency: Prime Real Estate Investments LLC
Agency Phone:

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 9 acre(s)
Garage: Garage
Property Type: Residential-Single Family Attached
Year Built: 2023
Notes: Welcome to the newest development in the Bennett Springs State Park area: The Coyote Den's. These Commercial grade vacation rentals were completed May of 2024 and are a must see! These properties are situated in a strategic location approximately 4 miles from Bennett Springs State Park, west of the bridge. The majority of all Bennett Springs traffic comes from the Kansas City area which gives this property unlimited free advertisement. The property features 5 homes that are 1,328 square feet each. They feature 2 bedroom/ 2 bath open concept floor plans. The homes were finished using higher end materials such as 50-year commercial grade flooring and granite countertops. They all come fully furnished with brand new furniture from Helton's Furnishings out of Lebanon, Missouri. Four of the units are positioned on 5.6 acres and encircle a new decorative pond, which was also stocked with fish during the spring of 2024. The 5th property is across Highway 64 and comes with 3.9 acres of its own. The properties have numerous features including two brand new wells, 505 feet deep and 465 feet deep. They were steel sleeved 180 feet a piece. The property featuring 4 units has a new expensive LPP septic system that was state approved. The single unit property also has a state approved septic system. Both properties are fenced and have nice entryways, with the one to the four-unit side featuring a stunning commercial grade electric gated entry. All the piping was sandblasted and painted black to match structures. The two outer units nearest the road on the four-unit side feature RV hookups for those having extra family members. We have installed Starlink Wi-Fi which has had great reviews. The circle driveway has been base rocked and overspread with 2-inch clean numerous times to prevent degrading of the roadway. I cant say enough for those interested in vacation rentals. Located next to the busiest State Park in Missouri, if you are looking for a long-term proven area (even during recession years), this is it! With interest rates dropping don't miss out on this opportunity!
MlsNumber: --
ListingId: 11368368


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