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;

7611 Hawkins Creamery Road
Gaithersburg, MD 20882
Adam Murphy with RE/MAX Realty Centre, Inc., original listing - (301) 591-3920

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $999,900
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 5600 Square Feet
Agency: RE/MAX Realty Centre, Inc.
Agency Phone: (301) 591-3920

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1979
Notes: Newly renovated 5600 sf home. The home was completely gutted in 2023, and rebuilt with all new insulation, electrical and plumbing systems, drywall, doors and flooring, windows, vinyl siding and roofing, as well as two LP gas Heating/AC systems and LED lighting—resulting in a very energy-efficient home.<br /> <br /> The neutral color of the house starts with “Sterling Gray” siding with “Flagstone Gray” accent. Inside the walls are freshly painted with a faint “Ice Cube” gray with a “Lazy Gray” accent and white doors and trim. The doors have rubbed-bronze hardware.<br /> <br /> The 4000 sf main level of this custom-built rambler-style home consists of 2000 sf of “living space” and 2000 sf of office and “sleeping space.”<br /> <br /> This luxurious home opens into a 2000 sf open floor plan “living space” consisting of the Living Room, Dining Room, Kitchen, and a Sun Room. The open living spaces feel huge with the 10’ and 11’ ceilings. The Living Room has a huge brick, LP gas fireplace. The Sun Room with south-facing windows also has its own LP gas fireplace. The custom gourmet kitchen comes with white Merillat Masterpiece Collection Cabinets, LG appliances, and an oversized 5’ by 8’ quartz island countertop. Glass doors in the foyer separate these living spaces from the sleeping quarters, providing privacy and peace.<br /> <br /> The home boosts a 200 sf office with a wood fireplace and its own separate exterior entrance.<br /> <br /> The “sleeping space” starts off with a 650 sf Master Bedroom Suite with another LP gas fireplace. An open 24’ by 17’ bedroom area, with a Master Bath area that has a cathedral ceiling, a 4’ by 8’ shower with bench, and dual vanities. Three additional bedrooms and two full bathrooms offer ample space for family and guests.<br /> <br /> The basement is finished with a den and a recreation room and plenty of unfinished storage space.<br /> <br /> This home boasts several energy-efficient upgrades, including the relocation of the heating/AC ductwork from hot attic space into conditioned space to improve energy efficiency. The attic is insulated with a combination of spray foam and loose-blown fiberglass insulation for a total rating of R-67. Exterior walls (2x4) are insulated with a combination of spray foam and fiberglass insulation for a total rating of R-22, while exterior walls (2x6) have a combination of spray foam and fiberglass insulation for a total rating of R-25.<br /> <br /> The home has new Mohawk laminate wood plank flooring throughout. A new SimpliSafe Security system has been installed.<br /> <br /> An oversized 24’ by 50’ (1200 sf) detached heated garage provides ample space for parking. An attached 225 sf equipment shed also provides ample storage.<br /> <br /> Beautiful mature trees and professional landscaping enhance the overall appeal of the property, providing a serene and picturesque setting. These natural surroundings not only add charm and curb appeal but also contribute to privacy and a sense of tranquility, making the home a more desirable retreat. The mature landscaping creates a welcoming atmosphere, perfect for those who appreciate nature and outdoor beauty right at their doorstep.<br /> <br /> Additionally, a massive new 1,300 sq. ft. Trex deck has been added, stretching nearly 100 feet in length. The deck is equipped with solar-powered LED lighting, offering both energy efficiency and ambiance for evening gatherings. Whether hosting family events or enjoying a peaceful night outdoors, this deck provides the perfect blend of style, functionality, and low-maintenance living.
MlsNumber: --
ListingId: MDMC2151198


Listing Provided By: RE/MAX Realty Centre, Inc., original listing
Phone: (301) 774-5900
Office Phone: (301) 591-3920
Agent Name: Adam Murphy
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 = 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