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

326 S Locust Street
Crescent, OK 73028
Shanna Garrett with EXP Realty, original listing - (405) 748-8500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $183,000
Beds: 3
Baths: Full: 1, ½: 1
Status: Active
SqFt: 1320 Square Feet
Agency: EXP Realty
Agency Phone: (888) 560-3964

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1936
Notes: This stunning home has been remodeled—no detail was left untouched! From the moment you arrive, you’ll love the recently painted exterior, crisp trim, and undeniable curb appeal that warmly welcomes you inside. Step through the through the front door and take in the modern yet inviting atmosphere, featuring updated flooring, a beautiful fireplace, stylish light fixtures, and textured and painted walls throughout. <br /> <br /> The kitchen is an absolute showstopper! Boasting custom cabinetry with soft-close hardware, sleek countertops, and stainless steel appliances, every inch has been thoughtfully designed. From the elegant crystal pulls to the modern lighting, this space truly shines! <br /> <br /> This home is filled with upgrades, including all-new windows for an abundance of natural light. The spacious utility room, conveniently located just off the kitchen with backyard access, also features custom cabinetry for added storage. <br /> <br /> Beyond the beautiful cosmetic updates, the major systems have been taken care of, too! A brand-new heat and air system was installed in 2023, along with updated plumbing and electrical. Plus, there’s a 420 sqft basement, perfect for extra storage or a storm shelter. <br /> <br /> Sitting on a fantastic corner lot in a prime location, this home is just minutes from hwy 74, schools, and shops. With all the right updates and finishing touches, this one is truly move-in ready! Don’t miss your chance to make it yours!
MlsNumber: --
ListingId: 1154672


Listing Provided By: EXP Realty, original listing
Phone: (405) 748-8500
Office Phone: (405) 748-8500
Agent Name: Shanna Garrett
Disclaimer: Copyright © 2025 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