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

101 E Oakland St
Hemingway, SC 29554
Brittney Burgess with eXp Realty LLC, original listing - (888) 440-2798

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $200,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 2150 Square Feet
Agency: eXp Realty LLC
Agency Phone: (888) 440-2798

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1919
Notes: Welcome to 101 East Oakland Street, a charming gem located in the heart of historic Hemingway, South Carolina. This beautifully maintained home boasts a range of captivating features that set it apart. Upon entering, you’ll find spacious living areas that invite you to relax and unwind. The completely renovated kitchen includes modern appliances, ample counter space, and a generous walk-in pantry, making it a chef's dream. Large scenic windows throughout the home fill the space with natural light, highlighting the stunning original hardwood flooring and creating a warm, welcoming atmosphere. The cozy fireplace serves as a perfect focal point for gatherings, while the sun-room offers a serene retreat to enjoy your morning coffee or read a book in peace. The exterior of the home is equally impressive, featuring a charming covered front porch, perfect for sipping sweet tea on warm Southern evenings. Additional outdoor amenities include storage space and an outdoor sink, ideal for gardening or other outdoor projects. This property, with its versatile design, presents a unique opportunity for various uses, including a charming home/office, a delightful bed and breakfast, or a multi-unit rental. The potential is limitless, making it an ideal investment for the forward-thinking buyer. Conveniently located downtown, you’ll have easy access to the quaint shops and vibrant community that epitomize small-town Southern charm. Don't miss your opportunity to explore all that this distinctive property has to offer. Schedule your tour today and envision the possibilities that await you in this remarkable home!
MlsNumber: --
ListingId: 20243130


Listing Provided By: eXp Realty LLC, original listing
Phone: (843) 373-1278
Office Phone: (888) 440-2798
Agent Name: Brittney Burgess
Disclaimer: Copyright © 2024 Pee Dee Realtor Association. 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