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

19940 E 1030 Road
Hammon, OK 73650
Chelsea Spencer-Randolph with Moxy Realty, original listing - (580) 243-2929

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $379,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2400 Square Feet
Agency: Moxy Realty
Agency Phone: (580) 243-2929

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1981
Notes: This beautifully updated tri-level country home is the perfect blend of modern style and everyday comfort. Featuring custom built-ins on all levels, this bright and airy home features a versatile floor plan with two spacious living areas. The ground level living area is complete with a cozy wood-burning stove, ideal for relaxing or entertaining and the other tucked away downstairs for loads of family fun. The kitchen is adorned with custom cabinets, granite countertops and stainless steel appliances. The kitchen flows effortlessly into a custom built dining banquet and living space, making gatherings a breeze. Upstairs you will find a master bedroom en-suite with large walk-in closet, oversized shower and a balcony view of the property. The upstairs guest room contains a custom cabinet that houses a concealed Murphy bed. Downstairs there is a full bathroom and additional guest room. Step outside onto the property and you will find a 36x58 shop with a built-on carport, a 24X40 shop with two bay doors, insulated 36X18 man cave, loft area and pellet stove. The property has a fenced backyard, storm shelter and water well.Generator, refrigerator and washer & dryer will remain with the home. This is a must see country home!
MlsNumber: --
ListingId: 1156589


Listing Provided By: Moxy Realty, original listing
Phone: (580) 243-2929
Office Phone: (580) 243-2929
Agent Name: Chelsea Spencer-Randolph
Disclaimer: Copyright © 2025 MLSOK, 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