Seller's Agent in 2021
Garrett Rothman
RSR, REALTORS, LLC
(717) 343-8909
23 in this area
260 Total Sales
563 N Locust Point Rd Mechanicsburg, PA 17050
Estimated Value: $3,128,057
4
Beds
6
Baths
11,487
Sq Ft
$272/Sq Ft
Est. Value
Highlights
- Second Kitchen
- Heated In Ground Pool
- Waterfall on Lot
- Silver Spring Elementary School Rated A
- Second Garage
- 10.82 Acre Lot
About This Home
As of May 2021Resort living on almost 12 acres in Cumberland Valley School District! Prepare to be in awe as you drive up the two car wide concrete driveway towards this stunning property which has over 11,000 SF of finished living space situated in a private setting with the most amazing views. The grand two-story entrance will start off your tour in your open floor plan dream home. You could host a 20-person dinner party in your formal dining room with plenty of space to cook in your gourmet kitchen. Cabinetry by Oak Park with soft close doors and drawers, custom built-in double refrigerators, two sinks, granite countertops, double ovens, gas cooktop, breakfast area and pantry. First Floor Owner's suite is tucked privately away with its own entrance, laundry room, and views of the pool area. Two-story living room with propane fireplace draws your eye up to the second floor where you will find 3 additional bedrooms, all with their own bathroom or bathroom access and walk-in closet. Second floor also features a study and additional laundry closet. When it's time to unwind head down to the basement to play some games, pump some iron, or catch up on your favorite Netflix shows in the movie theater. When the sun is out and the weather is hot we would definitely suggest you relax by the pool, take a nap, then take a dip in the water, reapply your sunscreen and REPEAT! This home has too many features to list and cannot be fully appreciated unless seen in person. Schedule your private tour today and get ready to call paradise "home!"
Last Agent to Sell the Property
(717) 343-8909 garrett@rsrrealtors.com RSR, REALTORS, LLC Listed on: 08/07/2020
Last Buyer's Agent
(717) 585-2626 edwintrealty@gmail.com Turn Key Realty Group License #AB068820
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $20,397
Year Built
- Built in 2015
Lot Details
- 10.82 Acre Lot
- Extensive Hardscape
- Private Lot
- Secluded Lot
- Open Lot
- Sprinkler System
- Property is in excellent condition
- Property is zoned AGRICULTURAL
Parking
- 6 Garage Spaces | 3 Direct Access and 3 Detached
- Second Garage
- Side Facing Garage
- Driveway
- Off-Street Parking
Home Design
- Traditional Architecture
- Brick Exterior Construction
- Frame Construction
- Stone Siding
- Stick Built Home
- Stucco
Interior Spaces
- Property has 2 Levels
- Open Floorplan
- Central Vacuum
- Curved or Spiral Staircase
- Dual Staircase
- Built-In Features
- Bar
- Chair Railings
- Crown Molding
- Wainscoting
- Tray Ceiling
- Vaulted Ceiling
- Ceiling Fan
- Recessed Lighting
- Gas Fireplace
- Window Treatments
- Mud Room
- Entrance Foyer
- Family Room Off Kitchen
- Living Room
- Formal Dining Room
- Den
- Recreation Room
- Game Room
- Home Gym
- Mountain Views
Kitchen
- Second Kitchen
- Breakfast Area or Nook
- Eat-In Kitchen
- Double Oven
- Cooktop
- Built-In Microwave
- Dishwasher
- Stainless Steel Appliances
- Kitchen Island
- Upgraded Countertops
- Disposal
Flooring
- Wood
- Partially Carpeted
- Ceramic Tile
Bedrooms and Bathrooms
- En-Suite Primary Bedroom
- En-Suite Bathroom
- Walk-In Closet
- Soaking Tub
- Walk-in Shower
Laundry
- Laundry Room
- Laundry on main level
- Dryer
- Washer
Partially Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Interior and Exterior Basement Entry
- Sump Pump
- Basement Windows
Home Security
- Home Security System
- Flood Lights
Accessible Home Design
- More Than Two Accessible Exits
Pool
- Heated In Ground Pool
- Gunite Pool
Outdoor Features
- Patio
- Waterfall on Lot
- Exterior Lighting
Schools
- Silver Spring Elementary School
- Eagle View Middle School
- Cumberland Valley High School
Utilities
- Forced Air Heating and Cooling System
- Geothermal Heating and Cooling
- Tankless Water Heater
- On Site Septic
Community Details
- No Home Owners Association
Listing and Financial Details
- Tax Lot 3
- Assessor Parcel Number 38-06-0015-006
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Aug 7, 2020
Closed on
May 3, 2021
Sold by
Essis Robert S and Essis Terese R
Bought by
Campisi Jaret M and Campisi Cristine H
Seller's Agent
Garrett Rothman
RSR, REALTORS, LLC
Buyer's Agent
Edwin Tichenor
Turn Key Realty Group
List Price
$3,300,000
Sold Price
$2,350,000
Premium/Discount to List
-$950,000
-28.79%
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$778,057
Avg. Annual Appreciation
6.65%
Original Mortgage
$1,880,000
Outstanding Balance
$1,703,749
Interest Rate
3.1%
Mortgage Type
New Conventional
Estimated Equity
$1,424,308
Purchase Details
Closed on
Aug 15, 2014
Sold by
Pierson Jeffrey M
Bought by
Essis Robert S
Purchase Details
Closed on
Aug 21, 2006
Sold by
Essis Salem M
Bought by
Pierson Jeffrey M
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$187,500
Interest Rate
6.88%
Mortgage Type
New Conventional
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Campisi Jaret M | $2,350,000 | None Available | |
| Essis Robert S | $250,000 | -- | |
| Pierson Jeffrey M | $250,000 | -- |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Campisi Jaret M | $1,880,000 | |
| Previous Owner | Pierson Jeffrey M | $187,500 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 05/03/2021 05/03/21 | Sold | $2,350,000 | -21.5% | $205 / Sq Ft |
| 01/08/2021 01/08/21 | Pending | -- | -- | -- |
| 10/13/2020 10/13/20 | Price Changed | $2,995,000 | -9.2% | $261 / Sq Ft |
| 08/07/2020 08/07/20 | For Sale | $3,300,000 | -- | $287 / Sq Ft |
Source: Bright MLS
Tax History Compared to Growth
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $23,662 | $1,553,300 | $339,900 | $1,213,400 |
| 2024 | $19,908 | $1,298,500 | $85,100 | $1,213,400 |
| 2023 | $21,372 | $1,298,500 | $85,100 | $1,213,400 |
| 2022 | $20,846 | $1,298,500 | $85,100 | $1,213,400 |
| 2021 | $20,397 | $1,468,200 | $254,800 | $1,213,400 |
| 2020 | $20,017 | $1,468,200 | $254,800 | $1,213,400 |
| 2019 | $19,688 | $1,468,200 | $254,800 | $1,213,400 |
| 2018 | $19,353 | $1,468,200 | $254,800 | $1,213,400 |
| 2017 | $19,012 | $1,468,200 | $254,800 | $1,213,400 |
| 2016 | -- | $247,800 | $247,800 | $0 |
| 2015 | -- | $247,800 | $247,800 | $0 |
| 2014 | -- | $247,800 | $247,800 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Garrett Rothman
-
Edwin Tichenor
Buyer's Agent in 2021
Edwin Tichenor
Turn Key Realty Group
(717) 585-2626
22 in this area
173 Total Sales
Map
Source: Bright MLS
MLS Number: PACB126380
APN: 38-06-0015-006
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to real estate for sale on this website appears in part through the BRIGHT Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms, and is provided by BRIGHT through a licensing agreement.
Listing information is from various brokers who participate in the Bright MLS IDX program and not all listings may be visible on the site.
The property information being provided on or through the website is for the personal, non-commercial use of consumers and such information may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Some properties which appear for sale on the website may no longer be available because they are for instance, under contract, sold or are no longer being offered for sale.
Property information displayed is deemed reliable but is not guaranteed.
Copyright 2025 Bright MLS, Inc.
Nearby Homes
- 37 Creekside Ln
- 18 Redwood Ln
- 10 Cypress Ln
- 4 Mimosa Ln
- 33 Redwood Ln
- 18 Aspen Ln
- 52 Buckeye Ln
- 8 Wheatfield Dr
- 36 Aspen Ln
- 48 Peach Ln
- 48 Aspen Ln
- 51 Aspen Ln
- 17 Goldenrod Dr
- Kipling Plan at Lark Meadows
- Kipling Plan at Silver Preserve
- Kipling Plan at Hidden Springs
- Devonshire Plan at Hidden Springs
- Hawthorne Plan at Hidden Springs
- Augusta Plan at Hidden Springs
- Harrison Plan at Hidden Springs
- 130 Valley View Dr
- 574 N Locust Point Rd
- 544 N Locust Point Rd
- 542 N Locust Point Rd
- 126 Valley View Dr
- 129 Valley View Dr
- 38 Green Hill Rd
- 122 Valley View Dr
- 125 Valley View Dr
- 564 N Locust Point Rd
- 575 N Locust Point Rd
- 114 Valley View Dr
- 111 Valley View Dr
- 571 N Locust Point Rd
- 591 N Locust Point Rd
- 112 Valley View Dr
- 581 N Locust Point Rd
- 37 Green Hill Rd
- 113 Valley View Dr
- 110 Valley View Dr