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','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 = 2190 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 = 2190 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;

9472 N 2020 Road
Hammon, OK 73650
Amber Aker with Moxy Realty, original listing - (580) 243-2929

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $449,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3730 Square Feet
Agency: Moxy Realty
Agency Phone: (580) 243-2929

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2009
Notes: Country Living Just Outside of Town!<br /> <br /> Discover the perfect blend of peaceful country living and modern convenience with this stunning custom-built Culver home, located just 1.5 miles outside of town. Spanning a little over 3700 sq ft, this spacious home features 4 bedrooms, 3.5 baths, and a versatile office that can easily be converted into a 5th bedroom. Designed with a split floor plan, the home boasts two primary suites, each with private baths, and over oversized closets in every room, offering plenty of storage space.<br /> <br /> Enjoy two comfortable living areas, perfect for entertaining or relaxing. Situated on 2 scenic acres, the property also includes a 30x40 workshop with electricity--ideal for hobbyists or additional storage.<br /> <br /> This is country living at its finest, with the conveniences of the town and school just minutes away!<br /> <br /> This home has been well-maintained and cared for over the last few years. New carpet was installed throughout the house in May 2022, the septic tank cleaned out in May 2022, a new back door and new center glass in the front door, replacement blinds to Primary bath and Kitchen windows, and updated light kits in 2nd Primary bath and Guest bath.<br /> <br /> The home also receives annual service by Clouds Landscaping, quarterly pest control service by Day's Pest Control, and quarterly service by Culligan for the water softener and reverse osmosis system.
MlsNumber: --
ListingId: 1140642


Listing Provided By: Moxy Realty, original listing
Phone: (405) 696-3146
Office Phone: (580) 243-2929
Agent Name: Amber Aker
Disclaimer: Copyright © 2024 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