Title Page Background
DEBUG FN args: Array ( [0] => 2175 [1] => [2] => [3] => agent ) BEFORE: Site: 2175 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2175 Igate: njhud LocID: 2175 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2175 AND i.igate IN ('okhud','usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'okhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2175 [1] => [2] => [3] => lender ) BEFORE: Site: 2175 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2175 Igate: njhud LocID: 2175 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2175 AND i.igate IN ('okhud','usahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'okhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2175 [1] => [2] => [3] => other ) BEFORE: Site: 2175 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2175 Igate: njhud LocID: 2175 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2175 AND i.igate IN ('okhud','usahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'okhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

1221 E 2nd
Sulphur, OK 73086

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $275,000
Beds: 4
Baths:
Status: Active
SqFt: 2184 Square Feet
Agency: Pebbles Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1920
Notes: Historic Charm Meets Modern Comfort in Sulphur, OK!<br /> Step into the allure of yesteryears with this enchanting 1920s home nestled in the historic heart of Sulphur. Brimming with character and boasting a blend of timeless elegance and contemporary convenience, this property invites you to experience the best of both worlds. As you enter, be greeted by the warmth of original hardwood floors, meticulously preserved to honor the home's heritage. The main floor offers a flexible layout, with the option to utilize one of the four bedrooms as a home office, catering to the demands of modern living. Upstairs, discover a haven of tranquility with three cozy bedrooms and two bathrooms, providing ample space for rest and relaxation. The convenience of a half bathroom downstairs adds to the functionality of this charming home. Savor the joy of cooking in the well-appointed kitchen, where all appliances, await your culinary adventures. Washer and Dryer will remain with the property as well. Embrace the beauty of natural light streaming through newly installed Anderson windows downstairs, illuminating the interior with a welcoming glow. This home boasts central heat and air downstairs, while window units upstairs ensure personalized climate control. Situated on a corner lot, enjoy the privacy of a fenced yard, perfect for outdoor gatherings or relaxing evenings. Additional features include a large carport, ideal for protecting vehicles from the elements, and a convenient storage shed for stowing away seasonal items. Plus, with a new roof on the horizon, you can rest assured knowing this home is both charming and well-maintained. Located in a prime location this property offers a lifestyle of comfort and convenience. Don't miss the opportunity to own a piece of Sulphur's history while enjoying modern amenities. Schedule your showing today and make this charming residence your own!
MlsNumber: --


Listing Provided By: Pebbles Real Estate, original listing
Phone: (580) 618-1622
Office Phone: (580) 369-3500
Agent Name: Liz Dilbeck
Disclaimer: Copyright © 2024 MLS Technology, 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