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 = 2890 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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 = 2890 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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 = 2890 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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;

35229 Somerset Ridge Road
Locust Grove, VA 22508

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2002
Notes: TAKE A LOOK AT THIS MAGNIFICENT FOUR-BEDROOM, THREE-BATH CUSTOM-BUILT HOME! CONVENIENTLY LOCATED IN THE SOMERSET COMMUNITY THAT INCLUDES AN OUTDOOR SWIMMING & KIDDIE POOL, AS WELL AS A TENNIS COURT & A SHORT DRIVE TO THE PLETHORA OF SHOPPING & DINING AMENITIES ON ROUTE 3/CENTRAL PARK & ACCESS TO I-95! SOME WONDERFUL RECENT UPDATES TO THE HOME INCLUDE A NEW ROOF IN THE LAST TWO MONTHS, ONE OF THE TWO HVAC UNITS IN THE LAST NINE MONTHS, A TANKLESS HOT WATER HEATER IN 2023, AN IRRIGATION SYSTEM & A CUSTOM SHED TO MATCH THE HOME! INCREDIBLE CURB APPEAL TO ENJOY EVERY DAY AS YOU PULL ONTO THE EXTENDED DRIVEWAY & INTO THE OVERSIZED, SIDE-LOADING TWO-CAR GARAGE, THE LOVELY CUSTOM GARDEN BEDS WILL WELCOME YOU & YOUR GUESTS TO THE INVITING, VERY SPACIOUS COVERED FRONT PORCH COMPLETE WITH CUSTOM TILED FLOORS & A CEILING FAN TO KEEP YOU COOL WHILE YOU ENJOY THE FRONT TREE LINE & GOLF COURSE VIEWS! AROUND BACK, A LARGE REAR DECK AWAITS WITH AMPLE SPACE & BUILT-IN SEATING TO ENJOY SOME QUALITY REST & RELAXATION WHILE ENTERTAINING GUESTS & TENDING TO THE GRILL, LOOKING OUT OVER THE LARGE BACKYARD THAT BACKS TO TALL TREES & INCLUDES SIDEWALKS TO BOTH THE DRIVEWAY & THE CUSTOM SHED WITH BEAUTIFUL LANDSCAPING SURROUND! THROUGH THE FRONT DOOR, YOU'LL ARRIVE TO GORGEOUS HARDWOOD FLOORING THAT FLOWS THROUGHOUT THE MAJORITY OF THE MAIN LEVEL IN ADDITION TO THE MULTITUDE OF HIGH, VAULTED & CATHEDRAL CEILINGS THROUGHOUT MOST OF THE ROOMS! RIGHT OF THE FOYER THROUGH A SET OF POCKET DOORS, THE FIRST OF TWO MAIN LEVEL BEDROOMS, THIS ONE PERFECT FOR AN IN-HOME OFFICE WITH LOADS OF SPACE & A WALK-IN CLOSET! OPPOSITE FROM YOUR POTENTIAL OFFICE, THE SPLENDID FORMAL DINING ROOM IS READY FOR DINNER PARTIES, DISPLAYING CHAIR RAILING & CUSTOM TRIM, CHANDELIER LIGHTING & A LARGE PALLADIAN WINDOW! BEYOND THE DINING ROOM, AN INCREDIBLE GOURMET KITCHEN BOASTS ELEGANT QUARTZ COUNTERTOPS WITH A WATERFALL BREAKFAST BAR, UPGRADED STAINLESS STEEL APPLIANCES, TONS OF CABINET STORAGE WITH UNDER-CABINET LIGHTING & FLOATING SHELVING, A TIMELESS, CUSTOM TILE BACKSPLASH, GOURMET PULL FAUCET & A SPACIOUS BREAKFAST ROOM WITH CHARMING PENDANT LIGHTING! THE PLACE YOU'LL LOVE TO SPEND THE MAJORITY OF YOUR FREE TIME IS SURE TO BE THIS STUNNING FAMILY ROOM WITH ITS SOARING, TWO STORY CEILINGS BLANKETED IN NATURAL LIGHTING FROM BOTH LEVELS OF WINDOWS & THE SET OF FRENCH DOORS TO THE REAR & A TREMENDOUS FLOOR-TO-CEILING STONE FIREPLACE WITH SCONCE LIGHTING, READY FOR A COZY NIGHT OF COUCH SURFING & IMPROMPTU AFTERNOON NAPS! OFF THE MAIN LEVEL BEDROOM HALLWAY, AN UPDATED FULL HALL BATH WITH CUSTOM HEXAGON TILE FLOORS & A SEPARATE LAUNDRY ROOM BEHIND A PRIVACY GLASS DOOR WITH COUNTERTOP SPACE & SHELF STORAGE! WONDERFUL MAIN LEVEL OWNER'S SUITE WITH VAULTED CEILINGS & A MARVELOUS ENSUITE WITH A JETTED, SOAKING TUB & SEPARATE SHOWER WITH CUSTOM TILING, DOUBLE VANITY SINKS & CERAMIC TILE FLOORING! ON THE UPPER LEVEL, THE SECOND & THIRD SPACIOUS BEDROOMS, BOTH WITH GREAT CLOSET SPACE, A FULL HALL BATH & A LARGE BONUS ROOM WITH SKYLIGHTS — A PERFECT FLEX SPACE TO FULFILL HOBBIES, MOVIE MARATHONS, A PLAYROOM & MORE! DO NOT MISS YOUR OPPORTUNITY TO OWN THIS INCREDIBLE CUSTOM-BUILT HOME! CALL TODAY TO SCHEDULE YOUR SHOWING BEFORE IT'S TOO LATE!
MlsNumber: VAOR2007126


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.


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 = 2890 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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;
Real Estate Expert Photo for Missy Garrison
Missy Garrison
ASCIIMontague Miller & Co. Realtors
Call Today!: (540) 661-2353

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App