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 = 2290 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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 = 2290 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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 = 2290 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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;

129 Lakewood Drive
Dingmans Ferry, PA 18328
Lisa McAteer with Keller Williams RE 402, original listing - (570) 832-4425

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $750,000
Beds: 3
Baths: Full: 4
Status: Active
SqFt: 5091 Square Feet
Agency: Keller Williams RE 402
Agency Phone: (570) 832-4425

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: STUNNING LAKEFRONT HOME! PLENTY OF ROOM FOR FAMILY AND FRIENDS! CENTRAL A/C! SAUNA! POOL TABLE! GARAGE! FINISHED BASEMENT! COMMUNITY SWIMMING POOLS! Just in time for Summer and just 90 minute from NYC find this turn-key custom-built luxurious property featuring cathedral ceilings, hardwood floors, 5 bedrooms (legal 3 with 2 bonus rooms with closets), 4 bathrooms, and more than 5,000 finished sqft of living space. PROFESSIONALLY CLEANED! FRESHLY PAINTED! OWNER IS A CONTRACTOR! Enjoy WOW factor upon entry with WATER VIEWS THROUGH THE BACK OF THE HOME, glowing hardwood floors, an open floor plan and a main floor boasting 1776 finished SQFT. A chef's dream kitchen opens to a large dining room; the perfect home for big parties, family gatherings, and huge get away weekends for all your guests! A stone-faced fireplace with two sconces is the focal piece of your living room which also has tons of beautiful windows! A bonus room on the main floor can be a 6th bedroom or office! Your primary suite is 360 SQFT with stunning lake views, a spa like bathroom, walk-in closet, and private office/nursery area! Four more large bedrooms and a guest bathroom complete the 2nd floor. Your finished walk-out basement leads out to a paver patio perfect for tanning, a fire-pit. Inside a huge family room/game room, another full bathroom and sauna makes this house the perfect destination when you need to relax and have fun! Additional features include a loft area, multiple staircases for easy navigation between floors, and an unfinished, framed walk-up attic space with potential for customization. The exterior boasts a expansive deck overlooking a serene, snow-covered landscape, providing a perfect spot for outdoor enjoyment in all seasons. DO NOT MISS THIS OPPORTUNITY TO OWN A ONE OF A KIND WATER FRONT PROPERTY IN A GATED DESIRABLE COMMUNITY IN BEAUTIFUL NORTHEAST PENNSYLVANIA!
MlsNumber: --
ListingId: PW-250519


Listing Provided By: Keller Williams RE 402, original listing
Phone: (570) 213-4871
Office Phone: (570) 832-4425
Agent Name: Lisa McAteer
Disclaimer: Copyright © 2025 Pike/Wayne Association of Realtors 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 = 2290 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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 Property Sisters of Hudson Valley
Property Sisters of Hudson Valley
ASCIIKeller Williams Hudson Valley United
Call Today!: (518) 491-2585
Mobile: (845) 741-5608

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App