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

11521 Green St
Fulton, MD 20759
Steve Lenet with Columbia, original listing - (888) 536-0216

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,300,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Pending
SqFt: --
Agency: Columbia
Agency Phone: (888) 536-0216

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2017
Notes: Welcome to Maple Lawn's Best of the Best! Absolutely Stunning, FULLY LOADED better-than-new home in Maple Lawn's sought-after Garden District. With OVER $120K of after-market Custom Upgrades, this 2017 Green Energy, Award-Winning beauty CHECKS ALL THE BOXES! The words 'Breathtaking' and 'Dramatic' come to mind, as you step inside from the Covered Front Porch, into the Open and Light Filled Main Level. You're greeted by Luxurious Hardwoods, High Ceilings, Exquisite Hunter Douglas Window Treatments, and fine touches throughout. The Welcoming Living Room features a Handsome Gas Fireplace with a custom Floor-to-Ceiling Stone Wall. Look to your left, and be amazed by the FULL-WALL Western Sliders, with Remote Shades. Watch the Western Sliders almost magically disappear, opening the entire Main Level to the Outside! That's right; the entire rear of the home can be OPENED, leaving nothing between you and the outside -- the Deck, Outside Hardscaping, and Fully Fenced Rear. Truly an ENTERTAINER'S DREAM!!! The Fabulous Chef-Inspired Gourmet Kitchen is as Lovely as it is Functional. Featuring SS Appliances, including a 5-Burner Cooktop with attractive Hood, and a Double Oven. There's a Super-Sized Island with a Breakfast Bar, and loads of extra Cabinetry. A Double Pantry, too. Also on the Main Level are a Large Office (or 5th Bedroom) with a big Walk-In Closet, and a Mudroom leading to the oversized, 2-Story, 2-Car Garage! And not just any Garage...this one has a 500-pound capacity Remote Lift, and a remote Bike Lift, as well. And, it's EV Level-2 ready. Are you getting the feeling that this is a special home? Well wait, there's much more. Let's head down to the Lower Level, where there's a beautiful Custom Family Room with Luxury Vinyl Plank Flooring, a Handsome Wet Bar with a Wine Refrigerator, and More. Also on this level are another Bedroom with TWO Walk-In Closets, and a Double-Vanity Full Bath with Stone Floor Walk-In Shower. Need still more space? Maybe a big Exercise Room? No worries! There's a large Bonus Room, and a Storage Room, too. The Utility Room is where the Geothermal HVAC System is! Geothermal is an Energy Efficient, Environmentally-Friendly way to heat and cool your new home. And for extra Energy Savings, the home has an OWNED (not leased) Solar Power System which will reduce your energy bills! No solar agreements -- it's yours. When it's time to retire for the evening, the Upper Level will not disappoint. The Owner's Suite is just as you would expect -- Impressive! Two large Walk-In Closets, both with closet systems! And the Private Bath is just perfect, with a Soaking Freestanding Tub, a Separate Walk-In Shower, Double Vanity Sinks, and a Private Water Closet Room. There are two additional (Very) Spacious Bedrooms, and a Jack & Jill Bathroom. The Laundry Room is on this level as well. Not in a closet, but in a separate room, with a Laundry Tub and Windows. And, there's a large Balcony off this Upper Level, too, with views of Greenspace. Out back, there's plenty of space to relax and entertain. And, for you gardeners, there are three galvanized metal raised beds with organic soil, and five food grade containers ready for your herbs and vegetables. And not to forget the fruit-bearing Chicago Hardy Fig tree with Oregano ground cover. You may never want to leave your new home, but when you do...Welcome to Maple Lawn's Exciting Amenities and Lifestyle, including Fine and Fun Dining, Shopping, Pools, Tennis, and so much more. And of course, nationally recognized Howard County Schools. Plus, easy access to DC, Baltimore, and everywhere in between. Don't miss this rare opportunity to own one of Maple Lawn's most impressive homes!
MlsNumber: --
ListingId: MDHW2051578


Listing Provided By: Columbia, original listing
Phone: (888) 536-0216
Office Phone: (888) 536-0216
Agent Name: Steve Lenet
Disclaimer: Copyright © 2025 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 = 1195 AND i.igate IN ('usahud','nwhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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 Michelle Williamson
Michelle Williamson
ASCIIKeller Williams
Call Today!: (443) 745-6177

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