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

442 Arizona Trail
Stuart, OK 74570
Marty Donaldson with C21/Shirley Donaldson Inc, original listing - (918) 426-4343

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $69,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: C21/Shirley Donaldson Inc
Agency Phone: (918) 426-4343

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Escape from the crowds, noise & frayed nerves to your own 10 acres, surveyed hideaway for Mother’s Nature soothing remedy. Located near Stuart. Heavenly wooded with non-congested timber & openings throughout, atop of a hillside tucked away with privacy & view to the pond. The Owner made some substantial improvements on it. Nature Lovers will find peace & tranquility, deer roaming throughout and a variety of wild life in this Country Seclusion. This great get-away Beauty has much to offer. Tucked away off South Buffalo Road, leading to Arizona Trail, leading uphill to the subject land. The Owners opened part of the land atop the hill side for the home pad, overlooking the pond. They had a well driller drill a water well and it hit water at 53 feet with a 26 feet, 6 inch PVC Pipe setting and an estimated Yield of 10 GPM. DEQ Perk Test is approved for a standard septic system. They opened up the home pad site with view to the pond and nearby electric to connect. There are no building, livestock or usage restrictions! It is ideal for anyone who simply has joy not being near people and love being tucked away. The property is partial fenced. Inside the land you will find a dry, seasonal creek bed and a pathway, which appears to be a road trail from the old days. An electric powerline runs through the land, ideal for target shooting and deer stand. Envision yourself on a front porch of your future, self efficient cabin overlooking the pond with a restful view! It is simply an ideal retreat from stressful City Life or for a permanent residence. According to the Owner there is fish in the pond.<br /> The Owners improved very recently the easement road, called Arizona Trail. It is not a County Road, but a legal easement road as shown on the boundary survey. The Owners installed several tinhorns, grated the road, cut the uphill incline lower and spend thousands of dollars for all improvements. Owners gave permission to disclose that they are selling due unexpected health issues.
MlsNumber: --
ListingId: 2443166


Listing Provided By: C21/Shirley Donaldson Inc, original listing
Phone: (918) 916-4948
Office Phone: (918) 426-4343
Agent Name: Marty Donaldson
Disclaimer: Copyright © 2024 MLS Technology, Inc. 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