NOT LISTED FOR SALE

155 Celestial Terrace Greencastle, PA 17225

Estimated Value: $764,000 - $935,894

5 Beds
4.5 Baths
5,273 Sq Ft
$158/Sq Ft Est. Value

Last Sold May 25, 2023

Last sale price $830,000 $157 Per Sq Ft

Current estimated payment $5,441/month

114 Days on Market

Highlights

  • Second Kitchen
  • Heated In Ground Pool
  • Open Floorplan
  • 24-Hour Security
  • Eat-In Gourmet Kitchen
  • Colonial Architecture

About This Home

As of May 2023

VIEW virtual tour for a more in-depth view of this Beautifully designed maintenance free home!
This exquisite open floor plan offers 5273 finished sqft. 5-bedroom 4-1/2 bath with 2 car garage situated on .51 acres in Heritage Estates. This home was constructed with entertaining in mind and an eye for detail. Brand new custom fully equipped kitchen with Island, built in dishwasher, double basin Ruvati 36" Undermount Workstation sink and granite countertops. Large pantry with pull out drawers, under kitchen cabinet lighting and extensive custom cabinets that continue into dining area with mini refrigerator. Open floor plan with vaulted ceilings, Den and living room with two-sided fireplace. The main level offers a large primary bedroom, with brand new flooring. Brand new full custom primary bath offering a MAXX bubble tub, large walk-in tile shower and large walk-in closet. Water heater in closet off primary bathroom designated for shower and bathtub to ensure hot water is plentiful! New alarm system, (hard wired outdoor ring camera system) Heating, A/C and alarm controllable by Z-Wave App.
First and second floors offers updated lighting, brand-new luxury vinyl tile, New floor-baseboard and fresh paint! Upper level boasts three bedrooms, walk in closets and two full baths.
Fully finished walkout lower level family room with custom wet bar and granite countertops, pool table and family room area with gorgeous stone gas fireplace. Workout in this deluxe Gym area with high impact gym floor and mirrors. Full custom bath and office or additional bedroom.
Custom outdoor entertainment area to include Outdoor Wet bar/Kitchen area granite countertops, Lyons built-in grill, doors, 2 refrigerators, and new hot water tank for outside bar sink. Heated propane Waterfall pool with 6 Pentair pool lighting also controllable from your phone! 4 pool deck water and shooter (pool deck jets). Cartridge pool filter no need to back flush. Wrought Iron fencing surrounds backyard with patio, gazebo, fenced garden area and extensive outdoor lighting to include landscape lighting all around bar and added into retaining wall. All decking installed with TimberTek Decking and underside of deck ceiling offers gutter and drain system for staying dry. New irrigation system including Rain Bird, Drip irrigation system for all back yard plants and 100% stone landscaping.
Other upgrades include: 5 electrical panels, 220 outlet in safe room closet, new Kinetico water softener & Reverse Osmosis system and Radon unit. Outdoor heating units replaced in the last two years. Floored storage above garage area and Gorilla basketball hoop in driveway. Three outdoor electric canopies-1 year old. Pentair smart logic phone control system and 3 ground mounted outdoor umbrellas. Landscaping offers multiple retaining walls, hardwired deck post lighting and 3 ground mounted Purple leaf outdoor umbrellas. Underground down spout drainage, outside sink drains underground to back yard pit in garden (stone)
This gorgeous home offers top of the line extras and is located in a great location. this home is minutes to I81, Hagerstown Airport, and easy transportation Frederick, Baltimore and Washington DC. 1.5hrs to Dulles and BWI Airports.

Last Agent to Sell the Property

Dawn Crilley-Shank

RE/MAX Elite Services License #5000602 Listed on: 01/04/2023

RE/MAX Elite Services

Last Buyer's Agent

Stacy Mellott

Keller Williams of Central PA License #RS323464

Keller Williams of Central PA

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $10,527

Year Built

  • Built in 2004 | Remodeled in 2022

Lot Details

  • 0.51 Acre Lot
  • Lot Dimensions are 120.00 x 185.00
  • Wrought Iron Fence
  • Stone Retaining Walls
  • Back Yard Fenced
  • Extensive Hardscape
  • Sprinkler System
  • Property is in excellent condition

Parking

  • 2 Car Direct Access Garage
  • 4 Driveway Spaces
  • Parking Storage or Cabinetry
  • Side Facing Garage
  • Garage Door Opener
  • Off-Street Parking

Home Design

  • Colonial Architecture
  • Entry on the 1st floor
  • Brick Exterior Construction
  • Architectural Shingle Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 5,273 Sq Ft Home
  • Property has 3 Levels
  • Open Floorplan
  • Wet Bar
  • Sound System
  • Built-In Features
  • Bar
  • Tray Ceiling
  • Cathedral Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • 2 Fireplaces
  • Double Sided Fireplace
  • Fireplace With Glass Doors
  • Stone Fireplace
  • Fireplace Mantel
  • Gas Fireplace
  • Double Pane Windows
  • Awning
  • Window Treatments
  • Window Screens
  • French Doors
  • Entrance Foyer
  • Family Room Off Kitchen
  • Living Room
  • Formal Dining Room
  • Den
  • Utility Room
  • Home Gym

Kitchen

  • Eat-In Gourmet Kitchen
  • Second Kitchen
  • Breakfast Area or Nook
  • Double Self-Cleaning Oven
  • Electric Oven or Range
  • Stove
  • Built-In Microwave
  • Ice Maker
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Upgraded Countertops
  • Wine Rack
  • Disposal
  • Instant Hot Water

Flooring

  • Wood
  • Carpet
  • Ceramic Tile
  • Luxury Vinyl Tile

Bedrooms and Bathrooms

  • En-Suite Primary Bedroom
  • En-Suite Bathroom
  • Walk-In Closet
  • Soaking Tub
  • Bathtub with Shower

Laundry

  • Laundry Room
  • Laundry on main level
  • Washer and Dryer Hookup

Finished Basement

  • Heated Basement
  • Walk-Out Basement
  • Connecting Stairway
  • Interior and Exterior Basement Entry
  • Shelving
  • Basement Windows

Home Security

  • Alarm System
  • Exterior Cameras
  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Pool

  • Heated In Ground Pool
  • Saltwater Pool
  • Vinyl Pool
  • Fence Around Pool

Outdoor Features

  • Deck
  • Patio
  • Gazebo
  • Outdoor Grill

Schools

  • Greencastle-Antrim Elementary And Middle School
  • Greencastle-Antrim Senior High School

Utilities

  • Forced Air Zoned Cooling and Heating System
  • Heat Pump System
  • Heating System Powered By Leased Propane
  • 200+ Amp Service
  • Propane
  • Water Treatment System
  • Tankless Water Heater
  • Water Conditioner is Owned
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 08-2B03.-077.-000000

Community Details

Overview

  • No Home Owners Association
  • Heritage Estates Subdivision

Security

  • 24-Hour Security

Home Details

Home Type

Single Family

Est. Annual Taxes

$10,527

Year Built

Built in 2004 | Remodeled in 2022

Lot Details

0

Parking

2

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Colonial
  • Ownership: Fee Simple
  • Historic: No
  • Home Warranty: No
  • Inclusions: Window Treatments, Water Treatment Equipment, Alarm System, Lower-Level Pool Table, Lower-Level Bar Stools, Lower-Level Family Room TV, Lower-Level Surround Sound, Lower-Level Dart Board, Lower-Level Mini Fridge (2), Lower-Level Microwave, Lower-Level Off
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Federal Flood Zone: No
  • Year Built: 2004
  • Year Renovated: 2022
  • Automatically Close On Close Date: No
  • Building Winterized: No
  • Remarks Public: VIEW virtual tour for a more in-depth view of this Beautifully designed maintenance free home! This exquisite open floor plan offers 5273 finished sqft. 5-bedroom 4-1/2 bath with 2 car garage situated on .51 acres in Heritage Estates. This home was constructed with entertaining in mind and an eye for detail. Brand new custom fully equipped kitchen with Island, built in dishwasher, double basin Ruvati 36" Undermount Workstation sink and granite countertops. Large pantry with pull out drawers, under kitchen cabinet lighting and extensive custom cabinets that continue into dining area with mini refrigerator. Open floor plan with vaulted ceilings, Den and living room with two-sided fireplace. The main level offers a large primary bedroom, with brand new flooring. Brand new full custom primary bath offering a MAXX bubble tub, large walk-in tile shower and large walk-in closet. Water heater in closet off primary bathroom designated for shower and bathtub to ensure hot water is plentiful! New alarm system, (hard wired outdoor ring camera system) Heating, A/C and alarm controllable by Z-Wave App. First and second floors offers updated lighting, brand-new luxury vinyl tile, New floor-baseboard and fresh paint! Upper level boasts three bedrooms, walk in closets and two full baths. Fully finished walkout lower level family room with custom wet bar and granite countertops, pool table and family room area with gorgeous stone gas fireplace. Workout in this deluxe Gym area with high impact gym floor and mirrors. Full custom bath and office or additional bedroom. Custom outdoor entertainment area to include Outdoor Wet bar/Kitchen area granite countertops, Lyons built-in grill, doors, 2 refrigerators, and new hot water tank for outside bar sink. Heated propane Waterfall pool with 6 Pentair pool lighting also controllable from your phone! 4 pool deck water and shooter (pool deck jets). Cartridge pool filter no need to back flush. Wrought Iron fencing surrounds backyard with patio, gazebo, fenced garden area and extensive outdoor lighting to include landscape lighting all around bar and added into retaining wall. All decking installed with TimberTek Decking and underside of deck ceiling offers gutter and drain system for staying dry. New irrigation system including Rain Bird, Drip irrigation system for all back yard plants and 100% stone landscaping. Other upgrades include: 5 electrical panels, 220 outlet in safe room closet, new Kinetico water softener & Reverse Osmosis system and Radon unit. Outdoor heating units replaced in the last two years. Floored storage above garage area and Gorilla basketball hoop in driveway. Three outdoor electric canopies-1 year old. Pentair smart logic phone control system and 3 ground mounted outdoor umbrellas. Landscaping offers multiple retaining walls, hardwired deck post lighting and 3 ground mounted Purple leaf outdoor umbrellas. Underground down spout drainage, outside sink drains underground to back yard pit in garden (stone) This gorgeous home offers top of the line extras and is located in a great location. this home is minutes to I81, Hagerstown Airport, and easy transportation Frederick, Baltimore and Washington DC. 1.5hrs to Dulles and BWI Airports.
  • Special Features: 4098
  • Property Sub Type: Detached
  • Stories: 0

Interior Features

  • Appliances: Dishwasher, Disposal, Microwave, Stainless Steel Appliances, Stove, Refrigerator, Washer/Dryer Hookups Only, Water Conditioner - Owned, Water Heater - Tankless, Built-In Microwave, Icemaker, Instant Hot Water, Oven - Self Cleaning, Oven - Double, Oven/Range - Electric, Water Heater
  • Entry Floor: 1
  • Flooring Type: Carpet, Hardwood, Luxury Vinyl Tile, Ceramic Tile
  • Interior Amenities: 2nd Kitchen, Bar, Breakfast Area, Built-Ins, Carpet, Ceiling Fan(s), Combination Kitchen/Living, Combination Dining/Living, Dining Area, Entry Level Bedroom, Family Room Off Kitchen, Floor Plan - Open, Kitchen - Eat-In, Formal/Separate Dining Room, Kitchen - Gourmet, Kitchen - Island, Kitchen - Table Space, Pantry, Primary Bath(s), Recessed Lighting, Soaking Tub, Sound System, Sprinkler System, Tub Shower, Upgraded Countertops, Walk-In Closet(s), Water Treat System, Wet/Dry Bar, Window Treatments, Wine Storage
  • Window Features: Screens, Double Pane
  • Fireplace Features: Gas/Propane, Double Sided, Fireplace - Glass Doors, Mantel(s), Stone
  • Fireplaces Count: 2
  • Fireplace: Yes
  • Door Features: French
  • Wall Ceiling Types: 9'+ Ceilings, Dry Wall, Vaulted Ceilings, Cathedral Ceilings, Tray Ceilings
  • Foundation Details: Concrete Perimeter
  • Levels Count: 3
  • Room List: Living Room, Dining Room, Primary Bedroom, Bedroom 2, Bedroom 3, Kitchen, Family Room, Den, Foyer, Bedroom 1, Exercise Room, Laundry, Office, Utility Room, Bathroom 1, Bathroom 2, Primary Bathroom, Full Bath, Half Bath
  • Basement: Yes
  • Basement Type: Fully Finished, Daylight, Full, Connecting Stairway, Heated, Improved, Interior Access, Outside Entrance, Shelving, Walkout Level, Windows
  • Laundry Type: Main Floor, Hookup
  • Total Sq Ft: 5273
  • Living Area Sq Ft: 5273
  • Price Per Sq Ft: 170.66
  • Above Grade Finished Sq Ft: 5273
  • Above Grade Finished Area Units: Square Feet
  • Street Number Modifier: 155

Beds/Baths

  • Bedrooms: 5
  • Main Level Bedrooms: 1
  • All Lower Level Bedrooms: 1
  • Lower Level Bedroom: 1
  • Total Bathrooms: 5
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Main Level Bathrooms: 2.00
  • Upper Level Bathrooms: 2
  • Lower Levels Bathrooms: 1
  • Upper Level Bathrooms: 2.00
  • Lower Levels Bathrooms: 1.00
  • Main Level Full Bathrooms: 1
  • Upper Level Full Bathrooms: 2
  • Lower Level Full Bathrooms: 1
  • Lower Level Full Bathrooms: 1
  • Main Level Half Bathrooms: 1

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Other Structures List: Gazebo
  • Construction Materials: Brick
  • Exterior Features: Bbq Grill, Extensive Hardscape, Stone Retaining Walls, Awning(s)
  • Pool Features: In Ground, Saltwater, Vinyl, Heated, Fenced
  • Road Surface Type: Black Top
  • Roof: Architectural Shingle
  • Spa: No
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: Yes - Personal
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage: Yes
  • Parking Features: Paved Driveway
  • Garage Features: Garage - Side Entry, Garage Door Opener, Inside Access, Additional Storage Area
  • Attached Garage Spaces: 2
  • Total Garage And Parking Spaces: 6
  • Type Of Parking: Attached Garage, Driveway, Off Street
  • Number of Spaces in Driveway: 4

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C, Multi Units, Zoned, Ceiling Fan(s), Heat Pump(s)
  • Monthly Average Electric: 566
  • Previous Twelve Months Electric Expense: 6792.00
  • Electric Service: 200+ Amp Service
  • Gas Avg Month: 131.00
  • Gas Prev12 Months: 1572.00
  • Heating Fuel: Electric, Propane - Leased
  • Heating Type: Forced Air, Heat Pump(s)
  • Heating: Yes
  • Hot Water: Electric, Multi-Tank, Tankless
  • Security: 24 Hour Security, Security System, Smoke Detector, Carbon Monoxide Detector(s), Electric Alarm, Exterior Cameras
  • Sewer/Septic System: Public Sewer
  • Utilities: Cable Tv, Propane
  • Monthly Water Average: 161
  • Water Previous Twelve Months: 1932.00
  • Water Source: Public
  • Municipal Trash: No
  • Internet Services: Cable

Condo/Co-op/Association

  • Condo Co-Op Association: No
  • HOA: No
  • Senior Community: No
  • Association Recreation Fee: No

Fee Information

  • Loss Mitigation Fee?: No

Schools

  • School District: GREENCASTLE-ANTRIM
  • Elementary School: GREENCASTLE-ANTRIM
  • Middle School: GREENCASTLE-ANTRIM
  • High School: GREENCASTLE-ANTRIM SENIOR
  • Elementary School Source: Listing Agent
  • High School Source: Listing Agent
  • Middle School Source: Listing Agent
  • School District Key: 300200396244
  • School District Source: Listing Agent
  • Elementary School: GREENCASTLE-ANTRIM
  • High School: GREENCASTLE-ANTRIM SENIOR
  • Middle Or Junior School: GREENCASTLE-ANTRIM

Lot Info

  • Horses: No
  • Additional Parcels: No
  • Fencing: Fully, Rear, Wrought Iron
  • Improvement Assessed Value: 58530.00
  • Land Assessed Value: 5280.00
  • Land Use Code: 101
  • Lot Size Acres: 0.51
  • Lot Dimensions: 120.00 x 185.00
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 22216.00
  • Outdoor Living Structures: Deck(s), Patio(s)
  • Property Condition: Excellent
  • Year Assessed: 2022
  • Zoning: RESIDENTIAL

Green Features

  • Clean Green Assessed: No

Rental Info

  • Ground Rent Exists: No
  • Lease Considered: No
  • Pets: No Pet Restrictions
  • Pets Allowed: Yes
  • Vacation Rental: No
  • Property Manager: No

Tax Info

  • Assessor Parcel Number: 10764478
  • Tax Annual Amount: 10527.00
  • Assessor Parcel Number: 08-2B03.-077.-000000
  • Tax Total Finished Sq Ft: 4342
  • County Tax Payment Frequency: Annually
  • Tax Year: 2022
  • Close Date: 05/25/2023

MLS Schools

  • School District Name: GREENCASTLE-ANTRIM

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 4, 2023
Closed on
May 11, 2023
Sold by
Black Clayton A and Black Tamara L
Bought by
Carroll Charles B
Seller's Agent
Dawn Crilley-Shank
RE/MAX Elite Services
Buyer's Agent
Stacy Mellott
Keller Williams of Central PA
List Price
$940,900
Sold Price
$830,000
Premium/Discount to List
-$110,900
-11.79%
Views
456
Current Estimated Value
$832,965

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$2,965
Avg. Annual Appreciation
-4.16%
Original Mortgage
$664,000
Outstanding Balance
$648,704
Interest Rate
6.27%
Mortgage Type
New Conventional
Estimated Equity
$103,419

Purchase Details

Closed on
Feb 11, 2005
Sold by
Sword James C
Bought by
Black Clayton A and Black Tamara L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$93,000
Interest Rate
5.73%
Mortgage Type
Future Advance Clause Open End Mortgage
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Carroll Charles B $830,000 None Listed On Document
Black Clayton A $450,000 None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Carroll Charles B $664,000
Previous Owner Black Clayton A $400,000
Previous Owner Black Clayton A $399,200
Previous Owner Black Clayton A $8,000
Previous Owner Black Clyton A $417,000
Previous Owner Black Clayton A $39,000
Previous Owner Black Clayton A $93,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/25/2023 05/25/23 Sold $830,000 -7.8% $157 / Sq Ft
04/28/2023 04/28/23 Pending -- -- --
04/19/2023 04/19/23 Price Changed $899,900 -4.4% $171 / Sq Ft
03/31/2023 03/31/23 For Sale $940,900 0.0% $178 / Sq Ft
02/04/2023 02/04/23 Pending -- -- --
01/23/2023 01/23/23 Price Changed $940,900 -0.9% $178 / Sq Ft
01/04/2023 01/04/23 For Sale $949,900 -- $180 / Sq Ft
Source: Bright MLS

Tax History Compared to Growth

Source: Public Records

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 $12,035 $70,200 $5,280 $64,920
2024 $11,777 $70,200 $5,280 $64,920
2023 $10,591 $63,810 $5,280 $58,530
2022 $10,527 $63,810 $5,280 $58,530
2021 $9,787 $60,390 $5,280 $55,110
2020 $9,556 $60,390 $5,280 $55,110
2019 $9,360 $60,390 $5,280 $55,110
2018 $9,269 $60,390 $5,280 $55,110
2017 $8,998 $60,390 $5,280 $55,110
2016 $1,730 $60,390 $5,280 $55,110
2015 $1,612 $60,390 $5,280 $55,110
2014 $1,612 $60,390 $5,280 $55,110
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: PAFL2011102

Bright MLS

APN: 08-2B03-077-000000