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 = 2183 AND i.igate IN ('usahud','okhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'okhud', 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 = 2183 AND i.igate IN ('usahud','okhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'okhud', 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 = 2183 AND i.igate IN ('usahud','okhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'okhud', 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;

70190 East 240 Road
Wyandotte, OK 74370
Erica Brent with Arrowhead Land Company, original listing - (833) 873-2452

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $569,000
Beds: 2
Baths: Full: 2, ½: 1
Status: Active
SqFt: 1640 Square Feet
Agency: Arrowhead Land Company
Agency Phone: (833) 873-2452

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Garage: Garage
Property Type: Residential-Single Family Attached
Year Built: --
Notes: Elk River Country Homestead is a ±40-acre breathtaking countryside retreat in the Elk River area of Grand Lake, near the Oklahoma/Missouri state line. It's time to bring your vision, roll up your sleeves, and create your dream property! Located just ±4.5 miles east of the Number 10 Bridge on the north side of the Elk River Corridor, and only ±1/2 mile from Tiff City, Missouri, this property offers a rare blend of beauty, resources, and untapped potential. Whether you're an investor seeking a value-add project, a hunter looking for your own private getaway, or someone dreaming of a self-sufficient country lifestyle just minutes from Grand Lake, this property is your canvas. The property is perimeter-fenced and includes five wells, three ponds, and a spring-ensuring a plentiful year-round water supply. There is a 2-bedroom, 2.5-bath home with solid bones and a spacious layout, including a large kitchen with island, open living area, and a walk-in cellar/storm shelter. With some TLC and finishing touches, this home can become a charming and comfortable retreat. Also included is a portable tiny home in good livable condition, plus multiple outbuildings-including several barns, shops, sheds, and a chicken coop. Together, these structures offer the foundation for workshops, creative spaces, or agricultural use. They're ready for repairs and custom upgrades to fit your vision. Adding to the appeal is a large bank of solar panels, currently in good working condition, offering both energy savings and sustainability. At the top of the property lies a beautiful full-sun vineyard, once used for blueberry wine production. The existing infrastructure is ready for revival, complete with irrigation and deer fencing for future fruit production. The vineyard includes established blueberries, as well as apple and pear trees that offer seasonal harvests. Nearby mature hardwoods add natural beauty and the potential for marketable timber. For hunters, an elevated shooting platform located in the top of the barn provides sweeping views over the rolling terrain and open grassy areas. This property is in a secluded yet convenient rural location, bursting with potential. With the right plan and a little old-fashioned sweat equity, you can transform and restore this land into the ultimate homestead, lake cabin, or income-producing farm. The setting is truly unbeatable. Elk River Country Homestead is conveniently located ±31 miles from Joplin, Missouri, ±100 miles from Tulsa International Airport, and only ±13 miles from Grove, Oklahoma. All showings are by appointment only.
MlsNumber: --
ListingId: 11495049


Listing Provided By: Arrowhead Land Company, original listing
Phone: (918) 863-0355
Office Phone: (833) 873-2452
Agent Name: Erica Brent
Disclaimer: Copyright © 2025 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