array:3 [
"RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=6&$skip=918&$filter=(StandardStatus in ('Active','Pending','Coming Soon','Hold','Expired') and ( City in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst') or PostalCity in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst','Lawrence')) and ListPrice le 5000000) and (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental')&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4531
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4535
+post_id: "29719"
+post_author: 1
+"ListingKey": "KEY423127141"
+"ListingId": "948236"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-02-26T19:21:36Z"
+"RFModificationTimestamp": "2026-02-26T19:26:16Z"
+"ListPrice": 1790000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 3600.0
+"BuildingAreaTotal": 3600.0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "311 Lyon Street, Hempstead, New York 11580"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6779283
+"Longitude": -73.7134322
+"YearBuilt": 1947
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Ali Rashid"
+"ListOfficeName": "Kingsland Properties"
+"ListAgentMlsId": "131127"
+"ListOfficeMlsId": "KNGL01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to 311 Lyon Street, a truly exceptional brand new residence nestled in the heart of the highly sought-after Valley Stream neighborhood. This massive home sits proudly on an expansive 8,000 square foot lot, offering the perfect blend of luxury, space, and functionality.\n
\n
Boasting 6 generously sized bedrooms and 5.5 spa-inspired bathrooms, this meticulously redesigned home offers an ideal layout for multigenerational living, entertaining, or simply enjoying abundant space and privacy.\n
\n
Step inside to discover top-of-the-line finishes throughout – from custom millwork and premium flooring to designer lighting and high-end fixtures. The chef’s kitchen is a true showstopper, featuring professional-grade appliances, quartz countertops, and a large island perfect for gatherings. The open-concept living and dining areas flow seamlessly, filled with natural light and offering a sophisticated yet comfortable atmosphere.\n
\n
Upstairs, the luxurious primary suite includes a stunning en-suite bath where dreams are made of. Additional bedrooms are spacious and bright, with beautifully appointed bathrooms throughout.\n
\n
Outside, the expansive lot offers endless possibilities – enjoy the professionally landscaped yard, build a dream patio, or create your private outdoor oasis.\n
\n
Located in a prime Valley Stream location, you’ll enjoy easy access to top-rated schools, parks, shopping, and transportation – all while living in one of the area’s most desirable and established neighborhoods.
"""
+"Appliances": array:4 [ …4]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "718-380-7400"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 5
+"BuildingAreaSource": "Plans"
+"BuildingAreaUnits": "Square Feet"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "347-592-0243"
+"CoListAgentEmail": "danyarashid@kingslandpr.com"
+"CoListAgentFullName": "Sultan Rashid"
+"CoListAgentKey": "326226155"
+"CoListAgentMlsId": "217091"
+"CoListOfficeKey": "326112922"
+"CoListOfficeMlsId": "KNGL01"
+"CoListOfficeName": "Kingsland Properties"
+"CoListOfficePhone": "718-380-7400"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-01-05T20:08:33.580656+00:00"
+"CrossStreet": "Blossom Row"
+"CumulativeDaysOnMarket": 145
+"DaysOnMarket": 76
+"ElementarySchool": "Shaw Avenue School"
+"ElementarySchoolDistrict": "Valley Stream - 30"
+"ExpirationDate": "2026-04-05"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Valley Stream Central High School"
+"HighSchoolDistrict": "Valley Stream Central"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "718-380-7400"
+"ListAgentEmail": "alirashid@kingslandpr.com"
+"ListAgentKey": "326145345"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326112922"
+"ListOfficePhone": "718-380-7400"
+"ListingAgreement": "Exclusive Agency"
+"ListingContractDate": "2026-01-05"
+"LivingAreaSource": "Plans"
+"LotSizeAcres": 0.18
+"LotSizeDimensions": "80x100"
+"LotSizeSquareFeet": 8000
+"MajorChangeTimestamp": "2026-02-26T19:19:46Z"
+"MajorChangeType": "Price Change"
+"MiddleOrJuniorSchool": "Valley Stream Memorial Junior High School"
+"MiddleOrJuniorSchoolDistrict": "Valley Stream Central"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-01-05"
+"OriginalEntryTimestamp": "2026-01-05T20:06:00Z"
+"OriginalListPrice": 1649000
+"OriginatingSystemModificationTimestamp": "2026-02-26T19:19:46Z"
+"OwnerName": "K. Holding Group LLC."
+"ParcelNumber": "373090330"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-01-05T20:07:36Z"
+"PhotosCount": 45
+"PostalCity": "Valley Stream"
+"PreviousListPrice": 1800000
+"PriceChangeTimestamp": "2026-02-26T19:19:46Z"
+"RoomsTotal": "16"
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-05T20:06:00Z"
+"StreetName": "Lyon"
+"StreetNumber": "311"
+"StreetNumberNumeric": "311"
+"StreetSuffix": "Street"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "13032.35"
+"TaxBlock": "309"
+"TaxLot": "33"
+"TaxYear": "2025"
+"Utilities": array:4 [ …4]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Full,Pull Stairs"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "37"
+"KEY_CurrentPrice": "1790000.00"
+"KEY_OpenHouseCount": "4"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "Price Decrease"
+"KEY_LivingAreaSearchSqFt": "3600.00"
+"KEY_NumberOfHeatingZones": "3"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "497.22222"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "9944444.4444"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "497.22222"
+"KEY_SourceSystemModificationTimestamp": "2026-01-05T12:19:12.170"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "497.22222"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.08551"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "497.22222"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423127141')"
+"provider_name": "One Key"
+"Media": array:45 [ …45]
+"ID": "29719"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5095
+post_id: "29712"
+post_author: 1
+"ListingKey": "KEY423123834"
+"ListingId": "948128"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-02-08T07:08:37Z"
+"RFModificationTimestamp": "2026-02-08T07:12:18Z"
+"ListPrice": 825000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2075.0
+"BuildingAreaTotal": 2075.0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "233 Meyer Avenue, Hempstead, New York 11580"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6743111
+"Longitude": -73.715555
+"YearBuilt": 1958
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Marcel Hostin"
+"ListOfficeName": "Coldwell Banker American Homes"
+"ListAgentMlsId": "183236"
+"ListOfficeMlsId": "BRMN04"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Come see this wonderful updated colonial home in Valley Stream! This property features 4 spacious bedrooms, 3 bathrooms, a formal living room, a formal dining room, and an updated kitchen. The full basement complete with an outside entrance, offers endless possibilities for added living space, recreation, or storage. Enjoy the private, fully fenced backyard with a patio that's perfect for outdoor entertaining. Conveniently located just minutes from the LIRR, schools, and shopping, this home truly has it all!"
+"Appliances": array:5 [ …5]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-302-8500"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-920-6202"
+"BuyerAgentEmail": "rsalazar.mortgage@gmail.com"
+"BuyerAgentFullName": "Ruben Salazar"
+"BuyerAgentKey": "326237352"
+"BuyerAgentMlsId": "228630"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326109949"
+"BuyerOfficeMlsId": "BRMN18"
+"BuyerOfficeName": "Coldwell Banker American Homes"
+"BuyerOfficePhone": "516-365-5780"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-01-05T15:50:54.965625+00:00"
+"CumulativeDaysOnMarket": 22
+"DaysOnMarket": 22
+"ElementarySchool": "Shaw Avenue School"
+"ElementarySchoolDistrict": "Valley Stream - 30"
+"ExpirationDate": "2026-07-31"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Valley Stream Central High School"
+"HighSchoolDistrict": "Valley Stream Central"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-260-0935"
+"ListAgentEmail": "mhostin@cbamhomes.com"
+"ListAgentKey": "326193509"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109935"
+"ListOfficePhone": "516-302-8500"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-01-05"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1113
+"LotSizeSquareFeet": 4850
+"MajorChangeTimestamp": "2026-02-07T15:14:46Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Valley Stream Memorial Junior High School"
+"MiddleOrJuniorSchoolDistrict": "Valley Stream Central"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-02-07"
+"OnMarketDate": "2026-01-16"
+"OriginalEntryTimestamp": "2026-01-05T15:47:04Z"
+"OriginalListPrice": 825000
+"OriginatingSystemModificationTimestamp": "2026-02-07T15:14:46Z"
+"OwnerName": "Pardo"
+"ParcelNumber": "2035-37-451-01-0010-0"
+"ParkingFeatures": array:2 [ …2]
+"PhotosChangeTimestamp": "2026-01-16T21:09:38Z"
+"PhotosCount": 21
+"PostalCity": "Valley Stream"
+"PostalCodePlus4": "3133"
+"PurchaseContractDate": "2026-02-07"
+"RoomsTotal": "10"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-260-0935"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-02-07T15:14:46Z"
+"StreetName": "Meyer"
+"StreetNumber": "233"
+"StreetNumberNumeric": "233"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "14201.09"
+"TaxAssessedValue": 538
+"TaxYear": "2024"
+"Utilities": array:3 [ …3]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "825000.00"
+"KEY_ContractPrice": "870000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "2075.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "397.59036"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "7412398.9218"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "397.59036"
+"KEY_SourceSystemModificationTimestamp": "2026-01-05T10:10:03.043"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "397.59036"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "397.59036"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423123834')"
+"provider_name": "One Key"
+"Media": array:21 [ …21]
+"ID": "29712"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4607
+post_id: "29706"
+post_author: 1
+"ListingKey": "KEY423120367"
+"ListingId": "948022"
+"PropertyType": "Residential"
+"PropertySubType": "Stock Cooperative"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-30T14:25:36Z"
+"RFModificationTimestamp": "2026-01-30T14:27:20Z"
+"ListPrice": 339000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 825.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11563"
+"UnparsedAddress": "200 Atlantic Avenue Unit 331, Hempstead, New York 11563"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 1963
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Don Vekiaropoulos"
+"ListOfficeName": "HomeSmart CrossIsland"
+"ListAgentMlsId": "147894"
+"ListOfficeMlsId": "CRXI02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Spacious 1 Bedroom with Elite Amenities. This stunning, well-maintained 1-bedroom Co-Op offering approx 825 SQFT of thoughtfully designed space—ideal for comfortable living. Features include a king-size bedroom with large closets, an open-concept living/dining area, a combo kitchen with all brand new appliances, a formal dining space, a food pantry, a full bath, and ample closet storage. Brand New Appliances. Building Amenities: Laundry facilities on every floor, a refreshing outdoor pool, a well-maintained lobby, and an assigned parking spot. Prime Location! Nestled near public transportation, LIRR, JFK, Schools, Parks, Beaches, and Houses of Worship, this unit offers both convenience and tranquillity. Enjoy the serene surroundings near urban conveniences. Move right in!"
+"Appliances": array:5 [ …5]
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFee": "1169"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [ …3]
+"AssociationYN": true
+"AttributionContact": "516-373-2460"
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "646-238-8656"
+"CoListAgentEmail": "jibran@hdrestate.io"
+"CoListAgentFullName": "Jibran A. Chouhan"
+"CoListAgentKey": "326178993"
+"CoListAgentMlsId": "167530"
+"CoListOfficeKey": "326110564"
+"CoListOfficeMlsId": "CRXI02"
+"CoListOfficeName": "HomeSmart CrossIsland"
+"CoListOfficePhone": "516-373-2460"
+"CommonWalls": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"Country": "US"
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-01-05T08:38:59.409987+00:00"
+"CumulativeDaysOnMarket": 283
+"DaysOnMarket": 77
+"Directions": "GPS or Google Maps"
+"ElementarySchool": "Marion Street School"
+"ElementarySchoolDistrict": "Lynbrook"
+"EntryLevel": 4
+"ExpirationDate": "2027-01-04"
+"Flooring": array:1 [ …1]
+"FoundationDetails": array:1 [ …1]
+"Heating": array:1 [ …1]
+"HighSchool": "Lynbrook Senior High School"
+"HighSchoolDistrict": "Lynbrook"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:3 [ …3]
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-983-9093"
+"ListAgentEmail": "vickersdon1@aol.com"
+"ListAgentKey": "326160761"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110564"
+"ListOfficePhone": "516-373-2460"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-01-04"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.0239
+"LotSizeSquareFeet": 1040
+"MajorChangeTimestamp": "2026-01-04T23:04:23Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "Lynbrook North Middle School"
+"MiddleOrJuniorSchoolDistrict": "Lynbrook"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-01-04"
+"OriginalEntryTimestamp": "2026-01-04T23:04:23Z"
+"OriginalListPrice": 339000
+"OriginatingSystemModificationTimestamp": "2026-01-30T14:24:24Z"
+"OwnerName": "Nicole"
+"ParcelNumber": "2025-38-500-00-0004-0"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-01-04T23:08:36Z"
+"PhotosCount": 28
+"PoolFeatures": array:1 [ …1]
+"PostalCity": "Lynbrook"
+"PriceChangeTimestamp": "2026-01-04T23:04:23Z"
+"PropertyAttachedYN": true
+"PropertyCondition": array:1 [ …1]
+"RoomsTotal": "6"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-983-9093"
+"ShowingRequirements": array:3 [ …3]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-04T23:04:23Z"
+"StoriesTotal": "4"
+"StreetName": "Atlantic"
+"StreetNumber": "200"
+"StreetNumberNumeric": "200"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"UnitNumber": "331"
+"Utilities": array:6 [ …6]
+"WaterSource": array:1 [ …1]
+"KEY_CurrentPrice": "339000.00"
+"KEY_OpenHouseCount": "0"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_ApprovalRequiredYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_EstimatedMaintenance": "1169"
+"KEY_LivingAreaSearchSqFt": "825.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_MinimumPctDownPayment": "20"
+"KEY_RATIO_ListPrice_By_LivingArea": "410.90909"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "14184100.4184"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "410.90909"
+"KEY_SourceSystemModificationTimestamp": "2026-01-04T18:04:23.030"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423120367')"
+"provider_name": "One Key"
+"Media": array:28 [ …28]
+"ID": "29706"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4608
+post_id: "29708"
+post_author: 1
+"ListingKey": "KEY423119966"
+"ListingId": "948007"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Multi Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-22T16:02:36Z"
+"RFModificationTimestamp": "2026-01-22T16:06:38Z"
+"ListPrice": 1790000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 10500.0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "83-91 Ocean Avenue, Hempstead, New York 11580"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6794899
+"Longitude": -73.7256497
+"YearBuilt": 1938
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Min Xiao"
+"ListOfficeName": "Welhome Realty Inc"
+"ListAgentMlsId": "185598"
+"ListOfficeMlsId": "WLHR01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Excellent Mixed-Use Value add Investment Opportunity – Strong Income Potential It is a well-located mixed-use property featuring 5 retail storefronts and 2 one-bedroom residential units. Situated on a high-visibility commercial block with steady traffic and strong local demand. Multiple income streams with upside potential through rent optimization. Convenient access to transportation, major highways, and surrounding neighborhoods. Ideal for investors seeking stable cashflow with long-term appreciation. Cap rate Approx.8.5%. Must see!"
+"AdditionalParcelsYN": true
+"AttributionContact": "347-654-7599"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-01-05T08:39:45.347350+00:00"
+"CumulativeDaysOnMarket": 18
+"DaysOnMarket": 77
+"ExpirationDate": "2026-07-03"
+"Heating": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "347-654-7599"
+"ListAgentEmail": "sammix688@gmail.com"
+"ListAgentKey": "326195763"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326116493"
+"ListOfficePhone": "646-535-1268"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-01-04"
+"LotSizeAcres": 0.24
+"MajorChangeTimestamp": "2026-01-04T21:37:22Z"
+"MajorChangeType": "New Listing"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"NumberOfUnitsTotal": "7"
+"OnMarketDate": "2026-01-04"
+"OriginalEntryTimestamp": "2026-01-04T21:37:22Z"
+"OriginalListPrice": 1790000
+"OriginatingSystemModificationTimestamp": "2026-01-22T16:01:19Z"
+"OwnerName": "Golden Harbour"
+"ParcelNumber": "37-401-114 & 37-401-477"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-01-04T21:38:36Z"
+"PhotosCount": 5
+"PostalCity": "Valley Stream"
+"PriceChangeTimestamp": "2026-01-04T21:37:22Z"
+"PropertyAttachedYN": true
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "347-654-7599"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-04T21:37:22Z"
+"StoriesTotal": "5"
+"StreetName": "Ocean"
+"StreetNumber": "83-91"
+"StreetNumberNumeric": "83"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:3 [ …3]
+"TaxAnnualAmount": "47231"
+"TaxAssessedValue": 6178
+"TaxYear": "2025"
+"Utilities": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "1790000.00"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "7458333.3333"
+"KEY_SourceSystemModificationTimestamp": "2026-01-04T16:37:22.597"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "170.47619"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "170.47619"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423119966')"
+"provider_name": "One Key"
+"Media": array:5 [ …5]
+"ID": "29708"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4572
+post_id: "29711"
+post_author: 1
+"ListingKey": "KEY423118062"
+"ListingId": "947926"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-20T19:30:36Z"
+"RFModificationTimestamp": "2026-03-20T19:36:34Z"
+"ListPrice": 889000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1836.0
+"BuildingAreaTotal": 1836.0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "19 Sprague Drive, Hempstead, New York 11580"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6744259
+"Longitude": -73.7040333
+"YearBuilt": 1948
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Anthony G. Gunther"
+"ListOfficeName": "Robert J Gunther Appraisals"
+"ListAgentMlsId": "9055477"
+"ListOfficeMlsId": "GUNT01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Immaculate and beautifully renovated home on quiet residential street in the heart of Valley Stream Village. The interior has been renovated in the last two years, with new sheetrock walls and ceilings, and refinished or new hardwood floors. Open concept living/dining rooms have recessed lighting. Eat-in kitchen is new, with stone counters and stainless appliances including a true six-burner stove. Both baths have been gut renovated with ceramic tile and all new fixtures. The first floor includes living room, dining room, kitchen, bedroom and full bath. The second floor has four large bedrooms and a full bath. One of the second floor bedrooms is set up as a cozy den. Full basement has high ceilings and plenty of storage. Exterior features include a large side patio, underground sprinklers, detached brick garage and driveway. Sprague Drive is centrally located and nearby schools, shopping and the Hendrickson Park and Pool Complex. Hendrickson Park is known for its beautiful lake, walking, jogging and cycling paths, as well as tennis and basketball courts and a children's playground. Valley Stream State Park is also nearby and includes wooded paths, playgrounds, picnic area and softball/soccer fields. A known commuter town, Valley Stream Station of the Long Island Railroad provides quick access the New York City and permit parking for village residents."
+"Appliances": array:3 [ …3]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-825-6420"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-01-05T09:07:51.122835+00:00"
+"CrossStreet": "Kent Road"
+"CumulativeDaysOnMarket": 75
+"DaysOnMarket": 77
+"ElementarySchool": "Wheeler Avenue School"
+"ElementarySchoolDistrict": "Valley Stream - 13"
+"ExpirationDate": "2026-07-04"
+"Flooring": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:2 [ …2]
+"HighSchool": "Valley Stream Central High School"
+"HighSchoolDistrict": "Valley Stream Central"
+"InteriorFeatures": array:4 [ …4]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "guntherappraisal@gmail.com"
+"ListAgentKey": "326259735"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326111847"
+"ListOfficePhone": "516-825-6420"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-01-04"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1263
+"LotSizeSquareFeet": 5500
+"MajorChangeTimestamp": "2026-01-04T15:19:18Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "Valley Stream Memorial Junior High School"
+"MiddleOrJuniorSchoolDistrict": "Valley Stream Central"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-01-04"
+"OriginalEntryTimestamp": "2026-01-04T15:19:18Z"
+"OriginalListPrice": 889000
+"OriginatingSystemModificationTimestamp": "2026-03-20T19:28:55Z"
+"OwnerName": "Steven Pascuzzi & Roberta Costanza"
+"ParcelNumber": "2035-37-542-00-0001-0"
+"ParkingFeatures": array:2 [ …2]
+"ParkingTotal": "2"
+"PatioAndPorchFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-01-04T15:20:36Z"
+"PhotosCount": 30
+"PostalCity": "Valley Stream"
+"PostalCodePlus4": "3328"
+"PriceChangeTimestamp": "2026-01-04T15:19:18Z"
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-353-3241"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-04T15:19:18Z"
+"StreetName": "Sprague"
+"StreetNumber": "19"
+"StreetNumberNumeric": "19"
+"StreetSuffix": "Drive"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "14444.24"
+"TaxAssessedValue": 551
+"TaxYear": "2024"
+"Utilities": array:6 [ …6]
+"WaterSource": array:1 [ …1]
+"WindowFeatures": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_Village": "Valley Stream"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "889000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_LivingAreaSearchSqFt": "1836.00"
+"KEY_ShowingContactPhone2": "516-353-3241"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "484.20479"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "7038796.5162"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "484.20479"
+"KEY_SourceSystemModificationTimestamp": "2026-01-04T10:19:18.590"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "484.20479"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "484.20479"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423118062')"
+"provider_name": "One Key"
+"Media": array:30 [ …30]
+"ID": "29711"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4573
+post_id: "29701"
+post_author: 1
+"ListingKey": "KEY423113503"
+"ListingId": "947786"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-01-21T07:07:41Z"
+"RFModificationTimestamp": "2026-01-21T07:10:43Z"
+"ListPrice": 1799999.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3600.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "217 Bayview Avenue, Hempstead, New York 11566"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.657605
+"Longitude": -73.5457486
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Luis Barreto"
+"ListOfficeName": "Compass Greater NY LLC"
+"ListAgentMlsId": "219746"
+"ListOfficeMlsId": "CMPA07"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Discover modern elegance in this exquisite new construction home located in the beautiful town of Merrick!. This 3600 square foot stunning residence offers 5 spacious bedrooms and 4.5 luxurious bathrooms, providing ample space for comfort and privacy. The home's design features a two-car garage and a versatile basement with a separate entrance, perfect for personalized use. Nestled on an expansive 75 by 150 lot, this property offers a serene setting while being conveniently close to restaurants, LIRR, and vibrant shopping destinations. The heart of this home is the gourmet kitchen, featuring custom cabinetry, a pot filler, a farm sink, and a massive custom quartz island—ideal for entertaining or casual meals. The primary bedroom offers a tray ceiling with two walk-in closets and a custom bathroom, equipped with double sinks, a stand-up shower, and a soaker tub. With plenty of time to customize every detail to your liking, this home is a rare opportunity to create your dream oasis. Embrace the chance to tailor this elegant modern masterpiece to your unique lifestyle!"
+"Appliances": array:9 [ …9]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "917-971-4627"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 4
+"BuildingAreaSource": "Plans"
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "HGAR"
+"BuyerAgentDirectPhone": "000-000-0000"
+"BuyerAgentFullName": "Unrepresented Buyer"
+"BuyerAgentKey": "421786246"
+"BuyerAgentMlsId": "347752"
+"BuyerOfficeAOR": "HGAR"
+"BuyerOfficeKey": "1262827"
+"BuyerOfficeMlsId": "888888"
+"BuyerOfficeName": "Buyer Representation Office"
+"BuyerOfficePhone": "000-000-0000"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-01-03T16:39:35.430236+00:00"
+"CumulativeDaysOnMarket": 166
+"DaysOnMarket": 17
+"ElementarySchool": "Norman J Levy Lakeside School"
+"ElementarySchoolDistrict": "Merrick"
+"ExpirationDate": "2026-07-03"
+"FireplaceFeatures": array:2 [ …2]
+"FireplaceYN": true
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:4 [ …4]
+"HighSchool": "John F Kennedy High School"
+"HighSchoolDistrict": "Merrick"
+"InteriorFeatures": array:23 [ …23]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:3 [ …3]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "917-971-4627"
+"ListAgentEmail": "luis.barreto@compass.com"
+"ListAgentKey": "326228733"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110404"
+"ListOfficePhone": "516-764-6060"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-01-03"
+"LivingAreaSource": "Plans"
+"LotSizeAcres": 0.26
+"LotSizeDimensions": "75 x 150"
+"LotSizeSquareFeet": 11250
+"MajorChangeTimestamp": "2026-01-20T16:54:37Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Merrick Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Merrick"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-01-20"
+"OnMarketDate": "2026-01-03"
+"OriginalEntryTimestamp": "2026-01-03T16:37:14Z"
+"OriginalListPrice": 1799999
+"OriginatingSystemModificationTimestamp": "2026-01-20T16:54:37Z"
+"OwnerName": "not available"
+"ParkingFeatures": array:3 [ …3]
+"PhotosChangeTimestamp": "2026-01-03T16:50:36Z"
+"PhotosCount": 4
+"PostalCity": "Merrick"
+"PriceChangeTimestamp": "2026-01-03T16:37:14Z"
+"PropertyCondition": array:1 [ …1]
+"PurchaseContractDate": "2026-01-20"
+"RoomsTotal": "13"
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-20T16:54:37Z"
+"StreetName": "Bayview"
+"StreetNumber": "217"
+"StreetNumberNumeric": "217"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "4995"
+"TaxYear": "2025"
+"Utilities": array:5 [ …5]
+"WaterSource": array:1 [ …1]
+"WindowFeatures": array:1 [ …1]
+"KEY_Attic": "Full,Pull Stairs,Unfinished"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "1799999.00"
+"KEY_ContractPrice": "1675000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_PreviousStatus": "Active"
+"KEY_AdditionalFeesYN": "0"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "3600.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "499.99972"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6923073.0769"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "499.99972"
+"KEY_SourceSystemModificationTimestamp": "2026-01-03T11:37:14.850"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY423113503')"
+"provider_name": "One Key"
+"Media": array:4 [ …4]
+"ID": "29701"
}
]
+success: true
+page_size: 6
+page_count: 294
+count: 1761
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=6&$skip=918&$filter=(StandardStatus in ('Active','Pending','Coming Soon','Hold','Expired') and ( City in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst') or PostalCity in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst','Lawrence')) and ListPrice le 5000000) and (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential'&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5094
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5077
+post_id: "29467"
+post_author: 1
+"ListingKey": "KEY422783103"
+"ListingId": "938685"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2026-01-02T05:12:38Z"
+"RFModificationTimestamp": "2026-01-02T05:15:16Z"
+"ListPrice": 1250000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2800.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11510"
+"UnparsedAddress": "300 Harbor Street, Hempstead, New York 11510"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6356132
+"Longitude": -73.6138043
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Erik C. Mahler CBR"
+"ListOfficeName": "Mahler Realty"
+"ListAgentMlsId": "85303"
+"ListOfficeMlsId": "MAHL01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Step into brand-new luxury living where scale, light, and craftsmanship meet every day ease. This elevated, FEMA-compliant 2025 build offers 4BR/3BA across 2,800 SF, with an open plan anchored by a jaw-dropping 20' & 20' chef’s kitchen—an entertainer’s dream—starring a grand center island, full stainless-steel package, and a true walk-in pantry with floor-to-ceiling storage. Sun-splashed living and dining flow effortlessly for hosting or quiet nights in, elevated by refined finishes, designer lighting, and custom millwork. The serene primary suite lives like a private retreat with a boutique-style closet and spa-inspired bath; generous secondary bedrooms flex for guests/office/studio. Thoughtful storage, smooth circulation, and modern, energy-efficient systems make daily life organized and effortless. Turn the key and live large."
+"Appliances": array:9 [ …9]
+"ArchitecturalStyle": array:3 [ …3]
+"AttributionContact": "516-223-3111"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-265-4816"
+"CoListAgentEmail": "peyton@mahlerrealty.com"
+"CoListAgentFullName": "Peyton Mahler"
+"CoListAgentKey": "419072345"
+"CoListAgentMlsId": "503294"
+"CoListOfficeKey": "326113441"
+"CoListOfficeMlsId": "MAHL01"
+"CoListOfficeName": "Mahler Realty"
+"CoListOfficePhone": "516-223-3111"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:3 [ …3]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-12-01T08:29:02.778986+00:00"
+"CrossStreet": "Fishermans"
+"CumulativeDaysOnMarket": 32
+"DaysOnMarket": 32
+"Directions": "Grand Ave South to Fishermans Rd West"
+"ElementarySchool": "Meadow Elementary School"
+"ElementarySchoolDistrict": "Baldwin"
+"ExpirationDate": "2026-01-02"
+"ExteriorFeatures": array:1 [ …1]
+"Fencing": array:3 [ …3]
+"FireplaceFeatures": array:2 [ …2]
+"FireplaceYN": true
+"Flooring": array:3 [ …3]
+"FoundationDetails": array:1 [ …1]
+"GarageSpaces": "3"
+"GarageYN": true
+"Heating": array:4 [ …4]
+"HighSchool": "Baldwin Senior High School"
+"HighSchoolDistrict": "Baldwin"
+"InteriorFeatures": array:15 [ …15]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "erik@mahlerrealty.com"
+"ListAgentKey": "326245957"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326113441"
+"ListOfficePhone": "516-223-3111"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-12-01"
+"LivingAreaSource": "Plans"
+"LotFeatures": array:4 [ …4]
+"LotSizeAcres": 0.18
+"LotSizeDimensions": "55x103"
+"LotSizeSquareFeet": 5040
+"MajorChangeTimestamp": "2026-01-02T05:10:47Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "Baldwin Middle School"
+"MiddleOrJuniorSchoolDistrict": "Baldwin"
+"MlsStatus": "Expired"
+"OffMarketDate": "2026-01-02"
+"OnMarketDate": "2025-12-01"
+"OriginalEntryTimestamp": "2025-12-01T08:25:20Z"
+"OriginalListPrice": 1250000
+"OriginatingSystemModificationTimestamp": "2026-01-02T05:10:47Z"
+"OwnerName": "Erika James"
+"ParcelNumber": "2089-54-431-00-0043-0"
+"ParkingFeatures": array:5 [ …5]
+"ParkingTotal": "4"
+"PatioAndPorchFeatures": array:4 [ …4]
+"PhotosChangeTimestamp": "2025-12-01T08:26:36Z"
+"PhotosCount": 40
+"PostalCity": "Baldwin"
+"PropertyCondition": array:1 [ …1]
+"RoadFrontageType": array:1 [ …1]
+"RoadResponsibility": array:1 [ …1]
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-223-3111"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-02T05:10:47Z"
+"StreetName": "Harbor"
+"StreetNumber": "300"
+"StreetNumberNumeric": "300"
+"StreetSuffix": "Street"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "1"
+"TaxBlock": "431"
+"TaxLot": "43"
+"TaxYear": "2025"
+"Utilities": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"WindowFeatures": array:5 [ …5]
+"YearBuiltEffective": 2025
+"KEY_Attic": "Storage"
+"KEY_Hamlet": "Baldwin"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "54"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "1250000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_IncludedInTaxes": "Sewer,Trash"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_LivingAreaSearchSqFt": "2800.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "446.42857"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6944444.4444"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "446.42857"
+"KEY_SourceSystemModificationTimestamp": "2025-11-24T14:59:23.290"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422783103')"
+"provider_name": "One Key"
+"Media": array:40 [ …40]
+"ID": "29467"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4605
+post_id: "30393"
+post_author: 1
+"ListingKey": "KEY422778470"
+"ListingId": "938547"
+"PropertyType": "Residential"
+"PropertySubType": "Stock Cooperative"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-03-10T07:03:39Z"
+"RFModificationTimestamp": "2026-03-10T07:06:54Z"
+"ListPrice": 297000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1000.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11559"
+"UnparsedAddress": "285 Central Avenue Unit D-7, Hempstead, New York 11559"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 1950
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Lori Schlesinger"
+"ListOfficeName": "Lori & Associates LI Realty"
+"ListAgentMlsId": "87462"
+"ListOfficeMlsId": "LORA01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Fully Renovated top Floor (second Floor) unit. Laundry Facility In the Basement. Hardwood floors just done, Renovated Kitchen with New appliances & Granite Countertops, Renovated Full Bathroom with a Bathtub, 2 spacious Bedrooms, Live in Super, outdoor Designated Parking spot available & indoor Garage spot has a waiting list. Maintenance $1222.71/month plus an assessment for 2026 (ends December 2026) for $134.03/month."
+"Appliances": array:4 [ …4]
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFeeIncludes": array:1 [ …1]
+"AttributionContact": "516-791-8300"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 1
+"BuilderModel": "Garden Apt"
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "917-620-0572"
+"BuyerAgentEmail": "elliebaum@gmail.com"
+"BuyerAgentFullName": "Elisheva Baum"
+"BuyerAgentKey": "326204848"
+"BuyerAgentMlsId": "195126"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326113756"
+"BuyerOfficeMlsId": "MLKY01"
+"BuyerOfficeName": "Milky Forst Properties Inc"
+"BuyerOfficePhone": "516-239-0306"
+"CommonWalls": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-11-24T15:44:46.108272+00:00"
+"CrossStreet": "Rockaway Tpke"
+"CumulativeDaysOnMarket": 102
+"DaysOnMarket": 102
+"Directions": "On Central Avenue Opposite The Peninsula Public Library...Off Rockaway Tpke."
+"ElementarySchool": "Lawrence Early Childhood-#4 School"
+"ElementarySchoolDistrict": "Lawrence"
+"EntryLevel": 2
+"ExpirationDate": "2026-05-31"
+"Flooring": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:2 [ …2]
+"HighSchool": "Lawrence Senior High School"
+"HighSchoolDistrict": "Lawrence"
+"InteriorFeatures": array:4 [ …4]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "loriandassociates@gmail.com"
+"ListAgentKey": "326247724"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326113285"
+"ListOfficePhone": "516-791-8300"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-11-24"
+"LivingAreaSource": "Other"
+"MajorChangeTimestamp": "2026-03-09T15:33:27Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "LAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS"
+"MiddleOrJuniorSchoolDistrict": "Lawrence"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-03-09"
+"OnMarketDate": "2025-11-24"
+"OriginalEntryTimestamp": "2025-11-24T15:38:56Z"
+"OriginalListPrice": 299000
+"OriginatingSystemModificationTimestamp": "2026-03-09T15:33:27Z"
+"OwnerName": "Lawrence Associates"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-11-28T17:12:36Z"
+"PhotosCount": 8
+"PostalCity": "Lawrence"
+"PreviousListPrice": 299000
+"PriceChangeTimestamp": "2026-01-05T17:09:21Z"
+"PropertyAttachedYN": true
+"PurchaseContractDate": "2026-03-06"
+"RoomsTotal": "5"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-410-4210"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-03-09T15:33:27Z"
+"StoriesTotal": "2"
+"StreetName": "Central"
+"StreetNumber": "285"
+"StreetNumberNumeric": "285"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "Lawrence Woods"
+"SyndicateTo": array:2 [ …2]
+"UnitNumber": "D-7"
+"Utilities": array:6 [ …6]
+"WaterSource": array:1 [ …1]
+"KEY_Village": "Lawrence"
+"KEY_FlipTaxYN": "1"
+"KEY_ParkingFee": "75"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "297000.00"
+"KEY_ContractPrice": "300000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_AdditionalFeesYN": "0"
+"KEY_RentingAllowedYN": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_ApprovalRequiredYN": "1"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_EstimatedMaintenance": "1223"
+"KEY_LivingAreaSearchSqFt": "1000.00"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_MinimumPctDownPayment": "20"
+"KEY_RATIO_ListPrice_By_LivingArea": "297.00000"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "297.00000"
+"KEY_SourceSystemModificationTimestamp": "2025-11-24T10:38:56.147"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.99331"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422778470')"
+"provider_name": "One Key"
+"Media": array:8 [ …8]
+"ID": "30393"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#317
+post_id: "29790"
+post_author: 1
+"ListingKey": "KEY422778456"
+"ListingId": "938545"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-01-26T07:04:41Z"
+"RFModificationTimestamp": "2026-01-26T07:06:13Z"
+"ListPrice": 814999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2252.0
+"BuildingAreaTotal": 2252.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "54 W 2nd Street, Hempstead, New York 11520"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6410626
+"Longitude": -73.5752563
+"YearBuilt": 1956
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Nicole Campisi"
+"ListOfficeName": "Keller Williams Points North"
+"ListAgentMlsId": "171166"
+"ListOfficeMlsId": "KEWG03"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "What A Gem of a Home! Far From A Cookie Cutter or Typical Cape As This Waterfront Beauty Has An Amazing Flow! Wide Open Floor Plan, Huge/Beautiful Kitchen w/Oversized Center Island (Neutral Tile Flooring), Tons of Cabinets & Countertop (Granite) Space! Gorgeous Hardwood Floors Throughout (Except Kitchen, Bathrooms and Family Room), Sunk In Family Room (Wide Plank Vinyl Flooring) with Wood Burning Fireplace. Natural Gas (Cooking and Heat), Radiant Heat in Kitchen & Family Room. New Boiler Installed in 2022, Tankless HW Heater, Cedar Tek Siding 2015. Generous Size Bedrooms. The Second Floor has 8ft Ceilings, Primary Ensuite is Incredible! Beautiful Primary Bath with Separate Tub and Shower! and the Most Magnificent Part is the Enormous Walk in Closet with Washer and Dryer. Backyard entrance fence is new (2021) with double doors opening to backyard. It's a WOW factor Indeed. Please see the Short Video in Photos. Generous, Flat Yard space. Whether You are a Boater or You Jet ski, or Both. There is Plenty of Space in the Water for All of Your Water Toys. 77 Feet of Bulkhead on the Canal,, Right in Your Backyard. Lifestyle Doesn't Get Much Better!"
+"Appliances": array:6 [ …6]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-865-1800"
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-554-5230"
+"BuyerAgentEmail": "luis@oversouthre.com"
+"BuyerAgentFullName": "Luis Genao"
+"BuyerAgentKey": "326221684"
+"BuyerAgentMlsId": "212482"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "406610771"
+"BuyerOfficeMlsId": "OVRS02"
+"BuyerOfficeName": "Oversouth LLC"
+"BuyerOfficePhone": "631-770-0030"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-01-13T14:27:46.219525+00:00"
+"CrossStreet": "Main Street"
+"CumulativeDaysOnMarket": 11
+"DaysOnMarket": 11
+"Directions": "Main Street to W. 2nd Street"
+"Disclosures": array:1 [ …1]
+"ElementarySchool": "Leo F Giblyn School"
+"ElementarySchoolDistrict": "Freeport"
+"ExpirationDate": "2026-07-13"
+"Fencing": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:2 [ …2]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "631-398-3992"
+"ListAgentEmail": "nicolecampisi@kw.com"
+"ListAgentKey": "326182329"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326112863"
+"ListOfficePhone": "516-865-1800"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-01-13"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:3 [ …3]
+"LotSizeAcres": 0.1607
+"LotSizeSquareFeet": 7000
+"MajorChangeTimestamp": "2026-01-25T19:29:11Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "John W Dodd Middle School"
+"MiddleOrJuniorSchoolDistrict": "Freeport"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-01-25"
+"OnMarketDate": "2026-01-13"
+"OriginalEntryTimestamp": "2026-01-13T14:24:16Z"
+"OriginalListPrice": 814999
+"OriginatingSystemModificationTimestamp": "2026-01-25T19:29:11Z"
+"OwnerName": "Mueller"
+"ParcelNumber": "2009-62-062-00-0263-0"
+"ParkingFeatures": array:2 [ …2]
+"PhotosChangeTimestamp": "2026-01-13T16:03:36Z"
+"PhotosCount": 50
+"PostalCity": "Freeport"
+"PostalCodePlus4": "5730"
+"PropertyCondition": array:1 [ …1]
+"PurchaseContractDate": "2026-01-24"
+"RoomsTotal": "8"
+"SecurityFeatures": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "631-398-3992"
+"ShowingRequirements": array:3 [ …3]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-25T19:29:11Z"
+"StreetDirPrefix": "W"
+"StreetName": "2nd"
+"StreetNumber": "54"
+"StreetNumberNumeric": "54"
+"StreetSuffix": "Street"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "10091.05"
+"TaxAssessedValue": 512
+"TaxYear": "2025"
+"Utilities": array:2 [ …2]
+"VirtualTourURLBranded": "https://ny360tours.hd.pics/54-W-2nd-St"
+"VirtualTourURLUnbranded": "https://ny360tours.hd.pics/54-W-2nd-St/idx"
+"WaterSource": array:1 [ …1]
+"WaterfrontFeatures": array:1 [ …1]
+"WaterfrontYN": true
+"WindowFeatures": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "814999.00"
+"KEY_ContractPrice": "815000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "2252.00"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "361.90009"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "5071555.6938"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "361.90009"
+"KEY_SourceSystemModificationTimestamp": "2025-11-24T10:37:28.937"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "361.90009"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "361.90009"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422778456')"
+"provider_name": "One Key"
+"Media": array:50 [ …50]
+"ID": "29790"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5111
+post_id: "29470"
+post_author: 1
+"ListingKey": "KEY422775678"
+"ListingId": "938487"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-02-14T07:05:38Z"
+"RFModificationTimestamp": "2026-02-14T07:07:41Z"
+"ListPrice": 1499000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2337.0
+"BuildingAreaTotal": 2874.0
+"City": "Hempstead"
+"PostalCode": "11572"
+"UnparsedAddress": "3522 Frederick Street, Hempstead, New York 11572"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.632187
+"Longitude": -73.6169459
+"YearBuilt": 1961
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Eric Joseph"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "227348"
+"ListOfficeMlsId": "DERE61"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "This premier waterfront residence sits secluded at the very end of a beautifully tree lined street nestled in the Estates section of Oceanside.The property is situated on a generous quarter-acre lot with over 160 feet of canal frontage. The home features four bedrooms and 2.5 baths, including a primary bedroom with an en suite bathroom, walk in closet, and a south-facing balcony overlooking the wide canal leading to Parson's creek and the Middle Bay. Hardwood floors span the interior, complemented by two wood-burning fireplaces that add warmth and character. As you walk in the front door, you’re greeted by abundant natural light from two skylights set high in the 15-foot ceilings, creating a bright, airy entry. An indoor pool, which is heated and cedar-lined, make it a truly one of a kind property- perfect for year-round swimming and entertaining. The pool connects to a back patio with sliders, creating seamless flow for hosting guests in any season. The second floor boasts a balcony overlooking the living room, and every room benefits from abundant natural light through skylights throughout the home. The built-in gas stove top, granite countertops, grill, and sink on the secondary deck provide additional outdoor cooking and entertaining options. The property includes a two-car garage and substantial expansion potential. Outdoor living is highlighted by a private backyard framed by mature trees—an ideal setting for relaxation and gatherings by the water. Waterfront amenities include a boat lift and two docks, with a bulkhead that was replaced after Sandy, ensuring sturdy waterfront infrastructure. The home has been meticulously cared for and maintained, reflecting more than forty years of attentive ownership. The backyard is tranquil and perfect for entertaining, with serene views of the water and a wider canal segment that offers straightforward access straight out to the Middle Bay. This residence combines timeless charm with modern conveniences in a sought-after Oceanside location, offering privacy, convenience, and a lifestyle focused on coastal living."
+"Appliances": array:9 [ …9]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-746-0440"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaSource": "Other"
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-238-7492"
+"BuyerAgentEmail": "mkrealtor1@gmail.com"
+"BuyerAgentFullName": "Michael L. Karlen"
+"BuyerAgentKey": "326129652"
+"BuyerAgentMlsId": "113854"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326115723"
+"BuyerOfficeMlsId": "SPH15"
+"BuyerOfficeName": "Signature Premier Properties"
+"BuyerOfficePhone": "516-766-7900"
+"CoBuyerAgentAOR": "LIBOR"
+"CoBuyerAgentDirectPhone": "516-458-4847"
+"CoBuyerAgentEmail": "rmanel@Signature Premier.com"
+"CoBuyerAgentFullName": "Robert D. Manel"
+"CoBuyerAgentKey": "326132189"
+"CoBuyerAgentMlsId": "116555"
+"CoBuyerOfficeKey": "326115723"
+"CoBuyerOfficeMlsId": "SPH15"
+"CoBuyerOfficeName": "Signature Premier Properties"
+"CoBuyerOfficePhone": "516-766-7900"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "347-860-0654"
+"CoListAgentEmail": "Lauren.Joseph@elliman.com"
+"CoListAgentFullName": "Lauren C. Joseph"
+"CoListAgentKey": "422468059"
+"CoListAgentMlsId": "505541"
+"CoListOfficeKey": "326110785"
+"CoListOfficeMlsId": "DERE61"
+"CoListOfficeName": "Douglas Elliman Real Estate"
+"CoListOfficePhone": "516-746-0440"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"Country": "US"
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-12-01T12:40:55.306401+00:00"
+"CumulativeDaysOnMarket": 74
+"DaysOnMarket": 74
+"Directions": "Very end of Frederick Street on Left"
+"Disclosures": array:2 [ …2]
+"ElementarySchool": "School 9E-Boardman Elem School"
+"ElementarySchoolDistrict": "Oceanside"
+"ExpirationDate": "2026-06-23"
+"FireplaceFeatures": array:3 [ …3]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Flooring": array:2 [ …2]
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "School 7-Oceanside Senior Hs"
+"HighSchoolDistrict": "Oceanside"
+"InteriorFeatures": array:9 [ …9]
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "917-900-2757"
+"ListAgentEmail": "eric.joseph@elliman.com"
+"ListAgentKey": "326236095"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110785"
+"ListOfficePhone": "516-746-0440"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-11-23"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.2505
+"LotSizeSquareFeet": 10912
+"MajorChangeTimestamp": "2026-02-13T20:51:02Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School"
+"MiddleOrJuniorSchoolDistrict": "Oceanside"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-02-13"
+"OnMarketDate": "2025-12-01"
+"OriginalEntryTimestamp": "2025-11-24T01:05:28Z"
+"OriginalListPrice": 1499000
+"OriginatingSystemModificationTimestamp": "2026-02-13T20:51:02Z"
+"OwnerName": "Francine J Slovin"
+"ParcelNumber": "2089-54-354-00-0150-0"
+"ParkingFeatures": array:4 [ …4]
+"ParkingTotal": "4"
+"PhotosChangeTimestamp": "2025-12-01T22:56:36Z"
+"PhotosCount": 23
+"PoolFeatures": array:1 [ …1]
+"PoolPrivateYN": true
+"PostalCity": "Oceanside"
+"PostalCodePlus4": "4714"
+"PropertyCondition": array:1 [ …1]
+"PurchaseContractDate": "2026-02-13"
+"RoomsTotal": "7"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "917-900-2757"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-02-13T20:51:02Z"
+"StreetName": "Frederick"
+"StreetNumber": "3522"
+"StreetNumberNumeric": "3522"
+"StreetSuffix": "Street"
+"SubdivisionName": "Estates"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "16955"
+"TaxAssessedValue": 630
+"TaxYear": "2024"
+"Utilities": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"WaterfrontFeatures": array:3 [ …3]
+"WaterfrontYN": true
+"KEY_Attic": "Crawl"
+"KEY_TaxSource": "Other"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "1499000.00"
+"KEY_ContractPrice": "1400000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "2337.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "347-860-0654"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "641.42062"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "5984031.9361"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "641.42062"
+"KEY_SourceSystemModificationTimestamp": "2025-11-23T16:48:34.857"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "521.57272"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "521.57272"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422775678')"
+"provider_name": "One Key"
+"Media": array:23 [ …23]
+"ID": "29470"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4567
+post_id: "29427"
+post_author: 1
+"ListingKey": "KEY422770056"
+"ListingId": "938320"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-22T18:09:40Z"
+"RFModificationTimestamp": "2026-03-22T18:11:36Z"
+"ListPrice": 889000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1452.0
+"BuildingAreaTotal": 1452.0
+"City": "Hempstead"
+"PostalCode": "11710"
+"UnparsedAddress": "116 Beach Avenue, Hempstead, New York 11710"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6573827
+"Longitude": -73.5209322
+"YearBuilt": 1923
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Joshua Manda"
+"ListOfficeName": "Coldwell Banker American Homes"
+"ListAgentMlsId": "207082"
+"ListOfficeMlsId": "BRMN17"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to this completely renovated Bellmore home, set right on the canal with peaceful water views and private water access. Walking through the front door, you are met by a bright and inviting living room that flows seamlessly into the dining area. The space continues into the beautifully renovated kitchen, designed for both cooking and gathering, and just beyond, the sunroom or your second living area, which offers serene water views and a perfect retreat for relaxing or entertaining.\n
\n
From the entryway, a central staircase leads upstairs to three comfortable bedrooms and a full bathroom finished in marble. The bathroom is equipped with a custom stand-up shower, complete with a shower niche and bench. The second level also features a walk-in closet, ample storage, and new windows that bring in abundant natural light. On the lower level, the half bath features a smart toilet with a bidet, heated seat, and multiple comfort settings.\n
\n
The finished basement gives even more living space, complete with a separate laundry room featuring a slop sink and top-of-the-line washer and dryer. The entire lower level was rebuilt with a pressure-treated elevated floor system, and all mechanicals are raised and protected for long-term peace of mind.\n
\n
Every part of this renovation was planned with modern convenience in mind. The home includes all-new kitchen appliances—gas stove, refrigerator, dishwasher, microwave, and wine fridge—natural gas heat, a tankless water heater, smart thermostats on every floor, and a CO2/fire alarm combo system. Throughout the entire home, new high hats with a halo setting provide two lighting options for everyday use or entertaining. Exterior upgrades include a brand-new roof and gutters.\n
\n
The property is engineered with a full-perimeter French drain, two high-capacity sump pumps with a water level alarm and backup battery.\n
\n
Minutes from the Wantagh Parkway, Sunrise Highway, Jones Beach, and Bellmore’s vibrant restaurants and nightlife, this home offers turnkey living with thoughtful design, modern comfort, and effortless coastal lifestyle.
"""
+"Appliances": array:6 [ …6]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "631-673-4444"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-11-24T18:42:22.436626+00:00"
+"CumulativeDaysOnMarket": 118
+"DaysOnMarket": 118
+"ElementarySchool": "Winthrop Avenue School"
+"ElementarySchoolDistrict": "Bellmore"
+"ExpirationDate": "2026-07-24"
+"Heating": array:1 [ …1]
+"HighSchool": "John F Kennedy High School"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"InteriorFeatures": array:4 [ …4]
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "631-827-6100"
+"ListAgentEmail": "Jmanda@cbamhomes.com"
+"ListAgentKey": "326216462"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109948"
+"ListOfficePhone": "631-673-4444"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-11-19"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:1 [ …1]
+"LotSizeAcres": 0.0402
+"LotSizeSquareFeet": 1750
+"MajorChangeTimestamp": "2026-03-11T14:03:43Z"
+"MajorChangeType": "Price Change"
+"MiddleOrJuniorSchool": "Grand Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2025-11-24"
+"OriginalEntryTimestamp": "2025-11-24T18:35:59Z"
+"OriginalListPrice": 979000
+"OriginatingSystemModificationTimestamp": "2026-03-22T18:08:31Z"
+"OwnerName": "Dodson Diamond Llc"
+"ParcelNumber": "2089-63-223-00-0014-0"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-11-24T18:37:36Z"
+"PhotosCount": 32
+"PostalCity": "Bellmore"
+"PostalCodePlus4": "4703"
+"PreviousListPrice": 939000
+"PriceChangeTimestamp": "2026-03-11T14:03:43Z"
+"RoomsTotal": "10"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "631 827 6100"
+"ShowingRequirements": array:3 [ …3]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-11-24T18:35:59Z"
+"StreetName": "Beach"
+"StreetNumber": "116"
+"StreetNumberNumeric": "116"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "14274.66"
+"TaxAssessedValue": 470
+"TaxYear": "2024"
+"Utilities": array:1 [ …1]
+"View": "Water"
+"WaterSource": array:1 [ …1]
+"WaterfrontFeatures": array:1 [ …1]
+"WaterfrontYN": true
+"KEY_Attic": "Pull Stairs"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "889000.00"
+"KEY_WaterAccessYN": "1"
+"KEY_OpenHouseCount": "1"
+"KEY_ElectricCompany": "PSEG"
+"KEY_AdditionalFeesYN": "0"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "Price Decrease"
+"KEY_LivingAreaSearchSqFt": "1452.00"
+"KEY_NumberOfHeatingZones": "3"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "631 673 4444"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "612.25895"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "22114427.8607"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "612.25895"
+"KEY_SourceSystemModificationTimestamp": "2025-11-22T11:26:21.803"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "612.25895"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.90807"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "612.25895"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422770056')"
+"provider_name": "One Key"
+"Media": array:32 [ …32]
+"ID": "29427"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4464
+post_id: "29423"
+post_author: 1
+"ListingKey": "KEY422769436"
+"ListingId": "938298"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-02-24T16:07:36Z"
+"RFModificationTimestamp": "2026-02-24T16:10:08Z"
+"ListPrice": 699999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1053.0
+"BuildingAreaTotal": 1400.0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "204 N Grove Street, Hempstead, New York 11580"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6712758
+"Longitude": -73.6933862
+"YearBuilt": 1937
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Kellyann Imeidopf"
+"ListOfficeName": "Coldwell Banker American Homes"
+"ListAgentMlsId": "173867"
+"ListOfficeMlsId": "BRMN13"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome home to this tastefully renovated Colonial featuring a welcoming front porch and timeless architectural style. Step inside to refinished hardwood floors that flow throughout the home, complemented by a fully updated kitchen with marble counter tops, stainless steel appliances, gas cooking, a new SS dishwasher, and brand-new hi-hat lighting. Additional upgrades include a new hot water heater, new washer and dryer, updated electric, and efficient gas heat. Finished Basement with Bathroom, laundry room, a egress window in a large finished room with closets. New windows, and screens in four seasons room.\n
The warm and inviting living room features a wood-burning fireplace, while the bright full dining room boasts a charming bay window that fills the space with natural light.\n
The four-season room offers an ideal additional living area—perfect for entertaining or customizing to your needs. Outside, enjoy a fenced backyard, a 1-car garage, and a long driveway accommodating up to 4 cars. Situated on a picturesque, tree-lined street with sidewalks, this home is located in a fantastic neighborhood you’ll love.\n
\n
A must-see property—move-in ready and beautifully updated throughout!
"""
+"Appliances": array:1 [ …1]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-293-2323"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "917-992-9228"
+"BuyerAgentEmail": "yauchan@kw.com"
+"BuyerAgentFullName": "Yau Lung Chan GRI SRS ABR CIPS"
+"BuyerAgentKey": "326179255"
+"BuyerAgentMlsId": "167809"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326112861"
+"BuyerOfficeMlsId": "KEWG01"
+"BuyerOfficeName": "Keller Williams Realty Greater"
+"BuyerOfficePhone": "516-873-7100"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-11-24T16:29:27.383776+00:00"
+"CrossStreet": "Park Ave"
+"CumulativeDaysOnMarket": 269
+"DaysOnMarket": 81
+"Directions": "Please use GPS"
+"ElementarySchool": "Wheeler Avenue School"
+"ElementarySchoolDistrict": "Valley Stream - 13"
+"ExpirationDate": "2026-11-22"
+"Flooring": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:2 [ …2]
+"HighSchool": "Valley Stream Central High School"
+"HighSchoolDistrict": "Valley Stream Central"
+"InteriorFeatures": array:5 [ …5]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "631-624-8663"
+"ListAgentEmail": "Kellyann.Imeidopf@gmail.com"
+"ListAgentKey": "326184850"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109944"
+"ListOfficePhone": "516-293-2323"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-11-22"
+"LivingAreaSource": "Appraiser"
+"LotSizeAcres": 0.0918
+"LotSizeSquareFeet": 4000
+"MajorChangeTimestamp": "2026-02-16T01:34:27Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Valley Stream Memorial Junior High School"
+"MiddleOrJuniorSchoolDistrict": "Valley Stream Central"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-02-15"
+"OnMarketDate": "2025-11-24"
+"OriginalEntryTimestamp": "2025-11-24T16:26:57Z"
+"OriginalListPrice": 699999
+"OriginatingSystemModificationTimestamp": "2026-02-24T16:05:39Z"
+"OwnerName": "Elizabeth Ramona Pena-Jorge & Luis Eduardo Jorge"
+"ParcelNumber": "2035-37-153-00-0005-0"
+"ParkingFeatures": array:3 [ …3]
+"PhotosChangeTimestamp": "2026-01-18T01:41:36Z"
+"PhotosCount": 16
+"PostalCity": "Valley Stream"
+"PostalCodePlus4": "4115"
+"PurchaseContractDate": "2026-02-13"
+"RoomsTotal": "6"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "631-624-8663"
+"ShowingRequirements": array:4 [ …4]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-02-16T01:34:27Z"
+"StreetDirPrefix": "N"
+"StreetName": "Grove"
+"StreetNumber": "204"
+"StreetNumberNumeric": "204"
+"StreetSuffix": "Street"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "11172.8"
+"TaxAssessedValue": 502
+"TaxYear": "2026"
+"Utilities": array:3 [ …3]
+"WaterSource": array:1 [ …1]
+"WindowFeatures": array:2 [ …2]
+"KEY_Attic": "Crawl"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "699999.00"
+"KEY_ContractPrice": "699000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_AdditionalRooms": "Library/Den"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "1053.00"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "664.76638"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "7625261.4379"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "664.76638"
+"KEY_SourceSystemModificationTimestamp": "2025-11-22T08:53:08.537"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "499.99929"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "499.99929"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422769436')"
+"provider_name": "One Key"
+"Media": array:16 [ …16]
+"ID": "29423"
}
]
+success: true
+page_size: 6
+page_count: 254
+count: 1524
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Cache Key: dcf36643c773c834bb56a53065056ef346d668dc5edb031d9bb2ebd5f19c65f2" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5926
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5884
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY422783103"
+"ListingId": "938685"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Expired"
+"ModificationTimestamp": "2026-01-02T05:12:38Z"
+"RFModificationTimestamp": "2026-01-02T05:15:16Z"
+"ListPrice": 1250000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2800.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11510"
+"UnparsedAddress": "300 Harbor Street, Hempstead, New York 11510"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6356132
+"Longitude": -73.6138043
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Erik C. Mahler CBR"
+"ListOfficeName": "Mahler Realty"
+"ListAgentMlsId": "85303"
+"ListOfficeMlsId": "MAHL01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Step into brand-new luxury living where scale, light, and craftsmanship meet every day ease. This elevated, FEMA-compliant 2025 build offers 4BR/3BA across 2,800 SF, with an open plan anchored by a jaw-dropping 20' & 20' chef’s kitchen—an entertainer’s dream—starring a grand center island, full stainless-steel package, and a true walk-in pantry with floor-to-ceiling storage. Sun-splashed living and dining flow effortlessly for hosting or quiet nights in, elevated by refined finishes, designer lighting, and custom millwork. The serene primary suite lives like a private retreat with a boutique-style closet and spa-inspired bath; generous secondary bedrooms flex for guests/office/studio. Thoughtful storage, smooth circulation, and modern, energy-efficient systems make daily life organized and effortless. Turn the key and live large."
+"Appliances": array:9 [ …9]
+"ArchitecturalStyle": array:3 [ …3]
+"AttributionContact": "516-223-3111"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-265-4816"
+"CoListAgentEmail": "peyton@mahlerrealty.com"
+"CoListAgentFullName": "Peyton Mahler"
+"CoListAgentKey": "419072345"
+"CoListAgentMlsId": "503294"
+"CoListOfficeKey": "326113441"
+"CoListOfficeMlsId": "MAHL01"
+"CoListOfficeName": "Mahler Realty"
+"CoListOfficePhone": "516-223-3111"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:3 [ …3]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-12-01T08:29:02.778986+00:00"
+"CrossStreet": "Fishermans"
+"CumulativeDaysOnMarket": 32
+"DaysOnMarket": 32
+"Directions": "Grand Ave South to Fishermans Rd West"
+"ElementarySchool": "Meadow Elementary School"
+"ElementarySchoolDistrict": "Baldwin"
+"ExpirationDate": "2026-01-02"
+"ExteriorFeatures": array:1 [ …1]
+"Fencing": array:3 [ …3]
+"FireplaceFeatures": array:2 [ …2]
+"FireplaceYN": true
+"Flooring": array:3 [ …3]
+"FoundationDetails": array:1 [ …1]
+"GarageSpaces": "3"
+"GarageYN": true
+"Heating": array:4 [ …4]
+"HighSchool": "Baldwin Senior High School"
+"HighSchoolDistrict": "Baldwin"
+"InteriorFeatures": array:15 [ …15]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "erik@mahlerrealty.com"
+"ListAgentKey": "326245957"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326113441"
+"ListOfficePhone": "516-223-3111"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-12-01"
+"LivingAreaSource": "Plans"
+"LotFeatures": array:4 [ …4]
+"LotSizeAcres": 0.18
+"LotSizeDimensions": "55x103"
+"LotSizeSquareFeet": 5040
+"MajorChangeTimestamp": "2026-01-02T05:10:47Z"
+"MajorChangeType": "Expired"
+"MiddleOrJuniorSchool": "Baldwin Middle School"
+"MiddleOrJuniorSchoolDistrict": "Baldwin"
+"MlsStatus": "Expired"
+"OffMarketDate": "2026-01-02"
+"OnMarketDate": "2025-12-01"
+"OriginalEntryTimestamp": "2025-12-01T08:25:20Z"
+"OriginalListPrice": 1250000
+"OriginatingSystemModificationTimestamp": "2026-01-02T05:10:47Z"
+"OwnerName": "Erika James"
+"ParcelNumber": "2089-54-431-00-0043-0"
+"ParkingFeatures": array:5 [ …5]
+"ParkingTotal": "4"
+"PatioAndPorchFeatures": array:4 [ …4]
+"PhotosChangeTimestamp": "2025-12-01T08:26:36Z"
+"PhotosCount": 40
+"PostalCity": "Baldwin"
+"PropertyCondition": array:1 [ …1]
+"RoadFrontageType": array:1 [ …1]
+"RoadResponsibility": array:1 [ …1]
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-223-3111"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-02T05:10:47Z"
+"StreetName": "Harbor"
+"StreetNumber": "300"
+"StreetNumberNumeric": "300"
+"StreetSuffix": "Street"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "1"
+"TaxBlock": "431"
+"TaxLot": "43"
+"TaxYear": "2025"
+"Utilities": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"WindowFeatures": array:5 [ …5]
+"YearBuiltEffective": 2025
+"KEY_Attic": "Storage"
+"KEY_Hamlet": "Baldwin"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "54"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "1250000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_IncludedInTaxes": "Sewer,Trash"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_MlsMajorChangeType": "Expired"
+"KEY_LivingAreaSearchSqFt": "2800.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "446.42857"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6944444.4444"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "446.42857"
+"KEY_SourceSystemModificationTimestamp": "2025-11-24T14:59:23.290"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422783103')"
+"provider_name": "One Key"
+"Media": array:40 [ …40]
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5869
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY422778470"
+"ListingId": "938547"
+"PropertyType": "Residential"
+"PropertySubType": "Stock Cooperative"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-03-10T07:03:39Z"
+"RFModificationTimestamp": "2026-03-10T07:06:54Z"
+"ListPrice": 297000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1000.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11559"
+"UnparsedAddress": "285 Central Avenue Unit D-7, Hempstead, New York 11559"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 1950
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Lori Schlesinger"
+"ListOfficeName": "Lori & Associates LI Realty"
+"ListAgentMlsId": "87462"
+"ListOfficeMlsId": "LORA01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Fully Renovated top Floor (second Floor) unit. Laundry Facility In the Basement. Hardwood floors just done, Renovated Kitchen with New appliances & Granite Countertops, Renovated Full Bathroom with a Bathtub, 2 spacious Bedrooms, Live in Super, outdoor Designated Parking spot available & indoor Garage spot has a waiting list. Maintenance $1222.71/month plus an assessment for 2026 (ends December 2026) for $134.03/month."
+"Appliances": array:4 [ …4]
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFeeIncludes": array:1 [ …1]
+"AttributionContact": "516-791-8300"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 1
+"BuilderModel": "Garden Apt"
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "917-620-0572"
+"BuyerAgentEmail": "elliebaum@gmail.com"
+"BuyerAgentFullName": "Elisheva Baum"
+"BuyerAgentKey": "326204848"
+"BuyerAgentMlsId": "195126"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326113756"
+"BuyerOfficeMlsId": "MLKY01"
+"BuyerOfficeName": "Milky Forst Properties Inc"
+"BuyerOfficePhone": "516-239-0306"
+"CommonWalls": array:1 [ …1]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-11-24T15:44:46.108272+00:00"
+"CrossStreet": "Rockaway Tpke"
+"CumulativeDaysOnMarket": 102
+"DaysOnMarket": 102
+"Directions": "On Central Avenue Opposite The Peninsula Public Library...Off Rockaway Tpke."
+"ElementarySchool": "Lawrence Early Childhood-#4 School"
+"ElementarySchoolDistrict": "Lawrence"
+"EntryLevel": 2
+"ExpirationDate": "2026-05-31"
+"Flooring": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:2 [ …2]
+"HighSchool": "Lawrence Senior High School"
+"HighSchoolDistrict": "Lawrence"
+"InteriorFeatures": array:4 [ …4]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "loriandassociates@gmail.com"
+"ListAgentKey": "326247724"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326113285"
+"ListOfficePhone": "516-791-8300"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-11-24"
+"LivingAreaSource": "Other"
+"MajorChangeTimestamp": "2026-03-09T15:33:27Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "LAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS"
+"MiddleOrJuniorSchoolDistrict": "Lawrence"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-03-09"
+"OnMarketDate": "2025-11-24"
+"OriginalEntryTimestamp": "2025-11-24T15:38:56Z"
+"OriginalListPrice": 299000
+"OriginatingSystemModificationTimestamp": "2026-03-09T15:33:27Z"
+"OwnerName": "Lawrence Associates"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-11-28T17:12:36Z"
+"PhotosCount": 8
+"PostalCity": "Lawrence"
+"PreviousListPrice": 299000
+"PriceChangeTimestamp": "2026-01-05T17:09:21Z"
+"PropertyAttachedYN": true
+"PurchaseContractDate": "2026-03-06"
+"RoomsTotal": "5"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-410-4210"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-03-09T15:33:27Z"
+"StoriesTotal": "2"
+"StreetName": "Central"
+"StreetNumber": "285"
+"StreetNumberNumeric": "285"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "Lawrence Woods"
+"SyndicateTo": array:2 [ …2]
+"UnitNumber": "D-7"
+"Utilities": array:6 [ …6]
+"WaterSource": array:1 [ …1]
+"KEY_Village": "Lawrence"
+"KEY_FlipTaxYN": "1"
+"KEY_ParkingFee": "75"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "297000.00"
+"KEY_ContractPrice": "300000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_AdditionalFeesYN": "0"
+"KEY_RentingAllowedYN": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_ApprovalRequiredYN": "1"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_EstimatedMaintenance": "1223"
+"KEY_LivingAreaSearchSqFt": "1000.00"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_MinimumPctDownPayment": "20"
+"KEY_RATIO_ListPrice_By_LivingArea": "297.00000"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "297.00000"
+"KEY_SourceSystemModificationTimestamp": "2025-11-24T10:38:56.147"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.99331"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422778470')"
+"provider_name": "One Key"
+"Media": array:8 [ …8]
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5438
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY422778456"
+"ListingId": "938545"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-01-26T07:04:41Z"
+"RFModificationTimestamp": "2026-01-26T07:06:13Z"
+"ListPrice": 814999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2252.0
+"BuildingAreaTotal": 2252.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "54 W 2nd Street, Hempstead, New York 11520"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6410626
+"Longitude": -73.5752563
+"YearBuilt": 1956
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Nicole Campisi"
+"ListOfficeName": "Keller Williams Points North"
+"ListAgentMlsId": "171166"
+"ListOfficeMlsId": "KEWG03"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "What A Gem of a Home! Far From A Cookie Cutter or Typical Cape As This Waterfront Beauty Has An Amazing Flow! Wide Open Floor Plan, Huge/Beautiful Kitchen w/Oversized Center Island (Neutral Tile Flooring), Tons of Cabinets & Countertop (Granite) Space! Gorgeous Hardwood Floors Throughout (Except Kitchen, Bathrooms and Family Room), Sunk In Family Room (Wide Plank Vinyl Flooring) with Wood Burning Fireplace. Natural Gas (Cooking and Heat), Radiant Heat in Kitchen & Family Room. New Boiler Installed in 2022, Tankless HW Heater, Cedar Tek Siding 2015. Generous Size Bedrooms. The Second Floor has 8ft Ceilings, Primary Ensuite is Incredible! Beautiful Primary Bath with Separate Tub and Shower! and the Most Magnificent Part is the Enormous Walk in Closet with Washer and Dryer. Backyard entrance fence is new (2021) with double doors opening to backyard. It's a WOW factor Indeed. Please see the Short Video in Photos. Generous, Flat Yard space. Whether You are a Boater or You Jet ski, or Both. There is Plenty of Space in the Water for All of Your Water Toys. 77 Feet of Bulkhead on the Canal,, Right in Your Backyard. Lifestyle Doesn't Get Much Better!"
+"Appliances": array:6 [ …6]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-865-1800"
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-554-5230"
+"BuyerAgentEmail": "luis@oversouthre.com"
+"BuyerAgentFullName": "Luis Genao"
+"BuyerAgentKey": "326221684"
+"BuyerAgentMlsId": "212482"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "406610771"
+"BuyerOfficeMlsId": "OVRS02"
+"BuyerOfficeName": "Oversouth LLC"
+"BuyerOfficePhone": "631-770-0030"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-01-13T14:27:46.219525+00:00"
+"CrossStreet": "Main Street"
+"CumulativeDaysOnMarket": 11
+"DaysOnMarket": 11
+"Directions": "Main Street to W. 2nd Street"
+"Disclosures": array:1 [ …1]
+"ElementarySchool": "Leo F Giblyn School"
+"ElementarySchoolDistrict": "Freeport"
+"ExpirationDate": "2026-07-13"
+"Fencing": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:2 [ …2]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "631-398-3992"
+"ListAgentEmail": "nicolecampisi@kw.com"
+"ListAgentKey": "326182329"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326112863"
+"ListOfficePhone": "516-865-1800"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-01-13"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:3 [ …3]
+"LotSizeAcres": 0.1607
+"LotSizeSquareFeet": 7000
+"MajorChangeTimestamp": "2026-01-25T19:29:11Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "John W Dodd Middle School"
+"MiddleOrJuniorSchoolDistrict": "Freeport"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-01-25"
+"OnMarketDate": "2026-01-13"
+"OriginalEntryTimestamp": "2026-01-13T14:24:16Z"
+"OriginalListPrice": 814999
+"OriginatingSystemModificationTimestamp": "2026-01-25T19:29:11Z"
+"OwnerName": "Mueller"
+"ParcelNumber": "2009-62-062-00-0263-0"
+"ParkingFeatures": array:2 [ …2]
+"PhotosChangeTimestamp": "2026-01-13T16:03:36Z"
+"PhotosCount": 50
+"PostalCity": "Freeport"
+"PostalCodePlus4": "5730"
+"PropertyCondition": array:1 [ …1]
+"PurchaseContractDate": "2026-01-24"
+"RoomsTotal": "8"
+"SecurityFeatures": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "631-398-3992"
+"ShowingRequirements": array:3 [ …3]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-25T19:29:11Z"
+"StreetDirPrefix": "W"
+"StreetName": "2nd"
+"StreetNumber": "54"
+"StreetNumberNumeric": "54"
+"StreetSuffix": "Street"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "10091.05"
+"TaxAssessedValue": 512
+"TaxYear": "2025"
+"Utilities": array:2 [ …2]
+"VirtualTourURLBranded": "https://ny360tours.hd.pics/54-W-2nd-St"
+"VirtualTourURLUnbranded": "https://ny360tours.hd.pics/54-W-2nd-St/idx"
+"WaterSource": array:1 [ …1]
+"WaterfrontFeatures": array:1 [ …1]
+"WaterfrontYN": true
+"WindowFeatures": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "814999.00"
+"KEY_ContractPrice": "815000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "2252.00"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "361.90009"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "5071555.6938"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "361.90009"
+"KEY_SourceSystemModificationTimestamp": "2025-11-24T10:37:28.937"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "361.90009"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "361.90009"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422778456')"
+"provider_name": "One Key"
+"Media": array:50 [ …50]
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5900
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY422775678"
+"ListingId": "938487"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-02-14T07:05:38Z"
+"RFModificationTimestamp": "2026-02-14T07:07:41Z"
+"ListPrice": 1499000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2337.0
+"BuildingAreaTotal": 2874.0
+"City": "Hempstead"
+"PostalCode": "11572"
+"UnparsedAddress": "3522 Frederick Street, Hempstead, New York 11572"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.632187
+"Longitude": -73.6169459
+"YearBuilt": 1961
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Eric Joseph"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "227348"
+"ListOfficeMlsId": "DERE61"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "This premier waterfront residence sits secluded at the very end of a beautifully tree lined street nestled in the Estates section of Oceanside.The property is situated on a generous quarter-acre lot with over 160 feet of canal frontage. The home features four bedrooms and 2.5 baths, including a primary bedroom with an en suite bathroom, walk in closet, and a south-facing balcony overlooking the wide canal leading to Parson's creek and the Middle Bay. Hardwood floors span the interior, complemented by two wood-burning fireplaces that add warmth and character. As you walk in the front door, you’re greeted by abundant natural light from two skylights set high in the 15-foot ceilings, creating a bright, airy entry. An indoor pool, which is heated and cedar-lined, make it a truly one of a kind property- perfect for year-round swimming and entertaining. The pool connects to a back patio with sliders, creating seamless flow for hosting guests in any season. The second floor boasts a balcony overlooking the living room, and every room benefits from abundant natural light through skylights throughout the home. The built-in gas stove top, granite countertops, grill, and sink on the secondary deck provide additional outdoor cooking and entertaining options. The property includes a two-car garage and substantial expansion potential. Outdoor living is highlighted by a private backyard framed by mature trees—an ideal setting for relaxation and gatherings by the water. Waterfront amenities include a boat lift and two docks, with a bulkhead that was replaced after Sandy, ensuring sturdy waterfront infrastructure. The home has been meticulously cared for and maintained, reflecting more than forty years of attentive ownership. The backyard is tranquil and perfect for entertaining, with serene views of the water and a wider canal segment that offers straightforward access straight out to the Middle Bay. This residence combines timeless charm with modern conveniences in a sought-after Oceanside location, offering privacy, convenience, and a lifestyle focused on coastal living."
+"Appliances": array:9 [ …9]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-746-0440"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaSource": "Other"
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-238-7492"
+"BuyerAgentEmail": "mkrealtor1@gmail.com"
+"BuyerAgentFullName": "Michael L. Karlen"
+"BuyerAgentKey": "326129652"
+"BuyerAgentMlsId": "113854"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326115723"
+"BuyerOfficeMlsId": "SPH15"
+"BuyerOfficeName": "Signature Premier Properties"
+"BuyerOfficePhone": "516-766-7900"
+"CoBuyerAgentAOR": "LIBOR"
+"CoBuyerAgentDirectPhone": "516-458-4847"
+"CoBuyerAgentEmail": "rmanel@Signature Premier.com"
+"CoBuyerAgentFullName": "Robert D. Manel"
+"CoBuyerAgentKey": "326132189"
+"CoBuyerAgentMlsId": "116555"
+"CoBuyerOfficeKey": "326115723"
+"CoBuyerOfficeMlsId": "SPH15"
+"CoBuyerOfficeName": "Signature Premier Properties"
+"CoBuyerOfficePhone": "516-766-7900"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "347-860-0654"
+"CoListAgentEmail": "Lauren.Joseph@elliman.com"
+"CoListAgentFullName": "Lauren C. Joseph"
+"CoListAgentKey": "422468059"
+"CoListAgentMlsId": "505541"
+"CoListOfficeKey": "326110785"
+"CoListOfficeMlsId": "DERE61"
+"CoListOfficeName": "Douglas Elliman Real Estate"
+"CoListOfficePhone": "516-746-0440"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"Country": "US"
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-12-01T12:40:55.306401+00:00"
+"CumulativeDaysOnMarket": 74
+"DaysOnMarket": 74
+"Directions": "Very end of Frederick Street on Left"
+"Disclosures": array:2 [ …2]
+"ElementarySchool": "School 9E-Boardman Elem School"
+"ElementarySchoolDistrict": "Oceanside"
+"ExpirationDate": "2026-06-23"
+"FireplaceFeatures": array:3 [ …3]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Flooring": array:2 [ …2]
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "School 7-Oceanside Senior Hs"
+"HighSchoolDistrict": "Oceanside"
+"InteriorFeatures": array:9 [ …9]
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "917-900-2757"
+"ListAgentEmail": "eric.joseph@elliman.com"
+"ListAgentKey": "326236095"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110785"
+"ListOfficePhone": "516-746-0440"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-11-23"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.2505
+"LotSizeSquareFeet": 10912
+"MajorChangeTimestamp": "2026-02-13T20:51:02Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School"
+"MiddleOrJuniorSchoolDistrict": "Oceanside"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-02-13"
+"OnMarketDate": "2025-12-01"
+"OriginalEntryTimestamp": "2025-11-24T01:05:28Z"
+"OriginalListPrice": 1499000
+"OriginatingSystemModificationTimestamp": "2026-02-13T20:51:02Z"
+"OwnerName": "Francine J Slovin"
+"ParcelNumber": "2089-54-354-00-0150-0"
+"ParkingFeatures": array:4 [ …4]
+"ParkingTotal": "4"
+"PhotosChangeTimestamp": "2025-12-01T22:56:36Z"
+"PhotosCount": 23
+"PoolFeatures": array:1 [ …1]
+"PoolPrivateYN": true
+"PostalCity": "Oceanside"
+"PostalCodePlus4": "4714"
+"PropertyCondition": array:1 [ …1]
+"PurchaseContractDate": "2026-02-13"
+"RoomsTotal": "7"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "917-900-2757"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-02-13T20:51:02Z"
+"StreetName": "Frederick"
+"StreetNumber": "3522"
+"StreetNumberNumeric": "3522"
+"StreetSuffix": "Street"
+"SubdivisionName": "Estates"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "16955"
+"TaxAssessedValue": 630
+"TaxYear": "2024"
+"Utilities": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"WaterfrontFeatures": array:3 [ …3]
+"WaterfrontYN": true
+"KEY_Attic": "Crawl"
+"KEY_TaxSource": "Other"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "1499000.00"
+"KEY_ContractPrice": "1400000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "2337.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "347-860-0654"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "641.42062"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "5984031.9361"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "641.42062"
+"KEY_SourceSystemModificationTimestamp": "2025-11-23T16:48:34.857"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "521.57272"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "521.57272"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422775678')"
+"provider_name": "One Key"
+"Media": array:23 [ …23]
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5902
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY422770056"
+"ListingId": "938320"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-22T18:09:40Z"
+"RFModificationTimestamp": "2026-03-22T18:11:36Z"
+"ListPrice": 889000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1452.0
+"BuildingAreaTotal": 1452.0
+"City": "Hempstead"
+"PostalCode": "11710"
+"UnparsedAddress": "116 Beach Avenue, Hempstead, New York 11710"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6573827
+"Longitude": -73.5209322
+"YearBuilt": 1923
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Joshua Manda"
+"ListOfficeName": "Coldwell Banker American Homes"
+"ListAgentMlsId": "207082"
+"ListOfficeMlsId": "BRMN17"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to this completely renovated Bellmore home, set right on the canal with peaceful water views and private water access. Walking through the front door, you are met by a bright and inviting living room that flows seamlessly into the dining area. The space continues into the beautifully renovated kitchen, designed for both cooking and gathering, and just beyond, the sunroom or your second living area, which offers serene water views and a perfect retreat for relaxing or entertaining.\n
\n
From the entryway, a central staircase leads upstairs to three comfortable bedrooms and a full bathroom finished in marble. The bathroom is equipped with a custom stand-up shower, complete with a shower niche and bench. The second level also features a walk-in closet, ample storage, and new windows that bring in abundant natural light. On the lower level, the half bath features a smart toilet with a bidet, heated seat, and multiple comfort settings.\n
\n
The finished basement gives even more living space, complete with a separate laundry room featuring a slop sink and top-of-the-line washer and dryer. The entire lower level was rebuilt with a pressure-treated elevated floor system, and all mechanicals are raised and protected for long-term peace of mind.\n
\n
Every part of this renovation was planned with modern convenience in mind. The home includes all-new kitchen appliances—gas stove, refrigerator, dishwasher, microwave, and wine fridge—natural gas heat, a tankless water heater, smart thermostats on every floor, and a CO2/fire alarm combo system. Throughout the entire home, new high hats with a halo setting provide two lighting options for everyday use or entertaining. Exterior upgrades include a brand-new roof and gutters.\n
\n
The property is engineered with a full-perimeter French drain, two high-capacity sump pumps with a water level alarm and backup battery.\n
\n
Minutes from the Wantagh Parkway, Sunrise Highway, Jones Beach, and Bellmore’s vibrant restaurants and nightlife, this home offers turnkey living with thoughtful design, modern comfort, and effortless coastal lifestyle.
"""
+"Appliances": array:6 [ …6]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "631-673-4444"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-11-24T18:42:22.436626+00:00"
+"CumulativeDaysOnMarket": 118
+"DaysOnMarket": 118
+"ElementarySchool": "Winthrop Avenue School"
+"ElementarySchoolDistrict": "Bellmore"
+"ExpirationDate": "2026-07-24"
+"Heating": array:1 [ …1]
+"HighSchool": "John F Kennedy High School"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"InteriorFeatures": array:4 [ …4]
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "631-827-6100"
+"ListAgentEmail": "Jmanda@cbamhomes.com"
+"ListAgentKey": "326216462"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109948"
+"ListOfficePhone": "631-673-4444"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-11-19"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:1 [ …1]
+"LotSizeAcres": 0.0402
+"LotSizeSquareFeet": 1750
+"MajorChangeTimestamp": "2026-03-11T14:03:43Z"
+"MajorChangeType": "Price Change"
+"MiddleOrJuniorSchool": "Grand Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2025-11-24"
+"OriginalEntryTimestamp": "2025-11-24T18:35:59Z"
+"OriginalListPrice": 979000
+"OriginatingSystemModificationTimestamp": "2026-03-22T18:08:31Z"
+"OwnerName": "Dodson Diamond Llc"
+"ParcelNumber": "2089-63-223-00-0014-0"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-11-24T18:37:36Z"
+"PhotosCount": 32
+"PostalCity": "Bellmore"
+"PostalCodePlus4": "4703"
+"PreviousListPrice": 939000
+"PriceChangeTimestamp": "2026-03-11T14:03:43Z"
+"RoomsTotal": "10"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "631 827 6100"
+"ShowingRequirements": array:3 [ …3]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-11-24T18:35:59Z"
+"StreetName": "Beach"
+"StreetNumber": "116"
+"StreetNumberNumeric": "116"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "14274.66"
+"TaxAssessedValue": 470
+"TaxYear": "2024"
+"Utilities": array:1 [ …1]
+"View": array:1 [ …1]
+"WaterSource": array:1 [ …1]
…26
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5904 …143}
]
+success: true
+page_size: 6
+page_count: 254
+count: 1524
+after_key: ""
}
]
]
