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

18543 Cove Creek Drive
Chesterfield, VA 23130
Stephanie Harding with Providence Hill Real Estate, original listing - (804) 512-4999

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $811,560
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3332 Square Feet
Agency: Providence Hill Real Estate
Agency Phone: (804) 512-4999

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Welcome to the Legacy Park section of Magnolia Green! This Linwood floorplan is a family sized favorite! The farmhouse exterior with large covered front porch, side load garage, and stained 8-foot door attracts the eye and begs to learn more. As you walk in, you're greeted by the open dining area to one side of the foyer and private study on the other. The spacious family room with wood-stained beams, gas fireplace and substantial natural light will draw you in further. Luxury awaits you in the gourmet kitchen with wall oven, gas cooktop, hood vented to the exterior, quartz countertops, upgraded cabinets, and tile backsplash. Mud room with drop zone from the 2-car garage and walk-in pantry is located behind the kitchen. An eat-in nook area open to family room provides access to large covered 10x18 back porch and your landscaped backyard. Hardwood floors and craftsman trim throughout 1st level. Gorgeous, stained oak stairs lead you to the bedroom level. Very large primary suite with sitting area, two spacious walk-in closets, and the luxury bath with slipper tub and elongated ceramic shower. Three additional bedrooms, full bath, laundry room, and loft take up the rest of second level. Upgraded carpet floors in bedrooms, craftsman trim, and tiled baths and laundry complete this showstopper ready for you to call HOME! This amazing new home is permitted and can be completed as quick as 4 months! Cut your wait short and stop by our model home to learn more. *Disclaimer* Photos from builder's library of the Linwood floorplan.
MlsNumber: --
ListingId: 2428234


Listing Provided By: Providence Hill Real Estate, original listing
Phone: (804) 314-8666
Office Phone: (804) 512-4999
Agent Name: Stephanie Harding
Disclaimer: Copyright © 2024 Central Virginia Regional Multiple Listing Service. 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