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

1862 Potomac Road
Pasadena, MD 21122

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $569,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1885
Agency: Greater Annapolis Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1972
Notes: Unleash Your Vision: Waterfront Fixer-Upper Beckons in Green Gables<br /> <br /> Calling all design aficionados and waterfront enthusiasts! This enchanting enclave in tranquil Green Gables presents a rare opportunity to craft your dream home. Picture yourself starting each day with mesmerizing water views and the tranquility of nature unfolding just beyond your expansive 1,885 sq ft sanctuary. Nestled on a generous .45-acre lot, this property boasts a sprawling backyard – perfect for hosting unforgettable barbecues, creating lasting family memories, or simply unwinding under the open sky.<br /> <br /> Classic Charm, Modern Metamorphosis Potential: Step inside and be greeted by the warmth of gleaming hardwood floors that flow seamlessly throughout, adding a touch of timeless elegance. The layout exudes functionality and comfort, featuring a primary suite with a full bath for ultimate relaxation. Two additional bedrooms and another full bath provide ample space for family or visiting guests.<br /> <br /> Nature's Playground at Your Doorstep: Gear up for exploration! This peaceful community borders Downs Park, placing a network of walking and biking trails at your doorstep. Imagine invigorating morning jogs or tranquil evening strolls amidst the embrace of nature.<br /> <br /> Spacious Functionality & Fuss-Free Convenience: Embrace effortless living! This residence boasts a spacious driveway with ample parking, a two-car carport offering protection for your vehicles and extra storage, and a handy shed to organize your belongings. Here's the cherry on top: no HOA fees to manage!<br /> <br /> Effortless Commute & Idyllic Ambiance: The location doesn't get much better! You'll reside near Annapolis, Baltimore, and DC, ensuring a smooth commute. This haven offers the perfect blend of city accessibility and the serenity of waterfront living.<br /> <br /> A Blank Canvas Awaits Your Masterpiece: This property is presented "as-is," empowering you to personalize it and make it your own. Unleash your inner designer and transform this charming spot into your bespoke waterfront oasis!<br /> <br /> Text Today & Let's Make Your Dream a Reality!
MlsNumber: MDAA2080882


Listing Provided By: Greater Annapolis Realty, original listing
Name: Greater Annapolis Realty
Phone: (410) 320-6428
Office Name: Greater Annapolis Realty
Office Phone: (410) 320-6428
Agent Name: Joe Fagiolo
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App