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;

649 Kennsbury Road
Middlesex, VA 23070

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,250,000
Beds: 3
Baths: 5
Status: Active
SqFt: 3600
Agency: Village Concepts Realty Group

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential
Year Built: 1990
Notes: Welcome to your slice of paradise nestled along the serene waterfront! Escape to a secluded cabin-style oasis set on a sprawling 3+ acre plot by the tranquil shores of Healy's Creek. Enjoy over 500 feet of waterfront, including a pier with 7000lb boat lift, perfect for endless waterfront activities. Enjoy panoramic views of the shimmering water from every angle of your expansive decking. Whether it's a morning coffee or an evening cocktail on the screen porch, every moment is enhanced by the tranquil beauty of the waterfront. The current owner has completed some amazing additions & upgrades and spared no expense. Inside, discover a versatile layout ideal for any gathering, offering vaulted stained wood ceilings throughout this amazing custom home and updates catering to various interests. In the Main House embrace the stunning waterfront views from every corner of the open-concept home, offering a well-appointed kitchen with new appliances, a primary suite with newly upgraded bath with steam shower, Large walk-in Closet with endless views of the serene waterfront. Outside, indulge in a heated inground ionized pool surrounded by luxurious travertine tile, accompanied by a hot tub and a charming pool house featuring custom cabinetry, vaulted ceilings, and convenient amenities. Cozy up by the crackling fireplace on the stone patio, where every evening feels like a retreat. Gather with loved ones, roast marshmallows, and create cherished memories against the backdrop of the glistening water. Located at the Piankatank River and Chesapeake Bay, the complete waterfront retreat with spectacular views on a protected hurricane harbor. Indulge in waterfront living at its finest and make every day a vacation. Your dream lifestyle awaits at this exquisite waterfront retreat. Contact us today to schedule a private tour and experience the epitome of coastal luxury!
MlsNumber: 2411040


Listing Provided By: Village Concepts Realty Group, original listing
Name: Village Concepts Realty Group
Phone: (804) 598-4343
Office Name: Village Concepts Realty Group
Office Phone: (804) 598-4343
Agent Name: Shelly Blair
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