Skip main navigation
Closed
  • $908,000

    823 Greenthorne Boulevard, Guilderland, NY 12303

    6beds
    4,622sqft
    Single Family Residence, Residential
    Built in 1998
    1.12 Acres Lot
    $971,000 Zestimate®
    $196/sqft
    $4,587 Estimated rent

    What's special

    OFFERS DUE 12PM SUN., FEB. 18! A true home of distinction in the prestigious Haven Hills neighborhood of Guilderland. Pride of craftsmanship is evident with custom moldings and attention to detailed finishes and updates throughout. Even the most particular chef will love cooking in the new Zarrillo gourmet eat-in kitchen that connects to the butler's pantry and gorgeous formal dining room. The second floor hosts five spacious bedrooms and three full bathrooms including a stunning primary suite with double-sided gas fireplace. The basement is finished for even more living space and storage, and hosts another full bathroom and three other finished room. Relax and entertain on the patio with available spa electrical connection, all overlooking professionally landscandscaped, private grounds.

    Zillow last checked: 7 hours ago

    Listing updated: February 27, 2025 at 10:40am

    Listed by:

    Judith Gabler 518-278-7230,

    Gabler Realty, LLC

    Bought with:

    Teresa R Gitto, 10401255608

    Coldwell Banker Commercial Prime Properties

    Source: Global MLS,MLS#: 202412123MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 6
    • Bathrooms: 6
    • Full bathrooms: 4
    • 1/2 bathrooms: 2
    Primary bedroom
    • Level: Second
    Bedroom
    • Level: Second
    Bedroom
    • Level: Second
    Bedroom
    • Level: Second
    Bedroom
    • Level: Second
    Primary bathroom
    • Level: Second
    Half bathroom
    • Level: First
    Half bathroom
    • Level: First
    Full bathroom
    • Level: Basement
    Full bathroom
    • Level: Second
    Full bathroom
    • Level: Second
    Dining room
    • Level: First
    Family room
    • Level: First
    Foyer
    • Level: First
    Game room
    • Level: Basement
    Kitchen
    • Level: First
    Living room
    • Level: First
    Mud room
    • Level: First
    Office
    • Level: First
    Other
    • Level: First
    Heating
    • Forced Air, Natural Gas, Zoned
    Cooling
    • Central Air
    Appliances
    • Included: Built-In Electric Oven, Convection Oven, Cooktop, Dishwasher, Disposal, Microwave, Refrigerator, Washer/Dryer
    • Laundry: Laundry Room, Upper Level
    Features
    • High Speed Internet, Ceiling Fan(s), Solid Surface Counters, Tray Ceiling(s), Vaulted Ceiling(s), Walk-In Closet(s), Wired for Sound, Built-in Features, Ceramic Tile Bath, Crown Molding, Eat-in Kitchen, Kitchen Island
    • Flooring: Tile, Ceramic Tile, Hardwood
    • Doors: French Doors
    • Basement: Exterior Entry,Finished,Full,Heated,Interior Entry
    • Number of fireplaces: 2
    • Fireplace features: Gas, Wood Burning
    Interior area
    • Total structure area: 4,622
    • Total interior livable area: 4,622 sqft
    • Finished area above ground: 4,622
    • Finished area below ground: 1,500

    Property

    Parking
    • Total spaces: 10
    • Parking features: Off Street, Paved, Attached, Driveway, Garage Door Opener
    • Garage spaces: 3
    • Has uncovered spaces: Yes
    Features
    • Patio & porch: Side Porch, Patio, Porch
    • Exterior features: Lighting
    • Has view: Yes
    • View description: Trees/Woods
    Lot
    • Size: 1.12 Acres
    • Features: Level, Private, Wooded, Landscaped
    Details
    • Parcel number: 013089 39.08345
    • Special conditions: Standard

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    • Property subtype: Single Family Residence, Residential
    Materials
    • Brick, Clapboard
    • Foundation: Concrete Perimeter
    • Roof: Asphalt,Copper
    Condition
    • Updated/Remodeled
    • New construction: No
    • Year built: 1998

    Utilities & green energy

    • Electric: Circuit Breakers
    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: Cable Available

    Community & neighborhood

    Security
    • Security features: Security System
    Location
    • Region: Schenectady
    • Subdivision: Haven Hills
    Services availability