NOT LISTED FOR SALE

42 Squire Ln Unit 2109 Athens, NY 12015

Estimated Value: $551,000 - $714,000

3 Beds
4.5 Baths
3,190 Sq Ft
$191/Sq Ft Est. Value

Last Sold March 25, 2024

Last sale price $525,000 $165 Per Sq Ft

Est. 16% increase in value since last sale

Current estimated payment $3,892/month

198 Days on Market

Highlights

  • View of Trees or Woods
  • Deck
  • Great Room
  • 1.37 Acre Lot
  • Contemporary Architecture
  • Community Pool

About This Home

As of March 2024

This newly renovated Custom Ranch is nestled on 1.37 acres, on a quiet side street in the Sleepy Hollow Lake Community. This crafted home features a sprawling floor plan surrounded with fine craftsmanship. Details were done brilliantly throughout with simple clean lines using superior materials, perfect for modern day living. A few of the home features are a spacious open floor plan, full finished basement, new custom kitchen, and the exterior has two porches, porch swing and a huge deck! This property is located only minutes to the town for shopping, and a short drive to Coxsackie, and Catskill, golf courses, restaurants and the NYS Thruway.

Last Agent to Sell the Property

Dave Merchant

Keller Williams Realty HV Nort License #10401290467 Listed on: 08/15/2023

Keller Williams Realty HV Nort

Last Buyer's Agent

Serena Mitchell

Weichert Realtors Fontaine License #10401379304

Weichert Realtors Fontaine

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,954

Year Built

  • Built in 2006

Lot Details

  • 1.37 Acre Lot

HOA Fees

  • $163 Monthly HOA Fees

Property Views

  • Woods
  • Hills
  • Rural
  • Park or Greenbelt
  • Neighborhood

Home Design

  • Contemporary Architecture
  • Ranch Style House
  • Frame Construction
  • Shingle Roof
  • Vinyl Siding
  • Concrete Perimeter Foundation

Interior Spaces

  • Gas Log Fireplace
  • Great Room
  • Living Room with Fireplace
  • Dining Room
  • Den
  • Vinyl Flooring
  • Finished Basement
  • Basement Fills Entire Space Under The House

Bedrooms and Bathrooms

  • 3 Bedrooms

Outdoor Features

  • Deck
  • Shed
  • Porch

Utilities

  • Forced Air Heating System
  • Heating System Uses Natural Gas
  • Gas Water Heater
  • High Speed Internet

Listing and Financial Details

  • Assessor Parcel Number 105.06-2-9

Community Details

Recreation

  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,954

Year Built

Built in 2006

Lot Details

0

HOA Fees

$163 per month

Listing Details

  • Year Built: 2006
  • Property Sub-Type: Single Family Residence
  • Lot Size Acres: 1.37
  • Road Surface Type: Paved
  • View Type:Pond View: Hills, Neighborhood, Park/Greenbelt, Rural, Trees/Woods
  • MLS Status: Closed
  • Architectural Style: Contemporary, Ranch
  • Entry Level: 1856
  • Property Attached Yn: No
  • General Property Information Lot Size Acres: 1.37
  • Electric:Circuit Breakers: Yes
  • Sewer:Public Sewer: Yes
  • Flooring:Vinyl: Yes
  • Other Structures:Shed(s): Yes
  • General Property Information:Bathrooms Half: 1
  • Architectural Style Ranch: Yes
  • Roof:Shingle: Yes
  • Water Source:Public: Yes
  • Architectural Style:Contemporary: Yes
  • Room Types Den2: Yes
  • Room Types Dining Room2: Yes
  • Room Types Living Room2: Yes
  • General Property Information Basement YN: Yes
  • View ParkGreenbelt: Yes
  • View Neighborhood4: Yes
  • View TreesWoods: Yes
  • Room Types Great Room2: Yes
  • Foundation Details Concrete Perimeter: Yes
  • View Rural: Yes
  • View Hills: Yes
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Water Heater, Gas Water Heater
  • Interior Amenities: High Speed Internet
  • Basement: Finished, Full
  • Basement YN: Yes
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Fireplaces: 1
  • Fireplace: Yes
  • Flooring: Vinyl
  • Full Basement: Yes
  • Appliances:Gas Water Heater: Yes
  • Basement Finished: Yes
  • Fireplace Features:Living Room: Yes
  • Pool Features:Community: Yes
  • Interior Features:High Speed Internet: Yes
  • Fireplace Features:Gas Log: Yes

Exterior Features

  • Roof: Shingle
  • Pool Features: Community
  • Construction Type: Frame, Vinyl Siding, Other
  • Foundation Details: Concrete Perimeter
  • Other Structures: Shed(s)
  • Patio And Porch Features: Deck, Porch
  • Construction Materials:Frame: Yes
  • Construction Materials:Other8: Yes
  • Patio And Porch Features:Deck2: Yes
  • Construction Materials:Vinyl Siding: Yes
  • Patio and Porch Features:Porch: Yes

Utilities

  • Sewer: Public Sewer
  • Electric: Circuit Breakers
  • Heating: Forced Air, Natural Gas
  • HeatingYN: Yes
  • Water Source: Public
  • Water Heater: Yes
  • Heating:Forced Air: Yes
  • Heating:Natural Gas: Yes

Condo/Co-op/Association

  • Association Fee: 1960.0
  • Association Fee Frequency: Annually
  • Association: Yes

Association/Amenities

  • General Property Information:Association YN: Yes
  • General Property Information:Association Fee: 1960.0
  • General Property Information:Association Fee Frequency: Annually

Schools

  • Junior High Dist: Coxsackie-Athens

Lot Info

  • Lot Size Sq Ft: 59677.2
  • ResoLotSizeUnits: Acres
  • Parcel Number: 105.06-2-9
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 15, 2023
Closed on
Mar 25, 2024
Sold by
Cruz Carmelo and Cruz Rebecca E
Bought by
Brown Jacqueline and Brown Amalie
Seller's Agent
Dave Merchant
Keller Williams Realty HV Nort
Buyer's Agent
Serena Mitchell
Weichert Realtors Fontaine
List Price
$559,000
Sold Price
$525,000
Premium/Discount to List
-$34,000
-6.08%
Views
202
Current Estimated Value
$609,979

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$84,979
Avg. Annual Appreciation
10.45%

Purchase Details

Listed on
Oct 25, 2019
Closed on
Feb 27, 2020
Sold by
Castle Elwood
Bought by
Cruz Carmelo
Seller's Agent
Dave Merchant
Keller Williams Realty HV Nort
Buyer's Agent
Dave Merchant
Keller Williams Realty HV Nort
List Price
$258,000
Sold Price
$245,000
Premium/Discount to List
-$13,000
-5.04%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
20.54%
Original Mortgage
$245,000
Interest Rate
3.5%
Mortgage Type
New Conventional

Purchase Details

Listed on
Oct 25, 2019
Closed on
Feb 26, 2020
Sold by
Castle Elwood
Bought by
Cruz Carmelo
Seller's Agent
Dave Merchant
Keller Williams Realty HV Nort
Buyer's Agent
Dave Merchant
Keller Williams Realty HV Nort
List Price
$258,000
Sold Price
$245,000
Premium/Discount to List
-$13,000
-5.04%

Home Financials for this Owner

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

Purchase Details

Closed on
Mar 31, 2011
Sold by
Castle Elwood
Bought by
Castle Elwood

Purchase Details

Closed on
Aug 10, 2006
Sold by
Loeb Werner L
Bought by
Castle Elwood D

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$270,000
Interest Rate
6.71%
Mortgage Type
Purchase Money Mortgage
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
Brown Jacqueline $525,000 None Available
Brown Jacqueline $525,000 None Available
Cruz Carmelo $185,000 None Available
Cruz Carmelo $185,000 None Available
Castle Elwood -- Murray Law Firm
Castle Elwood -- Murray Law Firm
Castle Elwood D $51,500 Gregory Mountain
Castle Elwood D $51,500 Gregory Mountain
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Cruz Carmelo $245,000
Previous Owner Cruz Carmelo $245,000
Previous Owner Castle Elwood D $270,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
03/25/2024 03/25/24 Sold $525,000 -6.1% $165 / Sq Ft
02/29/2024 02/29/24 Pending -- -- --
08/15/2023 08/15/23 For Sale $559,000 +128.2% $175 / Sq Ft
02/26/2020 02/26/20 Sold $245,000 -5.0% $132 / Sq Ft View Prior Sale
02/06/2020 02/06/20 Pending -- -- --
10/25/2019 10/25/19 For Sale $258,000 -- $139 / Sq Ft
Source: Hudson Valley Catskills Region Multiple List Service

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 $5,954 $342,000 $33,700 $308,300
2023 $5,324 $342,000 $33,700 $308,300
2022 $7,167 $288,800 $33,700 $255,100
2021 $7,240 $288,800 $33,700 $255,100
2020 $7,285 $288,800 $33,700 $255,100
2019 $6,589 $288,800 $33,700 $255,100
2018 $6,589 $288,800 $33,700 $255,100
2017 $6,653 $288,800 $33,700 $255,100
2016 $6,244 $270,000 $23,700 $246,300
2015 -- $270,000 $23,700 $246,300
2014 -- $270,000 $23,700 $246,300
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Hudson Valley Catskills Region Multiple List Service

MLS Number: 149540

Hudson Valley Catskills Region Multiple List Service

APN: 192289-105-006-0002-009-000-0000