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

2364 Huguenot Trail
Powhatan, VA 23139

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,600,000
Beds: 4
Baths: 5
Status: Active
SqFt: 5152
Agency: Napier Old Colony Realtors, Inc. t/a Napier Realto

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1988
Notes: First offering on this exquisite, all brick Georgian home on 20 acres, just 7 miles from Route 288 on historic Huguenot Trail! Detailed throughout with impressive multi member trim, beautiful hardwood floors, custom built in cabinets in several rooms, wainscotting and dentil moldings.  The large entry foyer welcomes guests as they step on the gorgeous marble floor and two story ceiling with stairs to 2nd floor. A formal dining room, with a fireplace flanked by built-in cabinets is elegant and holds a buffet size table and extra serving cabinets.  Enter into a gourmet kitchen with a 6 burner Viking gas range on the island, handsome cherry cabinets and tile backsplash and a breakfast area overlooking the  huge family room with massive brick fireplace and Cathedral ceiling.  A wet bar with custom cherry cabinets is perfect for entertaining. In addition on the 1st floor is a sunroom with tile floor, the classy, custom library/study features excellent detailed moldings, built in bookcases and raised panel lower walls.  A formal living room flows into the study.  The 2nd floor has a very pretty primary suite with Fireplace, a large updated bath, plus a suite room where one finds two walk-in closets and back stairs to the 1st floor. Three  additional bedrooms and two baths, with ample closets and a steps to a finished 3rd floor for a bonus recreation room. 20 acres, in two parcels, with a barn for outdoor pets, private access to the James River at the end of the private road, landscaped yards with paved circle driveway.  Easy access to central Powhatan and Route 288 makes this property a must if looking for land and convenience. Large low maintenance decking can be found off the back rooms and overlook the yard and field. There is extra parking space and a two car garage with openers This sale covers 2 properties, one 10 acre plot with the home (018-2-1)and a second adjacent 10 acre plot (018-2-2) with a stable on it. Home is close to Fine Creek the drive from Chesterfield is relaxing and beautiful.
MlsNumber: 2412695


Listing Provided By: Napier Old Colony Realtors, Inc. t/a Napier Realto, original listing
Name: Napier Old Colony Realtors, Inc. t/a Napier Realto
Phone: (804) 794-4531
Office Name: Napier REALTORS ERA
Office Phone: (804) 794-4531
Agent Name: Dianne Long
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