174 Main St, 2 | Madison Boro

$4,000 | 2 Beds | 2 Baths (2 Full)

Location! Newer luxury condo with 1238 SF, chic and stylish with stunning millwork, architectural details, quality craftsmanship and beautiful hardwood floors throughout. Windows galore and filled with natural light, this condo is located on the second floor. The living room has a unique curved nook, crown molding and recessed lighting, the kitchen is the highlight with white quartz counters, plenty of cabinets, counter seating with pendant lights, stainless appliances; and a separate eating area, the ensuite bedroom with tray ceiling offers 2 double closets and access to the open porch, the second bedroom has substantial crown molding, double closet, 15 panel glass door to access the open porch in back. The laundry/utility room is on this level as well. The large basement is partially finished, and offers great potential for additional recreational space or abundant storage. Easy commute to NYC, just minutes to the train station (for the mid-town direct) and the quaint downtown with all the restaurants and shops and everything the Rose City has to offer GSMLS 3979482

Directions to property: Main St.

MLS Listing ID: 
GSMLS 3979482
Listing Status
Status of the Listing.
Listing Status: 
Active
Listing Status (Local): 
Active
Listing Status Accepting Offers: 
1
Building Details
Details about the building on a property.
Architectural Style: 
3 or More Stories
Year Built: 
2022
New Construction: 
0
Basement: 
Finished-Partially
Interior: 
Blinds, High Ceilings
Fireplaces: 
No
Construction
Exterior Features: 
Open Porch(es), Sidewalk, Underground Lawn Sprinkler
DisabilityFeatures: 
No
Porch: 
No
Deck: 
No
Room Details
Details about the rooms in the building.
Total Rooms: 
4
Total Bedrooms: 
2
Total Bathrooms: 
2
Total Full-Bathrooms: 
2
Total Half-Bathrooms: 
0
Master Bedroom 
Dimensions: 
18x11 
Level: 
Second
Second Bedroom 
Dimensions: 
14x12 
Level: 
Second
Kitchen 
Dimensions: 
22x12 
Level: 
Second
Living Room 
Dimensions: 
16x14 
Level: 
Second
Utilities
Information about utilities available on the property.
Heating System: 
1 Unit
Heating System Fuel: 
Gas-Natural
Cooling System: 
1 Unit
Water Heating System: 
Gas
Water Source: 
Public Water
Sewer: 
Public Sewer
Lot/Land Details
Details about the lots and land features included on the property.
Acres: 
0.31
Waterfront: 
0
Lot Features
Driveway: 
1 Car Width, Blacktop
Parking Type: 
1 Car Width, Blacktop
Total Parking Spaces: 
2
Pool: 
No
Fence: 
No
Public Record
Parcel Number: 
2317-02001-0000-00018-0000-
Listing Dates
Dates involved in the transaction.
Listing Entry Date/Time: 
8/5/2025
Contract Details
Details about the listing contract.
Inclusions: 
Building Insurance, Maintenance-Building, Taxes
Possession: 
September
Listing Participants
Participants (agents, offices, etc.) in the transaction.
Listing Office Name: 
KELLER WILLIAMS REALTY