$799,000
SOLD AUG 7, 2026
3 Beds
2 Baths
1,550 Sq Ft
0.64 Acre Lot

Sale Details

Date Sold: August 7, 2026

$515 Per Sq Ft

28 Days on Market

Highlights

  • Ocean View
  • Wood Flooring
  • Granite Countertops
  • 28,000 Sq Ft lot
  • High Ceiling
  • Terrace

About This Home

As of August 2026

Rarely available!

Welcome to unit 2D at 174 Beach 125th Street, a beach block stunning three-bedroom, two-bathroom duplex condo featuring private parking, two outdoor spaces, and ocean views. This house-style residence, part of the second phase of Ocean Walk Condos, is located less than a block from the beach-an opportunity you don't want to miss.

Entering through your private entrance, you ascend one flight to a spacious, open floor plan illuminated by ample sunlight and finished with hardwood floors. The living room is generously sized, accented with four windows and sliding doors that lead to a balcony, both offering ocean views. The kitchen boasts granite countertops, stainless steel appliances, and an eat-in counter that flows seamlessly into the separate dining area. Two large bedrooms, a full bathroom, a washer/dryer, and generous closet space complete this level.

Upstairs, you'll find an expansive primary suite of nearly 600 square feet, customizable to suit your needs. This space features hardwood floors, vaulted ceilings, four spacious closets, a full bathroom with glass shower doors and jacuzzi, and an additional large terrace-perfect for enjoying your morning coffee with ocean views or hosting friends during sunset.

Additional highlights include two zone central air conditioning and heat, an extra-large private storage room, a separate storage shed, low monthly common charges and taxes, and a private parking spot. Close proximity to the beach and boardwalk, shopping, and transportation makes this a true dream home!

Last Agent to Sell the Property

Kelly Neinast

Corcoran Group License #10301200640 Listed on: 04/28/2026

Corcoran Group

Co-Listed By

Kristin Neinast O'Brien

Corcoran Group License #40NE1044501

Last Buyer's Agent

Kelly Neinast

Corcoran Group License #10301200640 Listed on: 04/28/2026

Corcoran Group

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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

Property Details

Home Type

  • Multi-Family

Est. Annual Taxes

  • $7,428

Year Built

  • Built in 2006

Lot Details

  • 28,000 Sq Ft Lot
  • Lot Dimensions are 100.000000x280.000000
  • Private Entrance

HOA Fees

  • $397 Monthly HOA Fees

Parking

  • Private Parking

Home Design

  • Entry on the 2nd floor

Interior Spaces

  • 1,550 Sq Ft Home
  • 3-Story Property
  • High Ceiling
  • Wood Flooring
  • Ocean Views

Kitchen

  • Dishwasher
  • Stainless Steel Appliances
  • Granite Countertops

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet
  • 2 Full Bathrooms

Laundry

  • Laundry in unit
  • Washer Hookup

Outdoor Features

  • Balcony
  • Terrace

Utilities

  • Central Air
  • No Heating

Community Details

  • 2 Units
  • Rockaway Park Subdivision

Listing and Financial Details

  • Legal Lot and Block 7502 / 16234

Property Details

Home Type

Multi-Family

Est. Annual Taxes

$7,428

Year Built

Built in 2006

Lot Details

0.64 Acres

HOA Fees

$397 per month

Listing Details

  • Exposures: East,North,South,West
  • Property SubType: Apartment
  • Property Type: Residential
  • Neighborhood: Rockaway Park
  • Entry Level: 2
  • Structure Type: Multi Family
  • CustomProperty: { "WeeklyRate": null, "OffMarketDate": "2026-08-07", "LivingAreaRange": null, "GuestHouseYN": null, "Lang2_Type": null, "AboveGradeUnfinishedAreaRange": null, "GuestHouseAreaTotalUnits": null, "PrivateShowingInstructions": null, "NumberOfBoatSlips": null, "LotSizeRangeUnits": null, "LakeId": null, "BuildingAreaTotalRange": null, "HumanModifiedYN": true, "MineralRights": null, "LotSizeRangeSource": null, "Permission": null, "Membership": null, "ModificationTimestamp": "2026-09-10T18:49:03.547-00:00", "Restrictions": null, "BoatDockSlipFeatures": null, "OffersReviewDate": null, "AdditionalFeeFrequency": null, "PotentialShortSale": null, "TitleCompanyPhone": null, "LeaseAmountPerAreaUnit": null, "AssociationFeeTotal": null, "PropertyAccess": null, "AdditionalFee": null, "LakeSize": null, "LivingAreaRangeHigh": null, "LotSizeAreaRangeLow": null, "GarageArea": null, "BelowGradeFinishedAreaRange": null, "BuildingAreaTotalRangeSource": null, "GarageAreaUnits": null, "AdditionalFeeYN": false, "LakeChainName": null, "BelowGradeFinishedAreaRangeUnits": null, "DevelopmentName": null, "TaxAuthority": null, "ProjectName": null, "WaterAccessYN": null, "AssociationFeeTotalFrequency": null, "ListOfficeMlsId": "40076", "GarageDimensions": null, "BelowGradeBedrooms": null, "MembershipRequiredYN": null, "AboveGradeBedrooms": null, "GulfAccessYN": null, "TaxAssessedValueImprovement": null, "AboveGradeUnfinishedAreaRangeSource": null, "OtherExpenseDescription": null, "MembershipFeeFrequency": null, "ListingKeyNumeric": 1158636138, "AdditionalInfo3": null, "BoatDockSlipDescription": null, "AdditionalInfo1": null, "PublicRemarks_lang2": null, "AdditionalInfo2": null, "PublicRemarks_lang3": null, "SourceFloorPlansCount": "1", "LastMonthRentReqYN": null, "AboveGradeUnfinishedAreaRangeUnits": null, "ListAOR": null, "ThirdPartyIntegrationType": null, "BuildingAreaTotalRangeUnits": null, "PricePerAreaUnit": null, "FractionalShare": "50.00", "TitleCompanyName": null, "AboveGradeFinishedAreaRangeSource": null, "BelowGradeFinishedAreaRangeSource": null, "OriginatingSystemKey": "33915244", "GuestHouseAreaTotalSource": null, "LeaseTermsDescription": null, "PropertyType": "Residential", "LivingAreaRangeUnits": null, "OriginatingSystemName": "RLS", "BelowGradeUnfinishedAreaRangeSource": null, "LandTenure": null, "OffSeasonRate": null, "Attic": null, "MembershipFee": null, "BoatDockAccommodates": null, "PropertySubTypeAdditional": "Apartment", "PricePerArea": null, "BoatDockYN": null, "BonusAmount": null, "GuestHouseAreaTotal": null, "ListingKey": "1158636138", "GuestHouseDescription": null, "SecurityDepositYN": null, "SourceSupplementPublicCount": null, "SaleOrLeaseIncludes": null, "AdditionalFeeDescription": null, "InternetEntireListingDisplayYN": true, "SeasonRate": null, "ComplexName": null, "StoriesPartial": null, "CustomFields": "{\n \"ElevatorsTotal\": \"0\",\n \"PercentOfCommonElements\": \"50.00\",\n \"KitchenCondition\": \"Excellent\",\n \"FlipTaxRemarks\": \"0.0\",\n \"FlipTax\": \"0.00\",\n \"LandmarkStatusYN\": \"0\",\n \"CapitalReservesYN\": \"0\",\n \"BuildingTaxLot\": \"7502\",\n \"MaximumFinancingRemarks\": \"90%\",\n \"PrivateOutdoorSpaceSize\": \"GreaterThan60SqFt\",\n \"ViewRemarks\": \"See remarks\",\n \"BathroomCondition\": \"Excellent\",\n \"BuyerAgentRLSParticipantYN\": \"1\",\n \"FurnishedListPrice\": \"799000.00\",\n \"SponsorUnitYN\": \"0\",\n \"TaxDeductionPercent\": \"0.00\",\n \"CertificateOfOccupancyYN\": \"1\",\n \"TaxMonthlyAmount\": \"619.00\",\n \"TaxAbatementYN\": \"0\",\n \"AttendanceType\": \"None\",\n \"MaximumFinancingPercent\": \"90.00\",\n \"ListingKey\": \"1158636138\"\n}", "BoatDockHeight": null, "AvailabilityType": null, "LakeName": null, "OriginatingSystemSubName": "RLS_REBNY", "RiverName": null, "BelowGradeUnfinishedAreaRangeUnits": null, "ListOfficeKey": "6607384", "TaxYearRange": null, "NumberOfBoatDocks": null, "LotSizeAreaRangeHigh": null, "TaxAssessedValueLand": null, "StandardStatus": "Closed", "GulfAccessType": null, "BoatSlipYN": null, "StormProtection": null, "LivingAreaRangeSource": null, "LeaseAmountPerArea": null, "TitleCompanyAddress": null, "MonthlyRate": null, "WaterAccessDescription": null, "SecurityDepositDescription": null, "TaxRate": null, "BelowGradeUnfinishedAreaRange": null, "MembershipDescription": null, "TitleCompanyPreferred": null, "AboveGradeFinishedAreaRangeUnits": null, "AboveGradeFinishedAreaRange": null, "LivingAreaRangeLow": null, "BuildingSizeDimensions": null, "PropertySubType": "Apartment", "UnitLocation": "2", "ConsumerRemarks": null, "LotSizeRange": null, "OffersDescription": null, "Lang3_Type": null, "StoriesPartialTotal": null, "Location": null, "ListingId": null, "RentSpreeYN": null, "RentSpreeURL": null, "ApplicationFee": null, "CommunityDevelopmentDistrictYN": null, "SourceSystemKey": null }
  • Special Features: None
  • Property Sub Type: MultiFamily
  • Stories: 3

Interior Features

  • Interior Features: Granite Counters, High Ceilings, Walk-In Closet(s)
  • Appliances: Dishwasher, Stainless Steel Appliance(s)
  • Fireplace: No
  • Flooring: Hardwood
  • Living Area: 1550.0
  • Living Area Units: Square Feet
  • Basement: No

Beds/Baths

  • Full Bathrooms: 2
  • Bathrooms Integer: 2
  • Bedrooms: 3

Exterior Features

  • Pool Features: Building None
  • View: Ocean
  • View: Yes
  • Exterior Features: Balcony, Private Entrance, Private Outdoor Space Over 60 Sqft
  • Patio/Porch Features: Terrace, Balcony

Garage/Parking

  • Garage: No
  • Attached Garage: No
  • Parking Features: Private

Utilities

  • Laundry Features: Washer Hookup, In Unit, See Remarks
  • Cooling: Central Air
  • Cooling: Yes
  • Heating: No

Condo/Co-op/Association

  • Common Charge/Maintenance Fee: 397.0
  • Common Charge/Maintenance Fee Frequency: Monthly
  • Common Interest: None

Lot Info

  • Lot Size Units: Square Feet
  • Lot Size Area: 28000.0
  • Lot Size Dimensions: 100.000000x280.000000

Rental Info

  • Land Lease: No
  • Furnished: Unfurnished

Building Info

  • New Construction: No
  • Units: 2
  • Total Stories: 3
  • Year Built: 2006

Tax Info

  • Tax Block: 16234
  • Tax Lot: 7502
  • Tax Annual: 7428.0

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 28, 2026
Closed on
Aug 7, 2026
Sold by
James R Ciaio As Trustee and The James R Ciaio Revocable Trust
Bought by
Seller's Agent
Kelly Neinast
Corcoran Group
Buyer's Agent
Kelly Neinast
Corcoran Group
List Price
$799,000
Sold Price
$799,000
Views
14

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
18.87%

Purchase Details

Closed on
Dec 23, 2022
Sold by
Ciaio James R
Bought by
James R Ciaio Revocable Trust and James R Ciaio As Trustee

Purchase Details

Closed on
Jul 30, 2015
Sold by
125 Belle Harbor Llc
Bought by
Ciaio James R

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$300,000
Interest Rate
4.08%
Mortgage Type
New Conventional
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Agents Specializing in Belle Harbor, NY

See All Agents

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Deed -- --
Deed $544,764 --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Loan Amount Loan Type
Previous Owner $300,000 New Conventional
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
08/07/2026 08/07/26 Sold $799,000 0.0% $515 / Sq Ft
05/26/2026 05/26/26 Pending -- -- --
04/28/2026 04/28/26 For Sale $799,000 -- $515 / Sq Ft
Source: Real Estate Board of New York (REBNY)

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
2026 $7,400 $37,292 $3,556 $33,736
2025 $7,434 $37,292 $4,278 $33,014
2024 $7,434 $37,014 $5,088 $31,926
2023 $7,013 $34,919 $5,278 $29,641
2022 $6,576 $36,419 $5,905 $30,514
2021 $6,540 $31,077 $5,905 $25,172
2020 $7,605 $35,927 $5,905 $30,022
2019 $7,351 $37,816 $5,905 $31,911
2018 $6,758 $33,150 $5,253 $27,897
2017 $7,439 $36,492 $5,905 $30,587
2016 $7,327 $36,492 $5,905 $30,587
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Real Estate Board of New York (REBNY)

MLS Number: RLS20087279

Real Estate Board of New York (REBNY)

APN: 16234-1108

Your Personal Tour Guide

Ask me questions while you tour the home.