Skip main navigation
Active
  • Price cut: $26K (7/14)
    $599,000

    29 Stony Brook Drive, Rexford, NY 12148

    4beds
    2,114sqft
    Loading
    Single Family Residence, Residential
    Built in 1975
    0.67 Acres Lot
    $582,600 Zestimate®
    $283/sqft
    $-- HOA

    What's special

    Private backyardAbundant natural lightSpacious yardAdditional living spaceRear deckPartially finished basementPark-like setting
    Enjoy water views and a park-like setting at this spacious 4-bedroom, 2.5-bath home offering 2,114 square feet of living space, plus approximately 1,000 square feet of partially finished basement space. Situated on a beautifully landscaped .67-acre lot, this property offers the perfect blend of privacy, functionality, and outdoor enjoyment. The welcoming interior features hardwood floors, abundant natural light, and a functional floor plan designed for both everyday living and entertaining. Large windows capture the surrounding scenery while creating a bright and inviting atmosphere throughout the home. One of the standout features is the additional living space provided by the partially finished basement, offering endless possibilities for a family room, recreation area, home gym, office, hobby space, or guest accommodations. Outdoor living is equally impressive. Relax in the three-season room overlooking the private backyard, entertain on the rear deck, or simply enjoy the peaceful setting surrounded by mature trees and established landscaping. The spacious yard provides plenty of room for outdoor activities, gardening, and gatherings. Car enthusiasts, hobbyists, and those in need of extra storage will appreciate the rare combination of an attached 2-car garage and an additional detached 2-car garage, providing ample space for vehicles, recreational equipment, workshops, or storage. Located on a quiet residential street, this home offers a tranquil setting while remaining conveniently close to schools, parks, shopping, dining, and major commuter routes. A rare opportunity to enjoy scenic views, generous living space, exceptional garage capacity, and a private setting all in one property.
    43 days
    |
    1,288
    |
    70
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Sterling Real Estate Group 518-688-2211,

    Scott G Roberts 518-522-4232,

    David P Triller 518-441-4826,

    Sterling Real Estate Group

    Source: Global MLS,MLS#: 202619968MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 3
      • Full bathrooms: 2
      • 1/2 bathrooms: 1
      Bedroom
      • Level: Second
      Bedroom
      • Level: Second
      Bedroom
      • Level: Second
      Bedroom
      • Level: Second
      Dining room
      • Level: First
      Family room
      • Level: First
      Foyer
      • Level: First
      Kitchen
      • Level: First
      Living room
      • Level: First
      Other
      • Level: First
      Heating
      • Baseboard, Forced Air, Oil
      Cooling
      • Central Air
      Appliances
      • Included: Electric Oven, Microwave, Refrigerator, Washer/Dryer
      • Laundry: Main Level
      Features
      • Vaulted Ceiling(s)
      • Flooring: Tile, Hardwood
      • Windows: Bay Window(s)
      • Basement: Finished,Full,Partial
      • Number of fireplaces: 1
      • Fireplace features: Living Room
      Interior area
      • Total structure area: 2,114
      • Total interior livable area: 2,114 sqft
      • Finished area above ground: 2,114
      • Finished area below ground: 1,000
      Video & virtual tour

      Property

      Parking
      • Total spaces: 8
      • Parking features: Attached, Detached, Driveway, Garage Door Opener, Heated Garage
      • Attached garage spaces: 4
      • Has uncovered spaces: Yes
      Features
      • Patio & porch: Deck, Glass Enclosed
      • Fencing: None
      • Has view: Yes
      • View description: Lake, Water
      • Has water view: Yes
      • Water view: Lake,Water
      • Body of water: Colonie Reservoir
      Lot
      • Size: 0.67 Acres
      • Features: Private, Road Frontage, Landscaped
      Details
      • Additional structures: Storage, Workshop, Garage(s)
      • Parcel number: 412400 283.17117
      • Special conditions: Standard

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Colonial
      • Property subtype: Single Family Residence, Residential
      Materials
      • Other, Aluminum Siding, Cedar, Vinyl Siding
      • Roof: Shingle
      Condition
      • Updated/Remodeled
      • New construction: No
      • Year built: 1975

      Utilities & green energy

      • Electric: Circuit Breakers
      • Sewer: Septic Tank

      Community & HOA

      HOA
      • Has HOA: No
      Location
      • Region: Rexford

      Financial & listing details

      • Price per square foot: $283/sqft
      • Tax assessed value: $389,167
      • Annual tax amount: $6,500
      • Date on market: 6/18/2026

        Estimated market value

        $582,600

        $553,000 - $612,000

        $3,574/mo

        Price history

        DateEventPrice
        7/14/2026Price change$599,000-4.2%$283/sqft
        Source: Global MLS #202619968 Report a problem
        6/18/2026Listed for sale$625,000+269.8%$296/sqft
        Source: Global MLS #202619968 Report a problem
        10/24/1997Sold$169,000$80/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025-- $140,100
        2024-- $140,100
        2023-- $140,100
        2022-- $140,100
        2021-- $140,100
        2020-- $140,100
        2019-- $140,100
        2018-- $140,100
        2017$4,491 +352.5%$140,100
        2016$993 -0.9%$140,100
        2015$1,001 -76.8%$140,100
        2014$4,318 $140,100
        2013-- $140,100
        2012-- $140,100
        2011-- $140,100
        2010-- $140,100
        2009-- $140,100
        2008-- $140,100
        2007-- $140,100
        2006-- $140,100
        2005-- $140,100
        2004-- $140,100
        2003-- $140,100
        2002-- $140,100
        2001-- $140,100 +8.2%
        2000-- $129,500
        Find assessor info on the county website

        Monthly payment

        Estimated monthly payment$1,822
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 12148

        Getting around

        0 / 100
        Car-Dependent
        23 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • High: Shenendehowa

        Source: Global MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes