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

931 Harleysville Pike
Harleysville, PA 19438
Mr. Gary A Mercer SR. with KW Greater West Chester, original listing - (610) 436-6500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,619,900
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 5603 Square Feet
Agency: KW Greater West Chester
Agency Phone: (610) 436-6500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2025
Notes: New Year..New Home! Don't miss this last chance to live at Briarwood... an exclusive enclave of four sprawling estate homes on private homesites, each over two acres. Design your dream home from one of our spacious floor plans offering modern must have features like main level guest suites, dramatic two story spaces, spacious mudrooms, second floor laundry rooms and expansive windows. With the Eddy Homes Design Advantage experience offering custom-curated design options with a complete selection of high-end finishes, these homes will truly make a statement. Nestled just a mile away, is Skippack Village with its array of boutique shopping, top-tier dining options, and lively activities, including popular First Fridays and Signature Skippack Days. The community's prime location ensures easy accessibility to major highways for easy access to Collegeville and Blue Bell. Even Center City Philadelphia is only 30 miles away. Enjoy the perfect blend of serene countryside living, sophistication and convenience.<br /> <br /> Enter this luxurious, custom European style floor plan through a grand two-story foyer. The immense kitchen boasts two 10’ islands and opens up to a breakfast room filled with windows. The two-story great room complete with a window wall & floor-to-ceiling stone fireplace beams with natural light. The first floor is finished off by a study featuring a fireplace & built-ins, a spacious dining room & a guest suite. An oversized mudroom, conveniently situated off the 4-car split garage, features built-ins and a walk-in pantry. The second floor offers an enormous owner’s suite including a luxury spa-like bath boasting dual sinks, a free-standing soaking tub, and a massive shower. This suite also includes two giant walk-in closets, a secluded sitting room, and a balcony overlooking the backyard. Three more bedrooms finish off the second floor each adorned with it's own private bath. ** Pictures are of a previously built Eddy Homes Property. Actual finishes and pricing will vary based on homeowner selections.
MlsNumber: --
ListingId: PAMC2125092


Listing Provided By: KW Greater West Chester, original listing
Phone: (484) 266-7440
Office Phone: (610) 436-6500
Agent Name: Mr. Gary A Mercer SR.
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 = 2284 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;
Andrea Audsley
ASCIIKeller Williams Real Estate
Call Today!: (267) 391-7354

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App