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

17490 General Puller Highway
Deltaville, VA 23043
Andrea Holt with IsaBell K. Horsley Real Estate, original listing - (804) 436-6256

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Other-Single Family Residence
Year Built: 1932
Notes: Step into this "like-new" gem where charm meets modern convenience! Every inch of this home has been thoughtfully updated in 2023, ensuring it's ready for you to enjoy full-time or part-time living. Highlights of the recent Updates Include: Kitchen Renovation: Quartz countertops, Brand-new cabinetry, and sleek stainless-steel appliances. Enclosed Porch: Finished with new windows, a door, and a utility closet housing a brand-new water heater, washer, dryer and water softener. Flooring & Lighting: Fresh new floors upstairs and downstairs, complemented by updated fans and lighting for a bright and contemporary feel throughout. One bedroom home plus a Bonus room for overflow sleeping. Bathrooms: Updated with new fixtures. Exterior & Roofing: New siding, fresh paint, and Brand-New Roofs on both the house and shed!! Driveway: Amazing new concrete driveway for easy access and curb appeal. Extra Features You'll Love: Tesla charging station. Ample space for boat parking with easy access to marinas and ramps. Location Perks: Located within 0.1 miles of Deltaville's favorite amenities: the coffee shop, library, hardware store, churches, post office, and more. This delightful home offers convenience, charm, and updates galore—don’t miss your chance to call it yours!
MlsNumber: --
ListingId: 2431119


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 © 2024 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