NOT LISTED FOR SALE

12 Squan Song Ln Colts Neck, NJ 07722

Estimated Value: $2,340,000 - $2,815,000

5 Beds
5.5 Baths
5,800 Sq Ft
$452/Sq Ft Est. Value

Last Sold October 10, 2017

Last sale price $1,500,000 $259 Per Sq Ft

Est. 75% increase in value since last sale

Current estimated payment $16,389/month

51 Days on Market

Highlights

  • Indoor Spa
  • Heated In Ground Pool
  • Maid or Guest Quarters
  • Conover Road School Rated A
  • 2.8 Acre Lot
  • Contemporary Architecture

About This Home

As of October 2017

HUGE PRICE REDUCTION!!! FABULOUS VALUE! NOT JUST A HOME BUT A RESORT-LIKE LIFESTYLE!
With almost 3 acres of manicured property, this 5800 sq. ft. timeless home is perfect for entertaining both inside and out. Just 7 years ago, the owners spent $300,000 creating a spectacular landscape complete with pool, spa,outdoor kitchen , pavilion ,play ground and serine pond with fish and waterfall. Located in a prestigious neighborhood with multi-million dollar estates, this home , at this substantially reduced price represents great value! Please arrange for a private showing of this immaculate home.

Last Agent to Sell the Property

Dana Miller

Heritage House Sotheby's International Realty License #0120237 Listed on: 06/10/2017

Heritage House Sotheby's International Realty

Last Buyer's Agent

Dana Miller

Weichert Realtors-Rumson

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $27,474

Year Built

  • Built in 1997

Lot Details

  • 2.8 Acre Lot
  • Home fronts a stream
  • Cul-De-Sac
  • Fenced
  • Backs to Trees or Woods

Parking

  • 3 Car Attached Garage
  • Workshop in Garage
  • Garage Door Opener
  • Circular Driveway
  • On-Street Parking
  • Off-Street Parking

Home Design

  • Contemporary Architecture
  • Brick Exterior Construction
  • Shingle Roof

Interior Spaces

  • 5,800 Sq Ft Home
  • 2-Story Property
  • Built-In Features
  • Crown Molding
  • Tray Ceiling
  • Ceiling height of 9 feet on the main level
  • Ceiling Fan
  • Recessed Lighting
  • Light Fixtures
  • Gas Fireplace
  • French Doors
  • Mud Room
  • Entrance Foyer
  • Great Room
  • Sitting Room
  • Sunken Living Room
  • Dining Room
  • Home Office
  • Recreation Room
  • Sun or Florida Room
  • Indoor Spa
  • Center Hall
  • Attic Fan
  • Home Security System
  • Laundry Room

Kitchen

  • Breakfast Area or Nook
  • Eat-In Kitchen
  • Breakfast Bar
  • Butlers Pantry
  • Built-In Double Oven
  • Portable Range
  • Freezer
  • Dishwasher
  • Kitchen Island
  • Granite Countertops

Flooring

  • Wood
  • Wall to Wall Carpet
  • Marble
  • Ceramic Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Primary bedroom located on second floor
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • Maid or Guest Quarters
  • In-Law or Guest Suite
  • Bidet
  • Dual Vanity Sinks in Primary Bathroom
  • Whirlpool Bathtub
  • Primary Bathroom includes a Walk-In Shower

Basement

  • Heated Basement
  • Basement Fills Entire Space Under The House
  • Recreation or Family Area in Basement

Pool

  • Heated In Ground Pool
  • Outdoor Pool
  • Pool Equipment Stays

Outdoor Features

  • Pond
  • Stream or River on Lot
  • Balcony
  • Patio
  • Terrace
  • Exterior Lighting
  • Gazebo
  • Shed
  • Outdoor Grill

Schools

  • Conover Road Elementary School
  • Cedar Drive Middle School
  • Colts Neck High School

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Heating System Uses Natural Gas
  • Well
  • Natural Gas Water Heater
  • Septic Tank
  • Septic System

Listing and Financial Details

  • Exclusions: Washer, Dryer, Select Window Treatments
  • Assessor Parcel Number 10-00051-0000-00002-28

Community Details

Overview

  • No Home Owners Association
  • Due Process Subdivision
  • Stream

Recreation

  • Recreational Area

Home Details

Home Type

Single Family

Est. Annual Taxes

$27,474

Year Built

Built in 1997

Lot Details

0

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • ResoLotFeatures: See Remarks, Other, Back to Woods, Cul-De-Sac, Fenced Area, Pond, Stream, Treed Lots
  • ResoPoolFeatures: Heated, In Ground, Pool Equipment
  • Inclusions: Outdoor Lighting, Wall Oven, Ceiling Fan(s), Counter Top Range, Dishwasher, Double Oven, Light Fixtures, Security System, Refrigerator, Attic Fan, Freezer, Garage Door Opener
  • Subdivision Name: Due Process
  • Architectural Style: Contemporary
  • Reso Flooring: Ceramic Tile, Marble, W/W Carpet
  • Reso Interior Features: Ceilings - 9Ft+ 1st Flr, Ceilings - 9Ft+ 2nd Flr, Center Hall, Dec Molding, French Doors, Hot Tub, Housekeeper Qtrs, In-Law Suite, Security System, Breakfast Bar, Recessed Lighting
  • New Construction: No
  • Year Built: 1997
  • Contract Info List PriceSqFt: 275.86
  • Contract Info New Construction: No
  • General Property Info Waterview: No
  • General Property Info Fireplace: Yes
  • General Property Info Basement: Yes
  • General Property Info HOA: No
  • General Property Info Pool: Yes
  • Interior Ceilings - 9Ft 1st Flr: Yes
  • Kitchen Center Island: Yes
  • Exterior Balcony2: Yes
  • ExteriorPatio: Yes
  • Exterior Swimming: Yes
  • Pool Heated3: Yes
  • Exterior Terrace: Yes
  • General Property Info Acreage: 2.8
  • General Property Info Farm: No
  • Location Middle School: Cedar Drive
  • Living Room Floor - Wood2: Yes
  • Dining Room Floor - Wood3: Yes
  • WaterSewer Well: Yes
  • Cooling Central Air: Yes
  • ExteriorFence: Yes
  • Exterior Storage: Yes
  • Roof Shingled: Yes
  • Rooms Laundry: Yes
  • Rooms Living Room: Yes
  • Lot Description Back to Woods: Yes
  • Lot Description Fenced Area: Yes
  • Lot Description Treed Lots: Yes
  • Floors Ceramic Tile: Yes
  • Water Heater Natural Gas2: Yes
  • Exterior Lighting: Yes
  • Exterior Shed: Yes
  • Parking Asphalt: Yes
  • General Property Info Handicap Access: No
  • General Property Info # Fireplaces: 1.0
  • Interior Ceilings - 9Ft 2nd Flr: Yes
  • Interior Dec Molding: Yes
  • Interior French Doors: Yes
  • Interior Recessed Lighting: Yes
  • Foyer Two Story: Yes
  • Included Light Fixtures: Yes
  • Included Ceiling Fan(s): Yes
  • Included Outdoor Lighting: Yes
  • Kitchen Floor - Ceramic4: Yes
  • Dining Room Dec Molding4: Yes
  • Kitchen GraniteStone Counter: Yes
  • GreatFamily Room Floor - Wood5: Yes
  • SidingBrick: Yes
  • Pool Pool Equipment: Yes
  • Kitchen Breakfast Cntr: Yes
  • Interior In-Law Suite: Yes
  • Included Double Oven: Yes
  • Kitchen BnookDining Area: Yes
  • Kitchen Eat-In: Yes
  • Basement Heated: Yes
  • Rooms Sitting: Yes
  • Lot Description Cul-De-Sac: Yes
  • Included Security System2: Yes
  • Kitchen Butler Pantry: Yes
  • Exterior BBQ: Yes
  • GreatFamily Room Fireplace - Gas4: Yes
  • GreatFamily Room Floor - WW Carpet4: Yes
  • Exterior Gazebo: Yes
  • Cooling Multi Units: Yes
  • Included Attic Fan: Yes
  • Included Counter Top Range: Yes
  • Living Room Built-Ins2: Yes
  • Exterior Rec Area: Yes
  • Rooms Mud: Yes
  • Mud Level First11: Yes
  • Foyer Floor - Marble: Yes
  • Lot Description Pond2: Yes
  • Floors Marble: Yes
  • Rec Room Level Basement9: Yes
  • Interior Hot Tub: Yes
  • Interior Housekeeper Qtrs: Yes
  • Parking Circular Driveway: Yes
  • GreatFamily Room Sunken3: Yes
  • Garage Workshop Workbench2: Yes
  • Lot Description Stream2: Yes
  • Water Type Stream: Yes
  • Cooling 3 Zoned AC: Yes
  • Heating 3 Zoned Heat: Yes
  • Special Features: VirtualTour

Interior Features

  • Basement: Ceilings - High, Full Finished, Heated
  • Basement: Yes
  • Full Bathrooms: 5
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Stories: 2
  • Other Rooms:Dining Room: Yes
  • Appliances Included:Dishwasher: Yes
  • Appliances Included:Refrigerator: Yes
  • Other Rooms:Sunroom: Yes
  • Other Rooms:Foyer: Yes
  • Kitchen Pantry: Yes
  • Features Interior:Security System: Yes
  • Appliances Included:Wall Oven: Yes
  • Other Rooms:Great Room: Yes
  • Other Rooms:Office2: Yes
  • Appliances Included:Freezer: Yes
  • Other Rooms:Rec Room: Yes
  • Primary Bedroom:Floor - WW Carpet3: Yes
  • Primary Bedroom Level:Second43: Yes
  • Primary Bedroom:Full Bath: Yes
  • Primary Bath:Floor - Ceramic7: Yes
  • Primary Bath:Shower Stall: Yes
  • Primary Bedroom:TRYVLTCATH3: Yes
  • Primary Bedroom:Walk-in Closet: Yes
  • Primary Bath Double Sinks: Yes
  • Primary Bath Whirlpool: Yes
  • Primary Bath Bidet: Yes

Exterior Features

  • Roof: Shingle
  • Acres: 2.8
  • Waterfront Features: Stream
  • Waterfront: No
  • Exclusions: Washer, Dryer, Select Window Treatments
  • Construction Type: Brick
  • Exterior Features: Balcony, BBQ, Fence, Gazebo, Patio, Rec Area, Shed, Storage, Swimming, Terrace, Other, Lighting
  • Exterior Features:Pool-In Ground: Yes

Garage/Parking

  • Garage: Yes
  • Attached Garage: Yes
  • Garage Spaces: 3.0
  • Parking Features: Circular Driveway, Asphalt, Driveway, Off Street, On Street, Workshop in Garage
  • General Property Info:Garage: Yes
  • ParkingOffStreet: Yes
  • Parking Driveway: Yes
  • Parking:On Street: Yes
  • _pound_ AppliancesIncluded:Garage Door Opener: Yes

Utilities

  • Sewer: Septic Tank
  • Cooling: Multi Units, Central Air, 3+ Zoned AC
  • Cooling Y N: Yes
  • Heating: Natural Gas, Forced Air, 3+ Zoned Heat
  • HeatingYN: Yes
  • Water Source: Well
  • Heating:Natural Gas: Yes
  • Water/Sewer/Septic: Yes
  • Heating:Forced Air: Yes

Condo/Co-op/Association

  • Senior Community: No
  • Association: No

Schools

  • Middle Or Junior School: Cedar Drive

Lot Info

  • Lot Size Sq Ft: 121968.0
  • Parcel #: 10-00051-0000-00002-28
  • Zoning Description: Residential, Single Family

Tax Info

  • Tax Year: 2016
  • Tax Annual Amount: 27474.0

MLS Schools

  • Elementary School: Conover Road
  • High School: Colts Neck

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 10, 2017
Closed on
Oct 2, 2017
Sold by
Keusch Ronald W and Keusch Audrey R
Bought by
Gill Jasrai Singh and Hundle Rameet Kaur
Seller's Agent
Dana Miller
Heritage House Sotheby's International Realty
Buyer's Agent
Dana Miller
Heritage House Sotheby's International Realty
Sold Price
$1,500,000
Current Estimated Value
$2,622,152

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$1,122,152
Avg. Annual Appreciation
7.12%
Original Mortgage
$1,200,000
Outstanding Balance
$1,001,261
Interest Rate
3.78%
Mortgage Type
New Conventional
Estimated Equity
$1,620,891

Purchase Details

Closed on
Sep 12, 1996
Sold by
Pegasus Properties
Bought by
Keusch Ronald and Keusch Audrey

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$580,000
Interest Rate
7.89%
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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
Gill Jasrai Singh $1,500,000 Scott Title Services Llc
Keusch Ronald $270,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Gill Jasrai Singh $1,200,000
Previous Owner Keusch Ronald $580,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
10/10/2017 10/10/17 Sold $1,500,000 -- $259 / Sq Ft
Source: MOREMLS (Monmouth Ocean Regional REALTORS®)

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 $30,488 $2,273,100 $1,013,400 $1,259,700
2024 $28,676 $2,046,200 $863,000 $1,183,200
2023 $28,676 $1,842,900 $638,000 $1,204,900
2022 $25,851 $1,687,700 $565,200 $1,122,500
2021 $26,241 $1,480,600 $415,200 $1,065,400
2020 $26,241 $1,487,600 $460,200 $1,027,400
2019 $26,450 $1,502,000 $495,200 $1,006,800
2018 $26,625 $1,500,000 $675,200 $824,800
2017 $27,110 $1,532,500 $675,200 $857,300
2016 $27,474 $1,587,200 $725,200 $862,000
2015 $26,979 $1,555,000 $725,200 $829,800
2014 $28,456 $1,686,800 $950,400 $736,400
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: MOREMLS (Monmouth Ocean Regional REALTORS®)

MLS Number: 21703519

MOREMLS (Monmouth Ocean Regional REALTORS®)

APN: 10-00051-0000-00002-28