Refine Search
Sort by
$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

$489,500
3 Beds 4 Baths 202619678 MLS
A RARE opportunity to own a newer construction home, built in 2019, in this Rotterdam neighborhood. This home offers the conveniences to own a true turnkey home. This home neighbors and is adjacent to 3 other new construction homes built by the original owner. Well maintained, this move-in-ready home shares quality finishes, thoughtful upgrades, and modern conveniences throughout. The floor plan is filled with natural light & features a modern appointed kitchen with quartz countertops, center island, upgraded appliances, recessed lighting and luxury vinyl plank flooring. The spacious primary suite offers a custom walk-in closet and an inviting en-suite bath, while ceramic tile finishes add a refined touch to each bathroom. Designed for both everyday living and entertaining, the backyard features an expansive patio, retractable awning with integrated lighting, custom stamped concrete fire pit area, and a large fenced yard. The finished basement add square footage to expand the living space with a full bath, egress window, and flexible areas ideal for a family room, home office, fitness space, or guest accommodations. Additional highlights include a reverse osmosis drinking water system, whole-house water conditioning system, Tesla EV charger, smart lighting, crown molding, designer Farrow & Ball paint, upgraded front porch railings, and an updated powder room with laundry. Every detail has been carefully considered, offering a seamless blend of comfort, style, and functionality. Conveniently located and access to shopping on Curry Road, Altamont Ave and minutes to I890/I90.

2069 Amsterdam Avenue

$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

$269,000
3 Beds 1 Baths 202616779 MLS
Discover timeless charm in this traditional home located in Rotterdam Junction within the desirable Schalmont School District, just steps from the historic Mabee Farm. This 3-bedroom home with a versatile den downstairs features beautiful hardwood floors throughout and a freshly painted front porch, perfect for relaxing. A bright bay window alcove creates a cozy nook and fills the home with natural light. Enjoy outdoor living on the back deck overlooking the shed and spacious yard. Situated on a rare double lot, there's ample space to add a garage and driveway, garden, pool, or outdoor living space. Character, history, and opportunity combine in this inviting property--don't miss your chance to make it yours!

8 Orchard Street

$265,000
7 Beds 2 Baths 202613391 MLS
Back on the market due to buyer financing. This large seven-bedroom home is ideally situated in the heart of Schenectady, offering tremendous potential for buyers seeking ample living space and a prime location. The property is conveniently located near Ellis Hospital, just minutes from downtown Schenectady and Union College. Four bedrooms are located on the second floor, while three additional bedrooms can be found on the third level, providing flexibility for large families or guests. The home includes two full bathrooms. Spacious kitchen, a private dining room perfect for gatherings, and a large family room featuring a fireplace. Other amenities include. A detached garage with a private alley entrance offers secure parking and additional storage. The front of the house features a covered porch, while the second floor includes its own porch. A large back deck is ideal for entertaining, and the backyard boasts fruit trees. Recent repairs have been completed on the furnace, water heater, and plumbing systems. Areas in the home require updating. The seller is open to considering all offers. For more information or to schedule a viewing! Call today for more information.

1024 Glenwood Boulevard

$1,895,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

©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