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

Lot 2 Limekiln Pike
Chalfont, PA 18914

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,299,000
Beds: 4
Baths: 4
Status: Active
SqFt: 5600
Agency: Realty Associates Group

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: --
Notes: M Gold Building Group presents quality New Construction to be built - A custom home on a gorgeous 2.8-acre lot. This is a must-see home with luxury details and thoughtful touches added throughout! 5,600 sq ft, 4 BR, 3.5 Bath Colonial with 3 car Garage. Quality Construction throughout. 2x6 exterior walls. Anderson 200 series windows. Crown molding, ceiling fans & custom lighting, including recessed lights throughout. Luxury baths with Century cabinetry. Wide plank hardwood floors throughout the entire house. Large, open 2-story foyer with a "T" Staircase overlooks 2-story Family room with stone gas fireplace and Breakfast room. Formal LR & Formal DR with Tray Ceiling. Hall off of Family room leads to large 1st floor Study & Powder room. Gorgeous luxury, center island Kitchen by Century Kitchens with quartz countertops, large pantry & stainless steel appliances. Breakfast room and Sunroom with a full wall of windows. Mudroom off kitchen with built-in bench & custom shelving with access to 3 car attached garage with insulated garage doors. Den with double glass doors. Oak stairs with poplar risers and painted balusters lead to the 2nd-floor landing with hardwood floors that overlooks the Family room below. MasterBedroom Suite with double door, tray ceiling, sitting area, separate make-up vanity, large walk-in closet & luxury bath with 6 ft seamless glass door shower with built-in seat, dual heads, double vanity & separate wash closet. 3 additional large bedrooms all offer walk-in closets. The 4th Bedroom features a full ensuite bath. Full Hall bath with double vanity & tub/shower. Convenient 2nd floor Laundry room with large closet &attached Utility room. full, walk-out Basement with 9' ceilings, . . 3 Zoned central air & gas heat. . Poured concrete foundation. Full glass front &side doors. Every room is wired for cable. Don't miss this beautiful custom home!
MlsNumber: PABU2064856


Listing Provided By: Realty Associates Group, original listing
Name: Realty Associates Group
Phone: (215) 343-9950
Office Name: RE/MAX Signature
Office Phone: (215) 343-9950
Agent Name: John Spognardi
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 = 2247 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 Fay Evans & Bernadette Clayton
Fay Evans & Bernadette Clayton
ASCIIKeller Williams
Fay: (215) 915-8047
Bernadette: (267) 614-8406

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App