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

1265 Hermitage Road
Manakin Sabot, VA 23103

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,525,000
Beds: 4
Baths: 6
Status: Pending
SqFt: 4795
Agency: RE/MAX Commonwealth

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential
Year Built: 2007
Notes: If you've been waiting for the '"I'LL KNOW IT WHEN I SEE IT HOME", Then this is Your Lucky Day!! The Amenities and Features of this Custom Built Home Haven are ENDLESS! Nestled on A Private 3 Acre Lot With a Huge Circular Paver Stone Driveway, this Home offers as much Outdoor Living Space as Indoor Space. The Custom Double Doors Open to a California Style Floor Plan with 10 foot Ceilings, 8 ft. Doors and Doorways, Coffered Ceilings, Beautiful Hardwood Floors and a Grand Open Floor Plan! The Living and Dining Rooms are centered in the Home with the Massive Primary Suite and Office on one Side and the Grand Kitchen with Wolf Appliances, Sub Zero Refrigerator and Family Room with Stacked Stone Fireplace on the Opposite End of the Home! Each Room has Access to the Incredible 750 sq. ft of Decking Across the Rear of the Home! There are an Additional 2 Ensuite Bedrooms on the First Floor as well as the Laundry Room and access to the Three Car Garage! The Second Floor Suite has A Private Rear Staircase, Full Bath and Terrace Overhang. The Walk Out Basement Offers a Huge Recreation Room, Custom Kitchenette and Another Full Bath! If this Isn't Enough, The Entertaining Continues to the Rear Yard with Patio Dining area AND THAT Pool! Yes, this IS "THAT" POOL! Custom Designed with Terraced Stairs Surrounding the Built-in Hot Tub Niche, the Massive Area of Gorgeous Hampton Limestone Decking details the 18' x 36' Custom Heated and COOLED, Saltwater Gunite Pool with PebbleTec finish, Automatic Pool Cover and Built-in Water Ledge with an Umbrella Stand!! The Large Outdoor Stone Fireplace adds to the Ambiance of the Pool's Aura! The Acreage offers enough Lawn for Gardening, Outdoor Sports and Play but Also is Beautifully Wooded for Privacy, a Perfect Combination! Add to this a whole house generator. Located Across from the Hermitage Country Club, This New Listing is Truly One of a Kind!
MlsNumber: 2408094


Listing Provided By: RE/MAX Commonwealth, original listing
Name: RE/MAX Commonwealth
Phone: (804) 288-5000
Office Name: RE/MAX Commonwealth
Office Phone: (804) 360-5200
Agent Name: Janice Taylor
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