NOT LISTED FOR SALE

404 Ethan Allen Dr New Cumberland, PA 17070

Estimated Value: $520,000 - $599,000

5 Beds
4 Baths
4,925 Sq Ft
$113/Sq Ft Est. Value

Last Sold November 20, 2020

Last sale price $410,000 $83 Per Sq Ft

Est. 35% increase in value since last sale

Current estimated payment $3,603/month

79 Days on Market

Highlights

  • Second Kitchen
  • Gourmet Kitchen
  • Maid or Guest Quarters
  • Spa
  • Open Floorplan
  • Contemporary Architecture

About This Home

As of November 2020

$30K PRICE DROP! Remarkable, custom designed brick home in the tranquil community of Colonial Woods, located conveniently just outside of New Cumberland Boro. Contemporary look & feel with open concept kitchen/living room, vaulted ceilings, skylights, light, bright & beautiful! Brand new granite countertops throughout, new roof, fresh paint, professionally cleaned & absolutely move-in ready! Main level Master Suite includes adjacent sitting room/office & the largest walk-in closet you could ask for. Gigantic fully finished, walkout basement features in-law suite, bedroom, full bath, full kitchen, & spacious living area. Large rear deck overlooks private backyard. Perfect location, off beaten track, but close to Rt83 corridor to York & Harrisburg.

Last Agent to Sell the Property

Justin Smith

Coldwell Banker Realty License #RS322313 Listed on: 07/29/2020

Coldwell Banker Realty

Co-Listed By

Lee Smith

Coldwell Banker Realty

Last Buyer's Agent

The Hamilton Team

RE/MAX Delta Group, Inc.

RE/MAX Delta Group, Inc.

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,496

Year Built

  • Built in 1994

Lot Details

  • 0.58

Parking

  • 2 Car Attached Garage
  • 4 Driveway Spaces
  • Parking Storage or Cabinetry
  • Front Facing Garage

Home Design

  • Contemporary Architecture
  • Traditional Architecture
  • Brick Exterior Construction
  • Asphalt Roof
  • Stick Built Home

Interior Spaces

  • Property has 2 Levels
  • Open Floorplan
  • Built-In Features
  • Crown Molding
  • Ceiling Fan
  • Skylights
  • Recessed Lighting
  • Wood Burning Fireplace
  • Entrance Foyer
  • Great Room
  • Family Room Off Kitchen
  • Combination Kitchen and Living
  • Dining Room
  • Efficiency Studio
  • Finished Basement
  • Walk-Out Basement

Kitchen

  • Gourmet Kitchen
  • Kitchenette
  • Second Kitchen
  • Upgraded Countertops

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • En-Suite Primary Bedroom
  • En-Suite Bathroom
  • Cedar Closet
  • Walk-In Closet
  • Maid or Guest Quarters
  • In-Law or Guest Suite

Laundry

  • Laundry Room
  • Laundry on lower level

Outdoor Features

  • Spa
  • Outbuilding

Utilities

  • Forced Air Heating and Cooling System
  • Heat Pump System
  • 200+ Amp Service
  • Well
  • Electric Water Heater

Additional Features

  • More Than Two Accessible Exits
  • 0.58 Acre Lot

Community Details

  • No Home Owners Association
  • Colonial Woods Subdivision

Listing and Financial Details

  • Tax Lot 0087
  • Assessor Parcel Number 27-000-24-0087-00-00000

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,496

Year Built

Built in 1994

Lot Details

0

Parking

2

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Contemporary, Traditional
  • Accessibility Features: 2+ Access Exits
  • Ownership: Fee Simple
  • Home Warranty: No
  • New Construction: No
  • Story List: Lower 1, Main, Upper 1
  • Federal Flood Zone: No
  • Year Built: 1994
  • Automatically Close On Close Date: No
  • Remarks Public: $30K PRICE DROP! Remarkable, custom designed brick home in the tranquil community of Colonial Woods, located conveniently just outside of New Cumberland Boro. Contemporary look & feel with open concept kitchen/living room, vaulted ceilings, skylights, light, bright & beautiful! Brand new granite countertops throughout, new roof, fresh paint, professionally cleaned & absolutely move-in ready! Main level Master Suite includes adjacent sitting room/office & the largest walk-in closet you could ask for. Gigantic fully finished, walkout basement features in-law suite, bedroom, full bath, full kitchen, & spacious living area. Large rear deck overlooks private backyard. Perfect location, off beaten track, but close to Rt83 corridor to York & Harrisburg.
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Flooring Type: Hardwood, Ceramic Tile, Carpet
  • Interior Amenities: Built-Ins, Carpet, Cedar Closet(s), Ceiling Fan(s), Combination Kitchen/Living, Crown Moldings, Dining Area, Family Room Off Kitchen, Floor Plan - Open, Primary Bath(s), Recessed Lighting, Skylight(s), Upgraded Countertops, Walk-In Closet(s), Wood Floors, Efficiency, 2nd Kitchen, Entry Level Bedroom, Kitchen - Gourmet, Kitchenette, Pantry
  • Fireplace Features: Wood
  • Fireplaces Count: 1
  • Fireplace: Yes
  • Levels Count: 2
  • Room List: Living Room, Dining Room, Primary Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Kitchen, Foyer, Great Room, In-Law/AuPair/Suite, Laundry, Maid/Guest Quarters, Primary Bathroom, Full Bath
  • Basement: Yes
  • Basement Type: Fully Finished, Walkout Level
  • Laundry Type: Main Floor, Lower Floor
  • Total Sq Ft: 4925
  • Living Area Sq Ft: 4925
  • Price Per Sq Ft: 117.46
  • Above Grade Finished Sq Ft: 3660
  • Below Grade Finished Sq Ft: 1265
  • Total Below Grade Sq Ft: 1265
  • Above Grade Finished Area Units: Square Feet
  • Street Number Modifier: 404

Beds/Baths

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

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Construction Materials: Brick, Stick Built
  • Exterior Features: Hot Tub, Outbuilding(s)
  • Roof: Asphalt
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: No Pool
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage: Yes
  • Garage Features: Garage - Front Entry, Additional Storage Area
  • Attached Garage Spaces: 2
  • Total Garage And Parking Spaces: 6
  • Type Of Parking: Attached Garage, Driveway
  • Number of Spaces in Driveway: 4

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C
  • Electric Service: 200+ Amp Service
  • Heating Fuel: Electric
  • Heating Type: Heat Pump(s), Forced Air
  • Heating: Yes
  • Hot Water: Electric
  • Sewer/Septic System: Public Sewer
  • Water Source: Well

Condo/Co-op/Association

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

Schools

  • School District: WEST SHORE
  • School District Key: 300200396679
  • School District Source: Listing Agent

Green Features

  • Clean Green Assessed: No

Lot Info

  • Land Use Code: 105
  • Lot Size Acres: 0.58
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 25222.00
  • Year Assessed: 2020
  • Zoning: RESIDENTIAL

Rental Info

  • Vacation Rental: No
  • Rent Spree Online Application: No

Tax Info

  • Assessor Parcel Number: 10800594
  • School Tax: 3637.00
  • Tax Annual Amount: 5496.00
  • Assessor Parcel Number: 27-000-24-0087-00-00000
  • Tax Lot: 0087
  • Tax Total Finished Sq Ft: 3526
  • County Tax Payment Frequency: Annually
  • Tax Year: 2020
  • Close Date: 11/20/2020

MLS Schools

  • School District Name: WEST SHORE

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 29, 2020
Closed on
Nov 20, 2020
Sold by
Bull James N and Bull Lelani K
Bought by
Ramirez Robert
Seller's Agent
Justin Smith
Coldwell Banker Realty
Buyer's Agent
The Hamilton Team
RE/MAX Delta Group, Inc.
List Price
$459,900
Sold Price
$410,000
Premium/Discount to List
-$49,900
-10.85%
Current Estimated Value
$554,815

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$144,815
Avg. Annual Appreciation
6.68%
Original Mortgage
$328,000
Outstanding Balance
$294,525
Interest Rate
2.8%
Mortgage Type
New Conventional
Estimated Equity
$260,290

Purchase Details

Listed on
Apr 10, 2012
Closed on
Jul 24, 2012
Sold by
Williams Robert L and Williams Helena A
Bought by
Bull James N and Labrie Leilani K
Seller's Agent
TOM XHILONE
Coldwell Banker Realty
Buyer's Agent
Eric Hoffer
Coldwell Banker Realty
List Price
$327,000
Sold Price
$290,000
Premium/Discount to List
-$37,000
-11.31%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.29%
Original Mortgage
$284,747
Interest Rate
3.25%
Mortgage Type
FHA

Purchase Details

Closed on
Sep 28, 1994
Bought by
Williams Robert L
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
Ramirez Robert $410,000 North Mountain Stlmt Svcs
Bull James N $294,000 None Available
Williams Robert L $223,500 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Ramirez Robert $328,000
Previous Owner Bull James N $18,000
Previous Owner Bull James N $16,000
Previous Owner Bull James N $284,747
Previous Owner Williams Robert L $280,000
Previous Owner Williams Robert L $47,200
Previous Owner Williams Robert L $175,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
11/20/2020 11/20/20 Sold $410,000 -4.6% $83 / Sq Ft
10/16/2020 10/16/20 Pending -- -- --
09/10/2020 09/10/20 Price Changed $429,900 -4.4% $87 / Sq Ft
09/01/2020 09/01/20 Price Changed $449,900 -2.2% $91 / Sq Ft
07/29/2020 07/29/20 For Sale $459,900 +58.6% $93 / Sq Ft
08/22/2012 08/22/12 Sold $290,000 -11.3% $59 / Sq Ft
07/12/2012 07/12/12 Pending -- -- --
04/10/2012 04/10/12 For Sale $327,000 -- $66 / 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 $6,363 $243,020 $42,040 $200,980
2024 $6,025 $243,020 $42,040 $200,980
2023 $5,860 $243,020 $42,040 $200,980
2022 $5,841 $243,020 $42,040 $200,980
2021 $5,496 $243,020 $42,040 $200,980
2020 $5,430 $243,020 $42,040 $200,980
2019 $5,335 $243,020 $42,040 $200,980
2018 $5,231 $243,020 $42,040 $200,980
2017 $5,055 $243,020 $42,040 $200,980
2016 $0 $243,020 $42,040 $200,980
2015 -- $243,020 $42,040 $200,980
2014 -- $243,020 $42,040 $200,980
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: PAYK142384

Bright MLS

APN: 27-000-24-0087.00-00000