Refine Search
Map
Sort by
$1,299,000
4 Beds ⋅ 5 Baths ⋅ 202622935 MLS
Designed and built by renowned builder Peter Sotile, this one-of-a-kind custom contemporary offers nearly 6,000 square feet of thoughtfully designed living space, which includes an exceptional finished lower level. Expansive windows (126 of them!) and skylights fill the home with natural light while bringing the beauty and serenity of the surrounding landscape indoors. The private primary suite is tucked away on its own wing and features two unique balconies--one overlooking the dramatic sunken living room and another accessed through sliding glass doors, where you can enjoy peaceful treetop views of the surrounding forest. A separate bedroom wing offers outstanding flexibility, featuring a shared living area, three spacious bedrooms, and two full bathrooms--ideal for family, guests, or multigenerational living. The oversized second-floor loft overlooks the grand foyer, family room, and kitchen, creating an open and airy atmosphere. The inviting library is introduced through beautifully etched double doors, while the formal dining room showcases elegant inlaid hardwood flooring and sliding glass doors leading to a screened porch. Recent updates provide peace of mind and modern comfort, including two approximately five-year-old heating and air conditioning systems, a newer roof, and an on-demand hot water system. The expansive finished lower level features an oversized recreation room perfect for entertaining, game nights, celebrations, or hosting large gatherings. This exceptional Baldwin Farms residence combines distinctive architecture, generous living spaces, and a tranquil natural setting to create a truly remarkable place to call home. All in the award winning Niskayuna School District!

37 Covington Court
$720,000
6 Beds ⋅ 7 Baths ⋅ 202622350 MLS
Seven-unit brick apartment building on Union Street in Schenectady, fully occupied. Built in 1984, three stories with a slate roof and central hot-water heat. The mix is six 1-bedroom apartments plus a studio (six bedrooms, seven full baths) across roughly 3,441 square feet. Heat, hot water, and trash are owner-provided; tenants pay their own electric and gas. A shared coin-operated laundry serves the building. Shared driveway access with adjacent dental office parking lot; recorded easement of record. Seller is offering a roof credit at closing. Commonly known as 838 Union Street. Offered individually or within an eleven-building Schenectady portfolio. A strong unit count for an investor seeking scale. Seven-unit brick apartment building on Union Street in Schenectady, fully occupied. Built in 1984, three stories with a slate roof and central hot-water heat. The mix is six 1-bedroom apartments plus a studio (six bedrooms, seven full baths) across roughly 3,441 square feet. Heat, hot water, and trash are owner-provided; tenants pay their own electric and gas. A shared coin-operated laundry serves the building. Shared driveway access with adjacent dental office parking lot; recorded easement of record. Seller is offering a roof credit at closing. Commonly known as 838 Union Street. Offered individually or within an eleven-building Schenectady portfolio. A strong unit count for an investor seeking scale.

838 1/2 Union Street
$330,000
5 Beds ⋅ 3 Baths ⋅ 202622340 MLS
Three-unit multifamily on Union Street in Schenectady, fully occupied. Built in 1900 with forced-air heat and hardwood flooring, it offers 5 bedrooms and 3 full baths across roughly 3,096 square feet. Tenants pay their own electric, gas, heat, and hot water. Offered individually or within an eleven-building Schenectady portfolio. Strong unit count for a value-minded investor.

834 Union Street
$249,900
202622263 MLS
Opportunity awaits at this mixed used Union Street property. Currently set up as a dentist office on the first floor and one apartment spanning the 2nd and 3rd floors. The dentist office features 3 treatment rooms, lobby, front desk, office, break room and two half bathrooms. The apartment is vacant and has 2 full bathrooms, one on the second floor and one on the 3rd floor and 4-5 bedrooms. The property has a garage and includes 8 off street parking spots. Great opportunity to convert into a two or three unit multi-family property and maximize its potential. Recent updates include two furnaces (2021) and two hot water heaters (2017 and 2019). Utilities are separate with two separate electric meters, and two gas meters. Central air on the first floor. Per the city of Schenectady, R-3 zoning and in the historic overlay district. 1984 is the effective year built. Property being sold as-is.

1006 Union Street
$789,000
4 Beds ⋅ 3 Baths ⋅ 202621917 MLS
Lovingly cared for by the same owner for more than 30 years, this unique 3,100+ sf farmhouse beautifully blends the timeless character of an 1800s historic home with the comfort and functionality of extensive renovations completed in the mid-1990s. This one-of-a-kind property offers the perfect balance of history, space, and versatility. The expansive floor plan provides incredible flexibility with multiple living areas ideal for multigenerational living, home office, recreation space, or creative studio. Every room reflects the warmth and character that only a historic country home can offer. Set on 3.1 picturesque acres with breathtaking panoramic views, the grounds feature established perennial gardens that provide colorful blooms throughout the seasons. Whether relaxing on the patio, soaking in the hot tub, or enjoying the outdoor shower after a day of gardening or horseback riding, the outdoor spaces were designed to embrace the peaceful beauty of country living. The impressive 26' x 38' barn offers endless possibilities with space for animals, equipment storage, a workshop, contractor's shop, woodworking studio, car collection, or hobby space. Equestrian enthusiasts will appreciate the separate horse barn featuring one existing stall, room to add additional stalls, and a spacious hay loft above. A run-in shed and chicken coop (with electric) complete this exceptional hobby farm or gentleman's farm. This property offers privacy and tranquility while remaining just minutes from hiking trails, nature preserves, and year-round outdoor recreation. Schenectady, Albany, and Saratoga Springs are all within easy reach, providing convenient access to shopping, restaurants, golf, skiing, entertainment, and the world-famous Saratoga Racecourse. Whether you're seeking a private country estate, an equestrian property, a hobby farm, this home offers historic charm, modern comfort, exceptional outbuildings, and an unmatched Upstate NY lifestyle. Virtually staged.

1236 McGuire School Road
$525,000
9 Beds ⋅ 5 Baths ⋅ 202621547 MLS
Looking to start a portfolio? This 5 unit building is completely renovated and waiting for its new owner. Close to the bus line and local shops this is a prime location. The building was taken off the market to renovate all units. Seller related to agent.

71 N Brandywine Avenue
$385,000
202621437 MLS
Exceptional turnkey commercial opportunity in one of Glenville's most desirable business corridors! Perfectly positioned on highly traveled Ballston Road (Route 50), this beautifully updated office/salon/barber suite property offers outstanding visibility, flexibility, and immediate occupancy for an owner-user or investor. Encompassing approximately 3,001 square feet on 0.83 acres, the two-story building is thoughtfully designed with six private suites--with the potential for additional offices depending on your preferred layout. The versatile floor plan also features two conference rooms, a welcoming reception area, client lounge, café, kitchenette, and multiple collaborative workspaces, making it ideal for professional offices, medical or wellness practices, salons, barbers, estheticians, or a variety of service-based businesses. Extensively updated throughout, the property boasts modern mechanical systems, new flooring, fresh carpet, and contemporary finishes, allowing a new owner to move in and begin operations immediately with little to no additional investment. Outside, the expansive parking area accommodates 10+ vehicles, providing convenient access for employees and clients alike. With traffic counts exceeding 20,000 vehicles per day, your business will benefit from exceptional exposure along one of the Capital Region's busiest commercial routes. Conveniently located just minutes from Rivers Casino, major retailers including Walmart and Lowe's, the Freeman's Bridge Road commercial corridor, Schenectady County Airport, and the Schenectady County Industrial Park, this property offers outstanding accessibility and proximity to a thriving business community. Whether you're expanding your business, relocating your operations, or seeking a high-quality commercial investment, this move-in-ready property delivers the location, flexibility, and professional setting to support long-term success.

322 N Ballston Road
$1,650,000
9 Beds ⋅ 6 Baths ⋅ 202621204 MLS
Exceptional opportunity to acquire two fully occupied five-unit apartment buildings offered together as a 10-unit investment portfolio. This turnkey package features a diverse unit mix, strong rental history, and over $220,000 in capital improvements since 2022, including renovated apartments, updated kitchens and baths, refinished hardwood and luxury vinyl flooring, plumbing and mechanical upgrades, exterior painting, and more. Tenants pay their own utilities. Both properties offer off-street parking, with garages at 1114 Union St. Ideally located near Union College, Ellis Hospital, downtown Schenectady, shopping, dining, and major highways. Financials available upon request.

1114 Union Street
$499,000
9 Beds ⋅ 2 Baths ⋅ 202621008 MLS
BIG 2-Family! 9 Bedrooms 2 Full Baths 1 Car Garage. Located in The Central State Street Neighborhood.

22 Elder Street
$1,149,000
5 Beds ⋅ 5 Baths ⋅ 202620994 MLS
Luxury New Construction. Custom Home to be built. Welcome to 13 Pinecrest Dr, a stunning Griner Construction custom home in quiet Niskayuna established neighborhood. Located within the Niskayuna School District. Now is the perfect time to personalize your dream home! Now is the time for you to select all of your finishes + design details. This 3,232 sq ft home showcases timeless craftsmanship and today's most sought-after features. The open-concept floor plan includes a bright and airy great room w/ a cozy gas fireplace, elegant dining area, and a chef's kitchen with quartz countertops, Schrock custom soft-close cabinetry, and stainless-steel appliances, perfect for entertaining. Bring your plans or use our Custom Home Plans. Your Dream Home Awaits!! Photos are examples of homes built.

13 Pinecrest Drive
$299,000
202620789 MLS
Owner Financing Available Huge mixed-use building in the heart of Schenectady. First floor is a former dine/pizzeria with potential for a restaurant, coffee shop, café, etc. Second floor is a lawyers office with built-in bookshelves. Next to diner space there is a space that was used for doctor's office and has a lot of potential for prime office space for your business.

170 Lafayette Street
$799,000
4 Beds ⋅ 3 Baths ⋅ 202620770 MLS
Twin Brooks Farm, a historic 86-acre farm with captivating views of the Helderbergs, has been part of the Duanesburg landscape for more than two centuries. Believed to date to circa 1790, the farmhouse occupies land that traces its origins to the original tract granted to James Duane, Founding Father and namesake of the Town of Duanesburg. Over the years, the property has served as a dairy farm, agricultural farm, and, more recently, an equestrian facility. The main house has been thoughtfully updated and expanded while retaining its historic character. Original details, generous living spaces, and numerous improvements throughout reflect the home's long history and careful stewardship. The farm is well-equipped for a variety of agricultural and equestrian uses. Highlights include an 18-stall horse barn with two foaling stalls and office/tackroom, large garage and hay barn; and an original 2-story post-and-beam barn which once contained an additional apartment. The property features a natural spring-fed pond, gently rolling agricultural fields, wooded areas, frontage on two roads and even more outbuildings. Located just 25 minutes from Albany and Schenectady, Twin Brooks Farm combines historic significance and endless potential for future use agriculturally, gentlemen's farm or simply an opportunity preserve an important piece of local history.

334 Duanesburg Churches Road
$3,000,000
202620541 MLS
A rare downtown Schenectady investment and redevelopment opportunity comprising approximately 45,322 square feet situated on 1.20 acres across four tax parcels. Prominently located at the intersection of State Street, South Ferry Street, and Erie Boulevard, the property offers extensive on-site parking, flexible office and community facility space, elevator access, and highly desirable C-4 Downtown Commercial Mixed-Use zoning that permits a broad range of office, medical, educational, multifamily, hospitality, retail, and mixed-use uses.

214 State Street
$299,000
202620395 MLS
The possibilities are endless with this original Schenectady Fire Department. Building was decommissioned almost 40 years ago but all of the original charm remains. Featuring a full brick exterior with a newer roof and plenty of off street parking. Covert the property to luxury apartments, relocate your office, divide the building into flexible space, an event space or start a business you have been dreaming about!

907 Albany Street
$350,000
5 Baths ⋅ 202620334 MLS
This Brick mixed use 5 unit building offers an exceptional investment in Schenectadys Vibrant Northside: Two ground floor storefronts plus three , 2 bedroom residential apartments above. All 3 apartments are rented $950 each. This location is a highly visible stretch on a busy corridor, ideal for an owner occupant, retail landlord or investor. Located right down the road from Union College, 2 min from the Casino and all downtown Schenectady has to offer.

1697 Van Vranken Avenue
$495,000
4 Beds ⋅ 4 Baths ⋅ 202619684 MLS
Step into a truly one-of-a-kind home where timeless craftsmanship meets modern convenience. The recently remodeled kitchen is a true centerpiece, thoughtfully designed with high-end appliances, quality finishes, and a perfect blend of style and function for both everyday living and entertaining. This spacious home offers room for everyone with an impressive large rec room ideal for gatherings, a home gym, or whatever suits your needs. It also boasts a large finished attic space with a full bath. Unique, stunning woodwork throughout creates a warmth and character rarely found today, complemented by beautiful stained glass. A home office/business space provides incredible flexibility and could be transformed into a private apartment, in-law suite, guest quarters, a home business, or a creative studio. Additional updates include a newly paved driveway and two solar systems. Blending exceptional architectural details with modern upgrades, versatile living spaces, and remarkable craftsmanship, this rare property offers the perfect combination of historic charm, contemporary comfort, and endless possibilities.

1520 Union Street
$325,000
6 Beds ⋅ 4 Baths ⋅ 202619267 MLS
Prime Investment Opportunity: This rock solid, four unit multifamily property is a cash flowing gem perfect for investors or owner occupants looking to live for free while tenants pay the mortgage. The building features three stable, long-term tenants with recent rent increases who would love to stay ensuring immediate, reliable income. One vacant unit ready for move-in or top market rent. Boasting a roof only four years old and separate utility meters, the spacious units are filled with original charm, featuring hardwood flooring, beautiful built-ins, updated tile bathrooms, and a massive walk-up attic with incredible potential for a future value add as additional living space. Situated on a direct bus line in a high-demand rental market with strong neighborhood presence and seamless proximity to downtown restaurants and amenities, this turn-key property is an absolute powerhouse for your portfolio. Contact the listing agent for more interior photos.

1405 State Street
$350,000
5 Baths ⋅ 202618955 MLS
This Brick mixed use 5 unit building offers an exceptional investment in Schenectadys Vibrant Northside: Two ground floor storefronts plus three , 2 bedroom residential apartments above. All 3 apartments are rented $950 each. This location is a highly visible stretch on a busy corridor, ideal for an owner occupant, retail landlord or investor. Located right down the road from Union College, 2 min from the Casino and all downtown Schenectady has to offer.

1697 Van Vranken Avenue
$789,900
4 Beds ⋅ 3 Baths ⋅ 202618807 MLS
Welcome to a rare 2.6-acre retreat where lifestyle, privacy, and possibility all come together. Custom-built in 1991 and freshly repainted inside and out, this 4,300 sq ft home blends timeless craftsmanship with modern comfort -- including a heated/insulated attached garage, a second full kitchen, and a heated sunroom with its own indoor garden. One of the home's most charming surprises is found in the finished lower level: a BellSouth payphone that instantly sparks nostalgia and a full bar originally from the legendary Ground Round restaurant -- the perfect conversation pieces for hosting, game nights, or creating your own entertainment space with personality and history. Outdoors, the property unfolds as a place to stretch out, breathe deeper, and settle in. Enjoy a 14-foot-deep, fully stocked pond and powered fountain, surrounded by open lawn and mature trees. The detached 1,300 sq ft heated and insulated garage offers incredible flexibility with a vehicle lift, making it ideal for car collectors, hobbyists, or home-based businesses. A mix of heating sources (oil, propane, electric), forced hot air with central air, well, and septic provide year-round efficiency and peace of mind. With 4 bedrooms, 3 full baths, a half bath, two full kitchens, expansive gathering spaces, and room to stretch out both indoors and out, this is a property designed for comfort, creativity, and lifestyle. 1306 Putnam Road, Schenectady, NY -- a one-of-a-kind setting where memories are made, hobbies thrive, and every day feels a little bit like a retreat. Sq Ft according to the seller / builder plans.

1306 Putnam Road
$365,000
202617449 MLS
Solid stone construction commercial building featuring multiple updates throughout, offering both character and functionality. The possibilities are endless. Allowed usage can be provided upon request. The property features a massive basement space with endless potential, ideal for use as a conference area, meeting space, storage, or additional operational use, it also includes 3 egresses. Excellent opportunity for a new owner seeking a well-maintained commercial property in a prime location on Guilderland Ave.

2558 Guilderland Avenue
$359,000
2 Baths ⋅ 202615138 MLS
Exceptional opportunity to own a versatile mixed-use retail / warehouse building in a high-visibility, high-traffic location! This +/- 4,400 SF property offers a flexible layout ideal for retail, warehouse, or service-based businesses. Positioned along a major thoroughfare with strong daily traffic counts and excellent exposure, the site provides easy access to Schenectady, Scotia, and Amsterdam. On site parking, room to expand, and much more make this ideal for owner-users or investors. Business can be added in for sale as well and is listed separately.

3304 Amsterdam Road
$225,000
202613933 MLS
Unique opportunity to acquire a versatile commercial property at an aggressive price point. Currently operating as a funeral home, the building offers immediate usability for an operator or strong value-add potential for investors. Features include a large chapel with seating, multiple offices, preparation space, and a spacious upper-level apartment for potential additional income or owner occupancy. Well-suited for religious use, community facility, or other commercial applications. Situated on a 0.35-acre lot with ample parking and garage space, the property supports a variety of commercial or mixed-use uses. Offered for a quick sale, presenting significant upside for investors or end-users.

322 Hulett Street
$2,150,000
202613733 MLS
Prime Corner Development Opportunity - Rotterdam, NY Positioned at a signalized intersection in the heart of Rotterdam, this ±44,000 SF corner lot offers exceptional visibility and strong daily traffic counts with immediate access to Route 9. The site presents a highly flexible development opportunity ideal for retail, office, or service-oriented users, with ample space for parking, signage, and efficient site layout. Surrounded by established national retailers and dense residential neighborhoods, the location supports a wide range of uses including medical, wellness, fitness, childcare, personal care, and fast-casual concepts. A rare opportunity to secure a highly visible corner site in a proven commercial corridor--perfect for users and developers seeking long-term growth and consistent traffic exposure.

1874 Altamont Avenue
$199,000
202611780 MLS
Professional office condominium, over 4400 sq ft located in the Nott Street Medical Arts building attached to Ellis Hospital. Opportunity for medical, dental, psychiatry, nutrition, health & wellness and much more! Consists of large waiting/reception, 2 offices and 8 exam rooms, 3 offices and 4 bathrooms. Also included is 2 private garage spaces. Leasing options available too!

1201 Nott Street Suite 102
$499,900
202611021 MLS
Iconic Schenectady Restaurant/Bar! Don't miss this rare opportunity to own a well-known restaurant/bar with over 50 years of history in Schenectady's thriving North End! Recently acquired and now available again, this property is just steps from Mohawk Harbor, Rivers Casino, and the future Mohawk Harbor Arena. Indoor and outdoor seating for 75+ guests. Fully remodeled in 2011 with a large commercial kitchen: ovens, fryers, walk-in cooler, and ample prep space. Outdoor stone patio with roof (2011), updated plumbing and electrical. Sale includes the business, building, furniture, and equipment. Private parking lot + plenty of public parking. Garage door access to basement for easy deliveries. Perfect for owner-operators or investors—turnkey and ready to go! Owner financing is available

1857 Van Vranken Avenue
$575,000
4 Baths ⋅ 202610875 MLS
Incredibly versatile beautifully maintained turnkey restaurant. Over 4300 of space on the main level could be divided into multiple spaces and or other businesses, with separate entrances. Currently a fully functioning restaurant, with full bar, cafe seating, a private dining room, and approx. 1200 sq ft that could be additional dining currently or a completely different business. There is also a residential apartment upstairs originally set up to be a 2 BR owners unit or additional offices about 600 Sq ft. The full basement offers offices, a full bath, walk in coolers/freezers, and tons of dry good storage. You couldn't rent this space for what you could own it for, excellent investment opportunity. Just 1/2 mile from Ellis Hospital, 1.5 miles to Rivers and Union College, and 2 miles to Proctors. Sale includes all FFE excepting some personal effects.

2015 Rosa Road
$1,990,000
7 Beds ⋅ 3 Baths ⋅ 202610469 MLS
Welcome to The Mansion at Rebecca's Fountain, where you'll be welcomed by a working fountain with a statue of Rebecca which sets the tone for this beautiful estate. Perched atop more than three secluded acres in Niskayuna, overlooking the Mohawk River, the Estate offers mountain views, refined architecture, and a rare sense of privacy minutes from the finest destinations. Reminiscent of ''Gone with the Wind,'' a grand foyer welcomes you with sweeping dual staircase & a striking 6-foot motorized crystal chandelier that showcases the elegance found throughout the home. Fully furnished by a designer, the approx. 5,000 sqft residence features 7 bedrooms, 3 full baths, sun-filled spaces, soaring ceilings, hardwood floors & oversized windows framing the surrounding landscape. The 1st floor primary suite serves as a serene retreat, featuring a spa-inspired bath w dual sinks, walk-in shower, jetted tub, and an expansive walk-in closet. The gourmet kitchen is ideal for daily living & entertaining, offering a large island, custom cabinetry & seamless flow to a formal dining room with classic millwork. Additional highlights include a sunken Great Room with vaulted ceiling and a floor-to-ceiling LP gas fireplace, first-floor laundry/ Butler's pantry, central air, a two-car side-load garage, and a partially finished lower level that is suitable as 7th bedroom or theater room. An additional 1,720 sqft of unfinished lower-level space (formerly wine storage) offers potential for a gym, game room or other uses. The estate unfolds into a serene oasis with a tranquil pond, custom concrete patio & deck, firepit, and a 7-person spa overlooking apple trees and wildlife. Completing the property is a detached aux building with an existing, legally permitted use for wine tasting & wine sales, offering a rare and distinctive feature that further sets the estate apart. A rare opportunity to own a landmark estate offering timeless elegance, exceptional flexibility, unmatched tranquility.

2820 Balltown Road
$525,000
202531024 MLS
Looking to start a portfolio? This 5 unit building is completely renovated and waiting for its new owner. Close to the bus line and local shops this is a prime location. The building was taken off the market to renovate all units. Seller related to agent.

71 N Brandywine Avenue
$675,000
202529672 MLS
Well-located property offering exceptional visibility and accessibility in one of Schenectady's most convenient areas. Situated near major thoroughfares and established neighborhoods, this property presents a versatile opportunity for a wide range of uses, establish an office, retail space, or service-based business, this location offers both convenience and long-term growth potential. Ideal for an owner-occupant or investor seeking strategic Schenectady location.

2855 Aqueduct Road
$845,000
5 Beds ⋅ 5 Baths ⋅ 202529377 MLS
Experience the Perfect blend of luxury, comfort, & privacy in this stunning contemporary estate set on 28.17 acres. This spacious 4,333 sq. ft home features 5 BR, 4 1/2 baths, including a main-level primary suite w/generous closets, & beautifully appointed bathroom. The open Kitchen is ideal for entertaining. The great room with an entertainment center, wet bar, & pool table- perfect for gatherings and relaxation. Step outside through French doors to enjoy the inviting inground saltwater pool. Car Enthusiasts and hobbyist will appreciate both the attached 3 car garage, & 3 car detached garage that holds 6 cars, while the greenhouse offers exciting potential for gardening. Energy efficiency is a highlight, with OWNED Solar panels and a propane tank providing independence and savings. (Attached garage solar is, rented) Recent updates include a blue stone front retaining wall, newer sidewalks, foundational work, fresh exterior paint (2023), a newer awning, 2 new garage doors (attached) and an accessible ramp to the front entrance. This Property is a rare opportunity for those seeking unique amenities, expansive grounds, private retreat. A New Furnace installed in February 2026, and all new LBT flooring was installed in the basement in April 2026.

3041 Mariaville Road

©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