Refine Search
Sort by
492 Olean Street, Rotterdam
$265,000
6 Beds ⋅ 3 Baths ⋅ 202626999 MLS
An incredible house-hacking opportunity awaits! Live in one unit while letting the other two cover your mortgage; or add a solid multi-unit asset to your portfolio. This charming property functions as three distinct living spaces: a 3-bedroom main floor, a 2-bedroom upper flat, and a private 1-bedroom lower-level apartment. Numerous updates throughout the home: ceilings, insulation, windows, flooring, trimwork, doors, baseboards, electrical outlets, light fixtures, dimmers. Kitchens have newer cabinets, appliances including built in microwaves, countertops and deep sinks, backsplashes. Furnace: new starter ignition and circulator pump.Exterior: painted front/garage doors, insulation, hard-wired lights with sensors. Multiple hose hook-ups with hot water to one. Enjoy a fenced front yard w/ solar lights and a spacious two-car garage complete with 1/2 bath, 2 sinks, and ample overhead storage. Parking for 5. Outdoor gazebo, propane fire pit, electric fireplaces-Unit 1 and Unit 2 has a built-in, and all A/C units to convey. Excluded: large wardrobe in Upper Unit. Located in a flexible B-2 zoning district and convenient to shopping, dining, and commuter routes. Sold as-is (inspections for buyer informational purposes only). Located in the Mohonasen School district.

492 Olean Street, Rotterdam

2003 Hamburg Street, Rotterdam
$299,999
6 Beds ⋅ 4 Baths ⋅ 202626557 MLS
Excellent investment opportunity in the Mohonasen School District! This triplex offers three income-producing units plus a separate additional building, a and major recent improvements. The spacious first-floor apartment features 4 bedrooms and 1.5 baths and currently rents for $1,800/month. The second floor consists of two 1-bedroom, 1-bath apartments currently renting for $750 and $850/month, respectively, for a total current gross rental income of $3,400/month. Adding even more versatility is a separate building formerly used as a jewelry shop and currently utilized as a workshop--offering excellent potential for storage, workspace, or other permitted uses. The property also features a large fenced-in backyard, brand-new septic system, brand-new roof, and public water. With strong existing rental income and the potential for a double-digit cap rate depending on purchase price and operating expenses, 2003 Hamburg Street presents an exciting opportunity for investors looking to add a unique multi-unit property to their portfolio. Convenient Schenectady-area location within the Mohonasen School District. Don't miss this opportunity!

2003 Hamburg Street, Rotterdam

11 Parkis Street, Rotterdam
$330,000
8 Beds ⋅ 4 Baths ⋅ 202624770 MLS
Endless Space, Peaceful Views, and Total Freedom! Escape to this massive 8 bedroom, 3.5 bath retreat tucked away on a quiet dead end street. Sitting on over half an acre of land, this home blends peaceful country living with room for everyone to spread out. Inside, you will find brand new flooring, fully renovated bathrooms and a beautifully updated kitchen that is perfect for gathering. The main floor features a private primary suite with a Uniquely updated bathroom. Upstairs, seven more bedrooms give you endless options to create private home offices, hobby rooms, or guest spaces. Step outside to enjoy peaceful woodland and mountain views from your yard. Whether you have a big family or want a smart investment property, Attractive Airbnb potential! This home gives you the space to live your dreams! It's one of a kind and located in the Schalmont Central School District.

11 Parkis Street, Rotterdam

1005 Fairlane Road, Rotterdam
$989,900
6 Beds ⋅ 5 Baths ⋅ 202623835 MLS
A once in a generation opportunity to own one of Rotterdam's most distinguished custom built estates. The first home built in this prestigious neighborhood, this landmark residence has long been admired for its exceptional quality, timeless architecture, and enduring craftsmanship. Situated on beautifully landscaped, park-like grounds, this extraordinary home offers approximately 6,300 square feet above grade plus an additional 3,000 square feet of finished lower level living space. A dramatic two story foyer welcomes you with marble floors, a sweeping staircase, and powder room. Formal living and dining rooms feature original hardwood floors preserved beneath carpeting since 1959, pocket doors, and an adjoining garden room complete with a wet bar, indoor grill, and dual sliding doors to the backyard. The spacious eat in kitchen offers abundant cabinetry and Corian countertops. The inviting family room features a Roman brick fireplace with slate hearth, oversized windows, and a built in bar closet. A stunning executive office showcases rich walnut paneling, custom built-ins, and a cherry coffered ceiling. The main level also includes a spacious primary suite with dual closets and private bath, plus a second bedroom and full bath. Upstairs are four generously sized bedrooms with hardwood floors, ample closet space, a cedar closet, linen closet, two large storage rooms, and a full bath with triple vanity, soaking tub, and separate shower. The finished lower level includes a family room with fireplace, recreation room, kitchenette, office, wine cellar, half bath, and an expansive two room woodworking shop. The striking brick and Kentucky bluestone exterior is complemented by an inground pool, pool house with bath and shower, lighted bocce court, gazebo, tree house, three-car attached garage, and beautifully landscaped grounds. Additional features include three Lennox furnaces, two central air systems, and generator hookup Adj .71acre building lot available separately

1005 Fairlane Road, Rotterdam

1374 Helderberg Avenue, Rotterdam
$350,000
6 Beds ⋅ 4 Baths ⋅ 202619139 MLS
Conveniently located near I-90 and within the Mohonasen School District, this Rotterdam 3 Unit offers tons of potential to investors and owner/occupants alike! Apartments 1 and 3 are currently occupied by month to month tenants, while Apt. 2 is vacant, recently renovated, and ready for an owner seeking to offset their cost of living or could comfortably rent at market rate. Large fenced yard, off-street parking, and a 3-car garage provide rare amenities not often seen in the multi-family market. Apartment 1 - 1 bed, 1 bath ($800). Apartment 2 - 2 bed, 1 bath. Apartment 3 - 3+bed, 1.5 bath ($1290). Slate roof. Separate utilities. Garage sold as-is. Showings for Apt. 3 preferably after 5PM weekdays or Wednesday during the day. Apt.'s 1 and 2 more availability. Showings begin Wednesday 6/10.

1374 Helderberg Avenue, Rotterdam

2021 Cedarlawn Avenue, Rotterdam
$240,000
6 Beds ⋅ 2 Baths ⋅ 202619077 MLS
Don't miss this rare opportunity to own a spacious 6 bedroom, 2 full bath home in Rotterdam with a bonus office/den space located in the Mohonasen School District. Featuring public water and sewer, stainless steel kitchen appliances, and a beautiful stained-glass window that adds character and charm to the living room, this home offers generous living space and endless possibilities. Filled with vintage charm and unique details throughout, the property has solid bones and is ready for a new owner to bring their vision and personal style. Whether you're looking for room to grow or the opportunity to build equity through updates, this home presents tremendous potential to create something truly special. Sold As-Is.

2021 Cedarlawn Avenue, Rotterdam

3206 Guilderland Avenue, Rotterdam
$525,000
7 Beds ⋅ 4 Baths ⋅ 202616650 MLS
Exceptional opportunity in the Mohonasen School District! This spacious 3-family property in Rotterdam offers over 4,000 sq ft of versatile living space, ideal for owner-occupants, investors, multi-generational living, or small business owners. The large first-floor unit is perfectly suited for owner occupancy, featuring a large updated eat-in kitchen, four bedrooms, and 1.5 baths--offering the feel and space of a single-family home. Upstairs, you'll find two additional units (a 2-bedroom/1-bath and a 1-bedroom/1-bath), each with separate utilities, providing strong income potential. Lovingly maintained by the same family, the property also includes a generous yard, shed and off-street parking. Zoned B-1, this property opens the door to a variety of possibilities--live, work, and invest all in one location.

3206 Guilderland Avenue, Rotterdam

1310 Currybush Road, Rotterdam
$1,250,000
6 Beds ⋅ 6 Baths ⋅ 202523097 MLS
This magnificent estate has a mini, private amusement park w/ helicopter pad! Enjoy huge water slide in heated salt-water pool, go-kart track w/ go-karts included, tennis court, koi pond & volcano display. Two-3 car, temperature controlled oversized garages (6 bays). House comes furnished w/ 5,132 sq. ft. 6 BR, 5 1/2 baths. Surrounded by 30 acres of land, just 20 min from Albany Int'l Airport & 18 min from Sch'dy Airport. Gorgeous, coffered ceilings, gourmet kit, game room & many more upscale features like 4-person jetted tub in one of 3 primary suites! Includes an in-law or guest suite w/ separate entrance. Soak in outdoor hot tub or hang out at the fire pit. Enjoy fall foliage, apple picking, hiking & ski at nearby Maple Ski Ridge or Gore Mt. Close to Saratoga & Lake George. Must see!

1310 Currybush Road, Rotterdam

2641 Broadway, Rotterdam
$417,000
7 Beds ⋅ 6 Baths ⋅ 202511431 MLS
Stunning Two Family Home in Mohonasen School District - Fully Remodeled! This beautifully remodeled two family home is a fantastic investment opportunity! This property has been thoughtfully updated from top to bottom. Featuring brand-new windows, new flooring, and stylish finishes throughout, every detail has been carefully considered. Enjoy spacious open-concept living with modern kitchens and baths, high-efficiency furnaces for cost-effective comfort, and additional finished space in both the attic and basement—perfect for extra rooms, storage, or flex space. With ample room and a fresh, contemporary feel, this home is completely move-in ready for tenants. Don't miss out on this turn-key rental property with gorgeous upgrades and exceptional appeal!

2641 Broadway, Rotterdam

©2019 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. Data last updated

How much is your home worth?

Get instant property value now!