array:1 [
"RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=60&$skip=1260&$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 {#5079
+items: array:60 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5125
+post_id: "29507"
+post_author: 1
+"ListingKey": "KEY422867685"
+"ListingId": "940836"
+"PropertyType": "Residential Income"
+"PropertySubType": "Duplex"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2025-12-20T07:08:40Z"
+"RFModificationTimestamp": "2025-12-20T07:13:40Z"
+"ListPrice": 750000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 1912.0
+"City": "Hempstead"
+"PostalCode": "11563"
+"UnparsedAddress": "103 Smith Street, Hempstead, New York 11563"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.662997
+"Longitude": -73.6751197
+"YearBuilt": 1908
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Scott Schoen"
+"ListOfficeName": "Compass Greater NY LLC"
+"ListAgentMlsId": "204817"
+"ListOfficeMlsId": "CMPA04"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Spacious Two-Family Home With Oversized Yard. Features A Total Of 4 Bedrooms And 2 Baths. Provides An Excellent Opportunity For Owner Occupancy, Investment, Or Extended Family Living. Plenty Of Potential To Renovate And Make It Your Own. Located In Lynbrook School District. This Home Is Surrounded By Convenient Amenities, Nearby Shopping, Fabulous Restaurants, And Two Nearby LIRR Train Stations, Offering A Convenient Commute To Manhattan. The Property Is Being Sold As Is And Certain Photos of The Property Are Virtually Staged."
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "631-434-5033"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-12-05T13:30:24.409243+00:00"
+"CrossStreet": "Hempstead Avenue"
+"CumulativeDaysOnMarket": 14
+"DaysOnMarket": 14
+"Directions": "Southern State Parkway South To Hempstead Avenue & A Right Turn Onto Smith Street"
+"ElementarySchool": "West End School"
+"ElementarySchoolDistrict": "Lynbrook"
+"ExpirationDate": "2026-05-31"
+"Flooring": array:4 [ …4]
+"Heating": array:1 [ …1]
+"HighSchool": "Lynbrook Senior High School"
+"HighSchoolDistrict": "Lynbrook"
+"InteriorFeatures": array:5 [ …5]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "631-434-5033"
+"ListAgentEmail": "scott.schoen@compass.com"
+"ListAgentKey": "326214245"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110401"
+"ListOfficePhone": "631-629-7719"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-12-04"
+"LotSizeAcres": 0.1905
+"LotSizeSquareFeet": 8300
+"MajorChangeTimestamp": "2025-12-19T17:15:14Z"
+"MajorChangeType": "Hold"
+"MiddleOrJuniorSchool": "Lynbrook North Middle School"
+"MiddleOrJuniorSchoolDistrict": "Lynbrook"
+"MlsStatus": "Hold"
+"NumberOfSeparateElectricMeters": 2
+"NumberOfUnitsTotal": "2"
+"OffMarketDate": "2025-12-19"
+"OnMarketDate": "2025-12-05"
+"OriginalEntryTimestamp": "2025-12-05T13:26:11Z"
+"OriginalListPrice": 750000
+"OriginatingSystemModificationTimestamp": "2025-12-19T17:15:14Z"
+"OwnerName": "Ehmsen"
+"ParcelNumber": "2025-37-252-00-0173-0"
+"ParkingFeatures": array:1 [ …1]
+"PatioAndPorchFeatures": array:2 [ …2]
+"PhotosChangeTimestamp": "2025-12-06T13:28:36Z"
+"PhotosCount": 34
+"PostalCity": "Lynbrook"
+"PostalCodePlus4": "1527"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "(631)-434-5033"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-12-19T17:15:14Z"
+"StreetName": "Smith"
+"StreetNumber": "103"
+"StreetNumberNumeric": "103"
+"StreetSuffix": "Street"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "14592"
+"TaxAssessedValue": 546
+"TaxYear": "2024"
+"Utilities": array:3 [ …3]
+"VirtualTourURLBranded": "https://tours.virtualtourzone.com/300921"
+"VirtualTourURLUnbranded": "https://tours.virtualtourzone.com/300921"
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Partially Finished,Walkup"
+"KEY_Village": "Lynbrook"
+"KEY_HoldDate": "2025-12-19"
+"KEY_TaxSource": "Other"
+"KEY_CurrentPrice": "750000.00"
+"KEY_NumOf1BedRooms": "1"
+"KEY_NumOf2BedRooms": "0"
+"KEY_NumOf3BedRooms": "1"
+"KEY_NumOf4BedRooms": "0"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Temp Off Market"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "3937007.8740"
+"KEY_SourceSystemModificationTimestamp": "2025-12-03T11:37:28.760"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "392.25941"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "392.25941"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422867685')"
+"provider_name": "One Key"
+"Media": array:34 [ …34]
+"ID": "29507"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5127
+post_id: "30687"
+post_author: 1
+"ListingKey": "KEY422861934"
+"ListingId": "940683"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-15T00:17:36Z"
+"RFModificationTimestamp": "2026-04-15T00:19:54Z"
+"ListPrice": 1325000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2444.0
+"BuildingAreaTotal": 2444.0
+"City": "Hempstead"
+"PostalCode": "11557"
+"UnparsedAddress": "41 Avon Road, Hempstead, New York 11557"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6468425
+"Longitude": -73.6929449
+"YearBuilt": 1938
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Orli Rokach"
+"ListOfficeName": "Realty Trends Corp"
+"ListAgentMlsId": "223671"
+"ListOfficeMlsId": "RLTT01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Welcome to this beautifully maintained colonial style home located in the desirable Hewlett neighborhood. This charming residence offers 5 spacious bedrooms and 3 bathrooms, featuring a bright and inviting layout with abundant natural light throughout. There is a full basement offering extra storage or potential living space and a private backyard. The house is situated on a quiet residential street. It is conveniently located near shopping, dining, transportation, and local amenities."
+"Appliances": array:8 [ …8]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-312-3223"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-04-06T19:29:31.236799+00:00"
+"CumulativeDaysOnMarket": 8
+"DaysOnMarket": 14
+"ElementarySchool": "Hewlett Elementary School"
+"ElementarySchoolDistrict": "Hewlett-Woodmere"
+"ExpirationDate": "2026-07-05"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "George W Hewlett High School"
+"HighSchoolDistrict": "Hewlett-Woodmere"
+"InteriorFeatures": array:4 [ …4]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-477-7946"
+"ListAgentEmail": "orlybenarie@yahoo.com"
+"ListAgentKey": "326232520"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115115"
+"ListOfficePhone": "516-312-3223"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-04-05"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1377
+"LotSizeSquareFeet": 6000
+"MajorChangeTimestamp": "2026-04-06T19:35:30Z"
+"MajorChangeType": "Price Change"
+"MiddleOrJuniorSchool": "Woodmere Middle School"
+"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-04-06"
+"OriginalEntryTimestamp": "2026-04-06T19:27:05Z"
+"OriginalListPrice": 1300000
+"OriginatingSystemModificationTimestamp": "2026-04-15T00:16:14Z"
+"OwnerName": "Abraham Hardoon"
+"ParcelNumber": "2089-39-439-00-0020-0"
+"ParkingFeatures": array:2 [ …2]
+"PhotosChangeTimestamp": "2026-04-15T00:17:36Z"
+"PhotosCount": 3
+"PostalCity": "Hewlett"
+"PostalCodePlus4": "1529"
+"PreviousListPrice": 1300000
+"PriceChangeTimestamp": "2026-04-06T19:35:30Z"
+"RoomsTotal": "7"
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-04-06T19:27:05Z"
+"StreetName": "Avon"
+"StreetNumber": "41"
+"StreetNumberNumeric": "41"
+"StreetSuffix": "Road"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "19070.94"
+"TaxAssessedValue": 601
+"TaxYear": "2024"
+"Utilities": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "1325000.00"
+"KEY_ElectricCompany": "PSEG"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "Price Increase"
+"KEY_LivingAreaSearchSqFt": "2444.00"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "542.14403"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "9622367.4655"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "542.14403"
+"KEY_SourceSystemModificationTimestamp": "2025-12-02T18:26:50.180"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "542.14403"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.01923"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "542.14403"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422861934')"
+"provider_name": "One Key"
+"Media": array:3 [ …3]
+"ID": "30687"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5124
+post_id: "29516"
+post_author: 1
+"ListingKey": "KEY422861551"
+"ListingId": "940671"
+"PropertyType": "Residential Income"
+"PropertySubType": "Duplex"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-02-07T07:05:39Z"
+"RFModificationTimestamp": "2026-02-07T07:07:00Z"
+"ListPrice": 788000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 1521.0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "121 Carroll Avenue, Hempstead, New York 11580"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6766333
+"Longitude": -73.7231326
+"YearBuilt": 1941
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Christopher Andron"
+"ListOfficeName": "Andron Realty Group Tulip R E"
+"ListAgentMlsId": "9051254"
+"ListOfficeMlsId": "ANDN02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "This beautiful newly renovated 2 family home is a 3+ room over 4 room design. The first floor offers an entry foyer, a spacious living room, a large new eat-in-kitchen with stone countertops and stainless steel appliances, 2 bedrooms, and a new bath. The second floor offers a living room with additional loft space, a large new eat-in-kitchen with stone countertops, a large bedroom, and a new bath. This home also offers a lovely finished basement, an attached garage, and a rear patio. With so much to offer, this may be the perfect home for you."
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "718-343-2010"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-234-6519"
+"BuyerAgentEmail": "fran@aventusrealestate.com"
+"BuyerAgentFullName": "Francheska Gomez"
+"BuyerAgentKey": "326201062"
+"BuyerAgentMlsId": "191167"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326306836"
+"BuyerOfficeMlsId": "AVNT01"
+"BuyerOfficeName": "Aventus Real Estate Corp"
+"BuyerOfficePhone": "516-234-6519"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-12-05T20:47:48.243466+00:00"
+"CrossStreet": "Washington Avenue"
+"CumulativeDaysOnMarket": 62
+"DaysOnMarket": 62
+"Directions": """
West Merrick Road to Carroll Avenue. \n
OR\n
Ocean Avenue to Washington Avenue to Carroll Avenue.
"""
+"ElementarySchoolDistrict": "Valley Stream Central"
+"ExpirationDate": "2026-06-30"
+"Fencing": array:1 [ …1]
+"Flooring": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:3 [ …3]
+"InteriorFeatures": array:2 [ …2]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:3 [ …3]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "andron@andronrealtygroup.com"
+"ListAgentKey": "326259343"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109378"
+"ListOfficePhone": "516-354-0500"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-12-05"
+"LotFeatures": array:2 [ …2]
+"LotSizeAcres": 0.0643
+"MajorChangeTimestamp": "2026-02-06T20:28:53Z"
+"MajorChangeType": "Pending"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"NumberOfSeparateGasMeters": 2
+"NumberOfUnitsTotal": "2"
+"OffMarketDate": "2026-02-06"
+"OnMarketDate": "2025-12-05"
+"OriginalEntryTimestamp": "2025-12-05T20:46:25Z"
+"OriginalListPrice": 788000
+"OriginatingSystemModificationTimestamp": "2026-02-06T20:28:53Z"
+"OwnerName": "Dimitri"
+"ParcelNumber": "2035-37-430-00-0022-0"
+"ParkingFeatures": array:2 [ …2]
+"ParkingTotal": "3"
+"PatioAndPorchFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-12-05T21:17:03Z"
+"PhotosCount": 4
+"PostalCity": "Valley Stream"
+"PropertyCondition": array:1 [ …1]
+"PurchaseContractDate": "2026-02-05"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-354-0500"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-02-06T20:28:53Z"
+"StreetName": "Carroll"
+"StreetNumber": "121"
+"StreetNumberNumeric": "121"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "11460.2"
+"TaxYear": "2025"
+"Utilities": array:7 [ …7]
+"WaterSource": array:1 [ …1]
+"WindowFeatures": array:1 [ …1]
+"KEY_TaxSource": "Other"
+"KEY_CurrentPrice": "788000.00"
+"KEY_ContractPrice": "770000.00"
+"KEY_NumOf1BedRooms": "1"
+"KEY_NumOf2BedRooms": "1"
+"KEY_NumOf3BedRooms": "0"
+"KEY_NumOf4BedRooms": "0"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_NumberOfHeatingZones": "3"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "12255054.4323"
+"KEY_SourceSystemModificationTimestamp": "2025-12-02T17:47:43.283"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "518.08021"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "518.08021"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422861551')"
+"provider_name": "One Key"
+"Media": array:4 [ …4]
+"ID": "29516"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5128
+post_id: "29543"
+post_author: 1
+"ListingKey": "KEY422860004"
+"ListingId": "940616"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-01-13T07:06:41Z"
+"RFModificationTimestamp": "2026-01-13T07:10:45Z"
+"ListPrice": 640000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1480.0
+"BuildingAreaTotal": 1480.0
+"City": "Hempstead"
+"PostalCode": "11572"
+"UnparsedAddress": "2861 Tilrose Avenue, Hempstead, New York 11572"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6446627
+"Longitude": -73.6399845
+"YearBuilt": 1928
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Glen Fox"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "208175"
+"ListOfficeMlsId": "DERE58"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to 2861 Tilrose Ave in Oceanside, New York—a beautifully renovated and exceptionally spacious home offering comfort, style, and convenience.\n
\n
The main level features a bright, open layout with a generous living room, dining area, and modern kitchen with stainless steel appliances, quartz countertops, and LED hi-hats. This floor also includes a bedroom and a convenient half bath, making the space ideal for both everyday living and entertaining. Hardwood floors run throughout, and the home is equipped with two heating zones for added efficiency.\n
\n
Upstairs, you’ll find a newly renovated full bathroom shared by three bedrooms, along with a comfortable and well-sized primary bedroom.\n
Both the kitchen and bathrooms are brand new, offering a fresh, modern feel.\n
\n
A finished, walk-up attic with full ceiling height provides a tremendous amount of additional living space. The basement—unfinished but with full 7-foot ceilings—offers bonus space as well for storage, complete with its own outside entrance and direct access to the backyard, creating easy indoor-outdoor flow.\n
\n
The property offers parking for over four cars, making it perfect for multi-driver households or guests.\n
\n
Located just moments from the LIRR, shopping, restaurants, and everything Oceanside has to offer, this home combines generous space with everyday convenience. Low taxes of $12,663 and no required flood insurance add to the long-term value.
"""
+"Appliances": array:4 [ …4]
+"AttributionContact": "516-432-3400"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "718-408-0041"
+"BuyerAgentEmail": "drjagnanan@gmail.com"
+"BuyerAgentFullName": "Devin Jagnanan"
+"BuyerAgentKey": "326232876"
+"BuyerAgentMlsId": "224046"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326111285"
+"BuyerOfficeMlsId": "EXP05"
+"BuyerOfficeName": "EXP Realty"
+"BuyerOfficePhone": "888-276-0630"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "818-679-8014"
+"CoListAgentEmail": "kristin.altfather@elliman.com"
+"CoListAgentFullName": "Kristin Altfather"
+"CoListAgentKey": "326217556"
+"CoListAgentMlsId": "208207"
+"CoListOfficeKey": "326110783"
+"CoListOfficeMlsId": "DERE58"
+"CoListOfficeName": "Douglas Elliman Real Estate"
+"CoListOfficePhone": "516-432-3400"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-12-09T22:01:48.617970+00:00"
+"CrossStreet": "Long Beach Rd"
+"CumulativeDaysOnMarket": 34
+"DaysOnMarket": 34
+"DirectionFaces": "South"
+"Directions": "Head west on Tilrose from Long Beach Rd"
+"ElementarySchool": "School 2"
+"ElementarySchoolDistrict": "Oceanside"
+"ExpirationDate": "2026-12-02"
+"Fencing": array:2 [ …2]
+"Flooring": array:3 [ …3]
+"Heating": array:2 [ …2]
+"HighSchool": "School 7-Oceanside Senior Hs"
+"HighSchoolDistrict": "Oceanside"
+"InteriorFeatures": array:7 [ …7]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-850-6437"
+"ListAgentEmail": "glen.fox@elliman.com"
+"ListAgentKey": "326217526"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110783"
+"ListOfficePhone": "516-432-3400"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-12-02"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:4 [ …4]
+"LotSizeAcres": 0.0568
+"LotSizeSquareFeet": 2475
+"MajorChangeTimestamp": "2026-01-12T19:51:20Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School"
+"MiddleOrJuniorSchoolDistrict": "Oceanside"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-01-12"
+"OnMarketDate": "2025-12-09"
+"OriginalEntryTimestamp": "2025-12-02T21:13:24Z"
+"OriginalListPrice": 640000
+"OriginatingSystemModificationTimestamp": "2026-01-12T19:51:20Z"
+"OtherStructures": array:1 [ …1]
+"OwnerName": "2861 Tilrose Avenue Llc"
+"ParcelNumber": "2089-38-385-00-0132-0"
+"ParkingFeatures": array:1 [ …1]
+"PatioAndPorchFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-12-09T22:04:36Z"
+"PhotosCount": 24
+"PostalCity": "Oceanside"
+"PostalCodePlus4": "1200"
+"PriceChangeTimestamp": "2025-12-02T21:13:24Z"
+"PropertyAttachedYN": true
+"PurchaseContractDate": "2026-01-12"
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-850-6437"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-12T19:51:20Z"
+"StreetName": "Tilrose"
+"StreetNumber": "2861"
+"StreetNumberNumeric": "2861"
+"StreetSuffix": "Avenue"
+"StructureType": array:1 [ …1]
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "12663"
+"TaxYear": "2026"
+"Utilities": array:4 [ …4]
+"WaterSource": array:1 [ …1]
+"WindowFeatures": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "640000.00"
+"KEY_ContractPrice": "650000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_DistanceToTrain": "1.50"
+"KEY_ElectricCompany": "PSEG"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "1480.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "818-679-8014"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "432.43243"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "11267605.6338"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "432.43243"
+"KEY_SourceSystemModificationTimestamp": "2025-12-02T16:13:24.210"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "432.43243"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "432.43243"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422860004')"
+"provider_name": "One Key"
+"Media": array:24 [ …24]
+"ID": "29543"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5126
+post_id: "29544"
+post_author: 1
+"ListingKey": "KEY422859415"
+"ListingId": "940595"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-02-04T20:56:36Z"
+"RFModificationTimestamp": "2026-02-04T21:03:15Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1418.0
+"BuildingAreaTotal": 1418.0
+"City": "Hempstead"
+"PostalCode": "11572"
+"UnparsedAddress": "14 Tilrose Avenue, Hempstead, New York 11572"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6446898
+"Longitude": -73.6400428
+"YearBuilt": 1928
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Glen Fox"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "208175"
+"ListOfficeMlsId": "DERE58"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to 14 Tilrose Ave in Oceanside, New York—a spacious, four-level home offering exceptional flexibility for extended or multi-generational living. The main level features a bright, open floor plan with a generous living room, dining area, kitchen, and sunroom, creating a seamless flow for everyday comfort and entertaining. The home offers hardwood floors throughout, two heating zones, and an abundance of parking with room for over four cars. The first floor includes a convenient half bath, while the second floor offers a large full bathroom shared by two bedrooms and a comfortable primary bedroom. The finished walk-up attic provides full ceiling height with an open layout. The fully finished basement offers bonus living space with its own outside entrance and direct access to the backyard, making indoor-outdoor living effortless.\n
Located moments from the LIRR, shopping, restaurants, and all that Oceanside has to offer, this home provides exceptional space and convenience in a prime location. Low taxes of $11,871 and no required flood insurance make this an even more attractive opportunity for long-term value.
"""
+"Appliances": array:1 [ …1]
+"AttributionContact": "516-432-3400"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaSource": "Other"
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "470-353-6600"
+"BuyerAgentEmail": "rrite.iam@gmail.com"
+"BuyerAgentFullName": "Rahat Rite"
+"BuyerAgentKey": "422804565"
+"BuyerAgentMlsId": "505739"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326112861"
+"BuyerOfficeMlsId": "KEWG01"
+"BuyerOfficeName": "Keller Williams Realty Greater"
+"BuyerOfficePhone": "516-873-7100"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "818-679-8014"
+"CoListAgentEmail": "kristin.altfather@elliman.com"
+"CoListAgentFullName": "Kristin Altfather"
+"CoListAgentKey": "326217556"
+"CoListAgentMlsId": "208207"
+"CoListOfficeKey": "326110783"
+"CoListOfficeMlsId": "DERE58"
+"CoListOfficeName": "Douglas Elliman Real Estate"
+"CoListOfficePhone": "516-432-3400"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-12-09T21:19:23.263214+00:00"
+"CrossStreet": "Long Beach Rd"
+"CumulativeDaysOnMarket": 52
+"DaysOnMarket": 52
+"DirectionFaces": "South"
+"Directions": "From Long Beach Rd, head west on Tilrose"
+"ElementarySchool": "School 2"
+"ElementarySchoolDistrict": "Oceanside"
+"ExpirationDate": "2026-12-02"
+"Fencing": array:2 [ …2]
+"Flooring": array:2 [ …2]
+"Heating": array:2 [ …2]
+"HighSchool": "School 7-Oceanside Senior Hs"
+"HighSchoolDistrict": "Oceanside"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:3 [ …3]
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-850-6437"
+"ListAgentEmail": "glen.fox@elliman.com"
+"ListAgentKey": "326217526"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110783"
+"ListOfficePhone": "516-432-3400"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-12-02"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:5 [ …5]
+"LotSizeAcres": 0.0614
+"LotSizeSquareFeet": 2675
+"MajorChangeTimestamp": "2026-01-30T17:56:37Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School"
+"MiddleOrJuniorSchoolDistrict": "Oceanside"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-01-30"
+"OnMarketDate": "2025-12-09"
+"OriginalEntryTimestamp": "2025-12-02T20:45:28Z"
+"OriginalListPrice": 599000
+"OriginatingSystemModificationTimestamp": "2026-02-04T20:55:26Z"
+"OtherStructures": array:1 [ …1]
+"OwnerName": "14 Tilrose Avenue Llc"
+"ParcelNumber": "2089-38-385-00-0131-0"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "3"
+"PhotosChangeTimestamp": "2025-12-09T21:48:36Z"
+"PhotosCount": 29
+"PostalCity": "Oceanside"
+"PostalCodePlus4": "1221"
+"PropertyAttachedYN": true
+"PurchaseContractDate": "2026-01-30"
+"RoomsTotal": "9"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-850-6437"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-30T17:56:37Z"
+"StreetName": "Tilrose"
+"StreetNumber": "14"
+"StreetNumberNumeric": "14"
+"StreetSuffix": "Avenue"
+"StructureType": array:1 [ …1]
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "11871"
+"TaxYear": "2026"
+"Utilities": array:5 [ …5]
+"WaterSource": array:1 [ …1]
+"WindowFeatures": array:2 [ …2]
+"KEY_Attic": "None"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "599000.00"
+"KEY_ContractPrice": "620000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_OpenHouseCount": "2"
+"KEY_PreviousStatus": "Active"
+"KEY_DistanceToTrain": "1.50"
+"KEY_ElectricCompany": "PSEG"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "2"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "1418.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "818-679-8014"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "422.42595"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "9755700.3257"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "422.42595"
+"KEY_SourceSystemModificationTimestamp": "2025-12-02T15:38:11.957"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "422.42595"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "422.42595"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422859415')"
+"provider_name": "One Key"
+"Media": array:29 [ …29]
+"ID": "29544"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5123
+post_id: "29502"
+post_author: 1
+"ListingKey": "KEY422858791"
+"ListingId": "940579"
+"PropertyType": "Residential"
+"PropertySubType": "Stock Cooperative"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-01-29T07:05:44Z"
+"RFModificationTimestamp": "2026-01-29T07:08:35Z"
+"ListPrice": 250000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 726.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11581"
+"UnparsedAddress": "510 Du Bois Avenue Unit 11b, Hempstead, New York 11581"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 1950
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Debra B. Miller CBR PSA"
+"ListOfficeName": "Cato Realty Inc"
+"ListAgentMlsId": "132519"
+"ListOfficeMlsId": "CATO01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Welcome home to this beautifully updated one bedroom co-op featuring gleaming wood floors, a newly renovated bathroom, and a modern kitchen with stainless steel appliances. The dining room opens seamlessly into the spacious living room, creating an ideal layout for both everyday living and entertaining. Generous closet space throughout completes this move-in-read home. Laundry in building. Gibson railroad station in rear of building making it ideal for travel. Parking available. Board approval required."
+"Appliances": array:1 [ …1]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "718-217-2549"
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-741-4333"
+"BuyerAgentEmail": "wneal@signaturepremier.com"
+"BuyerAgentFullName": "Wendy M. Neal"
+"BuyerAgentKey": "326226615"
+"BuyerAgentMlsId": "217566"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326115719"
+"BuyerOfficeMlsId": "SPH11"
+"BuyerOfficeName": "Signature Premier Properties"
+"BuyerOfficePhone": "516-741-4333"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-12-04T19:36:08.572384+00:00"
+"CrossStreet": "Cochran Pl"
+"CumulativeDaysOnMarket": 54
+"DaysOnMarket": 54
+"Directions": "Mill Rd to Dubois"
+"ElementarySchool": "Hewlett Elementary School"
+"ElementarySchoolDistrict": "Hewlett-Woodmere"
+"EntryLevel": 2
+"ExpirationDate": "2026-06-30"
+"Heating": array:1 [ …1]
+"HighSchool": "George W Hewlett High School"
+"HighSchoolDistrict": "Hewlett-Woodmere"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-668-1838"
+"ListAgentEmail": "debra.miller@catorealtyinc.com"
+"ListAgentKey": "326146590"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110132"
+"ListOfficePhone": "718-217-2549"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-12-04"
+"LivingAreaSource": "Plans"
+"MajorChangeTimestamp": "2026-01-28T17:13:16Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Valley Stream Memorial Junior High School"
+"MiddleOrJuniorSchoolDistrict": "Valley Stream Central"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-01-28"
+"OnMarketDate": "2025-12-04"
+"OriginalEntryTimestamp": "2025-12-04T19:29:28Z"
+"OriginalListPrice": 250000
+"OriginatingSystemModificationTimestamp": "2026-01-28T17:13:16Z"
+"OwnerName": "Estate of Audrian Augustus"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1"
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-12-04T19:30:36Z"
+"PhotosCount": 20
+"PostalCity": "Valley Stream"
+"PurchaseContractDate": "2026-01-27"
+"RoomsTotal": "4"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "718-217-2549"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-28T17:13:16Z"
+"StreetName": "Du Bois"
+"StreetNumber": "510"
+"StreetNumberNumeric": "510"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"UnitNumber": "11B"
+"Utilities": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"KEY_FlipTaxYN": "1"
+"KEY_ParkingFee": "40"
+"KEY_CurrentPrice": "250000.00"
+"KEY_ContractPrice": "250000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_RentingAllowedYN": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_ApprovalRequiredYN": "1"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_EstimatedMaintenance": "861"
+"KEY_LivingAreaSearchSqFt": "726.00"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_MinimumPctDownPayment": "20"
+"KEY_RATIO_ListPrice_By_LivingArea": "344.35262"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "344.35262"
+"KEY_SourceSystemModificationTimestamp": "2025-12-02T14:59:05.893"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422858791')"
+"provider_name": "One Key"
+"Media": array:20 [ …20]
+"ID": "29502"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5122
+post_id: "29494"
+post_author: 1
+"ListingKey": "KEY422858453"
+"ListingId": "940569"
+"PropertyType": "Residential"
+"PropertySubType": "Stock Cooperative"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-03-03T07:04:42Z"
+"RFModificationTimestamp": "2026-03-03T07:04:52Z"
+"ListPrice": 419999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1200.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "47 Anchor Street Unit Y, Hempstead, New York 11520"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 1985
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Dorrie C. Capizzi"
+"ListOfficeName": "Signature Premier Properties"
+"ListAgentMlsId": "9022274"
+"ListOfficeMlsId": "SPH07"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "This Fantastic Waterfront Retreat With Amazing Views Is Located In The Village Of Freeport With All It's Amenities! Boat Slips May Be Available For Rental! Enter In To A Spacious Hallway With Double Closet & Deco Chandelier. Lovely Eat In Kitchen With Quartz Counters, Cherrywood Cabinets, Stainless Appliances, Exquisite Backsplash, & Tile Flooring. New Frigidaire Refrigerator & Microwave. Spacious Living Rm/Dining Rm Combination With Cathedral Ceiling, Laminate Wide Plank Wood Flooring, Skylights, & Slider Leading To Your Own Private Balcony With Magnificent Waterviews Of The Wide Canal. Large Primary Bedroom With Ensuite Bath Located On The First Floor Offers Great Waterviews & Spacious Double Closet. 7 Year Old Ensuite Bath With Walk-In Shower, Extensive Tile Work/Glass Deco's, Unique Vanity, & Kohler Fixtures. Laundry Area With Stackable Washer/Dryer. The 2nd Floor Offers A Great Loft Bedroom Featuring Large Windows Facing The Canal & Vaulted Ceiling. An Additional Bath With Tile Flooring Adjoins The Loft Bedroom. This Unit Also Features A Walk-In Attic Room - Great For Storage Or Possible Closet. Take In The Views On Your Wonderful, Covered, & Private Balcony! Other Features Include: 7 Year Old Heat Pump & Hot Water Heater, New Panel Box For Electric, Newly Updated CAC, Recessed Lighting, & Storage Room For Bicycle Nearby. Close To All Shopping, LIRR, Major Roads, & The Nautical Mile With Restaurants, Night Life & Fishing!"
+"Appliances": array:10 [ …10]
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": "Boat Dock,Landscaping,Maintenance,Maintenance Grounds,Parking,Powered Boats Allowed,Trash"
+"AssociationFee": "1050"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:7 [ …7]
+"AssociationPhone": "(516) 223-8833"
+"AssociationYN": true
+"AttributionContact": "631-422-3100"
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"BuildingFeatures": array:1 [ …1]
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-445-4848"
+"BuyerAgentEmail": "annettevmiller@gmail.com"
+"BuyerAgentFullName": "Annette Vasquez Miller"
+"BuyerAgentKey": "326151271"
+"BuyerAgentMlsId": "137647"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326113175"
+"BuyerOfficeMlsId": "LIKE01"
+"BuyerOfficeName": "Linda Kettering Realty Corp"
+"BuyerOfficePhone": "516-792-0680"
+"CommonWalls": array:1 [ …1]
+"CommunityFeatures": array:2 [ …2]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-12-03T22:50:52.101250+00:00"
+"CrossStreet": "Westend Ave"
+"CumulativeDaysOnMarket": 89
+"DaysOnMarket": 89
+"Directions": "Atlantic Ave To Westend Ave To Anchor St (Anchors Edge Community). Last Building On Left At End Of Parking Lot. Go Up The Center Stair Alcove & To The Right."
+"ElementarySchool": "Leo F Giblyn School"
+"ElementarySchoolDistrict": "Freeport"
+"EntryLevel": 1
+"ExpirationDate": "2026-06-03"
+"ExteriorFeatures": array:3 [ …3]
+"Flooring": array:3 [ …3]
+"Heating": array:3 [ …3]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:17 [ …17]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:3 [ …3]
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "631-926-8102"
+"ListAgentEmail": "dorriehomes@gmail.com"
+"ListAgentKey": "326253930"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115715"
+"ListOfficePhone": "631-422-3100"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-12-03"
+"ListingTerms": "Cash,Conventional"
+"LivingAreaSource": "Other"
+"LotFeatures": array:7 [ …7]
+"MajorChangeTimestamp": "2026-03-03T01:41:21Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "John W Dodd Middle School"
+"MiddleOrJuniorSchoolDistrict": "Freeport"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-03-02"
+"OnMarketDate": "2025-12-03"
+"OriginalEntryTimestamp": "2025-12-03T22:48:25Z"
+"OriginalListPrice": 449999
+"OriginatingSystemModificationTimestamp": "2026-03-03T01:41:21Z"
+"OwnerName": "Luckman"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "1"
+"PatioAndPorchFeatures": array:2 [ …2]
+"PetsAllowed": array:2 [ …2]
+"PhotosChangeTimestamp": "2025-12-03T22:49:36Z"
+"PhotosCount": 28
+"PostalCity": "Freeport"
+"PreviousListPrice": 449999
+"PriceChangeTimestamp": "2026-01-21T20:00:52Z"
+"PropertyAttachedYN": true
+"PropertyCondition": array:1 [ …1]
+"PurchaseContractDate": "2026-03-02"
+"RoadFrontageType": array:1 [ …1]
+"RoadResponsibility": array:1 [ …1]
+"RoomsTotal": "5"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "631-422-3100"
+"ShowingRequirements": array:3 [ …3]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-03-03T01:41:21Z"
+"StoriesTotal": "2"
+"StreetName": "Anchor"
+"StreetNumber": "47"
+"StreetNumberNumeric": "47"
+"StreetSuffix": "Street"
+"SubdivisionName": "Anchors Edge"
+"SyndicateTo": array:2 [ …2]
+"UnitNumber": "Y"
+"Utilities": array:5 [ …5]
+"View": "Water"
+"WaterSource": array:1 [ …1]
+"WaterfrontFeatures": array:5 [ …5]
+"WaterfrontYN": true
+"WindowFeatures": array:6 [ …6]
+"KEY_Attic": "Partial,See Remarks,Storage,Unfinished"
+"KEY_FlipTaxYN": "0"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "419999.00"
+"KEY_ContractPrice": "425000.00"
+"KEY_WaterAccessYN": "1"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_SharesNumberOf": "185"
+"KEY_ElectricCompany": "Other"
+"KEY_AdditionalFeesYN": "0"
+"KEY_RentingAllowedYN": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_ApprovalRequiredYN": "1"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LocationDescription": "Second Floor"
+"KEY_EstimatedMaintenance": "0"
+"KEY_LivingAreaSearchSqFt": "1200.00"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_MinimumPctDownPayment": "10"
+"KEY_MinimumIncomeRequiredYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "349.99917"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "349.99917"
+"KEY_SourceSystemModificationTimestamp": "2025-12-02T14:44:46.853"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.93333"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422858453')"
+"provider_name": "One Key"
+"Media": array:28 [ …28]
+"ID": "29494"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5129
+post_id: "29656"
+post_author: 1
+"ListingKey": "KEY422847059"
+"ListingId": "940230"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-18T19:09:38Z"
+"RFModificationTimestamp": "2026-04-18T19:14:26Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1846.0
+"BuildingAreaTotal": 1846.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "135 Whaley Street, Hempstead, New York 11520"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6483687
+"Longitude": -73.5894377
+"YearBuilt": 1903
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Kimberly Padilla Maravilla"
+"ListOfficeName": "Oversouth LLC"
+"ListAgentMlsId": "228172"
+"ListOfficeMlsId": "OVRS02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Experience this luxurious colonial conveniently located near shops and water front restaurants and more!\n
This diamond condition colonial boasts luxury amenities such as open layout a beautiful Island- hardwood floorings and high hats through out the house. This house is completely gutted and everything has been replaced to the studs! Don't miss out on this opportunity to make this home yours! Truly chef's kiss\n
\n
All information are deemed accurate, but must be independently verified and buyers are to do their due-diligence.
"""
+"Appliances": array:6 [ …6]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "631-770-0030"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-12-24T19:32:49.080049+00:00"
+"CumulativeDaysOnMarket": 116
+"DaysOnMarket": 118
+"ElementarySchool": "Archer Street School"
+"ElementarySchoolDistrict": "Freeport"
+"ExpirationDate": "2026-12-01"
+"FireplaceFeatures": array:2 [ …2]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [ …1]
+"FoundationDetails": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:10 [ …10]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "631-805-0106"
+"ListAgentEmail": "Kmaravilla@oversouthre.com"
+"ListAgentKey": "326236904"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "406610771"
+"ListOfficePhone": "631-770-0030"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-12-01"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1837
+"LotSizeSquareFeet": 8000
+"MajorChangeTimestamp": "2026-04-08T13:48:12Z"
+"MajorChangeType": "Price Change"
+"MiddleOrJuniorSchool": "John W Dodd Middle School"
+"MiddleOrJuniorSchoolDistrict": "Freeport"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2025-12-23"
+"OriginalEntryTimestamp": "2025-12-01T21:56:51Z"
+"OriginalListPrice": 920000
+"OriginatingSystemModificationTimestamp": "2026-04-18T19:08:28Z"
+"OwnerName": "Cornwells Beach Holdings LLC"
+"ParcelNumber": "2009-62-129-00-0002-0"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-12-23T23:05:36Z"
+"PhotosCount": 20
+"PostalCity": "Freeport"
+"PostalCodePlus4": "4220"
+"PreviousListPrice": 920000
+"PriceChangeTimestamp": "2026-04-08T13:48:12Z"
+"PropertyCondition": array:1 [ …1]
+"RoomsTotal": "9"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "631-805-0106"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-12-01T21:56:51Z"
+"StreetName": "Whaley"
+"StreetNumber": "135"
+"StreetNumberNumeric": "135"
+"StreetSuffix": "Street"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "12933.32"
+"TaxAssessedValue": 411
+"TaxLot": "2"
+"TaxYear": "2024"
+"Utilities": array:3 [ …3]
+"WaterSource": array:1 [ …1]
+"WindowFeatures": array:2 [ …2]
+"YearBuiltEffective": 1903
+"KEY_Attic": "Full,Storage"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "899000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_OpenHouseCount": "1"
+"KEY_MlsDistrictCode": "6212900020"
+"KEY_AdditionalFeesYN": "0"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "Price Decrease"
+"KEY_LivingAreaSearchSqFt": "1846.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "486.99892"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "4893848.6663"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "486.99892"
+"KEY_SourceSystemModificationTimestamp": "2025-12-01T16:55:52.057"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "486.99892"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.97717"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "486.99892"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422847059')"
+"provider_name": "One Key"
+"Media": array:20 [ …20]
+"ID": "29656"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5130
+post_id: "29521"
+post_author: 1
+"ListingKey": "KEY422839433"
+"ListingId": "939969"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-02-16T19:49:36Z"
+"RFModificationTimestamp": "2026-02-16T19:56:49Z"
+"ListPrice": 799999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 1422.0
+"BuildingAreaTotal": 1422.0
+"City": "Hempstead"
+"PostalCode": "11581"
+"UnparsedAddress": "98 Miriam Street, Hempstead, New York 11581"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6557758
+"Longitude": -73.6931688
+"YearBuilt": 1953
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Hassan Z. Shah"
+"ListOfficeName": "Blackstone Realty"
+"ListAgentMlsId": "210090"
+"ListOfficeMlsId": "RCHB01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Discover the perfect blend of space, comfort, and convenience in this 6-bedroom, 3-bath single-family home with a true mother-daughter layout - ideal for extended families, guests, or anyone seeking flexible living options.\n
\n
Every bedroom is generously sized, and the home features a thoughtfully designed multifamily in-law floor plan, allowing for privacy while keeping loved ones close. Enjoy bright, open living spaces that flow seamlessly into a beautiful sunroom, perfect for morning coffee, relaxation, or year-round entertaining. Not only that, but this property is perched on a bright corner lot, this home enjoys abundant sunlight - a perfect match for its energy-saving solar panels\n
\n
The property also includes a private garage, giving you the ultimate convenience for parking or additional storage - a rare advantage in this location.\n
\n
Nestled right between Sunrise Highway and Rockaway Avenue, this home puts you at the heart of everything. Commuting is effortless with the LIRR train and ELFC just a 10-minute walk away, plus multiple Nassau County bus lines (n1, n4, n31, n32) nearby. You’ll also have quick access to all your shopping needs - from groceries and essentials to retail and dining - all just minutes away.\n
\n
This home checks every box: spacious bedrooms, versatile layout, sunroom, garage, and unbeatable location.
"""
+"Appliances": array:6 [ …6]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-802-3939"
+"Basement": array:3 [ …3]
+"BasementYN": true
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-12-06T02:21:04.722108+00:00"
+"CumulativeDaysOnMarket": 73
+"DaysOnMarket": 136
+"ElementarySchool": "Contact Agent"
+"ElementarySchoolDistrict": "Contact Agent"
+"ExpirationDate": "2026-12-01"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Contact Agent"
+"HighSchoolDistrict": "Contact Agent"
+"InteriorFeatures": array:12 [ …12]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "929-261-6754"
+"ListAgentEmail": "hassanrealtor110@gmail.com"
+"ListAgentKey": "326219369"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326114911"
+"ListOfficePhone": "516-802-3939"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-12-01"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1217
+"LotSizeSquareFeet": 5301
+"MajorChangeTimestamp": "2026-02-16T19:47:46Z"
+"MajorChangeType": "Price Change"
+"MiddleOrJuniorSchool": "Call Listing Agent"
+"MiddleOrJuniorSchoolDistrict": "Contact Agent"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2025-12-05"
+"OriginalEntryTimestamp": "2025-12-01T16:22:52Z"
+"OriginalListPrice": 849999
+"OriginatingSystemModificationTimestamp": "2026-02-16T19:47:46Z"
+"OwnerName": "Rizwan & Noman Ayoub"
+"ParcelNumber": "2035-39-023-00-0062-0"
+"ParkingFeatures": array:3 [ …3]
+"ParkingTotal": "2"
+"PhotosChangeTimestamp": "2025-12-01T16:24:36Z"
+"PhotosCount": 16
+"PostalCity": "Valley Stream"
+"PostalCodePlus4": "1321"
+"PreviousListPrice": 849999
+"PriceChangeTimestamp": "2026-02-16T19:47:46Z"
+"RoomsTotal": "10"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "800-746-9464"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-12-01T16:22:52Z"
+"StreetName": "Miriam"
+"StreetNumber": "98"
+"StreetNumberNumeric": "98"
+"StreetSuffix": "Street"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "9736.53"
+"TaxAssessedValue": 473
+"TaxYear": "2024"
+"Utilities": array:6 [ …6]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "799999.00"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "Price Decrease"
+"KEY_LivingAreaSearchSqFt": "1422.00"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "562.58720"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6573533.2786"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "562.58720"
+"KEY_SourceSystemModificationTimestamp": "2025-12-01T11:22:52.017"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "562.58720"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.94118"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "562.58720"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422839433')"
+"provider_name": "One Key"
+"Media": array:16 [ …16]
+"ID": "29521"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5131
+post_id: "29469"
+post_author: 1
+"ListingKey": "KEY422836217"
+"ListingId": "939877"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-18T11:57:36Z"
+"RFModificationTimestamp": "2026-04-18T11:59:40Z"
+"ListPrice": 1899000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 5000.0
+"BuildingAreaTotal": 5000.0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "1680 Lake Avenue, Hempstead, New York 11566"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6775561
+"Longitude": -73.5561307
+"YearBuilt": 2007
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Maria R. Aramanda"
+"ListOfficeName": "Gull Realty Inc"
+"ListAgentMlsId": "9032558"
+"ListOfficeMlsId": "GURE01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Set on lush, park-like large grounds exclusively private in one of Merrick’s most desirable neighborhoods, this exceptional Colonial residence offers privacy, scale, and refined living at every turn.\n
A grand entry welcomes you into sun-filled interiors featuring rich hardwood floors, custom doors and windows, and thoughtfully designed spaces ideal for both everyday living and elegant entertaining. The expansive gourmet kitchen opens seamlessly to a warm family room anchored by a striking stone fireplace and sliding glass doors that lead to an oversized outdoor deck—perfect for indoor-outdoor gatherings.\n
The living room impresses with soaring 20-foot vaulted ceilings, crown moldings, and a unique waterfall tray detail that creates a serene and inviting atmosphere. A formal dining room adds sophistication, while a first-floor bedroom or home office with a full bath provides flexibility for guests or multigenerational living.\n
The upper level features a luxurious primary suite with a spa-like bathroom and his-and-hers walk-in closets, along with generously sized bedrooms, including a Jack-and-Jill layout and additional private bath. All rooms are enhanced with custom built-ins and California closets.\n
The fully finished basement extends the living space with additional bedrooms, a full bath, a gym, walk-in closets, a large family room, and a custom-built playhouse—creating a perfect retreat for relaxation and recreation.\n
Additional highlights there is an extra 2500 sq ft of living with 2 to 3 bedrooms on the lower level \n
could be possible M/D included are central air conditioning, gas heat, central vacuum, in-ground sprinklers, custom outdoor lighting, a two-car garage, and parking for up to six vehicles. The expansive grounds offers complete privacy ample space for a pool, tennis court, or outdoor oasis.\n
A rare opportunity to own a distinguished home offering exceptional space, comfort, and lifestyle in Merrick.
"""
+"Appliances": array:10 [ …10]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-889-4600"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 5
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-12-01T09:11:23.465270+00:00"
+"CumulativeDaysOnMarket": 135
+"DaysOnMarket": 137
+"ElementarySchool": "Birch School"
+"ElementarySchoolDistrict": "Merrick"
+"ExpirationDate": "2026-05-30"
+"FireplaceYN": true
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Sanford H Calhoun High School"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"InteriorFeatures": array:22 [ …22]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "maria@gullrealty.com"
+"ListAgentKey": "326257372"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326111848"
+"ListOfficePhone": "516-889-4600"
+"ListingAgreement": "Exclusive Agency"
+"ListingContractDate": "2025-12-01"
+"LivingAreaSource": "Measured"
+"LotSizeAcres": 0.3225
+"LotSizeSquareFeet": 14048
+"MajorChangeTimestamp": "2026-01-10T18:50:49Z"
+"MajorChangeType": "Price Change"
+"MiddleOrJuniorSchool": "Merrick Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2025-12-04"
+"OriginalEntryTimestamp": "2025-12-01T09:09:22Z"
+"OriginalListPrice": 1800000
+"OriginatingSystemModificationTimestamp": "2026-04-18T11:56:18Z"
+"OwnerName": "Veronica Florentino & Anthony Gallo"
+"ParcelNumber": "2089-56-144-00-0707-0"
+"ParkingFeatures": array:2 [ …2]
+"PhotosChangeTimestamp": "2026-01-03T04:08:36Z"
+"PhotosCount": 44
+"PostalCity": "Merrick"
+"PostalCodePlus4": "2483"
+"PreviousListPrice": 1950000
+"PriceChangeTimestamp": "2026-01-10T18:50:49Z"
+"RoomsTotal": "11"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-889-4600"
+"ShowingRequirements": array:1 [ …1]
+"SpaFeatures": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-12-04T05:31:04Z"
+"StreetName": "Lake"
+"StreetNumber": "1680"
+"StreetNumberNumeric": "1680"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "30437.37"
+"TaxAssessedValue": 1051
+"TaxYear": "2024"
+"Utilities": array:5 [ …5]
+"VirtualTourURLBranded": "https://tours.onefinedaymedia.com/305080"
+"VirtualTourURLUnbranded": "https://tours.onefinedaymedia.com/idx/305080"
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Full"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "1899000.00"
+"KEY_OpenHouseCount": "0"
+"KEY_PreviousStatus": "Coming Soon"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "Price Decrease"
+"KEY_LivingAreaSearchSqFt": "5000.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "516-849-6035"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "379.80000"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "5888372.0930"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "379.80000"
+"KEY_SourceSystemModificationTimestamp": "2025-12-01T04:09:22.623"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.05500"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422836217')"
+"provider_name": "One Key"
+"Media": array:44 [ …44]
+"ID": "29469"
}
10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5132
+post_id: "29480"
+post_author: 1
+"ListingKey": "KEY422833539"
+"ListingId": "939853"
+"PropertyType": "Residential"
+"PropertySubType": "Stock Cooperative"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-02-24T07:02:41Z"
+"RFModificationTimestamp": "2026-02-24T07:04:44Z"
+"ListPrice": 359999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 900.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11572"
+"UnparsedAddress": "4 Rose Street Unit 7, C-1, Hempstead, New York 11572"
+"Coordinates": array:2 [ …2]
+"Latitude": 30.0929491
+"Longitude": -96.0806548
+"YearBuilt": 1964
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Nicholas Santillo"
+"ListOfficeName": "Signature Premier Properties"
+"ListAgentMlsId": "209444"
+"ListOfficeMlsId": "SPH11"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Welcome to 4 Rose Street, Unit 7C-1 — a charming and beautifully maintained 2-bedroom, 1-bath co-op located in one of Oceanside’s most serene and sought-after waterfront communities. This inviting unit features gleaming hardwood floors, a full kitchen, and exceptional storage throughout. The entire complex has recently undergone extensive upgrades, including newly repaved grounds and refreshed common areas, enhancing both aesthetics and long-term value. Residents enjoy a host of lifestyle amenities, including a fitness center, dog run, and beautifully kept outdoor spaces. For water enthusiasts, seasonal boat slips are available for just $500, perfect for boats or jet skis, with kayak storage offered at $75 per season. Each unit comes with an assigned parking spot, with additional parking options available for $50 per month. A convenient bike shed is also available for only $5 per month. Maintenance is $1,626 with STAR, and includes taxes, water, heat, and parking."
+"Appliances": array:5 [ …5]
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": "Boat Dock,Fitness Center,Landscaping,Live In Super,Maintenance Grounds,Parking,Pool,Snow Removal"
+"AssociationFeeIncludes": array:10 [ …10]
+"AssociationYN": true
+"AttributionContact": "516-741-4333"
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"BuildingFeatures": array:2 [ …2]
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-427-0866"
+"BuyerAgentEmail": "judy.hendrickson@elliman.com"
+"BuyerAgentFullName": "Judy Hendrickson"
+"BuyerAgentKey": "326223651"
+"BuyerAgentMlsId": "214501"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326110763"
+"BuyerOfficeMlsId": "DERE23"
+"BuyerOfficeName": "Douglas Elliman Real Estate"
+"BuyerOfficePhone": "516-354-6500"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "347-575-3800"
+"CoListAgentEmail": "omalayeva@signaturepremier.com"
+"CoListAgentFullName": "Oksana Malayeva SFR"
+"CoListAgentKey": "326189005"
+"CoListAgentMlsId": "178388"
+"CoListOfficeKey": "326115723"
+"CoListOfficeMlsId": "SPH15"
+"CoListOfficeName": "Signature Premier Properties"
+"CoListOfficePhone": "516-766-7900"
+"CommonWalls": array:1 [ …1]
+"CommunityFeatures": array:4 [ …4]
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-12-02T14:39:16.267919+00:00"
+"CumulativeDaysOnMarket": 80
+"DaysOnMarket": 80
+"ElementarySchool": "School 8"
+"ElementarySchoolDistrict": "Oceanside"
+"EntryLevel": 1
+"ExpirationDate": "2026-09-02"
+"Flooring": array:1 [ …1]
+"Heating": array:2 [ …2]
+"HighSchool": "School 7-Oceanside Senior Hs"
+"HighSchoolDistrict": "Oceanside"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-924-3677"
+"ListAgentEmail": "nsantillo@signaturepremier.com"
+"ListAgentKey": "326218742"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115719"
+"ListOfficePhone": "516-741-4333"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-12-02"
+"LivingAreaSource": "Other"
+"MajorChangeTimestamp": "2026-02-24T01:00:38Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School"
+"MiddleOrJuniorSchoolDistrict": "Oceanside"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-02-23"
+"OnMarketDate": "2025-12-02"
+"OriginalEntryTimestamp": "2025-12-02T14:33:34Z"
+"OriginalListPrice": 359999
+"OriginatingSystemModificationTimestamp": "2026-02-24T01:00:38Z"
+"OwnerName": "Fitzroy"
+"ParcelNumber": "2089-43-B-00-0008-0"
+"ParkingFeatures": array:2 [ …2]
+"PetsAllowed": array:4 [ …4]
+"PhotosChangeTimestamp": "2025-12-02T14:34:36Z"
+"PhotosCount": 21
+"PostalCity": "Oceanside"
+"PropertyAttachedYN": true
+"PurchaseContractDate": "2026-02-20"
+"RoomsTotal": "6"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "347-575-3800"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-02-24T01:00:38Z"
+"StoriesTotal": "2"
+"StreetName": "Rose"
+"StreetNumber": "4"
+"StreetNumberNumeric": "4"
+"StreetSuffix": "Street"
+"SubdivisionName": "Ocean Harbor Club"
+"SyndicateTo": array:2 [ …2]
+"UnitNumber": "7, C-1"
+"Utilities": array:7 [ …7]
+"WaterSource": array:1 [ …1]
+"WaterfrontFeatures": array:2 [ …2]
+"WaterfrontYN": true
+"KEY_FlipTaxYN": "1"
+"KEY_CurrentPrice": "359999.00"
+"KEY_ContractPrice": "340000.00"
+"KEY_FlipTaxAmount": "3%"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_ApprovalRequiredYN": "1"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_EstimatedMaintenance": "1667"
+"KEY_LivingAreaSearchSqFt": "900.00"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_MinimumPctDownPayment": "20"
+"KEY_RATIO_ListPrice_By_LivingArea": "399.99889"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "399.99889"
+"KEY_SourceSystemModificationTimestamp": "2025-11-30T19:50:27.297"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422833539')"
+"provider_name": "One Key"
+"Media": array:21 [ …21]
+"ID": "29480"
}
11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5133
+post_id: "29854"
+post_author: 1
+"ListingKey": "KEY422832232"
+"ListingId": "939812"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-21T21:38:36Z"
+"RFModificationTimestamp": "2026-01-21T21:40:34Z"
+"ListPrice": 869000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 3192.0
+"BuildingAreaTotal": 3192.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "4 Laurette Lane, Hempstead, New York 11520"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.639469
+"Longitude": -73.5708127
+"YearBuilt": 1958
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Carolyn Campbell Gould CBR"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "104994"
+"ListOfficeMlsId": "DERE03"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Welcome to this beautiful Colonial-style home located in the Village of Freeport. Offering an impressive 6 bedrooms which includes a spacious en-suite and 4 full bathrooms. This spacious 3000+ residence is perfect for extended living and entertaining. The oversized Eat-In- Kitchen features energy efficient stainless-steel appliances and generous counter space, ideal for gatherings and everyday meals. Relax in the spa-like bathroom with an oversize jacuzzi tub and shower. This home also features, a formal dining room and 2- living rooms. Enjoy the convenience of an attached garage with direct access into the kitchen. The primary- living room includes a custom cherrywood built in entertainment center and a fireplace, adding warmth and elegance. The secondary- living room with sliding doors allow access to a large fenced backyard, complete with a patio that's perfect for outdoor dining or quiet relaxation. Enjoy the convenience of Central air and IG sprinkler systems!! Situated on an expansive 60X100 lot, this home provides privacy and room to grow. Don't miss this exceptional opportunity in the village with its own Police/ Electric/ Water depts. Close to LIRR/Parkways/Beaches/ Parks/ Golf courses/ Shopping/ Recreation center with indoor/outdoor- pools/gym/basketball courts. Only minutes to the Nautical mile- great restaurants with boat docking access!"
+"Appliances": array:2 [ …2]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-921-2262"
+"BathroomsFull": 4
+"BuildingAreaUnits": "Square Feet"
+"CarportSpaces": "1"
+"CarportYN": true
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-01-19T21:13:47.214040+00:00"
+"CumulativeDaysOnMarket": 36
+"DaysOnMarket": 125
+"ElementarySchool": "Leo F Giblyn School"
+"ElementarySchoolDistrict": "Freeport"
+"ExpirationDate": "2026-06-30"
+"Fencing": array:2 [ …2]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:9 [ …9]
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "carolyn.campbell@elliman.com"
+"ListAgentKey": "326121370"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110753"
+"ListOfficePhone": "516-921-2262"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-12-08"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.1377
+"LotSizeDimensions": "60x100"
+"LotSizeSquareFeet": 6000
+"MajorChangeTimestamp": "2026-01-21T21:37:10Z"
+"MajorChangeType": "Price Change"
+"MiddleOrJuniorSchool": "John W Dodd Middle School"
+"MiddleOrJuniorSchoolDistrict": "Freeport"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2025-12-16"
+"OriginalEntryTimestamp": "2025-12-09T00:24:21Z"
+"OriginalListPrice": 899000
+"OriginatingSystemModificationTimestamp": "2026-01-21T21:37:10Z"
+"OwnerName": "Gregory Carr Jr"
+"ParcelNumber": "2009-62-205-00-0004-0"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-12-16T21:23:36Z"
+"PhotosCount": 29
+"PostalCity": "Freeport"
+"PostalCodePlus4": "5732"
+"PreviousListPrice": 899000
+"PriceChangeTimestamp": "2026-01-21T21:37:10Z"
+"RoomsTotal": "11"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-921-2262"
+"ShowingRequirements": array:2 [ …2]
+"SpaFeatures": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-12-09T00:24:21Z"
+"StreetName": "Laurette"
+"StreetNumber": "4"
+"StreetNumberNumeric": "4"
+"StreetSuffix": "Lane"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "17677.1"
+"TaxAssessedValue": 578
+"TaxYear": "2025"
+"Utilities": array:2 [ …2]
+"VirtualTourURLUnbranded": "https://jumpvisualtours.com/u/488909"
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "869000.00"
+"KEY_ElectricCompany": "Other"
+"KEY_MlsMajorChangeType": "Price Decrease"
+"KEY_LivingAreaSearchSqFt": "3192.00"
+"KEY_ShowingContactPhone2": "516-972-5772"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "272.24311"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6310820.6245"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "272.24311"
+"KEY_SourceSystemModificationTimestamp": "2025-11-30T14:57:45.333"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "272.24311"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.96663"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "272.24311"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422832232')"
+"provider_name": "One Key"
+"Media": array:29 [ …29]
+"ID": "29854"
}
12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5134
+post_id: "29464"
+post_author: 1
+"ListingKey": "KEY422830891"
+"ListingId": "939763"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-19T20:09:38Z"
+"RFModificationTimestamp": "2026-04-19T20:13:23Z"
+"ListPrice": 1199000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3045.0
+"BuildingAreaTotal": 3045.0
+"City": "Hempstead"
+"PostalCode": "11572"
+"UnparsedAddress": "3452 Ocean Avenue, Hempstead, New York 11572"
+"Coordinates": array:2 [ …2]
+"Latitude": 30.0929491
+"Longitude": -96.0806548
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Maria Lindh"
+"ListOfficeName": "Next Level Real Estate NY"
+"ListAgentMlsId": "111539"
+"ListOfficeMlsId": "MRLI01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Summer is coming and what better place to live than here!?!? 3,045 sq ft of stay-cation living on an impressive 80ft wide deep canal where summer 2026 can be all about boating days, backyard nights, and a lifestyle that feels like vacation. This expanded 4 bedroom, 2 bath ranch features open, sunlit interiors with an eat-in kitchen that flows into a spacious family room anchored by a dramatic floor-to-vaulted-ceiling 3 sided stone fireplace. Large windows and sliding doors showcase panoramic water views and lead to a generous deck with a pool, creating seamless indoor-outdoor living for everyday enjoyment or easy entertaining. The primary suite provides serene water views, private deck access, and a spa-inspired bath with an oversized soaking tub and separate shower. The exterior truly shines with 80ft of waterfront, a massive floating dock, and multiple slips, currently accommodating a 22-ft boat, a 40-ft boat, and jet skis, offering exceptional space for a variety of water toys. Additional highlights include a garage, circular driveway, manicured landscaping, and expansive windows that frame the tranquil canal setting. This rare property offers a versatile waterfront lifestyle with open views, generous indoor and outdoor spaces, and a layout ideal for relaxing, hosting, and enjoying time on the water."
+"Appliances": array:7 [ …7]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-688-3593"
+"Basement": array:1 [ …1]
+"BathroomsFull": 2
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-11-30T14:04:47.760084+00:00"
+"CumulativeDaysOnMarket": 338
+"DaysOnMarket": 125
+"Disclosures": array:2 [ …2]
+"ElementarySchool": "School 9E-Boardman Elem School"
+"ElementarySchoolDistrict": "Oceanside"
+"Exclusions": "As Per Formal Contract"
+"ExpirationDate": "2026-09-30"
+"Fencing": array:2 [ …2]
+"FireplaceFeatures": array:1 [ …1]
+"FireplacesTotal": "1"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:2 [ …2]
+"HighSchool": "School 7-Oceanside Senior Hs"
+"HighSchoolDistrict": "Oceanside"
+"InteriorFeatures": array:11 [ …11]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-688-3593"
+"ListAgentEmail": "maria4home@aol.com"
+"ListAgentKey": "326127512"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326113859"
+"ListOfficePhone": "516-688-3593"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-11-29"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:9 [ …9]
+"LotSizeAcres": 0.1837
+"LotSizeSquareFeet": 8000
+"MajorChangeTimestamp": "2026-04-17T18:05:51Z"
+"MajorChangeType": "Price Change"
+"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School"
+"MiddleOrJuniorSchoolDistrict": "Oceanside"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2025-11-30"
+"OriginalEntryTimestamp": "2025-11-30T14:00:41Z"
+"OriginalListPrice": 1249000
+"OriginatingSystemModificationTimestamp": "2026-04-19T20:08:31Z"
+"OwnerName": "Goldstein"
+"ParcelNumber": "2089-54-455-00-0025-0"
+"ParkingFeatures": array:5 [ …5]
+"ParkingTotal": "4"
+"PhotosChangeTimestamp": "2026-04-14T18:59:36Z"
+"PhotosCount": 49
+"PoolFeatures": array:2 [ …2]
+"PoolPrivateYN": true
+"PostalCity": "Oceanside"
+"PostalCodePlus4": "4328"
+"PreviousListPrice": 1249000
+"PriceChangeTimestamp": "2026-04-17T18:05:51Z"
+"RoomsTotal": "9"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "877-847-9523"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-04-13T17:40:30Z"
+"StreetName": "Ocean"
+"StreetNumber": "3452"
+"StreetNumberNumeric": "3452"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "17755.83"
+"TaxAssessedValue": 672
+"TaxYear": "2024"
+"Utilities": array:5 [ …5]
+"WaterSource": array:1 [ …1]
+"WaterfrontFeatures": array:4 [ …4]
+"WaterfrontYN": true
+"KEY_Attic": "None"
+"KEY_HoldDate": "2026-03-28"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "1199000.00"
+"KEY_OpenHouseCount": "2"
+"KEY_PreviousStatus": "Hold"
+"KEY_ElectricCompany": "PSEG"
+"KEY_NumberOfKitchens": "1"
+"KEY_OpenHouseUpcoming": "Public: Sun Apr 26, 2:30PM-4:00PM"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "Price Decrease"
+"KEY_LivingAreaSearchSqFt": "3045.00"
+"KEY_NumberOfHeatingZones": "3"
+"KEY_OpenHousePublicCount": "1"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_OpenHousePublicUpcoming": "Public: Sun Apr 26, 2:30PM-4:00PM"
+"KEY_RATIO_ListPrice_By_LivingArea": "393.76026"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6526946.1078"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "393.76026"
+"KEY_SourceSystemModificationTimestamp": "2025-11-30T08:36:02.843"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "393.76026"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.95997"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "393.76026"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422830891')"
+"provider_name": "One Key"
+"Media": array:49 [ …49]
+"ID": "29464"
}
13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5135
+post_id: "29457"
+post_author: 1
+"ListingKey": "KEY422824986"
+"ListingId": "939594"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-02-05T07:05:37Z"
+"RFModificationTimestamp": "2026-02-05T07:09:41Z"
+"ListPrice": 1250000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2420.0
+"BuildingAreaTotal": 2420.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "766 Guy Lombardo Avenue, Hempstead, New York 11520"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6330122
+"Longitude": -73.5806224
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Rachel Okul"
+"ListOfficeName": "EXIT Realty Premier"
+"ListAgentMlsId": "188386"
+"ListOfficeMlsId": "EREA02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to this spectacular, fully renovated 5-bedroom, 3.5-bath coastal contemporary located on the coveted Guy Lombardo waterfront in the wonderful Village of Freeport. No expense has been spared—every inch of this property has been thoughtfully redesigned with high-end finishes, modern craftsmanship, and exceptional attention to detail.\n
\n
\n
\n
Step inside to bright, open living spaces anchored by sleek design, large windows, and stunning water views. The home features two spacious balconies, perfect for morning coffee, entertaining, or simply enjoying the peaceful tide. With four private dock slips, this residence is a dream for boaters and waterfront lovers alike.\n
\n
\n
\n
The exterior is just as impressive, offering an AstroTurf yard for low-maintenance enjoyment year-round, plus a beautifully finished façade and generous driveway parking. Inside, the flexible layout provides an incredible opportunity for a mother-daughter setup with proper permits, ideal for extended family, guests, or multi-generational living.\n
\n
\n
\n
Located in the vibrant, highly desirable Village of Freeport—known for its waterfront lifestyle, marinas, restaurants, and convenience—this home offers luxury, comfort, and versatility all in one.\n
\n
\n
\n
Truly move-in ready and meticulously upgraded, this is waterfront living at its finest. Let the next chapter of your life begin on Guy Lombardo Avenue.
"""
+"Appliances": array:4 [ …4]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "917-767-6607"
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-244-2466"
+"BuyerAgentEmail": "jimmy.amram@elliman.com"
+"BuyerAgentFullName": "Jimmy Amram"
+"BuyerAgentKey": "326222205"
+"BuyerAgentMlsId": "213013"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326110783"
+"BuyerOfficeMlsId": "DERE58"
+"BuyerOfficeName": "Douglas Elliman Real Estate"
+"BuyerOfficePhone": "516-432-3400"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-11-28T23:15:39.600137+00:00"
+"CumulativeDaysOnMarket": 68
+"DaysOnMarket": 68
+"Directions": "GPS"
+"ElementarySchool": "Leo F Giblyn School"
+"ElementarySchoolDistrict": "Freeport"
+"ExpirationDate": "2026-11-27"
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:16 [ …16]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "917-767-6607"
+"ListAgentEmail": "rachelokul@exitpremiersells.com"
+"ListAgentKey": "326198422"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326111209"
+"ListOfficePhone": "516-795-1000"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-11-28"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.1722
+"LotSizeSquareFeet": 7500
+"MajorChangeTimestamp": "2026-02-05T02:44:41Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "John W Dodd Middle School"
+"MiddleOrJuniorSchoolDistrict": "Freeport"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-02-04"
+"OnMarketDate": "2025-11-28"
+"OriginalEntryTimestamp": "2025-11-28T23:11:28Z"
+"OriginalListPrice": 1250000
+"OriginatingSystemModificationTimestamp": "2026-02-05T02:44:41Z"
+"OwnerName": "Gammo Rudi"
+"ParcelNumber": "2009-62-102-00-0804-0"
+"ParkingFeatures": array:3 [ …3]
+"PhotosChangeTimestamp": "2025-11-28T23:12:36Z"
+"PhotosCount": 44
+"PostalCity": "Freeport"
+"PostalCodePlus4": "6213"
+"PurchaseContractDate": "2026-02-04"
+"RoomsTotal": "13"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "917-767-6607"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-02-05T02:44:41Z"
+"StreetName": "Guy Lombardo"
+"StreetNumber": "766"
+"StreetNumberNumeric": "766"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "16535.74"
+"TaxAssessedValue": 535
+"TaxYear": "2024"
+"Utilities": array:5 [ …5]
+"VirtualTourURLBranded": "https://tours.russellprattphotography.com/u/488652"
+"WaterSource": array:1 [ …1]
+"WaterfrontFeatures": array:4 [ …4]
+"WaterfrontYN": true
+"KEY_Attic": "Pull Stairs"
+"KEY_Village": "Freeport"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "1250000.00"
+"KEY_ContractPrice": "1260000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "2420.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "516.52893"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "7259001.1614"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "516.52893"
+"KEY_SourceSystemModificationTimestamp": "2025-11-28T17:14:31.117"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "516.52893"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "516.52893"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422824986')"
+"provider_name": "One Key"
+"Media": array:44 [ …44]
+"ID": "29457"
}
14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5136
+post_id: "29456"
+post_author: 1
+"ListingKey": "KEY422824842"
+"ListingId": "939587"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2026-02-18T07:03:40Z"
+"RFModificationTimestamp": "2026-02-18T07:07:51Z"
+"ListPrice": 1140000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 2347.0
+"BuildingAreaTotal": 2347.0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "60 Saint Johns Avenue, Hempstead, New York 11580"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6774275
+"Longitude": -73.7238788
+"YearBuilt": 1987
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Mohammad S. Farhad"
+"ListOfficeName": "Exit Realty Prime"
+"ListAgentMlsId": "504749"
+"ListOfficeMlsId": "MONI01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Spacious and fully renovated Hi-Ranch house located in the heart of Valley Stream. This property features beautifully updated living spaces, including 4 Bedrooms, 2 full Baths, Living/Dining, Kitchen on the second floor, and 3 Bedrooms, 2 full Baths, Living/Dining, Kitchen on the first floor. Additionally, there is a finished Basement with a separate entrance, a private Driveway, and a Garage. The current interior layout offers the possibility of easy conversion into a mother-daughter with the proper permit, making this home a versatile investment for your family's needs. Conveniently located close to Laurelton Parkway, Belt Parkway, schools, shops, and other community amenities."
+"Appliances": array:3 [ …3]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "718-262-0205"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 4
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-11-28T21:47:10.953451+00:00"
+"CumulativeDaysOnMarket": 81
+"DaysOnMarket": 81
+"ElementarySchool": "Contact Agent"
+"ElementarySchoolDistrict": "Contact Agent"
+"ExpirationDate": "2026-03-10"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Contact Agent"
+"HighSchoolDistrict": "Contact Agent"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "347-754-9760"
+"ListAgentEmail": "mf.exitny@gmail.com"
+"ListAgentKey": "421231648"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326113806"
+"ListOfficePhone": "718-262-0205"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-11-28"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.1051
+"LotSizeSquareFeet": 4576
+"MajorChangeTimestamp": "2026-02-17T22:32:04Z"
+"MajorChangeType": "Hold"
+"MiddleOrJuniorSchool": "Call Listing Agent"
+"MiddleOrJuniorSchoolDistrict": "Contact Agent"
+"MlsStatus": "Hold"
+"OffMarketDate": "2026-02-17"
+"OnMarketDate": "2025-11-28"
+"OriginalEntryTimestamp": "2025-11-28T21:45:10Z"
+"OriginalListPrice": 1200000
+"OriginatingSystemModificationTimestamp": "2026-02-17T22:32:04Z"
+"OwnerName": "60 Saint Johns Mmg Inc"
+"ParcelNumber": "2035-37-423-00-0067-0"
+"ParkingFeatures": array:2 [ …2]
+"PhotosChangeTimestamp": "2025-12-08T21:43:46Z"
+"PhotosCount": 26
+"PostalCity": "Valley Stream"
+"PostalCodePlus4": "2928"
+"PreviousListPrice": 1200000
+"PriceChangeTimestamp": "2025-12-26T19:46:43Z"
+"RoomsTotal": "15"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "3477549760"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-02-17T22:32:04Z"
+"StreetName": "Saint Johns"
+"StreetNumber": "60"
+"StreetNumberNumeric": "60"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "12278.32"
+"TaxAssessedValue": 586
+"TaxYear": "2024"
+"Utilities": array:2 [ …2]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_HoldDate": "2026-02-17"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "1140000.00"
+"KEY_OpenHouseCount": "2"
+"KEY_PreviousStatus": "Active"
+"KEY_NumberOfKitchens": "2"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Temp Off Market"
+"KEY_LivingAreaSearchSqFt": "2347.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "485.72646"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "10846812.5595"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "485.72646"
+"KEY_SourceSystemModificationTimestamp": "2025-11-28T16:45:10.163"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "485.72646"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.95000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "485.72646"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422824842')"
+"provider_name": "One Key"
+"Media": array:26 [ …26]
+"ID": "29456"
}
15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5137
+post_id: "29466"
+post_author: 1
+"ListingKey": "KEY422820238"
+"ListingId": "939468"
+"PropertyType": "Residential"
+"PropertySubType": "Stock Cooperative"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-03-01T07:07:39Z"
+"RFModificationTimestamp": "2026-03-01T07:11:27Z"
+"ListPrice": 179000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 473.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "100 S Ocean S Avenue Unit 3u, Hempstead, New York 11520"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 1958
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Salvatore Burruano CBR"
+"ListOfficeName": "American Pride Realty Inc"
+"ListAgentMlsId": "9060085"
+"ListOfficeMlsId": "APR101"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Upper floor... one of the nicest Studio units in this Building! Spacious and bright, 2 Room Co-Op unit with beautiful wood floors features a large entry foyer, large living room, updated kitchen featuring shaker style cabinets, stainless steel appliances, granite countertops and gas cooking; newer bathroom and lots of closets! Dogs are allowed with board approval! Convenient to shopping, the Long Island Railroad, and buses. It is located near the Nautical Mile, the Freeport Library and Post Office. Parking on premises $25 per month (waitlist). Free storage cage (waitlist). $4 for bike room space. With STAR exemption maintenance would be approximately $560."
+"Appliances": array:4 [ …4]
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationYN": true
+"AttributionContact": "516-546-9090"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "631-746-7704"
+"BuyerAgentEmail": "marissa@joneshollowrealty.com"
+"BuyerAgentFullName": "Marissa Disla"
+"BuyerAgentKey": "326231316"
+"BuyerAgentMlsId": "222417"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326112617"
+"BuyerOfficeMlsId": "JNSH01"
+"BuyerOfficeName": "Jones Hollow Realty Group Inc"
+"BuyerOfficePhone": "631-650-3977"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-12-01T05:44:25.317902+00:00"
+"CrossStreet": "Merrick Road"
+"CumulativeDaysOnMarket": 88
+"DaysOnMarket": 88
+"DirectionFaces": "East"
+"Directions": "Between Sunrise Hwy. and Merrick road."
+"ElementarySchool": "Columbus Avenue School"
+"ElementarySchoolDistrict": "Freeport"
+"EntryLevel": 3
+"ExpirationDate": "2026-08-31"
+"Flooring": array:1 [ …1]
+"Heating": array:1 [ …1]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:2 [ …2]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentEmail": "salvatore@americanpriderealty.com"
+"ListAgentKey": "326260223"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109443"
+"ListOfficePhone": "516-546-9090"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-12-01"
+"LivingAreaSource": "Other"
+"MajorChangeTimestamp": "2026-02-28T20:15:01Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "John W Dodd Middle School"
+"MiddleOrJuniorSchoolDistrict": "Freeport"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-02-28"
+"OnMarketDate": "2025-12-01"
+"OriginalEntryTimestamp": "2025-12-01T05:41:11Z"
+"OriginalListPrice": 179000
+"OriginatingSystemModificationTimestamp": "2026-02-28T20:15:01Z"
+"OwnerName": "Rano"
+"ParkingFeatures": array:1 [ …1]
+"PetsAllowed": array:3 [ …3]
+"PhotosChangeTimestamp": "2025-12-01T06:13:36Z"
+"PhotosCount": 19
+"PostalCity": "Freeport"
+"PurchaseContractDate": "2026-02-27"
+"RoomsTotal": "2"
+"SecurityFeatures": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "855-293-3591"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-02-28T20:15:01Z"
+"StoriesTotal": "4"
+"StreetDirPrefix": "S"
+"StreetDirSuffix": "S"
+"StreetName": "Ocean"
+"StreetNumber": "100"
+"StreetNumberNumeric": "100"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"UnitNumber": "3U"
+"Utilities": array:5 [ …5]
+"WaterSource": array:1 [ …1]
+"KEY_ParkingFee": "25"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "179000.00"
+"KEY_ContractPrice": "179000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_PreviousStatus": "Active"
+"KEY_DistanceToTrain": "0.25"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_ApprovalRequiredYN": "1"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_EstimatedMaintenance": "558"
+"KEY_LivingAreaSearchSqFt": "473.00"
+"KEY_ShowingContactPhone2": "516-546-9090"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_MinimumPctDownPayment": "10"
+"KEY_RATIO_ListPrice_By_LivingArea": "378.43552"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "378.43552"
+"KEY_SourceSystemModificationTimestamp": "2025-11-27T15:19:05.533"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422820238')"
+"provider_name": "One Key"
+"Media": array:19 [ …19]
+"ID": "29466"
}
16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5138
+post_id: "29452"
+post_author: 1
+"ListingKey": "KEY422818684"
+"ListingId": "939438"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Mixed Use"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-02-21T03:27:36Z"
+"RFModificationTimestamp": "2026-02-21T03:33:12Z"
+"ListPrice": 799999.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 3890.0
+"LivingArea": 0
+"BuildingAreaTotal": 5550.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "69 S Main Street, Hempstead, New York 11520"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.7085599
+"Longitude": -73.6248063
+"YearBuilt": 1903
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Demetrios Droggitis"
+"ListOfficeName": "Century Homes Realty Group LLC"
+"ListAgentMlsId": "135729"
+"ListOfficeMlsId": "DAER01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Prime commercial opportunity in the heart of Freeport! this versatile property offers excellent visibility, strong foot/vehicle traffic, and close proximity to public transportation. Flexible layout, great street frontage, and positioned within a growing commercial district. Perfect for investors seeking a high-exposure location."
+"AttributionContact": "718-886-6800"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"BusinessType": "Commercial,Mixed,Professional Service,Professional/Office,Restaurant,Retail"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "631-747-7814"
+"CoListAgentEmail": "jessfarez@gmail.com"
+"CoListAgentFullName": "Jessica B. Rivera"
+"CoListAgentKey": "326210640"
+"CoListAgentMlsId": "201129"
+"CoListOfficeKey": "326110648"
+"CoListOfficeMlsId": "DAER01"
+"CoListOfficeName": "Century Homes Realty Group LLC"
+"CoListOfficePhone": "718-886-6800"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-11-27T05:24:36.879577+00:00"
+"CumulativeDaysOnMarket": 85
+"DaysOnMarket": 144
+"ExpirationDate": "2026-05-31"
+"Heating": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "718-886-6800"
+"ListAgentEmail": "Demetrios.d@live.com"
+"ListAgentKey": "326149502"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110648"
+"ListOfficePhone": "718-886-6800"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-11-26"
+"LotSizeAcres": 0.0893
+"LotSizeSquareFeet": 3890
+"MajorChangeTimestamp": "2026-02-21T03:26:14Z"
+"MajorChangeType": "Price Change"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2025-11-27"
+"OriginalEntryTimestamp": "2025-11-27T05:21:03Z"
+"OriginalListPrice": 979000
+"OriginatingSystemModificationTimestamp": "2026-02-21T03:26:14Z"
+"OwnerName": "Riverside South Realty Corp"
+"ParcelNumber": "2009-55-205-00-0129-0"
+"PhotosChangeTimestamp": "2025-12-09T00:24:50Z"
+"PhotosCount": 15
+"PostalCity": "Freeport"
+"PostalCodePlus4": "3871"
+"PreviousListPrice": 979000
+"PriceChangeTimestamp": "2026-02-21T03:26:14Z"
+"PropertyAttachedYN": true
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "646-773-0763"
+"ShowingRequirements": array:3 [ …3]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-11-27T05:21:03Z"
+"StreetDirPrefix": "S"
+"StreetName": "Main"
+"StreetNumber": "69"
+"StreetNumberNumeric": "69"
+"StreetSuffix": "Street"
+"SyndicateTo": array:3 [ …3]
+"TaxAnnualAmount": "17626.73"
+"TaxAssessedValue": 4821
+"TaxYear": "2024"
+"Utilities": array:4 [ …4]
+"WaterSource": array:1 [ …1]
+"KEY_CurrentPrice": "799999.00"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "Price Decrease"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "8958555.4311"
+"KEY_SourceSystemModificationTimestamp": "2025-11-27T00:21:03.950"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "144.14396"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.81716"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "144.14396"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422818684')"
+"provider_name": "One Key"
+"Media": array:15 [ …15]
+"ID": "29452"
}
17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5139
+post_id: "29451"
+post_author: 1
+"ListingKey": "KEY422816905"
+"ListingId": "939389"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T10:01:41Z"
+"RFModificationTimestamp": "2025-11-27T10:03:32Z"
+"ListPrice": 1299999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3500.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "87 Sobro Avenue, Hempstead, New York 11580"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6800066
+"Longitude": -73.7199709
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Hassan Z. Shah"
+"ListOfficeName": "Blackstone Realty"
+"ListAgentMlsId": "210090"
+"ListOfficeMlsId": "RCHB01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to 87 Sobro Avenue – A Home That Speaks to the Heart.\n
Set on a sun-soaked, south-facing corner lot in North Valley Stream, this one-of-a-kind newly built colonial is where light, space, and soul come together. With 5 spacious bedrooms, 3.5 elegant baths, and over 3,500 sq ft of beautifully finished living space, every detail invites comfort and connection. The chef’s kitchen—designed with floor-to-ceiling cabinetry and high-end appliances—is the true heart of the home. Upstairs, the tranquil primary suite offers a spa-inspired bath and custom walk-in closet—a peaceful escape from the everyday. Below it all lies a rare bonus: a fully finished, soundproof basement featuring 9-ft ceilings, hardwood floors, and a full bathroom—ideal for entertaining, extended stays, or multi-generational living. Even better, the owner is willing to add a private outside entrance, offering incredible flexibility for future use. Moments from LIRR, shopping, schools, and major highways—this is more than a house.\n
It’s a forever home, filled with light, love, and limitless possibility.
"""
+"Appliances": array:5 [ …5]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-802-3939"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-11-26T22:38:30.872249+00:00"
+"CumulativeDaysOnMarket": 1
+"DaysOnMarket": 145
+"ElementarySchool": "Clearstream Avenue School"
+"ElementarySchoolDistrict": "Valley Stream - 30"
+"ExpirationDate": "2026-11-26"
+"Flooring": array:2 [ …2]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:2 [ …2]
+"HighSchool": "Valley Stream North High School"
+"HighSchoolDistrict": "Valley Stream Central"
+"InteriorFeatures": array:17 [ …17]
+"RFTransactionType": "For Sale"
…66
}
18 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5140 …145}
19 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5141 …134}
20 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5142 …157}
21 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5143 …156}
22 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5144 …148}
23 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5146 …146}
24 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5115 …130}
25 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5114 …137}
26 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5113 …121}
27 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5112 …121}
28 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5111 …155}
29 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5110 …155}
30 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5109 …176}
31 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5108 …135}
32 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5107 …144}
33 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5106 …146}
34 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5105 …134}
35 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5104 …144}
36 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5103 …158}
37 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5102 …135}
38 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5101 …129}
39 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5100 …133}
40 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5099 …155}
41 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5098 …150}
42 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5097 …160}
43 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5096 …160}
44 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5095 …140}
45 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5094 …150}
46 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5093 …188}
47 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5092 …142}
48 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5091 …127}
49 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5090 …132}
50 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5089 …130}
51 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5088 …133}
52 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5087 …121}
53 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5086 …157}
54 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5085 …122}
55 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5084 …138}
56 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5083 …96}
57 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5082 …109}
58 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5081 …147}
59 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5080 …144}
]
+success: true
+page_size: 60
+page_count: 32
+count: 1920
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
]
