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

13149 John Martin Drive
Williamsport, MD 21795
Brannon Evans with Keller Williams Premier Realty, original listing - (301) 745-4450

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $675,000
Beds: 8
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4631 Square Feet
Agency: Keller Williams Premier Realty
Agency Phone: (301) 745-4450

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2017
Notes: Introducing a remarkable residential home that transcends the ordinary! This expansive eight-bedroom, four and a half bath residence is nestled on a desirable corner lot backing up to the Common Ground Community Property allowing a sense of spaciousness and expansive feel.<br /> The main level features an owner suite, designed for ultimate comfort and convenience. The open floor plan seamlessly connects the living, dining, and kitchen areas, making it perfect for entertaining. Upstairs, you'll find four additional spacious bedrooms, including a second owner suite with a vaulted ceiling and luxurious extra large spa-like walk-in steam shower, providing a perfect retreat.<br /> The fully finished walkout basement is a standout feature, boasting ample natural light from large windows. It includes two bedrooms, a separate laundry room, and a full kitchen, making it an ideal in-law suite, guest quarters and great for multigenerational living.<br /> This home is a rare find, combining functionality with elegance, and is ready to welcome you and your family. Don’t miss your chance to experience this exceptional property—schedule your private showing today!<br /> <br /> **Extra Key Features:**<br /> - **Stylish Design:** “The Anderson” Model- Named after the owners due to its impressive layout and customized design. This model is now one of the builders best sellers!<br /> - **Flooring:** Beautiful Stranded Bamboo Janka wood flooring with a hardness rating of 4500, complemented by upgraded, pet-resistant carpet and padding.<br /> - **Second Floor Laundry:** Providing a central location for laundry tasks without having to navigate stairs.<br /> - **Outdoor Space:** Dog Watch Safe Link underground invisible fence system suitable for any size dog. <br /> - **Massive Kids Playground Swingset:** This impressive swingset is designed for endless fun! (Note: This item is Negotiable upon sale)<br /> - **Parking:** Oversized parking pad with additional space for vehicles.<br /> - **Accessibility:** Wraparound sidewalk leading to the finished basement entrance.<br /> -**400 Amp Electrical Service<br /> -**Dual Zone HVAC<br /> This property combines modern living with comfort, providing a spacious feel thanks to its location and design. Perfect for families and those who appreciate quality finishes!
MlsNumber: --
ListingId: MDWA2024992


Listing Provided By: Keller Williams Premier Realty, original listing
Phone: (443) 204-9240
Office Phone: (301) 745-4450
Agent Name: Brannon Evans
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 = 1203 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 Stacie Storm Miller, REALTOR, CLHMS, MRP, SRES, SRS, MD & PA Licensed
Stacie Storm Miller, REALTOR, CLHMS, MRP, SRES, SRS, MD & PA Licensed
ASCIIBHHS, PenFed Realty
Direct: (703) 577-4850
Office: (443) 627-2900

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App