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

1048 Horseshoe Bend Road
Keysville, VA 23947
Navona Hart with Century 21 Realty @ Home, original listing - (434) 390-4004

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $675,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3700 Square Feet
Agency: Century 21 Realty @ Home
Agency Phone: (434) 390-4004

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 33 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1990
Notes: Welcome to a slice of heaven, nestled just outside a quaint town and only an hour from the buzz of Richmond. This remarkable farm property spans 33 pristine acres of mixed pasture, lush timber, and fertile hayfields, offering an idyllic setting whether you seek a personal retreat from city life or a versatile countryside abode. The main residence features 3 bedrooms and 3 ½ baths, with a generous 2,200 sq. ft. of living space. Each room is designed to maximize comfort and functionality, ensuring a cozy yet luxurious rural lifestyle.The versatile pool house offers year-round enjoyment with an additional 1,500 sq. ft. of heated and cooled space. Dive into relaxation with a stunning 20x40 in-ground saltwater pool. For those passionate about horseback riding or farming, the property boasts a 24x36 barn complete with 2 stalls, a wash and tack room, an outdoor shower stall, and abundant hay storage—all crafted with tongue-and-groove paneling for a timeless aesthetic.Hone your skills at your private shooting range, and enjoy the peace of mind provided by a personal bunker and hidden safe. Car enthusiasts and hobbyists will appreciate the oversized 36x66 garage, which accommodates up to 10 vehicles, along with a 26x30 auto shop equipped with a robust 9,000-pound lift. The property is surrounded by high-tensile wire fencing, making it perfect for animals. Meander through the babbling creek at the back of the property, adding a touch of serenity to this already breathtaking estate. This property offers unparalleled opportunities for personal ventures. Whether you're planting a vineyard, raising livestock, or seeking a weekend getaway that feels like a daily vacation, this farm transforms aspirations into reality. Embrace a lifestyle that combines solitude and opportunity. Whether stargazing under an unblemished night sky, farming your own vegetables, or indulging in your hobbies, this land adapts to meet your dreams.
MlsNumber: --
ListingId: 2500437


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