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

9643 Watkins Rd
Gaithersburg, MD 20882
Matt Huff with Rockville Centre, original listing - (888) 536-0216

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,200,000
Beds: 6
Baths: Full: 4, ½: 1
Status: Active
SqFt: --
Agency: Rockville Centre
Agency Phone: (888) 536-0216

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: Gorgeous all brick custom-built Colonial home on 2 acres! 6 Bedroom/4.5 Bath with Primary Bedroom on the main level! Wait for your guests on the welcoming covered front brick Porch that features recessed lighting.2-story Entry Foyer, with guest closet, hardwood flooring, Palladian window. Front door offers double sidelights all with leaded glass. The Living Room offers a quiet place for conversation and features hardwood flooring, and a ceiling fanEntertain family & friends in the Formal Dining Room with big picture window, hardwood flooring, chair rail, crown moldingGourmet Island Kitchen boasts wood cabinets, and granite countertops. Stainless appliances, 2 wall ovens, gas cooktop on the island plus additional storage, breakfast bar overlooking the Dining Area, double pantry, hardwood floors, recessed lighting. A bookcase matching the cabinets has plenty of room for all your cookbooks! Access to garage thru the Kitchen hallwayTons of natural light in the Dining Area thru the big picture window! Recessed lighting, wood flooring. Access to the back Porch thru the Dining Area.Expansive sun-filled Family Room has plenty of room for your book/wine club with vaulted ceilings with fan, gas fireplace, Palladian picture windows, wood flooring. Access to the Deck, & Patio thru the Family Room.A restful oasis awaits in the Main level Primary Bedroom that features a tray ceiling with fan, tons of natural light, recessed lighting, carpeted flooring.Main level Primary Bath offers plenty of room with 2 sinks, granite countertops. Vaulted ceiling, walk-in closet, linen closet, soaking tub, Palladian window. Water closet.Main level BR2/Au Pair Suite is bight and sunny with ceiling fan, carpeted flooring, and ample closet space.Main level Full tub Bath, ceramic tile surroundA Powder Room and Laundry Room with full-sized front-loading washer & dryer, Utility sink, and cabinets for storage complete the main level. Upper level BR3 features a big picture window, carpeted flooring, walk-in closet, and ceiling fanUpper level BR4 features a big picture window, carpeted flooring, walk-in closet, and ceiling fanJack & Jill Bath: oversized stall shower and large vanityUpper level BR 5 with ample closet space, carpeted flooringUpper level BR6 boasts a huge footprint with plenty of room for sleep over parties or a man-cave or she ""Ëœshed', carpeted flooring, ceiling fansUnfinished lower level, walk-up/out thru sliding glass doors. Tons of room for improvements; home gym, craft space, media room. Includes a rough-in for Bathroom.Beautifully maintained rear yard and gardens: Expansive Trex deck and patio. Stone retaining wall. Vista views of rear yard and gardens a wonderful place to have family reunions or even a wedding!3 car side-entry garage with shelving and cabinets, ceiling fan, full house sprinkler system, walk-out basement. Custom installed bottled propane system for gas cooking and gas furnace.Window treatments convey.
MlsNumber: --
ListingId: MDMC2120274


Listing Provided By: Rockville Centre, original listing
Phone: (888) 536-0216
Office Phone: (888) 536-0216
Agent Name: Matt Huff
Disclaimer: Copyright © 2024 Long & Foster Real Estate. 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 = 1197 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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 Emcee Arah
Emcee Arah
ASCIISamson Properties
Call Today!: (301) 691-2209

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 = 1197 AND i.igate IN ('usahud','mdhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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 Paul McCausland
Paul McCausland
ASCIIMeridian Bank
Office: (301) 605-9961

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App