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

124 Lakeway Drive
Cheraw, SC 29520
Mary Anderson with Lewis Realty, original listing - (843) 921-2002

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $434,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3113 Square Feet
Agency: Lewis Realty
Agency Phone: (843) 921-2002

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1960
Notes: Get ready to be blown away by the transformation this home has recently undergone! Once you see the sophisticated choices in decor and read about the extensive renovations, you will find comfort knowing this is not a traditional "flip." New roof with 30 year, architectural shingles, new Trane HVAC, refinished hardwood flooring, updated electrical outlets, quartz kitchen countertops, all new appliances, extensive bathroom renovations with beautiful vanities, gorgeous new light fixtures throughout, and much, much more! The lay-out of the home has great flow! Upon entry, you will be welcomed in to a combined and open formal living/dining area, spacious den, and large kitchen, which has plenty of room for informal, "eat-in" dining. Also on the main floor, you'll find four bedrooms and two fabulous, new bathrooms. The primary suite has great flex space which could serve as additional closet space, or it could be a perfect place for a home office (3D renderings are available). An area off the kitchen has plenty of additional flex space (mudroom/pantry/storage) and a full bathroom. This home also has the added bonus of a walk-out basement with over 400 sq. ft., which has fresh sheetrock throughout and is heated and cooled. There is a modest toilet and shower there, as well. Outside, you can appreciate time on the wonderful patio, the updated landscaping, and a new driveway. Located on a quiet street very close to town, parks, schools, and shopping, this one is a dream realized! Make an appointment to see it today!
MlsNumber: --
ListingId: 20242245


Listing Provided By: Lewis Realty, original listing
Phone: (843) 910-1934
Office Phone: (843) 921-2002
Agent Name: Mary Anderson
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