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

1576 Folly Road
Ophelia, VA 22473
April Caldwell with Samson Properties, original listing - (703) 378-8810

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $930,000
Beds: 6
Baths: Full: 4
Status: Active
SqFt: 3444 Square Feet
Agency: Samson Properties
Agency Phone: (703) 378-8810

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 1990
Notes: Discover your own slice of paradise in the heart of the Northern Neck. This charming ranch-style home offers the perfect blend of comfort, space, and coastal charm. Recently renovated with brand new wood flooring, a spacious deck, and a luxurious master suite with a walk-in closet and Jacuzzi tub, this property offers the perfect blend of comfort and modern amenities. Enjoy spacious living with four bedrooms, including a master suite with a private bath and direct access to the back deck. The guest house adds an additional two bedrooms and its own kitchen, providing ample space for family or guests. (There are 2 master bedrooms). Unwind on the expansive deck, overlooking the lush landscaping, fruit trees, and a serene lily garden. A fenced-in area ensures a safe haven for pets. Immerse yourself in the beauty of the Chesapeake Bay. Nearby attractions include Sunny Bank Ferry, VirMar Beach, public boat ramps, marinas, waterfront restaurants, and opportunities for fishing, crabbing, and dolphin watching. The recently renovated kitchen boasts a wall oven and adds a touch of contemporary style. Relax by the cozy fireplace on chilly evenings. Situated on a sprawling 4.48-acre lot, the property offers ample space for gardening, outdoor activities, or simply enjoying the peaceful surroundings. Delight in the bounty of nature with apple trees, pear trees, and blueberry bushes that produce delicious harvests. Located just 5 miles from VirMar Beach, 20 minutes from Kilmarnock, and 15 minutes from Reedville.
MlsNumber: --
ListingId: 118097


Listing Provided By: Samson Properties, original listing
Phone: (804) 450-2775
Office Phone: (703) 378-8810
Agent Name: April Caldwell
Disclaimer: Copyright © 2024 Northern Neck 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