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

3506 Greenpoint Road
East New Market, MD 21631

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $499,900
Beds: 2
Baths: 2
Status: Active
SqFt: 1648
Agency: Sharon Real Estate P.C.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1950
Notes: Discover the Choptank River Waterfront Cottage, a charming 2 bedroom and 2 bathroom home with an inviting open floor plan. The property boasts a fully bulkheaded shoreline, featuring 5 boat slips on a protected cove, a boat lift, and a boat davit, all with a comfortable 3' MLW. Savor breathtaking sunrises and sunsets, observe the passing boat traffic, and enjoy fishing at your doorstep. Take advantage of the best crabbing, fishing, and boating opportunities on the Choptank River and Chesapeake Bay, right at your fingertips on Maryland's Eastern Shore. Destinations of Oxford, Cambridge and Tilghman Island are awaiting or venture further on the Chesapeake Bay. The cottage is set in a prime location with panoramic water views and nestled along the picturesque shores of the Choptank River. Surrounding the area are exceptional properties, showcasing excellent property values. The primary bedroom is a peaceful sanctuary featuring a walk-in closet and attached bath. The gorgeous river room spans the entire front of the house, offering uninterrupted views of the broad Choptank River. The delightful living room boasts original pine wood walls and an exposed beam ceiling, a reflection of the rustic charm. The kitchen is a chef's dream with stainless appliances and an abundance of cabinet space. A separate laundry/storage room with custom cabinetry adds a touch of practicality. Savor the flavors of Maryland's famous crabs and relish the waterfront ambiance on your waterside deck or either of the two additional decks, all featuring water views. The paved driveway offers an RV hook-up with 30-amp electric service and a sewer connection, ensuring convenience and flexibility. **Please note major property improvements by adjoining property owners are temporary and will enhance the overall value upon completion - please understand this is not permanent**
MlsNumber: MDDO2007030


Listing Provided By: Sharon Real Estate P.C., original listing
Name: Sharon Real Estate P.C.
Phone: (410) 228-2525
Office Name: Sharon Real Estate P.C.
Office Phone: (410) 228-2525
Agent Name: Sharon Spedden
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