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

110 Jesses Way
Farmville, VA 23901

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $419,900
Beds: 4
Baths: 3
Status: Active
SqFt: 2108
Agency: CENTURY 21 Realty @ Home

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2006
Notes: This property is in town and offers the privacy of a mini estate. Sitting on the front porch you overlook a beautiful wooded paradise, sit on back patio and feel like you are the only ones around or enjoy the side yard and watch the birds all around. The home offers peace of mind on all major components with new roof (2023), new main floor heat pump(2022), & new custom kitchen. Home also offers a ton of storage with a custom garage system and walk-in attic. The property encompasses 2 lots with fencing and outdoor living spaces that are used almost all year long. Come inside and find 4 bedrooms with 2 baths on the upper level. Primary bedroom offers walk-in closet and bath. 2nd bedroom is oversized with room for sitting, 3rd and 4th are great for office, guests and the littles. Upper hall bath has newer tile. Laundry is spacious. Main level has room for a library/living, dining room and boasts an open family room, kitchen and breakfast nook. The kitchen has slow-close cabinets and drawers, new appliances, a pantry that everyone wants, granite countertops, over and under cabinet lighting this is truly a chef's delight. The outdoor living spaces include a covered patio~~come sit on a rainy day and feel your worries slide away, a side deck with a swing, and other carefully crafted retreat areas. This yard is private and easily maintained. Fenced for children and dogs. And although it sits on a hill (neighbors will call first) the garage entrance is fewer steps and easier entrance for those concerned about steps. This home is in a thriving town with shopping, restaurants, Longwood University and Hampden Sydney College. Close to hospital and medical care. If you need it the community offers it. Come see this gem today before someone else grabs it up.
MlsNumber: 2409017


Listing Provided By: CENTURY 21 Realty @ Home, original listing
Name: CENTURY 21 Realty @ Home
Phone: (434) 390-4004
Office Name: Century 21 Realty @ Home
Office Phone: (434) 390-4004
Agent Name: Navona Hart
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