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

104 Viewtown Road
Amissville, VA 20106

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $679,900
Beds: 4
Baths: 3
Status: Active
SqFt: 2782
Agency: Belcher Real Estate, LLC.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential
Year Built: 1987
Notes: WELCOME HOME TO THIS BEAUTIFUL FOUR-BEDROOM, THREE BATH ALL-BRICK RAMBLER! SITUATED ON A SPRAWLING 10.81-ACRE LOT FEATURING ENCHANTING ROLLING HILLS THAT CREATE A CAPTIVATING & EVER-CHANGING LANDSCAPE BACKING TO A BREATHTAKING WOODED BACKDROP, OFFERING A SENSE OF SERENITY & NATURAL BEAUTY! THE PROPERTY OFFERS VAST YARD SPACE SURROUNDING THE HOME PROVIDING AMPLE ROOM FOR OUTDOOR ACTIVITIES, GARDENING & CREATIVE LANDSCAPING, WHILE THE HUGE REAR DECK PROVIDES AN IDEAL VANTAGE POINT FOR TAKING IN THE PANORAMIC VISTAS, MAKING IT A PERFECT SPOT FOR OUTDOOR RELAXATION & ENTERTAINING! THE OVERSIZED, SIDE-LOADING GARAGE, WITH SPACE FOR THREE VEHICLES, & THE EXTENDED DRIVEWAY ENSURE CONVENIENCE, AND EASE OF ACCESS & ADD TO THE HOME'S OVERALL PRACTICALITY! INTO THE FOYER, YOU HAVE A HUGE LIVING ROOM ON YOUR LEFT WITH BUMPOUT WINDOWS TO THE FRONT, READY FOR YOUR PERSONAL TOUCH FOR YOUR OWN WELCOMING ATMOSPHERE TO COME HOME TO! BEYOND THE LIVING ROOM, THE SEPARATE DINING ROOM AWAITS, WITH PLENTY OF SPACE FOR DINNER GATHERINGS TO COME! A SPACIOUS REC ROOM/FLEX SPACE RESIDES ON THE OTHER SIDE OF THE DINING ROOM, COMPLETE WITH A FULL BATH, SIDE ACCESS TO THE EXTERIOR & ACCESS TO THE GARAGE! ON THE REAR OF THE HOME, THE WONDERFUL FAMILY ROOM IS READY TO MAKE NEW MEMORIES FOR YEARS TO COME, WITH A LOVELY BRICK FIREPLACE & TWO SETS OF FRENCH DOORS TO THE REAR DECK, OFFERING THE SCENIC VIEWS FROM INSIDE THE HOME! SPECTACULAR KITCHEN WITH TONS OF SPACE TO PREP MEALS, LOADS OF COUNTERTOP & CABINET STORAGE, DOUBLE WALL OVENS, A COOKTOP & A SPACIOUS BREAKFAST AREA WITH SLIDING GLASS DOORS TO THE REAR DECK! SEPARATE LAUNDRY ROOM WITH A UTILITY SINK, CABINET STORAGE & SECONDARY ACCESS TO THE GARAGE! DOWN THE BEDROOM HALLWAY, THE MAIN LEVEL IS COMPLETE WITH ALL FOUR BEDROOMS, INCLUDING THE SPACIOUS OWNER'S SUITE THAT INCLUDES ITS OWN FRENCH DOORS TO THE REAR DECK, AS WELL AS AN ENSUITE BOASTING A JETTED TUB, SEPARATE SHOWER & SPLIT VANITIES & FINALLY THE FULL HALL BATH! UNFINISHED BASEMENT PROVIDES LOADS OF ADDITIONAL STORAGE! DO NOT MISS YOUR OPPORTUNITY TO OWN THIS INCREDIBLE PROPERTY & ITS 10.81 ACRES OF NATURE'S BEAUTY! CALL TODAY TO SCHEDULE YOUR SHOWING BEFORE IT'S TOO LATE!
MlsNumber: VARP2001370


Listing Provided By: Belcher Real Estate, LLC., original listing
Name: Belcher Real Estate, LLC.
Phone: (540) 841-1718
Office Name: Belcher Real Estate, LLC.
Office Phone: (540) 300-9669
Agent Name: Alex Belcher
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App