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

4688 S Cowpasture Lane
Hume, VA 22639
Robin Garbe with CENTURY 21 New Millennium, original listing - (703) 753-7910

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,195,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2519 Square Feet
Agency: CENTURY 21 New Millennium
Agency Phone: (703) 753-7910

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: BACK ON MARKET WITH A BRAND NEW ROOF AND GUTTERS! IDEAL HORSE PROPERTY IN NORTHERN FAUQUIER COUNTY. This unique design by local architect James Hricko combines contemporary & rustic elements creating a modern cottage style home. Custom built in 2002, the “Silo House” was designed to evoke the barn and silo that once stood on this site and to nurture a passion for horses. <br /> <br /> Reminiscent of the way homes and barns were designed in early America or colder climates in Europe, the barn attaches to the main house. Thus, it is wonderfully easy to comfortably check on equine friends, even in the worst weather. The house was carefully designed to blend naturally in its setting, among gently rolling fields, and placed purposefully, so that horses in their pastures are always in view. The siding is comprised of natural cedar shingles, with tongue & groove vertical boards on the silo, and painted in “Wedgewood Blue”, a luxurious shade that is both serene and delightful. The new "Shakewood" architectural shingles compliment the siding and are in keeping with the "cottage" look .<br /> <br /> Inside, cool gray flooring, white walls, and clean lines exude a peaceful “zen-like” energy. The family room is warmed by a wood burning fireplace with rustic wood mantel and beams, which were salvaged from the old barn that once stood on the site. Throughout the home, sunlight spills in through an abundance of windows and glass doors, and gorgeous pastoral views are enjoyed from every room. The round silo provides a unique space perfect for a cozy “lounge” on the main level and an invigorating office space upstairs. <br /> <br /> Thoughtfully planned to make horse keeping as care-free as possible, the well-ventilated and well-lit barn is comfortable for both horse & human, with a heated & cooled tack room, three 12x12 matted stalls, a luxurious wash stall and plenty of hay storage. There are 3 board-fenced paddocks with run-in sheds, 2 of which have automatic waterers and all three have spigots by them. A circular drive makes trailering a breeze, and there is ample parking for trucks and farm equipment. Last, but not least, a Generac generator is waiting to save the day if the power goes out. <br /> <br /> Located in Hume, one of the most scenic and protected parts of Fauquier County, it is an easy drive to the town of Marshall for groceries, or to grab a sandwich at the world-famous Red Truck Bakery. With access to a variety of options for high-speed internet, it is feasible to work successfully from home. For those who must commute to the city, route 66 is just a 10 minute drive, with Wegmans and the shopping meccas of Gainesville and Haymarket along the way. Over $170,000 in improvements since the current owner purchased the home, and it shows! To fully appreciate this truly “one of a kind” equestrian property, you will want to schedule a personal tour. Please ask for a detailed brochure, with 3D Tour, Floor Plans and a long list of improvements.
MlsNumber: --
ListingId: VAFQ2014928


Listing Provided By: CENTURY 21 New Millennium, original listing
Phone: (540) 349-1400
Office Phone: (703) 753-7910
Agent Name: Robin Garbe
Disclaimer: Copyright © 2024 Bright MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 2848 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;
Dan Radtke
ASCIIRE/MAX Gateway
Call Today!: (703) 283-9540

Local Mortgage Pro

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 = 2848 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;
Heritage Financial, Inc.
Call Today!: (410) 224-7250

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App