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

40079 D Ecr 1319 Rd
Mccurtain, OK 74944
Sherry Hamby with McGraw REALTORS, original listing - (479) 226-3931

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,302,500
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2436 Square Feet
Agency: McGraw REALTORS
Agency Phone: (479) 226-3931

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 365 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1988
Notes: This gorgeous Spanish-style home is situated on a hill overlooking green pastures and ponds with a magnificent view from every angle. You will love sitting on the north front porch where you can see for miles. Towards the south, you have view of the pastures and mountains. <br /> The large open living room includes a Spanish style fireplace and ceiling beams running the length of the room. A wall of windows on the north wall offers plenty of views. An additional entryway at the front of the home leads to a private office which also connects to the living room. Newly installed luxury vinyl flooring is throughout the main living area. Off of the living room is a large dining room and eat-in kitchen. There is a half bath located outside off of the covered carport for convenience. The large patio on the south of the home is a perfect place to wind down after a long day!<br /> On the other side of the living room is a large primary bedroom complete with a walk-in closet and a newly remodeled bathroom with a full vanity and walk in shower. The main bathroom across the hall has a tub and large vanity. The second bedroom is next door as well as the laundry room. The bedrooms have been updated with new carpet. The third bedroom is located across from the covered carport, also known as the guest suite. It consists of a bathroom with a shower, a small kitchenette with a gas stove, and a bedroom suite. A new metal roof was recently installed on the home as well.<br /> Several ponds and a seasonal creek are scattered throughout the property. The topography of the land is sloping to gently sloping with approx. 60% being in pastureland. The remaining amount is in native hardwoods and pine which gives plenty of cover for wildlife and offers good shade for livestock. There is also an abundance of wildlife in the area including whitetail deer, eastern wild turkey, and other small game. There is a good stand of Bermuda grass, Lespedeza, seasonal Yellow Hop, and Clover for cattle grazing.
MlsNumber: --
ListingId: 1068586


Listing Provided By: McGraw REALTORS, original listing
Phone: (479) 226-3931
Office Phone: (479) 226-3931
Agent Name: Sherry Hamby
Disclaimer: Copyright © 2024 Fort Smith Board of Realtors. 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