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

45168 Lighthouse Road
Piney Point, MD 20674
Marc Luger with Keller Williams Capital Properties, original listing - (240) 383-1350

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $797,500
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 1720 Square Feet
Agency: Keller Williams Capital Properties
Agency Phone: (240) 383-1350

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1940
Notes: PUBLIC OPEN HOUSES SATURDAY 11/9 & SUNDAY 11/10 12-4PM (Open ALL day Saturday and Sunday by appointment--Call LA to schedule or for further details)<br /> <br /> **Welcome to 45168 Lighthouse Rd. – Your Dream Vacation Getaway!** Nestled on a stunning private beachfront in sought after Piney Point, MD, this completely renovated 4 bedroom, 2 full bath property is the perfect blend of luxury and leisure. Boasting over $200,000 in upgrades and amenities completed since 2023, every corner of this home reflects modern sophistication and thoughtful design. Not only is it ideal as a specatcular vacation retreat, but also a lucrative Airbnb investment property with up to a 6 figure yearly income (Turnkey AirBnb business with ALL furnishings, service providers, marketing/advertising materials in place AND included)!<br /> <br /> The main house has been completely renovated from top to bottom and features three spacious bedrooms and two beautifully renovated full baths. Recent upgrades include a brand-new roof, enhanced electrical and plumbing systems, and energy-efficient dual-pane windows that flood the space with natural light. The interior also boasts new flooring and newly upgraded lighting and fixtures throughout while the gourmet chef's kitchen, complete with a peninsula, luxurious Quartz counters, upgraded cabinetry, and stainless steel appliances, is ideal for entertaining or enjoying cozy gatherings with loved ones<br /> <br /> In addition to the main home, the separate guest house adds even more value and versatility to this incredible property. Functioning as a bedroom and game room, the guest house also features a bar, flat-screen TV, variety of games, and lounge/seating area; making it the perfect space for entertaining friends and family or providing a cozy retreat for guests. The detached garage also doubles as a fitness room, equipped with exercise machines and weights AND extra storage space to fit your supplies….including your customized E-Z GO golf cart for on and off roading transportation.<br /> <br /> The expansive outdoor space features not only your own private beach with pier in front, but also backs to water as well! The rear features a NEW custom Trex deck with private dock and boat ramp, along with NEW entertainment-sized hot tub equipped with Bluetooth speaker system. Whether entertaining friends or relaxing under the stars, you will love the breathtaking views of serene waters that surround you. With ample parking for up to 12 cars, a newly constructed driveway and parking pad, and a NEW privacy fence surrounding the lot, this home offers both convenience and seclusion. This is truly not just a property; but a lifestyle waiting for you to embrace. Don’t miss your chance to make this slice of paradise your own!<br /> <br /> **Just ask for a list of furnishings, sporting equipment, kayaks, boats and more INCLUDED with your new home!**
MlsNumber: --
ListingId: MDSM2021476


Listing Provided By: Keller Williams Capital Properties, original listing
Phone: (240) 383-1350
Office Phone: (240) 383-1350
Agent Name: Marc Luger
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 = 1200 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;
Real Estate Expert Photo for Tyler Mattingly
Tyler Mattingly
ASCIIColdwell Banker Jay Lilly Real Estate
Call Today!: (443) 569-2796

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App