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

510 N Second Street
Texhoma, OK 73949-9999
Nancy Freeman with Realty House, original listing - (580) 338-6659

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $230,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: --
Agency: Realty House
Agency Phone: (580) 338-6659

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Wonderful Family home with all the necessities, Central heat /Air conditioning, 3 nice size bedrooms and 2 bathrooms, brick, privacy fence, a safe room, outside storage with room for a large lawnmower or additional tools, the double car garage has a remote controls for easy access, it boasts a covered patio, draperies, new carpet and new wood flooring, all walls are freshly painted, 7 ceiling fans, open floor plan with separate entry, established landscaping and yard, sidewalk, and inviting fireplace. This is a must see home and won't last long; great location with excellent Texhoma Schools, student sports, music, and computer programs and clubs with competitive teams prepared for growing families and future young leaders. Texhoma has exceptional churches and youth groups. Texhoma provides convenience banking for the community at Anchor D Bank. No Man's Land Cafe has excellent food and homemade desserts. Texhoma is the home of Texhoma Livestock Commission, El Burro Mexican Cafe, the new Jatta Coffee , Soup, and Sandwich Shop, The Crystal Boot, are, all located on Hwy 54. Today's and Yesterdays and Fire Department with emergency services are downtown, while the public swimming pool, beautiful parks, football field, baseball/softball fields, and newly remodeled THS gymnasium create a positive atmosphere for families, young life, and seniors wanting a safe and productive place to call home.
MlsNumber: --
ListingId: 20250031


Listing Provided By: Realty House, original listing
Phone: (405) 308-6142
Office Phone: (580) 338-6659
Agent Name: Nancy Freeman
Disclaimer: Copyright © 2025 Northwest Oklahoma Association 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