Title Page Background
DEBUG FN args: Array ( [0] => 3237 [1] => [2] => [3] => agent ) BEFORE: Site: 3237 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3237 Igate: njhud LocID: 3237 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3237 AND i.igate IN ('pahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3237 [1] => [2] => [3] => lender ) BEFORE: Site: 3237 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3237 Igate: njhud LocID: 3237 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3237 AND i.igate IN ('pahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3237 [1] => [2] => [3] => other ) BEFORE: Site: 3237 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3237 Igate: njhud LocID: 3237 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3237 AND i.igate IN ('pahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

118 Davis Drive
North Wales, PA 19454
John Petty with Homestarr Realty, original listing - (215) 355-5565

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,190,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 5272 Square Feet
Agency: Homestarr Realty
Agency Phone: (215) 355-5565

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1994
Notes: ***OPEN HOUSE (Public) Sun, Apr 27 1:00 PM - 3:00 PM***<br /> Stunning Guidi-Built Stone & Stucco Home on Premium Lot Backing to Park-like Setting.<br /> <br /> Welcome to this beautifully crafted residence featuring a striking stone and stucco façade, nestled on a meticulously landscaped, private lot with serene views- including layers of beautiful flowering trees, Wissahickon stream and backing up to woods. Newer roof and upgraded windows add to the curb appeal and efficiency of this 5,272 finished square foot property. The grand two-story foyer sets the tone for elegance, leading to a sophisticated formal living room and dining room—perfect for entertaining.<br /> <br /> The impressive two-story family room is filled with natural light from skylights and features a floor-to-ceiling stone fireplace, creating a warm and inviting atmosphere. A private first-floor study offers the ideal space for a home office or library.<br /> <br /> The spacious kitchen is a chef’s dream, complete with a granite island, tiled backsplash, and abundant cabinetry. A rear staircase provides added convenience and flow throughout the home.<br /> <br /> Upstairs, the luxurious master suite boasts a generous sitting area, dual walk-in closets, and an additional closet for extra storage. The spa-inspired master bath includes a soaking tub and separate shower for ultimate relaxation.<br /> <br /> The fully finished walkout basement is designed for entertaining, featuring a custom oak bar and direct access to the newly upgraded, oversized engineered wood deck—optimal for year-round enjoyment. There is an additional bedroom on the basement level, perfect for guests. A large shed for extra storage adds to the charm of this property.<br /> <br /> This exceptional 5/6 Bedroom home offers the perfect blend of luxury, comfort, and privacy. A must-see for the discerning buyer.<br /> <br /> Room Measurements<br /> Main Building<br /> MAIN FLOOR<br /> Bath: 5'1" x 6'11" (5' x 6.9') | 35 sq ft<br /> Breakfast: 10'11" x 13'2" (11' x 13.1') | 142 sq ft<br /> Dining: 13' x 15'11" (13' x 15.9') | 207 sq ft<br /> Family: 18'4" x 13'3" (18.3' x 13.3') | 243 sq ft<br /> Foyer: 14'11" x 11'8" (14.9' x 11.7') | 136 sq ft<br /> Garage: 32'10" x 20'3" (32.9' x 20.2') | 665 sq ft<br /> Kitchen: 15'5" x 12'11" (15.4' x 12.9') | 187 sq ft<br /> Laundry: 7' x 7'7" (7' x 7.5') | 53 sq ft<br /> Living: 21' x 15' (21' x 15') | 284 sq ft<br /> Office: 13'8" x 13'6" (13.7' x 13.5') | 186 sq ft<br /> 2ND FLOOR<br /> Bath: 10'11" x 8' (10.9' x 8') | 71 sq ft<br /> Bath: 9'3" x 13'8" (9.3' x 13.7') | 127 sq ft<br /> Bath: 7'6" x 8' (7.5' x 8') | 52 sq ft<br /> Bedroom: 10'11" x 13'1" (10.9' x 13.1') | 142 sq ft<br /> Bedroom: 13'7" x 11' (13.6' x 11') | 149 sq ft<br /> Bedroom: 10'11" x 11'3" (10.9' x 11.2') | 123 sq ft<br /> Bedroom: 17'9" x 14'5" (17.7' x 14.4') | 233 sq ft<br /> Den: 10'11" x 26'10" (10.9' x 26.9') | 247 sq ft<br /> Primary: 23' x 13'8" (23' x 13.7') | 249 sq ft<br /> BASEMENT<br /> Bar: 12'9" x 7'5" (12.8' x 7.4') | 67 sq ft<br /> Den: 9'6" x 12'11" (9.5' x 12.9') | 121 sq ft<br /> Rec Room: 31'9" x 39'10" (31.8' x 39.8') | 876 sq ft<br /> Storage: 18'3" x 30'3" (18.3' x 30.2') | 448 sq ft<br /> Note: Only major rooms are listed. Some listed rooms may be excluded from total interior floor area (e.g. garage). Room dimensions are largest length and width; parts of room may be smaller. Room area is not always equal to product of length and width.<br /> <br /> <br /> Floor Area Information:<br /> <br /> MAIN FLOOR<br /> Finished Area: 1915.18 sq ft<br /> Unfinished Area: 707.34 sq ft<br /> <br /> 2ND FLOOR<br /> Finished Area: 2059.22 sq ft<br /> Unfinished Area: 39.09 sq ft<br /> <br /> BASEMENT (Below Grade)<br /> Finished Area: 1223.21 sq ft<br /> Unfinished Area: 492.57 sq ft<br /> <br /> ANSI Z765-2021, Main Building<br /> Above Grade Finished Area: 3974.40 sq ft<br /> Above Grade Unfinished Area: 746.43 sq ft<br /> <br /> Below Grade Finished Area: 1223.21 sq ft<br /> Below Grade Unfinished Area: 492.57 sq ft
MlsNumber: --
ListingId: PAMC2135744


Listing Provided By: Homestarr Realty, original listing
Phone: (215) 355-5565
Office Phone: (215) 355-5565
Agent Name: John Petty
Disclaimer: Copyright © 2025 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => montgomery-central [3] => PA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: montgomery-central State: PA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: montgomery-central State: PA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3237 AND i.igate IN ('pahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Ginger Childs
Ginger Childs
ASCIIRE/MAX Achievers
Call Today!: (610) 960-3456

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App