$499,900
PENDING $50K PRICE DROP

Estimated payment $3,674/month

Total Views 134,211
4 Beds
2 Baths
2,760 Sq Ft
$181 Price per Sq Ft

Highlights

  • Above Ground Pool
  • View of Trees or Woods
  • Deck
  • Red Mill School Rated A
  • 0.81 Acre Lot
  • Private Lot

About This Home

Live side-by-side with the flexibility today's lifestyles require in this thoughtfully designed twin in-law home featuring two separate 2-bedroom, 1-bath units for a combined total of 4 beds & 2 full baths over 2,760 sq ft. This purpose-built legal in-law residence offers ADA compliant one-level living with ramp accessibility, creating comfort, independence, and ease for multigenerational living under one roof. Make a grand entrance down the circular driveway and discover a tucked-away retreat just 2 minutes to Regeneron and only 10 minutes to downtown Albany. Sip your coffee on the wraparound mahogany porch as you watch the world go by in this peaceful setting surrounded by lush lawn, gardens, and mature trees. Inside you'll feel the openness created by cathedral ceilings and sunlight streaming through a multitude of windows. Gather together in the modern open floor plan, where stunning inlaid hardwood floors and custom tile add warmth and character throughout. Whip up memorable meals in the gorgeous eat-in chef's kitchen featuring granite counters, a center island, and generous prep space. Laundry day is a breeze with the convenient first-floor laundry. Grill & chill on the expansive deck overlooking the level, private backyard. Cool off in the above-ground pool with a new pump (2025). Imagine the possibilities in the huge basement that is ready to be finished into even more living space. Enjoy year-round comfort with a newer furnace and central A/C (2022), while solar panels help reduce energy costs and increase efficiency. HW tank (2023). Highly ranked East Greenbush Schools. Must show valid prequalification letter prior to scheduling a private showing.

Listing Agent

Jenn Baniak-Hollands

KW Platform License #10301218622 Listed on: 05/07/2026

KW Platform

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $10,229

Year Built

  • Built in 2003

Lot Details

  • 35,284 Sq Ft Lot
  • Landscaped
  • Private Lot
  • Wooded Lot
  • Garden

Home Design

  • Ranch Style House
  • Shingle Roof
  • Vinyl Siding
  • Asphalt

Interior Spaces

  • 2,760 Sq Ft Home
  • Cathedral Ceiling
  • Paddle Fans
  • Sliding Doors
  • Living Room
  • Dining Area
  • Den
  • Views of Woods

Kitchen

  • Eat-In Kitchen
  • Range
  • Microwave
  • Dishwasher
  • Kitchen Island

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Bathroom on Main Level
  • 2 Full Bathrooms

Laundry

  • Laundry on main level
  • Washer and Dryer

Unfinished Basement

  • Basement Fills Entire Space Under The House
  • Exterior Basement Entry
  • Sump Pump

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Parking

  • 6 Parking Spaces
  • Circular Driveway
  • Off-Street Parking

Accessible Home Design

  • Accessible Full Bathroom
  • Accessible Kitchen
  • Accessible Hallway
  • Customized Wheelchair Accessible
  • Accessible Doors
  • Accessible Approach with Ramp

Eco-Friendly Details

  • Solar owned by seller

Outdoor Features

  • Above Ground Pool
  • Deck
  • Wrap Around Porch
  • Shed

Schools

  • Columbia High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • 200+ Amp Service
  • Gas Water Heater
  • Grinder Pump
  • Cable TV Available

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Legal Lot and Block 1.000 / 15
  • Assessor Parcel Number 382400 154.4-15-1

Home Details

Home Type

Single Family

Est. Annual Taxes

$10,229

Year Built

Built in 2003

Lot Details

0.81 Acres

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Accessibility: Customized Wheelchair Accessible, Accessible Doors, Accessible Full Bath, Accessible Kitchen, Accessible Approach with Ramp, Accessible Hallway(s)
  • Year Built: 2003
  • Directions: RT 20 to Ridge Road, right onto Neptune
  • Above Grade Finished Sq Ft: 2760.0
  • Architectural Style: Ranch
  • Financial Details General Taxes: 4099.0
  • General Taxes Description: Estimated
  • Financial Details School Taxes: 6130.0
  • School Taxes Description: Estimated
  • Fuel Cost Description Fuel Cost: 136
  • Green Power: Solar
  • Lot Size Acres: 0.81
  • New Construction: No
  • Full Bathroom Level: First
  • Subdivision Name: Select One
  • Levels: One
  • Power Production Type: Photovoltaics
  • Special Features: VirtualTour

Interior Features

  • Flooring: Carpet, Ceramic Tile, Hardwood
  • Basement: Unfinished, Full, Exterior Entry, Sump Pump
  • Interior Amenities: Walk-In Closet(s), Cathedral Ceiling(s), Grinder Pump, Paddle Fan, Eat-in Kitchen, Kitchen Island
  • Appliances: Range, Refrigerator, Dishwasher, Microwave, Washer/Dryer, Gas Water Heater
  • Full Bathrooms: 2
  • Total Bedrooms: 4
  • Door Features: Sliding Doors
  • Living Area: 2760.0
  • Other Equipment: Grinder Pump
  • Bedroom Level: First
  • Den Level: First
  • Kitchen Level: First
  • Living Room Level: First
  • Bathroom Levels Full Bathroom 1: 1st
  • Bathroom Levels Full Bathroom 2: 1st
  • Fireplace: No
  • Attic Features: Hatch
  • Dining Room Type: Dining Area
  • Interior Features: Walk-In Closet(s), Cathedral Ceiling(s), Grinder Pump, Paddle Fan
  • Kitchen Features: Eat-in Kitchen, Kitchen Island

Exterior Features

  • Roof: Asphalt, Shingle
  • Construction Type: Vinyl Siding
  • Fencing: None
  • Other Structures: Shed(s)
  • Patio And Porch Features: Porch, Deck, Composite Deck, Pressure Treated Deck, Covered, Wrap Around
  • Pool Features: Above Ground
  • View: Trees/Woods
  • Waterfront: No

Garage/Parking

  • Parking Features: Off Street, Circular Driveway
  • Attached Garage: No
  • Total Parking Spaces: 6.0
  • Property Detail:Parking YN: Yes

Utilities

  • Utilities: Cable Available
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Electric: 200+ Amp Service, Circuit Breakers, Photovoltaics Seller Owned
  • Heating: Natural Gas, Forced Air
  • Laundry Features: Main Level, Laundry Closet
  • Security: Carbon Monoxide Detector(s), Smoke Detector(s)
  • Water Source: Public
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Association: No

Schools

  • Junior High Dist: East Greenbush

Lot Info

  • Lot Features: Landscaped, Private, Wooded, Garden
  • Parcel #: 382400 154.4-15-1
  • Lot Size Sq Ft: 35283.6

Tax Info

  • Tax Annual Amount: 10229.0
  • Tax Block: 15
  • Tax Lot: 1.000

MLS Schools

  • HighSchool: Columbia

3D Interior and Exterior Tours

Floorplans

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $11,001 $573,000 $65,500 $507,500
2024 $11,001 $355,800 $59,000 $296,800
2023 $10,303 $355,800 $59,000 $296,800
2022 $9,462 $333,000 $59,000 $274,000
2021 $9,329 $333,000 $59,000 $274,000
2020 $7,395 $333,000 $59,000 $274,000
2019 $8,398 $333,000 $59,000 $274,000
2018 $8,398 $333,000 $59,000 $274,000
2017 $9,133 $276,000 $65,500 $210,500
2016 $5,534 $244,100 $65,500 $178,600
2015 -- $244,100 $65,500 $178,600
2014 -- $244,100 $65,500 $178,600
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft Prior Sale
08/03/2026 08/03/26 Pending -- -- --
06/16/2026 06/16/26 Price Changed $499,900 -4.8% $181 / Sq Ft
06/03/2026 06/03/26 Price Changed $524,900 -4.5% $190 / Sq Ft
05/07/2026 05/07/26 For Sale $549,900 +69.2% $199 / Sq Ft
09/06/2016 09/06/16 Sold $325,000 0.0% $118 / Sq Ft View Prior Sale
07/03/2016 07/03/16 Pending -- -- --
05/22/2016 05/22/16 For Sale $325,000 -- $118 / Sq Ft
Source: Global MLS

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Warranty Deed -- --
Deed $325,000 Richard Miller
Interfamily Deed Transfer -- Andrew Jacobs
Interfamily Deed Transfer -- --
Interfamily Deed Transfer -- --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Loan Amount Loan Type
Previous Owner $227,500 Unknown
Previous Owner $227,500 New Conventional
Previous Owner $161,500 Unknown
Source: Public Records

About the Listing Agent

Jenn Baniak-Hollands

KW Platform

(518) 405-6560

Section Image

I could tell you about me, but first I'd rather talk about you – about your plans for the future, where you would like to go and how I can help you get there, about your home, so I can market it to sell for the highest price possible, and about your goals for real estate investment and how we can achieve them together.

I am a "realtorpreneur" with a passion for marketing & building relationships. I have sold 500+ homes since 2016. I love the Capital District - where my British husband

Jenn's Other Listings

  • 796 Feura Bush Rd, Delmar, NY 12054

    $474,900

    • 6 Beds
    • 3 Baths
    • 2,760 Sq Ft
    • 796 Feura Bush Rd
    • Delmar, NY

    *Open Sat 9/19 from 11a - 1p* Big on space and wonderfully private, this expanded 6-bedroom Delmar home gives everyone room to spread out while forever-wild woods create a peaceful natural backdrop next door. Enjoy a layout made for multigenerational living, with 3 bedrooms and 2 full baths on the first floor, plus 3 more bedrooms and a full bath upstairs. Welcome guests into the formal living

    Jenn Baniak-Hollands KW Platform

    Section Image
  • 95 Meadowland St, Delmar, NY 12054

    $574,900 Pending

    • 5 Beds
    • 3.5 Baths
    • 2,552 Sq Ft
    • 95 Meadowland St
    • Delmar, NY

    *Open House cancelled * Live every day like the weekend at this spacious 5 bed, 3.5 bath side hall Colonial with an incredible basement home theater on an oversized lot tucked in the shade and privacy of mature trees just a few blocks to Delmar's 4 corners. Open the door to continuous hardwood floors and an open flowing layout between the living room, dining room and kitchen. Whip up delicious

    Jenn Baniak-Hollands KW Platform

    Section Image
  • 40 Willow Dr, Delmar, NY 12054

    $725,000 Pending

    • 4 Beds
    • 2.5 Baths
    • 2,626 Sq Ft
    • 40 Willow Dr
    • Delmar, NY

    Find the Delmar lifestyle you've been looking for with cul-de-sac living and an epic backyard at this 4 bed, 2.5 bath colonial with over $150,000 in recent updates. Arrive home to lush landscaping, a wide front porch accented by polymer ''stone'' siding, and Govee LED lighting that adds a welcoming glow to the front and back. Whip up delicious meals in the expansive kitchen with quartz counters,

    Jenn Baniak-Hollands KW Platform

    Section Image
  • 23 Fernwood Dr, Albany, NY 12211

    $499,900 $50K PRICE DROP

    • 5 Beds
    • 3 Baths
    • 1,842 Sq Ft
    • 23 Fernwood Dr
    • Albany, NY

    New Price! Ask about the recent improvements to this beauty. Timeless mid-century modern living at this tucked-away 5 bedroom, 3 full bath spacious split level home on a quiet street in Loudonville. Arrive hone to the curb appeal of a lush lawn and charming brick & stone exterior. Whip up delicious meals in the stylish kitchen with quartz counters and newer stainless steel appliances. Feel

    Jenn Baniak-Hollands KW Platform

    Section Image
  • L12 Rr 9w, Bethlehem, NY 12158

    $89,000 Pending

    • Land
    • 3.8 Acres
    • $23,421 per Acre
    • L12 Rr 9w
    • Bethlehem, NY

    Buildable lot in a prime Bethlehem location with 297 feet of road frontage and public water available at the road. This 3.8 acre lot is zoned Rural Light Industrial (RLI), and with town approvals it could be used for a variety of businesses, including: low-impact manufacturing, outdoor contractor or equipment storage, distribution hub, specialized automotive repair and fleet depot, etc. Schedule

    Jenn Baniak-Hollands KW Platform

    Section Image
  • 1407 Chestnut St, Watervliet, NY 12189

    $299,900 Pending

    • 3 Beds
    • 2 Baths
    • 1,576 Sq Ft
    • 1407 Chestnut St
    • Watervliet, NY

    *Best & Final offers due 7/14 at 12 noon.* Tucked away on a peaceful tree-lined dead-end street in the Town of Colonie, this beautifully maintained 3-bedroom, 2 full bath custom contemporary home offers far more space than meets the eye. Gorgeous curb appeal, beautiful landscaping, and a completely move-in-ready interior make it the perfect home for first-time buyers, downsizers, or anyone

    Jenn Baniak-Hollands KW Platform

    Section Image
  • Unlisted Address

    $700,000 Pending

    • Land
    • 13.3 Acres
    • $52,632 per Acre

    *RARE* 13.3 potentially buildable acres Zoned single family residential in Latham in the top ranked North Colonie School District with low Colonie taxes! Endless potential awaits on this expansive plot that is comprised of 2 separate parcels being sold together for a combined price of $700,000 - 230A Old Niskayuna Rd (12.3 acres) & 7 Saybrook Dr (1 acre). Access via 7 Saybrook Dr with

    Jenn Baniak-Hollands KW Platform

    Section Image
  • 230A Old Niskayuna Rd, Newtonville, NY 12110

    $700,000 Pending

    • Land
    • 13.3 Acres
    • $52,632 per Acre
    • 230A Old Niskayuna Rd
    • Newtonville, NY

    *RARE* 13.3 potentially buildable acres Zoned single family residential in Latham in the top ranked North Colonie School District with low Colonie taxes! Endless potential awaits on this expansive plot that is comprised of 2 separate parcels being sold together for a combined price of $700,000 - 230A Old Niskayuna Rd (12.3 acres) & 7 Saybrook Dr (1 acre). Access via 7 Saybrook Dr with

    Jenn Baniak-Hollands KW Platform

    Section Image
  • 327 10th St, Troy, NY 12180

    $219,900 Pending

    • 4 Beds
    • 2 Baths
    • 2,500 Sq Ft
    • 327 10th St
    • Troy, NY

    Why pay the whole mortgage yourself when a tenant can help? Move right into the spacious vacant first-floor unit of this attractive Troy two-family and start collecting rent from the long-term tenant upstairs from day one. Set on a quiet side street with great curb appeal and ample street parking, you're just 3 minutes from I-787 and Route 7 for an easy commute throughout the Capital Region. Step

    Jenn Baniak-Hollands KW Platform

    Section Image

Source: Global MLS

MLS Number: 202616626

Global MLS

APN: 2400-154.4-15-1

Your Personal Tour Guide

Ask me questions while you tour the home.