NOT LISTED FOR SALE

402 S Queen St Littlestown, PA 17340

Estimated Value: $281,278

4 Beds
1.5 Baths
2,654 Sq Ft
$106/Sq Ft Est. Value

Last Sold April 27, 2021

Last sale price $225,000 $85 Per Sq Ft

Est. 25% increase in value since last sale

Current estimated payment $1,994/month

141 Days on Market

Highlights

  • Colonial Architecture
  • Sun or Florida Room
  • 2 Car Detached Garage
  • Wood Flooring
  • No HOA
  • Living Room

About This Home

As of April 2021

Big Price Reduction ! Highly Motivated Seller says SELL ! Special property offers so many options for your use. As a single family detached home you can optimize all space with a kitchen, living room, dining room and powder room on the 1st floor, including side and rear enclosed porches. Beautiful wood floors and a propane fireplace insert to keep you cozy on those bitter winter evenings. The 2nd floor would offer you a full bath, 4 large bedrooms and a big attic. A second option is for two units (1st and 2nd floor) with front door entrance to foyer and stairs to 2nd floor and 1st floor entrance from either the sunroom or rear door. In this case, there would be 2bd on 2nd floor and 1 or 2 bd on 1st floor. There is room in a storage area next to the powder room to upgrade it to a full bath. A third option would be for a business on the 1st floor and a 2bd apartment on the 2nd floor as it is set up now. Zoning is TCMU so please confirm all business options with Littlestown Boro. In any of these scenarios you can also enjoy a small private fenced yard, a small detached garage w/ opener and a huge detached storage/garage building. The large building has a loading dock, a huge 2nd floor, water and electric, ideal for storage and hobbies. Parking for 6+ vehicles. Prior owner has contacted me to share that her family built the home in 1937 and not 1900.

Last Agent to Sell the Property

Melissa Divers-Reed

RE/MAX Solutions License #505037 Listed on: 10/26/2020

RE/MAX Solutions

Last Buyer's Agent

Wendy Hofmann

RE/MAX Solutions License #RSR003495

RE/MAX Solutions

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,162

Year Built

  • Built in 1900

Lot Details

  • 0.25 Acre Lot
  • Wood Fence
  • Level Lot
  • Back Yard Fenced
  • Property is in good condition
  • Property is zoned TCMU, Town Center Mixed Use - visit the Littlestown boro website for permitted uses, chapter 500-11 under codes and zoning for TCMU

Parking

  • 2 Car Detached Garage
  • 5 Driveway Spaces
  • Parking Storage or Cabinetry
  • Rear-Facing Garage
  • Gravel Driveway

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Slate Roof
  • Metal Roof
  • Aluminum Siding

Interior Spaces

  • Property has 2 Levels
  • Gas Fireplace
  • Living Room
  • Dining Room
  • Sun or Florida Room
  • Wood Flooring
  • Basement Fills Entire Space Under The House
  • Stove

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Laundry on lower level
  • Washer and Dryer Hookup

Outdoor Features

  • Storage Shed
  • Outbuilding

Utilities

  • Forced Air Heating and Cooling System
  • Natural Gas Water Heater

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Assessor Parcel Number 27011-0086---000

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,162

Year Built

Built in 1900

Lot Details

0

Parking

2

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Colonial
  • Ownership: Fee Simple
  • New Construction: No
  • Story List: Main, Upper 1
  • Federal Flood Zone: No
  • Year Built: 1900
  • Remarks Public: Big Price Reduction ! Highly Motivated Seller says SELL ! Special property offers so many options for your use. As a single family detached home you can optimize all space with a kitchen, living room, dining room and powder room on the 1st floor, including side and rear enclosed porches. Beautiful wood floors and a propane fireplace insert to keep you cozy on those bitter winter evenings. The 2nd floor would offer you a full bath, 4 large bedrooms and a big attic. A second option is for two units (1st and 2nd floor) with front door entrance to foyer and stairs to 2nd floor and 1st floor entrance from either the sunroom or rear door. In this case, there would be 2bd on 2nd floor and 1 or 2 bd on 1st floor. There is room in a storage area next to the powder room to upgrade it to a full bath. A third option would be for a business on the 1st floor and a 2bd apartment on the 2nd floor as it is set up now. Zoning is TCMU so please confirm all business options with Littlestown Boro. In any of these scenarios you can also enjoy a small private fenced yard, a small detached garage w/ opener and a huge detached storage/garage building. The large building has a loading dock, a huge 2nd floor, water and electric, ideal for storage and hobbies. Parking for 6+ vehicles. Prior owner has contacted me to share that her family built the home in 1937 and not 1900.
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Stove
  • Interior Amenities: Wood Floors
  • Fireplace Features: Gas/Propane
  • Fireplaces Count: 1
  • Fireplace: Yes
  • Levels Count: 2
  • Room List: Living Room, Dining Room, Bedroom 2, Bedroom 3, Bedroom 4, Kitchen, Bedroom 1, Sun/Florida Room
  • Basement: Yes
  • Basement Type: Full
  • Laundry Type: Hookup, Lower Floor
  • Total Sq Ft: 3794
  • Living Area Sq Ft: 2654
  • Price Per Sq Ft: 94.16
  • Above Grade Finished Sq Ft: 2654
  • Below Grade Sq Ft: 1140
  • Total Below Grade Sq Ft: 1140
  • Above Grade Finished Area Units: Square Feet
  • Street Number Modifier: 402

Beds/Baths

  • Bedrooms: 4
  • Total Bathrooms: 2
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Main Level Bathrooms: 1.00
  • Upper Level Bathrooms: 1
  • Upper Level Bathrooms: 1.00
  • Upper Level Full Bathrooms: 1
  • Main Level Half Bathrooms: 1

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Other Structures List: Garage(s), Storage Barn/Shed
  • Construction Materials: Brick, Aluminum Siding
  • Exterior Features: Outbuilding(s)
  • Roof: Slate, Metal
  • 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
  • Parking Features: Crushed Stone
  • Garage Features: Additional Storage Area, Garage - Rear Entry
  • Number Of Detached Garage Spaces: 2
  • Total Garage And Parking Spaces: 7
  • Type Of Parking: Detached Garage, Driveway
  • Number of Spaces in Driveway: 5

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C
  • Heating Fuel: Natural Gas
  • Heating Type: Forced Air
  • Heating: Yes
  • Hot Water: Natural Gas
  • Sewer/Septic System: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

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

Schools

  • School District: LITTLESTOWN AREA
  • School District Key: 300200396832
  • School District Source: Listing Agent

Green Features

  • Clean Green Assessed: No

Lot Info

  • Fencing: Rear, Wood
  • Improvement Assessed Value: 148700.00
  • Land Assessed Value: 51500.00
  • Land Use Code: 105
  • Lot Features: Level, Rear Yard
  • Lot Size Acres: 0.25
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 11000.00
  • Property Condition: Good
  • Year Assessed: 2021
  • Zoning: TCMU
  • Zoning Description: Town Center Mixed Use - visit the Littlestown boro website for permitted uses, chapter 500-11 under codes and zoning for TCMU

Rental Info

  • Vacation Rental: No

Tax Info

  • Assessor Parcel Number: 11211243
  • School Tax: 2511.00
  • Tax Annual Amount: 4162.00
  • Assessor Parcel Number: 27011-0086---000
  • Tax Total Finished Sq Ft: 2654
  • County Tax Payment Frequency: Annually
  • Tax Data Updated: No
  • Tax Year: 2021
  • Close Date: 04/27/2021

MLS Schools

  • School District Name: LITTLESTOWN AREA

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 26, 2020
Closed on
Apr 27, 2021
Sold by
Dillon Ronald G
Bought by
Paz Oscar
Seller's Agent
Melissa Divers-Reed
RE/MAX Solutions
Buyer's Agent
Wendy Hofmann
RE/MAX Solutions
List Price
$279,900
Sold Price
$225,000
Premium/Discount to List
-$54,900
-19.61%
Total Days on Market
141
Current Estimated Value
$281,278

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$56,278
Avg. Annual Appreciation
6.02%
Original Mortgage
$168,750
Outstanding Balance
$155,185
Interest Rate
3.1%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$132,074
Source: Public Records

Similar Homes in Littlestown, PA

  • 28 Gettysburg Ct Unit 60, Littlestown, PA 17340

    $299,900

    • 3 Beds
    • 2.5 Baths
    • 1,556 Sq Ft
    • 28 Gettysburg Ct
    • Unit 60
    • Littlestown, PA

    Coming Soon in Littlestown! This charming 3-bedroom, 2 1/2-bath split-level home is ready to make your own. With spacious rooms, cozy vibes, and plenty of natural light, it's the perfect place to call home. Stay tuned for interior photos that will make you fall in love! Don’t miss out on the opportunity to live in this wonderful neighborhood. More details to come!

    Missy Wise RE/MAX Patriots

    Section Image
  • 6054 Baltimore Pike Unit 1, Littlestown, PA 17340

    $265,000

    • 3 Beds
    • 1.5 Baths
    • 1,244 Sq Ft
    • 6054 Baltimore Pike
    • Unit 1
    • Littlestown, PA

    This charming3 bedroom 1.5 bath Colonial farmhouse, nestled in the heart of Littlestown, offers a perfect blend of classic design and modern upgrades. With a major renovation in 2024-2025, this home will feature a traditional floor plan enhanced by open kitchen upgraded countertops,new floors and a host of beautiful renovations, creating an inviting atmosphere for gatherings. The kitchen is

    Denise Lewis Brook-Owen Real Estate

    Section Image
  • 408 Lexington Way Unit 169, Littlestown, PA 17340

    $319,900

    • 3 Beds
    • 2 Baths
    • 1,484 Sq Ft
    • 408 Lexington Way
    • Unit 169
    • Littlestown, PA

    6/28 Open House Cancelled! Lovely home in a lovely development, sitting in a quaint small town of Littlestown in Historic Adams County. This 4 level split has gorgeous landscaping, family room, and a 2 car concrete driveway off the rear alley. The sellers have recently replaced the furnace (4 yrs) and central air condenser (5 yrs), water heater (2025), and are installing a new roof which will

    Bill Mundorff Berkshire Hathaway HomeServices Homesale Realty

    Section Image
  • 220 S Columbus Ave Unit 154, Littlestown, PA 17340

    $284,900

    • 3 Beds
    • 2 Baths
    • 1,463 Sq Ft
    • 220 S Columbus Ave
    • Unit 154
    • Littlestown, PA

    220 S. COLUMBUS AVE IN LITTLESTOWN, PA! STUNNING MULTI-LEVEL HOME IN HERITAGE HILLS - NO HOA! Welcome to this Well-Maintained Multi-Level Home in the Desirable Heritage Hills Neighborhood. Built in 2000, this property combines Modern Living with Excellent Equity-Building Potential on a Generous 0.26-Acre Lot. Step inside to discover a Thoughtfully Designed Open Concept Main Level featuring the

    Darren Dickensheets RE/MAX Quality Service, Inc.

    Section Image
  • 545 W King St, Littlestown, PA 17340

    $244,900

    • 3 Beds
    • 1.5 Baths
    • 1,307 Sq Ft
    • 545 W King St
    • Littlestown, PA

    Nestled at 545 West King St. in Littlestown, this charming home features three generously sized bedrooms, perfect for a growing family or those who enjoy extra space. The property includes a large garage out back, offering ample storage or workspace. Conveniently located close to shopping and schools, it's also an ideal spot for Maryland commuters. The newly installed laminate flooring in the

    Gavin Lamparter The Exchange Real Estate Company LLC

    Section Image
  • 5 Stayman Way Unit 61, Littlestown, PA 17340

    $325,000

    • 3 Beds
    • 2.5 Baths
    • 1,646 Sq Ft
    • 5 Stayman Way
    • Unit 61
    • Littlestown, PA

    Welcome to this charming 1,600+ sq. ft., 3-bedroom, 2.5-bath, 1-car garage home located in the Appler Community in Littlestown, PA, right on the Maryland-Pennsylvania border. This well-maintained home offers recent updates including fresh paint and new carpeting throughout, an updated first-floor bathroom, modern newer stainless steel kitchen appliances, and a newer water heater installed in

    Suzanne Christianson RE/MAX of Gettysburg

    Section Image
  • 48 Ashfield Dr Unit 55, Littlestown, PA 17340

    $324,900

    • 3 Beds
    • 2 Baths
    • 1,588 Sq Ft
    • 48 Ashfield Dr
    • Unit 55
    • Littlestown, PA

    Price Dropped $25,000 – Priced to Sell Fast!This 3-bedroom rancher with a 2-car garage is now an incredible value. Walking distance to schools, move-in ready, and waiting for you!Featuring a full unfinished basement, main-floor laundry and a spacious 2 car garage. This home offers both convenience and opportunity. Prime location - close to schools, shopping and more!

    Karen Tavenner RE/MAX Quality Service, Inc.

    Section Image
  • 863 Hanover Pike Unit 8, Littlestown, PA 17340

    $299,900

    • 4 Beds
    • 2 Baths
    • 2,397 Sq Ft
    • 863 Hanover Pike
    • Unit 8
    • Littlestown, PA

    Been looking for that 4 bedroom home with loads of square footage at a reasonable price? Well than this would be the one to dial in on. Sitting on just under a half acre and just outside of downtown Littlestown it is ideally situated for easy access to Hanover and the Md line. It cannot be overstated, all 4 bedrooms are a generous size; all 4 could easily be the size of a typical primary bedroom.

    Colin Cameron EXP Realty, LLC

    Section Image
  • 640 Bollinger Rd, Littlestown, PA 17340

    $225,000

    • 3 Beds
    • 2 Baths
    • 2,162 Sq Ft
    • 640 Bollinger Rd
    • Littlestown, PA

    List price to be opening bid at online only auction. Online auction to be conducted on Auctioneers website. Bidding begins Sunday, July 6th & ends Friday, July 11, 2025, at 12:00 PM. Updated 3 Bedroom, 2 Bath Split-Foyer Home – Move-In Ready! Welcome to this beautifully updated move-in ready two-story single-family home located just south of Littlestown, PA in Adams County, near the Mason-Dixon

    Carley Cooper Alex Cooper Auctioneers, Inc.

    Section Image

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
Paz Oscar $225,000 None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Paz Oscar $168,750
Previous Owner Dillon Ronald G $188,800
Previous Owner Dillon Ronald G $23,600
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/27/2021 04/27/21 Sold $225,000 -10.0% $85 / Sq Ft
03/16/2021 03/16/21 Pending -- -- --
02/17/2021 02/17/21 Price Changed $249,900 -2.0% $94 / Sq Ft
01/15/2021 01/15/21 Price Changed $254,900 -1.9% $96 / Sq Ft
12/29/2020 12/29/20 Price Changed $259,900 -1.9% $98 / Sq Ft
11/22/2020 11/22/20 Price Changed $264,900 -1.9% $100 / Sq Ft
11/05/2020 11/05/20 Price Changed $269,900 -3.6% $102 / Sq Ft
10/26/2020 10/26/20 For Sale $279,900 -- $105 / 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 $5,213 $226,800 $51,500 $175,300
2024 $5,024 $226,800 $51,500 $175,300
2023 $4,830 $226,800 $51,500 $175,300
2022 $4,237 $200,200 $51,500 $148,700
2021 $4,112 $200,200 $51,500 $148,700
2020 $4,063 $200,200 $51,500 $148,700
2019 $3,941 $200,200 $51,500 $148,700
2018 $3,869 $200,200 $51,500 $148,700
2017 $3,770 $200,200 $51,500 $148,700
2016 -- $200,200 $51,500 $148,700
2015 -- $200,200 $51,500 $148,700
2014 -- $200,200 $51,500 $148,700
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: PAAD113792

Bright MLS

APN: 27-011-0086-000