NOT LISTED FOR SALE

154 Maple Ave Altamont, NY 12009

Estimated Value: $449,000 - $808,000

5 Beds
3.5 Baths
2,950 Sq Ft
$202/Sq Ft Est. Value

Last Sold March 19, 2024

Last sale price $516,000 $175 Per Sq Ft

Est. 16% increase in value since last sale

Current estimated payment $3,730/month

4 Days on Market

Highlights

  • Radiant Floor
  • Main Floor Primary Bedroom
  • Solid Surface Countertops
  • Altamont Elementary School Rated 9+
  • Victorian Architecture
  • 1-minute walk to Schilling Park

About This Home

As of March 2024

Incredible opportunity to own this true showpiece of a home. Located in the quaint and charming village of Altamont, this home has been thoughtfully updated from top to bottom. Boasting FIVE bedrooms, 3.5 baths, TWO primary suites plus a bonus play/media room, this home truly has IT ALL! Gourmet kitchen features double wall ovens, pot filler, top of the line appliances with an abundance of counter space complete with stunning coffered ceilings PLUS bonus butler's pantry to store bigger appliances and everything for entertaining! Enjoy your outdoor oasis with the professionally landscaped lot, patio, wrap around front porch with detailed mahogany ceilings and pergola. 2nd floor laundry room, new on demand hot water heater. Multiple offers. Highest & best due by Saturday 2/3 @8pm!

Last Agent to Sell the Property

Leanne Royer

Venture Fox Realty Group LLC License #40RO1163308 Listed on: 01/30/2024

Last Buyer's Agent

Joseph Cardinale

Howard Hanna Capital Inc License #10401290174

Howard Hanna Capital Inc

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,793

Year Built

  • Built in 1880 | Remodeled

Lot Details

  • 0.39 Acre Lot
  • Landscaped
  • Level Lot
  • Front Yard Sprinklers
  • Cleared Lot
  • Garden

Parking

  • 2 Car Detached Garage
  • Driveway

Home Design

  • Victorian Architecture
  • Rubber Roof
  • Wood Siding
  • Asphalt

Interior Spaces

  • 2,950 Sq Ft Home
  • 2-Story Property
  • Built-In Features
  • Chair Railings
  • Crown Molding
  • Paddle Fans
  • Wood Burning Fireplace
  • Plantation Shutters
  • Blinds
  • Rods
  • Entrance Foyer
  • Family Room
  • Living Room
  • Dining Room
  • Den
  • Game Room
  • Basement Fills Entire Space Under The House
  • Attic Fan
  • Home Security System

Kitchen

  • Double Oven
  • Range Hood
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Solid Surface Countertops
  • Trash Compactor

Flooring

  • Wood
  • Carpet
  • Radiant Floor
  • Ceramic Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Primary Bedroom on Main
  • Walk-In Closet
  • Bathroom on Main Level
  • Ceramic Tile in Bathrooms

Laundry

  • Laundry Room
  • Laundry on upper level
  • Washer and Dryer

Outdoor Features

  • Patio
  • Exterior Lighting
  • Pergola
  • Wrap Around Porch

Schools

  • Altamont Elementary School
  • Guilderland High School

Utilities

  • Zoned Heating and Cooling System
  • Heating System Uses Natural Gas
  • Radiant Heating System
  • Baseboard Heating
  • Heating System Uses Steam
  • 200+ Amp Service
  • Tankless Water Heater
  • Water Softener
  • High Speed Internet
  • Cable TV Available

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Legal Lot and Block 40.000 / 4
  • Assessor Parcel Number 013001 37.18-4-40

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,793

Year Built

Built in 1880 | Remodeled

Lot Details

0.39 Acres

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Year Built: 1880
  • Directions: Take Route 20/Western Ave into the village of Altamont. Take a right on Lincoln Ave to left on Jay Street. Driveway for 154 Maple is on Jay Street. Last driveway/house on right. Additional parking on Maple Ave across from house or in Altamont Reformed church parking lot on Jay Street.
  • Above Grade Finished Sq Ft: 2950.0
  • Architectural Style: Victorian
  • Financial Details General Taxes: 1245.0
  • General Taxes Description: Actual
  • Financial Details School Taxes: 5904.0
  • School Taxes Description: Actual
  • Financial Details Village Taxes: 644.0
  • Village Taxes Description: Actual
  • Lot Size Acres: 0.39
  • New Construction: No
  • Parking Features Parking Total: 2.0
  • Full Bathroom Level: Second
  • Half Bathroom Level: First
  • Laundry Room Level: Second
  • Other Room Level: First
  • Primary Bathrooms Level: First
  • Primary Bedroom Level: First
  • Sale Detail Seller Contribution: No
  • Special Listing Conditions Ownership: Agent is owner
  • Ownership: Agent is owner
  • Garage Yn: Yes
  • Appliances Refrigerators: Yes
  • Flooring:Carpet: Yes
  • Flooring:Hardwood: Yes
  • Laundry Features:Upper Level: Yes
  • Cooling:Central Air: Yes
  • Appliances Microwave: Yes
  • Flooring:Ceramic Tile: Yes
  • Architectural Style:Victorian: Yes
  • Water Softeners: Yes
  • Levels Two: Yes
  • Directions Remarks: Agent to Agent Remarks: MULTIPLE OFFERS. HIGHEST AND BEST DUE BY SATURDAY FEBRUARY 3RD AT 8PM. DECISION WILL BE MADE BY SUNDAY AT 11AM Listing agent is owner Central air is only only 1st floor Huge attic for storage above detached garage Village of Altamont pays water and sewer 2x a year Contingent upon sellers closing on new house currently under contract. Target close early to mid March Driveway is on Jay Street
  • Directions Remarks: Public Remarks: Incredible opportunity to own this true showpiece of a home. Located in the quaint and charming village of Altamont, this home has been thoughtfully updated from top to bottom. Boasting FIVE bedrooms, 3.5 baths, TWO primary suites plus a bonus play/media room, this home truly has IT ALL! Gourmet kitchen features double wall ovens, pot filler, top of the line appliances with an abundance of counter space complete with stunning coffered ceilings PLUS bonus butler's pantry to store bigger appliances and everything for entertaining! Enjoy your outdoor oasis with the professionally landscaped lot, patio, wrap around front porch with detailed mahogany ceilings and pergola. 2nd floor laundry room, new on demand hot water heater. Multiple offers. Highest & best due by Saturday 2/3 @8pm!
  • Special Features: None

Interior Features

  • Flooring: Carpet, Ceramic Tile, Hardwood
  • Basement: Full
  • Interior Amenities: High Speed Internet, Paddle Fan, Solid Surface Counters, Walk-In Closet(s), Ceramic Tile Bath, Chair Rail, Crown Molding, Kitchen Island, Built-in Features
  • Appliances: Dishwasher, Double Oven, Microwave, Range Hood, Refrigerator, Tankless Water Heater, Trash Compactor, Washer/Dryer, Water Softener
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Fireplace Features: Wood Burning
  • Fireplaces: 1
  • Living Area: 2950.0
  • Bedroom Level: Second
  • Den Level: First
  • Dining Room Level: First
  • Family Room Level: First
  • Foyer Level: First
  • Game Room Level: Second
  • Kitchen Level: First
  • Living Room Level: First
  • Window Features: Plantation Shutters, Blinds, Curtain Rods
  • Bathroom Levels Full Bathroom 1: 1st
  • Bathroom Levels Full Bathroom 2: 2nd
  • Bathroom Levels Full Bathroom 3: 2nd
  • Bathroom Levels Half Bathroom 1: 1st
  • Fireplace: Yes
  • Appliances Dishwasher: Yes
  • Fireplace Features:Wood Burning: Yes
  • Interior Features:High Speed Internet: Yes
  • Interior Features:Paddle Fan: Yes
  • Full Basement: Yes
  • Appliances:Range Hood: Yes
  • Appliances:WasherDryer: Yes
  • Interior Features:Walk-In Closet(s): Yes
  • Kitchen Features:Kitchen Island: Yes
  • Interior Features:Ceramic Tile Bath: Yes
  • Interior Features:Solid Surface Counters: Yes
  • Attic Features:None16: Yes
  • Interior Features:Chair Rail: Yes
  • Interior Features:Crown Molding: Yes
  • Appliances:Trash Compactor: Yes
  • Appliances:Tankless Water Heater: Yes
  • Kitchen Features:Built-in Features2: Yes
  • Kitchen Features:Gourmet Kitchen: Yes
  • Appliances:Double Oven: Yes

Exterior Features

  • Exterior Features: Drive-Paved, Lighting
  • Roof: Rubber, Asphalt
  • Construction Type: Wood Siding
  • Other Structures: Pergola
  • Patio And Porch Features: Wrap Around, Patio, Porch
  • Waterfront: No
  • Property Condition: Updated/Remodeled
  • Construction Materials:Wood Siding: Yes
  • Patio And Porch Features:Porch: Yes
  • Exterior Features:Drive-Paved: Yes
  • Patio And Porch Features:Patio: Yes
  • Lot Features:Landscaped: Yes
  • Window Features:Curtain Rods: Yes
  • Lot Features:Level: Yes
  • Window Features:Blinds: Yes
  • Lot Features:Cleared: Yes
  • Lot Features:Sprinklers In Front: Yes
  • Exterior Features:Lighting: Yes
  • Lot Features:Garden2: Yes
  • Patio And Porch Features:Wrap Around: Yes
  • Window Features:Plantation Shutters: Yes

Garage/Parking

  • Garage Spaces: 2.0
  • Parking Features: Paved, Detached, Driveway
  • Attached Garage: No
  • Total Parking Spaces: 2.0
  • Property Detail:Garage Spaces: 2.0
  • Property Detail:Parking YN: Yes
  • Parking Features:Driveway: Yes
  • Parking Features:Paved: Yes
  • Parking Features:Garage: Yes
  • Parking Features:Detached: Yes

Utilities

  • Utilities: Cable Connected
  • Sewer: Public Sewer
  • Cooling: Attic Fan, Central Air
  • Electric: 200+ Amp Service
  • Heating: Baseboard, Natural Gas, Radiant, Radiant Floor, Steam, Zoned
  • Laundry Features: Laundry Room, Upper Level
  • Security: Security System
  • Water Source: Public
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Heating:Baseboard: Yes
  • Heating:Natural Gas: Yes
  • Heating:Radiant: Yes
  • Heating:Steam: Yes
  • Heating:Zoned: Yes
  • Heating:Radiant Floor: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Parcel Tax HOA:Association YN: No

Schools

  • Junior High Dist: Guilderland

Lot Info

  • Lot Features: Level, Sprinklers In Front, Cleared, Garden, Landscaped
  • Parcel #: 013001 37.18-4-40
  • Lot Size Sq Ft: 16988.4

Tax Info

  • Tax Annual Amount: 7793.0
  • Tax Block: 4
  • Tax Lot: 40.000

MLS Schools

  • Elementary School: Altamont
  • HighSchool: Guilderland

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 30, 2024
Closed on
Mar 19, 2024
Sold by
Royer Jeremy and Royer Leanne
Bought by
Freund Robert and Freund Tiffany
Seller's Agent
Leanne Royer
Venture Fox Realty Group LLC
Buyer's Agent
Joseph Cardinale
Howard Hanna Capital Inc
List Price
$424,900
Sold Price
$516,000
Premium/Discount to List
$91,100
21.44%
Views
78
Current Estimated Value
$596,477

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$80,477
Avg. Annual Appreciation
7.72%
Original Mortgage
$485,450
Outstanding Balance
$475,968
Interest Rate
6.64%
Mortgage Type
New Conventional
Estimated Equity
$120,509
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
Freund Robert $1,205,000 Marathon Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Freund Robert $485,450
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
03/19/2024 03/19/24 Sold $516,000 +21.4% $175 / Sq Ft
02/04/2024 02/04/24 Pending -- -- --
01/30/2024 01/30/24 For Sale $424,900 -- $144 / Sq Ft
Source: Global MLS

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 $7,992 $301,000 $60,000 $241,000
2023 $7,759 $301,000 $60,000 $241,000
2022 $6,998 $301,000 $60,000 $241,000
2021 $6,732 $301,000 $60,000 $241,000
2020 $7,223 $301,000 $60,000 $241,000
2019 $7,098 $301,000 $60,000 $241,000
2018 $5,235 $215,000 $43,000 $172,000
2017 $0 $215,000 $43,000 $172,000
2016 $5,522 $215,000 $43,000 $172,000
2015 -- $215,000 $43,000 $172,000
2014 -- $215,000 $43,000 $172,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Global MLS

MLS Number: 202411275

Global MLS

APN: 013001-037-018-0004-040-000-0000

Your Personal Tour Guide

Ask me questions while you tour the home.