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

7126 Big Sugar Creek Road
Pineville, MO 64854
Nathan Anderson with Hayden Outdoors Real Estate, original listing - (970) 674-1990

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $650,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1600 Square Feet
Agency: Hayden Outdoors Real Estate
Agency Phone: (970) 674-1990

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 23 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2012
Notes: Waterfront access to Big Sugar Creek! The 23.5+/- acre property is conveniently located 20 miles from Northwest Arkansas on paved roads. In 2012 the 1600 sq ft home was built using insulated concrete forms providing exceptional energy efficiency, and strength. Double Sugar Creek Farm is a one of a kind recreational property with opportunities to float the creek, fish for small mouth, hunt whitetail deer, and chase after the occasional turkey. The land on Big Sugar Creek consists of level creek bottoms and a timbered ridgetop. Deer can be seen regularly coming out of the timber into the bottoms to feed. The custom home constructed in 2012 has a lot to love. The home was constructed with efficiency, durability, and strength in mind when they chose to use insulated concrete forms. The home consists of 2Br, 2Ba, an office, a FEMA approved safe room inside the master closet, stained concrete floors, custom cabinets, walk in tile shower, full length deck, and a large screened in porch with a wood burning fireplace to enjoy the creek while watching the sun go down. The large shop has a 2 story apartment inside that backs up to the creek. It includes a kitchen, bathroom, laundry, living space, large sleeping quarters upstairs, and 2 screened in porches. The apartment has been used as a short term rental in the past and could be used as that again. Much of the shop has been insulated with spray foam, has a large roll up door for parking your equipment inside, a lean to, shelving, a cat walk, and high ceilings. The recreational opportunities are endless here. The property has excellent hunting, fishing, floating, and gardening. Also Big Sugar Creek State Park which consists of 2000 acres corners up to Northwest corner of the property. Huckleberry Ridge Conservation Area is just across the creek about a 10 minute drive away with 2100 acres of public land for hunting, camping, hiking, and exploring. A very active and extensive off road park is only 10 miles away for the off roading enthusiast. The climate is warm and temperate. Over the course of the year, the temperature typically varies from28°Fto89°F. Rainfall can occur year round, even in the driest month there is likely to be precipitation. The average annual the rainfall is approximately 43 inches.
MlsNumber: --
ListingId: 11323747


Listing Provided By: Hayden Outdoors Real Estate, original listing
Phone: (970) 674-1990
Office Phone: (970) 674-1990
Agent Name: Nathan Anderson
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