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

447991 East 1751 Road
Rattan, OK 74562
Gary Hill with Red River Realty and Auction, original listing - (580) 924-9595

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $139,900
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Red River Realty and Auction
Agency Phone: (580) 924-9595

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Garage: Garage
Property Type: Land-Other
Year Built: --
Notes: THIS 40 ACRES IS WITHIN THE 45,816 ACRES KNOWN AS THE THREE RIVERS WILDLIFE MANAGEMENT AREA THAT IS OWNED BY WEYERHAEUSER COMPANY. THERE IS ABUNDANT WILDLIFE AND VIEWS AND ACCESS. NO PRIVATE LAND TOUCHING THIS TRACT SO NO NEIGHBORS. THIS 40 NOW SEEMS LIKE 45,000 ACRES. OWNER PUT A GRAVELED ENTRANCE WITH A GREEN CATTLE PANEL GATE THAT IS WELL CONSTRUCTED AND A 8FT BY 8FT YELLOW WOOD STAINED DECK WITH A PICNIC TABLE AND BBQ PIT FOR A BASE OF OPERATIONS TO WORK FROM. IT HAS A LONG ROAD ACCESS AT THE TOP OF PROPERTY. YOU CAN TURN AROUND FROM ROAD AND THERE ARE BIG ROCK LEDGES AND YOU COULD BUILD IF YOU WANT. THE OWNER DOES NOT WANT TO SELL, BUT HE IS SO BUSY AND ITS HARD FOR HIM TO GET THERE AS OFTEN AS HE WANTS. THE ROAD IS HARD ROCK AND WELL MAINTAINED AND AT LEAST 30 YEARS BEFORE ANY CUTTING WILL BE DONE IN THE AREA. RAW LAND IS A GREAT INVESTMENT AND THIS IS PRICED TO SELL. FROM THE NORTH AT NOLIA LOOP IT IS APPROX. 12 MILES TO THE PROPERTY AND DOES TAKE TIME TO GET THERE BUT BEAUTIFUL DRIVE WITH CREEK CROSSINGS, FISHING OPPORTUNITIES, AND BEAUTIFUL VIEWS. THIS 40 IS AT APPROX. ELEVATIONS OF 1,200 TO 1,400 FEET AS TOP OF MOUNTAIN IS AT 1,400.
MlsNumber: --
ListingId: 11328539


Listing Provided By: Red River Realty and Auction, original listing
Phone: (972) 965-3223
Office Phone: (580) 924-9595
Agent Name: Gary Hill
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