Seller's Agent in 2022
Kathy Courter
RE/MAX
(973) 420-0022
60 in this area
209 Total Sales
227 Squaw Trail Andover, NJ 07821
Estimated Value: $1,273,000 - $1,577,000
4
Beds
3.5
Baths
3,800
Sq Ft
$375/Sq Ft
Est. Value
Highlights
- Private Waterfront
- Second Kitchen
- Sauna
- Docks
- Home Theater
- Sitting Area In Primary Bedroom
About This Home
As of August 2022100 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!
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 *
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
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.91%
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
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
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Gulotta Charles | $1,312,500 | Conti Alexandra A | |
| Laroia Rajiv | $787,500 | Chicago Title Insurance Co | |
| Squaw Trail Llc | $250,000 | None Available | |
| Somjen Gregory J | -- | None Available |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Gulotta Charles | $853,125 | |
| Previous Owner | Laroia Rajiv | $556,000 | |
| Previous Owner | Laroia Rajiv | $590,625 | |
| Previous Owner | Squaw Trail Llc | $300,000 | |
| Previous Owner | Squaw Trail Llc | $200,000 | |
| Previous Owner | Somjen Gregory J | $200,000 | |
| Previous Owner | Sills Charles J | $100,000 | |
| Previous Owner | Sills Charles J | $259,000 |
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
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
-
Kathy Courter
-
Leila Duran
Buyer's Agent in 2022
Leila Duran
ADDISON REAL ESTATE
(862) 432-1566
3 in this area
52 Total Sales
Map
Source: Garden State MLS
MLS Number: 3762457
APN: 12-50208-0000-00014-01
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.
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
- 229 A Squaw Trail
- 385 Maxim Dr
- 46 Oklahoma Trail
- 14 Marshall Trail
- 307 Squaw Trail
- 47 Indian Trail
- 35 Fordham Trail
- 321 Squaw Trail
- 13 Oklahoma Trail
- 46 Sutton Trail
- 4 Bear Pond Trail
- 106 Leland Trail
- 104 Leland Trail
- 208 Maxim Dr
- 35 Mountain Trail
- 244 Dupont Ave
- 27 Skidmore Trail
- 36 Oneida Ave
- 636 Lakeside Ave
- 15 Sutton Rd