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

35402 Highway 7
Davis, OK 73030
Cynthia Silvas with G3 Land & Home, LLC., original listing - (580) 721-9355

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $780,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2379 Square Feet
Agency: G3 Land & Home, LLC.
Agency Phone: (580) 721-9355

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 70 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: Dream Ranch for Sale - Near Turner Falls & Arbuckle Mountains at Davis, Oklahoma!<br /> Escape to your own slice of paradise with this custom built 2003 ranch style home nestled on 70 lush acres. Conveniently located just miles west of I-35, this property offers tranquility and convenience, making it perfect for outdoor enthusiasts, horse or cattle farmers, or anyone seeking a serene lifestyle. Property Highlights: 10 Acre Watershed Lake, fully stocked for fishing and perfect for relaxing afternoons.<br /> 2-3 Acre Secondary Lake is a peaceful retreat with plenty of wildlife such as whitetail deer, ducks and turkey. Rolling 70 Acres are ideal for hunting, horseback riding or ag use. Improvements include a 30X40 Metal Shop with RV Hookup, Loafing Shed, Hay barn and Lean-to with corrals. The home has a chain link fenced back yard for pets. Property is fenced and cross-fenced for horses and cattle. ADDITIONAL 75 ACRES JOINS ON THE SOUTH SIDE OF PROPERTY AVAILABLE FOR SALE. <br /> <br /> This rare gem is a short drive to local attractions and halfway between Oklahoma City, OK and Dallas, TX, making commuting easy while still offering the privacy of rural living. Don't miss your chance to own this spectacular ranch! Contact us today for a private tour and make this property yours.
MlsNumber: --
ListingId: 2440221


Listing Provided By: G3 Land & Home, LLC., original listing
Phone: (580) 721-9355
Office Phone: (580) 721-9355
Agent Name: Cynthia Silvas
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