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

41 Wooldridge Cove
Deltaville, VA 23043

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $689,000
Beds: 3
Baths: 3
Status: Pending
SqFt: 2174
Agency: IsaBell K. Horsley Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Other
Year Built: 1990
Notes: Sharp and sophisticated with a Carolina flair, this waterfront home is gleaming from the mailbox to the boatlift. Outdoor living is abundant, featuring a sun-soaked deck, a recently added (2023) veranda complete with a durable Metal Roof and ceiling fan for blissful summer afternoons, a patio with Spa off the Primary Bedroom, and a Pier offering a serene spot to appreciate the water, complete with a 10,000 lb boatlift and skiff lift. The front entrance welcomes you with Carolina shutters, imparting a casual and friendly ambiance. Impeccably maintained, the interior boasts a first floor with a welcoming sitting room and dining area. Hardwood floors through most of the main level. The kitchen, equipped with new granite countertops and stainless steel appliances, seamlessly flows into the breakfast room and den, all with picturesque views of Moore's Creek. A fireplace with gas logs adds warmth and coziness in the den. Plantation shutters grace most of the home, enhancing its timeless allure. The primary bedroom ensuite, conveniently located on the main level, caters to one-level living, while two upstairs bedrooms for guests share a remodeled bath with a walk-in shower and glass doors. A recent addition includes a 10’ x 20’ workshop adjacent to the two-car attached garage perfect for lawn mower or golf cart. Situated in the inviting community of Lucy’s Cove, this residence is just minutes away from essential amenities such as a grocery store, farm market, and, for boaters, West Marine, providing waterfront living and convenient accessibility.
MlsNumber: 2404691


Listing Provided By: IsaBell K. Horsley Real Estate, original listing
Name: IsaBell K. Horsley Real Estate
Phone: (804) 436-6256
Office Name: IsaBell K. Horsley Real Estate
Office Phone: (804) 436-6256
Agent Name: Andrea Holt
Disclaimer: Copyright © 2024 Chesapeake Bay & Rivers Association of Realtors. 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