Welcome to this adorable, move-in ready Cape in the East Greenbush School District! This well-maintained home features a spacious living room, a formal dining room, two bedrooms, and a full bathroom on the first floor. Upstairs, you'll find a third bedroom with a half bathroom and a bonus room—ideal as a fourth bedroom, home office, or den. The home also includes a full, unfinished basement. Public water, public sewer & natural gas heat. Conveniently located on a quiet dead-end street, just minutes to downtown Albany, restaurants, shopping, schools & Regeneron. Enjoy comfort, convenience, and charm all in one!
Closed
$248,000
23 Lakeview Avenue, Rensselaer, NY 12144
3beds
1,512sqft
Single Family Residence, Residential
Built in 1948
4,356 Square Feet Lot
$255,400 Zestimate®
$164/sqft
$2,346 Estimated rent
Home value
$255,400
$217,000 - $301,000
$2,346/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$2,346/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$2,346/mo
Rent Zestimate®
Refinance and save
$1,451/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$1,451/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 startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked: 7 hours ago
Listing updated: July 02, 2025 at 12:04pm
Listed by:
Amanda L Hart 518-366-6974,
Miranda Real Estate Group, Inc
Bought with:
Julie E Adadjo, 40AD1171591
Heartland Home Properties, LLC
Source: Global MLS,MLS#: 202515387
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 1
- 1/2 bathrooms: 1
Bedroom
- Level: First
Bedroom
- Level: First
Bedroom
- Level: Second
Bedroom
- Description: Bonus room
- Level: Second
Full bathroom
- Level: First
Half bathroom
- Level: Second
Dining room
- Level: First
Kitchen
- Level: First
Living room
- Level: First
Heating
- Hot Water, Natural Gas, Radiant
Cooling
- Window Unit(s)
Appliances
- Included: Microwave, Oven, Range, Refrigerator, Washer/Dryer
- Laundry: In Basement
Features
- Flooring: Tile, Vinyl, Carpet
- Basement: Full,Sump Pump,Unfinished
Interior area
- Total structure area: 1,512
- Total interior livable area: 1,512 sqft
- Finished area above ground: 1,512
- Finished area below ground: 0
Property
Parking
- Total spaces: 2
- Parking features: Off Street
Features
- Exterior features: Other
Lot
- Size: 4,356 sqft
- Features: Level, Landscaped
Details
- Additional structures: Shed(s)
- Parcel number: 382400 155.9217
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Cape Cod
- Property subtype: Single Family Residence, Residential
Materials
- Vinyl Siding
- Roof: Shingle,Asphalt
Condition
- Updated/Remodeled
- New construction: No
- Year built: 1948
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & neighborhood
Location
- Region: Rensselaer
Price history
| Date | Event | Price |
|---|---|---|
| 1/9/2026 | Listing removed | $2,400$2/sqft |
Source: Zillow Rentals Report a problem | ||
| 11/20/2025 | Price change | $2,400-4%$2/sqft |
Source: Zillow Rentals Report a problem | ||
| 11/7/2025 | Listed for rent | $2,500$2/sqft |
Source: Zillow Rentals Report a problem | ||
| 7/2/2025 | Sold | $248,000-0.8%$164/sqft |
Source:  Global MLS #202515387 Report a problem | ||
| 4/22/2025 | Contingent | $249,900$165/sqft |
Source: NY State MLS #11477560 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | -- | $194,000 |
| 2023 | -- | $194,000 |
| 2022 | -- | $194,000 |
Find assessor info on the county website
Neighborhood: Hampton Manor
Nearby schools
GreatSchools rating
- 7/10Red Mill SchoolGrades: PK-5Distance: 0.5 mi
- 7/10Howard L Goff SchoolGrades: 6-8Distance: 2.6 mi
- 8/10Columbia High SchoolGrades: 9-12Distance: 2.2 mi
Schools provided by the listing agent
- High: Columbia
Source: Global MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Sell for more on Zillow
Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
$255,400
2% more
+$5,108
With Zillow Showcase(estimated)
$260,508
- New York
- Rensselaer County
- Rensselaer
- 12144
- Hampton Manor
- 23 Lakeview Avenue