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 = 1200 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 = 1200 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 = 1200 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;

40095 Greentree
Leonardtown, MD 20650
Sarah Mulford-Martin with EXP Realty, LLC, original listing - (888) 860-7369

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $950,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4416 Square Feet
Agency: EXP Realty, LLC
Agency Phone: (888) 860-7369

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: Why wait for new construction? This like-new modern farmhouse is move-in ready and loaded with upgrades! Built by the highly requested Mednick Construction, this sale includes two lots totaling nearly 7 acres, offering ample space and privacy just outside downtown Leonardtown. With over 4,000 finished square feet of living space, a fabulous layout, and incredible potential in the huge unfinished walk-out basement, ready to be transformed into a private apartment, home theater, or gaming area—this home has it ALL! Perfectly situated on a cul-de-sac, this home has amazing curb appeal! Don’t worry about keeping your lawn looking fresh and green during the hot summer months; a lawn irrigation system is included! Step inside to a bright, airy, and perfect floor plan! Beaming with natural. light, you can relax in a cozy family room with a stone gas fireplace and a stunning coffered ceiling, offering breathtaking views of the expansive front yard and fenced private backyard. The modern gourmet kitchen sets the stage for culinary creations, featuring gas cooking, double wall ovens, custom cabinetry, and a huge walk-in pantry! Working from home or studying is a breeze in the private main floor office! The main-floor owner’s suite features a en suite bath, a massive walk-in closet, its own private laundry room, and private access to the back porch! Bring your furry friends and all the backpacks, because this home features a massive mudroom with custom cabinetry, a doggie shower, a built-in kennel, and a laundry hookup! Upstairs, you’ll find three additional bedrooms, two of which share a Jack-and-Jill bath, while the third has its own bathroom. A loft area provides the perfect space for a playroom, teen hangout, or additional home office, while the FROG room (family room over the garage) offers endless possibilities as a second primary suite, game room, or massive home office. A huge 3-car attached garage provides ample space for all your toys, storage, and parking needs. This home also features a total of 3 laundry hookups, ensuring convenience on every level! The outdoor space is equally impressive, with an expansive front porch, a huge screened-in rear porch, a custom brick patio with a fire pit, accented with landscape lighting, and a fenced rear yard! Don’t miss out—this home is filled with so much natural light, you’ll be happy every day you spend here! You can’t build this home for this price today—this is an incredible opportunity! The assumable VA loan at 5% (for a qualified VA buyer) and the numerous beautiful upgrades added by the current owners make this property truly exceptional. Schedule your private tour today!
MlsNumber: --
ListingId: MDSM2020340


Listing Provided By: EXP Realty, LLC, original listing
Phone: (888) 860-7369
Office Phone: (888) 860-7369
Agent Name: Sarah Mulford-Martin
Disclaimer: Copyright © 2025 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 = 1200 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 Tyler Mattingly
Tyler Mattingly
ASCIIColdwell Banker Jay Lilly Real Estate
Call Today!: (443) 569-2796

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 = 1200 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;
Dawn Orbits NMLS#1116147
ASCIIWaterstone Mortgage
Call Today!: (540) 931-2702

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App