HOMESFARMSANDLAND
BuySell
    • Featured Properties
    • Property Showcases
    • Latest Blogs
      • Overview
      • Explore Open Houses
      • Discover Rental Living
      • Escape to Cabin Life
      • Unlock Multi-Family Living
      • Your Perfect Land Awaits
      • Embrace Farm Life
      • Overview
      • Find Rentals
      • Find Cabins
      • Browse Homes
      • Browse Farms
      • Browse Lands
    • Saved Properties
    • Overview
    • Buying Form
    • Buying Process
    • Mortgage Calculator
    • Overview
    • Selling Form
    • Selling Process
    • Free Home Evaluation
      • All of Otsego
      • Cooperstown
      • Oneonta
      • West Oneonta
      • Milford
      • Hartwick
      • Worcester
      • Unadilla
      • Laurens
      • Richfield Springs
      • All of Schoharie
      • Cobleskill
      • Middleburgh
      • Schoharie
      • Sharon Springs
      • Summit
      • Richmondville
      • Esperance
      • All of Chenango
      • Norwich
      • Oxford
      • Greene
      • Bainbridge
      • Sherburne
      • All of Delaware
      • Delhi
      • Stamford
      • Andes
      • Walton
      • Margaretville
      • Roxbury
      • Sidney
      • All of Greene
      • Catskill
      • Windham
      • Hunter
      • Cairo
      • Coxsackie
      • Athens
      • All of Broome
      • Binghamton
      • Vestal
      • Endicott
      • All of Oneida
      • New Hartford
      • Utica
      • Marcy
      • Clinton
      • All of Montgomery
      • Amsterdam
      • Fort Plain
      • Canajoharie
      • Fonda
      • All of Ulster
      • Kingston
      • New Paltz
      • Saugerties
      • Woodstock
      • Marlborough
    • Overview
    • Free Vendor List
    • Practical Guides
    • Need Funding?
    • Property Inspector
    • Down Payment Eligibility
    • Location Sharing?
      • Overview
      • Standard Operating Procedure
      • NYS Buyer-Seller
      • NYS Landlord-Tenant
      • Tenant Rights Notice
      • Fair Housing Notice
      • Privacy Policy
      • Location Services
      • Properties Preferences
      • Map Data Attribution
    • Who We Are
    • Meet the Team
Featured
Featured Properties
Property Showcases
Latest Blogs
Search
Advanced Search
Explore Open Houses
Discover Rental Living
Escape to Cabin Life
Unlock Multi-Family Living
Your Perfect Land Awaits
Embrace Farm Life
Search by Map
Find Rentals
Find Cabins
Browse Homes
Browse Farms
Browse Lands
Saved Properties
Buy
Buying Form
Buying Process
Mortgage Calculator
Sell
Selling Form
Selling Process
Free Home Evaluation
HOMESFARMSANDLAND
  • Otsego
  • Schoharie
  • Chenango
  • Delaware
  • Greene
  • Broome
  • Oneida
  • Montgomery
  • Ulster

Select a county to see cities

Resources
Free Vendor List
Practical Guides
Need Funding?
Property Inspector
Down Payment Eligibility
Location Sharing?
Disclosures
Standard Operating Procedure
NYS Buyer-Seller
NYS Landlord-Tenant
Tenant Rights Notice
Fair Housing Notice
Privacy Policy
Location Services
Properties Preferences
Map Data Attribution
About
Who We Are
Meet the Team

Let's Find Your Next Property.

HOMESFARMSANDLAND.COM

Kevin Lucero

Lic. Real Estate Salesperson

a Charlotteville Realty Team

Independently Owned & Operated

607-282-6242kevin@homesfarmsandland.com

Buying

  • Buying Form
  • Buying Process
  • Mortgage Calculator

Selling

  • Selling Form
  • Selling Process
  • Free Home Evaluation

About Us

  • Who We are
  • Meet the Team

Resources

  • Latest Blogs
  • Free Vendor List
  • PracticalGuides
  • Need Funding?
  • Property Inspector
  • Down Payment Eligibility

Communities

  • Otsego County
  • Schoharie County
  • Chenango County
  • Delaware County
  • Greene County
  • Broome County
  • Oneida County
  • Montgomery County
  • Ulster County

Disclosures

  • Standard Operating Procedure
  • NYS Buyer-Seller
  • NYS Landlord-Tenant
  • Tenant Rights Notice
  • Fair Housing Notice
  • Privacy Policy
  • Location Services
  • Properties Preferences
  • Map Data Attribution

© 2026 Homes, Farms & Land. All rights reserved.

Property at 36-38 Riverview Drive, Rotterdam, NY 12150
IN ESCROW
0
$399,900

36-38 Riverview DriveRotterdam, NY, 12150

4 Beds3 Baths2,400 SqFt0.27 Acres
Beautifully updated side-by-side duplex overlooking the Mohawk River. This spacious property offers two bright and inviting 2-bedroom apartments, each with just over 1,000 sq ft of comfortable living space. The main level of each unit has been fully remodeled, featuring a modern kitchen with bar seating, brand-new stainless steel appliances, a generous living room, and a stylish updated half bath. Upstairs, each apartment includes two well-sized bedrooms and an updated full bathroom. Both units also come with their own private basement--complete with a washer and dryer. Brand-new garage doors have been installed on the 2-car garage with additional off-street parking available on the recently repaved driveway. Enjoy a spacious backyard with tranquil views of the Mohawk River and surrounding mountains, all set in a peaceful Upstate NY location. The home has been thoughtfully maintained and upgraded, featuring new energy-efficient windows, a 2-year-old asphalt shingle roof, and new high-efficiency hot water heaters installed in 2024 and 2025. New septic installed in '26. Whether you're looking to enjoy one unit as an owner-occupant or seeking a turnkey investment property, this duplex offers outstanding flexibility and immediate income potential. No flood insurance required.
1 / 39

Est. Monthly

$1,896/MO

$399,900

36-38 Riverview Drive, Rotterdam, NY

4 Beds3 Baths2,400 SqFt0.27 Acres

Beautifully updated side-by-side duplex overlooking the Mohawk River. This spacious property offers two bright and inviting 2-bedroom apartments, each with just over 1,000 sq ft of comfortable living space. The main level of each unit has been fully remodeled, featuring a modern kitchen with bar seating, brand-new stainless steel appliances, a generous living room, and a stylish updated half bath. Upstairs, each apartment includes two well-sized bedrooms and an updated full bathroom. Both units also come with their own private basement--complete with a washer and dryer. Brand-new garage doors have been installed on the 2-car garage with additional off-street parking available on the recently repaved driveway. Enjoy a spacious backyard with tranquil views of the Mohawk River and surrounding mountains, all set in a peaceful Upstate NY location. The home has been thoughtfully maintained and upgraded, featuring new energy-efficient windows, a 2-year-old asphalt shingle roof, and new high-efficiency hot water heaters installed in 2024 and 2025. New septic installed in '26. Whether you're looking to enjoy one unit as an owner-occupant or seeking a turnkey investment property, this duplex offers outstanding flexibility and immediate income potential. No flood insurance required.

StatusIn Escrow
Property TypeMulti Family
Property SubtypeDuplex
Year Built1976
Days on Market9 days

Est. Monthly Payment

$1,895.52

%
%
yr

Private Mortgage Insurance

Not required

Affordability Checkoptional
$

Enter your annual income to check affordability

Property Details

Property Information

36-38 Riverview Drive

Rotterdam, NY 12150 • Schenectady
4
Beds
3
Baths
2,400
SqFt
0.27
Acres
Status
In Escrow
Property Type
Multi Family
Property Subtype
Duplex
Year Built
197650 years ago
Days on Market
9 days
Tax History
Estimated values, may not reflect current amounts.
  • Annual Tax Amount
    $7,780
Property History
  • Listed for sale
    Apr 29, 2026 • GLOBAL MLS • 202616001
    $399,900
Mortgage Calculator
Estimated monthly payment for this property
$1,895.52
Down Payment
Interest Rate
Loan Term
%
%
yearsyrs.
Affordability Checkoptional
$

Enter your annual income to see if this home fits your budget

Private Mortgage Insurance

Not required — down payment above 20%
MLS Information
  • Source
    Global MLS
  • MLS#
    202616001
  • Listing Office
    Find Advisors
  • Last Updated
    27 days ago

Climate & Systems

  • Heating
    • Electric
    • Baseboard

Interior Features

  • Basement
    • Unfinished
    • Full

Parking

  • Parking Spaces
    6
  • Garage Spaces
    2

Lot & Grounds

  • Lot Size
    0.27 acres
  • Exterior Features
    None

Type

  • Property Type
    Multi Family
  • Property Subtype
    Duplex
  • Architectural Style
    Other

Structure

  • Construction
    • Brick
    • Vinyl Siding
  • Roof
    Shingle

Condition

  • Year Built
    1976
  • Days on Market
    9 days
  • Water
    Public
  • Sewer
    Septic Tank
  • Electric
    200+ Amp Service

607-282-6242, (607) 282-6242, or +1 607 282 6242

Kevin Lucero

Kevin Lucero

Lic. Real Estate Salesperson

CallEmail
Picked for you

Similar Properties

Handpicked listings that match what you're looking at

View all →
  • 48 Olanta Street, Lancaster, NY 14043ACTIVE$360,000

    48 Olanta Street, Lancaster, NY 14043

    6 Beds3 Baths2,184 SqFt0.1745 Acres

    LISTING BY REALTY ONE GROUP EMPOWER

  • 102 Prospect Avenue, Hamburg, NY 14075ACTIVE$364,900

    102 Prospect Avenue, Hamburg, NY 14075

    4 Beds2 Baths2,673 SqFt0.404 Acres

    LISTING BY KELLER WILLIAMS REALTY LANCASTER

  • 2418 Campbell Avenue, Schenectady, NY 12306ACTIVE$367,000

    2418 Campbell Avenue, Schenectady, NY 12306

    6 Beds2 Baths2,084 SqFt0.1 Acres

    LISTING BY FIND ADVISORS

  • 166 Blue Barns Road, Clifton Park, NY 12148ACTIVE$369,000

    166 Blue Barns Road, Clifton Park, NY 12148

    3 Beds2 Baths1,488 SqFt0.46 Acres

    LISTING BY SCHERMERHORN REALTY GROUP LLC

  • 683 State Street, Albany, NY 12203ACTIVE$369,000

    683 State Street, Albany, NY 12203

    6 Beds2 Baths1,750 SqFt0.06 Acres

    LISTING BY ADI REAL ESTATE SERVICES LLC

  • 43 Myrtle Avenue, Albany, NY 12202ACTIVE$369,900

    43 Myrtle Avenue, Albany, NY 12202

    4 Beds3 Baths2,376 SqFt0.06 Acres

    LISTING BY REAL BROKER NY LLC

  • 11 S Dove Street, Albany, NY 12202ACTIVE$375,000

    11 S Dove Street, Albany, NY 12202

    7 Beds2 Baths2,454 SqFt0.08 Acres

    LISTING BY HOWARD HANNA CAPITAL INC

  • 703 Union Street, Schenectady, NY 12305ACTIVE$375,000

    703 Union Street, Schenectady, NY 12305

    3 Beds2 Baths2,578 SqFt0.09 Acres

    LISTING BY GUCCIARDO REAL ESTATE LLC

  • 149 Homestead Avenue, Albany, NY 12203ACTIVE$385,000

    149 Homestead Avenue, Albany, NY 12203

    6 Beds2 Baths2,668 SqFt0.12 Acres

    LISTING BY KW PLATFORM

  • 1096 Wicker Street, Ticonderoga, NY 12883ACTIVE$395,000

    1096 Wicker Street, Ticonderoga, NY 12883

    4 Beds2 Baths3,500 SqFt2.53 Acres

    LISTING BY BRANNOCK PROPERTIES