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;

Rumbley
Westover, MD 21871
Sara Pavlica with ERA Martin Associates, original listing - (410) 749-1818

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $36,000
Beds: 4
Baths: Full: 1
Status: Active
SqFt: 650 Square Feet
Agency: ERA Martin Associates
Agency Phone: (410) 749-1818

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Manufactured Home
Year Built: 2015
Notes: New rubber roof recently added.<br /> Unwind by the Bay! Your Perfect Vacation Retreat Awaits 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. Features & Amenities: Unmatched Value: At this price, experience waterfront living without breaking the bank. Prime Location: Just steps away from the water's edge, with a public boat ramp across the street for easy access. 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. Dining & Entertainment: Indulge in delicious meals and live music at nearby Pit & Pub and TIKI Bar & Grill, just across the street at the marina. Convenience: Park amenities include water, sewer, lawn care, and trash pickup - all for a hassle-free stay. Quick Move-In: Start unwinding the moment the transfer is complete. No delays, just pure relaxation. Additional Information: Price: $3,500. covers all your essentials for an effortless annual stay. Park Approval: Ensure a smooth transition by securing park approval for lot lease. Verification: Buyers and agents are encouraged to verify all listing information, including park approval and lot rent. Don't Miss Out! Call Now for Your Appointment. Experience the joys of bay life without delay. Your perfect getaway awaits - seize the opportunity today!
MlsNumber: --
ListingId: MDSO2004748


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