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;

369 Edgewater Road
Pasadena, MD 21122

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,695,000
Beds: 4
Baths: 4
Status: Active
SqFt: 5238
Agency: Keller Williams Flagship of Maryland

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2003
Notes: WATERFRONT CUSTOM HOME - Price Improvement - Enjoy 160’ of Waterfront ...Once in a Life Time opportunity to own this Stunning Home with nearly 5,000 sq.ft located in the sought after North Shore on the Magothy River with unobstructed expansive views. Enter this home into a beautiful Vaulted Foyer looking through to the Waterfront amid Breathtaking Views along with Beautiful Landscaping. Very spacious Family/Living area with 10’ Ceilings and an Open Floorplan, Gas Fireplace and beautiful Hardwood Floors throughout. Enjoy Water Views from the Gourmet Kitchen while cooking on Wolf Appliances featuring a 6 Burner Dual Fuel Gas Stove with Warming Drawer and Electric Double Ovens, Sub-Zero Frig, Custom Granite Countertops, Large Maple Cabinets, Island Seating, Butler’s Pantry and exit the French Doors leading to the Spacious Waterfront Deck. Exploring the rest of the home features 4 Bedrooms and 4 Full Baths… Take the beautiful staircase up to the 2nd Level offering 2 En-Suite Bedrooms. The Primary Bedroom Suite resides on the Waterfront with Vaulted Ceilings, Gas Fireplace, and an observation Balcony where you can enjoy the Sunrise, Beautiful Custom Walk-In California Closet, Primary Bathroom with heated floors and Jacuzzi Soaking Tub, Walk-In Shower and Dual Sink Vanity. The other 3 Bedrooms are sized generously all with Large Walk-In Closets, 1 is an En-Suite Bedroom with the 2 Additional Bedrooms offering a J&J Bathroom. Down in the Finished Basement, you will find a Family Room, Office/Den and a Large Storage Room. Custom Hunter Douglas Luminette & Silhouette Blinds throughout the home. Parking is not an issue as you have a Driveway Hosting 8 Vehicles and an Oversized Front Loading 2 Car Garage with Coated Floors, Custom Cabinets and Shelving. Now, Head outside to your Private 100’ Pier with Deep Water and you will find 2/12,500 Lbs. Boat Lifts, 1/3,000 Lb. Boat Lift, 1/800 Lb. Boat Lift and a 20’ Platform ready for Family Fun! The beautifully Large manicured Waterfront Yard has a Multi Zoned Water Sprinkler and is partially fenced and also Host a Fire Pit where every inch is great for entertaining while living the true waterfront life. Jump on your boat with convenient access to the Chesapeake Bay, Islands and Downtown Annapolis with countless Boating Destinations. You will create unforgettable memories in this Waterfront staycation home for many years to come and entertain excellence with everything this property has to Offer! Propane Generator Included. There is a Voluntary HOA but this great community maintains a Private Community Beach with a Pavilion on the Magothy River, Boat Ramp, Marina, New Playground and don’t forget the Community Events. It’s an easy commute to Annapolis, Ft. Meade, DC and nearby Golf Courses. Schedule your private tour! Must be prequalified and or have proof of funds to schedule a showing.
MlsNumber: MDAA2065862


Listing Provided By: Keller Williams Flagship of Maryland, original listing
Name: Keller Williams Flagship of Maryland
Phone: (410) 729-7700
Office Name: Keller Williams Flagship of Maryland
Office Phone: (410) 729-7700
Agent Name: Lauren A Smith
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