array:3 [
"RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=6&$skip=972&$filter=(StandardStatus in ('Active','Pending','Coming Soon','Hold','Expired') and ( City in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst') or PostalCity in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst','Lawrence')) and ListPrice le 5000000) and (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental')&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4531
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4535
+post_id: "29652"
+post_author: 1
+"ListingKey": "KEY422989764"
+"ListingId": "944538"
+"PropertyType": "Residential Income"
+"PropertySubType": "Duplex"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2026-02-08T07:07:37Z"
+"RFModificationTimestamp": "2026-02-08T07:12:18Z"
+"ListPrice": 1099999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11518"
+"UnparsedAddress": "74 Davis St, Hempstead, New York 11518"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6409563
+"Longitude": -73.6665384
+"YearBuilt": 1920
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Brandon Fernandes"
+"ListOfficeName": "Manhasset Sands Point Realty"
+"ListAgentMlsId": "503231"
+"ListOfficeMlsId": "NISF01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Fully Renovated Two-Family – Delivered Vacant – Prime East Rockaway Location\n
\n
Welcome to 74 Davis Street, East Rockaway, a turnkey legal two-family property fully renovated in 2024 and delivered vacant at closing. This is a rare opportunity for investors or owner-occupants seeking flexibility, strong upside, and a premier commuter-friendly location.\n
\n
The home features two well-appointed apartments with modern kitchens, updated baths, and quality finishes throughout. Prior rental income highlights the property’s strong earning potential:\n
\n
Unit 1: Previously rented for $3,750/month\n
\n
Unit 2: Previously rented for $2,800/month\n
\n
Additional value includes a finished basement (not legal; buyer to verify use) and a garage with separate rental potential, offering multiple income streams.\n
\n
Situated on a quiet residential street, the property is walking distance to the LIRR, shops, restaurants, and local amenities, making it highly desirable for tenants and end users alike.\n
\n
Ideal for investors, 1031 exchange buyers, or owner-occupants looking to offset their mortgage with rental income. Vacant delivery allows immediate rent optimization or personal occupancy.\n
\n
A high-quality, income-producing asset in a sought-after Nassau County neighborhood
"""
+"AttributionContact": "516-314-7120"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 3
+"BuildingAreaUnits": "Square Feet"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-314-7120"
+"CoListAgentEmail": "nick@msprealty.org"
+"CoListAgentFullName": "Nicholas M. Sforza"
+"CoListAgentKey": "326267022"
+"CoListAgentMlsId": "95443"
+"CoListOfficeKey": "326114083"
+"CoListOfficeMlsId": "NISF01"
+"CoListOfficeName": "Manhasset Sands Point Realty"
+"CoListOfficePhone": "516-314-7120"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-12-23T22:50:56.099761+00:00"
+"CumulativeDaysOnMarket": 46
+"DaysOnMarket": 46
+"ExpirationDate": "2026-04-24"
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-640-1489"
+"ListAgentEmail": "bfernandes965@gmail.com"
+"ListAgentKey": "418981286"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326114083"
+"ListOfficePhone": "516-314-7120"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-12-23"
+"MajorChangeTimestamp": "2026-02-07T18:44:26Z"
+"MajorChangeType": "Hold"
+"MlsStatus": "Hold"
+"NumberOfUnitsTotal": "2"
+"OffMarketDate": "2026-02-07"
+"OnMarketDate": "2025-12-23"
+"OriginalEntryTimestamp": "2025-12-23T22:49:30Z"
+"OriginalListPrice": 1099999
+"OriginatingSystemModificationTimestamp": "2026-02-07T18:44:26Z"
+"OwnerName": "Brandon Fernandes"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-12-23T22:50:36Z"
+"PhotosCount": 24
+"PostalCity": "East Rockaway"
+"PriceChangeTimestamp": "2025-12-23T22:49:30Z"
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-02-07T18:44:26Z"
+"StreetName": "Davis"
+"StreetNumber": "74"
+"StreetNumberNumeric": "74"
+"StreetSuffix": "Street"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "15714"
+"TaxYear": "2025"
+"Utilities": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"KEY_HoldDate": "2026-02-07"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "1099999.00"
+"KEY_NumOf1BedRooms": "0"
+"KEY_NumOf2BedRooms": "1"
+"KEY_NumOf3BedRooms": "1"
+"KEY_NumOf4BedRooms": "0"
+"KEY_OpenHouseCount": "4"
+"KEY_PreviousStatus": "Active"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Temp Off Market"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_SourceSystemModificationTimestamp": "2025-12-16T14:07:51.620"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422989764')"
+"provider_name": "One Key"
+"Media": array:24 [ …24]
+"ID": "29652"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5095
+post_id: "29691"
+post_author: 1
+"ListingKey": "KEY422988420"
+"ListingId": "944495"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-03-12T07:05:38Z"
+"RFModificationTimestamp": "2026-03-12T07:09:59Z"
+"ListPrice": 1250000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2537.0
+"BuildingAreaTotal": 2573.0
+"City": "Hempstead"
+"PostalCode": "11518"
+"UnparsedAddress": "164 Waverly Avenue, Hempstead, New York 11518"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6434339
+"Longitude": -73.676224
+"YearBuilt": 1946
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Mary C. Valenti"
+"ListOfficeName": "C21 Verdeschi & Walsh Realty"
+"ListAgentMlsId": "99532"
+"ListOfficeMlsId": "LAV01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Welcome to this stunning & unique corner Colonial home where every detail has a mind of its own. This home offers Primary bedroom suite w/full bath, steam shower, jacuzzi tub & sky light, plus 2.5 additional baths, 3 additional bedrooms, an oversized living room with a gas fireplace, which takes you into a large kitchen with a Garland Professional Gas Range stove with 2 ovens, skylights, nice size island, stainless steel appliances, and gas fireplace. From there, you go into a Zen type of dining room , hardwood floors and carpeting as well. Also, off the kitchen is a huge fenced in yard with a salt water in ground pool, Koi pond, TREX deck, inground sprinklers, 100X100 size property. This home also comes with a 2 car garage, full finished basement with wine cellar. Attic. Don't miss the chance to make this home your forever home."
+"Appliances": array:7 [ …7]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-431-6160"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "917-370-5354"
+"BuyerAgentEmail": "laura.carroll@compass.com"
+"BuyerAgentFullName": "Laura S. Carroll"
+"BuyerAgentKey": "326185422"
+"BuyerAgentMlsId": "174472"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326110405"
+"BuyerOfficeMlsId": "CMPA08"
+"BuyerOfficeName": "Compass Greater NY LLC"
+"BuyerOfficePhone": "516-408-2231"
+"ConstructionMaterials": array:3 [ …3]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-01-02T14:12:05.680230+00:00"
+"CumulativeDaysOnMarket": 68
+"DaysOnMarket": 68
+"ElementarySchool": "Waverly Park School"
+"ElementarySchoolDistrict": "Lynbrook"
+"ExpirationDate": "2027-01-02"
+"ExteriorFeatures": array:2 [ …2]
+"Fencing": array:2 [ …2]
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Flooring": array:2 [ …2]
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:2 [ …2]
+"HighSchool": "Lynbrook Senior High School"
+"HighSchoolDistrict": "Lynbrook"
+"InteriorFeatures": array:6 [ …6]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-316-0323"
+"ListAgentEmail": "tangirl63@aol.com"
+"ListAgentKey": "326270809"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326113052"
+"ListOfficePhone": "516-431-6160"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2026-01-02"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.2296
+"LotSizeSquareFeet": 10000
+"MajorChangeTimestamp": "2026-03-11T15:24:23Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Lynbrook South Middle School"
+"MiddleOrJuniorSchoolDistrict": "Lynbrook"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-03-11"
+"OnMarketDate": "2026-01-02"
+"OriginalEntryTimestamp": "2026-01-02T14:09:15Z"
+"OriginalListPrice": 1250000
+"OriginatingSystemModificationTimestamp": "2026-03-11T15:24:23Z"
+"OwnerName": "Richard S & Thea P Levey"
+"ParcelNumber": "2005-42-114-00-0211-0"
+"ParkingFeatures": array:1 [ …1]
+"PatioAndPorchFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-01-02T14:10:36Z"
+"PhotosCount": 36
+"PoolFeatures": array:1 [ …1]
+"PoolPrivateYN": true
+"PostalCity": "East Rockaway"
+"PostalCodePlus4": "1613"
+"PurchaseContractDate": "2026-03-11"
+"RoomsTotal": "8"
+"SecurityFeatures": array:1 [ …1]
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "5163160323"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-03-11T15:24:23Z"
+"StreetName": "Waverly"
+"StreetNumber": "164"
+"StreetNumberNumeric": "164"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "23210.64"
+"TaxAssessedValue": 843
+"TaxYear": "2025"
+"Utilities": array:6 [ …6]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Pull Stairs,Unfinished"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "1250000.00"
+"KEY_ContractPrice": "1100000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "2537.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "492.70792"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "5444250.8711"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "492.70792"
+"KEY_SourceSystemModificationTimestamp": "2025-12-16T12:22:16.777"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "485.81422"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "485.81422"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422988420')"
+"provider_name": "One Key"
+"Media": array:36 [ …36]
+"ID": "29691"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4607
+post_id: "29964"
+post_author: 1
+"ListingKey": "KEY422987696"
+"ListingId": "944464"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-03-11T18:14:36Z"
+"RFModificationTimestamp": "2026-03-11T18:23:49Z"
+"ListPrice": 775000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1640.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11565"
+"UnparsedAddress": "66 Woods Avenue, Hempstead, New York 11565"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6815358
+"Longitude": -73.6744349
+"YearBuilt": 1951
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Rhea Cory Knopf"
+"ListOfficeName": "Compass Greater NY LLC"
+"ListAgentMlsId": "91890"
+"ListOfficeMlsId": "CMPA07"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Ideally located in the heart of Malverne in Valley Stream District #13 schools, this spacious 5-bedroom, 2-bath Colonial-style Cape offers exceptional flexibility and living space. The home features two king-size bedrooms, including one conveniently located on the first floor and another on the second floor. An inviting main-level den extension provides additional living and entertaining space. The full, unfinished basement with high ceilings offers excellent potential to create additional living areas. Situated on over 8,000 square feet of property, this home presents a wonderful opportunity for a new owner to customize and make it their own."
+"Appliances": array:3 [ …3]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-375-7727"
+"Basement": array:1 [ …1]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-455-6264"
+"BuyerAgentEmail": "fleonardini@signaturepremier.com"
+"BuyerAgentFullName": "Francesca Leonardini"
+"BuyerAgentKey": "326248312"
+"BuyerAgentMlsId": "88145"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326115719"
+"BuyerOfficeMlsId": "SPH11"
+"BuyerOfficeName": "Signature Premier Properties"
+"BuyerOfficePhone": "516-741-4333"
+"CoBuyerAgentAOR": "LIBOR"
+"CoBuyerAgentDirectPhone": "516-639-1443"
+"CoBuyerAgentEmail": "hgholami@signaturepremier.com"
+"CoBuyerAgentFullName": "Hengameh Gholami"
+"CoBuyerAgentKey": "326119199"
+"CoBuyerAgentMlsId": "102672"
+"CoBuyerOfficeKey": "326115719"
+"CoBuyerOfficeMlsId": "SPH11"
+"CoBuyerOfficeName": "Signature Premier Properties"
+"CoBuyerOfficePhone": "516-741-4333"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2026-02-02T20:16:47.109656+00:00"
+"CrossStreet": "Gold Pl"
+"CumulativeDaysOnMarket": 25
+"DaysOnMarket": 25
+"ElementarySchool": "Willow Road School"
+"ElementarySchoolDistrict": "Valley Stream - 13"
+"ExpirationDate": "2026-06-16"
+"Flooring": array:2 [ …2]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Valley Stream Central High School"
+"HighSchoolDistrict": "Valley Stream Central"
+"InteriorFeatures": array:4 [ …4]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-375-7727"
+"ListAgentEmail": "cory.knopf@compass.com"
+"ListAgentKey": "326263979"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110404"
+"ListOfficePhone": "516-764-6060"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-12-16"
+"LivingAreaSource": "Public Records"
+"LotSizeSquareFeet": 8400
+"MajorChangeTimestamp": "2026-03-11T18:13:30Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Howard T Herber Middle School"
+"MiddleOrJuniorSchoolDistrict": "Valley Stream Central"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-02-27"
+"OnMarketDate": "2026-02-02"
+"OriginalEntryTimestamp": "2026-02-02T20:12:06Z"
+"OriginalListPrice": 775000
+"OriginatingSystemModificationTimestamp": "2026-03-11T18:13:30Z"
+"OwnerName": "Meglin/Brodhead"
+"ParkingFeatures": array:3 [ …3]
+"ParkingTotal": "2"
+"PhotosChangeTimestamp": "2026-01-18T12:54:36Z"
+"PhotosCount": 19
+"PostalCity": "Malverne"
+"PurchaseContractDate": "2026-03-11"
+"RoomsTotal": "10"
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-03-11T18:13:30Z"
+"StreetName": "Woods"
+"StreetNumber": "66"
+"StreetNumberNumeric": "66"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "14655"
+"TaxBlock": "553"
+"TaxLot": "21"
+"TaxYear": "2025"
+"Utilities": array:5 [ …5]
+"WaterSource": array:1 [ …1]
+"YearBuiltEffective": 1951
+"KEY_Attic": "None"
+"KEY_HoldDate": "2026-02-27"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "35"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "775000.00"
+"KEY_ContractPrice": "795000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Hold"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "1640.00"
+"KEY_NumberOfHeatingZones": "3"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "472.56098"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "472.56098"
+"KEY_SourceSystemModificationTimestamp": "2025-12-16T11:31:58.440"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422987696')"
+"provider_name": "One Key"
+"Media": array:19 [ …19]
+"ID": "29964"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4608
+post_id: "29665"
+post_author: 1
+"ListingKey": "KEY422987481"
+"ListingId": "944449"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-29T10:01:37Z"
+"RFModificationTimestamp": "2025-12-29T10:04:47Z"
+"ListPrice": 2999999.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3115.0
+"BuildingAreaTotal": 3115.0
+"City": "Hempstead"
+"PostalCode": "11598"
+"UnparsedAddress": "136 Linden Street, Hempstead, New York 11598"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6279798
+"Longitude": -73.7174347
+"YearBuilt": 1913
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Ann Bienstock"
+"ListOfficeName": "Five Towns Miller Realty Inc"
+"ListAgentMlsId": "143188"
+"ListOfficeMlsId": "DOMI01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Introducing 136 Linden Street. Nestled on a beautiful, tree-lined street in the heart of Woodmere, this home is set on an expansive lot of just over 17,000 square feet, offering rare space, privacy, and opportunity. The residence features 5 oversized bedrooms and 4 full bathrooms, along with a spacious living room, formal dining room, and den—an ideal layout for both comfortable living and entertaining. Step outside to a beautifully maintained in-ground pool, updated approximately three years ago with a new heater, liner, and filter. The massive backyard provides exceptional outdoor space, perfect for future expansion, recreation, or enjoying as a private outdoor oasis. Ideally located near top-rated schools, houses of worship, shopping, dining, parks, and transportation, this property presents a unique opportunity to own an oversized property in one of Woodmere’s most desirable neighborhoods.\n
The information has been provided by the Seller and public records and has not been verified by the Broker. Information is deemed reliable but not guaranteed.
"""
+"Appliances": array:6 [ …6]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-374-4100"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 4
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-12-28T17:55:48.213340+00:00"
+"CumulativeDaysOnMarket": 1
+"DaysOnMarket": 84
+"ElementarySchool": "Lawrence Early Childhood-#4 School"
+"ElementarySchoolDistrict": "Lawrence"
+"ExpirationDate": "2026-04-30"
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "Lawrence Senior High School"
+"HighSchoolDistrict": "Lawrence"
+"InteriorFeatures": array:5 [ …5]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-374-4100"
+"ListAgentEmail": "chana@ftmr.com"
+"ListAgentKey": "326156415"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110921"
+"ListOfficePhone": "516-374-4100"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-12-28"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.3949
+"LotSizeDimensions": "122x143 IRR"
+"LotSizeSquareFeet": 17202
+"MajorChangeTimestamp": "2025-12-28T17:50:44Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "LAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS"
+"MiddleOrJuniorSchoolDistrict": "Lawrence"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2025-12-28"
+"OriginalEntryTimestamp": "2025-12-28T17:50:44Z"
+"OriginalListPrice": 2999999
+"OriginatingSystemModificationTimestamp": "2025-12-29T10:00:08Z"
+"OwnerName": "Furst"
+"ParcelNumber": "2089-39-242-00-0341-0"
+"ParkingFeatures": array:3 [ …3]
+"PatioAndPorchFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-12-28T17:52:36Z"
+"PhotosCount": 37
+"PoolFeatures": array:1 [ …1]
+"PoolPrivateYN": true
+"PostalCity": "Woodmere"
+"PostalCodePlus4": "2622"
+"RoomsTotal": "11"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-449-9692"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-12-28T17:50:44Z"
+"StreetName": "Linden"
+"StreetNumber": "136"
+"StreetNumberNumeric": "136"
+"StreetSuffix": "Street"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "22296.4"
+"TaxAssessedValue": 1308
+"TaxYear": "2025"
+"Utilities": array:3 [ …3]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Finished,Full"
+"KEY_TaxSource": "Municipality"
+"KEY_CurrentPrice": "2999999.00"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_LivingAreaSearchSqFt": "3115.00"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "963.08154"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "7596857.4323"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "963.08154"
+"KEY_SourceSystemModificationTimestamp": "2025-12-16T11:21:17.403"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "963.08154"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "963.08154"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422987481')"
+"provider_name": "One Key"
+"Media": array:37 [ …37]
+"ID": "29665"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4572
+post_id: "29598"
+post_author: 1
+"ListingKey": "KEY422982383"
+"ListingId": "944295"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2026-01-02T19:39:36Z"
+"RFModificationTimestamp": "2026-01-02T19:45:24Z"
+"ListPrice": 755000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1096.0
+"BuildingAreaTotal": 1096.0
+"City": "Hempstead"
+"PostalCode": "11580"
+"UnparsedAddress": "17 Laurel Place, Hempstead, New York 11580"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6716575
+"Longitude": -73.7258811
+"YearBuilt": 1941
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Roger Liu"
+"ListOfficeName": "Century Homes Realty Group LLC"
+"ListAgentMlsId": "200493"
+"ListOfficeMlsId": "DAER01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Recent Renovated Lovely Cape House on 5000 sqft lot. Situating at Cue-De-Sec road for privacy and quietness. Features 3 Bed 2 Full bath.OSE basement. Livingroom. Kitchen. Wet Bar. Family Room. New Gas Boiler. Laundry Room. Sunroom. Open backyard. Det Garage and Shed. Long Driveway. Leased Solar Panels cost $100 each month. All Information Is Deemed Reliable But Is Not Guaranteed. Buyer Is Advised To Verify The Accuracy Of All Information Independently."
+"Appliances": array:4 [ …4]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "718-886-6800"
+"Basement": array:4 [ …4]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-12-15T20:51:23.948283+00:00"
+"CumulativeDaysOnMarket": 8
+"DaysOnMarket": 8
+"ElementarySchool": "James A Dever School"
+"ElementarySchoolDistrict": "Valley Stream - 13"
+"ExpirationDate": "2026-05-15"
+"FireplacesTotal": "1"
+"Flooring": array:2 [ …2]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:2 [ …2]
+"HighSchool": "Valley Stream Central High School"
+"HighSchoolDistrict": "Valley Stream Central"
+"Inclusions": "Some Furnitures"
+"InteriorFeatures": array:4 [ …4]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "646-233-6608"
+"ListAgentEmail": "rogerliuhomes@gmail.com"
+"ListAgentKey": "326210023"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110648"
+"ListOfficePhone": "718-886-6800"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-12-15"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.1148
+"LotSizeSquareFeet": 5000
+"MajorChangeTimestamp": "2026-01-02T19:38:17Z"
+"MajorChangeType": "Hold"
+"MiddleOrJuniorSchool": "Valley Stream Memorial Junior High School"
+"MiddleOrJuniorSchoolDistrict": "Valley Stream Central"
+"MlsStatus": "Hold"
+"OffMarketDate": "2026-01-02"
+"OnMarketDate": "2025-12-15"
+"OriginalEntryTimestamp": "2025-12-15T20:45:53Z"
+"OriginalListPrice": 690000
+"OriginatingSystemModificationTimestamp": "2026-01-02T19:38:17Z"
+"OwnerName": "Tanvir Ahmed Chowdhury"
+"ParcelNumber": "2035-37-409-00-0168-0"
+"ParkingFeatures": array:2 [ …2]
+"ParkingTotal": "3"
+"PhotosChangeTimestamp": "2025-12-15T20:47:36Z"
+"PhotosCount": 30
+"PostalCity": "Valley Stream"
+"PostalCodePlus4": "4800"
+"PreviousListPrice": 690000
+"PriceChangeTimestamp": "2026-01-01T20:44:32Z"
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "646-233-6608"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-02T19:38:17Z"
+"StreetName": "Laurel"
+"StreetNumber": "17"
+"StreetNumberNumeric": "17"
+"StreetSuffix": "Place"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "11865.84"
+"TaxAssessedValue": 441
+"TaxYear": "2025"
+"Utilities": array:5 [ …5]
+"VirtualTourURLBranded": "https://youtu.be/r0ajlw7f0IA"
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Finished,Full,Walkup"
+"KEY_HoldDate": "2026-01-02"
+"KEY_TaxSource": "Other"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "755000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_AdditionalFeesYN": "1"
+"KEY_NumberOfKitchens": "1"
+"KEY_MlsMajorChangeType": "Temp Off Market"
+"KEY_AdditionalFeesAmount": "100.00"
+"KEY_LivingAreaSearchSqFt": "1096.00"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_AdditionalFeeFrequency": "Monthly"
+"KEY_AdditionalFeeDescription": "Solar Panels Leased"
+"KEY_RATIO_ListPrice_By_LivingArea": "688.86861"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6576655.0523"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "688.86861"
+"KEY_SourceSystemModificationTimestamp": "2025-12-15T15:45:09.817"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "688.86861"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.09420"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "688.86861"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422982383')"
+"provider_name": "One Key"
+"Media": array:30 [ …30]
+"ID": "29598"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4573
+post_id: "29683"
+post_author: 1
+"ListingKey": "KEY422982229"
+"ListingId": "944291"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-15T18:09:40Z"
+"RFModificationTimestamp": "2026-03-15T18:14:56Z"
+"ListPrice": 665000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1384.0
+"BuildingAreaTotal": 1384.0
+"City": "Hempstead"
+"PostalCode": "11510"
+"UnparsedAddress": "820 Jefferson Street, Hempstead, New York 11510"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 1926
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Todd A. Yovino"
+"ListOfficeName": "Island Advantage Realty LLC"
+"ListAgentMlsId": "9048648"
+"ListOfficeMlsId": "YOVI01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Spectacular Cape Cod-style home with an oversized garage, fresh landscaping, and remarkable updates featuring beautiful finishes and exceptional attention to detail. This property is where taste, comfort, affordability, and real value connect. Fantastic location providing ease of access to various area amenities. To help visualize this home's potential, yard photos were digitally enhanced."
+"Appliances": array:5 [ …5]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "631-351-6000"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-12-31T19:04:08.676205+00:00"
+"CrossStreet": "Verity Ln"
+"CumulativeDaysOnMarket": 74
+"DaysOnMarket": 81
+"Directions": "From Atlantic Ave turn onto Verity Ln, Turn left onto Jefferson St"
+"Disclosures": array:1 [ …1]
+"ElementarySchool": "Meadow Elementary School"
+"ElementarySchoolDistrict": "Baldwin"
+"ExpirationDate": "2026-03-29"
+"Flooring": array:2 [ …2]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:2 [ …2]
+"HighSchool": "Baldwin Senior High School"
+"HighSchoolDistrict": "Baldwin"
+"InteriorFeatures": array:4 [ …4]
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "631-351-6000"
+"ListAgentEmail": "todd@iarny.com"
+"ListAgentKey": "326258880"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326116614"
+"ListOfficePhone": "631-351-6000"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-12-30"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:2 [ …2]
+"LotSizeAcres": 0.1038
+"LotSizeDimensions": "40X113"
+"LotSizeSquareFeet": 4520
+"MajorChangeTimestamp": "2025-12-31T19:01:26Z"
+"MajorChangeType": "New Listing"
+"MiddleOrJuniorSchool": "Baldwin Middle School"
+"MiddleOrJuniorSchoolDistrict": "Baldwin"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OnMarketDate": "2025-12-31"
+"OriginalEntryTimestamp": "2025-12-31T19:01:26Z"
+"OriginalListPrice": 665000
+"OriginatingSystemModificationTimestamp": "2026-03-15T18:08:26Z"
+"OwnerName": "U S BANK TRUST NATIONAL ASSOCIATION & SC9 TITLE TR"
+"ParcelNumber": "2089-54-414-00-0008-0"
+"ParkingFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-12-31T19:02:36Z"
+"PhotosCount": 25
+"PostalCity": "Baldwin"
+"PostalCodePlus4": "4631"
+"PropertyCondition": array:1 [ …1]
+"RoomsTotal": "7"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "800-746-9464"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2025-12-31T19:01:26Z"
+"StreetName": "Jefferson"
+"StreetNumber": "820"
+"StreetNumberNumeric": "820"
+"StreetSuffix": "Street"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "10732.53"
+"TaxAssessedValue": 348
+"TaxBlock": "414"
+"TaxLot": "8"
+"TaxYear": "2025"
+"Utilities": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "None"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "54"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "665000.00"
+"KEY_OpenHouseCount": "5"
+"KEY_AdditionalRooms": "Dining Area"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "1"
+"KEY_MlsMajorChangeType": "New Listing"
+"KEY_LivingAreaSearchSqFt": "1384.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "480.49133"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6406551.0597"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "480.49133"
+"KEY_SourceSystemModificationTimestamp": "2025-12-15T15:35:59.080"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "480.49133"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "480.49133"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422982229')"
+"provider_name": "One Key"
+"Media": array:25 [ …25]
+"ID": "29683"
}
]
+success: true
+page_size: 6
+page_count: 294
+count: 1761
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=6&$skip=972&$filter=(StandardStatus in ('Active','Pending','Coming Soon','Hold','Expired') and ( City in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst') or PostalCity in ('East Rockaway','Lynbrook','Hewlett','Hewlett Harbor','Oceanside','Valley Stream','North Woodmere','Woodmere','Baldwin','Freeport','Malverne','Merrick','Bellmore','Cedarhurst','Lawrence')) and ListPrice le 5000000) and (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential'&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5094
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5077
+post_id: "28815"
+post_author: 1
+"ListingKey": "KEY422550913"
+"ListingId": "932006"
+"PropertyType": "Residential"
+"PropertySubType": "Stock Cooperative"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-01-13T07:05:38Z"
+"RFModificationTimestamp": "2026-01-13T07:11:07Z"
+"ListPrice": 139000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 300.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11598"
+"UnparsedAddress": "141 Woodmere Boulevard Unit 6c, Hempstead, New York 11598"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 1929
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Frank A. DeLucia"
+"ListOfficeName": "Coldwell Banker American Homes"
+"ListAgentMlsId": "5147"
+"ListOfficeMlsId": "BRMN14"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Top floor renovated studio in an elevator building—updated kitchen and bath.Steps from the LIRR"
+"Appliances": array:2 [ …2]
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [ …2]
+"AttributionContact": "516-665-2000"
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-522-4969"
+"BuyerAgentEmail": "jessica.hollenstein@elliman.com"
+"BuyerAgentFullName": "Jessica Hollenstein CBR RSPS SRS A"
+"BuyerAgentKey": "326188594"
+"BuyerAgentMlsId": "177938"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326110792"
+"BuyerOfficeMlsId": "DERE71"
+"BuyerOfficeName": "Douglas Elliman Real Estate"
+"BuyerOfficePhone": "516-669-3700"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-11-04T21:11:03.921580+00:00"
+"CumulativeDaysOnMarket": 69
+"DaysOnMarket": 69
+"Directions": "waze"
+"ElementarySchool": "Hewlett Elementary School"
+"ElementarySchoolDistrict": "Hewlett-Woodmere"
+"ExpirationDate": "2026-08-01"
+"Heating": array:1 [ …1]
+"HighSchool": "George W Hewlett High School"
+"HighSchoolDistrict": "Hewlett-Woodmere"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-578-2212"
+"ListAgentEmail": "fdelucia@cbamhomes.com"
+"ListAgentKey": "326240195"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109945"
+"ListOfficePhone": "516-665-2000"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-11-04"
+"LivingAreaSource": "Other"
+"MajorChangeTimestamp": "2026-01-12T20:17:27Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Woodmere Middle School"
+"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-01-12"
+"OnMarketDate": "2025-11-04"
+"OriginalEntryTimestamp": "2025-11-04T21:03:16Z"
+"OriginalListPrice": 139000
+"OriginatingSystemModificationTimestamp": "2026-01-12T20:17:27Z"
+"OwnerName": "Pfefferle"
+"ParkingFeatures": array:1 [ …1]
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-11-04T21:04:36Z"
+"PhotosCount": 19
+"PostalCity": "Woodmere"
+"PurchaseContractDate": "2026-01-12"
+"RoomsTotal": "1"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "5166652000"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-12T20:17:27Z"
+"StreetName": "Woodmere"
+"StreetNumber": "141"
+"StreetNumberNumeric": "141"
+"StreetSuffix": "Boulevard"
+"SyndicateTo": array:2 [ …2]
+"UnitNumber": "6C"
+"Utilities": array:6 [ …6]
+"WaterSource": array:1 [ …1]
+"KEY_FlipTaxYN": "0"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "139000.00"
+"KEY_ContractPrice": "134000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_RentingAllowedYN": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_ApprovalRequiredYN": "1"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_EstimatedMaintenance": "575"
+"KEY_LivingAreaSearchSqFt": "300.00"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_MinimumPctDownPayment": "20"
+"KEY_RATIO_ListPrice_By_LivingArea": "463.33333"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "463.33333"
+"KEY_SourceSystemModificationTimestamp": "2025-11-04T13:22:43.077"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422550913')"
+"provider_name": "One Key"
+"Media": array:19 [ …19]
+"ID": "28815"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4605
+post_id: "28819"
+post_author: 1
+"ListingKey": "KEY422550903"
+"ListingId": "932005"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-03-06T07:04:38Z"
+"RFModificationTimestamp": "2026-03-06T07:10:25Z"
+"ListPrice": 1649990.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3572.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11710"
+"UnparsedAddress": "2542 Lefferts Place, Hempstead, New York 11710"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6591335
+"Longitude": -73.5330645
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Stephanie B. Calinoff"
+"ListOfficeName": "Signature Premier Properties"
+"ListAgentMlsId": "9034066"
+"ListOfficeMlsId": "SPH05"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Discover an extraordinary expression of modern elegance at 2542 Lefferts Place, a newly built masterpiece offering the perfect blend of refined design, sophisticated craftsmanship, and exceptional functionality. With 5 bedrooms and 5 full bathrooms across three levels of curated luxury living, this residence delivers a lifestyle of ultimate comfort and style.\n
\n
\n
A grand foyer sets the tone, opening to a sun-drenched living space featuring an in-wall linear electric fireplace complemented by custom built-ins, creating a striking focal point for elevated gatherings. The showpiece chef’s kitchen impresses with custom illumination, high-end finishes, premium appliances, an expansive walk-in pantry, and a designer pass-through coffee bar / wet bar—perfect for effortless entertaining.\n
\n
Retreat to the lavish primary suite, offering boutique hotel ambiance with a spa-caliber ensuite, immense closet potential, and refined detailing throughout. Each secondary bedroom is generously scaled, with access to a beautifully appointed full bath.\n
\n
The fully finished lower level extends the home’s functionality with a spacious recreation area, full bath, and a private outside entrance, ideal for guest accommodations, a home theater, or multipurpose living.\n
\n
Outdoors, a tranquil setting provides space for future patio and landscape design—your vision, your sanctuary. \n
\n
*Flood Zone X- No Flood Required* Buyer is responsible to pay transfer tax, final survey and water tap fee.
"""
+"Appliances": array:6 [ …6]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-729-3717"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 5
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-729-3717"
+"BuyerAgentEmail": "scalinoff@signaturepremier.com"
+"BuyerAgentFullName": "Stephanie B. Calinoff"
+"BuyerAgentKey": "326257757"
+"BuyerAgentMlsId": "9034066"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326115713"
+"BuyerOfficeMlsId": "SPH05"
+"BuyerOfficeName": "Signature Premier Properties"
+"BuyerOfficePhone": "631-360-2800"
+"CoBuyerAgentAOR": "LIBOR"
+"CoBuyerAgentDirectPhone": "631-972-8030"
+"CoBuyerAgentEmail": "jmendola@signaturepremier.com"
+"CoBuyerAgentFullName": "Joseph Mendola"
+"CoBuyerAgentKey": "326219798"
+"CoBuyerAgentMlsId": "210536"
+"CoBuyerOfficeKey": "326115713"
+"CoBuyerOfficeMlsId": "SPH05"
+"CoBuyerOfficeName": "Signature Premier Properties"
+"CoBuyerOfficePhone": "631-360-2800"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "631-972-8030"
+"CoListAgentEmail": "jmendola@signaturepremier.com"
+"CoListAgentFullName": "Joseph Mendola"
+"CoListAgentKey": "326219798"
+"CoListAgentMlsId": "210536"
+"CoListOfficeKey": "326115713"
+"CoListOfficeMlsId": "SPH05"
+"CoListOfficeName": "Signature Premier Properties"
+"CoListOfficePhone": "631-360-2800"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-11-05T11:43:44.624879+00:00"
+"CrossStreet": "Frederick Court"
+"CumulativeDaysOnMarket": 120
+"DaysOnMarket": 120
+"Directions": "Merrick Rd West to Bellmore (Exit W6 W) left to Lefferts Place"
+"ElementarySchool": "Reinhard Early Childhood Center"
+"ElementarySchoolDistrict": "Bellmore"
+"ExpirationDate": "2026-05-05"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:3 [ …3]
+"HighSchool": "John F Kennedy High School"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-729-3717"
+"ListAgentEmail": "scalinoff@signaturepremier.com"
+"ListAgentKey": "326257757"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115713"
+"ListOfficePhone": "631-360-2800"
+"ListingAgreement": "Exclusive Agency"
+"ListingContractDate": "2025-11-05"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.1638
+"LotSizeSquareFeet": 7288
+"MajorChangeTimestamp": "2026-03-05T16:30:59Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Grand Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-03-05"
+"OnMarketDate": "2025-11-05"
+"OriginalEntryTimestamp": "2025-11-05T11:39:28Z"
+"OriginalListPrice": 1699990
+"OriginatingSystemModificationTimestamp": "2026-03-05T16:30:59Z"
+"OwnerName": "Gavork Holdings Llc"
+"ParcelNumber": "2089-63-052-00-1270-0"
+"ParkingFeatures": array:2 [ …2]
+"PhotosChangeTimestamp": "2025-11-05T11:40:36Z"
+"PhotosCount": 50
+"PostalCity": "Bellmore"
+"PostalCodePlus4": "4423"
+"PreviousListPrice": 1699990
+"PriceChangeTimestamp": "2026-01-22T19:50:42Z"
+"PurchaseContractDate": "2026-03-05"
+"RoomsTotal": "14"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "5167293717"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-03-05T16:30:59Z"
+"StreetName": "Lefferts"
+"StreetNumber": "2542"
+"StreetNumberNumeric": "2542"
+"StreetSuffix": "Place"
+"SyndicateTo": array:2 [ …2]
+"TaxAssessedValue": 538
+"TaxYear": "2025"
+"Utilities": array:4 [ …4]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Unfinished"
+"KEY_TaxSource": "Other"
+"KEY_CurrentPrice": "1649990.00"
+"KEY_ContractPrice": "1649990.00"
+"KEY_OpenHouseCount": "0"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "3572.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "461.92329"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "10073199.0232"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "461.92329"
+"KEY_SourceSystemModificationTimestamp": "2025-11-04T13:22:17.527"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.97059"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422550903')"
+"provider_name": "One Key"
+"Media": array:50 [ …50]
+"ID": "28819"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#317
+post_id: "29368"
+post_author: 1
+"ListingKey": "KEY422543688"
+"ListingId": "931785"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-03-21T07:03:40Z"
+"RFModificationTimestamp": "2026-03-21T07:08:27Z"
+"ListPrice": 689000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1719.0
+"BuildingAreaTotal": 5000.0
+"City": "Hempstead"
+"PostalCode": "11518"
+"UnparsedAddress": "12 Hewlett Point Avenue, Hempstead, New York 11518"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6351504
+"Longitude": -73.6692145
+"YearBuilt": 1927
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Claudia Felix de Souza"
+"ListOfficeName": "Coldwell Banker American Homes"
+"ListAgentMlsId": "195828"
+"ListOfficeMlsId": "BRMN04"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Beautifully updated home on a picturesque tree-lined street in East Rockaway. This move-in-ready residence features a spacious open floor plan, quartz countertops, crown molding, and brand-new stainless-steel appliances. Sunlight fills the home, creating a bright and inviting atmosphere throughout. A second-floor balcony overlooks the private backyard—perfect for relaxing or entertaining.\n
Located close to parks, schools, shopping, dining, and the East Rockaway LIRR station for an easy commute to Manhattan. Best of all, the property sits outside the flood zone, providing extra peace of mind—your new home awaits!
"""
+"Appliances": array:9 [ …9]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-302-8500"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-779-8423"
+"BuyerAgentEmail": "johngandolfosells@gmail.com"
+"BuyerAgentFullName": "John C. Gandolfo"
+"BuyerAgentKey": "326121593"
+"BuyerAgentMlsId": "105241"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326109936"
+"BuyerOfficeMlsId": "BRMN05"
+"BuyerOfficeName": "Coldwell Banker American Homes"
+"BuyerOfficePhone": "516-223-2525"
+"CoBuyerAgentAOR": "LIBOR"
+"CoBuyerAgentDirectPhone": "516-644-8097"
+"CoBuyerAgentEmail": "realtorgandolfo@aol.com"
+"CoBuyerAgentFullName": "Barbara L. Gandolfo"
+"CoBuyerAgentKey": "326249090"
+"CoBuyerAgentMlsId": "89085"
+"CoBuyerOfficeKey": "326109936"
+"CoBuyerOfficeMlsId": "BRMN05"
+"CoBuyerOfficeName": "Coldwell Banker American Homes"
+"CoBuyerOfficePhone": "516-223-2525"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-11-18T15:40:10.503744+00:00"
+"CumulativeDaysOnMarket": 104
+"DaysOnMarket": 104
+"ElementarySchool": "Centre Avenue Elementary School"
+"ElementarySchoolDistrict": "East Rockaway"
+"Exclusions": "None"
+"ExpirationDate": "2026-11-04"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "East Rockaway Junior-Senior High Sch"
+"HighSchoolDistrict": "East Rockaway"
+"InteriorFeatures": array:7 [ …7]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "347-526-2926"
+"ListAgentEmail": "clafelix@hotmail.com"
+"ListAgentKey": "326205528"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109935"
+"ListOfficePhone": "516-302-8500"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-11-17"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.11
+"LotSizeSquareFeet": 5000
+"MajorChangeTimestamp": "2026-03-20T18:00:45Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "East Rockaway Junior-Senior High Sch"
+"MiddleOrJuniorSchoolDistrict": "East Rockaway"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-03-20"
+"OnMarketDate": "2025-11-23"
+"OriginalEntryTimestamp": "2025-11-18T15:38:52Z"
+"OriginalListPrice": 677000
+"OriginatingSystemModificationTimestamp": "2026-03-20T18:00:45Z"
+"OwnerName": "Goncalves"
+"ParcelNumber": "2089-42-049-00-0101-0"
+"ParkingFeatures": array:3 [ …3]
+"PhotosChangeTimestamp": "2026-02-17T20:49:36Z"
+"PhotosCount": 20
+"PostalCity": "East Rockaway"
+"PreviousListPrice": 677000
+"PriceChangeTimestamp": "2026-02-17T20:51:21Z"
+"PurchaseContractDate": "2026-03-20"
+"RoomsTotal": "7"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "347-526-2926"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-03-20T18:00:45Z"
+"StreetName": "HewLett Point"
+"StreetNumber": "12"
+"StreetNumberNumeric": "12"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "14804.92"
+"TaxBlock": "049"
+"TaxLot": "101"
+"TaxYear": "2025"
+"Utilities": array:5 [ …5]
+"WaterSource": array:1 [ …1]
+"YearBuiltEffective": 1927
+"KEY_Attic": "Finished"
+"KEY_HoldDate": "2026-02-05"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "42"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "689000.00"
+"KEY_ContractPrice": "694000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_IncludedInTaxes": "Sewer"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "1719.00"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "516-302-8500"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "400.81443"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6263636.3636"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "400.81443"
+"KEY_SourceSystemModificationTimestamp": "2025-11-03T20:44:26.963"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "137.80000"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.01773"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "137.80000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422543688')"
+"provider_name": "One Key"
+"Media": array:20 [ …20]
+"ID": "29368"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5111
+post_id: "28803"
+post_author: 1
+"ListingKey": "KEY422535557"
+"ListingId": "931514"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-03-07T07:04:37Z"
+"RFModificationTimestamp": "2026-03-07T07:11:35Z"
+"ListPrice": 779000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1032.0
+"BuildingAreaTotal": 1032.0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "1531 Merrick Avenue, Hempstead, New York 11566"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6821226
+"Longitude": -73.559474
+"YearBuilt": 1952
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Edith Tesar"
+"ListOfficeName": "Coldwell Banker American Homes"
+"ListAgentMlsId": "502601"
+"ListOfficeMlsId": "BRMN05"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Charming Expanded 4-Bedroom Cape with Modern Updates and Prime Location\n
This beautifully maintained expanded Cape-style home offers a spacious and inviting layout perfect for both relaxing and entertaining. Step inside to a bright and airy living room, featuring hardwood floors and plenty of space for family gatherings. The dining area is ideal for both casual meals and formal dinners, and flows seamlessly into the renovated kitchen.\n
The kitchen is a highlight, featuring stainless steel appliances, sleek granite countertops, modern cabinetry, and recessed lighting. A door off the kitchen leads to the large backyard — a fantastic space for outdoor entertainment and summer BBQs.\n
The first floor includes one generous sized bedroom with ample closet space, and a stylishly updated full bathroom. Upstairs, you'll find three more large bedrooms, both with great closet storage, along with another fully renovated bathroom.\n
The full basement offers endless potential — use it as additional living space, a home gym, or storage, with the convenience of an on-site washer/dryer and utilities.\n
The exterior is just as appealing, with well-maintained landscaping, a charming attached 1-car garage, and a paver and cement driveway that adds to the home’s curb appeal. In addition, the house is equipped with a generator. New windows and siding done in September, 2025.\n
Perfectly situated close to transportation, schools, and shopping, this home offers both comfort and convenience. With its combination of classic Cape Cod charm and modern updates, this home is move-in ready and waiting for you to make it your own.
"""
+"Appliances": array:7 [ …7]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-223-2525"
+"Basement": array:3 [ …3]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "315-380-0336"
+"BuyerAgentEmail": "williamcheng7777777@gmail.com"
+"BuyerAgentFullName": "William Cheng"
+"BuyerAgentKey": "326214128"
+"BuyerAgentMlsId": "204694"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326111212"
+"BuyerOfficeMlsId": "ERLT01"
+"BuyerOfficeName": "E Realty International Corp"
+"BuyerOfficePhone": "718-886-8110"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-644-3929"
+"CoListAgentEmail": "dazzato@cbamhomes.com"
+"CoListAgentFullName": "Denise L. Azzato SFR"
+"CoListAgentKey": "326128345"
+"CoListAgentMlsId": "112444"
+"CoListOfficeKey": "326109936"
+"CoListOfficeMlsId": "BRMN05"
+"CoListOfficeName": "Coldwell Banker American Homes"
+"CoListOfficePhone": "516-223-2525"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"Country": "US"
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-11-03T19:16:08.674693+00:00"
+"CrossStreet": "Henry Road"
+"CumulativeDaysOnMarket": 109
+"DaysOnMarket": 109
+"Directions": "Southern State Parkway to Merrick Avenue, Follow GPS"
+"ElementarySchool": "Harold D Fayette School"
+"ElementarySchoolDistrict": "North Merrick"
+"ExpirationDate": "2026-04-29"
+"Flooring": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:2 [ …2]
+"HighSchool": "Sanford H Calhoun High School"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-382-2075"
+"ListAgentEmail": "etesar@cbamhomes.com"
+"ListAgentKey": "418404816"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109936"
+"ListOfficePhone": "516-223-2525"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-11-03"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:7 [ …7]
+"LotSizeAcres": 0.2044
+"LotSizeDimensions": "89 x 104"
+"LotSizeSquareFeet": 8904
+"MajorChangeTimestamp": "2026-03-06T17:12:41Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Merrick Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-03-06"
+"OnMarketDate": "2025-11-16"
+"OriginalEntryTimestamp": "2025-11-03T19:12:37Z"
+"OriginalListPrice": 779000
+"OriginatingSystemModificationTimestamp": "2026-03-06T17:12:41Z"
+"OwnerName": "1531 Merrick Ave Owners Llc"
+"ParcelNumber": "2089-56-247-00-0023-0"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "3"
+"PhotosChangeTimestamp": "2026-01-22T16:47:36Z"
+"PhotosCount": 24
+"PostalCity": "Merrick"
+"PostalCodePlus4": "1602"
+"PurchaseContractDate": "2026-03-05"
+"RoomsTotal": "7"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-223-2525"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-03-06T17:12:41Z"
+"StreetName": "Merrick"
+"StreetNumber": "1531"
+"StreetNumberNumeric": "1531"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "11352.47"
+"TaxAssessedValue": 399
+"TaxBlock": "247"
+"TaxLot": "23"
+"TaxYear": "2024"
+"Utilities": array:4 [ …4]
+"VirtualTourURLBranded": "https://studios.ingagere.com/1531-Merrick-Ave"
+"VirtualTourURLUnbranded": "https://studios.ingagere.com/1531-Merrick-Ave/idx"
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Crawl"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "56"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "779000.00"
+"KEY_ContractPrice": "745000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_MlsDistrictCode": "29"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "1032.00"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "516-382-2075"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "754.84496"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "3811154.5988"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "754.84496"
+"KEY_SourceSystemModificationTimestamp": "2025-11-03T12:27:31.720"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "754.84496"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "754.84496"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422535557')"
+"provider_name": "One Key"
+"Media": array:24 [ …24]
+"ID": "28803"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4567
+post_id: "29650"
+post_author: 1
+"ListingKey": "KEY422534245"
+"ListingId": "931469"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-01-29T07:04:43Z"
+"RFModificationTimestamp": "2026-01-29T07:08:36Z"
+"ListPrice": 1149888.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2388.0
+"BuildingAreaTotal": 2668.0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "3034 Bond Drive, Hempstead, New York 11566"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.641897
+"Longitude": -73.5499721
+"YearBuilt": 1964
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "William Ortiz"
+"ListOfficeName": "Redfin Real Estate"
+"ListAgentMlsId": "175529"
+"ListOfficeMlsId": "CNDE01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to 3034 Bond Drive, a beautifully updated Merrick gem showcasing a striking exterior with brick accents, manicured landscaping, and an inviting wide-open entry that sets the tone for the contemporary design within. This turn-key, move-in-ready home features high-end finishes throughout and an open, airy floorplan ideal for both everyday living and entertaining. The main level offers a floating living room with a dramatic dual staircase, a formal dining room perfect for gatherings, and a sunlit den with a convenient half bath. The updated eat-in kitchen impresses with quartz countertops, new stainless-steel appliances, and abundant custom cabinetry.\n
\n
The private quarters include a spacious primary suite highlighted by a spa-like primary bathroom featuring radiant heated floors and a luxurious steam shower, creating a true retreat. Three additional generously sized bedrooms offer excellent closet space, while a partial basement provides laundry and flexible storage options.\n
\n
Outside, enjoy a beautifully maintained backyard complete with an 18' retractable awning, brick and bluestone patio, and lush green space—perfect for relaxing or entertaining. Additional features include in-ground sprinklers, central air conditioning, and updated systems for year-round comfort.\n
\n
Ideally located in one of Merrick’s most sought-after neighborhoods near parks, shopping, dining, and top-rated schools, this exceptional contemporary home offers style, comfort, and convenience—just unpack and enjoy.
"""
+"Appliances": array:4 [ …4]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "631-337-8238"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-729-0419"
+"BuyerAgentEmail": "pam.miller827@gmail.com"
+"BuyerAgentFullName": "Pam E. Miller"
+"BuyerAgentKey": "326134317"
+"BuyerAgentMlsId": "118879"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326115717"
+"BuyerOfficeMlsId": "SPH09"
+"BuyerOfficeName": "Signature Premier Properties"
+"BuyerOfficePhone": "516-546-6300"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-12-23T16:41:33.661111+00:00"
+"CumulativeDaysOnMarket": 30
+"DaysOnMarket": 30
+"ElementarySchool": "Birch School"
+"ElementarySchoolDistrict": "Merrick"
+"ExpirationDate": "2026-06-30"
+"Flooring": array:1 [ …1]
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:3 [ …3]
+"HighSchool": "John F Kennedy High School"
+"HighSchoolDistrict": "Merrick"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "631-922-0560"
+"ListAgentEmail": "william.ortiz@redfin.com"
+"ListAgentKey": "326186387"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110429"
+"ListOfficePhone": "631-337-8238"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-12-23"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1816
+"LotSizeSquareFeet": 7910
+"MajorChangeTimestamp": "2026-01-29T01:05:24Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Merrick Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Merrick"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-01-28"
+"OnMarketDate": "2025-12-29"
+"OriginalEntryTimestamp": "2025-12-23T16:38:59Z"
+"OriginalListPrice": 1149888
+"OriginatingSystemModificationTimestamp": "2026-01-29T01:05:24Z"
+"OwnerName": "Glassman"
+"ParcelNumber": "2089-62-214-00-0041-0"
+"ParkingFeatures": array:3 [ …3]
+"PhotosChangeTimestamp": "2026-01-21T15:25:36Z"
+"PhotosCount": 28
+"PostalCity": "Merrick"
+"PostalCodePlus4": "5125"
+"PurchaseContractDate": "2026-01-28"
+"RoomsTotal": "8"
+"Sewer": array:1 [ …1]
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-29T01:05:24Z"
+"StreetName": "Bond"
+"StreetNumber": "3034"
+"StreetNumberNumeric": "3034"
+"StreetSuffix": "Drive"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "19468.47"
+"TaxAssessedValue": 723
+"TaxYear": "2024"
+"Utilities": array:1 [ …1]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "See Remarks"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "1149888.00"
+"KEY_ContractPrice": "1285000.00"
+"KEY_OpenHouseCount": "3"
+"KEY_PreviousStatus": "Active"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "2388.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "481.52764"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6331982.3789"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "481.52764"
+"KEY_SourceSystemModificationTimestamp": "2025-11-03T11:29:29.160"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "430.99250"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "430.99250"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422534245')"
+"provider_name": "One Key"
+"Media": array:28 [ …28]
+"ID": "29650"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4464
+post_id: "30388"
+post_author: 1
+"ListingKey": "KEY422532997"
+"ListingId": "931428"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2026-01-03T07:04:41Z"
+"RFModificationTimestamp": "2026-01-03T07:08:07Z"
+"ListPrice": 750000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1211.0
+"BuildingAreaTotal": 3800.0
+"City": "Hempstead"
+"PostalCode": "11559"
+"UnparsedAddress": "11 Bayview Avenue, Hempstead, New York 11559"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6348298
+"Longitude": -73.7436334
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Maira Gonzalez Padilla"
+"ListOfficeName": "Realty Connect USA LLC"
+"ListAgentMlsId": "208101"
+"ListOfficeMlsId": "RLLE02"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Welcome to this beautiful renovated bungalow-style home. This 3 Bedrooms and 2 Bathrooms home has been completely updated from top to bottom is Move-in- Ready. new roofing, new windows, New kitchen with stainless steel appliances, granite countertops, hardwood floors, laundry, this property is conveniently faced for privacy. Every detail of this home has been thoughtfully updated for modern comfort and style. Don't miss this special home."
+"Appliances": array:8 [ …8]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "mgonzalez@realtyconnectusa.com"
+"BathroomsFull": 2
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"Country": "US"
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-11-03T16:19:20.984284+00:00"
+"CrossStreet": "West Avenue"
+"CumulativeDaysOnMarket": 114
+"DaysOnMarket": 60
+"Directions": "West Avenue to Bayview Avenue"
+"ElementarySchool": "Lawrence Primary School-#2 School"
+"ElementarySchoolDistrict": "Lawrence"
+"ExpirationDate": "2026-11-01"
+"Fencing": array:2 [ …2]
+"Flooring": array:1 [ …1]
+"Heating": array:1 [ …1]
+"HighSchool": "Lawrence Senior High School"
+"HighSchoolDistrict": "Lawrence"
+"InteriorFeatures": array:8 [ …8]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-670-2739"
+"ListAgentEmail": "mgonzalez@realtyconnectusa.com"
+"ListAgentKey": "326217452"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115083"
+"ListOfficePhone": "516-714-3606"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-11-01"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:1 [ …1]
+"LotSizeAcres": 0.0872
+"LotSizeSquareFeet": 3800
+"MajorChangeTimestamp": "2026-01-02T17:54:47Z"
+"MajorChangeType": "Hold"
+"MiddleOrJuniorSchool": "LAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS"
+"MiddleOrJuniorSchoolDistrict": "Lawrence"
+"MlsStatus": "Hold"
+"OffMarketDate": "2026-01-02"
+"OnMarketDate": "2025-11-03"
+"OriginalEntryTimestamp": "2025-11-03T16:17:22Z"
+"OriginalListPrice": 750000
+"OriginatingSystemModificationTimestamp": "2026-01-02T17:54:47Z"
+"OwnerName": "Mk Best Remodeling Llc"
+"ParcelNumber": "2089-40-002-00-0104-0"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "2"
+"PhotosChangeTimestamp": "2025-11-03T16:18:36Z"
+"PhotosCount": 20
+"PostalCity": "Lawrence"
+"PropertyCondition": array:1 [ …1]
+"RoomsTotal": "6"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516 670-2739"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-02T17:54:47Z"
+"StreetName": "Bayview"
+"StreetNumber": "11"
+"StreetNumberNumeric": "11"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "10790.27"
+"TaxAssessedValue": 370
+"TaxBlock": "2"
+"TaxLot": "104"
+"TaxYear": "2024"
+"Utilities": array:6 [ …6]
+"WaterSource": array:1 [ …1]
+"YearBuiltEffective": 1991
+"KEY_Attic": "Dormer"
+"KEY_HoldDate": "2026-01-02"
+"KEY_TaxSource": "Municipality"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "750000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Temp Off Market"
+"KEY_LivingAreaSearchSqFt": "1211.00"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "619.32287"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "8600917.4312"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "619.32287"
+"KEY_SourceSystemModificationTimestamp": "2025-11-03T10:45:27.077"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "197.36842"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "197.36842"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422532997')"
+"provider_name": "One Key"
+"Media": array:20 [ …20]
+"ID": "30388"
}
]
+success: true
+page_size: 6
+page_count: 254
+count: 1524
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Cache Key: f5843cf25302553905eb00e2a7aa3f1465c591185faaf546129cf69f8351c17b" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5974
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5932
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY422550913"
+"ListingId": "932006"
+"PropertyType": "Residential"
+"PropertySubType": "Stock Cooperative"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-01-13T07:05:38Z"
+"RFModificationTimestamp": "2026-01-13T07:11:07Z"
+"ListPrice": 139000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 300.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11598"
+"UnparsedAddress": "141 Woodmere Boulevard Unit 6c, Hempstead, New York 11598"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.7092836
+"Longitude": -73.6230362
+"YearBuilt": 1929
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Frank A. DeLucia"
+"ListOfficeName": "Coldwell Banker American Homes"
+"ListAgentMlsId": "5147"
+"ListOfficeMlsId": "BRMN14"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": "Top floor renovated studio in an elevator building—updated kitchen and bath.Steps from the LIRR"
+"Appliances": array:2 [ …2]
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [ …2]
+"AttributionContact": "516-665-2000"
+"BathroomsFull": 1
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-522-4969"
+"BuyerAgentEmail": "jessica.hollenstein@elliman.com"
+"BuyerAgentFullName": "Jessica Hollenstein CBR RSPS SRS A"
+"BuyerAgentKey": "326188594"
+"BuyerAgentMlsId": "177938"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326110792"
+"BuyerOfficeMlsId": "DERE71"
+"BuyerOfficeName": "Douglas Elliman Real Estate"
+"BuyerOfficePhone": "516-669-3700"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-11-04T21:11:03.921580+00:00"
+"CumulativeDaysOnMarket": 69
+"DaysOnMarket": 69
+"Directions": "waze"
+"ElementarySchool": "Hewlett Elementary School"
+"ElementarySchoolDistrict": "Hewlett-Woodmere"
+"ExpirationDate": "2026-08-01"
+"Heating": array:1 [ …1]
+"HighSchool": "George W Hewlett High School"
+"HighSchoolDistrict": "Hewlett-Woodmere"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-578-2212"
+"ListAgentEmail": "fdelucia@cbamhomes.com"
+"ListAgentKey": "326240195"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109945"
+"ListOfficePhone": "516-665-2000"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-11-04"
+"LivingAreaSource": "Other"
+"MajorChangeTimestamp": "2026-01-12T20:17:27Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Woodmere Middle School"
+"MiddleOrJuniorSchoolDistrict": "Hewlett-Woodmere"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-01-12"
+"OnMarketDate": "2025-11-04"
+"OriginalEntryTimestamp": "2025-11-04T21:03:16Z"
+"OriginalListPrice": 139000
+"OriginatingSystemModificationTimestamp": "2026-01-12T20:17:27Z"
+"OwnerName": "Pfefferle"
+"ParkingFeatures": array:1 [ …1]
+"PetsAllowed": array:1 [ …1]
+"PhotosChangeTimestamp": "2025-11-04T21:04:36Z"
+"PhotosCount": 19
+"PostalCity": "Woodmere"
+"PurchaseContractDate": "2026-01-12"
+"RoomsTotal": "1"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "5166652000"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-01-12T20:17:27Z"
+"StreetName": "Woodmere"
+"StreetNumber": "141"
+"StreetNumberNumeric": "141"
+"StreetSuffix": "Boulevard"
+"SyndicateTo": array:2 [ …2]
+"UnitNumber": "6C"
+"Utilities": array:6 [ …6]
+"WaterSource": array:1 [ …1]
+"KEY_FlipTaxYN": "0"
+"KEY_ConcessionYN": "0"
+"KEY_CurrentPrice": "139000.00"
+"KEY_ContractPrice": "134000.00"
+"KEY_PreviousStatus": "Active"
+"KEY_RentingAllowedYN": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_ApprovalRequiredYN": "1"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_EstimatedMaintenance": "575"
+"KEY_LivingAreaSearchSqFt": "300.00"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_MinimumPctDownPayment": "20"
+"KEY_RATIO_ListPrice_By_LivingArea": "463.33333"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "463.33333"
+"KEY_SourceSystemModificationTimestamp": "2025-11-04T13:22:43.077"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422550913')"
+"provider_name": "One Key"
+"Media": array:19 [ …19]
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5918
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY422550903"
+"ListingId": "932005"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-03-06T07:04:38Z"
+"RFModificationTimestamp": "2026-03-06T07:10:25Z"
+"ListPrice": 1649990.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3572.0
+"BuildingAreaTotal": 0
+"City": "Hempstead"
+"PostalCode": "11710"
+"UnparsedAddress": "2542 Lefferts Place, Hempstead, New York 11710"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6591335
+"Longitude": -73.5330645
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Stephanie B. Calinoff"
+"ListOfficeName": "Signature Premier Properties"
+"ListAgentMlsId": "9034066"
+"ListOfficeMlsId": "SPH05"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Discover an extraordinary expression of modern elegance at 2542 Lefferts Place, a newly built masterpiece offering the perfect blend of refined design, sophisticated craftsmanship, and exceptional functionality. With 5 bedrooms and 5 full bathrooms across three levels of curated luxury living, this residence delivers a lifestyle of ultimate comfort and style.\n
\n
\n
A grand foyer sets the tone, opening to a sun-drenched living space featuring an in-wall linear electric fireplace complemented by custom built-ins, creating a striking focal point for elevated gatherings. The showpiece chef’s kitchen impresses with custom illumination, high-end finishes, premium appliances, an expansive walk-in pantry, and a designer pass-through coffee bar / wet bar—perfect for effortless entertaining.\n
\n
Retreat to the lavish primary suite, offering boutique hotel ambiance with a spa-caliber ensuite, immense closet potential, and refined detailing throughout. Each secondary bedroom is generously scaled, with access to a beautifully appointed full bath.\n
\n
The fully finished lower level extends the home’s functionality with a spacious recreation area, full bath, and a private outside entrance, ideal for guest accommodations, a home theater, or multipurpose living.\n
\n
Outdoors, a tranquil setting provides space for future patio and landscape design—your vision, your sanctuary. \n
\n
*Flood Zone X- No Flood Required* Buyer is responsible to pay transfer tax, final survey and water tap fee.
"""
+"Appliances": array:6 [ …6]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-729-3717"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 5
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-729-3717"
+"BuyerAgentEmail": "scalinoff@signaturepremier.com"
+"BuyerAgentFullName": "Stephanie B. Calinoff"
+"BuyerAgentKey": "326257757"
+"BuyerAgentMlsId": "9034066"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326115713"
+"BuyerOfficeMlsId": "SPH05"
+"BuyerOfficeName": "Signature Premier Properties"
+"BuyerOfficePhone": "631-360-2800"
+"CoBuyerAgentAOR": "LIBOR"
+"CoBuyerAgentDirectPhone": "631-972-8030"
+"CoBuyerAgentEmail": "jmendola@signaturepremier.com"
+"CoBuyerAgentFullName": "Joseph Mendola"
+"CoBuyerAgentKey": "326219798"
+"CoBuyerAgentMlsId": "210536"
+"CoBuyerOfficeKey": "326115713"
+"CoBuyerOfficeMlsId": "SPH05"
+"CoBuyerOfficeName": "Signature Premier Properties"
+"CoBuyerOfficePhone": "631-360-2800"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "631-972-8030"
+"CoListAgentEmail": "jmendola@signaturepremier.com"
+"CoListAgentFullName": "Joseph Mendola"
+"CoListAgentKey": "326219798"
+"CoListAgentMlsId": "210536"
+"CoListOfficeKey": "326115713"
+"CoListOfficeMlsId": "SPH05"
+"CoListOfficeName": "Signature Premier Properties"
+"CoListOfficePhone": "631-360-2800"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-11-05T11:43:44.624879+00:00"
+"CrossStreet": "Frederick Court"
+"CumulativeDaysOnMarket": 120
+"DaysOnMarket": 120
+"Directions": "Merrick Rd West to Bellmore (Exit W6 W) left to Lefferts Place"
+"ElementarySchool": "Reinhard Early Childhood Center"
+"ElementarySchoolDistrict": "Bellmore"
+"ExpirationDate": "2026-05-05"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:3 [ …3]
+"HighSchool": "John F Kennedy High School"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-729-3717"
+"ListAgentEmail": "scalinoff@signaturepremier.com"
+"ListAgentKey": "326257757"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326115713"
+"ListOfficePhone": "631-360-2800"
+"ListingAgreement": "Exclusive Agency"
+"ListingContractDate": "2025-11-05"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.1638
+"LotSizeSquareFeet": 7288
+"MajorChangeTimestamp": "2026-03-05T16:30:59Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Grand Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-03-05"
+"OnMarketDate": "2025-11-05"
+"OriginalEntryTimestamp": "2025-11-05T11:39:28Z"
+"OriginalListPrice": 1699990
+"OriginatingSystemModificationTimestamp": "2026-03-05T16:30:59Z"
+"OwnerName": "Gavork Holdings Llc"
+"ParcelNumber": "2089-63-052-00-1270-0"
+"ParkingFeatures": array:2 [ …2]
+"PhotosChangeTimestamp": "2025-11-05T11:40:36Z"
+"PhotosCount": 50
+"PostalCity": "Bellmore"
+"PostalCodePlus4": "4423"
+"PreviousListPrice": 1699990
+"PriceChangeTimestamp": "2026-01-22T19:50:42Z"
+"PurchaseContractDate": "2026-03-05"
+"RoomsTotal": "14"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "5167293717"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-03-05T16:30:59Z"
+"StreetName": "Lefferts"
+"StreetNumber": "2542"
+"StreetNumberNumeric": "2542"
+"StreetSuffix": "Place"
+"SyndicateTo": array:2 [ …2]
+"TaxAssessedValue": 538
+"TaxYear": "2025"
+"Utilities": array:4 [ …4]
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Unfinished"
+"KEY_TaxSource": "Other"
+"KEY_CurrentPrice": "1649990.00"
+"KEY_ContractPrice": "1649990.00"
+"KEY_OpenHouseCount": "0"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "3572.00"
+"KEY_NumberOfHeatingZones": "2"
+"KEY_OpenHousePublicCount": "0"
+"KEY_DownPaymentResourceYN": "0"
+"KEY_RATIO_ListPrice_By_LivingArea": "461.92329"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "10073199.0232"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "461.92329"
+"KEY_SourceSystemModificationTimestamp": "2025-11-04T13:22:17.527"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "0.97059"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422550903')"
+"provider_name": "One Key"
+"Media": array:50 [ …50]
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5553
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY422543688"
+"ListingId": "931785"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-03-21T07:03:40Z"
+"RFModificationTimestamp": "2026-03-21T07:08:27Z"
+"ListPrice": 689000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1719.0
+"BuildingAreaTotal": 5000.0
+"City": "Hempstead"
+"PostalCode": "11518"
+"UnparsedAddress": "12 Hewlett Point Avenue, Hempstead, New York 11518"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6351504
+"Longitude": -73.6692145
+"YearBuilt": 1927
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Claudia Felix de Souza"
+"ListOfficeName": "Coldwell Banker American Homes"
+"ListAgentMlsId": "195828"
+"ListOfficeMlsId": "BRMN04"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Beautifully updated home on a picturesque tree-lined street in East Rockaway. This move-in-ready residence features a spacious open floor plan, quartz countertops, crown molding, and brand-new stainless-steel appliances. Sunlight fills the home, creating a bright and inviting atmosphere throughout. A second-floor balcony overlooks the private backyard—perfect for relaxing or entertaining.\n
Located close to parks, schools, shopping, dining, and the East Rockaway LIRR station for an easy commute to Manhattan. Best of all, the property sits outside the flood zone, providing extra peace of mind—your new home awaits!
"""
+"Appliances": array:9 [ …9]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-302-8500"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 1
+"BuildingAreaSource": "Public Records"
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-779-8423"
+"BuyerAgentEmail": "johngandolfosells@gmail.com"
+"BuyerAgentFullName": "John C. Gandolfo"
+"BuyerAgentKey": "326121593"
+"BuyerAgentMlsId": "105241"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326109936"
+"BuyerOfficeMlsId": "BRMN05"
+"BuyerOfficeName": "Coldwell Banker American Homes"
+"BuyerOfficePhone": "516-223-2525"
+"CoBuyerAgentAOR": "LIBOR"
+"CoBuyerAgentDirectPhone": "516-644-8097"
+"CoBuyerAgentEmail": "realtorgandolfo@aol.com"
+"CoBuyerAgentFullName": "Barbara L. Gandolfo"
+"CoBuyerAgentKey": "326249090"
+"CoBuyerAgentMlsId": "89085"
+"CoBuyerOfficeKey": "326109936"
+"CoBuyerOfficeMlsId": "BRMN05"
+"CoBuyerOfficeName": "Coldwell Banker American Homes"
+"CoBuyerOfficePhone": "516-223-2525"
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-11-18T15:40:10.503744+00:00"
+"CumulativeDaysOnMarket": 104
+"DaysOnMarket": 104
+"ElementarySchool": "Centre Avenue Elementary School"
+"ElementarySchoolDistrict": "East Rockaway"
+"Exclusions": "None"
+"ExpirationDate": "2026-11-04"
+"FireplaceFeatures": array:1 [ …1]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:1 [ …1]
+"HighSchool": "East Rockaway Junior-Senior High Sch"
+"HighSchoolDistrict": "East Rockaway"
+"InteriorFeatures": array:7 [ …7]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "347-526-2926"
+"ListAgentEmail": "clafelix@hotmail.com"
+"ListAgentKey": "326205528"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109935"
+"ListOfficePhone": "516-302-8500"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-11-17"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.11
+"LotSizeSquareFeet": 5000
+"MajorChangeTimestamp": "2026-03-20T18:00:45Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "East Rockaway Junior-Senior High Sch"
+"MiddleOrJuniorSchoolDistrict": "East Rockaway"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-03-20"
+"OnMarketDate": "2025-11-23"
+"OriginalEntryTimestamp": "2025-11-18T15:38:52Z"
+"OriginalListPrice": 677000
+"OriginatingSystemModificationTimestamp": "2026-03-20T18:00:45Z"
+"OwnerName": "Goncalves"
+"ParcelNumber": "2089-42-049-00-0101-0"
+"ParkingFeatures": array:3 [ …3]
+"PhotosChangeTimestamp": "2026-02-17T20:49:36Z"
+"PhotosCount": 20
+"PostalCity": "East Rockaway"
+"PreviousListPrice": 677000
+"PriceChangeTimestamp": "2026-02-17T20:51:21Z"
+"PurchaseContractDate": "2026-03-20"
+"RoomsTotal": "7"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "347-526-2926"
+"ShowingRequirements": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-03-20T18:00:45Z"
+"StreetName": "HewLett Point"
+"StreetNumber": "12"
+"StreetNumberNumeric": "12"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "14804.92"
+"TaxBlock": "049"
+"TaxLot": "101"
+"TaxYear": "2025"
+"Utilities": array:5 [ …5]
+"WaterSource": array:1 [ …1]
+"YearBuiltEffective": 1927
+"KEY_Attic": "Finished"
+"KEY_HoldDate": "2026-02-05"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "42"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "689000.00"
+"KEY_ContractPrice": "694000.00"
+"KEY_WaterAccessYN": "0"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_IncludedInTaxes": "Sewer"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "1719.00"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "516-302-8500"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "400.81443"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "6263636.3636"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "400.81443"
+"KEY_SourceSystemModificationTimestamp": "2025-11-03T20:44:26.963"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "137.80000"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.01773"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "137.80000"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422543688')"
+"provider_name": "One Key"
+"Media": array:20 [ …20]
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5948
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY422535557"
+"ListingId": "931514"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-03-07T07:04:37Z"
+"RFModificationTimestamp": "2026-03-07T07:11:35Z"
+"ListPrice": 779000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1032.0
+"BuildingAreaTotal": 1032.0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "1531 Merrick Avenue, Hempstead, New York 11566"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.6821226
+"Longitude": -73.559474
+"YearBuilt": 1952
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Edith Tesar"
+"ListOfficeName": "Coldwell Banker American Homes"
+"ListAgentMlsId": "502601"
+"ListOfficeMlsId": "BRMN05"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Charming Expanded 4-Bedroom Cape with Modern Updates and Prime Location\n
This beautifully maintained expanded Cape-style home offers a spacious and inviting layout perfect for both relaxing and entertaining. Step inside to a bright and airy living room, featuring hardwood floors and plenty of space for family gatherings. The dining area is ideal for both casual meals and formal dinners, and flows seamlessly into the renovated kitchen.\n
The kitchen is a highlight, featuring stainless steel appliances, sleek granite countertops, modern cabinetry, and recessed lighting. A door off the kitchen leads to the large backyard — a fantastic space for outdoor entertainment and summer BBQs.\n
The first floor includes one generous sized bedroom with ample closet space, and a stylishly updated full bathroom. Upstairs, you'll find three more large bedrooms, both with great closet storage, along with another fully renovated bathroom.\n
The full basement offers endless potential — use it as additional living space, a home gym, or storage, with the convenience of an on-site washer/dryer and utilities.\n
The exterior is just as appealing, with well-maintained landscaping, a charming attached 1-car garage, and a paver and cement driveway that adds to the home’s curb appeal. In addition, the house is equipped with a generator. New windows and siding done in September, 2025.\n
Perfectly situated close to transportation, schools, and shopping, this home offers both comfort and convenience. With its combination of classic Cape Cod charm and modern updates, this home is move-in ready and waiting for you to make it your own.
"""
+"Appliances": array:7 [ …7]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "516-223-2525"
+"Basement": array:3 [ …3]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "315-380-0336"
+"BuyerAgentEmail": "williamcheng7777777@gmail.com"
+"BuyerAgentFullName": "William Cheng"
+"BuyerAgentKey": "326214128"
+"BuyerAgentMlsId": "204694"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326111212"
+"BuyerOfficeMlsId": "ERLT01"
+"BuyerOfficeName": "E Realty International Corp"
+"BuyerOfficePhone": "718-886-8110"
+"CoListAgentAOR": "LIBOR"
+"CoListAgentDirectPhone": "516-644-3929"
+"CoListAgentEmail": "dazzato@cbamhomes.com"
+"CoListAgentFullName": "Denise L. Azzato SFR"
+"CoListAgentKey": "326128345"
+"CoListAgentMlsId": "112444"
+"CoListOfficeKey": "326109936"
+"CoListOfficeMlsId": "BRMN05"
+"CoListOfficeName": "Coldwell Banker American Homes"
+"CoListOfficePhone": "516-223-2525"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"Country": "US"
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-11-03T19:16:08.674693+00:00"
+"CrossStreet": "Henry Road"
+"CumulativeDaysOnMarket": 109
+"DaysOnMarket": 109
+"Directions": "Southern State Parkway to Merrick Avenue, Follow GPS"
+"ElementarySchool": "Harold D Fayette School"
+"ElementarySchoolDistrict": "North Merrick"
+"ExpirationDate": "2026-04-29"
+"Flooring": array:1 [ …1]
+"GarageSpaces": "1"
+"GarageYN": true
+"Heating": array:2 [ …2]
+"HighSchool": "Sanford H Calhoun High School"
+"HighSchoolDistrict": "Bellmore-Merrick"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "516-382-2075"
+"ListAgentEmail": "etesar@cbamhomes.com"
+"ListAgentKey": "418404816"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326109936"
+"ListOfficePhone": "516-223-2525"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-11-03"
+"LivingAreaSource": "Public Records"
+"LotFeatures": array:7 [ …7]
+"LotSizeAcres": 0.2044
+"LotSizeDimensions": "89 x 104"
+"LotSizeSquareFeet": 8904
+"MajorChangeTimestamp": "2026-03-06T17:12:41Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Merrick Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Bellmore-Merrick"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-03-06"
+"OnMarketDate": "2025-11-16"
+"OriginalEntryTimestamp": "2025-11-03T19:12:37Z"
+"OriginalListPrice": 779000
+"OriginatingSystemModificationTimestamp": "2026-03-06T17:12:41Z"
+"OwnerName": "1531 Merrick Ave Owners Llc"
+"ParcelNumber": "2089-56-247-00-0023-0"
+"ParkingFeatures": array:1 [ …1]
+"ParkingTotal": "3"
+"PhotosChangeTimestamp": "2026-01-22T16:47:36Z"
+"PhotosCount": 24
+"PostalCity": "Merrick"
+"PostalCodePlus4": "1602"
+"PurchaseContractDate": "2026-03-05"
+"RoomsTotal": "7"
+"Sewer": array:1 [ …1]
+"ShowingContactPhone": "516-223-2525"
+"ShowingRequirements": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "NY"
+"StatusChangeTimestamp": "2026-03-06T17:12:41Z"
+"StreetName": "Merrick"
+"StreetNumber": "1531"
+"StreetNumberNumeric": "1531"
+"StreetSuffix": "Avenue"
+"SyndicateTo": array:2 [ …2]
+"TaxAnnualAmount": "11352.47"
+"TaxAssessedValue": 399
+"TaxBlock": "247"
+"TaxLot": "23"
+"TaxYear": "2024"
+"Utilities": array:4 [ …4]
+"VirtualTourURLBranded": "https://studios.ingagere.com/1531-Merrick-Ave"
+"VirtualTourURLUnbranded": "https://studios.ingagere.com/1531-Merrick-Ave/idx"
+"WaterSource": array:1 [ …1]
+"KEY_Attic": "Crawl"
+"KEY_TaxSource": "Municipality"
+"KEY_TaxSection": "56"
+"KEY_ConcessionYN": "1"
+"KEY_CurrentPrice": "779000.00"
+"KEY_ContractPrice": "745000.00"
+"KEY_OpenHouseCount": "1"
+"KEY_PreviousStatus": "Active"
+"KEY_ElectricCompany": "PSEG"
+"KEY_MlsDistrictCode": "29"
+"KEY_AdditionalFeesYN": "0"
+"KEY_NumberOfKitchens": "1"
+"KEY_ShowingTimeFlagYN": "0"
+"KEY_MlsMajorChangeType": "Pending"
+"KEY_LivingAreaSearchSqFt": "1032.00"
+"KEY_NumberOfHeatingZones": "1"
+"KEY_OpenHousePublicCount": "0"
+"KEY_ShowingContactPhone2": "516-382-2075"
+"KEY_DownPaymentResourceYN": "1"
+"KEY_RATIO_ListPrice_By_LivingArea": "754.84496"
+"KEY_RATIO_ListPrice_By_LotSizeAcres": "3811154.5988"
+"KEY_RATIO_CurrentPrice_By_LivingArea": "754.84496"
+"KEY_SourceSystemModificationTimestamp": "2025-11-03T12:27:31.720"
+"KEY_RATIO_ListPrice_By_BuildingAreaTotal": "754.84496"
+"KEY_RATIO_ListPrice_By_OriginalListPrice": "1.00000"
+"KEY_RATIO_CurrentPrice_By_BuildingAreaTotal": "754.84496"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('KEY422535557')"
+"provider_name": "One Key"
+"Media": array:24 [ …24]
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5950
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "KEY422534245"
+"ListingId": "931469"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-01-29T07:04:43Z"
+"RFModificationTimestamp": "2026-01-29T07:08:36Z"
+"ListPrice": 1149888.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2388.0
+"BuildingAreaTotal": 2668.0
+"City": "Hempstead"
+"PostalCode": "11566"
+"UnparsedAddress": "3034 Bond Drive, Hempstead, New York 11566"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.641897
+"Longitude": -73.5499721
+"YearBuilt": 1964
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "William Ortiz"
+"ListOfficeName": "Redfin Real Estate"
+"ListAgentMlsId": "175529"
+"ListOfficeMlsId": "CNDE01"
+"OriginatingSystemName": "OneKey"
+"PublicRemarks": """
Welcome to 3034 Bond Drive, a beautifully updated Merrick gem showcasing a striking exterior with brick accents, manicured landscaping, and an inviting wide-open entry that sets the tone for the contemporary design within. This turn-key, move-in-ready home features high-end finishes throughout and an open, airy floorplan ideal for both everyday living and entertaining. The main level offers a floating living room with a dramatic dual staircase, a formal dining room perfect for gatherings, and a sunlit den with a convenient half bath. The updated eat-in kitchen impresses with quartz countertops, new stainless-steel appliances, and abundant custom cabinetry.\n
\n
The private quarters include a spacious primary suite highlighted by a spa-like primary bathroom featuring radiant heated floors and a luxurious steam shower, creating a true retreat. Three additional generously sized bedrooms offer excellent closet space, while a partial basement provides laundry and flexible storage options.\n
\n
Outside, enjoy a beautifully maintained backyard complete with an 18' retractable awning, brick and bluestone patio, and lush green space—perfect for relaxing or entertaining. Additional features include in-ground sprinklers, central air conditioning, and updated systems for year-round comfort.\n
\n
Ideally located in one of Merrick’s most sought-after neighborhoods near parks, shopping, dining, and top-rated schools, this exceptional contemporary home offers style, comfort, and convenience—just unpack and enjoy.
"""
+"Appliances": array:4 [ …4]
+"ArchitecturalStyle": array:1 [ …1]
+"AttributionContact": "631-337-8238"
+"Basement": array:2 [ …2]
+"BasementYN": true
+"BathroomsFull": 2
+"BuildingAreaUnits": "Square Feet"
+"BuyerAgentAOR": "LIBOR"
+"BuyerAgentDirectPhone": "516-729-0419"
+"BuyerAgentEmail": "pam.miller827@gmail.com"
+"BuyerAgentFullName": "Pam E. Miller"
+"BuyerAgentKey": "326134317"
+"BuyerAgentMlsId": "118879"
+"BuyerOfficeAOR": "LIBOR"
+"BuyerOfficeKey": "326115717"
+"BuyerOfficeMlsId": "SPH09"
+"BuyerOfficeName": "Signature Premier Properties"
+"BuyerOfficePhone": "516-546-6300"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Nassau County"
+"CreationDate": "2025-12-23T16:41:33.661111+00:00"
+"CumulativeDaysOnMarket": 30
+"DaysOnMarket": 30
+"ElementarySchool": "Birch School"
+"ElementarySchoolDistrict": "Merrick"
+"ExpirationDate": "2026-06-30"
+"Flooring": array:1 [ …1]
+"GarageSpaces": "2"
+"GarageYN": true
+"Heating": array:3 [ …3]
+"HighSchool": "John F Kennedy High School"
+"HighSchoolDistrict": "Merrick"
+"InteriorFeatures": array:3 [ …3]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [ …1]
+"ListAOR": "LIBOR"
+"ListAgentAOR": "LIBOR"
+"ListAgentDirectPhone": "631-922-0560"
+"ListAgentEmail": "william.ortiz@redfin.com"
+"ListAgentKey": "326186387"
+"ListOfficeAOR": "LIBOR"
+"ListOfficeKey": "326110429"
+"ListOfficePhone": "631-337-8238"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-12-23"
+"LivingAreaSource": "Public Records"
+"LotSizeAcres": 0.1816
+"LotSizeSquareFeet": 7910
+"MajorChangeTimestamp": "2026-01-29T01:05:24Z"
+"MajorChangeType": "Pending"
+"MiddleOrJuniorSchool": "Merrick Avenue Middle School"
+"MiddleOrJuniorSchoolDistrict": "Merrick"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-01-28"
+"OnMarketDate": "2025-12-29"
+"OriginalEntryTimestamp": "2025-12-23T16:38:59Z"
+"OriginalListPrice": 1149888
+"OriginatingSystemModificationTimestamp": "2026-01-29T01:05:24Z"
+"OwnerName": "Glassman"
+"ParcelNumber": "2089-62-214-00-0041-0"
+"ParkingFeatures": array:3 [ …3]
+"PhotosChangeTimestamp": "2026-01-21T15:25:36Z"
+"PhotosCount": 28
+"PostalCity": "Merrick"
…41
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5952 …134}
]
+success: true
+page_size: 6
+page_count: 254
+count: 1524
+after_key: ""
}
]
]