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

713 Chestoa Trail
Aberdeen, NC 28315

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $443,900
Beds: 4
Baths: 3
Status: Active
SqFt: 2424
Agency: Better Homes and Gardens Real Estate Lifestyle Pro

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2024
Notes: The Bailey.Great room with gas log fireplace with decorative mantle and granite surround in ''Absolute Black''.Kitchen features island, quartz countertops in ''Carrera Retro'', subway tile backsplash in ''Arctic White'' set in a brick pattern, white shaker cabinets, pantry, and dining area; Stainless steel microwave, dishwasher, and gas range.Rear covered porch is perfect for entertaining and is easily accessible through the dining area.Half bath with pedestal sink and oval mirror.Staircase with painted wood balusters.All bedrooms on second floor with access to full bathroom with vanity, tub/shower combination and lvp flooring.Second-floor laundry room with washer/dryer connections and lvp flooring.Primary suite with tray ceiling and crown molding; Primary bathroom with access to walk-in closet, dual sinks with quartz countertop in ''Niagara'', shaker cabinets in ''Charcoal'' with center drawer stack, linen closet, walk-in tile shower, private water closet, and tile flooring.Finished bonus room on third floor!Durable luxury vinyl plank floors throughout the first floor.Front door painted in Sherwin Williams ''Domino'' with transom window and sidelights providing natural light in the foyer.Low maintenance vinyl siding with board and batten accents; Dimensional roof shingles.2-car front-loading garage.Fiber Optic Internet service is available!Energy Plus Certified with a 1-2-10-year builder in-house warranty.
MlsNumber: 100429001


Listing Provided By: Better Homes and Gardens Real Estate Lifestyle Pro, original listing
Name: Better Homes and Gardens Real Estate Lifestyle Pro
Phone: (910) 315-7856
Office Name: Better Homes and Gardens Real Estate Lifestyl
Office Phone: (910) 315-7856
Agent Name: Scott Lincicome
Disclaimer: Copyright © 2024 Better Homes and Gardens Real Estate. 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