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

320 Lloyds Rd
Champlain, VA 22438
Isaiah Benton with Samson Properties, original listing - (540) 681-1500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $359,999
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1400 Square Feet
Agency: Samson Properties
Agency Phone: (540) 681-1500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Welcome to your dream home! 1400 Sq Ft Nestled on over 6 Acres of land in the serene countryside, this brand-new 3-bedroom, 2-bathroom home offers the perfect blend of modern comfort and rural tranquility.<br /> <br /> Step inside to discover an open-concept layout filled with natural light. The spacious living area flows seamlessly into a contemporary kitchen, complete with sleek countertops, custom cabinetry, and brand-new stainless steel appliances.<br /> <br /> The primary suite is a private retreat, boasting a luxurious en-suite bathroom and ample closet space. Two additional bedrooms provide plenty of room for family, guests, or a home office.<br /> <br /> One of the standout features of this home is the covered back deck looking over the Beautiful back yard , perfect for enjoying peaceful mornings with a cup of coffee or entertaining guests while taking in the stunning views of your expansive property.<br /> <br /> With over 6 acres to call your own, the possibilities are endless. Whether you dream of gardening, creating outdoor living spaces, or simply enjoying the beauty of nature, this property offers it all. Great back yard to with Endless possibilities. <br /> <br /> Located just a short drive from Tappahannock and Fredericksburg, you'll enjoy the convenience of nearby amenities while savoring the peace and privacy of country living.<br /> <br /> Don't miss this opportunity to own a brand-new home with room to roam. Schedule your private showing today!
MlsNumber: --
ListingId: VAES2000772


Listing Provided By: Samson Properties, original listing
Phone: (703) 896-5869
Office Phone: (540) 681-1500
Agent Name: Isaiah Benton
Disclaimer: Copyright © 2025 Bright MLS. 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