array:3 [
"RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=6&$skip=738&$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 {#4712
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4713
+post_id: "30899"
+post_author: 1
+"ListingKey": "KEY424354256"
+"ListingId": "984499"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-06-19T07:07:37Z"
+"RFModificationTimestamp": "2026-06-19T07:11:59Z"
+"ListPrice": 479000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 544.0
+"BuildingAreaTotal": 544.0
+"City": "Hempstead"
+"PostalCode": "11518"
+"UnparsedAddress": "27 Edwin Court, Hempstead, New York 11518"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6367697
+"Longitude": -73.6700375
+"YearBuilt": 1925
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Judy Hendrickson"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "214501"
+"ListOfficeMlsId": "DERE23"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to 27 Edwin Court. A charming bungalow set on a rare double lot. This renovated home offers an open layout, one bedroom, one full bathroom, and a modern kitchen complete with stainless steel appliances, along with the convenience of a stackable washer and dryer tucked away out of site. The lower level provides excellent storage, adding valuable functionality.\n
Other recent upgrades include new baseboard heating, ductless mini split unit, a tankless water heater, roof, and spray foam insulation—ensuring efficiency and peace of mind. Enjoy low-maintenance living with modern amenities, complemented by the added outdoor space of the double lot. Ideally located near local amenities, parks, transportation, and the waterfront, this move-in ready home presents a wonderful opportunity to own in East Rockaway. **Home was elevated in 2018** No village tax.
"""
+"Appliances": array:1 [ …1]
+"ArchitecturalStyle": array:2 [ …2]
+"AttributionContact": "516-354-6500"
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-361-1680"
+"BuyerAgentEmail": "danielmurphy@cbamhomes.com"
+"BuyerAgentFullName": "Daniel J. Murphy"
+"BuyerAgentKey": "326255944"
+"BuyerAgentMlsId": "9028880"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326109956"
+"BuyerOfficeMlsId": "BRMN25"
+"BuyerOfficeName": "Coldwell Banker American Homes"
+"BuyerOfficePhone": "516-798-4100"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-04-19T17:05:23.148235+00:00"
+"CrossStreet": "Lawson Ave."
+"CumulativeDaysOnMarket": 59
+"DaysOnMarket": 59
+"Directions": "Lawson Ave to Edwin Ct."
+"ElementarySchool": "Rhame Avenue Elementary School"
+"ElementarySchoolDistrict": "East Rockaway"
+"ExpirationDate": "2026-08-11"
+"Heating": array:2 [ …2]
+"HighSchool": "East Rockaway Junior-Senior High Sch"
+"HighSchoolDistrict": "East Rockaway"
+"InteriorFeatures": array:2 [ …2]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-427-0866"
+"ListAgentEmail": "judy.hendrickson@elliman.com"
+"ListAgentKey": "326223651"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110763"
+"ListOfficePhone": "516-354-6500"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-04-11"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.0379
+"LotSizeDimensions": "60x55"
+"LotSizeSquareFeet": 3300
+"MajorChangeTimestamp": "2026-06-18T13:51:52Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "East Rockaway Junior-Senior High Sch"
+"MiddleOrJuniorSchoolDistrict": "East Rockaway"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-06-18"
+"OnMarketDate": "2026-04-19"
+"OriginalEntryTimestamp": "2026-04-19T17:01:54Z"
+"OriginalListPrice": 479000
+"OriginatingSystemModificationTimestamp": "2026-06-18T13:51:52Z"
+"OwnerName": "Nancy A Snow"
+"ParcelNumber": "2089-42-022-00-0014-0"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-18T19:39:38Z"
+"PhotosCount": 12
+"PostalCity": "East Rockaway"
+"PostalCodePlus4": "2306"
+"PurchaseContractDate": "2026-06-17"
+"RoomsTotal": "4"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-354-6500"
+"ShowingRequirements": array:3 [ …3]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-06-18T13:51:52Z"
+"StreetName": "Edwin"
+"StreetNumber": "27"
+"StreetNumberNumeric": "27"
+"StreetSuffix": "Court"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "6578.48"
+"TaxYear": "2026"
+"Utilities": array:2 [ …2]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Storage"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "479000.00"
+"KEY_ContractPrice": "450000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_BuyerRepresentation": "Buyer's Agent"
+"KEY_LivingAreaSearchSqFt": "544.00"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "880.51471"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "12638522.4274"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "880.51471"
+"KEY_SourceSystemModificationTimestamp": "2026-04-13T15:05:48.133"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "880.51471"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "880.51471"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424354256')"
+"provider_name": "One Key"
+"Media": array:12 [ …12]
+"ID": "30899"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5272
+post_id: "31222"
+post_author: 1
+"ListingKey": "KEY424354082"
+"ListingId": "984492"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T18:20:36Z"
+"RFModificationTimestamp": "2026-06-16T18:26:30Z"
+"ListPrice": 998000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 1826.0
+"BuildingAreaTotal": 1826.0
+"City": "Hempstead"
+"PostalCode": "11563"
+"UnparsedAddress": "126 Scranton Avenue, Hempstead, New York 11563"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.655805
+"Longitude": -73.6857866
+"YearBuilt": 1950
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Ruth Chalco"
+"ListOfficeName": "Compass Greater NY LLC"
+"ListAgentMlsId": "9031767"
+"ListOfficeMlsId": "CMPA07"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Brick and Sided Legal Two Family Home -Each level has 3 Bedrooms, Lr, Eik, & Updated Bath. Home has 2 Electric Meters, Driveway, Full, Finished Basement, and Yard."
+"Appliances": array:2 [ …2]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "718-809-8671"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-05-11T19:40:40.125107+00:00"
+"CrossStreet": "Bixley Heath"
+"CumulativeDaysOnMarket": 36
+"DaysOnMarket": 49
+"ElementarySchool": "William L Buck School"
+"ElementarySchoolDistrict": "Valley Stream - 24"
+"ExpirationDate": "2026-10-13"
+"Heating": array:3 [ …3]
+"HighSchool": "Valley Stream South High School"
+"HighSchoolDistrict": "Valley Stream Central"
+"InteriorFeatures": array:2 [ …2]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "718-809-8671"
+"ListAgentEmail": "ruth.chalco@compass.com"
+"ListAgentKey": "326257094"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110404"
+"ListOfficePhone": "516-764-6060"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-04-13"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1217
+"LotSizeSquareFeet": 5300
+"MajorChangeTimestamp": "2026-06-16T18:18:38Z"
+"MajorChangeType": "Price Change"
+"MiddleOrJuniorSchool": "Valley Stream Memorial Junior High School"
+"MiddleOrJuniorSchoolDistrict": "Valley Stream Central"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-05-11"
+"OriginalEntryTimestamp": "2026-05-11T19:32:32Z"
+"OriginalListPrice": 1050000
+"OriginatingSystemModificationTimestamp": "2026-06-16T18:18:38Z"
+"OwnerName": "Isabel Arevalo"
+"ParcelNumber": "2025-42-172-00-0050-0"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-05-05T16:17:36Z"
+"PhotosCount": 23
+"PostalCity": "Lynbrook"
+"PostalCodePlus4": "2813"
+"PreviousListPrice": 1050000
+"PriceChangeTimestamp": "2026-06-16T18:18:38Z"
+"RoomsTotal": "9"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "(718) 809-8671"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-11T19:32:32Z"
+"StreetName": "Scranton"
+"StreetNumber": "126"
+"StreetNumberNumeric": "126"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "8325.37"
+"TaxAssessedValue": 537
+"TaxYear": "2024"
+"Utilities": array:4 [ …4]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "998000.00"
+"KEY_OpenHouseCount": "2"
+"KEY_ElectricCompany": "PSEG"
+"KEY_NumberOfKitchens": "2"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "Price Decrease"
+"KEY_LivingAreaSearchSqFt": "1826.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "546.54984"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "8200493.0156"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "546.54984"
+"KEY_SourceSystemModificationTimestamp": "2026-04-13T15:00:59.740"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "546.54984"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.95048"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "546.54984"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424354082')"
+"provider_name": "One Key"
+"Media": array:23 [ …23]
+"ID": "31222"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4784
+post_id: "30927"
+post_author: 1
+"ListingKey": "KEY424353537"
+"ListingId": "984469"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-07T16:39:37Z"
+"RFModificationTimestamp": "2026-06-07T16:45:08Z"
+"ListPrice": 989000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2064.0
+"BuildingAreaTotal": 2064.0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "2038 Ripley Lane, Hempstead, New York 11566"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.657415
+"Longitude": -73.548648
+"YearBuilt": 1961
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Elaine Richheimer"
+"ListOfficeName": "Douglas Elliman Real Estate"
+"ListAgentMlsId": "174177"
+"ListOfficeMlsId": "DERE28"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to 2038 Ripley Lane, a stunning split-level home nestled in the heart of the Lindenmere section of Merrick in a wonderful cul-de-sac location. This home offers an inviting blend of comfort, style, and convenience, perfect for those who appreciate quality living.\n
Boasting four spacious bedrooms and three bathrooms, this home is designed to accommodate a variety of living arrangements. The primary\n
bedroom features an en-suite bathroom for added privacy and convenience. The additional three bedrooms offer ample space and versatility to meet your unique needs. Home has solar panels and central air . The heart of the home, the kitchen, has been updated with sleek granite countertops and is perfectly suited for both everyday living and entertaining. The formal dining room adjacent to the kitchen creates an ideal setting for hosting gatherings and creating lasting memories. The expansive living room, complemented by a den with a vaulted ceiling provides a welcoming atmosphere for relaxation and entertainment. Throughout the home, beautiful hardwood floors add a touch of elegance and warmth.\n
Venture downstairs to a roomy basement, a versatile space that can be tailored to your lifestyle. Whether you need a home office, a workout room, or a play area, this space is ready to accommodate your needs. Enjoy those warm days in your backyard for spending time to relax or to soak up the sun.\n
The location offers a sense of community and tranquility. Nearby, you will find a variety of shopping and dining options to explore. For those who commute, transportation is conveniently close, making your daily journey that much easier. Trains go to Penn Station and Grand Central and beautiful beaches are just one exit away !\n
Don't miss this unique opportunity to own a piece of Merrick's charm. This home offers a blend of style, convenience and comfort. Won't last! Enjoy the lifestyle Merrick has to offer! Must See!
"""
+"Appliances": array:8 [ …8]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-623-4500"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:3 [ …3]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-04-21T20:55:30.613894+00:00"
+"CrossStreet": "Merrick Avenue"
+"CumulativeDaysOnMarket": 47
+"DaysOnMarket": 69
+"ElementarySchool": "Birch School"
+"ElementarySchoolDistrict": "Merrick"
+"Exclusions": "To Be Determined"
+"ExpirationDate": "2026-10-13"
+"Flooring": array:2 [ …2]
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Sanford H Calhoun High School"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"InteriorFeatures": array:5 [ …5]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-721-8316"
+"ListAgentEmail": "Elaine.Richheimer@elliman.com"
+"ListAgentKey": "326185145"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110766"
+"ListOfficePhone": "516-623-4500"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-04-13"
+"ListingTerms": "Contract"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1519
+"LotSizeSquareFeet": 6615
+"MajorChangeTimestamp": "2026-04-21T20:48:49Z"
+"MiddleOrJuniorSchool": "Merrick Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-04-21"
+"OriginalEntryTimestamp": "2026-04-21T20:48:49Z"
+"OriginalListPrice": 989000
+"OriginatingSystemModificationTimestamp": "2026-06-07T16:38:17Z"
+"OwnerName": "David & Melva Novak"
+"ParcelNumber": "2089-56-176-00-0222-0"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-22T20:18:36Z"
+"PhotosCount": 22
+"PostalCity": "Merrick"
+"PostalCodePlus4": "3929"
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-623-4500"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-04-21T20:48:49Z"
+"StreetName": "Ripley"
+"StreetNumber": "2038"
+"StreetNumberNumeric": "2038"
+"StreetSuffix": "Lane"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "21471.76"
+"TaxAssessedValue": 690
+"TaxBlock": "176"
+"TaxLot": "222"
+"TaxYear": "2024"
+"Utilities": array:5 [ …5]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Crawl"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "56"
+"KEY_CurrentPrice": "989000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_SolarOwnership": "Owned"
+"KEY_IncludedInTaxes": "Sewer,Trash"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_LivingAreaSearchSqFt": "2064.00"
+"KEY_NumberOfHeatingZones": "3"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "479.16667"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6510862.4095"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "479.16667"
+"KEY_SourceSystemModificationTimestamp": "2026-04-13T14:43:24.740"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "479.16667"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "479.16667"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424353537')"
+"provider_name": "One Key"
+"Media": array:22 [ …22]
+"ID": "30927"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4785
+post_id: "30797"
+post_author: 1
+"ListingKey": "KEY424350252"
+"ListingId": "984381"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-23T18:39:37Z"
+"RFModificationTimestamp": "2026-05-23T18:42:06Z"
+"ListPrice": 1048000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3834.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11572"
+"UnparsedAddress": "3420 Woodward Street, Hempstead, New York 11572"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.632263
+"Longitude": -73.621761
+"YearBuilt": 1954
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Roman Nissim"
+"ListOfficeName": "Keystone Realty USA Corp"
+"ListAgentMlsId": "193301"
+"ListOfficeMlsId": "KEEG02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to the spacious split-level House in Oceanside located between two channels of water with constant breeze. This meticulously maintain expanded split is complimented by beautiful hardwood floors on main and second levels. Enjoy Huge Cathedral Ceiling Living Room with Fireplace, Spacious Dining Room and Den Room. Top Level features Office and Family Room. Four Big Bedrooms and Two and a Half Bath. The bright and refreshing Eat-In-Kitchen features contemporary, oversized wood cabinets and granite counter tops equipped with high-end stainless-steel appliances with access to a Large Backyard for Gardening, Entertaining and enjoying long summer days. Enjoy your Own Boat Dock, jet ski and any other waterfront activity you can think of right from your backyard! Located on one of Oceanside premier waterfront blocks, 3420 Woodward Street is not a property to be missed.\n
This "PRICED TO SELL" House can be yours today!\n
Sellers are very motivated. ALL OFFERS WILL BE CONSIDERED. Less expensive than renting.
"""
+"Appliances": array:6 [ …6]
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationAmenities": "Park"
+"AttributionContact": "631-261-2800"
+"Basement": array:3 [ …3]
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"CarportSpaces": "2"
+"CarportYN": true
+"ConstructionMaterials": array:3 [ …3]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-04-13T17:35:37.116796+00:00"
+"CrossStreet": "Freeman Ave"
+"CumulativeDaysOnMarket": 40
+"DaysOnMarket": 77
+"ElementarySchool": "School 4"
+"ElementarySchoolDistrict": "Oceanside"
+"ExpirationDate": "2026-10-31"
+"ExteriorFeatures": array:3 [ …3]
+"Fencing": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [ …2]
+"Heating": array:2 [ …2]
+"HighSchool": "School 7-Oceanside Senior Hs"
+"HighSchoolDistrict": "Oceanside"
+"InteriorFeatures": array:7 [ …7]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "917-215-1944"
+"ListAgentEmail": "romeonis@gmail.com"
+"ListAgentKey": "326203093"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326112838"
+"ListOfficePhone": "631-261-2800"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-04-12"
+"LivingAreaSource": "Other"
+"LotFeatures": array:4 [ …4]
+"LotSizeAcres": 0.19
+"LotSizeDimensions": "65x125"
+"LotSizeSquareFeet": 8125
+"MajorChangeTimestamp": "2026-04-13T17:28:48Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School"
+"MiddleOrJuniorSchoolDistrict": "Oceanside"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-04-13"
+"OriginalEntryTimestamp": "2026-04-13T17:28:48Z"
+"OriginalListPrice": 1048000
+"OriginatingSystemModificationTimestamp": "2026-05-23T18:38:16Z"
+"OwnerName": "Goldin Trust"
+"ParcelNumber": "2089-54-354-00-0051-0"
+"ParkingFeatures": array:3 [ …3]
+"PatioAndPorchFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-13T17:30:36Z"
+"PhotosCount": 25
+"PostalCity": "Oceanside"
+"PriceChangeTimestamp": "2026-04-13T17:28:48Z"
+"RoomsTotal": "10"
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:3 [ …3]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-04-13T17:28:48Z"
+"StreetName": "Woodward"
+"StreetNumber": "3420"
+"StreetNumberNumeric": "3420"
+"StreetSuffix": "Street"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "23761"
+"TaxBlock": "354"
+"TaxLot": "51"
+"TaxYear": "2024"
+"Utilities": array:1 [ …1]
+"View": "Water"
+"WaterSource": array:1 [ …1]
+"WaterfrontFeatures": array:3 [ …3]
+"WaterfrontYN": true
+"WindowFeatures": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_TaxSource": "Other"
+"KEY_TaxSection": "54"
+"KEY_CurrentPrice": "1048000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_IncludedInTaxes": "Sewer,Trash"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_LivingAreaSearchSqFt": "3834.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "273.34377"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "5515789.4737"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "273.34377"
+"KEY_SourceSystemModificationTimestamp": "2026-04-13T13:28:48.300"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424350252')"
+"provider_name": "One Key"
+"Media": array:25 [ …25]
+"ID": "30797"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4747
+post_id: "30862"
+post_author: 1
+"ListingKey": "KEY424348026"
+"ListingId": "984304"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2026-06-10T07:06:40Z"
+"RFModificationTimestamp": "2026-06-10T07:08:59Z"
+"ListPrice": 749000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1446.0
+"BuildingAreaTotal": 1446.0
+"City": "Hempstead"
+"PostalCode": "11572"
+"UnparsedAddress": "404 Foxdale Avenue, Hempstead, New York 11572"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6445689
+"Longitude": -73.6248209
+"YearBuilt": 1950
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Perry Pappas"
+"ListOfficeName": "Signature Premier Properties"
+"ListAgentMlsId": "174216"
+"ListOfficeMlsId": "SPH15"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Introducing 404 Foxdale Ave - Welcome to this beautifully reimagined 4-bedroom, 2-bath Cape set on a prime 7,410 sq ft corner property in a highly desirable location near Silver Lake Park and the elementary school. Thoughtfully updated and filled with natural light, this home offers the perfect balance of timeless design and modern living. The main level showcases an airy, open-concept layout designed for both everyday comfort and seamless entertaining. Sunlight pours through the space, highlighting sleek new tile flooring and creating a bright, inviting atmosphere throughout. At the center of the home is a stunning, fully updated kitchen featuring a spacious center island, clean modern finishes, and abundant workspace—ideal for cooking, gathering, and entertaining with ease. All four bedrooms are well-proportioned, offering versatility for guests, or a dedicated home office. The two fully renovated bathrooms are designed with a refined, contemporary aesthetic, delivering a spa-like feel with elevated finishes. A full, freshly painted and waterproofed basement provides exceptional bonus space with endless potential—perfect for a recreation area, gym, or additional living space. Set on an expansive corner lot, the outdoor space offers privacy and flexibility for entertaining, relaxing, or future enhancements. With its prime location close to parks, schools, shopping, and transportation, this home delivers both lifestyle and convenience. Move-in ready and thoughtfully updated throughout, this is a rare opportunity to own a turn-key home in a sought-after neighborhood."
+"Appliances": array:1 [ …1]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-766-7900"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-460-2103"
+"CoListAgentEmail": "enzocaronna135@gmail.com"
+"CoListAgentFullName": "Enzo Caronna"
+"CoListAgentKey": "422929208"
+"CoListAgentMlsId": "505822"
+"CoListOfficeKey": "326115723"
+"CoListOfficeMlsId": "SPH15"
+"CoListOfficeName": "Signature Premier Properties"
+"CoListOfficePhone": "516-766-7900"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-04-16T13:49:02.602374+00:00"
+"CumulativeDaysOnMarket": 54
+"DaysOnMarket": 54
+"ElementarySchool": "School 3"
+"ElementarySchoolDistrict": "Oceanside"
+"ExpirationDate": "2026-10-31"
+"Heating": array:2 [ …2]
+"HighSchool": "School 7-Oceanside Senior Hs"
+"HighSchoolDistrict": "Oceanside"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-766-7900"
+"ListAgentEmail": "perrpapp@gmail.com"
+"ListAgentKey": "326185183"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115723"
+"ListOfficePhone": "516-766-7900"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-04-16"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1701
+"LotSizeSquareFeet": 7410
+"MajorChangeTimestamp": "2026-06-09T12:37:02Z"
+"MajorChangeType": "Hold"
+"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School"
+"MiddleOrJuniorSchoolDistrict": "Oceanside"
+"MlgCanUse": array:3 [ …3]
+"MlsStatus": "Hold"
+"OffMarketDate": "2026-06-09"
+"OnMarketDate": "2026-04-16"
+"OriginalEntryTimestamp": "2026-04-16T13:43:10Z"
+"OriginalListPrice": 749000
+"OriginatingSystemModificationTimestamp": "2026-06-09T12:37:02Z"
+"OwnerName": "Singh"
+"ParcelNumber": "2089-54-503-00-0008-0"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-23T18:56:36Z"
+"PhotosCount": 31
+"PostalCity": "Oceanside"
+"PostalCodePlus4": "2524"
+"RoomsTotal": "7"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-460-2103"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-06-09T12:37:02Z"
+"StreetName": "Foxdale"
+"StreetNumber": "404"
+"StreetNumberNumeric": "404"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "12916"
+"TaxAssessedValue": 473
+"TaxYear": "2024"
+"Utilities": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Partial"
+"KEY_HoldDate": "2026-06-09"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "749000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Temp Off Market"
+"KEY_LivingAreaSearchSqFt": "1446.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "517.98064"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "4403292.1811"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "517.98064"
+"KEY_SourceSystemModificationTimestamp": "2026-04-13T12:18:21.870"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "517.98064"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "517.98064"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424348026')"
+"provider_name": "One Key"
+"Media": array:31 [ …31]
+"ID": "30862"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4748
+post_id: "30794"
+post_author: 1
+"ListingKey": "KEY424347048"
+"ListingId": "984281"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-29T07:13:37Z"
+"RFModificationTimestamp": "2026-05-29T07:15:43Z"
+"ListPrice": 1275000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1305.0
+"BuildingAreaTotal": 1305.0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "16 Felton Avenue, Hempstead, New York 11580"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6713875
+"Longitude": -73.7073324
+"YearBuilt": 1936
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Ankush Pal"
+"ListOfficeName": "PB RE Group Corp"
+"ListAgentMlsId": "196422"
+"ListOfficeMlsId": "PLBR01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to an exceptional, fully renovated residence in the heart of Valley Stream, offering a rare combination of modern upgrades and expansive land. Set on an oversized 15,000 sq. ft. lot (approx. 80 x 190), this property stands out as one of the few remaining large parcels in the area—perfect for homeowners, investors, or those seeking future potential.\n
\n
This beautifully updated home features 3 generously sized bedrooms and 2.5 bathrooms, highlighted by a luxurious primary suite with a spacious, spa-like bath. The interior showcases brand-new wood flooring throughout, a sleek modern kitchen with updated appliances, stylish tile finishes, and abundant closet and storage space designed for comfortable living.\n
\n
Step outside to a private, fully fenced backyard with a large patio—ideal for entertaining, relaxing, or hosting gatherings. The property also offers unmatched parking capacity for 20+ vehicles, a massive two-car garage, and a separate outside entrance (OSE) to the basement, providing added flexibility and convenience.\n
\n
Ideally located just off N. Central Ave on Felton Avenue, you’re minutes from shopping, dining, schools, and major transportation routes. With possible subdivision potential (with proper permits) or the opportunity to create a custom estate, this property delivers both immediate enjoyment and long-term value.\n
\n
A truly unique offering with endless possibilities—don’t miss your chance to make it yours!
"""
+"Appliances": array:9 [ …9]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-254-7777"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"CarportSpaces": "2"
+"CarportYN": true
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-494-7777"
+"CoListAgentEmail": "ravipal17@gmail.com"
+"CoListAgentFullName": "Ravi Pal"
+"CoListAgentKey": "326207453"
+"CoListAgentMlsId": "197851"
+"CoListOfficeKey": "326114551"
+"CoListOfficeMlsId": "PLBR01"
+"CoListOfficeName": "PB RE Group Corp"
+"CoListOfficePhone": "516-254-7777"
+"ConstructionMaterials": array:3 [ …3]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-04-13T15:52:43.374355+00:00"
+"CrossStreet": "North Central Ave"
+"CumulativeDaysOnMarket": 318
+"DaysOnMarket": 77
+"Directions": "From the Southern State Parkway take Exit 13N for Central Ave toward Valley Stream. Proceed north on Central Ave for approximately 1–1.5 miles, then turn right onto Felton Ave. Continue down the block to #16, which will be on the street."
+"ElementarySchool": "Shaw Avenue School"
+"ElementarySchoolDistrict": "Valley Stream - 30"
+"ExpirationDate": "2026-07-15"
+"FireplaceYN": true
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Valley Stream Central High School"
+"HighSchoolDistrict": "Valley Stream Central"
+"InteriorFeatures": array:2 [ …2]
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-254-7777"
+"ListAgentEmail": "ankushpal1998@gmail.com"
+"ListAgentKey": "326206107"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326114551"
+"ListOfficePhone": "516-254-7777"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-04-13"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.3444
+"LotSizeDimensions": "80x190"
+"LotSizeSquareFeet": 15000
+"MajorChangeTimestamp": "2026-05-28T17:01:26Z"
+"MajorChangeType": "Back On Market"
+"MiddleOrJuniorSchool": "Valley Stream Memorial Junior High School"
+"MiddleOrJuniorSchoolDistrict": "Valley Stream Central"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-04-13"
+"OriginalEntryTimestamp": "2026-04-13T15:50:23Z"
+"OriginalListPrice": 1275000
+"OriginatingSystemModificationTimestamp": "2026-05-28T17:01:26Z"
+"OwnerName": "Roda"
+"ParcelNumber": "2035-37-191-00-0157-0"
+"ParkingFeatures": array:4 [ …4]
+"PhotosChangeTimestamp": "2026-04-13T15:51:36Z"
+"PhotosCount": 32
+"PostalCity": "Valley Stream"
+"PostalCodePlus4": "3902"
+"PriceChangeTimestamp": "2026-04-13T15:50:23Z"
+"PropertyCondition": array:1 [ …1]
+"RoomsTotal": "12"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "5162547777"
+"ShowingRequirements": array:5 [ …5]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-28T17:01:26Z"
+"StreetName": "Felton"
+"StreetNumber": "16"
+"StreetNumberNumeric": "16"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "11392"
+"TaxAssessedValue": 329
+"TaxYear": "2024"
+"Utilities": array:7 [ …7]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_HoldDate": "2026-05-28"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "1275000.00"
+"KEY_OpenHouseCount": "2"
+"KEY_PreviousStatus": "Hold"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "Back On Market"
+"KEY_LivingAreaSearchSqFt": "1305.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "5164947777"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "977.01149"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "3702090.5923"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "977.01149"
+"KEY_SourceSystemModificationTimestamp": "2026-04-13T11:50:23.093"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "977.01149"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "977.01149"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424347048')"
+"provider_name": "One Key"
+"Media": array:32 [ …32]
+"ID": "30794"
}
]
+success: true
+page_size: 6
+page_count: 373
+count: 2238
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=6&$skip=738&$filter=(StandardStatus in ('Active','Pending','Coming Soon','Hold','Expired') and ( City in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst') or PostalCity in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst','Lawrence')) and ListPrice le 5000000) and (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential'&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5271
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5254
+post_id: "30633"
+post_author: 1
+"ListingKey": "KEY424107567"
+"ListingId": "977465"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-05-03T07:12:39Z"
+"RFModificationTimestamp": "2026-05-03T07:14:57Z"
+"ListPrice": 829000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1728.0
+"BuildingAreaTotal": 1818.0
+"City": "Hempstead"
+"PostalCode": "11518"
+"UnparsedAddress": "18 Phipps Avenue, Hempstead, New York 11518"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6435337
+"Longitude": -73.6642197
+"YearBuilt": 1926
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Brianna Raleigh"
+"ListOfficeName": "Coldwell Banker American Homes"
+"ListAgentMlsId": "179342"
+"ListOfficeMlsId": "BRMN12"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "This stunning 3 Bedroom Colonial features a large updated eat in kitchen with quartzite countertops and stainless steel appliances, living room with a fireplace, formal dining room, sunroom/office, 1.5 baths, and a master bedroom with a balcony. There is a full basement, full pull down attic for storage, gas heating, central air conditioning and In ground Sprinklers. This home has an oversized 55x200 lot with long driveway and 2 car garage that has an attached shed with beautiful barnyard doors and an outdoor patio. Close proximity to LIRR, Parks, Shops, Restaurants & much more."
+"Appliances": array:9 [ …9]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-825-6511"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-967-5048"
+"BuyerAgentEmail": "clara.valderrama@elliman.com"
+"BuyerAgentFullName": "Clara Valderrama"
+"BuyerAgentKey": "326133893"
+"BuyerAgentMlsId": "11843"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326110785"
+"BuyerOfficeMlsId": "DERE61"
+"BuyerOfficeName": "Douglas Elliman Real Estate"
+"BuyerOfficePhone": "516-746-0440"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-04-01T14:18:58.504792+00:00"
+"CrossStreet": "Atlantic Ave"
+"CumulativeDaysOnMarket": 30
+"DaysOnMarket": 30
+"Directions": "Use GPS"
+"ElementarySchool": "Centre Avenue Elementary School"
+"ElementarySchoolDistrict": "East Rockaway"
+"ExpirationDate": "2026-10-01"
+"ExteriorFeatures": array:1 [ …1]
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [ …1]
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "East Rockaway Junior-Senior High Sch"
+"HighSchoolDistrict": "East Rockaway"
+"InteriorFeatures": array:6 [ …6]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-510-3199"
+"ListAgentEmail": "braleigh@cbamhomes.com"
+"ListAgentKey": "326189908"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109943"
+"ListOfficePhone": "516-825-6511"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-04-01"
+"LivingAreaSource": "Other"
+"LotFeatures": array:6 [ …6]
+"LotSizeAcres": 0.2449
+"LotSizeDimensions": "55 x 200"
+"LotSizeSquareFeet": 10670
+"MajorChangeTimestamp": "2026-05-02T14:31:26Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "East Rockaway Junior-Senior High Sch"
+"MiddleOrJuniorSchoolDistrict": "East Rockaway"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-05-02"
+"OnMarketDate": "2026-04-01"
+"OriginalEntryTimestamp": "2026-04-01T14:15:17Z"
+"OriginalListPrice": 829000
+"OriginatingSystemModificationTimestamp": "2026-05-02T14:31:26Z"
+"OtherStructures": array:1 [ …1]
+"OwnerName": "Dogan & Mariela Kaleli"
+"ParcelNumber": "2005-38-144-00-0005-0"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-01T14:16:36Z"
+"PhotosCount": 35
+"PostalCity": "East Rockaway"
+"PostalCodePlus4": "1403"
+"PurchaseContractDate": "2026-05-01"
+"RoomsTotal": "7"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-825-6511"
+"ShowingRequirements": array:3 [ …3]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-02T14:31:26Z"
+"StreetName": "Phipps"
+"StreetNumber": "18"
+"StreetNumberNumeric": "18"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "17514.76"
+"TaxAssessedValue": 534
+"TaxYear": "2024"
+"Utilities": array:7 [ …7]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Full,Pull Stairs"
+"KEY_Village": "East Rockaway"
+"KEY_TaxSource": "Other"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "829000.00"
+"KEY_ContractPrice": "860000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_DistanceToTrain": "0.60"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "1728.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "479.74537"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "3385055.1245"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "479.74537"
+"KEY_SourceSystemModificationTimestamp": "2026-03-27T14:03:42.520"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "455.99560"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "455.99560"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424107567')"
+"provider_name": "One Key"
+"Media": array:35 [ …35]
+"ID": "30633"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4782
+post_id: "30599"
+post_author: 1
+"ListingKey": "KEY424106236"
+"ListingId": "977426"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-27T18:09:39Z"
+"RFModificationTimestamp": "2026-06-29T08:31:22Z"
+"ListPrice": 1150000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2268.0
+"BuildingAreaTotal": 2268.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "718 Guy Lombardo Avenue, Hempstead, New York 11520"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.63462
+"Longitude": -73.580828
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Rachel Okul"
+"ListOfficeName": "EXIT Realty Premier"
+"ListAgentMlsId": "KEY188386"
+"ListOfficeMlsId": "KEYEREA02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to waterfront living at its finest in the heart of Freeport’s coveted Guy Lombardo Ave . Built in 2021 on the widest Canal in Freeport and thoughtfully raised for peace of mind, this stunning four-bedroom, three-bath Colonial blends modern construction with effortless coastal charm.\n
\n
Step inside to a bright, open-concept layout designed for both everyday living and entertaining. Sunlight pours through the home, highlighting spacious living and dining areas that flow seamlessly into a beautifully appointed kitchen—perfect for gathering with friends after a day on the water. A convenient first-floor bedroom offers flexibility for guests or a private home office.\n
\n
Upstairs, you’ll find generously sized bedrooms, including a serene primary suite complete with its own private full bathroom, creating the perfect retreat. Additional bedrooms and baths provide comfort and convenience for everyone. The home also features a two-car garage and ample storage throughout.\n
\n
Set on an oversized lot 150 X 53 , the outdoor space is where this property truly shines. Enjoy living on the widest canal in Freeport with abundant docking—ideal for boating enthusiasts, featuring 4 Dock Spots for all your water toys ! Catch fish right from your private dock !With plenty of room to add a pool, you can create your own private waterfront oasis.\n
\n
Located just moments from the renowned Nautical Mile, you’ll have easy access to vibrant waterfront dining, shopping, and entertainment, all while enjoying the tranquility of one of Freeport’s most desirable neighborhoods. Low Taxes $12,395 & Low Flood Insurance under $500!!
"""
+"Appliances": array:9 [ …9]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "917-767-6607"
+"BasementYN": true
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-03-27T19:59:44.850422+00:00"
+"CumulativeDaysOnMarket": 78
+"DaysOnMarket": 80
+"Directions": "GPS"
+"ElementarySchool": "Leo F Giblyn School"
+"ElementarySchoolDistrict": "Freeport"
+"ExpirationDate": "2026-09-27"
+"ExteriorFeatures": array:3 [ …3]
+"Flooring": array:1 [ …1]
+"FrontageLength": "52"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:20 [ …20]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "917-767-6607"
+"ListAgentEmail": "rachelokul@exitpremiersells.com"
+"ListAgentKey": "KEY326198422"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "KEY326111209"
+"ListOfficePhone": "516-795-1000"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-03-27"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.1825
+"LotSizeDimensions": "150 X 53"
+"LotSizeSquareFeet": 7950
+"MajorChangeTimestamp": "2026-04-10T04:31:13Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "John W Dodd Middle School"
+"MiddleOrJuniorSchoolDistrict": "Freeport"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-04-10"
+"OriginalEntryTimestamp": "2026-03-27T19:56:20Z"
+"OriginalListPrice": 1150000
+"OriginatingSystemModificationTimestamp": "2026-06-27T18:08:19Z"
+"OwnerName": "Campbell"
+"ParcelNumber": "2009-62-102-00-0813-0"
+"ParkingFeatures": array:3 [ …3]
+"PhotosChangeTimestamp": "2026-06-27T17:38:36Z"
+"PhotosCount": 42
+"PostalCity": "Freeport"
+"PostalCodePlus4": "6213"
+"RoomsTotal": "7"
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-04-10T04:31:13Z"
+"StreetName": "Guy Lombardo"
+"StreetNumber": "718"
+"StreetNumberNumeric": "718"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "12395.14"
+"TaxAssessedValue": 531
+"TaxYear": "2024"
+"Utilities": array:6 [ …6]
+"View": "Water"
+"WaterSource": array:1 [ …1]
+"WaterfrontFeatures": array:4 [ …4]
+"WaterfrontYN": true
+"KEY_Attic": "Full,Pull Stairs,Storage"
+"KEY_Village": "Freeport"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "1150000.00"
+"KEY_WaterAccessYN": "1"
+"KEY_OpenHouseCount": "2"
+"KEY_PreviousStatus": "Coming Soon"
+"KEY_ElectricCompany": "Other"
+"KEY_IncludedInTaxes": "Sewer, Trash"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_LivingAreaSearchSqFt": "2268.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "507.05467"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6301369.8630"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "507.05467"
+"KEY_SourceSystemModificationTimestamp": "2026-03-27T13:20:17.977"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "507.05467"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "507.05467"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424106236')"
+"provider_name": "One Key"
+"Media": array:42 [ …42]
+"ID": "30599"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#317
+post_id: "30591"
+post_author: 1
+"ListingKey": "KEY424097733"
+"ListingId": "977218"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T20:09:38Z"
+"RFModificationTimestamp": "2026-06-29T08:31:45Z"
+"ListPrice": 949999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2191.0
+"BuildingAreaTotal": 2191.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "154 California Avenue, Hempstead, New York 11520"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6658003
+"Longitude": -73.5996687
+"YearBuilt": 1937
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Marie Carlton"
+"ListOfficeName": "Fave Realty Inc"
+"ListAgentMlsId": "KEY180694"
+"ListOfficeMlsId": "KEYFVE01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to This Stunning Colonial in Prime Freeport!\n
Don’t miss this incredible opportunity to own a beautiful two-story Colonial nestled in the heart of Sterns Park—one of Freeport’s most desirable neighborhoods, located within the Baldwin School District.\n
Situated mid-block on a picturesque, tree-lined street, this spacious home offers nearly 2,200 square feet of living space, blending timeless charm with modern comfort.\n
Step inside to find a gracious layout featuring a formal living room with a cozy wood-burning fireplace, a formal dining room perfect for entertaining, and a bright eat-in kitchen. The expansive den provides additional living space and offers convenient access to the rear patio—ideal for indoor-outdoor living.\n
This home boasts:\n
4 generously sized bedrooms\n
2 full bathrooms and 1 half bath\n
Beautiful hardwood floors throughout\n
Elegant coffered ceilings\n
Skylights that fill the home with natural light\n
The full basement spans the entire footprint of the home, offering abundant storage and a dedicated laundry area.\n
Perfectly located near shopping, dining, the LIRR, and public transportation, this home offers both convenience and charm in one exceptional package.\n
With its spacious layout, classic design, and prime location, this is truly a must-see home that won’t last long.\n
Schedule your private showing today!
"""
+"Appliances": array:9 [ …9]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-519-8049"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:3 [ …3]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-03-27T03:54:37.162701+00:00"
+"CumulativeDaysOnMarket": 88
+"DaysOnMarket": 89
+"ElementarySchool": "Brookside Elementary School"
+"ElementarySchoolDistrict": "Baldwin"
+"ExpirationDate": "2027-03-26"
+"FireplaceFeatures": array:2 [ …2]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Baldwin Senior High School"
+"HighSchoolDistrict": "Baldwin"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:3 [ …3]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-216-2170"
+"ListAgentEmail": "carltonm76@gmail.com"
+"ListAgentKey": "KEY326191159"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "KEY418046046"
+"ListOfficePhone": "516-519-8049"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-03-26"
+"LivingAreaSource": "Appraiser"
+"LotSizeAcres": 0.1376
+"LotSizeSquareFeet": 5995
+"MajorChangeTimestamp": "2026-05-26T18:11:05Z"
+"MajorChangeType": "Price Change"
+"MiddleOrJuniorSchool": "Baldwin Middle School"
+"MiddleOrJuniorSchoolDistrict": "Baldwin"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-03-26"
+"OriginalEntryTimestamp": "2026-03-27T03:51:25Z"
+"OriginalListPrice": 975000
+"OriginatingSystemModificationTimestamp": "2026-06-28T20:08:17Z"
+"OtherStructures": array:1 [ …1]
+"OwnerName": "538 Wingate Drive Corp"
+"ParcelNumber": "2009-36-518-00-0020-0"
+"ParkingFeatures": array:2 [ …2]
+"PatioAndPorchFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-22T00:21:36Z"
+"PhotosCount": 39
+"PostalCity": "Freeport"
+"PostalCodePlus4": "1311"
+"PreviousListPrice": 959999
+"PriceChangeTimestamp": "2026-05-26T18:11:05Z"
+"RoomsTotal": "9"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-216-2170"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-26T18:09:32Z"
+"StreetName": "California"
+"StreetNumber": "154"
+"StreetNumberNumeric": "154"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "17477.69"
+"TaxAssessedValue": 515
+"TaxYear": "2024"
+"Utilities": array:5 [ …5]
+"WaterSource": array:1 [ …1]
+"WindowFeatures": array:1 [ …1]
+"KEY_Attic": "Crawl"
+"KEY_HoldDate": "2026-05-20"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "949999.00"
+"KEY_WaterAccessYN": "0"
+"KEY_OpenHouseCount": "2"
+"KEY_PreviousStatus": "Hold"
+"KEY_AdditionalRooms": "Home Office"
+"KEY_ElectricCompany": "Other"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "Price Decrease"
+"KEY_LivingAreaSearchSqFt": "2191.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "433.59151"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6904062.5000"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "433.59151"
+"KEY_SourceSystemModificationTimestamp": "2026-03-26T23:51:25.310"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "433.59151"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.97436"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "433.59151"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424097733')"
+"provider_name": "One Key"
+"Media": array:39 [ …39]
+"ID": "30591"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5288
+post_id: "30588"
+post_author: 1
+"ListingKey": "KEY424095969"
+"ListingId": "977173"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-27T09:01:46Z"
+"RFModificationTimestamp": "2026-03-27T09:05:12Z"
+"ListPrice": 950000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1631.0
+"BuildingAreaTotal": 1631.0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "1656 Michalicki Place, Hempstead, New York 11566"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.671593
+"Longitude": -73.5686562
+"YearBuilt": 1964
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Jaime H. Mesa"
+"ListOfficeName": "RE/MAX Team"
+"ListAgentMlsId": "9012366"
+"ListOfficeMlsId": "CSQU04"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Excellent House in a quiet Block. Great Location in Merrick . Close to All Amenities, Worship, Schools and Shopping. Close to Meadowbrook Parkway. Property includes Garage, Private Driveway and Backyard."
+"Appliances": array:3 [ …3]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "718-429-4400"
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-03-26T23:40:00.334730+00:00"
+"CrossStreet": "Meadowbrook Road"
+"CumulativeDaysOnMarket": 1
+"DaysOnMarket": 95
+"Directions": "Meadowbrook Road to Michalicki Place"
+"ElementarySchoolDistrict": "North Merrick"
+"ExpirationDate": "2026-09-27"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:2 [ …2]
+"HighSchoolDistrict": "North Merrick"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "347-684-4135"
+"ListAgentEmail": "jaimehmesa@hotmail.com"
+"ListAgentKey": "326251992"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110587"
+"ListOfficePhone": "718-429-4400"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-03-26"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1326
+"LotSizeDimensions": "55x108"
+"LotSizeSquareFeet": 5778
+"MajorChangeTimestamp": "2026-03-26T23:37:14Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchoolDistrict": "North Merrick"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-03-26"
+"OriginalEntryTimestamp": "2026-03-26T23:37:14Z"
+"OriginalListPrice": 950000
+"OriginatingSystemModificationTimestamp": "2026-03-27T09:00:23Z"
+"OwnerName": "Mario Rodriguez"
+"ParcelNumber": "2089-55-094-00-1364-0"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-26T23:38:36Z"
+"PhotosCount": 4
+"PostalCity": "Merrick"
+"PostalCodePlus4": "2509"
+"PropertyCondition": array:1 [ …1]
+"RoomsTotal": "6"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "347 684-4135"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-03-26T23:37:14Z"
+"StreetName": "Michalicki"
+"StreetNumber": "1656"
+"StreetNumberNumeric": "1656"
+"StreetSuffix": "Place"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "13725.73"
+"TaxAssessedValue": 508
+"TaxYear": "2024"
+"Utilities": array:5 [ …5]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "950000.00"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_LivingAreaSearchSqFt": "1631.00"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "582.46475"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "7164404.2232"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "582.46475"
+"KEY_SourceSystemModificationTimestamp": "2026-03-26T19:33:21.840"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "582.46475"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "582.46475"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424095969')"
+"provider_name": "One Key"
+"Media": array:4 [ …4]
+"ID": "30588"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4642
+post_id: "30583"
+post_author: 1
+"ListingKey": "KEY424090117"
+"ListingId": "976998"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-04-25T07:08:39Z"
+"RFModificationTimestamp": "2026-04-25T07:12:08Z"
+"ListPrice": 1150000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 2536.0
+"BuildingAreaTotal": 2860.0
+"City": "Hempstead"
+"PostalCode": "11572"
+"UnparsedAddress": "577 Waukena Avenue, Hempstead, New York 11572"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6362945
+"Longitude": -73.6230729
+"YearBuilt": 1947
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Anna Aprea ABR SFR SRES"
+"ListOfficeName": "Coldwell Banker American Homes"
+"ListAgentMlsId": "88250"
+"ListOfficeMlsId": "BRMN05"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to this spacious and beautifully maintained stone-front Colonial offering a versatile M/D layout with possible proper permits—ideal for extended or multi-generational living. Relax on the inviting covered front porch. As you enter the first floor, step into the foyer with coat closet, large primary bedroom with excellent closet space with access to a full bath, & two additional bedrooms. Enjoy a Large living room with a Cozy wood-burning fireplace, a formal dining room with sliders to a patio, and a bright, granite kitchen with stainless steel appliances and a charming breakfast nook. A second full bath completes this level which leads to the Lower level, Basement with laundry/utility room and abundant storage/bonus rooms. \n
The second floor offers an open-concept design with vaulted ceilings, featuring a spacious eat-in kitchen with a large island, stainless steel appliances, and pantry. This level also includes a living room, dining room, three bedrooms, a full bath, washer/dryer, and attic access. Additional features include: \n
Attached garage, Newer gas hot air heating system, 2-zone central air conditioning, Large, fenced property with pavered patio—perfect for entertaining. Conveniently located near schools (Elementary #3 and High School, shopping, dining, beaches, parks, and transportation. Not in a flood zone! Don't Miss this Gem in a desired Location!!!
"""
+"Appliances": array:8 [ …8]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-223-2525"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 3
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "347-413-1936"
+"BuyerAgentEmail": "Humayunc7@gmail.com"
+"BuyerAgentFullName": "Humayun Zaman SFR"
+"BuyerAgentKey": "326198098"
+"BuyerAgentMlsId": "188043"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "423885815"
+"BuyerOfficeMlsId": "LINY01"
+"BuyerOfficeName": "LINY Real Estate"
+"BuyerOfficePhone": "516-849-9691"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-859-3794"
+"CoListAgentEmail": "stacyrealtor2@gmail.com"
+"CoListAgentFullName": "Stacy Fredricks SFR"
+"CoListAgentKey": "326252219"
+"CoListAgentMlsId": "9013380"
+"CoListOfficeKey": "326109936"
+"CoListOfficeMlsId": "BRMN05"
+"CoListOfficeName": "Coldwell Banker American Homes"
+"CoListOfficePhone": "516-223-2525"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-03-26T20:18:54.183175+00:00"
+"CrossStreet": "Frederick st"
+"CumulativeDaysOnMarket": 27
+"DaysOnMarket": 27
+"Directions": "Brower Ave to Waukena Ave."
+"ElementarySchool": "School 3"
+"ElementarySchoolDistrict": "Oceanside"
+"ExpirationDate": "2026-10-31"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"Flooring": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "School 7-Oceanside Senior Hs"
+"HighSchoolDistrict": "Oceanside"
+"InteriorFeatures": array:14 [ …14]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "646-279-4781"
+"ListAgentEmail": "AnnaAprea@aol.com"
+"ListAgentKey": "326248395"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109936"
+"ListOfficePhone": "516-223-2525"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-03-25"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1892
+"LotSizeSquareFeet": 8240
+"MajorChangeTimestamp": "2026-04-24T20:41:15Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School"
+"MiddleOrJuniorSchoolDistrict": "Oceanside"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-04-24"
+"OnMarketDate": "2026-03-28"
+"OriginalEntryTimestamp": "2026-03-26T20:13:32Z"
+"OriginalListPrice": 1150000
+"OriginatingSystemModificationTimestamp": "2026-04-24T20:41:15Z"
+"OwnerName": "Robley"
+"ParcelNumber": "2089-54-449-00-0118-0"
+"ParkingFeatures": array:2 [ …2]
+"PatioAndPorchFeatures": array:3 [ …3]
+"PhotosChangeTimestamp": "2026-03-29T15:42:36Z"
+"PhotosCount": 45
+"PostalCity": "Oceanside"
+"PostalCodePlus4": "4730"
+"PurchaseContractDate": "2026-04-24"
+"RoomsTotal": "12"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "646-279-4781"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-04-24T20:41:15Z"
+"StreetName": "Waukena"
+"StreetNumber": "577"
+"StreetNumberNumeric": "577"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "18842.57"
+"TaxAssessedValue": 662
+"TaxYear": "2026"
+"Utilities": array:4 [ …4]
+"VirtualTourURLBranded": "https://speakeasymedia.hd.pics/2909983"
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Pull Stairs"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "1150000.00"
+"KEY_ContractPrice": "1100000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_NumberOfKitchens": "2"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "2536.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "516-859-3794"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "453.47003"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6078224.1015"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "453.47003"
+"KEY_SourceSystemModificationTimestamp": "2026-03-26T14:52:49.687"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "402.09790"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "402.09790"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424090117')"
+"provider_name": "One Key"
+"Media": array:45 [ …45]
+"ID": "30583"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4749
+post_id: "30590"
+post_author: 1
+"ListingKey": "KEY424089736"
+"ListingId": "976986"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-06-16T07:06:40Z"
+"RFModificationTimestamp": "2026-06-16T07:08:03Z"
+"ListPrice": 675000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1444.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "62 W 1st Street, Hempstead, New York 11520"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6417414
+"Longitude": -73.5767593
+"YearBuilt": 1929
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Rachel Okul"
+"ListOfficeName": "EXIT Realty Premier"
+"ListAgentMlsId": "188386"
+"ListOfficeMlsId": "EREA02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Waterfront Opportunity Under $700,000 – Prime Freeport Location! Welcome to this charming three-bedroom, two-bath waterfront Dutch Colonial nestled on a quiet dead-end street in one of the most desirable blocks in Freeport. Boasting 66 feet of bulkhead, this property is a true boater’s paradise with plenty of room for your large vessel, jet skis, and more. Step inside to a warm and inviting living room featuring a cozy gas-burning fireplace, perfect for relaxing after a day on the water. The layout flows seamlessly into a full-sized dining room and a bright kitchen with white wood cabinetry & Quartz countertops , all overlooking a wide, picturesque canal—bringing waterfront views right into your everyday living. Just off the kitchen, step out onto your private deck—an ideal spot to unwind and take in breathtaking sunset views over the water. Upstairs, you’ll find three comfortable bedrooms and a full bathroom, with serene water views that create a peaceful retreat. A pull-down attic provides convenient additional storage. Navian Tankless hot water heater & Central Air conditioning! Enjoy the ultimate coastal lifestyle—whether you’re swimming right off your dock, entertaining by the water, or setting out for a day of boating. The attached garage offers the perfect space to store your vehicles, tools, and waterfront toys during the off-season. A rare opportunity to own a waterfront gem combining location, lifestyle, and space—this is the one you’ve been waiting for ! Roof is 2 only years old !"
+"Appliances": array:6 [ …6]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "917-767-6607"
+"Basement": array:4 [ …4]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "917-767-6607"
+"BuyerAgentEmail": "rachelokul@exitpremiersells.com"
+"BuyerAgentFullName": "Rachel Okul"
+"BuyerAgentKey": "326198422"
+"BuyerAgentMlsId": "188386"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326111209"
+"BuyerOfficeMlsId": "EREA02"
+"BuyerOfficeName": "EXIT Realty Premier"
+"BuyerOfficePhone": "516-795-1000"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-03-27T02:22:05.021478+00:00"
+"CumulativeDaysOnMarket": 67
+"DaysOnMarket": 67
+"Directions": "GPS"
+"ElementarySchool": "Leo F Giblyn School"
+"ElementarySchoolDistrict": "Freeport"
+"ExpirationDate": "2026-09-26"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:3 [ …3]
+"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": "2026-03-26"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.1366
+"LotSizeSquareFeet": 5952
+"MajorChangeTimestamp": "2026-06-15T16:42:17Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "John W Dodd Middle School"
+"MiddleOrJuniorSchoolDistrict": "Freeport"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-06-15"
+"OnMarketDate": "2026-04-09"
+"OriginalEntryTimestamp": "2026-03-27T02:16:58Z"
+"OriginalListPrice": 750000
+"OriginatingSystemModificationTimestamp": "2026-06-15T16:42:17Z"
+"OwnerName": "Rehwinkle"
+"ParcelNumber": "2009-62-061-00-0086-0"
+"ParkingFeatures": array:2 [ …2]
+"PhotosChangeTimestamp": "2026-05-24T20:06:36Z"
+"PhotosCount": 32
+"PostalCity": "Freeport"
+"PostalCodePlus4": "5725"
+"PreviousListPrice": 725000
+"PriceChangeTimestamp": "2026-05-24T20:06:33Z"
+"PurchaseContractDate": "2026-06-15"
+"RoomsTotal": "7"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "917-767-6607"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-06-15T16:42:17Z"
+"StreetDirPrefix": "W"
+"StreetName": "1st"
+"StreetNumber": "62"
+"StreetNumberNumeric": "62"
+"StreetSuffix": "Street"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "12309.31"
+"TaxAssessedValue": 409
+"TaxBlock": "061"
+"TaxLot": "86"
+"TaxYear": "2024"
+"Utilities": array:2 [ …2]
+"WaterSource": array:1 [ …1]
+"WaterfrontFeatures": array:3 [ …3]
+"WaterfrontYN": true
+"KEY_Attic": "Pull Stairs"
+"KEY_Village": "Freeport"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "62"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "675000.00"
+"KEY_ContractPrice": "670000.00"
+"KEY_OpenHouseCount": "3"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "Other"
+"KEY_IncludedInTaxes": "Sewer,Trash"
+"KEY_NumberOfKitchens": "1"
+"KEY_ConcessionInPrice": "14500.00"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_BuyerRepresentation": "Rachel Okul - Buyer Unrepresented"
+"KEY_LivingAreaSearchSqFt": "1444.00"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "467.45152"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "4941434.8463"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "467.45152"
+"KEY_SourceSystemModificationTimestamp": "2026-03-26T14:40:36.900"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.90000"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424089736')"
+"provider_name": "One Key"
+"Media": array:32 [ …32]
+"ID": "30590"
}
]
+success: true
+page_size: 6
+page_count: 327
+count: 1957
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Cache Key: c18da9822aac50fcbc308c4fa5cd6ab5b9e9f5715b1e7a65c8898bd95cf14a0b" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#6208
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6166
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY424107567"
+"ListingId": "977465"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-05-03T07:12:39Z"
+"RFModificationTimestamp": "2026-05-03T07:14:57Z"
+"ListPrice": 829000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1728.0
+"BuildingAreaTotal": 1818.0
+"City": "Hempstead"
+"PostalCode": "11518"
+"UnparsedAddress": "18 Phipps Avenue, Hempstead, New York 11518"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6435337
+"Longitude": -73.6642197
+"YearBuilt": 1926
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Brianna Raleigh"
+"ListOfficeName": "Coldwell Banker American Homes"
+"ListAgentMlsId": "179342"
+"ListOfficeMlsId": "BRMN12"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "This stunning 3 Bedroom Colonial features a large updated eat in kitchen with quartzite countertops and stainless steel appliances, living room with a fireplace, formal dining room, sunroom/office, 1.5 baths, and a master bedroom with a balcony. There is a full basement, full pull down attic for storage, gas heating, central air conditioning and In ground Sprinklers. This home has an oversized 55x200 lot with long driveway and 2 car garage that has an attached shed with beautiful barnyard doors and an outdoor patio. Close proximity to LIRR, Parks, Shops, Restaurants & much more."
+"Appliances": array:9 [ …9]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-825-6511"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-967-5048"
+"BuyerAgentEmail": "clara.valderrama@elliman.com"
+"BuyerAgentFullName": "Clara Valderrama"
+"BuyerAgentKey": "326133893"
+"BuyerAgentMlsId": "11843"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326110785"
+"BuyerOfficeMlsId": "DERE61"
+"BuyerOfficeName": "Douglas Elliman Real Estate"
+"BuyerOfficePhone": "516-746-0440"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-04-01T14:18:58.504792+00:00"
+"CrossStreet": "Atlantic Ave"
+"CumulativeDaysOnMarket": 30
+"DaysOnMarket": 30
+"Directions": "Use GPS"
+"ElementarySchool": "Centre Avenue Elementary School"
+"ElementarySchoolDistrict": "East Rockaway"
+"ExpirationDate": "2026-10-01"
+"ExteriorFeatures": array:1 [ …1]
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [ …1]
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "East Rockaway Junior-Senior High Sch"
+"HighSchoolDistrict": "East Rockaway"
+"InteriorFeatures": array:6 [ …6]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-510-3199"
+"ListAgentEmail": "braleigh@cbamhomes.com"
+"ListAgentKey": "326189908"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109943"
+"ListOfficePhone": "516-825-6511"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-04-01"
+"LivingAreaSource": "Other"
+"LotFeatures": array:6 [ …6]
+"LotSizeAcres": 0.2449
+"LotSizeDimensions": "55 x 200"
+"LotSizeSquareFeet": 10670
+"MajorChangeTimestamp": "2026-05-02T14:31:26Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "East Rockaway Junior-Senior High Sch"
+"MiddleOrJuniorSchoolDistrict": "East Rockaway"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-05-02"
+"OnMarketDate": "2026-04-01"
+"OriginalEntryTimestamp": "2026-04-01T14:15:17Z"
+"OriginalListPrice": 829000
+"OriginatingSystemModificationTimestamp": "2026-05-02T14:31:26Z"
+"OtherStructures": array:1 [ …1]
+"OwnerName": "Dogan & Mariela Kaleli"
+"ParcelNumber": "2005-38-144-00-0005-0"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-01T14:16:36Z"
+"PhotosCount": 35
+"PostalCity": "East Rockaway"
+"PostalCodePlus4": "1403"
+"PurchaseContractDate": "2026-05-01"
+"RoomsTotal": "7"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-825-6511"
+"ShowingRequirements": array:3 [ …3]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-02T14:31:26Z"
+"StreetName": "Phipps"
+"StreetNumber": "18"
+"StreetNumberNumeric": "18"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "17514.76"
+"TaxAssessedValue": 534
+"TaxYear": "2024"
+"Utilities": array:7 [ …7]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Full,Pull Stairs"
+"KEY_Village": "East Rockaway"
+"KEY_TaxSource": "Other"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "829000.00"
+"KEY_ContractPrice": "860000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_DistanceToTrain": "0.60"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "1728.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "479.74537"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "3385055.1245"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "479.74537"
+"KEY_SourceSystemModificationTimestamp": "2026-03-27T14:03:42.520"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "455.99560"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "455.99560"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424107567')"
+"provider_name": "One Key"
+"Media": array:35 [ …35]
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6152
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY424106236"
+"ListingId": "977426"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-27T18:09:39Z"
+"RFModificationTimestamp": "2026-06-29T08:31:22Z"
+"ListPrice": 1150000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2268.0
+"BuildingAreaTotal": 2268.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "718 Guy Lombardo Avenue, Hempstead, New York 11520"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.63462
+"Longitude": -73.580828
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Rachel Okul"
+"ListOfficeName": "EXIT Realty Premier"
+"ListAgentMlsId": "KEY188386"
+"ListOfficeMlsId": "KEYEREA02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to waterfront living at its finest in the heart of Freeport’s coveted Guy Lombardo Ave . Built in 2021 on the widest Canal in Freeport and thoughtfully raised for peace of mind, this stunning four-bedroom, three-bath Colonial blends modern construction with effortless coastal charm.\n
\n
Step inside to a bright, open-concept layout designed for both everyday living and entertaining. Sunlight pours through the home, highlighting spacious living and dining areas that flow seamlessly into a beautifully appointed kitchen—perfect for gathering with friends after a day on the water. A convenient first-floor bedroom offers flexibility for guests or a private home office.\n
\n
Upstairs, you’ll find generously sized bedrooms, including a serene primary suite complete with its own private full bathroom, creating the perfect retreat. Additional bedrooms and baths provide comfort and convenience for everyone. The home also features a two-car garage and ample storage throughout.\n
\n
Set on an oversized lot 150 X 53 , the outdoor space is where this property truly shines. Enjoy living on the widest canal in Freeport with abundant docking—ideal for boating enthusiasts, featuring 4 Dock Spots for all your water toys ! Catch fish right from your private dock !With plenty of room to add a pool, you can create your own private waterfront oasis.\n
\n
Located just moments from the renowned Nautical Mile, you’ll have easy access to vibrant waterfront dining, shopping, and entertainment, all while enjoying the tranquility of one of Freeport’s most desirable neighborhoods. Low Taxes $12,395 & Low Flood Insurance under $500!!
"""
+"Appliances": array:9 [ …9]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "917-767-6607"
+"BasementYN": true
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-03-27T19:59:44.850422+00:00"
+"CumulativeDaysOnMarket": 78
+"DaysOnMarket": 80
+"Directions": "GPS"
+"ElementarySchool": "Leo F Giblyn School"
+"ElementarySchoolDistrict": "Freeport"
+"ExpirationDate": "2026-09-27"
+"ExteriorFeatures": array:3 [ …3]
+"Flooring": array:1 [ …1]
+"FrontageLength": "52"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:20 [ …20]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "917-767-6607"
+"ListAgentEmail": "rachelokul@exitpremiersells.com"
+"ListAgentKey": "KEY326198422"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "KEY326111209"
+"ListOfficePhone": "516-795-1000"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-03-27"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.1825
+"LotSizeDimensions": "150 X 53"
+"LotSizeSquareFeet": 7950
+"MajorChangeTimestamp": "2026-04-10T04:31:13Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "John W Dodd Middle School"
+"MiddleOrJuniorSchoolDistrict": "Freeport"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-04-10"
+"OriginalEntryTimestamp": "2026-03-27T19:56:20Z"
+"OriginalListPrice": 1150000
+"OriginatingSystemModificationTimestamp": "2026-06-27T18:08:19Z"
+"OwnerName": "Campbell"
+"ParcelNumber": "2009-62-102-00-0813-0"
+"ParkingFeatures": array:3 [ …3]
+"PhotosChangeTimestamp": "2026-06-27T17:38:36Z"
+"PhotosCount": 42
+"PostalCity": "Freeport"
+"PostalCodePlus4": "6213"
+"RoomsTotal": "7"
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-04-10T04:31:13Z"
+"StreetName": "Guy Lombardo"
+"StreetNumber": "718"
+"StreetNumberNumeric": "718"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "12395.14"
+"TaxAssessedValue": 531
+"TaxYear": "2024"
+"Utilities": array:6 [ …6]
+"View": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"WaterfrontFeatures": array:4 [ …4]
+"WaterfrontYN": true
+"KEY_Attic": "Full,Pull Stairs,Storage"
+"KEY_Village": "Freeport"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "1150000.00"
+"KEY_WaterAccessYN": "1"
+"KEY_OpenHouseCount": "2"
+"KEY_PreviousStatus": "Coming Soon"
+"KEY_ElectricCompany": "Other"
+"KEY_IncludedInTaxes": "Sewer, Trash"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_LivingAreaSearchSqFt": "2268.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "507.05467"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6301369.8630"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "507.05467"
+"KEY_SourceSystemModificationTimestamp": "2026-03-27T13:20:17.977"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "507.05467"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "507.05467"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424106236')"
+"provider_name": "One Key"
+"Media": array:42 [ …42]
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5652
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY424097733"
+"ListingId": "977218"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T20:09:38Z"
+"RFModificationTimestamp": "2026-06-29T08:31:45Z"
+"ListPrice": 949999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2191.0
+"BuildingAreaTotal": 2191.0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "154 California Avenue, Hempstead, New York 11520"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6658003
+"Longitude": -73.5996687
+"YearBuilt": 1937
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Marie Carlton"
+"ListOfficeName": "Fave Realty Inc"
+"ListAgentMlsId": "KEY180694"
+"ListOfficeMlsId": "KEYFVE01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to This Stunning Colonial in Prime Freeport!\n
Don’t miss this incredible opportunity to own a beautiful two-story Colonial nestled in the heart of Sterns Park—one of Freeport’s most desirable neighborhoods, located within the Baldwin School District.\n
Situated mid-block on a picturesque, tree-lined street, this spacious home offers nearly 2,200 square feet of living space, blending timeless charm with modern comfort.\n
Step inside to find a gracious layout featuring a formal living room with a cozy wood-burning fireplace, a formal dining room perfect for entertaining, and a bright eat-in kitchen. The expansive den provides additional living space and offers convenient access to the rear patio—ideal for indoor-outdoor living.\n
This home boasts:\n
4 generously sized bedrooms\n
2 full bathrooms and 1 half bath\n
Beautiful hardwood floors throughout\n
Elegant coffered ceilings\n
Skylights that fill the home with natural light\n
The full basement spans the entire footprint of the home, offering abundant storage and a dedicated laundry area.\n
Perfectly located near shopping, dining, the LIRR, and public transportation, this home offers both convenience and charm in one exceptional package.\n
With its spacious layout, classic design, and prime location, this is truly a must-see home that won’t last long.\n
Schedule your private showing today!
"""
+"Appliances": array:9 [ …9]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-519-8049"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:3 [ …3]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-03-27T03:54:37.162701+00:00"
+"CumulativeDaysOnMarket": 88
+"DaysOnMarket": 89
+"ElementarySchool": "Brookside Elementary School"
+"ElementarySchoolDistrict": "Baldwin"
+"ExpirationDate": "2027-03-26"
+"FireplaceFeatures": array:2 [ …2]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Baldwin Senior High School"
+"HighSchoolDistrict": "Baldwin"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:3 [ …3]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-216-2170"
+"ListAgentEmail": "carltonm76@gmail.com"
+"ListAgentKey": "KEY326191159"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "KEY418046046"
+"ListOfficePhone": "516-519-8049"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-03-26"
+"LivingAreaSource": "Appraiser"
+"LotSizeAcres": 0.1376
+"LotSizeSquareFeet": 5995
+"MajorChangeTimestamp": "2026-05-26T18:11:05Z"
+"MajorChangeType": "Price Change"
+"MiddleOrJuniorSchool": "Baldwin Middle School"
+"MiddleOrJuniorSchoolDistrict": "Baldwin"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-03-26"
+"OriginalEntryTimestamp": "2026-03-27T03:51:25Z"
+"OriginalListPrice": 975000
+"OriginatingSystemModificationTimestamp": "2026-06-28T20:08:17Z"
+"OtherStructures": array:1 [ …1]
+"OwnerName": "538 Wingate Drive Corp"
+"ParcelNumber": "2009-36-518-00-0020-0"
+"ParkingFeatures": array:2 [ …2]
+"PatioAndPorchFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-04-22T00:21:36Z"
+"PhotosCount": 39
+"PostalCity": "Freeport"
+"PostalCodePlus4": "1311"
+"PreviousListPrice": 959999
+"PriceChangeTimestamp": "2026-05-26T18:11:05Z"
+"RoomsTotal": "9"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-216-2170"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-05-26T18:09:32Z"
+"StreetName": "California"
+"StreetNumber": "154"
+"StreetNumberNumeric": "154"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "17477.69"
+"TaxAssessedValue": 515
+"TaxYear": "2024"
+"Utilities": array:5 [ …5]
+"WaterSource": array:1 [ …1]
+"WindowFeatures": array:1 [ …1]
+"KEY_Attic": "Crawl"
+"KEY_HoldDate": "2026-05-20"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "949999.00"
+"KEY_WaterAccessYN": "0"
+"KEY_OpenHouseCount": "2"
+"KEY_PreviousStatus": "Hold"
+"KEY_AdditionalRooms": "Home Office"
+"KEY_ElectricCompany": "Other"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "Price Decrease"
+"KEY_LivingAreaSearchSqFt": "2191.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "433.59151"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6904062.5000"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "433.59151"
+"KEY_SourceSystemModificationTimestamp": "2026-03-26T23:51:25.310"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "433.59151"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.97436"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "433.59151"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424097733')"
+"provider_name": "One Key"
+"Media": array:39 [ …39]
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6182
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY424095969"
+"ListingId": "977173"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-27T09:01:46Z"
+"RFModificationTimestamp": "2026-03-27T09:05:12Z"
+"ListPrice": 950000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1631.0
+"BuildingAreaTotal": 1631.0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "1656 Michalicki Place, Hempstead, New York 11566"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.671593
+"Longitude": -73.5686562
+"YearBuilt": 1964
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Jaime H. Mesa"
+"ListOfficeName": "RE/MAX Team"
+"ListAgentMlsId": "9012366"
+"ListOfficeMlsId": "CSQU04"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Excellent House in a quiet Block. Great Location in Merrick . Close to All Amenities, Worship, Schools and Shopping. Close to Meadowbrook Parkway. Property includes Garage, Private Driveway and Backyard."
+"Appliances": array:3 [ …3]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "718-429-4400"
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-03-26T23:40:00.334730+00:00"
+"CrossStreet": "Meadowbrook Road"
+"CumulativeDaysOnMarket": 1
+"DaysOnMarket": 95
+"Directions": "Meadowbrook Road to Michalicki Place"
+"ElementarySchoolDistrict": "North Merrick"
+"ExpirationDate": "2026-09-27"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:2 [ …2]
+"HighSchoolDistrict": "North Merrick"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "347-684-4135"
+"ListAgentEmail": "jaimehmesa@hotmail.com"
+"ListAgentKey": "326251992"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110587"
+"ListOfficePhone": "718-429-4400"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-03-26"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1326
+"LotSizeDimensions": "55x108"
+"LotSizeSquareFeet": 5778
+"MajorChangeTimestamp": "2026-03-26T23:37:14Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchoolDistrict": "North Merrick"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2026-03-26"
+"OriginalEntryTimestamp": "2026-03-26T23:37:14Z"
+"OriginalListPrice": 950000
+"OriginatingSystemModificationTimestamp": "2026-03-27T09:00:23Z"
+"OwnerName": "Mario Rodriguez"
+"ParcelNumber": "2089-55-094-00-1364-0"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-03-26T23:38:36Z"
+"PhotosCount": 4
+"PostalCity": "Merrick"
+"PostalCodePlus4": "2509"
+"PropertyCondition": array:1 [ …1]
+"RoomsTotal": "6"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "347 684-4135"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-03-26T23:37:14Z"
+"StreetName": "Michalicki"
+"StreetNumber": "1656"
+"StreetNumberNumeric": "1656"
+"StreetSuffix": "Place"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "13725.73"
+"TaxAssessedValue": 508
+"TaxYear": "2024"
+"Utilities": array:5 [ …5]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "950000.00"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_LivingAreaSearchSqFt": "1631.00"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "582.46475"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "7164404.2232"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "582.46475"
+"KEY_SourceSystemModificationTimestamp": "2026-03-26T19:33:21.840"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "582.46475"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "582.46475"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424095969')"
+"provider_name": "One Key"
+"Media": array:4 [ …4]
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6184
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY424090117"
+"ListingId": "976998"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-04-25T07:08:39Z"
+"RFModificationTimestamp": "2026-04-25T07:12:08Z"
+"ListPrice": 1150000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 2536.0
+"BuildingAreaTotal": 2860.0
+"City": "Hempstead"
+"PostalCode": "11572"
+"UnparsedAddress": "577 Waukena Avenue, Hempstead, New York 11572"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6362945
+"Longitude": -73.6230729
+"YearBuilt": 1947
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Anna Aprea ABR SFR SRES"
+"ListOfficeName": "Coldwell Banker American Homes"
+"ListAgentMlsId": "88250"
+"ListOfficeMlsId": "BRMN05"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to this spacious and beautifully maintained stone-front Colonial offering a versatile M/D layout with possible proper permits—ideal for extended or multi-generational living. Relax on the inviting covered front porch. As you enter the first floor, step into the foyer with coat closet, large primary bedroom with excellent closet space with access to a full bath, & two additional bedrooms. Enjoy a Large living room with a Cozy wood-burning fireplace, a formal dining room with sliders to a patio, and a bright, granite kitchen with stainless steel appliances and a charming breakfast nook. A second full bath completes this level which leads to the Lower level, Basement with laundry/utility room and abundant storage/bonus rooms. \n
The second floor offers an open-concept design with vaulted ceilings, featuring a spacious eat-in kitchen with a large island, stainless steel appliances, and pantry. This level also includes a living room, dining room, three bedrooms, a full bath, washer/dryer, and attic access. Additional features include: \n
Attached garage, Newer gas hot air heating system, 2-zone central air conditioning, Large, fenced property with pavered patio—perfect for entertaining. Conveniently located near schools (Elementary #3 and High School, shopping, dining, beaches, parks, and transportation. Not in a flood zone! Don't Miss this Gem in a desired Location!!!
"""
+"Appliances": array:8 [ …8]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-223-2525"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 3
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "347-413-1936"
+"BuyerAgentEmail": "Humayunc7@gmail.com"
+"BuyerAgentFullName": "Humayun Zaman SFR"
+"BuyerAgentKey": "326198098"
+"BuyerAgentMlsId": "188043"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "423885815"
+"BuyerOfficeMlsId": "LINY01"
+"BuyerOfficeName": "LINY Real Estate"
+"BuyerOfficePhone": "516-849-9691"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-859-3794"
+"CoListAgentEmail": "stacyrealtor2@gmail.com"
+"CoListAgentFullName": "Stacy Fredricks SFR"
+"CoListAgentKey": "326252219"
+"CoListAgentMlsId": "9013380"
+"CoListOfficeKey": "326109936"
+"CoListOfficeMlsId": "BRMN05"
+"CoListOfficeName": "Coldwell Banker American Homes"
+"CoListOfficePhone": "516-223-2525"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-03-26T20:18:54.183175+00:00"
+"CrossStreet": "Frederick st"
+"CumulativeDaysOnMarket": 27
+"DaysOnMarket": 27
+"Directions": "Brower Ave to Waukena Ave."
+"ElementarySchool": "School 3"
+"ElementarySchoolDistrict": "Oceanside"
+"ExpirationDate": "2026-10-31"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"Flooring": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "School 7-Oceanside Senior Hs"
+"HighSchoolDistrict": "Oceanside"
+"InteriorFeatures": array:14 [ …14]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "646-279-4781"
+"ListAgentEmail": "AnnaAprea@aol.com"
+"ListAgentKey": "326248395"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109936"
+"ListOfficePhone": "516-223-2525"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-03-25"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1892
+"LotSizeSquareFeet": 8240
+"MajorChangeTimestamp": "2026-04-24T20:41:15Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "School 9M-Oceanside Middle School"
+"MiddleOrJuniorSchoolDistrict": "Oceanside"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-04-24"
+"OnMarketDate": "2026-03-28"
+"OriginalEntryTimestamp": "2026-03-26T20:13:32Z"
+"OriginalListPrice": 1150000
+"OriginatingSystemModificationTimestamp": "2026-04-24T20:41:15Z"
+"OwnerName": "Robley"
+"ParcelNumber": "2089-54-449-00-0118-0"
+"ParkingFeatures": array:2 [ …2]
+"PatioAndPorchFeatures": array:3 [ …3]
+"PhotosChangeTimestamp": "2026-03-29T15:42:36Z"
+"PhotosCount": 45
+"PostalCity": "Oceanside"
+"PostalCodePlus4": "4730"
+"PurchaseContractDate": "2026-04-24"
+"RoomsTotal": "12"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "646-279-4781"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-04-24T20:41:15Z"
+"StreetName": "Waukena"
+"StreetNumber": "577"
+"StreetNumberNumeric": "577"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "18842.57"
+"TaxAssessedValue": 662
+"TaxYear": "2026"
+"Utilities": array:4 [ …4]
+"VirtualTourURLBranded": "https://speakeasymedia.hd.pics/2909983"
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Pull Stairs"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "1150000.00"
+"KEY_ContractPrice": "1100000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_NumberOfKitchens": "2"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "2536.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "516-859-3794"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "453.47003"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6078224.1015"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "453.47003"
+"KEY_SourceSystemModificationTimestamp": "2026-03-26T14:52:49.687"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "402.09790"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "402.09790"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('KEY424090117')"
+"provider_name": "One Key"
+"Media": array:45 [ …45]
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6186
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY424089736"
+"ListingId": "976986"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-06-16T07:06:40Z"
+"RFModificationTimestamp": "2026-06-16T07:08:03Z"
+"ListPrice": 675000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1444.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11520"
+"UnparsedAddress": "62 W 1st Street, Hempstead, New York 11520"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6417414
+"Longitude": -73.5767593
+"YearBuilt": 1929
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Rachel Okul"
+"ListOfficeName": "EXIT Realty Premier"
+"ListAgentMlsId": "188386"
+"ListOfficeMlsId": "EREA02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Waterfront Opportunity Under $700,000 – Prime Freeport Location! Welcome to this charming three-bedroom, two-bath waterfront Dutch Colonial nestled on a quiet dead-end street in one of the most desirable blocks in Freeport. Boasting 66 feet of bulkhead, this property is a true boater’s paradise with plenty of room for your large vessel, jet skis, and more. Step inside to a warm and inviting living room featuring a cozy gas-burning fireplace, perfect for relaxing after a day on the water. The layout flows seamlessly into a full-sized dining room and a bright kitchen with white wood cabinetry & Quartz countertops , all overlooking a wide, picturesque canal—bringing waterfront views right into your everyday living. Just off the kitchen, step out onto your private deck—an ideal spot to unwind and take in breathtaking sunset views over the water. Upstairs, you’ll find three comfortable bedrooms and a full bathroom, with serene water views that create a peaceful retreat. A pull-down attic provides convenient additional storage. Navian Tankless hot water heater & Central Air conditioning! Enjoy the ultimate coastal lifestyle—whether you’re swimming right off your dock, entertaining by the water, or setting out for a day of boating. The attached garage offers the perfect space to store your vehicles, tools, and waterfront toys during the off-season. A rare opportunity to own a waterfront gem combining location, lifestyle, and space—this is the one you’ve been waiting for ! Roof is 2 only years old !"
+"Appliances": array:6 [ …6]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "917-767-6607"
+"Basement": array:4 [ …4]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "917-767-6607"
+"BuyerAgentEmail": "rachelokul@exitpremiersells.com"
+"BuyerAgentFullName": "Rachel Okul"
+"BuyerAgentKey": "326198422"
+"BuyerAgentMlsId": "188386"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326111209"
+"BuyerOfficeMlsId": "EREA02"
+"BuyerOfficeName": "EXIT Realty Premier"
+"BuyerOfficePhone": "516-795-1000"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-03-27T02:22:05.021478+00:00"
+"CumulativeDaysOnMarket": 67
+"DaysOnMarket": 67
+"Directions": "GPS"
+"ElementarySchool": "Leo F Giblyn School"
+"ElementarySchoolDistrict": "Freeport"
+"ExpirationDate": "2026-09-26"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Freeport High School"
+"HighSchoolDistrict": "Freeport"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
…86
}
]
+success: true
+page_size: 6
+page_count: 327
+count: 1957
+after_key: ""
}
]
]
