Title Page Background
DEBUG FN args: Array ( [0] => 2842 [1] => [2] => [3] => agent ) BEFORE: Site: 2842 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2842 Igate: njhud LocID: 2842 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('vahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2842 [1] => [2] => [3] => lender ) BEFORE: Site: 2842 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2842 Igate: njhud LocID: 2842 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('vahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2842 [1] => [2] => [3] => other ) BEFORE: Site: 2842 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2842 Igate: njhud LocID: 2842 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('vahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

104 Viewtown Road
Amissville, VA 20106

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential-Single Family Residence
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: --


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