This stunning and secluded 4BR & 3BA dramatic Contemporary is unmatched in style, design and functionality! Beautiful landscaping encompasses the 2,600 sf two level Loudonville gem. Natural light filters throughout the custom glass doors and windows. Open living and dining room separated by 3-sided gas fireplace. Gourmet kitchen with stainless steel appliances and dining peninsula. Gallery. Master bedroom suite with cozy den/sitting room. Spectacular spa-like master bath. Laundry closet. California Closets. 2 additional bedrooms and hall bath complete the main floor. Garden level features: Spacious family room with gas fireplace. Guest suite and bath. Utility/work room. So many unique features. Don't miss this rare opportunity to call 38 Cherry Tree home! Original owner was the architect. Excellent Condition
Single-familyProperty Type
1975Year Built
0.57 acresLot Size
$367Est. Price/Sq.Ft.
2 garage spacesParking
Listing by Steven Girvin• Better Homes and Gardens Tech
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
4
Baths
3.5
Stories
1
Lot width
—
Lot depth
—
Lot size
0.57 Acres
Year renovated
—
Sq. Ft.
1,720
Year built
1975
Style
Single Family Residential
County
Albany County
APN
012689A04300300070150000000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 14, 2026.
SFR
Single Family Residential District
The purpose of the Single Family Residential District (SFR) is to provide areas primarily for single-family residential development in the form of detached dwellings. The purpose is to create neighborhoods where people live and conduct their domestic activities. The Single Family Residential District is characterized by traditional suburban residential development.
Property details
Parking
Parking Information
Has Garage
Attached Garage YN: Yes
# of Garage Spaces: 2
# of Parking Total: 4
Parking Features: Off Street, Attached, Detached
Interior
Virtual Tour Information
Bathroom Information
# of Bathrooms (Full): 3
# of Bathrooms (Total Integer): 3
Room 1 Information
Type: Primary Bedroom
Level: First
Room 2 Information
Type: Living Room
Level: First
Room 3 Information
Type: Dining Room
Level: First
Room 4 Information
Type: Kitchen
Level: First
Room 5 Information
Type: Family Room
Level: Basement
Room 6 Information
Type: Den
Level: First
Room 7 Information
Type: Other
Level: First
Room 8 Information
Type: Bedroom
Level: First
Room 9 Information
Type: Full Bathroom
Level: First
Room 10 Information
Type: Primary Bathroom
Level: First
Room 11 Information
Type: Utility Room
Level: Basement
Basement Information
Basement: Finished, Full, Sump Pump
Laundry Features
Laundry Features: In Basement, Laundry Closet, Laundry Room, Main Level
Fireplace Information
Has Fireplace
# of Fireplaces Total: 2
Fireplace Features: Family Room, Gas, Living Room
Interior Features
# of Rooms Total: 11
Interior Features: High Speed Internet, Paddle Fan, Solid Surface Counters, Built-in Features
Appliances: Dishwasher, Disposal, Gas Water Heater, Microwave, Oven, Range, Refrigerator
Flooring: Ceramic Tile
Door Features: Sliding Doors
Exterior
Exterior Features
Patio And Porch Features: Deck, Patio
Roof: Asphalt
Fencing: Fenced, Privacy
Exterior Features: Garden, Lighting
Property Information
Property Sub Type: Single Family Residence
Living Area: 1,720
Below Grade Finished Area: 900
Construction Materials: Vinyl Siding
Security Features: Security System
Lot Information
Lot Size Acres: 0.57
Lot Size Square Feet: 24,829.2
Lot Size Dimensions: 24,829sf
Lot Features: Level, Private, Wooded, Cul-De-Sac, Landscaped
Financial
Tax Information
Tax Annual Amount: $7,214
Tax Annual Amount: $7,214
Financial Details: General Taxes: $2,347
Financial Details: School Taxes: $4,867
Utilities
Heating & Cooling
Has Heating
Heating: Forced Air, Natural Gas
Has Cooling
Cooling: Central Air
Utility Information
Sewer: Public Sewer
Utilities: Cable Available
Water Source: Public
Location
School Information
School District: North Colonie (including Maplewood)
Location Information
Directions: Loudon Road (Route 9) Heading south of main intersection (Osborne & Menands Rd.) first street on right. House is at the dead-end.
Public facts
Beds: 4
Baths: 3.5
Sq. Ft.: 1,720
Stories: 1.0
Lot Size: 0.57 acres
Style: Single Family Residential
Year Built: 1975
Year Renovated: —
County: Albany County
APN: 012689A04300300070150000000
Home facts updated by county records on Aug 14, 2026
Around this home
Schools
Loudonville School
Public K-5 • Assigned • 0.3mi
5/10
Shaker Junior High School
Public 6-8 • Assigned • 2.3mi
8/10
Shaker High School
Public 9-12 • Assigned • 2.3mi
8/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
10/10 Flood Factor
Estimated 80%+ chance of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
3/10 Heat Factor
7 days above 97° expected this year, 15 days in 30 years
3/10 Wind Factor
7% chance of strong winds in next 30 years
1/10 Air Factor
0 unhealthy days expected this year, 0 days in 30 years
Provided by First Street
Historical weather
Albany, NY • 12211
Average low and high temperatures (°F)
30
17
32
19
50
30
60
41
68
50
80
61
86
67
81
60
76
56
63
45
49
35
35
22
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 8.7 hours in
June and 3.5 hours in December, placing it below the
U.S. average for solar exposure.
8.7 hrs
3.5 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$600,000 – $726,000
Sell confidently with a local market expert in Albany. 3 minutes to get started.