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

13810 W 33rd Street S
Haskell, OK 74463

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $425,000
Beds: 3
Baths: 2
Status: Pending
SqFt: 1500
Agency: Keller WIlliams Realty Advantage

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Property Type: Residential
Year Built: 2003
Notes: CALLING ALL FSA BUYERS -- 40 +/- ACRES OF COUNTRY CHARM WITH RANCH HOUSE AND BARN IN HASKELL—ONLY 17 MILES FROM EUFAULA LAKE AND 20 MILES TO FORT GIBSON LAKE!! Nestled on 80 +/- acres, this 3 bed/2 bath home with 2-car carport embodies the perfect blend of rural charm and modern comfort. Home is largely maintenance free, including the less than 2-year-old HVAC system. The acreage, coupled with the 60'x100' barn with concrete floor, storm cellar, and 12'x100' lean-to presents limitless possibilities for customization and fulfillment. The versatile barn with concrete floor provides plenty of space for storage, workshops, or even the possibility of converting it to suit your specific needs or hobbies. The vast, open land offers endless possibilities for ranching, equestrian pursuits, or the creation of your dream outdoor sanctuary. Benefit from the convenience of being 10 miles from Muskogee, 9 miles from Haskell, and within reach of other neighboring towns, making essential amenities easily accessible. Strategically situated to enjoy easy access to major highways including US-62 (3.5 miles away), US-64 (2 miles away), and US-69 (10 miles away). Don't miss this rare opportunity to own a piece of Oklahoma dirt with your nearest neighbor a quarter mile away. Additional land available. Schedule a showing today!
MlsNumber: 2411676


Listing Provided By: Keller WIlliams Realty Advantage, original listing
Name: Keller WIlliams Realty Advantage
Phone: (918) 712-2252
Office Name: Keller Williams Advantage
Office Phone: (918) 712-2252
Agent Name: Drew Ary
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