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 = 2276 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 = 2276 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 = 2276 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 Hummingbird Way
Palmyra, PA 17078

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,450,000
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 6812 Square Feet
Agency: Lusk & Associates Sotheby's International Realty
Agency Phone: (717) 291-9101

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2015
Notes: Welcome to a residence of unparalleled elegance nestled within the esteemed Estates of Forest Ridge. This exquisite estate, set amidst lush woodlands, epitomizes the art of sophisticated living and is an ideal for hosting gatherings. Upon entering, you are welcomed by an impressive foyer showcasing rich hardwood floors. The thoughtfully designed layout features five bedrooms, five full bathrooms, and a powder room. Every window offers serene views of the surrounding natural beauty, ensuring a tranquil, private retreat. The gourmet kitchen is a chef’s dream, boasting custom cabinetry, a KitchenAid stove with dual ovens and a six-burner cooktop, a sleek hood vent, two dishwashers, and a pantry. A stylish wine bar, accessible from both the kitchen and the formal dining room, adds an extra touch of luxury. Integrated home audio speakers create a perfect ambiance for enjoying your favorite tunes. Adjacent to the kitchen, the sun-drenched Sunroom, with its radiant heated floors, provides an inviting space to enjoy the winter season and panoramic nature views. The main-level primary suite is a sanctuary of comfort, featuring expansive dimensions, two walk-in closets, a cozy sitting area, and access to a screened porch. The spa-like primary bathroom is complete with double sinks, a Victoria + Albert soaking tub, a water closet, and a walk-in shower with dual shower heads. The main floor also includes luxurious office with French doors, a second bedroom with an en-suite bathroom and its own private screened porch, perfect for serene moments in nature. On the upper level, two additional bedrooms and two full bathrooms offer ample space and privacy. The lower level is an entertainer’s paradise, highlighted by a grand recreation room. Here, you’ll find a bar area with an island, a dedicated game room, and a theater room equipped with surround sound for an immersive cinematic experience. Additionally, this level features an exercise room and a spacious bedroom with two walk-in closets and a full bathroom. Enjoy seamless indoor-outdoor living with walk-out access to the beautifully appointed exterior, which includes a patio and a fire pit for all to enjoy. Don’t miss the opportunity to experience this magnificent home firsthand. Schedule your private showing today to discover the luxurious lifestyle that awaits.
MlsNumber: --
ListingId: PALN2016462


Listing Provided By: Lusk & Associates Sotheby's International Realty, original listing
Phone: (717) 291-9101
Office Phone: (717) 291-9101
Agent Name: Anne M Lusk
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 = 2276 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 Stephanie Butler
Stephanie Butler
ASCIISuburban Realty
Call Today!: (717) 222-0584

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App