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

1761 Jc Loop
Valliant, OK 74764
Heather Howell with HST & Co LLC, original listing - (870) 478-7653

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,900
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 3504 Square Feet
Agency: HST & Co LLC
Agency Phone: (870) 478-7653

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Garage: Garage
Property Type: Residential-Farm
Year Built: 1996
Notes: Secluded Little River Frontage Hideaway in McCurtain County, OK! Dreaming of privacy and a country river retreat? Look no further! This 8-acre waterfront property on the high banks of Little River boasts a waterfront home with stunning recent upgrades. Property Highlights - Custom Home:3504 sq. ft., built in 1996, remodeled in 2001 and 2020. - Luxurious Features:Remodeled master loft suite, new windows throughout, and an open, airy feel. Multiple outbuildings and shops recently added. One two story 25x100 Spray foam insulation 600 amp, single phase and water hydrant, Second shop is 24 x 16 with separate power pole with 200 amp and RV hook up fully insulated with a separate water hydrant. - Spacious Living: 3 bedrooms, 2 bathrooms, and ample storage for large families. - Outdoor Bliss: Enjoy the pool overlooking Little River for peaceful, relaxing afternoons. Recreational Paradise: - Fishing:Freshwater fishing for crappie, catfish, perch, and bass. - Hunting:Whitetail deer, Eastern wild turkey, squirrels, and rabbits roam the property. Prime Location: - 2.35 hours to Dallas, TX - 3 hours to Tulsa, OK - 3.25 hours to Oklahoma City, OK - Close to Pine Creek Lake, Hugo Lake, McGhee Creek Lake, Sardis Lake, and Broken Bow Lake/Beavers Bend/Hochatown. This secluded gem offers endless recreational adventures-don't miss out on owning a slice of paradise!
MlsNumber: --
ListingId: 11385298


Listing Provided By: HST & Co LLC, original listing
Phone: (405) 614-9081
Office Phone: (870) 478-7653
Agent Name: Heather Howell
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