$1,312,500
SOLD AUG 26, 2022

227 Squaw Trail Andover, NJ 07821

4 Beds
3.5 Baths
3,800 Sq Ft
0.35 Acres

Recently Sold

$345 Per Sq Ft

91% Below List Price

174 Days on Market

Highlights

  • Private Waterfront
  • Second Kitchen
  • Sauna
  • Docks
  • Home Theater
  • Sitting Area In Primary Bedroom

About This Home

As of August 2022

100 feet of lakefront! Stylish one owner custom built lake home located in a scenic tranquil location. Tucked away in a 5 mile per hour protected cove. Enjoy swimming, fishing, and entertaining off your lakefront patios and covered deck with outdoor gas fireplace. Interior offers three living levels (see floor plans). Great rm with gas fireplace is open to dining rm and main kitchen. 1st floor laundry rm & separate powder rm. 2nd floor with spacious master suite, sitting rm, sauna room, walk-in closet. Spa like master bath with jetted tub, glass enclosed shower, dual vanity and slider to private balcony deck that leads back into master suite. Two additional spacious bedrooms and full guest bath. Lower level walk-out with high ceilings, full 2nd kitchen, media rm/4th bedroom as this space has two double closets. Full bath with walk-in shower. Spacious family rm/game rm with sliders to lower level covered patio and outdoor patio. Steps lead to lower level lakefront access to dock with swim ladder. This property backs to woods and is located within 10 minutes to shopping. Hiking and biking paths, state parks, 20 mins to major ski resort, golf & spa. 30 minutes to Morristown and 1 hour to NYC. NJ transit train, uber available. Turn key, mint condition lake house. The perfect place you have been waiting for! See video walk through and feature sheet for interior and exterior appointments. No expense spared!

Last Agent to Sell the Property

Kathy Courter

RE/MAX HOUSE VALUES Listed on: 02/05/2022

RE/MAX HOUSE VALUES

Last Buyer's Agent

Leila Duran

ADDISON REAL ESTATE

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $23,836

Year Built

  • Built in 2011

Lot Details

  • 0.35 Acre Lot
  • Private Waterfront
  • Lake Front

Parking

  • 2 Car Attached Garage
  • Oversized Parking
  • Inside Entrance
  • Garage Door Opener

Home Design

  • Custom Home
  • Stone Siding
  • Vinyl Siding
  • Tile

Interior Spaces

  • 3,800 Sq Ft Home
  • High Ceiling
  • Gas Fireplace
  • Thermal Windows
  • Blinds
  • Entrance Foyer
  • Living Room with Fireplace
  • 2 Fireplaces
  • Family or Dining Combination
  • Home Theater
  • Loft
  • Sauna
  • Carbon Monoxide Detectors
  • Attic

Kitchen

  • Second Kitchen
  • Breakfast Bar
  • Butlers Pantry
  • Gas Oven or Range
  • Recirculated Exhaust Fan
  • Microwave
  • Dishwasher
  • Wine Refrigerator
  • Kitchen Island

Flooring

  • Wood
  • Wall to Wall Carpet

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Sitting Area In Primary Bedroom
  • Primary bedroom located on second floor
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • Dressing Area
  • Powder Room
  • In-Law or Guest Suite
  • Jetted Tub in Primary Bathroom
  • Separate Shower

Laundry

  • Laundry Room
  • Dryer
  • Washer

Finished Basement

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

Outdoor Features

  • Docks
  • Deck
  • Patio
  • Porch

Schools

  • Hopatcong High School

Utilities

  • Central Air
  • Multiple Heating Units
  • Propane
  • Well
  • Electric Water Heater
  • Septic System

Community Details

  • Powered Boats Allowed

Listing and Financial Details

  • Assessor Parcel Number 2812-50208-0000-00014-0001-
  • Tax Block *

Home Details

Home Type

Single Family

Est. Annual Taxes

$23,836

Year Built

Built in 2011

Lot Details

0

Parking

2

Listing Details

  • Style: Custom Home
  • Primary Style: Custom Home
  • Subproperty Type: Single Family
  • Year Built: 2011
  • Year Built Description: Approximate
  • County Name: Sussex
  • Exclusions: see seller disclosure
  • Street Number Display: 227
  • Directions: Maxim Dr to Squaw Trail
  • I D: 5127852
  • Modified: 2023-08-27
  • Number Images: 34
  • Section Subdiv Development: Lake Hopatcong
  • First Name: KATHLEEN
  • First Name3: LEILA
  • Last Name: COURTER
  • Last Name3: DURAN
  • Office Phone: 973-420-0022
  • Office Phone3: 862-251-4915
  • Attribution Contact: null
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Flooring: Carpeting, Tile, Wood
  • Fireplace Description: Gas Fireplace, Living Room
  • Number of Fireplaces: 2
  • Appliances: Carbon Monoxide Detector, Dishwasher, Dryer, Kitchen Exhaust Fan, Microwave Oven, Range/Oven-Gas, Refrigerator, Washer, WineRefr
  • Interior Amenities: Blinds, High Ceilings, JacuzTyp, Security System, StallShw, StallTub, Walk-In Closet
  • Number Rooms: 11
  • Bedrooms: 4
  • Master Bedroom Desc: Dressing Room, Full Bath, Sitting Room, Walk-In Closet
  • Bedroom 1 Level: Second
  • Bedroom 2 Level: Second
  • Bedroom 3 Level: Second
  • Bedroom 4 Level: Basement
  • Primary Bathroom Features: Jetted Tub, Sauna, Stall Shower
  • Bathrooms: 3.10
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Description: Finished, Full, Walkout
  • Basement Level Rooms: 1 Bedroom, Bath(s) Other, Family Room, Media Room
  • Dining Room Level: First
  • Dining Area: Living/Dining Combo
  • Family Room Level: Basement
  • In Law Suite: Yes
  • In Law Suite Description: Bedroom 1, Full Bath, Kitchen, Living Room, SepEnter
  • Kitchen Area: Breakfast Bar, Center Island, Pantry, Second Kitchen
  • Kitchen Dim: 14x10
  • Kitchen Level: First
  • Living Room Dim: 15x15
  • Living Room Level: First
  • Other Room 1: Kitchen
  • Other Room1 Dim: 14x10
  • Other Room1 Level: Basement
  • Other Room 2: Media Room
  • Other Room2 Dim: 20x20
  • Other Room2 Level: Basement
  • Other Room 3: Utility Room
  • Other Room3 Dim: 9x8
  • Other Room3 Level: Basement
  • Level 1 Rooms: Foyer, Kitchen, Laundry Room, LivDinRm, Pantry, Porch, Powder Room
  • Level 2 Rooms: 3 Bedrooms, Attic, Bath Main, Bath(s) Other, Loft
  • Estimated Sq Ft: 3800
  • Phone: 973-770-7777

Exterior Features

  • Exterior Description: Stone, Vinyl Siding
  • Exterior Features: Deck, Dock, Open Porch(es), Patio, Thermal Windows/Doors
  • Roof Description: Asphalt Shingle

Garage/Parking

  • Garage Description: Attached Garage, Garage Door Opener, InEntrnc, Oversize Garage
  • Number Garage Spaces: 2
  • Number Parking Spaces: 4
  • Parking Driveway Description: 2 Car Width, Blacktop

Utilities

  • Cooling: Central Air
  • Fuel Type: GasPropL
  • Heating: 2 Units
  • Sewer: Septic
  • Utilities: Gas-Propane
  • Water: Well
  • Water Heater: Electric

Condo/Co-op/Association

  • Amenities: Boats - Gas Powered Allowed

Schools

  • High School: HOPATCONG
  • High School: HOPATCONG

Lot Info

  • Lot Size: 100 X150 IRR
  • Assessed Improvement Value: 423600
  • Assessed Land Value: 283300
  • Assessment: 706900
  • Lot Description: Lake Front, Waterfront
  • Lot Identifier: 14.01
  • Lot I D Tax: *
  • Total Acres: 0.35
  • Zoning: Res

Tax Info

  • Tax Acres: *
  • Assessed Improvement Value: *
  • Assessed Land Value: *
  • Total Tax Assessed: *
  • Streetname Tax: *
  • Street Number Tax: *
  • Tax Amount: 23836
  • Tax Amount Tax: *
  • Assessor Parcel Number: 2812-50208-0000-00014-0001-
  • Assessor Parcel Number: *
  • Tax Rate Amount: 3.372
  • Tax Rate Tax: *
  • Tax Rate Year: 2021
  • Tax Year Tax: *
  • Tax Year: 2021

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 5, 2022
Closed on
Aug 23, 2022
Sold by
Laroia and Deepika
Bought by
Gulotta Charles and Gulotta Tara A
Seller's Agent
Kathy Courter
RE/MAX HOUSE VALUES
Buyer's Agent
Leila Duran
ADDISON REAL ESTATE
List Price
$14,999,900
Sold Price
$1,312,500
Premium/Discount to List
-$13,687,400
-91.25%
Views
15
Current Estimated Value
$1,424,596

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$112,096
Avg. Annual Appreciation
2.86%
Original Mortgage
$853,125
Outstanding Balance
$820,030
Interest Rate
5.13%
Estimated Equity
$604,566

Purchase Details

Listed on
Apr 10, 2012
Closed on
Apr 10, 2012
Sold by
Squaw Trail Llc
Bought by
Laroia Rajiv and Laroia Deepika
Seller's Agent
Kathy Courter
RE/MAX HOUSE VALUES
Buyer's Agent
Kathy Courter
RE/MAX HOUSE VALUES
Sold Price
$787,500

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.04%
Original Mortgage
$590,625
Interest Rate
3.17%
Mortgage Type
New Conventional

Purchase Details

Closed on
Nov 4, 2009
Sold by
Somjen Gregory J and Parette Marc
Bought by
Squaw Trail Llc

Purchase Details

Closed on
Sep 14, 2009
Sold by
Somjen Gregory J and Parette Marc
Bought by
Somjen Gregory J and Parette Marc
Source: Public Records

Similar Homes in Andover, NJ

  • 307 Squaw Trail, Andover, NJ 07821

    $1,050,000

    • 3 Beds
    • 4 Baths
    • 2,282 Sq Ft
    • 307 Squaw Trail
    • Andover, NJ

    Lakeside Living has never looked better! Beautiful 3 Bed, 4 Bath Colonial with Master Suite backing to beautiful Byram Cove in desirable Hopatcong is sure to impress! Meticulously maintained inside & out with plenty of big ticket upgrades all through, move-in-ready and waiting for you! Spanning three finished levels with over 2200 sq ft of sophisticated living, just pack your bags & move right

    Robert Dekanski RE/MAX 1st ADVANTAGE

    Section Image
  • 1 Lourdes Ct, Andover, NJ 07821

    $1,175,000

    • 4 Beds
    • 4.5 Baths
    • 1 Lourdes Ct
    • Andover, NJ

    Stunning New Construction in prestigious Perona Estates. A Masterpiece of Modern Living! Country setting, just 50 miles from NYC. Step inside this beautiful new home, designed with an expansive open floor plan that seamlessly blends elegance and functionality. With sun-drenched living spaces and thoughtful architectural details, this home is perfect for both everyday comfort and grand

    CHRISTINE KASKO COLDWELL BANKER REALTY

    Section Image
  • 111 Ballantine Rd, Andover, NJ 07821

    $975,000

    • 3 Beds
    • 4 Baths
    • 111 Ballantine Rd
    • Andover, NJ

    RESORT LIKE SETTING, SPRAWLING RANCH ON A COUNTRY ESTATE, WITH ALL THE AMENITIES YOU'VE DREAMED OF,SET ON 3 PLUS ACRES FENCED IN ACRES AND LANDSCAPED LIKE A SOPHISTICATED, METROPOLITAN PARK. THIS HOME AND PROPERTY HAS A TENNIS/PICKLEBALL COURT, GORGEOUS HEATED POOL WITH STONE WATERFALL AND BRAND NEW LINER, HOT TUB, KOI POND, A WRAP AROUND DECK WITH A COVERED, DRAPED OUTDOOR RM PLUS EXTENSIVE

    Michael Kahwaty COLDWELL BANKER REALTY

    Section Image
  • 27 Mountainview Dr, Andover, NJ 07821

    $999,000

    • 4 Beds
    • 4.5 Baths
    • 5,500 Sq Ft
    • 27 Mountainview Dr
    • Andover, NJ

    Breathtaking from the curb and remarkable within, this stunning, one-of-a-kind 4 Bed 4.5 Bath Custom Colonial with dual Primary Suites and Oversized 3 Car Garage has everything you need and more. Situated on a premium private cul-de-sac of 3+ plush acres with over 5500+ sq ft of luxurious living, enjoy peace and privacy abound. Double door entry and grand two story foyer sets the stage for

    Robert Dekanski RE/MAX 1st ADVANTAGE

    Section Image
  • 96 Brighton Rd, Andover, NJ 07821

    $1,100,000

    • 4 Beds
    • 2.5 Baths
    • 96 Brighton Rd
    • Andover, NJ

    Welcome to this RARE opportunity to own a beautifully maintained colonial home, offered for the first time by its original owners! Originally designed as a 4-bedroom residence, one wall has been thoughtfully removed to create an oversized bedroom, making the home currently configured as 3 bedrooms easily convertible back if desired. Inside, you'll find a spacious and open floor plan that

    Christine Laird WEICHERT REALTORS

    Section Image
  • 8 Limekiln Ct, Andover, NJ 07821

    $1,098,000

    • 5 Beds
    • 5.5 Baths
    • 8 Limekiln Ct
    • Andover, NJ

    Welcome to this stunning well maintained 5,700 sq ft home, boasting 5 bedrooms & 5.5 baths, nestled at the end of a cul-de-sac, set on 5.92 acres.The grand center hall greets you with 2 curved staircases into a home designed for spacious and luxurious living. The 1st floor features a formal Living & Dining room that steps into a 2-story family room featuring a granite fireplace. A dedicated Study

    DEIRDRE GOOD WEICHERT REALTORS

    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 Type Sale Price Title Company
Deed $1,312,500 Conti Alexandra A
Deed $787,500 Chicago Title Insurance Co
Bargain Sale Deed $250,000 None Available
Interfamily Deed Transfer -- None Available
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $853,125 No Value Available
Previous Owner $556,000 New Conventional
Previous Owner $590,625 New Conventional
Previous Owner $300,000 Credit Line Revolving
Previous Owner $200,000 Credit Line Revolving
Previous Owner $200,000 Unknown
Previous Owner $100,000 Unknown
Previous Owner $259,000 Unknown
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/26/2022 08/26/22 Sold $1,312,500 -5.9% $345 / Sq Ft
07/29/2022 07/29/22 Pending -- -- --
06/11/2022 06/11/22 Price Changed $1,395,000 -3.8% $367 / Sq Ft
05/21/2022 05/21/22 Price Changed $1,449,900 -3.3% $382 / Sq Ft
02/05/2022 02/05/22 Price Changed $1,499,900 -90.0% $395 / Sq Ft
02/05/2022 02/05/22 For Sale $14,999,900 +1804.7% $3,947 / Sq Ft
04/10/2012 04/10/12 Sold $787,500 -- $1,135 / 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 $24,734 $1,310,800 $449,400 $861,400
2023 $24,734 $706,900 $283,300 $423,600
2022 $24,247 $706,900 $283,300 $423,600
2021 $23,837 $706,900 $283,300 $423,600
2020 $23,589 $706,900 $283,300 $423,600
2019 $23,490 $706,900 $283,300 $423,600
2018 $23,441 $706,900 $283,300 $423,600
2017 $23,405 $706,900 $283,300 $423,600
2016 $23,455 $706,900 $283,300 $423,600
2015 $22,925 $706,900 $283,300 $423,600
2014 $22,847 $706,900 $283,300 $423,600
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Garden State MLS

MLS Number: 3762457

Garden State MLS

APN: 12-50208-0000-00014-01