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

000 Rumbley Rd
Westover, MD 21871

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $20,000
Beds: 1
Baths: 1
Status: Active
SqFt: 300
Agency: ERA Martin Associates

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1986
Notes: Unwind by the Bay! Your Perfect Vacation Retreat Awaits<br /> Escape to your own slice of paradise with this charming vacation home, being sold AS IS. Forget worries and indulge in the ultimate bay experience - whether it's fishing, crabbing, kayaking, crabbing, boating or simply soaking up the sun.<br /> Features & Amenities:<br /> Unmatched Value: At this price, experience waterfront living without breaking the bank.<br /> Prime Location: Just steps away from the water's edge, with a public boat ramp across the street for easy access.<br /> Endless Recreation: Enjoy fishing, crabbing, water skiing, boating, jet skiing, kayaking, and canoeing - right at your doorstep. Kick back on the screen porch and savor stunning sunsets over the bay. Extra Refrigerator on porch to store all those extra adult beverages.<br /> Dining & Entertainment: Indulge in delicious meals and live music at nearby Pit & Pub and TIKI Bar & Grill, just across the street at the marina.<br /> Convenience: Park amenities include water, sewer, lawn care, and trash pickup - all for a hassle-free stay.<br /> Quick Move-In: Start unwinding the moment the transfer is complete. No delays, just pure relaxation.<br /> Additional Information:<br /> Price: $3200 covers all your essentials for an effortless annual stay.<br /> Park Approval: Ensure a smooth transition by securing park approval for lot lease.<br /> Verification: Buyers and agents are encouraged to verify all listing information, including park approval and lot rent.<br /> Don't Miss Out! Call Now for Your Appointment.<br /> Experience the joys of bay life without delay. Your perfect getaway awaits - seize the opportunity today!<br /> Note: Selling AS IS with everything included. Buyer/buyer's agent must verify all information to their satisfaction.
MlsNumber: MDSO2004464


Listing Provided By: ERA Martin Associates, original listing
Name: ERA Martin Associates
Phone: (410) 749-1818
Office Name: ERA Martin Associates
Office Phone: (410) 749-1818
Agent Name: Sara Pavlica
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