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

339756 E Highway 62 Highway
Meeker, OK 74855
Ney Briggs with Ariston Realty LLC, original listing - (405) 802-1174

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $235,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Ariston Realty LLC
Agency Phone: (405) 802-1174

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Land-Other
Year Built: --
Notes: PRICE REDUCED!!! Discover the perfect space to build your dream home or establish a business on this expansive 5-acre property. Professionally cleared and meticulously maintained, this land is ready for construction and versatile enough to meet both residential and commercial needs. Key features include a spacious 40’ x 50’ building, equipped with two 12’ doors, a convenient walk-in door, and three well-placed windows (two 2.5’ x 3’ windows and a larger 2.5’ x 3’ double window in the front). This well-equipped building also features a crane and car lifter, making it ideal for a workshop or business use. The infrastructure is top-notch, with a brand-new septic system located in the northeast corner and a new water well positioned at the front of the property, near the 8 all steel beam carport and container. The property also includes an existing sewer system and is fenced on three sides, with sturdy wire and pipe fencing in the front for added security. For extra storage or workspace, a separate 8 car carport slopped to drain properly adds convenience. The container outside is reserved but available for separate purchase, offering additional flexibility. Additionally, this property features a 2,000 sq. ft. building with a 6 to 8-inch steel-reinforced concrete floor, constructed in the 1960s and still without cracks. Other features include a solid pad foundation and a gravel driveway. Lots of native brown stone to be sold or used off the property. Wind break and plenty of firewood left to west of property. With ample space and built-in infrastructure, this property offers endless possibilities. Don’t miss this rare opportunity to own a versatile and well-prepared property!
MlsNumber: --
ListingId: 1134205


Listing Provided By: Ariston Realty LLC, original listing
Phone: (405) 802-1174
Office Phone: (405) 802-1174
Agent Name: Ney Briggs
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