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

304 E Valley Road
Lequire, OK 74943
Terra Geralds with Property Solutions Real Estate, original listing - (888) 220-0988

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $155,000
Beds: 5
Baths: Full: 2
Status: Pending
SqFt: 1725 Square Feet
Agency: Property Solutions Real Estate
Agency Phone: (918) 457-4100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1970
Notes: Peaceful Country Living with Room to Roam – 5 Bed, 2 Bath on 0.5+ Acre in Lequire, OK<br /> <br /> Tucked away in the quiet community of Lequire, OK, this 5-bedroom, 2-bath home offers the perfect blend of comfort, space, and privacy. Situated on over half an acre, this 1,725 sq ft property features an open floor plan, metal roof, and wooded land on both sides, giving you the country feel you’ve been looking for.<br /> <br /> A gated entry and full fencing with privacy panels at the front and rear provide both security and seclusion. Inside, you’ll find new vinyl windows, ceiling fans throughout, and a thoughtfully designed primary suite featuring three stylish barn doors, an en-suite bathroom, and a massive walk-in closet.<br /> <br /> Need more space to relax or entertain? Enjoy a newly added hot tub room with hot tub, or cool off in the above-ground pool during Oklahoma summers. The backyard is set up for fun and function with a barn (gravel floor), 8x10 portable building, a sandbox, and even a 6-person storm shelter for peace of mind.<br /> <br /> This home is farm-animal friendly and just 15 minutes from Stigler, where you’ll find shopping, restaurants, medical services, and a movie theater. The current owner enjoys the convenience of Walmart grocery delivery right to the home.<br /> <br /> If you’re looking to escape the hustle and bustle but still want to stay connected, this property checks all the boxes.
MlsNumber: --
ListingId: 2520896


Listing Provided By: Property Solutions Real Estate, original listing
Phone: (918) 869-1877
Office Phone: (888) 220-0988
Agent Name: Terra Geralds
Disclaimer: Copyright © 2025 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