823 Greenthorne Boulevard, Schenectady, NY 12303
OFF MARKET

823 Greenthorne Boulevard
Schenectady, NY 12303

  • 6 Beds
  • 5 Baths
  • 4,622 sqft (on 1.12 acres)

$1,068,900

Trulia Estimate
as of May 22, 2026
Est. Refi. Payment $6,852/mo*
Refinance Your Home

$1,068,900

Trulia Estimate
as of May 22, 2026
Est. Refi. Payment $6,852/mo*
Refinance Your Home
6 Beds
5 Baths
4,622 sqft
(on 1.12 acres)

Local Information

Map showing home location
© Google
-- mins to
Commute Destination

Description

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.
This property is off market, which means it's not currently listed for sale or rent on Trulia. This may be different from what's available on other websites or public sources. This description is from February 27, 2025

Home Highlights

Parking
Garage
Outdoor
Porch, Patio
A/C
Heating & Cooling
HOA
None
Price/Sqft
No Info
Listed
180+ days ago

Home Details for 823 Greenthorne Boulevard

Active Status

MLS Status: Closed

Interior Features

Interior Details
Basement: Exterior Entry,Finished,Full,Heated,Interior EntryNumber of Rooms: 20Types of Rooms: Primary Bedroom, Bedroom, Primary Bathroom, Half Bathroom, Full Bathroom, Dining Room, Family Room, Foyer, Game Room, Kitchen, Living Room, Mud Room, Office, Other
Beds & Baths
Number of Bedrooms: 6Number of Bathrooms: 6Number of Bathrooms (full): 4Number of Bathrooms (half): 2
Dimensions and Layout
Living Area: 4622 Square Feet
Appliances & Utilities
Utilities: Cable AvailableAppliances: Built-In Electric Oven, Convection Oven, Cooktop, Dishwasher, Disposal, Microwave, Refrigerator, Washer/DryerDishwasherDisposalLaundry: Laundry Room,Upper LevelMicrowaveRefrigerator
Heating & Cooling
Heating: Forced Air,Natural Gas,ZonedHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Forced Air
Fireplace & Spa
Number of Fireplaces: 2Fireplace: Gas, Wood BurningHas a FireplaceNo Spa
Gas & Electric
Electric: Circuit Breakers
Windows, Doors, Floors & Walls
Door: French DoorsFlooring: Tile, Ceramic Tile, Hardwood
Levels, Entrance, & Accessibility
Floors: Tile, Ceramic Tile, Hardwood
View
Has a ViewView: Trees/Woods
Security
Security: Security System

Exterior Features

Exterior Home Features
Roof: Asphalt CopperPatio / Porch: Side Porch, Patio, PorchExterior: LightingFoundation: Concrete Perimeter
Parking & Garage
Number of Garage Spaces: 3Number of Covered Spaces: 3No CarportHas a GarageHas Open ParkingParking Spaces: 10Parking: Off Street,Paved,Attached,Driveway,Garage Door Opener
Frontage
Not on Waterfront
Water & Sewer
Sewer: Public Sewer
Finished Area
Finished Area (above surface): 4622 Square FeetFinished Area (below surface): 1500 Square Feet

Property Information

Year Built
Year Built: 1998
Property Type / Style
Property Type: ResidentialProperty Subtype: Single Family Residence, ResidentialArchitecture: Colonial
Building
Construction Materials: Brick, ClapboardNot a New Construction
Property Information
Condition: Updated/RemodeledParcel Number: 013089 39.08345

Price & Status

Price
List Price: $849,900
Status Change & Dates
Off Market Date: Sun Feb 18 2024Possession Timing: Close Of Escrow

Media

Location

Direction & Address
City: GuilderlandCommunity: Haven Hills
School Information
Elementary School: LynnwoodHigh School: GuilderlandHigh School District: Guilderland

Building

Building Area
Building Area: 4622 Square Feet

HOA

No HOA

Lot Information

Lot Area: 1.12 Acres

Listing Info

Special Conditions: Standard

Mobile R/V

Mobile Home Park
Mobile Home Units: Feet

Miscellaneous

BasementMls Number: 202412123Above Grade Unfinished Area: 4622Showing Requirements: Showing Service, Sign on Property
Last check for updates: about 5 hours ago
Listed by Judith Gabler, (518) 727-5653
Gabler Realty, LLC
Bought with: Teresa R Gitto, (518) 225-3689, Coldwell Banker Commercial Prime Properties
Source: Global MLS, MLS#202412123

Price History for 823 Greenthorne Boulevard

DatePriceEventSource
03/28/2024$908,000Sold
Global MLS #202412123
02/19/2024$849,900PendingGlobal MLS #202412123
02/15/2024$849,900Listed For SaleGlobal MLS #202412123
07/15/2022$867,000Sold
Global MLS #202218033
05/26/2022$825,000PendingGlobal MLS #202218033
05/18/2022$825,000Listed For SaleGlobal MLS #202218033
09/16/1998$539,900Sold
N/A
Skip to last item
  • Results are loading
Skip to first item

Property Tax and Assessment

Year2025
Tax
Assessment$940,000
Home facts updated by county records

Comparable Sales for 823 Greenthorne Boulevard

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
428 Ridgehill Road, Schenectady, NY
0.33
Single-Family Home
$999,500
03/27/26
5
4.5
4,296
341 W Highland Drive, Schenectady, NY
0.10
Single-Family Home
$325,000
02/05/26
6
2.5
2,920
84 Okara Drive, Schenectady, NY
0.23
Single-Family Home
$430,000
08/08/25
3
2
2,383
6470 Vosburgh Road, Altamont, NY
0.83
Single-Family Home
$740,000
08/08/25
6
3
3,562
222 Bell Court, Schenectady, NY
0.72
Single-Family Home
$775,000
03/16/26
4
2.5
3,660
114 Okara Drive, Schenectady, NY
0.23
Single-Family Home
$479,900
09/15/25
4
2.5
1,857
308 Polsinelli Drive, Schenectady, NY
0.41
Single-Family Home
$479,000
09/17/25
4
2.5
2,573
228 Vincenza Lane, Schenectady, NY
0.38
Single-Family Home
$521,000
12/31/25
4
2.5
2,607
618 Maywood Avenue, Schenectady, NY
0.33
Single-Family Home
$460,000
10/10/25
4
2
2,324

Nearby homes

Get a sense of prices in the area by checking nearby homes.
Skip to last item
Skip to first item

Assigned Schools

These are the assigned schools for 823 Greenthorne Boulevard.
View nearby schools on GreatSchools
The GreatSchools Rating compares schools on a variety of school quality indicators including test scores, college readiness, equity and more. Learn more.

What Locals Say about Schenectady

At least 1174 Trulia users voted on each feature.

  • 83 % Say it's dog friendly

  • 82 % Say car is needed

  • 80 % Say yards are well-kept

  • 79 % Say parking is easy

  • 73 % Say there's holiday spirit

  • 65 % Say kids play outside

  • 62 % Say there are sidewalks

  • 60 % Say people would walk alone at night

  • 57 % Say it's quiet

  • 54 % Say it's walkable to restaurants

  • 53 % Say neighbors are friendly

  • 53 % Say they plan to stay for at least 5 years

  • 49 % Say there's wildlife

  • 48 % Say it's walkable to grocery stores

  • 44 % Say streets are well-lit

  • 29 % Say there are community events

Sourced by Trulia users. Learn more about our methodology.
  • Amber
    "The neighborhood has a lot of Nice walking paths and close to lots of parks. It is very family friendly. "
    0
    Flag
  • Mshilindra
    "It’s peaceful if you’re planning on moving here from a big busy city. You can make a living and start saving more. It’s better to raise a family. "
    0
    Flag
  • Kelly Kilian
    "The quiet setting on the evening traffic, quiet down the wildlife in the backyard. The trains that go by in the back not something you see every day houses are somewhat far apart, so it makes it hard to get to know your neighbors, but I did meet one very nice elderly gentleman Close proximity, and driving distance to stores, markets and restaurants"
    0
    Flag
  • Boris Mio
    "Rotterdam is a Great place to live with family, so far enjoying my time here with family, good neighbors."
    0
    Flag
  • sharif murray
    "Casino bars music events restaurants lot of parks the place is still in development to becoming better "
    0
    Flag
  • Marlene Morales
    "Not too bad. 22 minutes to downtown Albany. Roundabout made all the difference. Close to the highway. "
    0
    Flag
  • Pattyhalpin8
    "We have lived here for 12 years. Safe and friendly community. People take pride of their homes and properties. Easy access to grocery stores, etc. we love it here! "
    0
    Flag
  • Trulia User
    "I am not sure about the community events in this area. I know the do garage sales in the summer, kids do trick or treating on Halloween."
    4
    Flag
  • Trulia User
    "They would absolutely love the local reserve to walk their dogs in. Nice safe area and not that much traffic as well"
    1
    Flag
  • Trulia User
    "the neighborhood is increasingly becoming questionable, along with loud music from neighbors who have no consideration for others in the surrounding, last but not least cars do not obey the speed limit during the day or night making it unsafe for both adults and children in the neighborhood."
    8
    Flag
  • Trulia User
    "I love Bellevue to live with my family. I’m still looking for a house or apartment in this area for a meal and tranquility for my children."
    1
    Flag
  • Trulia User
    "the value neighborhood has access to a bus running every day of the week taking you to downtown Schenectady to tractors and great restaurants and casino and you can jump right on 890 and go to Albany New York City within a couple minutes Amsterdam so it's real easy to commute and less traffic and less time spent on the road"
    0
    Flag
  • Trulia User
    "We have a close little neighborhood in our area of town. We have block parties every year. We all chat with each other. "
    0
    Flag
  • Trulia User
    "There are lots of dog walkers in our neighborhood. Neighbors are friendly towards dogs. You see all types of dogs, large to small. "
    0
    Flag
  • Trulia User
    "My neighborhood does not have great public transportation. You will need a car to live around here. Does have Great schools, safe and close to shopping areas and restaurants "
    0
    Flag
  • Trulia User
    "I've lived here for a few years I love the neighborhood. everyone is friendly and it has a great neighborhood feel"
    4
    Flag
  • Trulia User
    "it's a very busy neighborhood. They love to walk out their dog every day. They do not like being stared at. they love when others play with their dogs. "
    0
    Flag
  • Trulia User
    "it's a cute small town that feels safe and neighborly, there's the city of Schenectady in close proximity as well in luding Rivers casino and there's shopping plazas and malls nearby also, it is a really convenient location."
    3
    Flag
  • Trulia User
    "A very nice neighborhood seems like a safe there’s not many stores near it but it is a supermarket people are very responsible and you need a car you can use the bus or cab and sometimes bikes or motorcycles but it seems like it’s safe for the children and the people. Love the scenery an the area has a high school and elementary schools near it very good building up their neighborhood and keeping their streets in their lawn clean."
    4
    Flag
  • Trulia User
    "It’s a great neighborhood but I have no car but I do use a cab service so anyway I can get downtown I would take the cab service not the bus"
    1
    Flag
  • Trulia User
    "Everything here is nice live this Neighborhood people are nice streets a clean family oriented please"
    0
    Flag
  • Trulia User
    "The stores are close by You can walk to the store. convenient locations..Friendly neighbors. and quit place to live. "
    0
    Flag
  • Hannah G.
    "Indian meadows park is great for kids. Great for birthday party & lots of fun things for kids of all ages all year long !"
    0
    Flag
  • Sharif M.
    "The commute is very reliable from buses to trains and taxis everywhere has a bus stop or taxis around "
    0
    Flag
  • Dhorweezy
    "Rotterdam is a nice town to live in. The school is great and in general feels safe. I have alway left my car unlocked and no issues"
    0
    Flag
  • Gtmelvin86
    "I work I’m the area for over two years and I think it’s a great place to live and raise a family and also to visit with lots of activities"
    8
    Flag
  • Desiree S.
    "oktoberfest is really great and brings everyone together, we go every year and the scotia glenville car show and holiday on the ave is so much fun as well! "
    1
    Flag
  • Summer A.
    "We all have dogs and we all take care of them and everyone and dogs a friends.this area has a lot of different animals around like roosters, horses,pigs, dogs, cats, little orange foxes coyotes, love hearing them in the distance kinda scary in a hott summer night "
    0
    Flag
  • Alex B.
    "the town is very active and has many events throughout the year, such as NiskaDay, a big parade and all day fair"
    0
    Flag
  • Missy C.
    "I’ve lived in this neighborhood for 7 years now. The Neighbors are friendly. There are a few parks in the area that are neatly kept and nice to visit."
    9
    Flag
  • Winterredrose
    "Everyone is friendly while still minding their own business. There is a good mix of people and ages. Safe family friendly area. Close to essential stores. "
    5
    Flag
  • Jpawlinga
    "Great sense of community, the neighbors are nice and there are a lot of kids in the neighborhood to play with "
    2
    Flag
  • Tarell G.
    "Great school district. The rating don’t show it because state testing is not required. The community is really tight nipped with sports. "
    0
    Flag
  • Bjulib
    "It is dog friendly. people are always friendly when I am walking my dog. Never received any guide lines about having dogs in the area I live in. "
    8
    Flag
  • Annahujak
    "My neighborhood is walkable to groceries, a library branch, the post office and various small shops. My work commute is 10-15 minutes. "
    0
    Flag
  • Clvandem
    "It’s full of families riding bikes with their kids, walking their dogs etc.... people are friendly and it’s safe."
    0
    Flag
  • Quanishawilliams32
    "dogs are always on leashes and I've never had a bad experience with dogs in this neighborhood. I also drive so I wouldn't notice. "
    2
    Flag
  • Stargyal90
    "people drive like they are crazy lots of car break ins use to be a nice neighborhood then all of the good people slowly leave"
    1
    Flag
  • Molly M.
    "Union Street and the GE plot neighborhood are safe and well maintained and convenient. I’ve lived in two different Union Street apartments in my life and have always loved it here. Reasonable commute to everywhere."
    12
    Flag
  • Chriss
    "There’s something here for everybody. Stores, restaurants both fine and cheap, pubs, movie theater, anything you want."
    0
    Flag

LGBTQ Local Legal Protections

Apartments for Rent

Skip to last item
Skip to first item

Explore by feature

Homes for sale near 823 Greenthorne Boulevard

Skip to last item
Skip to first item

Off Market Homes Near 823 Greenthorne Boulevard

Skip to last item
Skip to first item
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.
Judy Moriarty, Zillow, Inc., Corp. Broker

Homes for rent near 823 Greenthorne Boulevard

Skip to last item
  • Results are loading
Skip to first item
823 Greenthorne Boulevard, Schenectady, NY 12303 is a 6 bedroom, 6 bathroom, 4,622 sqft single-family home built in 1998. This property is not currently available for sale. 823 Greenthorne Boulevard was last sold on Mar 28, 2024 for $908,000 (7% higher than the asking price of $849,900). The current Trulia Estimate for 823 Greenthorne Boulevard is $1,068,900.