Refine Search
Sort by
$428,000
3 Beds 3 Baths 202621905 MLS
Welcome to 142 Fernbank in Delmar! Inside, bright and open living spaces invite you to settle in, while the granite kitchen with centre island naturally becomes the heart of daily life. Two bedrooms and a full bath on the first floor mean everyday living can stay comfortably on one level. Upstairs, a private primary suite option with full bath offers a welcome retreat. And below, a full dry basement holds genuine potential for additional living space down the road. The big decisions have already been made for you, roof, natural gas conversion, Trex deck, driveway, replacement windows, and more, all completed. Step outside to a spacious composite deck and fenced backyard made for backyard games or quiet evenings. Grab coffee and stroll to Four Corners, spend Saturday mornings at the Delmar Farmers Market, hop on the Rail Trail, or walk to the library or Hamagrael Elementary. Top-rated Bethlehem schools complete the picture. The bones are exceptional. The location is walkable. The neighborhood is established. All that's waiting is the right buyer. *Some listing photos have been AI enhanced and/or virtually staged.

142 Fernbank Avenue

$254,900
3 Beds 1 Baths 202621865 MLS
Welcome home to this tastefully updated bungalow at 17 Tremont St, in a convenient Albany location. Inside, you'll find an enclosed front porch, bright living room, dining room, an updated kitchen featuring stainless steel appliances & butcher block countertops -- perfect for entertaining or everyday living. Three comfortable bedrooms & a renovated bathroom round out the main living space, while a back enclosed porch provides additional flex space for a home office, mudroom, or sunroom. This home has been thoughtfully updated throughout, including: Updated windows for improved energy efficiency New flooring throughout Renovated bathroom Fresh paint throughout New boiler (2023) Storage won't be an issue with the full attic, offering plenty of room for all your seasonal items and extras. Outside, enjoy a spacious .14-acre lot with generous side & back yard space. The paved driveway offers off-street parking for up to 3 vehicles. Location: just 11 minutes to Albany International Airport, 13 minutes to the NYS Capitol in the heart of downtown Albany, and 7 minutes to Colonie Center -- putting shopping, dining, travel, and city life all within easy reach. Bonus for investors: this home has a track record as an Airbnb and mid-term rental, offering fantastic income potential for the next owner.

17 Tremont Street

$869,000
4 Beds 6 Baths 202621767 MLS
Rarely does a home offer this level of space, privacy, and resort-style living in such a convenient Guilderland location. Set in the desirable Vale of Normanskill neighborhood, 257 Longhouse Lane is an impressive brick Colonial offering 4 bedrooms, 3 full baths, and 2 half baths, with a thoughtfully designed layout for comfortable everyday living and memorable entertaining. The main level features formal living and dining rooms, a custom eat-in kitchen with an island and new appliances, a generous family room with a wood-burning fireplace, and dedicated office or library space. The finished, heated basement provides exceptional flexibility with space for a theater area, game room, bar setup, and additional recreation or entertaining areas. A true highlight is the private indoor swimming pool complex, complete with a Jacuzzi and sauna for year-round enjoyment through every Northeast season. The exceptional outdoor spaces create a private resort-style setting for relaxation and entertaining, featuring a fenced and landscaped 0.45-acre lot, grand patio, built-in fire pits, outdoor kitchen, deck, and multiple gathering areas. Select high-quality indoor and outdoor furnishings are also included at no additional cost. Additional features include a paved driveway, 2-car garage, and generous off-street parking. Conveniently located near Western Avenue/Route 20, NY-155, Crossgates Mall, shopping, dining, schools, parks, and major commuter routes, this remarkable home offers a rare combination of space, amenities, privacy, and accessibility. Schedule your private showing today.

257 Longhouse Lane

$368,000
3 Beds 3 Baths 202621657 MLS
Located within Albany's historic Mansion District, just steps from the Governor's Mansion and minutes from downtown offices, this well-maintained 3 unit property offers an exceptional investment opportunity in one of the city's most recognizable neighborhoods. Building features include hardwood floors, ceramic tile, stainless steel appliances, newer boiler, new hot water tank, plus each unit has a washer/dryer and a bonus room (office/storage/etc) - amenities tenants appreciate! Just minutes from downtown Albany and close to a neighborhood park, this location adds to the property's strong investment appeal. Well-maintained, well-located, and well-equipped, this is an excellent addition to any investment portfolio! *Pictures show vacant units but all apartments are rented.

175 Eagle Street

$500,000
7 Beds 4 Baths 202621537 MLS
Whether you're looking for multigenerational living, hoping to offset your mortgage with rental income or searching for an investment property with exceptional income potential, this versatile South Colonie property has so much to offer. Located in the South Colonie School District with low Colonie taxes, this rare three-family home offers flexibility that's hard to find. The spacious owner's unit features 3 bedrooms and 1.5 bathrooms, while the additional apartments include a 2-bedroom unit and a 1-bedroom unit. There's also a flex bedroom that could easily be incorporated into any of the units for additional living space or rental value. The large, partially finished garden-level basement offers exciting potential for additional finished living space or the possibility of creating a future fourth unit (subject to any required approvals and permits). Outside, you'll find a massive, private backyard with a patio that's perfect for relaxing, entertaining or giving tenants plenty of outdoor space to enjoy. Parking and storage are a breeze with both an attached one-car garage and a detached one-car garage. The detached garage has both electricity and water run to it. Conveniently located with easy access to a major bus route, shopping, restaurants and everyday amenities, this property combines location, flexibility and long-term value. Whether you're planning to live in one unit while generating income from the others or expanding your investment portfolio, this is a property packed with possibilities. *Photos limited for tenant privacy.*

2187 Central Avenue

$1,149,000
4 Beds 5 Baths 202621305 MLS
Custom-built executive ranch with 4,000+/- sq. ft. above grade, set privately on over 6 acres in North Colonie schools. Impressive stone exterior, circular driveway, covered entry, and beautiful landscaping create exceptional curb appeal. Inside, soaring ceilings, hardwood floors, custom millwork, oversized windows, and an open floor plan offer a dramatic yet comfortable feel. The great room features vaulted ceilings, a stunning stone fireplace, and walls of windows overlooking the private grounds. The gourmet kitchen offers abundant custom cabinetry, stainless appliances, breakfast bar, and seamless flow to the dining and living areas. The magnificent finished lower level expands the home with a custom bar, entertainment space, bedroom, bathroom, weight room, and excellent potential for an in-law suite or guest retreat. Enjoy outdoor living from the rear porch, patio, and gazebo surrounded by peaceful wooded privacy. A rare luxury ranch offering space, privacy, craftsmanship, and incredible entertaining options. 3D tour attached.

268 Boght Road

$239,900
6 Beds 2 Baths 202621119 MLS
BOM at no fault to seller. Well maintained 2 family duplex available for the first time in over 32 years. Each unit offers 3 bedrooms and 1 full bathroom with spacious room sizes and functional layouts throughout. The vacant upper unit features hardwood floors and is move in ready, making it an excellent opportunity for an owner occupant or investor seeking market rent. The enclosed sunroom provides additional living space and could potentially be converted into a fourth bedroom, office, or flex space. The first floor is occupied by a long term tenant of more than 25 years currently paying $1,000 per month, providing immediate rental income. Separate utilities help keep operating expenses down. A private backyard adds to the property's appeal. Conveniently located just minutes from I-90, I-787, downtown Albany, hospitals, colleges, restaurants, shopping, and major employers, offering easy access throughout the Capital Region.

354 Second Avenue

$795,900
5 Baths 202620599 MLS
An extraordinary commercial asset emerges at 160 Creamery Rd, Greenville, NY. Seated on 17.40+ pristine, country-club-style acres, this iconic property features a historically significant hospitality venue that has operated successfully for over 81 consecutive years. Nestled on a tranquil, low-traffic side road, the estate seamlessly pairs commercial scalability with an idyllic country lifestyle. Turnkey Facility: The offering includes the complete physical real estate, land, and an extensive inventory of Furniture, Fixtures, and Equipment (FF&E). Waterfront & Acreage: The 17.40-acre parcel showcases a magnificent stocked pond, an expansive outdoor dining deck designed for high-capacity seating, lush destination landscaping, and over 450+ linear feet of private, direct frontage along Basic Creek, located on the opposite side of the road from the restaurant. On-Site Owner's Residence: Maximizing operational efficiency, the property includes a spacious, beautifully appointed 2-bedroom private residence--ideal for an owner-operator or on-site manager. The Strategic Opportunity: Please note: The existing business entity itself is not for sale and remains a community staple. The offering is strictly for the premium real estate and physical infrastructure. This provides a clean slate for an ambitious restaurateur, hospitality group, or developer to execute a new concept. The property's spatial layout and natural aesthetics make it an elite candidate for transformation into a premier destination farm-to-table restaurant, a high-margin wedding venue, or an exclusive special occasion event facility. Do not miss the chance to control one of the most prominent, long-standing hospitality footprints in the Greenville/Capital Region submarket. Schedule your private, qualified tour today.

160 Creamery Road

$699,900
4 Beds 2 Baths 202620553 MLS
Welcome to 378 County Route 354 in Preston Hollow, NY where history, character, land, and opportunity come together. This remarkable 1850 farmhouse offers the charm buyers search for in a historic home, with many original features still preserved while the current owner has completed numerous updates and improvements. Like many treasured old farmhouses, there are still projects to continue, offering the perfect opportunity for someone who appreciates the craftsmanship, story, and timeless beauty these homes provide. Inviting 4-bedroom farmhouse features a warm and welcoming kitchen perfect for gathering, cooking, and creating memories. The charming sitting area off the kitchen with a wood stove provides the ideal place to relax with a book, enjoy morning coffee, or create your own cozy retreat space.Adding even more value is the newly built 30x32 outbuilding, originally designed and used as a yoga retreat space. With electric already in place, the possibilities are wide open imagine a studio, creative workspace, guest retreat, home business, short-term rental opportunity, or your own private escape. (Additional utilities could potentially be added.Set on approximately 46.4 acres of stunning countryside, this property offers a beautiful mix of open fields, wooded areas, mountain views, and endless possibilities. Whether you dream of creating a hobby farm, bringing animals, growing your own crops, enjoying outdoor recreation, or simply escaping the noise of everyday life located close to local farms, farm stands, shopping, restaurants, towns, and outdoor destinations including nearby ski areas, this property combines peaceful country living with convenience.A historic farmhouse, acreage, views, additional building, incredible potential, and taxes only $3,500 annually Come love it, continue to work on it and make it yours for generations to come. Some homes are built others become part of your story, your story begins here. OPEN HOUSE 6/28/26 10 TO 1PM.

378 County Route 354

$649,900
4 Beds 4 Baths 202620221 MLS
Opportunity awaits as this gorgeous recently renovated 3-4 bedroom 2 full 2 partial bath Delmar home situated on an estate like setting with a desirable first floor primary bedroom suite hits the market! This home has an open floor plan and is filled with charm and character throughout! Features include a breathtaking sun filled huge family room with towering vaulted ceiling with skylights and dramatic fireplace! The large eat in gourmet kitchen boasts a large island, quartz countertops, pull-out cabinets and brand new stainless steel double wall oven! The first floor primary bedroom suite features a sharp newly renovated primary bath with double vanity, stand up ceramic shower and soaking tub! There's also a huge walk in closet in the primary! Spacious classy dining room with vaulted ceiling and skylights, living room with an abundance of windows, first floor laundry room with sink, large entry, sharp second floor remodeled bathroom, loft with office area, newly refinished beautiful gleaming hardwood floors, central air! Large basement with two finished bonus rooms and bathroom! Two car oversized garage! Impressive grounds on nearly acre lot with circular driveway! Lots of recent upgrades and improvements here. Brand new central air system! This is an absolute must see with Bethlehem schools!

758 Feura Bush Road

$949,800
6 Beds 6 Baths 202619915 MLS
Come Explore .... 5 Normandy Square, Guilderland, NY 12009 -- tucked away on a manicured cul-de-sac in the Guilderland School District, this custom home has all the ''I wants'' and more. Much more! Truly needs to be seen to be appreciated. From the moment you enter the soaring two-story foyer-great room, the double-trayed 18' LED ceiling and floor-to-ceiling windows and fireplace tell you this isn't your average Albany County home. The great room opens to a gourmet kitchen with a massive island, beverage cooler, and pot filler. The breakfast nook and transitional sunroom lead to an expansive covered patio with a woodburning lodge fireplace, raftered ceilings, paddle fans, an all-weather TV, and a natural-gas Weber grill kitchen -- built for effortless, entertaining in the shadows of Thatcher Park. Less than 100 feet away sits the most flexible space of all: a 40'x60' (2,600+ sq ft) accessory dwelling unit with potential for recreation center/small business headquarters, or even light manufacturing. Could be used for car storage, a golf simulator, a theatre, dance studio, it is a blank slate. The ADU includes a 2BR/1.5BA apartment, ideal for multigenerational living, guests, or more offices for a home-based business. The 3,781 sq ft, natural-light-filled 4BR/3.5BA main house has a first-floor primary suite and 3-car garage. Combined: over 5,500 sq ft, 6 bedrooms, 4 full and 2 half baths, newer mechanicals, and unparalleled flex space near Costco, Hannaford, and all Guilderland/Altamont has to offer. This is the unicorn -- that unique Altamont, NY property you've been searching for. Stop by fall in love and say ''AHHH'' -- you've arrived home.

5 Normandy Square

$499,400
3 Beds 3 Baths 202619676 MLS
To Be Built. Welcome Home to Meadowdale Estates, a maintenance free community conveniently located in the Town of Colonie, proudly presented by Trojanski Custom Builders and featuring outstanding amenities such as a 9' finishable basement with egress window, granite and quartz selections for your kitchen, high quality cabinetry, gas fireplace, wide plank engineered hardwood floors, custom paver walkway, fiberglass door, first floor Primary Suite, and the option to add a second Primary Suite upstairs in the unfinished bonus room, if you choose! Enjoy the convenience of maintenance free living at Meadowdale Estates! Photos are for reference purposes and may be a different floor plan or have varying options. An agent is related to builder

18 Priddle Lane

$2,450,000
202619191 MLS
Rare find! Completely renovated 11 years ago, this incredible building is fully rented and features 14 luxury apartments all with their own unique architectural details, and one large retail space with frontage on Washington Avenue, plus a large unfinished basement with even more investment potential. All apartments have hardwood floors, granite, dishwashers, private laundry, their own gas furnace and central air, hot water heater and electric panel. Large storage rooms for tenants both up and down. Shared lounge or gym space. Accessible lift to second floor. Secure entrances and lobby with intercom & updated security system. Potential rentable basement space up to fire code. Extremely attractive assumable Freddie Mac mortgage available until Dec. 31, 2029. Inquire for more details.

260 Washington Avenue

$460,000
3 Beds 3 Baths 202618492 MLS
Experience maintenance free living at this beautifully appointed Bryn Mawr residence. Designed with an open floor plan, the home features soaring ceilings and expansive windows that fill the space with natural light. The eat in kitchen offers granite countertops, a large center island and stainless steel appliances, seamlessly opening to the family room with a gas fireplace. Plus, there is a first floor laundry room. The primary suite provides a comfortable retreat with a private bath featuring a double granite vanity, tiled shower and large walk in closet with built ins. The lower level adds additional storage space, while the back deck and 2 car attached garage enhance everyday convenience. Recent updates include dishwasher and microwave (2026), washer and dryer (2025). Ideally located just minutes to area hospitals, restaurants and shops.

4 Bryn Mawr Court

$579,900
4 Beds 6 Baths 202618260 MLS
Sprawling, spacious, versatile & uniquely individual 4BR, 5.5BA custom ranch-style home in desirable Sage Hill. Boasting over 3,500 sf of living space. Situated on nearly an acre & framed by mature trees, this property offers privacy & a peaceful backyard with a deck & patio to relax on. The original wing features a welcoming slate floor foyer. Large living room with beautiful bay window, handsome fireplace & built-ins. Bright dining room with large picture window. Country kitchen with ample cabinetry & prep area. Cozy corner breakfast area. Pantry/mudroom & half bath adjacent to the entrance from the 2 car side load garage. Original primary with ensuite bath. Convenient hall bath. Music room. Walkout lower level with recreation room, flex space & full bath complete the traditional house. A wide, bright hallway with a cozy sitting area & an atrium door bridges the original home to the expansive newer wing. Two additional bedrooms share a full bathroom with double sinks. A separate laundry room is strategically placed nearby. The private owner's suite is located at the end of the addition with a walk-in closet & a calming bathroom equipped with a soaking tub and separate standalone shower. Second-floor loft lends itself perfectly to a home office, studio or playroom. An unfinished walkout basement complete the modern addition. An established neighborhood, great location and award winning schools complete the package. A very unique property!

6 Sage Hill Lane

$1,499,900
4 Beds 4 Baths 202618087 MLS
Welcome to an exceptional equestrian estate set on 7 picturesque acres, thoughtfully designed for both horse & rider. This unique property offers outstanding facilities, including a beautifully maintained 8-stall barn featuring fans in each stall & 2 heated stalls, a heated tack room, & oversized wash area. An impressive indoor riding arena w: a new roof in 2024, regulation dressage dimensions, 8-foot interior walls & premium GGT fiber footings for superior performance-- providing year-round comfort, functionality, & training capability. The property features generous pastures & turnout areas w a new all steel Buckley fence w concrete posts along w exceptional riding & training facilities. Additionally, the property is equipped w a commercial-grade generator & a comprehensive camera system throughout the estate, providing added peace of mind along with reliable safety & security for both horses & property year-round. The home itself has been extensively updated w countless improvements throughout the interior & exterior, including all new architectural grade windows w hidden screens, a completely gutted & beautifully redesigned kitchen featuring an iconic AGA stove & Sub-zero refrigerator, new lighting throughout, custom built fireplace and hearth, updated bathrooms & freshly painted interior & exterior spaces. A stunning rear heated porch w blue stone patio addition creates the perfect setting for entertaining or relaxing while overlooking the property, complete with a WiFi-controlled Lutron lighting system for modern convenience & ambiance. For anyone seeking a private horse property w premium features. Whether you are riding competitively or simply embracing the equestrian lifestyle, this estate combines practicality, comfort, & versatility in a truly special setting. A rare opportunity to own a turnkey horse property w exceptional infrastructure, scenic surroundings, & endless potential for both personal enjoyment & professional use

145 Bullock 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