174 Warm Sunday Way
MECHANICSBURG, PA 17050
- 4 beds
- 4 baths
- 3,291 sqft
- ~1/2 acre lot
- $189 per sqft
- 2007 build
More homes
Step inside this stunning residence and experience the perfect blend of luxury, comfort and modern design. Boasting over 3200 finished SF, the property includes 4 bedrooms, 3.5 bathrooms, a fully finished lower level and an exceptional outdoor entertaining space. A grand two-story entryway welcomes you into the open-concept floor plan featuring a spacious kitchen with granite countertops, a center island with seating, newer stainless steel appliances, soft-close cabinetry, a generous pantry and recessed lighting - perfect for culinary enthusiasts. Formal dining room with pendant lighting, wainscoting and crown molding. The inviting living room showcases a gas fireplace with decorative mantel. Natural light fills the home creating a warm and sophisticated ambiance. Step outside to your backyard oasis complete with a fully fenced in, flat and usable yard with mature landscaping, elevated covered paver patio with vaulted ceilings, designated hot tub area and a built-in gas fire pit. Back inside, the owner’s suite is a true retreat offering dual walk-in closets and a spa-inspired en suite bath with a walk-in tiled shower with glass doors, a luxurious soaking tub, dual vanity sinks, and designer lighting and fixtures. Three additional well-appointed bedrooms share a stylish bath with a tub/shower combination. The finished lower level expands the living space featuring a flexible area ideal for a home gym, office or media room, plus a beautifully designed full bath with tile floors and a walk-in shower. Additional highlights include newer LVP flooring, new carpet and fresh paint, smart home technology including Ring doorbell, thermostat and hardwired ADT system. Mudroom entry off garage with custom cubbies. Energy efficient gas heat and hot water. Basement plumbed for wet bar. Nestled in the sought-after Rivendell community, residents enjoy access to a private neighborhood pool, basketball court, clubhouse with a kitchen and fitness area. Ideally situated within Cumberland Valley School District, walking trails, parks and even strolling distance to local coffee shops—this is the perfect blend of convenience, lifestyle and comfort.
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Apr 3, 2025
•
MLS# PACB2038746 —
The Building
-
Year Built:2007
-
Year Built Source:Assessor
-
Year Major Reno/Remodel:2022
-
New Construction:No
-
Construction Materials:Stick Built, Vinyl Siding
-
Structure Type:Detached
-
Architectural Style:Traditional
-
Levels:2
-
Accessibility Features:Other
-
Foundation Details:Active Radon Mitigation, Concrete Perimeter
-
Basement:Yes
-
Basement Type:Fully Finished
-
Total SqFt Source:Estimated
-
Total Below Grade SqFt:1024
-
Total Below Grade SqFt Source:Estimated
-
Above Grade Finished Area Units:Square Feet
-
Above Grade Finished SqFt:2532
-
Above Grade Finished SqFt Source:Assessor
-
Below Grade Finished Area Units:Square Feet
-
Below Grade Unfinished Area Units:Square Feet
-
Below Grade Finished SqFt Source:Estimated
-
Below Grade Finished SqFt:759
-
Below Grade Unfinished SqFt:265
-
Below Grade Unfinished SqFt Source:Estimated
-
Tax Total Finished SqFt:2532
Interior
-
Interior Features:Bathroom - Soaking Tub, Bathroom - Walk-In Shower, Carpet, Ceiling Fan(s), Combination Kitchen/Living, Crown Moldings, Dining Area, Kitchen - Island, Pantry, Recessed Lighting, Wainscotting, Walk-in Closet(s), WhirlPool/HotTub, Window Treatments
-
Room List:Primary Bedroom
-
Flooring Type:Luxury Vinyl Plank, Luxury Vinyl Tile, Carpet
-
Fireplace:Yes
-
Fireplaces:1
-
Fireplace Features:Gas/Propane
-
Living Area SqFt Source:Estimated
Room Dimensions
-
Total SqFt:3556
-
Living Area SqFt:3,291 Sqft
Financial & Terms
-
Sale Type:Standard
-
Acceptable Financing:Cash, FHA, Conventional, VA
-
Buyer Financing:Conventional
-
Possession:31-60 Days CD
Location
-
Directions:Gettysburg Pike to Silver Spring Rd, R on July Breeze, R on Cloudless Sky Dr, R on Warm Sunday Way
-
Latitude:40.24206000
-
Longitude:-77.01075000
The Property
-
Property Type:Residential
-
Property Condition:Very Good
-
Lot Size Units:Square Feet
-
Lot Size Acres:0.39
-
Lot Size Source:Assessor
-
Lot SqFt:16,988 Sqft
-
Inclusions:Kitchen Refrigerator, Washer, Dryer, Basement Refrigerator
-
Exclusions:Swing Set
-
Zoning:RESIDENTIAL
-
Outdoor Living Structures:Patio(s), Roof
-
Other Structures:Above Grade, Below Grade
-
Horse:No
-
Waterview:No
-
Fencing:Fully
-
Waterfront:No
-
Water Oriented:No
-
Water Access:No
-
Navigable Water:No
-
Tidal Water:No
-
Land Use Code:101
-
Riparian Rights:No
Listing Agent
- Contact info:
- Agent phone:
- (570) 204-6945
- Office phone:
- (717) 761-6300
Taxes
-
Tax ID Number:38-08-0565-172
-
Tax Year:2024
-
Tax Lot:108
-
Tax Annual Amount:$4,819
-
Tax Assessed Value:$321,200
-
Year Assessed:2024
-
School Tax:3641.0
-
County Tax:758.00
-
City/Town Tax:419.00
-
Total Taxes Payment Frequency:Annually
Beds
-
Bedrooms:4
-
Upper Level Bedrooms:4
-
Upper Level 1 Bedrooms:4
Baths
-
Total Baths:4
-
Full Baths:3
-
Half Baths:1
-
Main Level Baths:1.00
-
Main Level Half Baths:1
-
Upper Level Full Baths:2
-
Lower Level Full Baths:1
-
Upper Level Total Baths:2
-
Upper Level Total Baths:2.00
-
All Lower Levels Total Baths:1
-
Lower Level Total Baths:1.00
-
Upper Level Full Baths:2
-
Lower Level Full Baths:1
The Listing
-
Close Sale Type:Standard Sale
Heating & Cooling
-
Cooling Type:Central A/C
-
Central Air:Yes
-
Cooling Fuel:Electric
-
Heating:Yes
-
Heating Type:Forced Air
-
Heating Fuel:Natural Gas
Utilities
-
Sewer/Septic:Public Sewer
-
Hot Water:Natural Gas
-
Water Source:Public
Appliances
-
Appliances:Built-In Microwave, Built-In Range, Dishwasher, Oven/Range - Electric, Refrigerator, Stainless Steel Appliances
Schools
-
High School:CUMBERLAND VALLEY
-
School District Name:Cumberland Valley
-
School District Source:Listing Agent
The Community
-
Subdivision Name:Rivendell
-
Senior Community:No
-
Exterior Features:Extensive Hardscape
-
Pool:Yes - Community
-
Community Pool Features:In Ground
-
HOA:Yes
-
Condo/Coop Association:No
-
HOA/Condo/Coop Amenities:Pool - Outdoor, Basketball Courts, Club House, Fitness Center, Jog/Walk Path
-
HOA Fee:$85
-
HOA Fee Frequency:Monthly
-
HOA Name:Rivendell Hoa
Parking
-
Total Garage and Parking Spaces:2
-
Garage:Yes
-
Garage Features:Garage - Side Entry
-
Garage Spaces:2.00
-
Type of Parking:Attached Garage, Driveway, Off Street
-
Parking Features:Concrete Driveway
-
# of Attached Garage Spaces:2
Extra Units
-
Vacation Rental:No
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
4/3/25
Apr 3, 2025
|
Sold | BRIGHT | $623,000 | -1.4% |
2/11/25
Feb 11, 2025
|
Pending | BRIGHT | $632,000 | |
2/6/25
Feb 6, 2025
|
Listed / Active | BRIGHT | $632,000 |