Kelliekieleyrealty.com Search Results

$700,000

**CAN BE SOLD AS A PACKAGE WITH 558 MADISON AVENUE** Seize a rare opportunity to own 5 units ideally located on the corner of New Scotland and Madison Avenue directly across from Washington Park and Albany Medical Center. This property is an investor or owner-occupier's dream, standing two stories and containing three 1BD/1BA units and two 2BD/1BA units, floor plan included in documents. One unit is occupied and the other four are primed for cosmetic renovations. The building dons historic details such as custom-doors, a beautiful brick facade, hardwood floors, and original moldings. Properties with this character and location are scarce, so act fast to capitalize on this unique chance!

8 Beds ⋅ 5 Baths ⋅ 202621769 MLS

**CAN BE SOLD AS A PACKAGE WITH 558 MADISON AVENUE** Seize a rare opportunity to own 5 units ideally located on the corner of New Scotland and Madison Avenue directly across from Washington Park and Albany Medical Center. This property is an investor or owner-occupier's dream, standing two stories and containing three 1BD/1BA units and two 2BD/1BA units, floor plan included in documents. One unit is occupied and the other four are primed for cosmetic renovations. The building dons historic details such as custom-doors, a beautiful brick facade, hardwood floors, and original moldings. Properties with this character and location are scarce, so act fast to capitalize on this unique chance!

552 Madison Avenue

$959,900

Welcome to 136 Brandon Terrace, a beautifully updated Prescott Woods gem where comfort, style, and everyday convenience make this home as practical as it is beautiful. Tucked into one of Guilderland's most sought-after neighborhoods, this spacious 5-bedroom, 4.5 -bath home offers the kind of layout that truly works for the way people live today. Step inside to a bright, inviting main level featuring a first-floor office--perfect for remote work--along with generous living and dining spaces that flow seamlessly for entertaining. The updated kitchen opens to the family room with exquisite stone fireplace and wet bar, and a cozy sunroom, filling the heart of the home with natural light and year-round warmth. A bedroom with ensuite bathroom, offering privacy for guests completes the first floor. Upstairs, the primary suite is a true retreat with exceptional closet space and its own private sauna, creating a spa-like escape at the end of the day. Three additional bedrooms provide flexibility for guests, hobbies, or multi-generational living. Summer days are meant to be enjoyed in the backyard oasis, complete with an in-ground pool, hot tub and plenty of room to relax, grill, and gather. The basement offers more room to spread out, with great room, cedar closet, wine cellar and full bath. If you've been searching for a home that blends space, comfort, and a touch of luxury, with thoughtful updates making it move in ready, --right in the heart of Guilderland--136 Brandon Terrace is the one you'll want to see.

5 Beds ⋅ 5 Baths ⋅ 202621476 MLS

Welcome to 136 Brandon Terrace, a beautifully updated Prescott Woods gem where comfort, style, and everyday convenience make this home as practical as it is beautiful. Tucked into one of Guilderland's most sought-after neighborhoods, this spacious 5-bedroom, 4.5 -bath home offers the kind of layout that truly works for the way people live today. Step inside to a bright, inviting main level featuring a first-floor office--perfect for remote work--along with generous living and dining spaces that flow seamlessly for entertaining. The updated kitchen opens to the family room with exquisite stone fireplace and wet bar, and a cozy sunroom, filling the heart of the home with natural light and year-round warmth. A bedroom with ensuite bathroom, offering privacy for guests completes the first floor. Upstairs, the primary suite is a true retreat with exceptional closet space and its own private sauna, creating a spa-like escape at the end of the day. Three additional bedrooms provide flexibility for guests, hobbies, or multi-generational living. Summer days are meant to be enjoyed in the backyard oasis, complete with an in-ground pool, hot tub and plenty of room to relax, grill, and gather. The basement offers more room to spread out, with great room, cedar closet, wine cellar and full bath. If you've been searching for a home that blends space, comfort, and a touch of luxury, with thoughtful updates making it move in ready, --right in the heart of Guilderland--136 Brandon Terrace is the one you'll want to see.

136 Brandon Terrace

$1,169,000

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.

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

$899,900

Experience unparalleled living in this stunning, expansive Loudonville home offering generous and well designed living space. Featuring 5 bedrooms and 4.5 baths, this residence perfectly balances sophisticated entertaining areas with casual, relaxed spaces. Featuring an inviting front porch. An open foyer with pristine cherry wood floors. The elegant living room and versatile sitting room (perfect as a formal dining room) feature classic crown molding, columns, striking wood floor with inlay, sparkling light fixtures, and 2 large double windows. Custom French doors open to an informal gathering space stretching across the entire rear of the home. Informal dining room with sliding doors to backyard. A custom white kitchen boasting premium stainless steel appliances, a farmhouse sink, granite countertops, a dining peninsula, and a big walk-in pantry. The family room is anchored by a handsome gas fireplace, framed by distinctive transom windows, and seamlessly connects with the kitchen. Large mudroom with tall custom cabinetry and tile flooring provides access to the 3-car garage, a powder room, and a custom laundry room that doubles as a secondary prep kitchen for gatherings. The upstairs features an elegant owner's suite with double door entry. This sanctuary offers a traditional style bath with double pedestal sinks, a soaking tub and a corner shower. Custom walk-in closet. 4 additional bedrooms share 2 full jack-and-jill style baths. Lower level versatile bonus space is configured for dedicated media, game, office, and gym areas, plus a full bath and ample storage. A custom pergola and quaint wood deck lead to a tastefully designed stone terrace with a built-in firepit, creating a private, all-season backyard sanctuary complete with a bonus side yard court. Impeccably maintained and thoughtfully designed for modern living. 9' ceilings on 1st floor. 2 HVAC zones. Come home to 15 Wildwood today!

5 Beds ⋅ 5 Baths ⋅ 202618917 MLS

Experience unparalleled living in this stunning, expansive Loudonville home offering generous and well designed living space. Featuring 5 bedrooms and 4.5 baths, this residence perfectly balances sophisticated entertaining areas with casual, relaxed spaces. Featuring an inviting front porch. An open foyer with pristine cherry wood floors. The elegant living room and versatile sitting room (perfect as a formal dining room) feature classic crown molding, columns, striking wood floor with inlay, sparkling light fixtures, and 2 large double windows. Custom French doors open to an informal gathering space stretching across the entire rear of the home. Informal dining room with sliding doors to backyard. A custom white kitchen boasting premium stainless steel appliances, a farmhouse sink, granite countertops, a dining peninsula, and a big walk-in pantry. The family room is anchored by a handsome gas fireplace, framed by distinctive transom windows, and seamlessly connects with the kitchen. Large mudroom with tall custom cabinetry and tile flooring provides access to the 3-car garage, a powder room, and a custom laundry room that doubles as a secondary prep kitchen for gatherings. The upstairs features an elegant owner's suite with double door entry. This sanctuary offers a traditional style bath with double pedestal sinks, a soaking tub and a corner shower. Custom walk-in closet. 4 additional bedrooms share 2 full jack-and-jill style baths. Lower level versatile bonus space is configured for dedicated media, game, office, and gym areas, plus a full bath and ample storage. A custom pergola and quaint wood deck lead to a tastefully designed stone terrace with a built-in firepit, creating a private, all-season backyard sanctuary complete with a bonus side yard court. Impeccably maintained and thoughtfully designed for modern living. 9' ceilings on 1st floor. 2 HVAC zones. Come home to 15 Wildwood today!

15 Wildwood Drive

$575,000

FOR INVESTORS: Legal 2-family property offering dual rental income opportunities. Strong demand for short-term and long-term rentals with close proximity to skiing, golf, hiking, and farm-to-table dining. Features include ample storage, a full walk-up attic, brand-new stainless steel appliances, and laundry hookups. Just 2+ hours from NYC, this home is well positioned for a weekend rental audience and makes a solid addition to any investment portfolio. FOR ENTREPRENEURS: Outbuildings provide excellent potential for an artist studio, yoga space, workshop, or other creative use. The legal 2-family configuration offers flexibility for live/work needs. Conveniently located near Albany, Hudson, Windham, and Saugerties—ideal for attracting clients or visitors. Scenic mountain views and access to outdoor recreation further enhance short-term rental appeal. FOR HOMEBUYERS: Two fully equipped living units offer versatile options for those seeking separate living spaces or adaptable layouts. Spacious bedrooms, a primary suite, and enclosed sunrooms provide comfort and privacy. The expansive living room features a wood-burning fireplace that adds warmth and character, while central air and mini-splits ensure year-round comfort. Located in the Greenville School District, which offers the International Baccalaureate Program.

5 Beds ⋅ 5 Baths ⋅ 202617831 MLS

FOR INVESTORS: Legal 2-family property offering dual rental income opportunities. Strong demand for short-term and long-term rentals with close proximity to skiing, golf, hiking, and farm-to-table dining. Features include ample storage, a full walk-up attic, brand-new stainless steel appliances, and laundry hookups. Just 2+ hours from NYC, this home is well positioned for a weekend rental audience and makes a solid addition to any investment portfolio. FOR ENTREPRENEURS: Outbuildings provide excellent potential for an artist studio, yoga space, workshop, or other creative use. The legal 2-family configuration offers flexibility for live/work needs. Conveniently located near Albany, Hudson, Windham, and Saugerties—ideal for attracting clients or visitors. Scenic mountain views and access to outdoor recreation further enhance short-term rental appeal. FOR HOMEBUYERS: Two fully equipped living units offer versatile options for those seeking separate living spaces or adaptable layouts. Spacious bedrooms, a primary suite, and enclosed sunrooms provide comfort and privacy. The expansive living room features a wood-burning fireplace that adds warmth and character, while central air and mini-splits ensure year-round comfort. Located in the Greenville School District, which offers the International Baccalaureate Program.

186 Cty Rte 411

$1,998,000

Sitting gracefully along the Hudson River, this spectacular waterfront estate offers breathtaking panoramic scenery of an unparalleled luxury lifestyle. Beautifully designed, every room captures the property in all its glory. You can immerse yourself in the waterfront views plus views of the gunite infinity pool, tennis court & guest cottage from almost anywhere in the home. The guest house features 3BR's, parking + deck overlooking 300ft of beach front. Features incl gourmet kitchen, 1st flr office+ library. Master suite w/private terrace, large great room, lower level recreation room & more. This is a one of a kind property in Bethlehem School District.

4 Beds ⋅ 5 Baths ⋅ 202617794 MLS

Sitting gracefully along the Hudson River, this spectacular waterfront estate offers breathtaking panoramic scenery of an unparalleled luxury lifestyle. Beautifully designed, every room captures the property in all its glory. You can immerse yourself in the waterfront views plus views of the gunite infinity pool, tennis court & guest cottage from almost anywhere in the home. The guest house features 3BR's, parking + deck overlooking 300ft of beach front. Features incl gourmet kitchen, 1st flr office+ library. Master suite w/private terrace, large great room, lower level recreation room & more. This is a one of a kind property in Bethlehem School District.

248 Van Wies Point Road

$669,900

Expansive, multi-generational living, over 4,000 square feet on a double lot on a quiet cul-de-sac within the award-winning Guilderland School Dist. Recent changes to town zoning law now allows for income rental of existing in law suite. Thoughtfully designed residence offers space, privacy, and professional craftsmanship across three finished levels. Kitchen w/tiled back splash, SS Appliances, island and pantry. Spacious dining room with hw flrs and chair rail provides the perfect setting for gatherings. Multiple living rooms offer endless possibilities. LR 1 is full of natural light. The brick FP with wood stove insert which will heat the house. Light a fire and host game night, movie, or a quiet place to read. LR 2 has a brick FP w\ gas insert providing warmth and comfort. This area leads to the upstairs In-Law suite. The main residence offers 4 bedrooms, 2 full baths,1/2 bath,2 living rooms, a formal dining room and home office. The 2 flr primary suite offers walk in closet, an en-suite bath with tiled shower, double sink and sky lights which brings natural light into this spacious bath. The 2nd flr full bath is exquisitely tiled, jet tub, and dual granite sinks. In-law apartment has its own entrance. The extra wide staircase leads to the in-law living room with custom made built-ins. The in-law sun room is a tranquil retreat with views of the private, tree lined backyard. In-Law full bath with a tiled walk-in shower and dual sink. Full eat in kitchen. Finished basement offers another whole level of living space w/ 1/2 bath. Enjoy the game around the custom made bar. Oversized 2 car garage leads to large mud room with custom made cubbies. Yard backs to forever wild, providing privacy amongst suburban conveniences. Enjoy hiking trails that meander through the woods beside a stream. Stroll streets lined w/old-fashioned Colonial-style lampposts and custom street signs. Walk to shops/restaurants. A true a multi-generational home in a location that cannot be beat.

5 Beds ⋅ 5 Baths ⋅ 202617214 MLS

Expansive, multi-generational living, over 4,000 square feet on a double lot on a quiet cul-de-sac within the award-winning Guilderland School Dist. Recent changes to town zoning law now allows for income rental of existing in law suite. Thoughtfully designed residence offers space, privacy, and professional craftsmanship across three finished levels. Kitchen w/tiled back splash, SS Appliances, island and pantry. Spacious dining room with hw flrs and chair rail provides the perfect setting for gatherings. Multiple living rooms offer endless possibilities. LR 1 is full of natural light. The brick FP with wood stove insert which will heat the house. Light a fire and host game night, movie, or a quiet place to read. LR 2 has a brick FP w\ gas insert providing warmth and comfort. This area leads to the upstairs In-Law suite. The main residence offers 4 bedrooms, 2 full baths,1/2 bath,2 living rooms, a formal dining room and home office. The 2 flr primary suite offers walk in closet, an en-suite bath with tiled shower, double sink and sky lights which brings natural light into this spacious bath. The 2nd flr full bath is exquisitely tiled, jet tub, and dual granite sinks. In-law apartment has its own entrance. The extra wide staircase leads to the in-law living room with custom made built-ins. The in-law sun room is a tranquil retreat with views of the private, tree lined backyard. In-Law full bath with a tiled walk-in shower and dual sink. Full eat in kitchen. Finished basement offers another whole level of living space w/ 1/2 bath. Enjoy the game around the custom made bar. Oversized 2 car garage leads to large mud room with custom made cubbies. Yard backs to forever wild, providing privacy amongst suburban conveniences. Enjoy hiking trails that meander through the woods beside a stream. Stroll streets lined w/old-fashioned Colonial-style lampposts and custom street signs. Walk to shops/restaurants. A true a multi-generational home in a location that cannot be beat.

573 Jefferson Court

$1,950,000

Set within the coveted Shaker Bay neighborhood, this distinguished residence reflects a high level of craftsmanship and thoughtful design, with an emphasis on scale, light and seamless flow. An impressive great room with soaring ceilings and a statement stone fireplace anchors the home, opening effortlessly to a well appointed kitchen and dining area crafted for both everyday living and elevated entertaining. The private first floor office offers a quiet workspace, while the main level primary suite provides a well appointed retreat with a spacious full bathroom and elevated finishes. A generously sized mudroom enhances everyday functionality without compromising style. The walk out lower level is designed for versatility, featuring a recreation room, bedroom and full bath, perfect for extended living or guests. Outdoors, the setting is equally compelling with an expansive deck overlooking the gorgeous grounds, a beautifully designed in ground pool, and a stone patio with a built in gas grill creating a true outdoor escape. Some major updates include: Furnace, HW Heater & Deck/Hardscaping all 2024, Pool liner 2025, Pool pump & filter 2023 and Roof 2019. Complete with a 3 car garage and access to neighborhood tennis courts, this home offers a rare balance of privacy, convenience and understated sophistication.

4 Beds ⋅ 5 Baths ⋅ 202616731 MLS

Set within the coveted Shaker Bay neighborhood, this distinguished residence reflects a high level of craftsmanship and thoughtful design, with an emphasis on scale, light and seamless flow. An impressive great room with soaring ceilings and a statement stone fireplace anchors the home, opening effortlessly to a well appointed kitchen and dining area crafted for both everyday living and elevated entertaining. The private first floor office offers a quiet workspace, while the main level primary suite provides a well appointed retreat with a spacious full bathroom and elevated finishes. A generously sized mudroom enhances everyday functionality without compromising style. The walk out lower level is designed for versatility, featuring a recreation room, bedroom and full bath, perfect for extended living or guests. Outdoors, the setting is equally compelling with an expansive deck overlooking the gorgeous grounds, a beautifully designed in ground pool, and a stone patio with a built in gas grill creating a true outdoor escape. Some major updates include: Furnace, HW Heater & Deck/Hardscaping all 2024, Pool liner 2025, Pool pump & filter 2023 and Roof 2019. Complete with a 3 car garage and access to neighborhood tennis courts, this home offers a rare balance of privacy, convenience and understated sophistication.

35 Shaker Bay Road

$995,000

Stunning new construction home to be built, offering over 3,600 sq ft of thoughtfully designed living space. This one-of-a-kind residence features a first-floor master suite and a truly unique custom floor plan--no duplicates, no repeats, and unmatched architectural character. Located in the highly regarded Guilderland School District, this home provides exceptional convenience just minutes from Crossgates Mall, Costco, restaurants, shopping, and major highways for an easy commute. A rare opportunity to own a custom-built home in a prime Capital Region location. ***The photos are renderings only to depict future build***

4 Beds ⋅ 5 Baths ⋅ 202612867 MLS

Stunning new construction home to be built, offering over 3,600 sq ft of thoughtfully designed living space. This one-of-a-kind residence features a first-floor master suite and a truly unique custom floor plan--no duplicates, no repeats, and unmatched architectural character. Located in the highly regarded Guilderland School District, this home provides exceptional convenience just minutes from Crossgates Mall, Costco, restaurants, shopping, and major highways for an easy commute. A rare opportunity to own a custom-built home in a prime Capital Region location. ***The photos are renderings only to depict future build***

1 Torrin Lane

$599,000

Mixed-Use Opportunity in Historic Albany! Welcome to 204 Lancaster Street, a well-located mixed-use building offering flexibility and versatility. This historic property features a ground-floor retail space with strong street presence, currently operated as a tailor shop, and suitable for a wide variety of commercial uses. Above the storefront are two residential apartments. Situated in a vibrant Albany neighborhood with steady foot and vehicle traffic, this property is ideal for investors or owner-occupants seeking a combination of commercial and residential use. The property has seen significant recent capital improvements totaling over $25,000, including a new commercial central air conditioning system, a new rubber roof, and a brand new hot water tank -- providing buyers with peace of mind and minimal near-term capital expenditure requirements. A unique opportunity to own a versatile, well-maintained building in one of Albany's established corridors. Tailor inventory can be purchased separately or included with the sale of the property.

2 Beds ⋅ 5 Baths ⋅ 202612819 MLS

Mixed-Use Opportunity in Historic Albany! Welcome to 204 Lancaster Street, a well-located mixed-use building offering flexibility and versatility. This historic property features a ground-floor retail space with strong street presence, currently operated as a tailor shop, and suitable for a wide variety of commercial uses. Above the storefront are two residential apartments. Situated in a vibrant Albany neighborhood with steady foot and vehicle traffic, this property is ideal for investors or owner-occupants seeking a combination of commercial and residential use. The property has seen significant recent capital improvements totaling over $25,000, including a new commercial central air conditioning system, a new rubber roof, and a brand new hot water tank -- providing buyers with peace of mind and minimal near-term capital expenditure requirements. A unique opportunity to own a versatile, well-maintained building in one of Albany's established corridors. Tailor inventory can be purchased separately or included with the sale of the property.

204 Lancaster Street

$649,900

Prime mixed-use building in Albany's vibrant Center Square neighborhood. Over 3,100 sq ft with a street-level commercial space (rented at $2,200/mo) approved for a variety of uses. Existing equipment provides a great starting point for food service operation. Three well-maintained residential units above generate $3,350/mo. One unit is a 1BR facing Lark St; another offers skyline views and private rooftop access. The top-floor unit features 3 bedrooms, 2 full baths, and in-unit laundry. Rare 2-car garage off Spring St for parking or deliveries. Gross annual income of $66,600. Steps from shops, restaurants, and Washington Park. Whether you're looking to expand your investment portfolio or establish a business in a high-visibility, high-foot-traffic location, this one is worth exploring.

5 Beds ⋅ 5 Baths ⋅ 202523509 MLS

Prime mixed-use building in Albany's vibrant Center Square neighborhood. Over 3,100 sq ft with a street-level commercial space (rented at $2,200/mo) approved for a variety of uses. Existing equipment provides a great starting point for food service operation. Three well-maintained residential units above generate $3,350/mo. One unit is a 1BR facing Lark St; another offers skyline views and private rooftop access. The top-floor unit features 3 bedrooms, 2 full baths, and in-unit laundry. Rare 2-car garage off Spring St for parking or deliveries. Gross annual income of $66,600. Steps from shops, restaurants, and Washington Park. Whether you're looking to expand your investment portfolio or establish a business in a high-visibility, high-foot-traffic location, this one is worth exploring.

197 Lark Street

Kellie Kieley Realty, LLC

Search

Resources

About