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

102 Rowland Drive
Port Deposit, MD 21904
Jeremy McDonough with Mr. Lister Realty, original listing - (410) 486-4504

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $448,500
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1526 Square Feet
Agency: Mr. Lister Realty
Agency Phone: (410) 486-4504

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Condominium
Year Built: 1999
Notes: Back on the market due to a commute change for the last buyer! Easy waterfront living meets entertainer's delight! This unit was purchased as a shell and designed with great care to be a dream condo. From the moment you enter the unit, the open concept design allows you to take in the views of the river. As you pass the threshold your eye takes in the bright and welcoming kitchen. This custom-built kitchen, designed by a former chef, boasts an oversized island, walk-in pantry, plumbed coffee machine, built-in microwave, dry bar with dual-zoned refrigerator and wine rack, and a deep apron sink with pre-rinse faucet. The KraftMaid cabinet system was designed specifically for this space and features drawer cabinets for optimal storage. The peninsula was designed to maximize seating so that the host can entertain everyone from the kitchen! Quartz countertops brighten the space and are a breeze for clean up. Beyond the kitchen lies an oversized living room area. For those seeking a space<br /> for a dining table in addition to the eat-up peninsula, this space could easily be converted to a dining and living room area. The primary bedroom is spacious with a large walk-in closet, but the floor to ceiling view of the Susquehanna steals the show. The primary bath is beautiful to behold, but don't overlook its luxurious features! The tiled floor, shower floor, shower wall and bench will be warmed to your<br /> desired temperature as set on the timed thermostat. Say goodbye to cold bathroom surfaces and instead enter your warm sanctuary each morning! The enormous shower is supplied by an 80-gallon water heater and features a Moen U system. Wifi capable, this system is programmable per user and features a handheld shower head, four wall-mounted jets, and a rain head. The large vanity is equipped with extra drawers for ample storage and an electric outlet built into the top drawer. The spacious second bedroom, with its walk-in closet and extra large bathroom. doubles as a private sanctuary for overnight guests or as a second ensuite. Extending off the living room and the primary bedroom is the sunroom which runs the width of the condo. The sunroom is currently being enjoyed as a bonus living room and office, though plenty of space is available here for a Murphy bed for those interested in entertaining additional overnight guests. The views from the double-sized deck are unrivaled in the area. With picturesque views that extends both up and down the river, you can't help but fall head over heels for living on the Susquehanna. Boaters, if no slip is available for purchase, inquire about storage for your boat with the local high-and-dry. The elevator in the middle of the building adds an extra layer of easy living and the 1.5 car garage leaves ample room for a car plus all the fun toys. Join the golf cart movement in Port Deposit and head down the block to join all your new friends at the local restaurants, or grab your paddle boards and head out to the river! The possibilities for fun are endless! Love the setup? The sale of the furniture is negotiable!
MlsNumber: --
ListingId: MDCC2014298


Listing Provided By: Mr. Lister Realty, original listing
Phone: (410) 486-4504
Office Phone: (410) 486-4504
Agent Name: Jeremy McDonough
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 = 1189 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;
JAMES JONES
ASCIIeXp Realty
Call Today!: (302) 559-4332

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App