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

199 W Lakeview Drive W
Hamlin, PA 18427
Marieann P. Duffy-Mates with C21 Jack Ruddy Real Estate, original listing - (570) 344-6724

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $305,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1172 Square Feet
Agency: C21 Jack Ruddy Real Estate
Agency Phone: (570) 344-6724

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2019
Notes: Viewings will start Monday, 3/17/25 with full 24 hour appointments!Have you dreamed of owning a log cabin in a beautiful rustic land space? This home is the answer to your dreams. This is a beautiful, rustic, log cabin. It has a convenient paved driveway , nice front porch and large back deck. Further out in the back yard is a fire pit with stacked wood nearby. Imagine the gatherings or quiet time in this beautiful setting. Through the front door you will find the living room with electric fireplace to the right and taking the left side walk up to the bar after a long day at work. The modern kitchen has stove, microwave, refrigerator and dishwasher. The laundry room is tucked away behind bifold doors. Down the hall is a full bath with soaker tub. and 1st floor bedroom. Wake up every morning to a view of nature in your back yard. Upstairs is a 3/4 bath with shower. There is a large loft area with it's own balcony and the 2nd floor bedroom with closet. There is also a storage shed on the property. this property is located in a gated community with many amenities.For example, 24 Hour Security, Gated Entrance, Clubhouse, Lodge, Campgrounds, 250 Acres Of Pristine Woodlands, and a Dog Park. Additionallyone can find a Recreational Sports Complex, Golf Course, Indoor/Outdoor Tennis, Power Boat Lake, Two Sand Beaches, Two Heated Outdoor Pools, Physical Fitness Center, Mini Golf, Art Center, Woodworkers Building, Ski Lift and Lodge, Tubing Run. (Details per The Hideout website)The furnace is new and under lease via contract with T.E. Spall and Sons. This contract is available for review as the Buyer can assume the contract. Currently, there is a tenant in the dwelling. The landlord describes him as a wonderful person. His lease expires in July, 2025. He would like to stay one more year until his son graduates from highschool. His son lives nearby. The tenant understands if he has to move but would like to stay. Full 24 hour notice is required
MlsNumber: --
ListingId: SC251026


Listing Provided By: C21 Jack Ruddy Real Estate, original listing
Phone: (570) 344-6724
Office Phone: (570) 344-6724
Agent Name: Marieann P. Duffy-Mates
Disclaimer: Copyright © 2025 Greater Scranton Board 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 = 2302 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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 Jack Gomez
Jack Gomez
ASCIICentury 21 Sundance Realty
Call Today!: (570) 878-9646

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App