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

849 S Preston Road
Lakewood, PA 18439
Lyndsey Tilton with Coldwell Banker Lakeview Realtors, original listing - (570) 226-4000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,350,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 3706 Square Feet
Agency: Coldwell Banker Lakeview Realtors
Agency Phone: (570) 226-4000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 44 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: Welcome to turnkey luxury living! This stunning estate, sitting on 45 acres, offers the perfect blend of modern luxury and timeless elegance, nestled amidst the serene beauty of Lakewood, Pennsylvania with a crystal clear private pond.Expansive Living Spaces: Soaring ceilings, abundant natural light, and thoughtfully designed interiors create an atmosphere of sophistication.Private Oasis: Unwind in your own private sanctuary, featuring a serene pond, well maintained trails, and picturesque landscapes.Luxurious Amenities: Indulge in the ultimate comfort with radiant floor heating, a state-of-the-art wine cellar, and three inviting fireplaces. Relax in the sauna before soaking in the jetted tub.Versatile Spaces: The detached three-car garage built in 2021 boasts a game room, sauna, bathroom, and office.Sustainable Living: Embrace eco-friendly living with two separate solar systems powering both the home and garage, with battery backup for if the power goes out.Gourmet Kitchen: A culinary masterpiece featuring top-of-the-line appliances, custom cabinetry, and a spacious island perfect for entertaining.Prime Location: Enjoy the peace and privacy of country living, while remaining conveniently close to local amenities and attractions.Outdoor Paradise: Unwind on the expansive patio, host unforgettable gatherings in front of the outdoor fireplace, or simply bask in the tranquility of the surrounding nature by the private pond.This extraordinary property offers an unparalleled opportunity to experience the finer things in life. Schedule a private tour today and discover your favorite place to be!
MlsNumber: --
ListingId: PW-243704


Listing Provided By: Coldwell Banker Lakeview Realtors, original listing
Phone: (570) 226-4000
Office Phone: (570) 226-4000
Agent Name: Lyndsey Tilton
Disclaimer: Copyright © 2024 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 = 2302 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 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