NOT LISTED FOR SALE

247 Squaw Trail Andover, NJ 07821

Estimated Value: $741,000 - $1,268,000

4 Beds
2 Baths
1,598 Sq Ft
$639/Sq Ft Est. Value

Last Sold November 07, 2017

Last sale price $585,000 $366 Per Sq Ft

Est. 75% increase in value since last sale

Current estimated payment $7,004/month

110 Days on Market

Highlights

  • Private Waterfront
  • Custom Home
  • Deck
  • Docks
  • Lake Privileges
  • Wooded Lot

About This Home

As of November 2017

LAKEFRONT ON LAKE HOPATCONG! PRIVATE SETTING ON DEAD END STREET! 103' OF LAKE FRONTAGE! Deep water section! Bring your toys, 2 docks 32' long, and another dock for Kayaks Canoes, Jet Skis! Stairs lead their way into the lake for the perfect swimming spot! Swing off the rope and splash into the lake like the good old days! 2 levels of decking, 2 patios, 2 docks and plenty of space for entertaining during those endless summer days or all year round! Open floor plan tons of windows your eyes get drawn out to the lake with the panoramic views on all levels! Kitchen has corian counter tops, with miles of counter space perfect for those who love to cook and entertain! Spacious bedrooms 3 w/ 4th room used as office or could be extra bedrm if needed! Lower level familyrm with views galore! Sunrises!

Last Agent to Sell the Property

Darla Quaranta

CENTURY 21 GEBA REALTY Listed on: 05/10/2017

CENTURY 21 GEBA REALTY

Last Buyer's Agent

Darla Quaranta

CENTURY 21 GEBA REALTY Listed on: 05/10/2017

CENTURY 21 GEBA REALTY

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $15,993

Year Renovated

  • 1996

Lot Details

  • 0.29 Acre Lot
  • Private Waterfront
  • Lake Front
  • Wooded Lot

Home Design

  • Custom Home
  • Vinyl Siding

Interior Spaces

  • Cathedral Ceiling
  • Ceiling Fan
  • Skylights
  • Family Room
  • Living Room
  • Formal Dining Room
  • Home Office

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Electric Oven or Range
  • Recirculated Exhaust Fan
  • Dishwasher

Flooring

  • Wood
  • Wall to Wall Carpet

Bedrooms and Bathrooms

  • 4 Bedrooms
  • En-Suite Primary Bedroom
  • Cedar Closet
  • 2 Full Bathrooms
  • Bathtub with Shower

Laundry

  • Laundry Room
  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Exterior Basement Entry

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Parking

  • 15 Parking Spaces
  • Stone Driveway

Accessible Home Design

  • Accessible Bedroom

Outdoor Features

  • Docks
  • Lake Privileges
  • Deck
  • Patio
  • Storage Shed

Schools

  • Hopatcong Elementary And Middle School
  • Hopatcong High School

Utilities

  • Cooling System Mounted In Outer Wall Opening
  • Standard Electricity
  • Well
  • Oil Water Heater
  • Water Softener is Owned
  • Septic System

Community Details

  • Powered Boats Allowed

Listing and Financial Details

  • Assessor Parcel Number 2812-50208-0000-00026-0000-
  • Tax Block *

Home Details

Home Type

Single Family

Est. Annual Taxes

$15,993

Year Renovated

1996

Lot Details

0

Listing Details

  • Style: Custom Home
  • Primary Style: Custom Home
  • Subproperty Type: Single Family
  • Year Built: 9999
  • Year Built Description: Approximate, Renovated
  • County Name: Sussex
  • Renovated Year: 1996
  • Street Number Display: 247
  • Directions: Maxim to Indian Trl to Papoose to R on Brave R Squaw #247 Go to the end!
  • I D: 4713056
  • Modified: 2021-09-23
  • Number Images: 24
  • Section Subdiv Development: LAKEFRONT/LAKE HOPATCONG
  • First Name: DARLA
  • First Name3: DARLA
  • Last Name: QUARANTA
  • Last Name3: QUARANTA
  • Office Phone: 973-726-0333
  • Office Phone3: 973-726-0333
  • Special Features: None
  • Property Sub Type: Detached
  • Year Renovated: 1996

Interior Features

  • Flooring: Carpeting, Wood
  • Appliances: Carbon Monoxide Detector, Range/Oven-Electric, Refrigerator, Washer, Dishwasher, Water Softener-Own, Kitchen Exhaust Fan, Dryer
  • Interior Amenities: Cedar Closets, SoakTub, TubShowr, Fire Extinguisher, Carbon Monoxide Detector, High Ceilings, Skylight, Cathedral Ceiling, Smoke Detector
  • Number Rooms: 8
  • Bedrooms: 4
  • Master Bedroom Desc: Full Bath
  • Bedroom 1 Level: Ground
  • Bedroom 2 Level: Second
  • Bedroom 3 Level: Second
  • Primary Bathroom Features: Tub Shower
  • Bathrooms: 2.00
  • Full Bathrooms: 2
  • Basement: Yes
  • Basement Description: Walkout, Finished, Full
  • Dining Room Level: First
  • Dining Area: Formal Dining Room
  • Family Room Level: Ground
  • Kitchen Area: Breakfast Bar, Eat-In Kitchen, Separate Dining Area
  • Kitchen Dim: 20x13
  • Kitchen Level: First
  • Living Room Dim: 17x24
  • Living Room Level: First
  • Other Room 1: Office
  • Other Room1 Dim: 11x10
  • Other Room1 Level: First
  • Level 1 Rooms: 1 Bedroom, Laundry Room, Office, Living Room, Dining Room, Bath Main, Kitchen
  • Level 2 Rooms: 2 Bedrooms
  • Ground Level Rooms: 1 Bedroom, Office, Walkout, Outside Entrance, Bath(s) Other, Family Room
  • Phone: 973-726-0333

Exterior Features

  • Exterior Description: Vinyl Siding
  • Exterior Features: Dock, Storage Shed, Patio, Deck
  • Roof Description: Asphalt Shingle

Garage/Parking

  • Number Parking Spaces: 15
  • Parking Driveway Description: 2 Car Width, Crushed Stone, Blacktop

Utilities

  • Cooling: Ceiling Fan, Wall A/C Unit(s)
  • Fuel Type: OilAbOut
  • Heating: 1 Unit, Baseboard - Hotwater
  • Sewer: Septic
  • Utilities: Electric
  • Water: Well
  • Water Heater: Oil

Condo/Co-op/Association

  • Amenities: Boats - Gas Powered Allowed, Lake Privileges

Schools

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

Lot Info

  • Lot Size: 98X130
  • Assessed Improvement Value: 208200
  • Assessed Land Value: 273800
  • Assessment: 482000
  • Easement: Unknown
  • Lot Description: Waterfront, Wooded Lot, Lake Front
  • Lot Identifier: 26
  • Lot I D Tax: *
  • Lot Size Tax: *
  • Total Acres: 0.29
  • Zoning: RES

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: 15993
  • Tax Amount Tax: *
  • Assessor Parcel Number: 2812-50208-0000-00026-0000-
  • Tax Rate Amount: 3.318
  • Tax Rate Tax: *
  • Tax Rate Year: 2016
  • Tax Year Tax: *
  • Tax Year: 2016

MLS Schools

  • Grade School: HOPATCONG

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 10, 2017
Closed on
Oct 30, 2017
Sold by
Warfield Bradley D and Warfield Kathy A
Bought by
Annis Mark C
Seller's Agent
Darla Quaranta
CENTURY 21 GEBA REALTY
Buyer's Agent
Darla Quaranta
CENTURY 21 GEBA REALTY
List Price
$625,000
Sold Price
$585,000
Premium/Discount to List
-$40,000
-6.4%
Current Estimated Value
$1,021,461

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$436,461
Avg. Annual Appreciation
3.87%
Original Mortgage
$526,500
Interest Rate
3.5%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Jun 28, 2005
Sold by
Robertson Robert
Bought by
Warfield Bradley D and Warfield Kathy A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$513,000
Interest Rate
6.37%
Mortgage Type
Fannie Mae Freddie Mac

Purchase Details

Closed on
Nov 9, 1994
Sold by
Campbell Jeffrey S and Knight Andrew D
Bought by
Robertson Robert
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
Annis Mark C $585,000 Simplicity Title Llc
Warfield Bradley D $570,000 First American Title Ins Co
Robertson Robert $64,125 First American Title Ins Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Annis Mark $310,000
Closed Annis Mark C $64,820
Previous Owner Annis Mark C $526,500
Previous Owner Warfield Bradley D $35,000
Previous Owner Warfield Bradley D $415,000
Previous Owner Warfield Bradley D $513,000
Previous Owner Robertson Robert $350,000
Previous Owner Robertson Robert $200,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
11/07/2017 11/07/17 Sold $585,000 -6.4% $366 / Sq Ft
08/28/2017 08/28/17 Pending -- -- --
05/10/2017 05/10/17 For Sale $625,000 -- $391 / 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
2024 $17,387 $785,500 $399,100 $386,400
2023 $17,387 $496,900 $278,300 $218,600
2022 $16,889 $492,400 $273,800 $218,600
2021 $16,604 $492,400 $273,800 $218,600
2020 $16,084 $482,000 $273,800 $208,200
2019 $16,017 $482,000 $273,800 $208,200
2018 $15,983 $482,000 $273,800 $208,200
2017 $15,959 $482,000 $273,800 $208,200
2016 $15,993 $482,000 $273,800 $208,200
2015 $15,631 $482,000 $273,800 $208,200
2014 $15,578 $482,000 $273,800 $208,200
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Garden State MLS

MLS Number: 3386901

Garden State MLS

APN: 12-50208-0000-00026