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

104 Peter Francisco Drive
Hopewell, VA 23860
Shanna Story with Parr & Abernathy Realty, Inc., original listing - (804) 452-0505

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $540,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2787 Square Feet
Agency: Parr & Abernathy Realty, Inc.
Agency Phone: (804) 452-0505

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1976
Notes: Welcome to timeless elegance in the heart of Appomattox Heights. This custom-built, all-brick Cape Cod offers 2,787 sq ft of refined living space on over half an acre, perfectly blending classic craftsmanship with modern luxury. From the moment you step into the grand foyer, you're greeted by intricate millwork, gleaming hardwood floors, and gracious entertaining spaces throughout. The formal living room features built-in cabinetry and a gas fireplace, while the library/den offers a warm wood-burning fireplace, custom bookcases, and dual access points for seamless flow. The formal dining room is adorned with a bay window and connects to a beautifully appointed kitchen with granite countertops, stainless steel appliances, wine cooler, breakfast bar, and charming eat-in nook. A private hallway leads to the laundry room with washer/dryer, utility sink, built-in ironing board, and sewing/folding station. Living and private quarters are smartly separated by a pocket door. The spacious primary suite boasts multiple closets and an en-suite bath, while the updated hall bath serves additional bedrooms. A 22x24 attached 2.5-car garage offers ample storage. Upstairs, an unfinished walk-up attic presents 1,716 sq ft of expansion potential.<br /> Outside, indulge in resort-style living. The 16x34 in-ground pool is surrounded by a generous patio—ideal for lounging, alfresco dining, or hosting elegant gatherings. An attached brick pool storage and an additional outbuilding offers versatile storage options. With newer windows, a slate roof, dual-zone gas HVAC, and two hot water heaters, every detail has been curated for comfort and sophistication. This exceptional home is a rare offering—luxury, charm, and entertainment in one of Hopewell’s most desirable neighborhoods. Make your private showing appointment today.
MlsNumber: --
ListingId: 2513621


Listing Provided By: Parr & Abernathy Realty, Inc., original listing
Phone: (804) 452-0505
Office Phone: (804) 452-0505
Agent Name: Shanna Story
Disclaimer: Copyright © 2025 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