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

2514 Eberhart Road
Quakertown, PA 18951
Nick Raimo with Keller Williams Real Estate-Montgomeryville, original listing - (215) 631-1900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $649,000
Beds: 4
Baths: Full: 2, ½: 2
Status: Active
SqFt: 4656 Square Feet
Agency: Keller Williams Real Estate-Montgomeryville
Agency Phone: (215) 631-1900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: Hidden Gem! Don’t miss out on this well maintained 4 Bedroom Colonial situated on a secluded street in Milford Township. Walk into the open 2-Story Foyer with loads of Windows and beautiful Woodwork. The Open Floor Plan has a wonderful flow, with an Office/Den, Living Room/Dining Room, Kitchen & Family Room. The Gourmet Kitchen is a loaded with a Hallman 40” Gas Oven, Large Island, Wet Bar, Wine Frig, and plenty of Counter & Cabinet space. The Expansive Family Room has lots of Natural Light and Gas Fireplace. Main Floor Laundry. The 2nd Floor has a Master Bedroom Suite with an Office/Sitting Area, Walk-In Closet, and Master Bathroom with Stall Shower, Jet Tub, and Dual Sink Vanity. The three other Bedrooms are large and have good Closet Space. The Hall Bath has a separate Vanity & Shower Area. Back Stairs complete the 2nd Floor. The Finished Basement is an Entertainer’s dream featuring a Wet Bar & Wine Cellar, Open Area for playing or relaxing, a separate Gym Area, and a Half Bath. The Outside Area is just as inviting with a Huge Stamped Concrete Patio. Gas hook-up for you Grille makes outside cooking simple. New HVAC and Hot Water Heater in 2022. Close to Routes 309, 663, and the PA Turnpike. Plenty of shopping and dining only minutes away. Call to make your appointment today! Sellers offering a $5000.00 assist towards landscaping around the Patio area.
MlsNumber: --
ListingId: PABU2088038


Listing Provided By: Keller Williams Real Estate-Montgomeryville, original listing
Phone: (215) 896-4949
Office Phone: (215) 631-1900
Agent Name: Nick Raimo
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App