Back to Search

Rotterdam Two-Family Home

2259 Hamburg Street Schenectady, NY 12303

2259 Hamburg Street, Schenectady, NY, 12303

$279,900

For Sale

$279,900

Move-in ready two-family home in Rotterdam with strong rental income.

Property Size2,244 SF

Price / SF$124.73

AddedMay 11

Days on Market67

Last RefreshJul 15 at 3:09 pm

Property Features for 2259 Hamburg Street

General Information

Standard status: Active
Size: 2,244 SF
Property subtype: Multi Family / Duplex

Building Details

Year Built: 1920

Listing office Berkshire Hathaway Home Services Blake

Listing date May 11, 2026

Source Compass

Displayed information is deemed reliable but is not guaranteed and should be independently verified.

All listing content including descriptions, pricing, images are the copyrighted material of Berkshire Hathaway Home Services Blake

Investment Insights

Based on property information with market context.

This two-family home in Rotterdam presents an opportunity for investment or owner-occupancy. The property is move-in ready and well-maintained, offering flexibility and space. Each unit features three bedrooms, a full bathroom, a bright living room, and an eat-in dining area/kitchen. Appliances are included. Replacement windows have been installed on the second floor, and the furnaces are newer. Washer-dryer hookups are located in the basement. The property is suitable for those looking to live in one unit and rent out the other, or to expand an investment portfolio. It offers convenience to shopping and restaurants, with easy access to highways. The property features strong rental income. The property size is 2244 square feet.

Key Highlights

Two‑family home ideal for owner‑occupancy with rental income potential or investment portfolio addition.
Each unit features three bedrooms, a full bathroom, living room, and eat‑in kitchen.
Move‑in ready condition with appliances included.

Local Financial Insights For Multifamily LT 5

Simulate Cap Rate and NOI

NOI Build-Up

Component	$	$/SF
Gross rent	$39.0k	$17.40
− Vacancy	−$2.5k	−$1.13
EGI	$36.5k	$16.27
− OpEx	−$11.0k	−$4.88
NOI	$25.6k	$11.39

2,244 SF · lease $17.40/SF/yr · vacancy 6.50% · expense 30.00%

Alternative Uses

Best Use

Multifamily LT 5

$365.1K

$319.4K – $425.9K (±1% cap)

NOI $25,555 @ 7.0% cap · market cap 9.13%

Second Best

Apartment 5plus

$327.5K

$286.5K – $382.0K (±1% cap)

NOI $22,922 @ 7.0% cap · market cap 8.19%

Theoretical Best

Office A

$671.7K

$587.7K – $783.6K (±1% cap)

NOI $47,016 @ 7.0% cap · market cap 16.80%

Zoning and permitted uses should be independently verified with local authorities.

Property Analytics

Property Profile Location Intelligence

Current Use by Public Records

Duplexes

Suggested Use

Similar For Sale Nearby

$3,000,000

45,322 SF

Downtown Office Building with Parking

Office building on four parcels with elevator access and parking, zoned for a wide range of commercial uses.

214 State Street, Schenectady, NY 12305

View Details
$500,000

2,944 SF

Three-Family Residential Income Property

Three-family home with an owner unit plus 2-bedroom and 1-bedroom apartments, including a partially finished garden-level basement.

2187 Central Avenue, Schenectady, NY 12304

View Details
$350,000

2,580 SF

Turnkey Auto Body Repair Shop

Auto body repair shop with office, near highways and businesses.

814 Broadway, Schenectady, NY 12305

View Details
$349,999

2,706 SF

Mixed-Use Property with Office Suite

Well-maintained mixed-use building with a private main-level office and an updated two-bedroom apartment above.

1603 Union Street, Schenectady, NY 12309

View Details
$675,000

3,833 SF

Storefront and Office Property

Well-situated Schenectady property with flexible space suited to office, retail, or service uses.

2855 Aqueduct Road, Schenectady, NY 12309

View Details
$349,999

2,585 SF

Mixed-Use Two-Family with Office

Two-family property with a first-floor professional office suite and a move-in ready owner unit upstairs.

1603 Union Street, Schenectady, NY 12309

View Details
$2,100,000

11,000 SF

Turnkey Townhome Portfolio for Sale

Eight turnkey townhomes on one lot, each with private garage parking and in-unit washer/dryer.

1001-1015 Barrett St, Schenectady, NY 12305

View Details
$950,000

2,368 SF

Turnkey Restaurant and Bar

Fully equipped restaurant and bar with kitchen, restrooms, basement, and off-street parking, plus patio seating.

1490 State Street, Schenectady, NY 12304

View Details
$400,000

2,700 SF

Automotive Service Parcel with Yard

Commercial parcel with yard area suited for fleet operations, automotive service, or light industrial use.

440 Peek Street, Schenectady, NY 12308

View Details
$199,000

4,481 SF

Medical Office Condominium Unit

Office condominium in the Nott Street Medical Arts building with exam rooms, private offices, and two private garage spaces.

1201 Nott Street, Schenectady, NY 12308

View Details
$225,000

1,677 SF

Two-Story Office Building For Sale

Two-story office building with salon and office space for sale.

162 Lafayette Street, Schenectady, NY 12305

View Details
$284,000

4,450 SF

Versatile Commercial/Mixed-Use Building

Two-story, 4,450+/- SF commercial building with flexible layout.

518 Hegeman Street, Schenectady, NY 12306

View Details

For sale
Duplexes
NY
Schenectady
12303
2259 Hamburg Street

What type of property is this?

Duplex - Move-in ready two-family home in Rotterdam with strong rental income.

Where is this duplex located?

The property is located at 2259 Hamburg Street Schenectady, NY.

What is the asking price?

The asking price for this property is $279,900.

What are key features of this property?

This property features: Two‑family home ideal for owner‑occupancy with rental income potential or investment portfolio addition.; Each unit features three bedrooms, a full bathroom, living room, and eat‑in kitchen.; Move‑in ready condition with appliances included.