NOT LISTED FOR SALE

123 Squaw Trail Andover, NJ 07821

Estimated Value: $348,000 - $385,000

2 Beds
1 Bath
1,000 Sq Ft
$365/Sq Ft Est. Value

Last Sold March 22, 2021

Last sale price $259,900 $260 Per Sq Ft

Est. 40% increase in value since last sale

Current estimated payment $2,406/month

10 Days on Market

Highlights

  • Greenhouse
  • Cape Cod Architecture
  • Loft
  • Lake Privileges
  • Wood Burning Stove
  • 1 Fireplace

About This Home

As of March 2021

MOVE RIGHT IN to this well cared for, craftsmans maintenance free home, featuring 2 bedrooms,1 bath plus loft ,1 car garage and plenty of storage, brand new carpeting, laminate flooring, spacious living room with bay window & a Ben Franklin wood burning stove, spacious office, eat in kitchen with a huge pantry, a gardeners green house/harvest room,beautiful landscaping including a gardeners shed, composite deck, koi pond, dog run, wood storage and 2 storage sheds. Dead end street plenty of privacy and beautiful views. Enjoy the Cove Club Membership seller has paid 3 years(optional) for fishing, boating and swimming.

Last Agent to Sell the Property

CONSTANTINA HUELSENBECK

C-21 CHRISTEL REALTY Listed on: 01/15/2021

Last Buyer's Agent

Nicole Wickenheisser

COLDWELL BANKER REALTY

COLDWELL BANKER REALTY

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,947

Year Built

  • Built in 1931

Lot Details

  • 0.37 Acre Lot
  • Privacy Fence
  • Wood Fence

Parking

  • 1 Car Direct Access Garage
  • Tuck Under Garage
  • Off-Street Parking

Home Design

  • Cape Cod Architecture
  • Colonial Architecture
  • Vinyl Siding
  • Tile

Interior Spaces

  • Ceiling Fan
  • 1 Fireplace
  • Wood Burning Stove
  • Blinds
  • Living Room
  • Home Office
  • Loft
  • Utility Room
  • Fire and Smoke Detector

Kitchen

  • Eat-In Kitchen
  • Butlers Pantry
  • Electric Oven or Range
  • Self-Cleaning Oven
  • Microwave
  • Dishwasher

Flooring

  • Wall to Wall Carpet
  • Laminate

Bedrooms and Bathrooms

  • 2 Bedrooms
  • Primary bedroom located on second floor
  • 1 Full Bathroom

Laundry

  • Laundry Room
  • Dryer
  • Washer

Basement

  • Walk-Out Basement
  • Partial Basement
  • Front Basement Entry

Outdoor Features

  • Lake Privileges
  • Patio
  • Greenhouse
  • Storage Shed
  • Outbuilding
  • Porch

Schools

  • Hopatcong Middle School
  • Hopatcong High School

Utilities

  • Electric Baseboard Heater
  • Standard Electricity
  • Well
  • Electric Water Heater

Listing and Financial Details

  • Assessor Parcel Number 2812-41006-0000-00008-0000-
  • Tax Block *

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,947

Year Built

Built in 1931

Lot Details

0

Parking

1

Listing Details

  • Style: Colonial, Cape Cod
  • Primary Style: Colonial
  • Subproperty Type: Single Family
  • Year Built: 1931
  • Year Built Description: Approximate
  • County Name: Sussex
  • Street Number Display: 123
  • Directions: LAKESIDE BLVD TO LEFT ON HOPATCHUNG TO RIGHT ON RIVER STYX TO LEFT ON SQUAW. HOME ON LEFT.
  • I D: 5042438
  • Modified: 2022-03-23
  • Number Images: 22
  • Section Subdiv Development: BYRAM COVE
  • First Name: CONSTANTINA
  • First Name3: NICOLE
  • Last Name: HUELSENBECK
  • Last Name3: WICKENHEISSER
  • Office Phone3: 273080
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Flooring: Carpeting, Laminate, Tile
  • Fireplace Description: Wood Stove-Freestanding
  • Number of Fireplaces: 1
  • Appliances: Dishwasher, Dryer, Microwave Oven, Range/Oven-Electric, Refrigerator, Self Cleaning Oven, Washer
  • Interior Amenities: Blinds, Carbon Monoxide Detector, Smoke Detector, TubShowr
  • Number Rooms: 7
  • Bedrooms: 2
  • Bedroom 1 Level: Second
  • Bedroom 2 Level: Second
  • Bathrooms: 1.00
  • Full Bathrooms: 1
  • Basement: Yes
  • Basement Description: Partial, Walkout
  • Kitchen Area: Eat-In Kitchen, Pantry
  • Kitchen Dim: 17x14
  • Kitchen Level: First
  • Living Room Dim: 12x18
  • Living Room Level: First
  • Other Room 1: Loft
  • Other Room1 Dim: 9x10
  • Other Room1 Level: Second
  • Other Room 2: Vestibul
  • Other Room2 Dim: 5x15
  • Other Room2 Level: First
  • Other Room 3: Office
  • Other Room3 Dim: 10x9
  • Other Room3 Level: First
  • Level 1 Rooms: Bath Main, Entrance Vestibule, GreenHse, Kitchen, Living Room, Office, Pantry, Porch
  • Level 2 Rooms: 2 Bedrooms, Loft
  • Ground Level Rooms: GarEnter, Laundry Room, Utility Room
  • Phone: 973-627-6800

Exterior Features

  • Exterior Description: Vinyl Siding
  • Exterior Features: Greenhouse Type Room, Outbuilding(s), Patio, Privacy Fence, Storage Shed, FencVnyl, Wood Fence
  • Roof Description: Asphalt Shingle

Garage/Parking

  • Garage Description: Garage Under
  • Number Garage Spaces: 1
  • Number Parking Spaces: 1
  • Parking Driveway Description: Blacktop, Off-Street Parking

Utilities

  • Cooling: Ceiling Fan
  • Fuel Type: Electric
  • Heating: Baseboard - Electric
  • Sewer: Septic 2 Bedroom Town Verified
  • Utilities: Electric
  • Water: Well
  • Water Heater: Electric

Condo/Co-op/Association

  • Amenities: Lake Privileges

Schools

  • Middle School: HOPATCONG
  • High School: HOPATCONG
  • High School: HOPATCONG
  • Middle Jr High School: HOPATCONG

Lot Info

  • Lot Size: 100X131 IRR
  • Assessed Improvement Value: 80900
  • Assessed Land Value: 68000
  • Assessment: 148900
  • Easement: Unknown
  • Lot Identifier: 8
  • Lot I D Tax: *
  • Total Acres: 0.37

Rental Info

  • Pets Allowed: Yes

Tax Info

  • Tax Acres: *
  • Assessed Improvement Value: *
  • Assessed Land Value: *
  • Total Tax Assessed: *
  • Streetname Tax: *
  • Street Number Tax: *
  • Tax Amount: 4947
  • Tax Amount Tax: *
  • Assessor Parcel Number: 2812-41006-0000-00008-0000-
  • Assessor Parcel Number: *
  • Tax Rate Amount: 3.323
  • Tax Rate Tax: *
  • Tax Rate Year: 2019
  • Tax Year Tax: *
  • Tax Year: 2019

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 15, 2021
Closed on
Mar 22, 2021
Sold by
Jobeless Ronald F and Jobeless Ronald
Bought by
Liuzzi Luca
Seller's Agent
CONSTANTINA HUELSENBECK
C-21 CHRISTEL REALTY
Buyer's Agent
Nicole Wickenheisser
COLDWELL BANKER REALTY
List Price
$259,900
Sold Price
$259,900
Current Estimated Value
$364,702

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$104,802
Avg. Annual Appreciation
7.75%
Original Mortgage
$207,920
Interest Rate
2.8%
Mortgage Type
New Conventional

Purchase Details

Listed on
Jan 15, 2021
Closed on
Mar 19, 2021
Sold by
Jobeless Ronald F
Bought by
Liuzzi Luca
Seller's Agent
CONSTANTINA HUELSENBECK
C-21 CHRISTEL REALTY
Buyer's Agent
Nicole Wickenheisser
COLDWELL BANKER REALTY
List Price
$259,900
Sold Price
$259,900

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$207,920
Interest Rate
2.8%
Mortgage Type
New Conventional

Purchase Details

Closed on
May 8, 2006
Sold by
Jobeless Anneke and Lowe Anneke
Bought by
Jobeless Ronald and Jobeless Anneke
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
Liuzzi Luca $259,900 Good To Be Home Title Agency
Liuzzi Luca $259,900 New Title Company Name
Jobeless Ronald -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Liuzzi Luca $207,920
Previous Owner Liuzzi Luca $207,920
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/22/2021 03/22/21 Sold $259,900 0.0% $260 / Sq Ft
01/25/2021 01/25/21 Pending -- -- --
01/15/2021 01/15/21 For Sale $259,900 -- $260 / Sq Ft
Source: Garden State 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,757 $276,100 $118,800 $157,300
2024 $5,210 $276,100 $118,800 $157,300
2023 $5,210 $148,900 $68,000 $80,900
2022 $5,107 $148,900 $68,000 $80,900
2021 $5,021 $148,900 $68,000 $80,900
2020 $4,969 $148,900 $68,000 $80,900
2019 $4,948 $148,900 $68,000 $80,900
2018 $4,938 $148,900 $68,000 $80,900
2017 $4,930 $148,900 $68,000 $80,900
2016 $4,941 $148,900 $68,000 $80,900
2015 $4,829 $148,900 $68,000 $80,900
2014 $4,812 $148,900 $68,000 $80,900
Source: Public Records

Agents Affiliated with this Home

  • C

    Seller's Agent in 2021

    CONSTANTINA HUELSENBECK

    C-21 CHRISTEL REALTY

  • Nicole Wickenheisser

    Buyer's Agent in 2021

    Nicole Wickenheisser

    COLDWELL BANKER REALTY

    (201) 230-1743

    3 in this area

    77 Total Sales

    Nicole Wickenheisser
    Section Image
See All Agents

Map

Source: Garden State MLS

MLS Number: 3687214

Garden State MLS

APN: 12-41006-0000-00008

New Jersey Sussex County Andover 07821

123 Squaw Trail, Andover, NJ

This home is located at 123 Squaw Trail, Andover, NJ 07821 since 15 January 2021 and is currently estimated at $364,702, approximately $364 per square foot. This property was built in 1931. 123 Squaw Trail is a home located in Sussex County with nearby schools including Hudson Maxim Elementary School, Durban Avenue Elementary School, and Tulsa Trail Elementary School.

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.

Garden State MLS The data relating to real estate for sale on this website comes in part from the IDX Program of Garden State Multiple Listing Service, L.L.C. Real estate listings held by other brokerage firms are marked as IDX Listing.

Information deemed reliable but not guaranteed.
Copyright © 2025 Garden State Multiple Listing Service, L.L.C. All rights reserved.

Notice: The dissemination of listings on this website does not constitute the consent required by N.J.A.C. 11:5.6.1 (n) for the advertisement of listings exclusively for sale by another broker. Any such consent must be obtained in writing from the listing broker.



This information is being provided for Consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties Consumers may be interested in purchasing.

Nearby Homes