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

2813 Hilton Road
Hiltons, VA 24258
Seth Jervis with eXp Realty, LLC, original listing - (888) 519-5113

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $728,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 6067 Square Feet
Agency: eXp Realty, LLC
Agency Phone: (888) 519-5113

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 47 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1890
Notes: If Victorian farmhouse wasn't a style of home before, it is now: covered front porch, classic white exterior and the quintessential turret. This 1890s home demands the attention it deserves from the road alone. And the charm carries over to the inside. The classic farmhouse foyer and staircase greets you upon entry. To the left, a warm, wood paneled office accented with an ornamental fireplace and intricate mantle. Just ahead is a large living space with access to an elevator that goes up to the master bedroom. The renovated kitchen features solid surface countertops, center island, an army of cabinets and vaulted ceiling. Directly off of the kitchen is a massive laundry room that could easily play the role of pantry, as well. The main level also features a formal dining room and full bathroom. The upstairs is comprised of three very spacious bedrooms and the second full bathroom. Follow the convenient breezeway over to the oversized two-car garage and guest house. The 1BR/1BA space features a full-sized kitchen, living room, bedroom with ensuite and an upstairs bonus room. In-laws, friends or VRBO guests will be well accommodated. A short ATV, farm truck or tractor ride takes you through the stone and wrought iron gateway into the 47 acre pasture and up to the 48' x 36' barn. The space has 200 AMP service, concrete slab floor, dual sliding doors on either side, a floored loft, bathroom and kitchenette. The acreage is completely fenced in and has a pond so it's livestock-friendly now. Additionally, there are separate fenced areas within the primary perimeter. Additional features at the property include two new HVAC systems, a Generac generator for the primary house and newer roof.
MlsNumber: --
ListingId: 9971981


Listing Provided By: eXp Realty, LLC, original listing
Phone: (423) 361-4030
Office Phone: (888) 519-5113
Agent Name: Seth Jervis
Disclaimer: Copyright © 2024 Tennessee 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