by RH Advisors
For Sale
For Rent
Blog
Property Records
Schools
SEARCH
Property Records
For Sale
For Rent
MORE
Blog
Schools
See Home Value
South Valley Stream 11581 South Valley Stream
797 Caldwell Avenue
Photo of 797 Caldwell Avenue
Sold on Jun 16, 2026

45

Map

Photo of 797 Caldwell Avenue
Photo of 797 Caldwell Avenue
$1,180,000
● House - Off Market

797 Caldwell Avenue

Hempstead, NY 11581
bedrooms
4 Beds
bathrooms
3 Baths
square feet
2,471 Ft²
$7,569
Est. Monthly
2.71%
Cap Rate

About This Property

New to the market! Welcome to a beautifully maintained 4-bedroom, 3-bathroom home on a spacious 74x100 lot, located on a serene tree-lined street in the highly desirable Hewlett-Woodmere School District. This charming home features a formal living room with vaulted ceilings, a separate dining room, and a large eat-in kitchen with granite countertops and abundant cabinet space. The primary bedroom boasts its own private en-suite bathroom for added comfort and privacy. The expansive lower level includes a generous den, wet bar, and convenient washer and dryer. A 2-car garage provides additional storage and parking. Throughout the home, you'll find gleaming hardwood floors, recessed lighting, and central air conditioning for year-round comfort. Step outside to enjoy the lush, fully fenced backyard – a perfect space for relaxation or entertaining. With its ideal location, ample living space, and modern amenities, this home is a must-see!
Unit Size
2,471 Ft²
Days on Market
377 days
Land Size
0.16 acres
Price per sqft
$485
Property Type
House
Property Taxes
$1,681
HOA Dues
-
Year Built
1961

Payment Calculator

Home Price
Down Payment
%
Loan Term
Interest %

Your Estimated Monthly Payment

Principal + Interest:
Property Tax:
HOA:
Home Insurance:
Mortgage Insurance:

Cap Rate Calculator

Purchase Price
Monthly Property Taxes
Monthly Rental Income
Maintenance & HOA
Income Per Year
Expenses Per Year
Operating Profit Per Year
Cap Rate 100% Occupancy
N/A (extreme outlier)

What does this mean?

Based on our analysis, the cap rate of this property is 1.25%. A negative cap rate indicates that the property might not be feasible as an income-producing asset. The median cap rate for a near zip code 11238 is 4.23%.

How much can I actually make?

Actual monthly rental income may vary between $4,760 and $7,140 depending on unit-specific characteristics. You can change the amount using the slider to further explore.

How is cap rate calculated?

Cap Rate = Net Operating Income (NOI) / Property Asset Value.

When calculating the cap rate, we assume 100% occupancy. Leverage (mortgage) is not considered.

Cap Rate provided by RealtyHop and RentHop, learn more about cap rate here.

Last updated: 5 months ago (OneKey MLS #KEY873445)

Price History

Date / Event Date Event Price
Jun 16, 2026 Sold
Premium
Sold
May 6, 2026 In contract -
In contract
Mar 31, 2026 Price Decreased $1,199,000
↓ $30K (2.4%)
Price Decreased
Dec 23, 2025 Price Decreased $1,229,000
↓ $20K (1.6%)
Price Decreased
Sep 30, 2025 Price Decreased $1,249,000
↓ $50K (3.9%)
Price Decreased
Show More

Property Highlights

Garage
Air Conditioning

Building Info

Overview

    General

  • Year Built: 1961
  • Effective Year Built: 1961
  • Total Rooms: 6
  • Bedroom Count: 0
  • Bathroom Count: 3
  • Full Bathrooms: 3
  • Partial Bathrooms: 3
  • Building Condition: 6
  • Building Quality: 7
  • Construction Type: 6
  • Building Style: 41
  • Exterior Walls Type: 24
  • Interior Walls Type: 0
  • Roof Shape Type: 0
  • Roof Cover Type: 20
  • Floor Count: 100
  • Living Units: 1
  • Floor Cover: 0
  • Basement Type: 3
  • Basement Area: 796
  • Garage Type: 17
  • Parking Space Count: 2
  • Patio Type: 0
  • Porch Type: 0
  • Pool Type: 0

    Dimensions

  • Lot Size Square Feet: 7,000
  • Lot Size Depth Feet: 1,000
  • Lot Size Frontage Feet: 740
  • Total Building Area: 2,471
  • Building Area: 2,471
  • Building Area Measurement: L

    Heating and Cooling

  • Air Conditioning: 1
  • Heating: 3
  • Heated Square Feet: 2,471
  • Heating Fuel Type: 3

    Utilities

  • Sewer System: 1
  • Water Service: 2

Building

  • Building Type: 0
  • Property Class: R
  • Land Acres: 0000000161
  • Standard Land Use Code: 1001
  • County Land Use Code: 2100
  • Legal Description 1: TOWN #1 SCH DIST 014

Neighborhood

  • School District Name: Hewlett-Woodmere Union Free School District
  • School Tax School District: 014
  • Census Tract: 410900

Geography

  • District: 282089
  • Section: 39
  • Parcel: 39-567-00-0009
  • Block: 567
  • Lot: 9
  • Municipality: HEMPSTEAD UNINCORPORATED
  • Latitude: 40.6463
  • Longitude: -73.7247

    Address

  • Full Address: 797 Caldwell Ave
  • Address - House Number: 797
  • Address - Street Name: Caldwell
  • Address - Suffix Type: Ave
  • State: NY
  • City Name: Valley Stream
  • Carrier Code: C064
  • 4-Digit Zip Code: 3618
  • Zip Code: 11581

Valuation

    Tax

  • Tax Year: 2023
  • Tax Amount: $1,707,513
  • Tax Rate Code Area: 013

    Appraisal Valuation

  • Standard Deviation: 0.1613
  • Valuation Date: Jun 28, 2023
  • Confidence Score: 79
  • Final Value: 926,187
  • High Value: 1,075,647
  • Low Value: 776,727

    Market Valuation

  • Market Total Value: $682,000

    Assessments Valuation

  • Assessed Year: 2023
  • Assessed Total Value: $682
  • Assessed Land Value: $305
  • Assessed Improvements Value: $377

    Exemptions

  • Homeowner Exemption: Yes
Data used for valuation calculations is provided by RealtyHop, and other third party sources
Request mortgage information redaction

Comparables

Unit
Status
Type
Beds
Baths
ft²
Price/ft²
Asking Price
Listed On
Closing Price
Sold On
HOA + Taxes

About South Valley Stream

Stats & Trends

Median Asking:

$979,000

Sale Price/ft²

$481

Below Asking

0.01%

Average Days on Market

105

Average Home Size

2680 ft²

Average Home Age

62.3 years

Currently For Sale

15 Listings
Based on RH Advisors, Inc. calculations of home data from MLS and/or public records.

Similar Homes for Sale

Currently no similar homes around

Nearby Rentals

Unit for rent at 104 Ormonde Boulevard, Valley Stream, NY, 11580

$4,750 /mo

  • 3 Beds
  • 1 Bath
  • 997 ft²
104 Ormonde Boulevard #HOUSERENTAL, Valley Stream, NY, 11580 Listing by Lucien Saintfort
Unit for rent at 531 Oceanpoint Avenue, Cedarhurst, NY, 11516

$4,450 /mo

  • 3 Beds
  • 1 Bath
  • 1,389 ft²
531 Oceanpoint Avenue #2NDFLOOR, Cedarhurst, NY, 11516 Listing by David Wiener
Unit for rent at 99 N. Strathmore, North Woodmere, NY, 11581

$4,750 /mo

  • 3 Beds
  • 2 Baths
  • 2,000 ft²
99 N. Strathmore, North Woodmere, NY, 11581 Listing by Jay Goldman CCIM

Rentals Near You

Click here to view more rentals in the neighborhood.
OneKey

Last Updated: 5 months ago
Data Source: OneKey MLS

Frequently Asked Questions

When was property at 797 Caldwell Avenue built and last sold?
The property at 797 Caldwell Avenue was built in 1961 and last sold on Jan 1, 1970 for $0.
How much is this home worth?
The estimated value of the home located at 797 Caldwell Avenue is $0.
What are some comparable homes to 797 Caldwell Avenue?
There are currently no comparable homes to 797 Caldwell Avenue.
Recent Neighborhood News
Haunted NYC Real Estate: 6 Spooky Stories Behind the Addresses
Lake House Prices Near NYC in 2026: What Waterfront Actually Costs (Labor Day Buyer's Guide)
9 New York City Seafood and Raw Bars
Why Some NYC Tenement Apartments Had Bathtubs in the Kitchen
Popular Searches
South Valley Stream Homes for Sale
South Valley Stream Houses for Sale
South Valley Stream Condos for Sale
South Valley Stream Homes with Basements
South Valley Stream Homes with Pools
South Valley Stream Homes with Parking
South Valley Stream Homes with Garages
South Valley Stream Homes with a View
Nearby Cities
Valley Stream Homes for Sale
Woodmere Homes for Sale
North Valley Stream Homes for Sale
Hewlett Homes for Sale
Hewlett Bay Park Homes for Sale
Nearby Property Records
Nassau County, NY Property Records
New York, NY Property Records
Hudson County, NJ Property Records
Bergen County, NJ Property Records
Union County, NJ Property Records
Essex County, NJ Property Records
Westchester County, NY Property Records
Monmouth County, NJ Property Records
Neighborhoods
Woodmere Real Estate
Laurelton Real Estate
Rosedale Real Estate
Hewlett Real Estate
Hewlett Bay Park Real Estate
Top Real Estate Agents
Top Agents in South Valley Stream
Top Agents in 11580
Top Agents in Valley Stream
Top Agents in 11581
Top Agents in Woodmere
Top Agents in Woodmere
Top Agents in 11422
Top Agents in Laurelton