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

1737 Upper Stump Road
Perkasie, PA 18944
Gus Wagner with BHHS Fox & Roach Collegeville, original listing - (610) 831-5300

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,500,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3730 Square Feet
Agency: BHHS Fox & Roach Collegeville
Agency Phone: (610) 831-5300

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Other-Other
Year Built: 2024
Notes: **Join us Thursday or Sunday at our Open House** Incredible new construction home by Winterwood Associates! This Meticulously designed and fully finished property is now complete and ready for you to move in. Nestled on a spacious 3-acre lot in the highly sought-after Central Bucks School District, this custom Modern Farmhouse showcases unparalleled quality and craftsmanship throughout. The spacious, open floor plan makes this the perfect home for entertaining, while the outdoor acreage allows for an incredible opportunity to make your own backyard oasis. Upon entering through the beautiful foyer, you'll marvel at the unique herringbone pattern flooring, high ceilings, and grand staircase. To the right of the foyer is a formal living area, opening into an office space with double-door privacy. From the foyer to the left is an incredible formal dining room that will accommodate all of your family gatherings. Continue through the foyer to enter the large gourmet kitchen, featuring an enormous island with plenty of seating, gas range with a beautiful hood, and incredible cabinet space. The cozy morning room and generously sized family room add wonderful living space with vaulted ceilings and a gas fireplace. The mudroom and powder room are both located next to the garage, making it an easy entry and exit to your vehicles. The second floor features a primary suite and 3 additional spacious bedrooms, each with private access to a full bathroom. The primary suite comes complete with a vast walk-in closet, dressing area, and primary bath, featuring both a soak-in tub and expansive traditional shower. The laundry room is conveniently located on the second floor, and the attic space can easily fit an additional three bedrooms. The enormous basement provides ample storage space and is ready to be finished as an additional living area. Don't miss out on this gorgeous new construction home in an award-winning school district!
MlsNumber: --
ListingId: PABU2080586


Listing Provided By: BHHS Fox & Roach Collegeville, original listing
Phone: (215) 280-2648
Office Phone: (610) 831-5300
Agent Name: Gus Wagner
Disclaimer: Copyright © 2024 Berkshire Hathaway HomeServices Fox & Roach, Realtors. 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 = 3445 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 Julie Thomer
Julie Thomer
ASCIIBHHS Fox and Roach Doylestown
Call Today!: (267) 236-6050

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App