502 Celebration Hill Road
Biglerville, PA 17307

$895,000

Beds: 0
Baths:
Sq. Feet: 3616
MLS ID: PAAD2020422
Subdivision:
School Dist: UPPER ADAMS
The Ultimate Real Estate Compound: Two Independent Homes on 8.5+ Acres! Rarely does an asset come to market that offers both a breathtaking lifestyle and a powerhouse financial strategy. Welcome to 502 Celebration Hill Road—a spectacular 8.52-acre country compound in the heart of Biglerville’s apple country featuring two entirely separate, beautifully remodeled residences. With a recent price adjustment to $895,000 , this unique multi-unit property is a dream come true for smart investors, multi-generational buyers seeking independent living spaces, or house-hackers looking to let a tenant pay their mortgage. The Financial & Lifestyle Flexibility The House-Hacker’s Dream: Live in the luxury main farmhouse and short-term or long-term rent the second home to completely offset your housing expenses. Multi-Generational Living Without Compromise: Keep family close while maintaining absolute privacy. Two separate driveways and structures mean no shared walls, independent utilities, and separate laundry facilities in both homes. Turnkey Income Potential: Both homes underwent high-end remodeling and renovations in 2024, minimizing your immediate capital expenditures and maximizing rental premium potential. Residence 1: The Luxury Farmhouse (5 Beds, 2.5 Baths) A masterclass in mixing 1920s historic charm with modern rental appeal. Main Level Performance: Features an open-concept flow from the side entrance into a spacious eat-in kitchen with newer appliances. Includes a main-floor bedroom and an updated full bath with a spa-style rainfall shower, body jets, and main-floor laundry. Upper Levels: Four additional large bedrooms with freshly installed carpet and neutral finishes. The gorgeous second-floor full bath features a standalone soaking tub. A massive, walk-up attic provides immediate potential for future equity expansion (ideal for a game room or lounge). Finished Basement Office: Fully functional lower-level office/workspace—perfect for a home business, remote workers, or specialized storage. Residence 2: The Modern-Rustic Ranch House (4 Beds, 2 Baths) Just a short stroll away sits the second completely independent residence. Boasts a sun-drenched great room and a high-end kitchen finished with rich wood cabinetry, stainless appliances, and a custom plank ceiling. Features a cozy wood stove for efficient heating, a charming clawfoot tub, and an incredibly comfortable layout that will easily attract premium long-term tenants or high-rate vacation renters. Elite Land & Infrastructure Upside: The asset value extends far into the acreage. The flat, open topography is a blank canvas for high-ROI event hosting, micro-weddings, or weekend retreats. Outbuildings galore: Includes a massive 6-car detached garage plus a 1-car attached garage—providing premium storage or separate workshop rental income potential. The Homestead Advantage: Complete with fenced paddocks, a stable, and a dedicated goat barn. Perfect for buyers wanting a sustainable mini-farm, or to lease out pasture space. Unmatched Amenities: A tranquil, koi-stocked pond anchored by weeping willows and an outdoor stone fire pit area offers the exact "Insta-worthy" lifestyle today's renters and buyers demand. Opportunities to own a cash-flowing compound of this scale, condition, and beauty are incredibly rare. Schedule your investor tour today and explore the endless possibilities of Celebration Hill! View this listing at: http://sandraleiby.com/mls=PAAD2020422

Property Features

School Information

Printed June 15, 2026


Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 06/15/2026. The listing information on this page last changed on 06/15/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Mon 06/15/2026 1:54:34 AM EST) or Bright MLS (last updated Mon 06/15/2026 12:36:55 AM EST). Real estate listings held by brokerage firms other than Berkshire Hathaway HomeServices Homesale Realty may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.
Privacy Policy / DMCA Notice / ADA Accessibility
Federal Housing Equal Opportunity Realtor
Corporate Office - 215 S Centerville Rd. Lancaster, PA 17603
James J Hafer - West Virginia Broker of Record

©2026 BHH Affiliates, LLC. An independently owned and operated franchisee of BHH Affiliates, LLC. Berkshire Hathaway HomeServices and the Berkshire Hathaway HomeServices symbol are registered service marks of Columbia Insurance Company, a Berkshire Hathaway affiliate. Equal Housing Opportunity.


Agent License Information: 
Licensed in Pennsylvania
Sandra Bare Leiby 

1680 Kenneth Road, York, PA 17408
717-757-7811