502 Celebration Hill Rd
Description
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!
- Listed by KEITH LIPARI • RE/MAX 1st AdvantageP: (717)-636-1101 keithlipari@gmail.com
Property Details for 502 Celebration Hill Road
Property Details for 502 Celebration Hill Road
| Status | Active |
|---|---|
| MLS # | PAAD2020422 |
| Days on Market | 238 |
| Taxes | $5,531 / year |
| HOA Fees | - |
| Condo/Co-op Fees | - |
| Property Type | Multi Family |
| MLS Type | Multi-Family / Fee Simple |
| Year Built | 1920 |
| Lot Size | 8.52 AC / 371,131 SF |
| County | Adams County |
Location
Building Information for 502 Celebration Hill Road
Payment Calculator
$4,921 per month
30 year fixed, 6.36% Interest
$4,460
$461
$0
Know your buying power with a preapproval and custom rate in minutes
1Property Information for 502 Celebration Hill Road
- School District Name: UPPER ADAMS
- School District County ID: 300200396614
- SchoolDistrictSource: 3rd Party
- High School: BIGLERVILLE (ADAMS PA)
- HighSchoolSource: 3rd Party
- County: ADAMS
- MLS Area: Menallen Twp (14329)
- Water View: No
- Water Access: No
- Water Oriented: No
- Navigable Water: No
- Tidal Water: No
- Riparian Rights Y/N: No
- Tax Year: 2015
- Tax Assessed Value: $320,500
- Year Assessed: 2011
- County Tax: $1,256
- Improvement Assessed Value: $165,600
- City Town Tax: $142
- Land Assessed Value: $154,900
- Special Assessment Pymnt: Annually
- Zoning: RESIDENTIAL
- Automatically Update Tax Values Y/N: No
- Single Room Units Count: 0
- One Bedroom Units Count: 0
- Two Bedroom Units Count: 0
- Three Bedroom Units Count: 2
- Other Units: Unit 1,Unit 2
- Number Of Units Vacant: 2
- Type: Unit 2
- Beds Total: 4
- Half Baths Count: 1
- Full Baths Count: 2
- Total Rooms: 13
- Type: Unit 1
- Unit Type Occupied YN: No
- Unit Type Finished SQFT: 1843
- Beds Total: 5
- Half Baths Count: 0
- Full Baths Count: 2
- Total Rooms: 14
- Year Major Reno Remodel: 2024
- Building Units Total: 2
- Total Finished SQFT: 3,616.00
- Total Finished SQFT Source: Estimated
- Total SQFT: 5,016.00
- Total SQFT Source: Estimated
- Construction Materials: Vinyl Siding
- Flooring Type: Carpet, Engineered Wood, Ceramic Tile
- Basement Type: Full, Interior Access, Partially Finished
- Foundation Details: Block
- Other Structure: 2nd House, Barn/Stable
- Lot Size Source: Estimated
- Lot Features: Backs to Trees, Pond
- Location Type: Rural
- Parcel ID: 11206884
- Type Of Parking: Detached Garage
- Num of Detached Garage Spaces: 6
- Total Garage Spaces: 6
- Garage Features: Additional Storage Area
- Interior Features: Dining Area, Other, Attic, Bathroom - Soaking Tub, Bathroom - Stall Shower, Bathroom - Tub Shower, Bathroom - Walk-In Shower, Breakfast Area, Carpet, Ceiling Fan(s), Entry Level Bedroom, Floor Plan - Traditional, Wood Floors
- Fireplace: Yes
- Fireplaces Count: 1
- Appliances: Dishwasher, Stove, Built-In Microwave
- Accessibility Features: 2+ Access Exits
- Exterior Features: Outbuilding(s)
- Outdoor Living Structures: Patio(s)
- Pool: No Pool
- Heating: Yes
- Cooling Type: Central A/C
- Cooling Fuel: Electric
- Heating Type: Forced Air
- Heating Fuel: Oil
- Hot Water: Electric
- Water Source: Well
- Sewer Septic: Septic Exists
- List Agent AOR: Greater Harrisburg Association of REALTORS
- List Agent URL: www.welcometohomepa.com
Property History for 502 Celebration Hill Road
| Date | Event & Source | Price | Appreciation |
|---|---|---|---|
| Jun 5, 2026 | Price Change BRIGHT #PAAD2020422 | $895,000 | — |
| Jun 5, 2026 | Price Change BRIGHT #PAAD2020406 | $895,000 | — |
| May 13, 2026 | Price Change BRIGHT #PAAD2020422 | $935,000 | — |
| May 13, 2026 | Price Change BRIGHT #PAAD2020406 | $935,000 | — |
| Nov 1, 2025 | Listed (Active) BRIGHT #PAAD2020422 | $990,000 | — |
| Nov 1, 2025 | Listed (Active) BRIGHT #PAAD2020406 | $990,000 | — |
| Jul 8, 2016 | Closed (Public Record) Public Record #1080829290 | $290,000 | — |
| Jul 8, 2016 | Withdrawn BRIGHT #1003202019 | $290,000 | — |
| Jun 24, 2016 | Closed BRIGHT #1003003015 | $290,000 | — |
| Apr 29, 2016 | Withdrawn BRIGHT #1002176688 | — | |
| Apr 27, 2016 | Pending BRIGHT #1003003015 | — | |
| Apr 11, 2016 | Listed (Active) BRIGHT #1002176688 | $299,900 | — |
| Apr 7, 2016 | Listed (Active) BRIGHT #1003202019 | $299,900 | — |
| Mar 28, 2016 | Listed (Active) BRIGHT #1003003015 | $299,900 | — |
| Date | Event & Source | Price |
|---|---|---|
| 06/05/2026 | Price Change BRIGHT #PAAD2020422 | $895,000 |
| 06/05/2026 | Price Change BRIGHT #PAAD2020406 | $895,000 |
| 05/13/2026 | Price Change BRIGHT #PAAD2020422 | $935,000 |
| 05/13/2026 | Price Change BRIGHT #PAAD2020406 | $935,000 |
| 11/01/2025 | Listed (Active) BRIGHT #PAAD2020422 | $990,000 |
| 11/01/2025 | Listed (Active) BRIGHT #PAAD2020406 | $990,000 |
| 07/08/2016 | Closed (Public Record) Public Record #1080829290 | $290,000 |
| 07/08/2016 | Withdrawn BRIGHT #1003202019 | $290,000 |
| 06/24/2016 | Closed BRIGHT #1003003015 | $290,000 |
| 04/29/2016 | Withdrawn BRIGHT #1002176688 | — |
| 04/27/2016 | Pending BRIGHT #1003003015 | — |
| 04/11/2016 | Listed (Active) BRIGHT #1002176688 | $299,900 |
| 04/07/2016 | Listed (Active) BRIGHT #1003202019 | $299,900 |
| 03/28/2016 | Listed (Active) BRIGHT #1003003015 | $299,900 |
For completeness, we often displays two records for one sale: the MLS record and the public record.
Public Records for 502 Celebration Hill Road
Schools near 502 Celebration Hill Road
Rating | School | Type | Grades | Distance |
|---|---|---|---|---|
| Public - | 4 to 6 | |||
| Public - | 7 to 8 | |||
| Public - | 9 to 12 | |||
| Public - | K to 3 |
Rating | School | Distance |
|---|---|---|
Upper Adams Intermediate School Public4 to 6 | ||
Upper Adams Middle School Public7 to 8 | ||
Biglerville High School Public9 to 12 | ||
Biglerville El School PublicK to 3 |
School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.
Similar Homes
Explore Nearby Homes
- Butler Township - Adams County Homes for Sale
- Cashtown Homes for Sale
- Cooke Township - Cumberland County Homes for Sale
- Flora Dale Homes for Sale
- Franklin Township - Adams County Homes for Sale
- Highland Township - Adams County Homes for Sale
- McKnightstown Homes for Sale
- Menallen Township - Adams County Homes for Sale
- Southampton Township - Cumberland County Homes for Sale
- Southampton Township - Franklin County Homes for Sale
- South Newton Township - Cumberland County Homes for Sale
- Straban Township - Adams County Homes for Sale
- Table Rock Homes for Sale
- Tyrone Township - Adams County Homes for Sale
- Heidlersburg Homes for Sale
- Biglerville Homes for Sale
- Arendtsville Homes for Sale
- Bendersville Homes for Sale
- Aspers Homes for Sale
- Orrtanna Homes for Sale
- Gardners Homes for Sale
- Shippensburg Homes for Sale
- Walnut Bottom Homes for Sale
- Gettysburg Homes for Sale
- Peach Glen Homes for Sale
- Fairfield Homes for Sale
- Fayetteville Homes for Sale
- York Springs Homes for Sale
- Scotland Homes for Sale
- New Oxford Homes for Sale
- 17325 Homes for Sale
- 17257 Homes for Sale
- 17303 Homes for Sale
- 17304 Homes for Sale
- 17324 Homes for Sale
- 17353 Homes for Sale
- 17222 Homes for Sale
- 17350 Homes for Sale
- 17306 Homes for Sale
- 17372 Homes for Sale
- 17241 Homes for Sale
- 17320 Homes for Sale
- 17266 Homes for Sale
- 17202 Homes for Sale
- 17375 Homes for Sale
No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.
Listing Courtesy of RE/MAX 1st Advantage
Based on information from one of the following Multiple Listing Services: BRIGHT, Greater LeHigh Valley Regional MLS, Greator Scranton Board of REALTORS® and Pocono Mountains Association of REALTORS®. Information being provided is for the visitor’s personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by BRIGHT, Greater LeHigh Valley Regional MLS, Greator Scranton Board of REALTORS® and Pocono Mountains Association of REALTORS® is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. Property information referenced on this web site comes from the Internet Data Exchange (IDX) program of the MLS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. For the avoidance of doubt, the accuracy of all information, regardless of source, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals.