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

8127 N Cleveland St
Enid, OK 73703
Jenny Smithson with Lippard Realty LLC, original listing - (580) 548-4663

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,500,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: --
Agency: Lippard Realty LLC
Agency Phone: (580) 548-4663

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 21 acre(s)
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Experience this magnificent home set on over 21 acres. Custom-built in 2018, this residence features 3,995 square feet of thoughtfully designed living space. It includes three spacious bedrooms, each equipped with its own en suite bathroom and walk-in closet. Upon entry, you'll be greeted by a stunning wood cathedral ceiling that leads into a large living room with captivating views of the gas fireplace and outdoor area. The kitchen is a culinary enthusiast's paradise, complete with multiple ovens, a Sub-Zero refrigerator, built-in ice maker, microwave, and a two-drawer dishwasher. Custom cabinet features include spice drawers and a mixer lift, along with an impressive U-shaped workspace and a generous breakfast nook. A spacious walkthrough pantry will satisfy even the most selective chef. This home also boasts a convenient laundry room with a sink and built-in space for an upright freeze. Completing the home is a half bath, a large formal dining area, and a sizable office with solid wood double doors featuring beautiful glass inlay. Additional highlights include heated flooring throughout, built-in blinds in all windows, two water wells, multiple geothermal systems for heating and cooling, on-demand hot water, a water softener, and a sprinkler system for easy yard maintenance. The stunning hardwood floors enhance the home's architectural style. Step outside to discover even more features to love. Solar panels efficiently generate electricity for both the home and shop, helping to reduce OGE electric utilities. The impressive shop spans 125'x75' and includes heated floors and three geothermal units for a comfortable work environment. It is equipped with three automatic overhead doors (14x14), a 50 AMP RV hookup, two welding plugs, ceiling fans, floor drains for easy cleaning of equipment, a water softener, and an air compressor. In the shop, you'll also find a "Man Cave" or living quarters complete with a bathroom, kitchen, and washer & dryer. There is also an upstairs loft area great for storage and office area featuring a built-in desk. The shop benefits from spray foam insulation in the walls and double insulation in the ceiling. The property’s exterior offers amenities such as a heated inground swimming pool and a lovely stone water feature. Landrun sod, a sprinkler system, and an 18-foot deep pond, which adds to the serene ambiance of this truly exceptional property. A 48KW Generac Generator ensures the home and shop remain operational during power outages. There are two exterior RV hookups and a sewage dump available. All electrical lines serving the property are buried for safety and aesthetics.
MlsNumber: --
ListingId: 20250273


Listing Provided By: Lippard Realty LLC, original listing
Phone: (580) 747-6225
Office Phone: (580) 548-4663
Agent Name: Jenny Smithson
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