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

127 Rose Lane
Horsham, PA 19044

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,000,000
Beds: 5
Baths: 6
Status: Active
SqFt: 7000
Agency: RE/MAX Centre Realtors

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential
Year Built: --
Notes: TO BE BUILT! Prime Custom Builders, LLC, is proud to unveil Rose Lane Manor. After years of dedication and hard work, isn't it time you crafted a sanctuary that reflects your refined taste? Seize this moment to build a stately manor home that exudes opulence and sophistication while effortlessly blending luxury with creature comforts. Nestled within a serene backdrop on the highly sought-after Rose Lane, this bespoke estate awaits your personal touches from the ground up. Set on a lush, 5-acre wooded expanse, this property epitomizes exclusivity with its cul-de-sac location. Picture an expansive open floor plan, where natural light bathes the interiors through generous windows, illuminating the residence's splendor. The state-of-the-art kitchen will be tailored to your preferences, capable of catering to grand soirées or those cherished intimate dinners for two. Pair it with your choice of high-end appliances to cultivate your culinary prowess. Beside the kitchen, an expansive great room, anchored by a cozy fireplace, emerges as the heart of the home and offers the perfect backdrop to any occasion. With soaring 10+ foot ceilings, the ambiance and grandeur of your custom-to-be-built home will be undeniable. Formal living and dining rooms set the stage for elegant gatherings. For those who prioritize a balance between home and work, the private study provides a tranquil oasis, ensuring productivity and focus in the comfort of your own home. Five sumptuous bedrooms, complemented by four lavish full bathrooms and two elegant half baths, ensure every need is catered to with finesse. Whether you desire a grand entertainment space or a relaxing reading nook, this residence provides the canvas for your aspirations. Its customizable nature ensures that both its interiors and exteriors resonate with your unique style. For the discerning buyer craving unmatched luxury and an opportunity to shape a personalized sanctuary, Rose Lane Manor awaits. Embark on this journey to design a legacy estate, a testament to your achievements and aesthetic. The door to your dream is ajar – are you ready to step through?<br /> <br /> Photographic Portfolio Disclaimer: The images featured in this listing are representative of a 10,000 square foot home valued above $5M, intended to demonstrate the superior craftsmanship, high-end finishes, and potential upgrades available. The home being offered at the list price of $4M reflects a 7,000 square foot property with a similar design aesthetic. Please note that certain finishes and features depicted may be upgrades and are not included in the base price. We invite interested buyers to inquire for a detailed list of standard finishes and available upgrades to fully customize their new home to their tastes and preferences.
MlsNumber: PAMC2088116


Listing Provided By: RE/MAX Centre Realtors, original listing
Name: RE/MAX Centre Realtors
Phone: (215) 343-8200
Office Name: RE/MAX Centre Realtors
Office Phone: (215) 343-8200
Agent Name: Sheri Oshins
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 = 3238 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 Kim Tonetti
Kim Tonetti
ASCIIBerkshire Hathaway HomeServices Powered by Fox and Roach Realtors
Call Today!: (610) 721-6006

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App