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

673 Nugent Lane
Weems, VA 22576
Andrea Holt with IsaBell K. Horsley Real Estate, original listing - (804) 436-6256

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,570,000
Beds: 4
Baths: Full: 5
Status: Active
SqFt: 4514 Square Feet
Agency: IsaBell K. Horsley Real Estate
Agency Phone: (804) 436-6256

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 12 acre(s)
Garage: Garage
Property Type: Other-Single Family Residence
Year Built: 1994
Notes: This property features 12 acres of enchanting woodlands and gently sloping yard leading to a special cove with a sandy beach and pier on the Corrotoman River. Along the way, you'll find a serene pergola shaded by a trumpet vine-entwined arbor, a reflecting pool, and a quarter-mile walking trail through the woods. The home itself is a commanding Colonial style with French Country decor, a center hall and 12-foot ceilings. The home features six fireplaces, six crystal chandeliers and extensive custom molding creating an air of celebration and magic. Upon entering, there’s a formal dining room and sitting room on either side. The magnificent kitchen includes gleaming quartz everywhere, sleek appliances, and a breakfast nook overlooking the water. The kitchen is open to the living room with built in bookshelves and fireplace. The sunroom offers an elegant swing bed and waterside terrace. The primary bedroom suite measures a generous 29’ x 15’ and is on the first floor. On either side of the grand center hall upstairs are additional bedrooms, and 2 full baths. And a waterside balcony at the end. The basement provides ample storage, a finished rec room and a screened porch; a cool retreat in the summer. Outside, a gated entrance and paved driveway welcome you leading to a boxwood-lined circle. The home has a 2-car attached garage and an additional 3-bay detached garage with storage over top that could be a guest house or AirBnb or barn. The house is located a short drive from restaurants and other amenities in Irvington, Kilmarnock & White Stone.
MlsNumber: --
ListingId: 2504403


Listing Provided By: IsaBell K. Horsley Real Estate, original listing
Phone: (804) 436-6256
Office Phone: (804) 436-6256
Agent Name: Andrea Holt
Disclaimer: Copyright © 2025 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