174 Main St, Unit 2

$1,700
Price
2
Beds
2,000 Sq. Ft.
$10 / Sq. Ft.
2,000
Sq. Ft.
$10
per Sq. Ft.

Description

Second-floor apartment in a prime Altamont location. Recently renovated with new flooring, fresh paint, and brand-new appliances and windows (arriving soon). Features 2 bedrooms plus an office, 1 bathroom, and in-unit washer/dryer. Close to shops, dining, parks, and just minutes to Albany. New photos will be added as updating continues.Second-floor apartment in a prime Altamont location. Recently renovated with new flooring, fresh paint, and brand-new appliances and windows (arriving soon). Features 2 bedrooms plus an office, 1 bathroom, and in-unit washer/dryer. Close to shops, dining, parks, and just minutes to Albany. New photos will be added as updating continues.
  1. Listed by Matthew G Zelezniak • Saratoga Spa Realty
    P: (518)-727-9107 kasandrarealtor@gmail.com

Property Details for 174 Main Street, Unit 2

Architectural Style
2nd Floor Apartment
Waterfront
No
Parking Total
2.00
LISTING UPDATED: 11/12/2025 10:30 AM

Property Details for 174 Main Street, Unit 2

StatusClosed
MLS #202523895
Days on Market1
Rental Incentives-
Available Date09/15/2025
Lease Term12 Months
Furnished-
Compass TypeRental
MLS TypeResidential Lease / Multi Family
Year Built1890
Lot Size0.32 AC / 13,939 SF
CountyAlbany County

Location

Listing Courtesy of Saratoga Spa Realty
Add your commute

Building Information for 174 Main Street, Unit 2

Building/Complex174 Main StFloor-Stories-Residences-Pet Policy-Pet Policy DetailsYesYear Built1890Building Size-

Property Information for 174 Main Street, Unit 2

Summary
Location and General Information
  • Postal City: Altamont
  • Directions: Drive on NY-146 W in Altamont for 2 miles property will be on your right.
  • City: Altamont
  • State Or Province: NY
  • Postal Code: 12009
  • County Or Parish: Albany
  • Latitude: 42.70
  • Longitude: -74.03
Taxes and HOA
  • Association Fee: $.00
  • Association: No
  • Parcel Number: 013001 37.18-4-18.2
Parking
  • GarageSpaces: .00
  • Attached Garage: No
  • Parking Features: Off Street
School Information
  • School District: Guilderland
  • High School: Guilderland
Property
Property and Assessments
  • Property Type: Residential Lease
  • Property Type Label: Residential Lease
Lot Information
  • Year Built: 1890
  • Above Grade Finished Area: 2000.0
  • Above Grade Finished Area Source: Public Records
  • Below Grade Finished Area: 2000.0
  • Below Grade Finished Area Source: Public Records
  • Year Established: 2
  • Lot Size Acres: 0.32
  • Lot Size Area: 0.32
  • Lot Size Units: Acres
  • Lot Size Square Feet: 13939.2
Building Information
  • Living Area: 2000.0
Utilities
  • Utilities: Cable Available, Cable Connected
  • Separate Utilities : Gas: Yes
Interior and Exterior Features
Exterior Features
  • Patio And Porch Features: Enclosed, Front Porch, Porch
Interior Features
  • Heating: Baseboard
  • Flooring: Other, Carpet
  • Construction Materials: Vinyl Siding
  • Entry Location: Right side on the front porch
  • Heating: Yes
  • Appliances: Electric Water Heater, Microwave, Range, Refrigerator, Washer/Dryer
  • Dining Room Type : Dining Area: Yes
Room Information
Room Information
  • Rooms Total: 8
  • Room Type: Primary Bedroom, Bedroom, Full Bathroom, Dining Room, Office, Family Room, Kitchen, 3 Seasons Room
Bathrooms
  • Bathrooms Total Integer: 1
  • Bathrooms Total Decimal: 1.00
  • Bathrooms Total Notational: 1.00
  • Bedrooms Total: 2
  • Bathrooms Full: 1
  • Bathrooms Half: 0
Room 1
  • RoomType: Primary Bedroom
  • RoomLevel: Second
Room 2
  • RoomType: Bedroom
  • RoomLevel: Second
Room 3
  • RoomType: Full Bathroom
  • RoomLevel: Second
Room 4
  • RoomType: Dining Room
  • RoomLevel: Second
Room 5
  • RoomType: Office
  • RoomLevel: Second
Room 6
  • RoomType: Family Room
  • RoomLevel: Second
Room 7
  • RoomType: Kitchen
  • RoomLevel: Second
Room 8
  • RoomType: 3 Seasons Room
  • RoomLevel: Second
Unit Information
Unit 1
  • Unit Detail : Kitchen: True
Rental
Rental Information
  • Land Lease: No
  • Tenant Pays: Internet, Trash Collection, Electricity, Gas
  • Owner Pays: Management, Sewer, Snow Removal, Water, Grounds Care
  • Pets Allowed: Yes
  • Pets Allowed : Yes: Yes

Property History for 174 Main Street, Unit 2

DateEvent & SourcePriceAppreciation
Oct 1, 2025

Rented

GLOBAL MLS #202523895

$1,700
Oct 1, 2025

Pending

GLOBAL MLS #202523895

Aug 14, 2025

Price Change

GLOBAL MLS #202523895

$2,000
Aug 14, 2025

Price Change

GLOBAL MLS #202523895

$1,900
Aug 14, 2025

Listed (Active)

GLOBAL MLS #202523895

$1,700
DateEvent & SourcePrice
10/01/2025

Rented

GLOBAL MLS #202523895

$1,700
10/01/2025

Pending

GLOBAL MLS #202523895

08/14/2025

Price Change

GLOBAL MLS #202523895

$2,000
08/14/2025

Price Change

GLOBAL MLS #202523895

$1,900
08/14/2025

Listed (Active)

GLOBAL MLS #202523895

$1,700

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Schools near 174 Main Street, Unit 2

This home is within Guilderland Central School District.
Rating
School
Type
Grades
Distance
Public - K to 5
Public - 6 to 8
Public - 9 to 12
Rating
School
Distance
Altamont Elementary School
PublicK to 5

Farnsworth Middle School
Public6 to 8

Guilderland High School
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the owner. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Saratoga Spa Realty

©2025 Global Multiple Listing Service, Inc. The data relating to real estate on this website comes in part from the Internet Data Exchange program of the GMLS. All information is deemed reliable but not guaranteed and should be independently verified. All properties subject to prior sale, change, or withdrawal. Neither listing broker(s), GMLS shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless from any damages arising from reliance upon these data. IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties they may be interested in purchasing.