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;

2104 Old Prescott Place
Henrico, VA 23238
Blake Eudailey with BHHS PenFed Realty, original listing - (804) 916-3300

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,225,000
Beds: 6
Baths: Full: 6, ½: 3
Status: Active
SqFt: 6108 Square Feet
Agency: BHHS PenFed Realty
Agency Phone: (804) 916-3300

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1999
Notes: West End Classic & Modern Colonial Home with 6 Bedrooms (possibly 7) each with Full Bathrooms, a 3 Car Garage, & made for entertaining! The gracious entry Foyer leads into the Center Hall with Granite Wet Bar with builtin Ice Maker (2022) & Wine Cooler, French Doors open into Dining & Living Rooms. 23 x 13 Modern Granite Custom Kitchen with 6x3 Granite Center Isle/Bar, custom paneled Refrigerator, newer appliances, Mosaic Tile Backsplash. The Breakfast Area opens into the 29’ Great Room with amazing views of the Pool/Patio areas and walks out to the 21’ x 11’ Covered Porch which steps onto the inviting hardscapes with custom shaped inground Pool surrounded by expansive cobbled paver Patios and stacked stone retaining walls with bench top seating, outdoor lighting & sound, guarded by a private wooded area. There are two solid masonry brick Pool Houses (9x8 Half Bath/Dressing Building; 8x8 Storage Building). If it is raining, escape to the 26 x 17 Media/Theater Room with surround sound, Half bath, and Media Mechanical Room. Primary Bedroom with Walk-in Closet, private tile Bath with separate Shower & Jetted Tub. Wood Floors, custom built-in Bookcases, and Handsome Moldings throughout with Dental Crown Moldings & Wainscot Moldings in formal areas. Third Floor is ideal private suite with Bedroom, Office/Den Area, Full Bath, and 21 x 15 Flex Room (possible 7th BR); Basement Recreation Room with Full Bath (possible suite for Handicap accessible space), Fireplace, wall of Builtin Bookcases, and opens onto a 21 x 13 separate & private Patio. Numerous updates & improvements including 3 Zone Heatpumps (new in 2020) with Gas Backup, 80 gallon Electron Water Heater (2018), New 50 Year Roof in 2008, low maintenance Brick & Hardiplank (freshly painted in 2022) exterior, low maintenance Gutters with leaf guards. Wooded .56 Acre Lot with a Quiet Cul de Sac location, Paved Drive, 3 Car Garage. This is truly a West End oasis, both your home and your vacation home, within walking distance to Godwin High School!
MlsNumber: --
ListingId: 2426347


Listing Provided By: BHHS PenFed Realty, original listing
Phone: (804) 916-3300
Office Phone: (804) 916-3300
Agent Name: Blake Eudailey
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.


Local Real Estate Expert

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;
Angelica DelliCarpini
ASCIIDF Real Estate & Land Resources, LLC
Call Today!: (804) 569-5115

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App