Skip main navigation
Closed
  • $622,400

    857 GREENTHORNE Boulevard, Guilderland, NY 12303

    4beds
    3,089sqft
    Single Family Residence, Residential
    Built in 1994
    0.42 Acres Lot
    $622,400 Zestimate®
    $201/sqft
    $3,520 Estimated rent

    Home value

    $622,400

    $560,000 - $691,000

    $3,520/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $3,520/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $3,520/mo

    Rent Zestimate®

    Refinance and save

    $4,175/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $4,175/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Remarkable and stately colonial now available on a private cul-de-sac in one of Guilderland's most prestigious neighborhoods! Kitchen has been professionally remodeled to fit all of your cooking/baking needs. Fresh paint and all baths recently remodeled and upgraded as well. Enjoy the large very private patio and backyard. Mature and low maintenance landscaping to enjoy year after year with beautiful and lush perennials. A wonderful opportunity to become part of the Haven Hills neighborhood! Superior Condition

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Zillow last checked:

    Listing updated:

    Listed by:

    Emily Modan,

    Berkshire Hathaway Home Services Blake

    Bought with:

    Leanne Royer, 40RO1163308

    CM Fox Real Estate

    Source: Global MLS,MLS#: 201713114MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 4
    • Full bathrooms: 3
    • 1/2 bathrooms: 1
    Half bathroom
    • Level: First
    Heating
    • Forced Air, Natural Gas, Zoned
    Cooling
    • Central Air
    Appliances
    • Included: Built-In Electric Oven, Built-In Gas Oven, Cooktop, Dishwasher, Disposal, Gas Water Heater, Humidifier, Microwave, Refrigerator
    • Laundry: Laundry Room, Main Level
    Features
    • High Speed Internet, Ceiling Fan(s), Solid Surface Counters, Built-in Features, Eat-in Kitchen
    • Flooring: Ceramic Tile
    • Doors: Sliding Doors
    • Basement: Finished,Full
    • Number of fireplaces: 1
    • Fireplace features: Living Room
    Interior area
    • Total structure area: 3,089
    • Total interior livable area: 3,089 sqft
    • Finished area above ground: 3,089
    • Finished area below ground: 1,000

    Property

    Parking
    • Total spaces: 4
    • Parking features: Off Street, Attached
    • Garage spaces: 2
    Features
    • Patio & porch: Patio
    • Exterior features: Lighting
    Lot
    • Size: 0.42 Acres
    • Features: Private, Sloped, Sprinklers In Front, Sprinklers In Rear, Wooded, Cul-De-Sac, Landscaped
    Details
    • Parcel number: 013000 39337
    • Special conditions: Standard

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    • Property subtype: Single Family Residence, Residential
    Materials
    • Cedar
    • Roof: Asphalt
    Condition
    • New construction: No
    • Year built: 1994
    Details
    • Builder model: BHHS LUX

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: Cable Available

    Community & neighborhood

    Security
    • Security features: Security System
    Location
    • Region: Guilderland
    • Subdivision: Haven Hills

    Price history

    DateEventPrice
    9/8/2017Sold$467,500+16.9%$151/sqft
    Source: Global MLS #201713114 Report a problem
    7/14/2004Sold$400,000$129/sqft
    Source: Global MLS #24100668 Report a problem

    Public tax history

    Tax history is unavailable.

    Neighborhood: 12084

    Nearby schools

    GreatSchools rating
    Sell for more on Zillow
    Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
    $622,400
    2% more
    +$12,448
    With Zillow Showcase(estimated)
    $634,848