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

223 Meridian Street
Meridian, OK 73058

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $140,000
Beds: --
Baths: 2
Status: Active
SqFt: --
Agency: Homestead & Co

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2012
Notes: Welcome to this versatile property nestled in the heart quaint small town Meridian! Currently a cherished place of worship, this spacious corner lot (approx 1/3 acre) endless possibilities. It's an ideal canvas for crafting your dream home or establishing a thriving business. With 1.5 bathrooms, including a handicap accessible shower, with each bathrooms including closet for extra storage, convenience is paramount. The layout features two generously sized rooms, ready to be transformed to suit your needs—whether it's creating a cozy living space, commercial venture, or a blend of both. Storage is abundant throughout the property, with a walk-in pantry in the kitchen providing ample space for essentials. The kitchen itself is a chef's delight, offering an abundance of counter & cabinet space for culinary creations. Portable islands with storage adds flexibility to the space, perfect for meal prep or casual dining. In addition to its versatile layout, it offers an extra room currently utilized as an office space, complete with a sink and additional storage. This thoughtful addition provides the flexibility to comfortably work from home or establish a convenient workspace for business endeavors. Whether it's for administrative tasks, crafting, or creative pursuits, this dedicated area enhances the property's functionality and adaptability to suit a variety of needs. With its blend of practicality and charm, this property presents a unique opportunity to tailor the space to your specific lifestyle or business aspirations. Additionally, the expansive outdoor patio offers a serene retreat for gatherings or relaxation, providing ample space for entertaining or enjoying quiet evenings under the stars. With the location, adaptable layout, and abundance of amenities, this property presents a rare opportunity to create the lifestyle or business venture of your dreams in a charming small-town setting. Don't miss out on making this versatile property your own
MlsNumber: 1112423


Listing Provided By: Homestead & Co, original listing
Name: Homestead & Co
Phone: (405) 471-1205
Office Name: Homestead + Co
Office Phone: (405) 509-0541
Agent Name: Courtney Smith
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