Ask Us About Our Office Listings

Ask Us About Our Office Listings

Listed below you will see our featured properties, homes that we represent. If you are curious about any of the properties below or would like a personal tour, please contact us today. We’d love to share the features that make these homes noteworthy. If you would like to see YOUR home listed below, please give us a call at (518) 878-6343 to receive a personal in-home consultation or click here to get your FREE home analysis.

View All of Our Office's Featured Property Listings for Sale

$519,000
3 Beds 3 Baths 202624738 MLS
Welcome home to 151 Consaul Rd in Colonie! Situated on 0.75 acres of level, usable land, this beautifully rebuilt single-level home offers space, flexibility, and modern finishes throughout. Originally built in 1960, the original home was completely demolished down to the foundation, with portions of the foundation newly poured, and the home was entirely rebuilt in 2021. The result is an established property with a thoughtfully designed layout and the feel and finishes of a much newer home. Step through the inviting entryway into a bright and spacious open-concept kitchen, living, and dining area, designed for both everyday living and entertaining. The main level features 3 spacious bedrooms and 2 full baths, along with an additional versatile room that can be used as a home office, guest space, den, hobby room, or potential 4th bedroom. The finished basement provides even more room to spread out, including a dedicated turf area ideal for workouts, training, recreation, or a variety of other uses. A half bath adds convenience, while the egress provides additional flexibility for future use. Outside, enjoy 0.75 acres of level property, complete with a basketball court and an impressive 30x30 outbuilding. The expansive property offers plenty of room for recreation, hobbies, storage, equipment, projects, and more. With its level yard, basketball court, turf area, and versatile outbuilding, the property offers a unique combination of indoor and outdoor space. Conveniently located near shopping, dining, everyday amenities, and major highways, 151 Consaul Rd offers space and privacy while keeping you close to everything the Capital Region has to offer. For added peace of mind, the home has been fully inspected, with no major defects noted in the inspection report. The inspection report is available to qualified interested buyers upon request. Beautifully rebuilt, incredibly versatile, and ready for its next owners-don't miss this one!

151 Consaul Road

$639,900
4 Beds 3 Baths 202624084 MLS
Welcome to 2928 W Lydius St., an exceptional custom luxury home currently under construction by Corradi Construction LLC, located in the highly desirable Guilderland Central School District. Situated on an expansive 100' x 150' lot, this thoughtfully designed 4-bedroom, 2.5-bath residence combines timeless design, high-end finishes, and quality craftsmanship throughout. Designed with today's lifestyle in mind, the open-concept first floor will feature a stunning custom kitchen with quartz countertops, premium cabinetry, stainless steel appliances, and a beautifully tiled backsplash. The kitchen flows seamlessly into the spacious dining and living areas, creating an ideal setting for both everyday living and entertaining. Luxury vinyl plank flooring will run throughout the first floor, complemented by carefully selected finishes and modern details. The second floor offers a spacious primary suite designed as a private retreat, complete with a generous walk-in closet and luxurious en-suite bathroom. Three additional bedrooms provide ample space for family, guests, or any additional use. A full basement provides abundant storage and tremendous potential for future finished living space. Outside, the oversized 100' x 150' lot offers plenty of room for outdoor entertaining, recreation, landscaping, or a future pool, while providing the space and privacy rarely found in new construction. Additional highlights include a high-efficiency natural gas heating system, central air conditioning, and quality construction throughout. Conveniently located near shopping, dining, entertainment, and major highways, this home offers the perfect blend of luxury, comfort, and convenience in one of the Capital Region's most sought-after school districts. Currently under construction by Corradi Construction LLC. Owner of property is a NYS Licensed Real Estate Salesperson.

2928 W Lydius Street

$749,900
3 Beds 4 Baths 202623864 MLS
Welcome home to this beautifully maintained contemporary-style property. The main-house features 3 bedrooms, 2.5 bathrooms, over 2,500sqft of living space. Step inside and be greeted by a breathtaking living room highlighted by a dramatic floor-to-ceiling fireplace and soaring 30+ foot ceilings, creating an impressive and inviting centerpiece to the home. Beautiful chefs' kitchen with brand new appliances. First floor bedrooms, laundry, office space and updated HVAC. Upstairs is a gorgeous private primary suite with expansive tile bathroom and large walk in closet. The outdoor space is truly made for entertaining. With over more than 1/2 an acre of private living space you can enjoy a paver patio with a built-in fire pit, tranquil waterfall feature flowing into a small pond, and an in-ground heated swimming pool. The dedicated pool/guest house completes the backyard retreat with its own kitchenette and private bathroom, making it perfect for hosting family and friends. Tucked away on a private cul-de-sac just off New Scotland Road, this home offers privacy while remaining close to everything Albany has to offer. Enjoy walking distance to Capital Hills Golf Course, Academy of the Holy Names, public parks, and community gardens, along with convenient access to major highways. Just minutes from Albany Medical Center, St. Peter's Hospital, Downtown Albany, restaurants, shopping, and more. A rare opportunity to enjoy impressive indoor living, resort-style outdoor amenities, and an exceptional Albany location--all in one property.

22 Olive Tree Lane

$749,900
4 Beds 3 Baths 202623454 MLS
Welcome to this beautiful North Colonie home, perfectly situated on a 1.42 acre lot. This Colonial offers 2,899 sqft of living space, a spacious 4-bedroom, 2.5-baths which combines comfort, functionality, and an ideal location. Step inside to an inviting open layout featuring hardwood floors, a stunning double-sided gas fireplace, and plenty of natural light throughout. The spacious kitchen offers ample cabinetry and counter space, along with a convenient prep sink, making it perfect for both everyday living and entertaining. Upstairs, you will find four generously sized bedrooms, including an expansive primary suite complete with a large private bathroom, his-and-hers closets, and a bonus room over the garage located directly off the primary suite. This versatile additional space is perfect for a home office, sitting room, fitness area, nursery, or additional storage. Brand-new carpeting was installed upstairs in 2026. Outside, enjoy the privacy of a long driveway, an attached 3-car garage, a large backyard, and a Trex deck ideal for relaxing or entertaining. Additional major upgrades include owned solar panels installed in 2025 and a new tankless on-demand hot water system installed in 2026. Conveniently located near North Colonie schools, parks, restaurants, shopping, and major highways, this property offers the space and privacy you've been looking for while keeping everything you need just minutes away. Don't miss the opportunity to make this North Colonie Colonial your new home!

548 Boght Road

$399,900
3 Beds 3 Baths 202623056 MLS
MULTIPLE OFFER DEADLINE - 8/15 at 4:00PM. Known as the Peter Stickles House (c. 1857), this brick home in Schenectady's historic Stockade District bears an official historic plaque and offers nearly 2,900 sqft, 3 bedrooms, 2.5 bathrooms, and beautifully preserved architectural details. Inside, natural sunlight pours through tall windows, highlighting gorgeous hardwood floors, and spacious rooms filled with historic character. Built-in cabinetry, a welcoming library, mudroom with first-floor laundry, and an updated kitchen with granite countertops, abundant storage, and an open layout. An upstairs office offers a quiet space for remote work or study. The walkout basement with interior entry provides additional flexibility and storage. Recent improvements include new central air, water heater, 96% high-efficiency gas furnace, updated plumbing, and smart climate controls. Outside, enjoy a private backyard setting with a deck, detached storage shed, natural gas grill line, included Weber natural gas grill, and perennial gardens attracting butterflies and hummingbirds. Featured on both the Stockade Walkabout and Stockade Garden Tour, this home is located in the Stockade District, a filming location for HBO's The Gilded Age. It's steps from Arthur's Market, community events, and the annual Stockade Villagers' Outdoor Art Show. Located along the Empire State Trail and one block from Riverfront Park, enjoy scenic walking and biking trails along the Mohawk River, plus easy access to Proctors Theatre, downtown restaurants, coffee shops, the Schenectady Greenmarket, and Amtrak service to Albany and New York City. Nearby employers include Union College, Ellis Hospital, GE Vernova, and GE Aerospace, with easy access to Albany, Albany International Airport, and Saratoga Springs. The current owner also operates a registered short-term rental, welcoming guests visiting Union College, Proctors Theatre, and local events.

33 Front Street

$335,000
6 Beds 3 Baths 202622691 MLS
Exceptional Turnkey 3-Family in the Heart of Schenectady's Historic Stockade! Whether you're looking to grow your investment portfolio or live in one unit while your tenants help pay the mortgage, this well-maintained three-family property is an outstanding opportunity. Two of the three units have been tastefully renovated and are fully occupied, generating $2,100 per month in rental income. The spacious 4-bedroom, 1-bath unit is vacant and move-in ready, making it ideal for an owner-occupant or an investor seeking additional rental income. Major updates include new 400-amp electrical service with four new breaker panels, offering peace of mind and long-term value. The property features: Two renovated 1-bedroom, 1-bath apartments rented at $1,100/month and $1,000/month One vacant 4-bedroom, 1-bath apartment with strong rental potential of approximately $1,800/month Projected gross annual rental income of $46,800 when fully occupied Detached 3-car garage Prime location in the highly sought-after Stockade Historic District, just minutes from downtown Schenectady, restaurants, shopping, Rivers Casino, Union College, Ellis Hospital, and major highways. A rare opportunity to own a versatile, income-producing property in one of Schenectady's most desirable neighborhoods. Whether you're an investor looking for solid cash flow or a buyer interested in offsetting your mortgage with rental income, this property offers exceptional value.

6 N College Street

Start Your Search

©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