Landlord's Agent in 2025
Miri Stern
Realty Connect USA LLC
(718) 791-9157
13 in this area
18 Total Sales
817 Glenridge Ave Valley Stream, NY 11581
Estimated Value: $1,060,000 - $1,093,902
5
Beds
3
Baths
2,800
Sq Ft
$385/Sq Ft
Est. Value
Highlights
- Property is near public transit
- Cathedral Ceiling
- Granite Countertops
- Raised Ranch Architecture
- Wood Flooring
- 5-minute walk to North Woodmere Park
About This Home
As of November 2025Welcome to this beautifully updated Rental- offering the perfect blend of style, space, and comfort, ideally located in the center of North Woodmere. Beautiful Eat-In Kitchen with modern finishes, Spacious Living Room, Dining Room, and Den-perfect for relaxing and entertaining. New Hardwood Floors Throughout. Five Bedrooms and Three Full Bathrooms Including a Primary Ensuite. Central Air Conditioning, 2 Car Garage and Ample Storage Spaces. Expansive Backyard ideal for outdoor living.
Last Agent to Rent the Property
Realty Connect USA LLC Brokerage Email: msternrealty@gmail.com License #10401310309 Listed on: 10/28/2025
Last Renter's Agent
Unrepresented Buyer
Buyer Representation Office
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $10,813
Year Built
- Built in 1962 | Remodeled in 2022
Lot Details
- 6,930 Sq Ft Lot
- Fenced
Parking
- 2 Car Attached Garage
- Driveway
- On-Street Parking
Home Design
- Raised Ranch Architecture
- 2-Story Property
- Entry on the 2nd floor
- Frame Construction
Interior Spaces
- 2,800 Sq Ft Home
- Cathedral Ceiling
- Formal Dining Room
- Wood Flooring
- Finished Basement
- Walk-Out Basement
Kitchen
- Eat-In Kitchen
- Oven
- Freezer
- Dishwasher
- Granite Countertops
Bedrooms and Bathrooms
- 5 Bedrooms
- En-Suite Primary Bedroom
- Walk-In Closet
- 3 Full Bathrooms
Laundry
- Dryer
- Washer
Location
- Property is near public transit
- Property is near schools
- Property is near shops
Schools
- Lawrence Primary Elementary School-#2 Elementary School
- Lawrence Middle School At Broadway Campus
- Lawrence Senior High School
Utilities
- Central Air
- Baseboard Heating
- Heating System Uses Oil
- Electric Water Heater
- Shared Septic
- Cable TV Available
Listing and Financial Details
- 12-Month Minimum Lease Term
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Closed on
Feb 24, 2023
Sold by
Walden Jacob I and Walden Rochel
Bought by
Jw Cliffside Holdings Llc
Current Estimated Value
Purchase Details
Closed on
Feb 21, 2023
Sold by
Walden Jacob and Walden Rochel
Bought by
Jw Glenridge Holdings Llc
Purchase Details
Listed on
Sep 10, 2021
Closed on
Jan 13, 2022
Sold by
Castellano Angelo and Castellno Lucy
Bought by
Walden Jacob and Walden Rochel
Seller's Agent
Havi Frankel
Keller Williams Points North
Buyer's Agent
Miri Stern
Realty Connect USA LLC
List Price
$865,000
Sold Price
$915,000
Premium/Discount to List
$50,000
5.78%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.31%
Original Mortgage
$732,000
Interest Rate
3.22%
Mortgage Type
New Conventional
Purchase Details
Closed on
Feb 18, 2000
Sold by
Gross Gail
Bought by
Castellano Angelo and Castellano Lucy
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$319,500
Interest Rate
7.87%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
Jun 17, 1998
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Jw Cliffside Holdings Llc | -- | None Available | |
| Jw Glenridge Holdings Llc | -- | None Available | |
| Walden Jacob | $915,000 | Old Republic National Title | |
| Castellano Angelo | $355,000 | First American Title Ins Co | |
| -- | $275,000 | -- |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Previous Owner | Walden Jacob | $732,000 | |
| Previous Owner | Castellano Angelo | $319,500 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 11/21/2025 11/21/25 | Rented | $6,000 | -7.7% | -- | |
| 10/28/2025 10/28/25 | For Rent | $6,500 | 0.0% | -- | |
| 11/01/2023 11/01/23 | Rented | $6,500 | 0.0% | -- | |
| 08/28/2023 08/28/23 | For Rent | $6,500 | 0.0% | -- | |
| 01/13/2022 01/13/22 | Sold | $915,000 | +5.8% | $380 / Sq Ft | View Prior Sale |
| 10/19/2021 10/19/21 | Pending | -- | -- | -- | |
| 09/10/2021 09/10/21 | For Sale | $865,000 | -- | $359 / Sq Ft |
Source: OneKey® MLS
Tax History Compared to Growth
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $10,813 | $659 | $262 | $397 |
| 2024 | $5,176 | $732 | $291 | $441 |
| 2023 | $12,083 | $741 | $295 | $446 |
| 2022 | $12,083 | $752 | $299 | $453 |
| 2021 | $15,537 | $784 | $312 | $472 |
| 2020 | $13,697 | $1,232 | $831 | $401 |
| 2019 | $5,718 | $1,232 | $831 | $401 |
| 2018 | $7,357 | $1,232 | $0 | $0 |
| 2017 | $6,733 | $1,232 | $831 | $401 |
| 2016 | $11,848 | $1,232 | $831 | $401 |
| 2015 | $4,785 | $1,232 | $831 | $401 |
| 2014 | $4,785 | $1,232 | $831 | $401 |
| 2013 | $4,506 | $1,232 | $831 | $401 |
Source: Public Records
Agents Affiliated with this Home
-
Miri Stern
-
U
Tenant's Agent in 2025
Unrepresented Buyer
Buyer Representation Office
-
Jimmy Amram
Buyer's Agent in 2023
Jimmy Amram
Douglas Elliman Real Estate
(516) 244-2466
3 in this area
57 Total Sales
-
H
Seller's Agent in 2022
Havi Frankel
Keller Williams Points North
Map
Source: OneKey® MLS
MLS Number: 929681
APN: 2089-39-599-00-0031-0
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to real estate for sale or lease on this web site comes in part from OneKey® MLS. Real estate listings held by brokerage firms other than Ten-X are marked with the OneKey® MLS logo or an abbreviated logo and detailed information about them includes the name of the listing broker.
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.
Copyright 2025 OneKey® MLS. All rights reserved.
Nearby Homes
- 748 Sherwood St
- 729 Wilson St
- 750 University St
- 740 Eagle Dr
- 683 Vandam St
- 764 Sherwood Ct
- 756 Dumont Place
- 722 Eagle Dr
- 797 Caldwell Ave
- 256-20 Craft Ave
- 254-16 Craft Ave
- 14963 258th St Unit 12
- 149-59 256th St Unit 17
- 636 Derby Ave
- 740 Kearny Dr
- 844 Flanders Dr
- 25946 149th Rd
- 5 Valley Ln W
- 8 Gale Dr
- 573 Fairway Dr
- 664 Michelle Place
- 658 Hungry Harbor Rd
- 668 Hungry Harbor Rd
- 654 Michelle Place
- 810 Glenridge Ave
- 672 Hungry Harbor Rd
- 648 Michelle Place
- 822 Glenridge Ave
- 665 Michelle Place
- 828 Glenridge Ave
- 678 Hungry Harbor Rd
- 642 Michelle Place
- 655 Michelle Place
- 665 Hungry Harbor Rd
- 834 Glenridge Ave
- 659 Hungry Harbor Rd
- 649 Hungry Harbor Rd
- 640 Hungry Harbor Rd
- 649 Michelle Place
- 653 Park Ln