Array
(
[RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=6&$skip=2058&$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 InternetEntireListingDisplayYN eq true&$expand=Media&$count=true] => Array
(
[RF Response] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse Object
(
[items] => Array
(
[0] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 31812
[post_author] => 1
[ListingKey] => KEY425554369
[ListingId] => 1016467
[PropertyType] => Residential
[PropertySubType] => Single Family Residence
[StandardStatus] => Pending
[ModificationTimestamp] => 2026-09-08T22:04:36Z
[RFModificationTimestamp] => 2026-09-08T22:06:06Z
[ListPrice] => 1299000
[BathroomsTotalInteger] => 4
[BathroomsHalf] => 2
[BedroomsTotal] => 8
[LotSizeArea] => 0
[LivingArea] => 2205
[BuildingAreaTotal] => 2205
[City] => Hempstead
[PostalCode] => 11559
[UnparsedAddress] => 227 Rockaway Turnpike, Hempstead, New York 11559
[Coordinates] => Array
(
[0] => -73.732747888987
[1] => 40.620087548613
)
[Latitude] => 40.620087548613
[Longitude] => -73.732747888987
[YearBuilt] => 1920
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => Lisa Scheininger
[ListOfficeName] => BH&G R E Realty Connect
[ListAgentMlsId] => 209670
[ListOfficeMlsId] => RLLE25
[OriginatingSystemName] => OneKey
[PublicRemarks] => Amazing opportunity to own a legal 2-family home in the desirable North Lawrence neighborhood! Situated on an oversized 8600 sq ft lot, this property has a large setback from the street, providing ample parking for multiple vehicles. The lower unit has an entry foyer, spacious living room, kitchen, 4 bedrooms and 1.5 baths. The upper unit has a kitchen, 1.5 baths and 4 bedrooms, with a living room that can function as a 5th bedroom. Shared access to a washer/ dryer for both units. Annual taxes only $8572. Come see it today!
[Appliances] => Array
(
[0] => Freezer
[1] => Range
[2] => Refrigerator
)
[ArchitecturalStyle] => Array
(
[0] => Other
)
[AttributionContact] => lscheininger@realtyconnectusa.com
[BathroomsFull] => 2
[BuildingAreaUnits] => Square Feet
[BuyerAgentAOR] => LIBOR
[BuyerAgentDirectPhone] => 516-884-6530
[BuyerAgentEmail] => lscheininger@realtyconnectusa.com
[BuyerAgentFullName] => Lisa Scheininger
[BuyerAgentKey] => 326218964
[BuyerAgentMlsId] => 209670
[BuyerOfficeAOR] => LIBOR
[BuyerOfficeKey] => 426552031
[BuyerOfficeMlsId] => RLLE25
[BuyerOfficeName] => BH&G R E Realty Connect
[BuyerOfficePhone] => 516-714-3606
[CoBuyerAgentAOR] => LIBOR
[CoBuyerAgentDirectPhone] => 516-524-8088
[CoBuyerAgentEmail] => judah.spector@gmail.com
[CoBuyerAgentFullName] => Judah Spector
[CoBuyerAgentKey] => 326183818
[CoBuyerAgentMlsId] => 172763
[CoBuyerOfficeKey] => 326115432
[CoBuyerOfficeMlsId] => SAYA01
[CoBuyerOfficeName] => All Going Realty LLC
[CoBuyerOfficePhone] => 516-206-2005
[CoListAgentAOR] => LIBOR
[CoListAgentDirectPhone] => 516-524-8088
[CoListAgentEmail] => judah.spector@gmail.com
[CoListAgentFullName] => Judah Spector
[CoListAgentKey] => 326183818
[CoListAgentMlsId] => 172763
[CoListOfficeKey] => 326115432
[CoListOfficeMlsId] => SAYA01
[CoListOfficeName] => All Going Realty LLC
[CoListOfficePhone] => 516-206-2005
[ConstructionMaterials] => Array
(
[0] => Advanced Framing Technique
)
[Cooling] => Array
(
[0] => Wall/Window Unit(s)
)
[CountyOrParish] => Nassau County
[CreationDate] => 2026-06-22T17:52:20.055155+00:00
[CumulativeDaysOnMarket] => 78
[DaysOnMarket] => 78
[ElementarySchool] => Lawrence Elementary School-Broadway
[ElementarySchoolDistrict] => Lawrence
[ExpirationDate] => 2026-12-17
[Heating] => Array
(
[0] => Natural Gas
)
[HighSchool] => Lawrence Senior High School
[HighSchoolDistrict] => Lawrence
[InteriorFeatures] => Array
(
[0] => First Floor Bedroom
[1] => First Floor Full Bath
)
[RFTransactionType] => For Sale
[InternetEntireListingDisplayYN] => 1
[ListAOR] => LIBOR
[ListAgentAOR] => LIBOR
[ListAgentDirectPhone] => 516-884-6530
[ListAgentEmail] => lscheininger@realtyconnectusa.com
[ListAgentKey] => 326218964
[ListOfficeAOR] => LIBOR
[ListOfficeKey] => 426552031
[ListOfficePhone] => 516-714-3606
[ListingAgreement] => Exclusive Right To Sell
[ListingContractDate] => 2026-06-21
[LivingAreaSource] => Public Records
[LotSizeAcres] => 0.1976
[LotSizeSquareFeet] => 8607
[MajorChangeTimestamp] => 2026-09-08T22:03:12Z
[MajorChangeType] => Pending
[MiddleOrJuniorSchool] => LAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS
[MiddleOrJuniorSchoolDistrict] => Lawrence
[MlgCanUse] => Array
(
[0] => IDX
)
[MlgCanView] => 1
[MlsStatus] => Pending
[OffMarketDate] => 2026-09-08
[OnMarketDate] => 2026-06-22
[OriginalEntryTimestamp] => 2026-06-22T17:46:57Z
[OriginalListPrice] => 1499000
[OriginatingSystemModificationTimestamp] => 2026-09-08T22:03:12Z
[OwnerName] => Daniel Vaturi & Frumit Birnbaum
[ParcelNumber] => 2089-40-034-00-0233-0
[ParkingFeatures] => Array
(
[0] => Driveway
)
[PhotosChangeTimestamp] => 2026-06-22T17:48:36Z
[PhotosCount] => 22
[PostalCity] => Lawrence
[PostalCodePlus4] => 1217
[PreviousListPrice] => 1499000
[PriceChangeTimestamp] => 2026-07-09T13:15:29Z
[PurchaseContractDate] => 2026-09-08
[RoomsTotal] => 11
[Sewer] => Array
(
[0] => Public Sewer
)
[ShowingRequirements] => Array
(
[0] => Appointment Only
[1] => Call Listing Agent
)
[SpecialListingConditions] => Array
(
[0] => None
)
[StateOrProvince] => NY
[StatusChangeTimestamp] => 2026-09-08T22:03:12Z
[StreetName] => Rockaway
[StreetNumber] => 227
[StreetNumberNumeric] => 227
[StreetSuffix] => Turnpike
[SyndicateTo] => Array
(
[0] => Realtor.com
[1] => OneKeyMLS.com
)
[TaxAnnualAmount] => 8572
[TaxYear] => 2026
[Utilities] => Array
(
[0] => Electricity Connected
[1] => Water Connected
)
[WaterSource] => Array
(
[0] => Public
)
[KEY_Attic] => Unfinished
[KEY_TaxSource] => Municipality
[KEY_ConcessionYN] => 0
[KEY_CurrentPrice] => 1299000.00
[KEY_ContractPrice] => 1175000.00
[KEY_PreviousStatus] => Active
[KEY_NumberOfKitchens] => 2
[KEY_ShowingTimeFlagYN] => 0
[KEY_MlsMajorChangeType] => Pending
[KEY_BuyerRepresentation] => Dual Agent
[KEY_LivingAreaSearchSqFt] => 2205.00
[KEY_DownPaymentResourceYN] => 0
[KEY_RATIO_ListPrice_By_LivingArea] => 589.11565
[KEY_RATIO_ListPrice_By_LotSizeAcres] => 6573886.6397
[KEY_RATIO_CurrentPrice_By_LivingArea] => 589.11565
[KEY_SourceSystemModificationTimestamp] => 2026-06-21T21:25:32.490
[KEY_RATIO_ListPrice_By_BuildingAreaTotal] => 589.11565
[KEY_RATIO_ListPrice_By_OriginalListPrice] => 0.86658
[KEY_RATIO_CurrentPrice_By_BuildingAreaTotal] => 589.11565
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425554369')
[provider_name] => One Key
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6a3975567367c706fddbbfd1
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/965fcacecd9accc4aff5d2a0f5fb3df3.webp
[MediaSize] => 264684
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/thumbnail-965fcacecd9accc4aff5d2a0f5fb3df3.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 800
[ResourceRecordKey] => 425554369
[ImageSizeDescription] => 1200x800
[MediaModificationTimestamp] => 2026-06-22T17:48:06.398Z
)
[1] => Array
(
[Order] => 1
[MediaKey] => 6a3975567367c706fddbbfd2
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/8966cb3f180d012a26a8b0cd9e95a707.webp
[MediaSize] => 295735
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/thumbnail-8966cb3f180d012a26a8b0cd9e95a707.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 826
[ResourceRecordKey] => 425554369
[ImageSizeDescription] => 1200x826
[MediaModificationTimestamp] => 2026-06-22T17:48:06.419Z
)
[2] => Array
(
[Order] => 2
[MediaKey] => 6a3975567367c706fddbbfd3
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/e997539915b7cb452dc090925659b5fa.webp
[MediaSize] => 272453
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/thumbnail-e997539915b7cb452dc090925659b5fa.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 800
[ResourceRecordKey] => 425554369
[ImageSizeDescription] => 1200x800
[MediaModificationTimestamp] => 2026-06-22T17:48:06.399Z
)
[3] => Array
(
[Order] => 3
[MediaKey] => 6a3975567367c706fddbbfd4
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/ac1857e9a67dc02db4ca5d224847a4a3.webp
[MediaSize] => 178728
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/thumbnail-ac1857e9a67dc02db4ca5d224847a4a3.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 800
[ResourceRecordKey] => 425554369
[ImageSizeDescription] => 1200x800
[MediaModificationTimestamp] => 2026-06-22T17:48:06.366Z
)
[4] => Array
(
[Order] => 4
[MediaKey] => 6a3975567367c706fddbbfd5
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/a7764e5dd42edc4916d8bf7ff9879c8f.webp
[MediaSize] => 99284
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/thumbnail-a7764e5dd42edc4916d8bf7ff9879c8f.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 800
[ResourceRecordKey] => 425554369
[ImageSizeDescription] => 1200x800
[MediaModificationTimestamp] => 2026-06-22T17:48:06.408Z
)
[5] => Array
(
[Order] => 5
[MediaKey] => 6a3975567367c706fddbbfd6
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/ff59750e9550c1ca8549f4919bb2d298.webp
[MediaSize] => 137922
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/thumbnail-ff59750e9550c1ca8549f4919bb2d298.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 800
[ResourceRecordKey] => 425554369
[ImageSizeDescription] => 1200x800
[MediaModificationTimestamp] => 2026-06-22T17:48:06.366Z
)
[6] => Array
(
[Order] => 6
[MediaKey] => 6a3975567367c706fddbbfd7
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/3d90ad0aca24d45c12c891c6d61dc639.webp
[MediaSize] => 140606
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/thumbnail-3d90ad0aca24d45c12c891c6d61dc639.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 800
[ResourceRecordKey] => 425554369
[ImageSizeDescription] => 1200x800
[MediaModificationTimestamp] => 2026-06-22T17:48:06.412Z
)
[7] => Array
(
[Order] => 7
[MediaKey] => 6a3975567367c706fddbbfd8
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/7b80bbc2da8249f00e8a5ee9d51b4074.webp
[MediaSize] => 147646
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/thumbnail-7b80bbc2da8249f00e8a5ee9d51b4074.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 800
[ResourceRecordKey] => 425554369
[ImageSizeDescription] => 1200x800
[MediaModificationTimestamp] => 2026-06-22T17:48:06.398Z
)
[8] => Array
(
[Order] => 8
[MediaKey] => 6a3975567367c706fddbbfd9
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/7be9068e11b1e34aa18712631712273c.webp
[MediaSize] => 96316
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/thumbnail-7be9068e11b1e34aa18712631712273c.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 904
[ResourceRecordKey] => 425554369
[ImageSizeDescription] => 1200x904
[MediaModificationTimestamp] => 2026-06-22T17:48:06.396Z
)
[9] => Array
(
[Order] => 9
[MediaKey] => 6a3975567367c706fddbbfda
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/bc3e5bf15c6ba42747468166ade147c0.webp
[MediaSize] => 151584
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/thumbnail-bc3e5bf15c6ba42747468166ade147c0.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 800
[ResourceRecordKey] => 425554369
[ImageSizeDescription] => 1200x800
[MediaModificationTimestamp] => 2026-06-22T17:48:06.387Z
)
[10] => Array
(
[Order] => 10
[MediaKey] => 6a3975567367c706fddbbfdb
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/2d2eec348f6e7e4c773b99f1c6245dff.webp
[MediaSize] => 161111
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/thumbnail-2d2eec348f6e7e4c773b99f1c6245dff.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 800
[ResourceRecordKey] => 425554369
[ImageSizeDescription] => 1200x800
[MediaModificationTimestamp] => 2026-06-22T17:48:06.393Z
)
[11] => Array
(
[Order] => 11
[MediaKey] => 6a3975567367c706fddbbfdc
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/772fc4bec95cf90654003b9be50c1c1b.webp
[MediaSize] => 272546
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/thumbnail-772fc4bec95cf90654003b9be50c1c1b.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 727
[ResourceRecordKey] => 425554369
[ImageSizeDescription] => 1200x727
[MediaModificationTimestamp] => 2026-06-22T17:48:06.359Z
)
[12] => Array
(
[Order] => 12
[MediaKey] => 6a3975567367c706fddbbfdd
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/5fa899b4890e346091e67f05465647ac.webp
[MediaSize] => 152237
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/thumbnail-5fa899b4890e346091e67f05465647ac.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 800
[ResourceRecordKey] => 425554369
[ImageSizeDescription] => 1200x800
[MediaModificationTimestamp] => 2026-06-22T17:48:06.366Z
)
[13] => Array
(
[Order] => 13
[MediaKey] => 6a3975567367c706fddbbfde
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/e485a3ccf5a4c08bb24030339b365301.webp
[MediaSize] => 143215
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/thumbnail-e485a3ccf5a4c08bb24030339b365301.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 800
[ResourceRecordKey] => 425554369
[ImageSizeDescription] => 1200x800
[MediaModificationTimestamp] => 2026-06-22T17:48:06.364Z
)
[14] => Array
(
[Order] => 14
[MediaKey] => 6a3975567367c706fddbbfdf
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/5475154a30e00138e5ac6f0642d927b6.webp
[MediaSize] => 132605
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/thumbnail-5475154a30e00138e5ac6f0642d927b6.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 800
[ResourceRecordKey] => 425554369
[ImageSizeDescription] => 1200x800
[MediaModificationTimestamp] => 2026-06-22T17:48:06.360Z
)
[15] => Array
(
[Order] => 15
[MediaKey] => 6a3975567367c706fddbbfe0
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/dbc13d269a1000e7598ee3384e75d5de.webp
[MediaSize] => 132128
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/thumbnail-dbc13d269a1000e7598ee3384e75d5de.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 800
[ResourceRecordKey] => 425554369
[ImageSizeDescription] => 1200x800
[MediaModificationTimestamp] => 2026-06-22T17:48:06.366Z
)
[16] => Array
(
[Order] => 16
[MediaKey] => 6a3975567367c706fddbbfe1
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/a600a8b0270856ef8575eba74dbae527.webp
[MediaSize] => 133254
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/thumbnail-a600a8b0270856ef8575eba74dbae527.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 800
[ResourceRecordKey] => 425554369
[ImageSizeDescription] => 1200x800
[MediaModificationTimestamp] => 2026-06-22T17:48:06.359Z
)
[17] => Array
(
[Order] => 17
[MediaKey] => 6a3975567367c706fddbbfe2
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/5dfa8ee62ba752b1fa091e9c4d5ef809.webp
[MediaSize] => 141442
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/thumbnail-5dfa8ee62ba752b1fa091e9c4d5ef809.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 800
[ResourceRecordKey] => 425554369
[ImageSizeDescription] => 1200x800
[MediaModificationTimestamp] => 2026-06-22T17:48:06.366Z
)
[18] => Array
(
[Order] => 18
[MediaKey] => 6a3975567367c706fddbbfe3
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/308ae70e85e5908614e5110bb29fe39d.webp
[MediaSize] => 130257
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/thumbnail-308ae70e85e5908614e5110bb29fe39d.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 800
[ResourceRecordKey] => 425554369
[ImageSizeDescription] => 1200x800
[MediaModificationTimestamp] => 2026-06-22T17:48:06.382Z
)
[19] => Array
(
[Order] => 19
[MediaKey] => 6a3975567367c706fddbbfe4
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/a4607d2a0c9a792d5eeda96c731cc880.webp
[MediaSize] => 107602
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/thumbnail-a4607d2a0c9a792d5eeda96c731cc880.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 800
[ResourceRecordKey] => 425554369
[ImageSizeDescription] => 1200x800
[MediaModificationTimestamp] => 2026-06-22T17:48:06.470Z
)
[20] => Array
(
[Order] => 20
[MediaKey] => 6a3975567367c706fddbbfe5
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/4cfd7b368496a74bc764277222447380.webp
[MediaSize] => 151481
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/thumbnail-4cfd7b368496a74bc764277222447380.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 800
[ResourceRecordKey] => 425554369
[ImageSizeDescription] => 1200x800
[MediaModificationTimestamp] => 2026-06-22T17:48:06.398Z
)
[21] => Array
(
[Order] => 21
[MediaKey] => 6a3975567367c706fddbbfe6
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/8c5fed1f00f64a43ede06eb4e0c84d01.webp
[MediaSize] => 165152
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425554369/thumbnail-8c5fed1f00f64a43ede06eb4e0c84d01.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 804
[ResourceRecordKey] => 425554369
[ImageSizeDescription] => 1200x804
[MediaModificationTimestamp] => 2026-06-22T17:48:06.408Z
)
)
[ID] => 31812
)
[1] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 31843
[post_author] => 1
[ListingKey] => KEY425553811
[ListingId] => 1016452
[PropertyType] => Residential
[PropertySubType] => Single Family Residence
[StandardStatus] => Active
[ModificationTimestamp] => 2026-09-11T20:22:36Z
[RFModificationTimestamp] => 2026-09-11T20:27:22Z
[ListPrice] => 799000
[BathroomsTotalInteger] => 3
[BathroomsHalf] => 0
[BedroomsTotal] => 4
[LotSizeArea] => 0
[LivingArea] => 2010
[BuildingAreaTotal] => 3132
[City] => Hempstead
[PostalCode] => 11572
[UnparsedAddress] => 3402 Elliott Boulevard, Hempstead, New York 11572
[Coordinates] => Array
(
[0] => -73.6571695
[1] => 40.6275443
)
[Latitude] => 40.6275443
[Longitude] => -73.6571695
[YearBuilt] => 1962
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => Sharon Basiratmand
[ListOfficeName] => Advocate Realty Group LLC
[ListAgentMlsId] => 221360
[ListOfficeMlsId] => AVCT01
[OriginatingSystemName] => OneKey
[PublicRemarks] => RARE OPPORTUNITY!! 3,910 square foot total living area waterview wide line ranch (2010 sq ft PLUS an additional 1900 Sqft on lower level ) on expansive 75 x 100 lot, located on a dead-end street, features 4 spacious bedrooms and 3 elegant bathrooms on the main floor, soaring high ceilings, skylights that flood the home with natural light, a designer eat-in kitchen with all brand-new appliances, and an attached 2-car garage. The private-entrance lower level feels like its own suite, complete with bedroom, full bath, kitchen, and expansive living space.
The main level of the home also boasts a spacious living room and dining area with a cozy stone fireplace, and sliding doors leading to a deck overlooking the water and a large yard. The fourth bedroom is a sunny and expansive private suite with high ceiling and skylights and includes a renovated full bath and large walk-in closet.
This is truly a one-of-a-kind opportunity combining a fully renovated home, massive finished lower level with full bath and bonus kitchen, and rare waterfront land for recreation.
[AdditionalParcelsYN] => 1
[Appliances] => Array
(
[0] => Dishwasher
[1] => Gas Oven
[2] => Stainless Steel Appliance(s)
[3] => Gas Water Heater
)
[ArchitecturalStyle] => Array
(
[0] => Exp Ranch
)
[Basement] => Array
(
[0] => Finished
[1] => Full
)
[BasementYN] => 1
[BathroomsFull] => 3
[BuildingAreaSource] => Cubi Casa
[BuildingAreaUnits] => Square Feet
[ConstructionMaterials] => Array
(
[0] => Advanced Framing Technique
)
[Cooling] => Array
(
[0] => Central Air
)
[CountyOrParish] => Nassau County
[CreationDate] => 2026-06-23T23:17:12.439226+00:00
[CumulativeDaysOnMarket] => 78
[DaysOnMarket] => 83
[ElementarySchool] => School 8
[ElementarySchoolDistrict] => Oceanside
[ExpirationDate] => 2026-10-15
[FireplaceYN] => 1
[FireplacesTotal] => 1
[GarageSpaces] => 2
[GarageYN] => 1
[Heating] => Array
(
[0] => Natural Gas
)
[HighSchool] => School 7-Oceanside Senior Hs
[HighSchoolDistrict] => Oceanside
[InteriorFeatures] => Array
(
[0] => First Floor Bedroom
[1] => Cathedral Ceiling(s)
[2] => High Ceilings
)
[RFTransactionType] => For Sale
[InternetEntireListingDisplayYN] => 1
[ListAOR] => LIBOR
[ListAgentAOR] => LIBOR
[ListAgentDirectPhone] => 516-717-8349
[ListAgentEmail] => sharon@advocaterealtyli.com
[ListAgentKey] => 326230297
[ListOfficeAOR] => LIBOR
[ListOfficeKey] => 424953230
[ListOfficePhone] => 516-717-8349
[ListingAgreement] => Exclusive Right To Sell
[ListingContractDate] => 2026-06-22
[LivingAreaSource] => Cubi Casa
[LotSizeAcres] => 0.1722
[LotSizeSquareFeet] => 7500
[MajorChangeTimestamp] => 2026-07-29T14:18:16Z
[MajorChangeType] => Price Change
[MiddleOrJuniorSchool] => School 9M-Oceanside Middle School
[MiddleOrJuniorSchoolDistrict] => Oceanside
[MlgCanUse] => Array
(
[0] => IDX
)
[MlgCanView] => 1
[MlsStatus] => Active
[OnMarketDate] => 2026-06-25
[OriginalEntryTimestamp] => 2026-06-23T23:11:47Z
[OriginalListPrice] => 887000
[OriginatingSystemModificationTimestamp] => 2026-09-11T20:21:24Z
[OwnerName] => Oceanside House Llc
[ParcelNumber] => 2089-43-215-00-0092-0
[ParkingFeatures] => Array
(
[0] => Driveway
[1] => Garage
[2] => On Street
)
[PhotosChangeTimestamp] => 2026-07-29T14:19:36Z
[PhotosCount] => 24
[PostalCity] => Oceanside
[PostalCodePlus4] => 3644
[PreviousListPrice] => 887000
[PriceChangeTimestamp] => 2026-07-29T14:18:16Z
[RoomsTotal] => 9
[Sewer] => Array
(
[0] => Public Sewer
)
[ShowingContactPhone] => 5167178349
[ShowingRequirements] => Array
(
[0] => Call Listing Agent
)
[SpecialListingConditions] => Array
(
[0] => None
)
[StateOrProvince] => NY
[StatusChangeTimestamp] => 2026-06-25T04:31:08Z
[StreetName] => Elliott
[StreetNumber] => 3402
[StreetNumberNumeric] => 3402
[StreetSuffix] => Boulevard
[SyndicateTo] => Array
(
[0] => Realtor.com
[1] => OneKeyMLS.com
)
[TaxAnnualAmount] => 15711
[TaxYear] => 2026
[Utilities] => Array
(
[0] => Electricity Connected
[1] => Natural Gas Connected
)
[WaterSource] => Array
(
[0] => Public
)
[WaterfrontFeatures] => Array
(
[0] => Bulkhead
[1] => Canal Access
[2] => Waterfront
)
[WaterfrontYN] => 1
[KEY_Attic] => Partial
[KEY_TaxSource] => Municipality
[KEY_ConcessionYN] => 0
[KEY_CurrentPrice] => 799000.00
[KEY_OpenHouseCount] => 1
[KEY_PreviousStatus] => Coming Soon
[KEY_ShowingTimeFlagYN] => 1
[KEY_MlsMajorChangeType] => Price Decrease
[KEY_LivingAreaSearchSqFt] => 2010.00
[KEY_OpenHousePublicCount] => 0
[KEY_DownPaymentResourceYN] => 1
[KEY_RATIO_ListPrice_By_LivingArea] => 397.51244
[KEY_RATIO_ListPrice_By_LotSizeAcres] => 4639953.5424
[KEY_RATIO_CurrentPrice_By_LivingArea] => 397.51244
[KEY_SourceSystemModificationTimestamp] => 2026-06-21T19:30:01.407
[KEY_RATIO_ListPrice_By_BuildingAreaTotal] => 255.10856
[KEY_RATIO_ListPrice_By_OriginalListPrice] => 0.90079
[KEY_RATIO_CurrentPrice_By_BuildingAreaTotal] => 255.10856
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425553811')
[provider_name] => One Key
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6a5642d310ae0c23c29b381c
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/9a35eb166f11b9b25e52fd666690a28e.webp
[MediaSize] => 259067
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-9a35eb166f11b9b25e52fd666690a28e.webp
[ImageWidth] => 1538
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1022
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 1538x1022
[MediaModificationTimestamp] => 2026-07-14T14:08:19.028Z
)
[1] => Array
(
[Order] => 1
[MediaKey] => 6a6a0bda9dfadaf0125aebc9
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/0dc89bc6f1c08858c56e7ad85fad01b6.webp
[MediaSize] => 160036
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-0dc89bc6f1c08858c56e7ad85fad01b6.webp
[ImageWidth] => 1024
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 681
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 1024x681
[MediaModificationTimestamp] => 2026-07-29T14:19:06.147Z
)
[2] => Array
(
[Order] => 2
[MediaKey] => 6a3e94ee5a39fed2374e26c5
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/97e1a7f302bfbf045a32204b86bed6ce.webp
[MediaSize] => 146812
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-97e1a7f302bfbf045a32204b86bed6ce.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1536
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 2048x1536
[MediaModificationTimestamp] => 2026-06-26T15:04:14.440Z
)
[3] => Array
(
[Order] => 3
[MediaKey] => 6a3b130bcdc4570a7db7487d
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/5d1bef3c873b2705755c094e179a3730.webp
[MediaSize] => 194127
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-5d1bef3c873b2705755c094e179a3730.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1363
[LongDescription] => Kitchen with high ceiling and skylights
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 2048x1363
[MediaModificationTimestamp] => 2026-06-23T23:13:14.961Z
)
[4] => Array
(
[Order] => 4
[MediaKey] => 6a3b130bcdc4570a7db7487e
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/59ed6a3a20a308e517fdcf0d291be56c.webp
[MediaSize] => 266727
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-59ed6a3a20a308e517fdcf0d291be56c.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1365
[LongDescription] => Kitchen
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 2048x1365
[MediaModificationTimestamp] => 2026-06-23T23:13:14.936Z
)
[5] => Array
(
[Order] => 5
[MediaKey] => 6a3b130bcdc4570a7db7487f
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/81e372602d990527c87016629b9a535a.webp
[MediaSize] => 207442
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-81e372602d990527c87016629b9a535a.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1363
[LongDescription] => Kitchen
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 2048x1363
[MediaModificationTimestamp] => 2026-06-23T23:13:14.960Z
)
[6] => Array
(
[Order] => 6
[MediaKey] => 6a3b130bcdc4570a7db74880
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/f7093654983111e60478c8559b8ec851.webp
[MediaSize] => 155764
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-f7093654983111e60478c8559b8ec851.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1364
[LongDescription] => First floor bath off dining area
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 2048x1364
[MediaModificationTimestamp] => 2026-06-23T23:13:14.940Z
)
[7] => Array
(
[Order] => 7
[MediaKey] => 6a3b130bcdc4570a7db74881
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/24b8538defb124d1027caf76f95e3339.webp
[MediaSize] => 234792
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-24b8538defb124d1027caf76f95e3339.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1363
[LongDescription] => Living Room
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 2048x1363
[MediaModificationTimestamp] => 2026-06-23T23:13:14.958Z
)
[8] => Array
(
[Order] => 8
[MediaKey] => 6a3b130bcdc4570a7db74882
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/4faa754da7fd6d51c4aae3d5dd2ec657.webp
[MediaSize] => 272212
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-4faa754da7fd6d51c4aae3d5dd2ec657.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1363
[LongDescription] => Living Room
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 2048x1363
[MediaModificationTimestamp] => 2026-06-23T23:13:14.944Z
)
[9] => Array
(
[Order] => 9
[MediaKey] => 6a3b130bcdc4570a7db74883
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/98e5a3c0c9db9f196fd6428f4ce9d6f6.webp
[MediaSize] => 230517
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-98e5a3c0c9db9f196fd6428f4ce9d6f6.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1364
[LongDescription] => Bedroom 3
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 2048x1364
[MediaModificationTimestamp] => 2026-06-23T23:13:15.007Z
)
[10] => Array
(
[Order] => 10
[MediaKey] => 6a3b130bcdc4570a7db74884
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/e94532d50a7931b52afd58bac3b21d52.webp
[MediaSize] => 190026
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-e94532d50a7931b52afd58bac3b21d52.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1364
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 2048x1364
[MediaModificationTimestamp] => 2026-06-23T23:13:14.945Z
)
[11] => Array
(
[Order] => 11
[MediaKey] => 6a3b130bcdc4570a7db74885
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/ba988536d75c60ed9182e6a3fbde7422.webp
[MediaSize] => 180898
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-ba988536d75c60ed9182e6a3fbde7422.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1364
[LongDescription] => Bedroom 2
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 2048x1364
[MediaModificationTimestamp] => 2026-06-23T23:13:14.950Z
)
[12] => Array
(
[Order] => 12
[MediaKey] => 6a3b130bcdc4570a7db74886
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/a23eee33c87826d2aa23e3571f8813c0.webp
[MediaSize] => 177829
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-a23eee33c87826d2aa23e3571f8813c0.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1365
[LongDescription] => Primary bedroom
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 2048x1365
[MediaModificationTimestamp] => 2026-06-23T23:13:14.962Z
)
[13] => Array
(
[Order] => 13
[MediaKey] => 6a3b130bcdc4570a7db74887
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/3b9be4deb5dd6ff823b4f75438d8d589.webp
[MediaSize] => 159107
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-3b9be4deb5dd6ff823b4f75438d8d589.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1364
[LongDescription] => En suite bath
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 2048x1364
[MediaModificationTimestamp] => 2026-06-23T23:13:14.936Z
)
[14] => Array
(
[Order] => 14
[MediaKey] => 6a3b130bcdc4570a7db74889
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/8a0a29a62f8684d0c22aae590423fa4a.webp
[MediaSize] => 109774
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-8a0a29a62f8684d0c22aae590423fa4a.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1363
[LongDescription] => Primary bedroom large closet
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 2048x1363
[MediaModificationTimestamp] => 2026-06-23T23:13:14.957Z
)
[15] => Array
(
[Order] => 15
[MediaKey] => 6a3b130bcdc4570a7db7488a
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/e67ba3b220d2b0dcaaa53683418f7c4b.webp
[MediaSize] => 211710
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-e67ba3b220d2b0dcaaa53683418f7c4b.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1364
[LongDescription] => Bedroom 4
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 2048x1364
[MediaModificationTimestamp] => 2026-06-23T23:13:14.977Z
)
[16] => Array
(
[Order] => 16
[MediaKey] => 6a3b130bcdc4570a7db7488b
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/038c672f1b50638748b01a54fbf6cb25.webp
[MediaSize] => 200048
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-038c672f1b50638748b01a54fbf6cb25.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1364
[LongDescription] => Basement
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 2048x1364
[MediaModificationTimestamp] => 2026-06-23T23:13:14.959Z
)
[17] => Array
(
[Order] => 17
[MediaKey] => 6a3b130bcdc4570a7db7488c
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/27ce831984ddfedddc73f1d0126dc489.webp
[MediaSize] => 191527
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-27ce831984ddfedddc73f1d0126dc489.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1363
[LongDescription] => Basement
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 2048x1363
[MediaModificationTimestamp] => 2026-06-23T23:13:14.972Z
)
[18] => Array
(
[Order] => 18
[MediaKey] => 6a3b130bcdc4570a7db7488d
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/3c1dae3b9b84d90c6b6b313884f65e35.webp
[MediaSize] => 174578
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-3c1dae3b9b84d90c6b6b313884f65e35.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1364
[LongDescription] => Basement back room
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 2048x1364
[MediaModificationTimestamp] => 2026-06-23T23:13:14.939Z
)
[19] => Array
(
[Order] => 19
[MediaKey] => 6a3b130bcdc4570a7db7488e
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/d6ceac3e64eefe42330d68699929a817.webp
[MediaSize] => 157521
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-d6ceac3e64eefe42330d68699929a817.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1363
[LongDescription] => Basement Back room with egress window
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 2048x1363
[MediaModificationTimestamp] => 2026-06-23T23:13:14.936Z
)
[20] => Array
(
[Order] => 20
[MediaKey] => 6a3b130bcdc4570a7db7488f
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/02b141a6da81fd5baa1092455d1b9a7a.webp
[MediaSize] => 141326
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-02b141a6da81fd5baa1092455d1b9a7a.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1361
[LongDescription] => Basement bathroom
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 2048x1361
[MediaModificationTimestamp] => 2026-06-23T23:13:14.973Z
)
[21] => Array
(
[Order] => 21
[MediaKey] => 6a3b130bcdc4570a7db74890
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/8c873fca3c2e1c061417b6c9fdc1870b.webp
[MediaSize] => 159565
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-8c873fca3c2e1c061417b6c9fdc1870b.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1363
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 2048x1363
[MediaModificationTimestamp] => 2026-06-23T23:13:14.963Z
)
[22] => Array
(
[Order] => 22
[MediaKey] => 6a3b130bcdc4570a7db74891
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/9eb8002e91172e426b8ac9b8c923ccdd.webp
[MediaSize] => 406219
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-9eb8002e91172e426b8ac9b8c923ccdd.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1365
[LongDescription] => Utility room
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 2048x1365
[MediaModificationTimestamp] => 2026-06-23T23:13:14.997Z
)
[23] => Array
(
[Order] => 23
[MediaKey] => 6a3b130bcdc4570a7db74892
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/c4eb543e4324c067877c3beb02648277.webp
[MediaSize] => 648766
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425553811/thumbnail-c4eb543e4324c067877c3beb02648277.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1360
[LongDescription] => Yard
[ResourceRecordKey] => 425553811
[ImageSizeDescription] => 2048x1360
[MediaModificationTimestamp] => 2026-06-23T23:13:14.969Z
)
)
[ID] => 31843
)
[2] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 31816
[post_author] => 1
[ListingKey] => KEY425549115
[ListingId] => 1016326
[PropertyType] => Residential
[PropertySubType] => Single Family Residence
[StandardStatus] => Hold
[ModificationTimestamp] => 2026-08-24T07:07:38Z
[RFModificationTimestamp] => 2026-08-24T07:09:27Z
[ListPrice] => 620000
[BathroomsTotalInteger] => 2
[BathroomsHalf] => 0
[BedroomsTotal] => 3
[LotSizeArea] => 0
[LivingArea] => 576
[BuildingAreaTotal] => 576
[City] => Hempstead
[PostalCode] => 11580
[UnparsedAddress] => 375 W Valley Stream Blvd., Hempstead, New York 11580
[Coordinates] => Array
(
[0] => -73.7133216
[1] => 40.6659148
)
[Latitude] => 40.6659148
[Longitude] => -73.7133216
[YearBuilt] => 1928
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => Erica Lewis
[ListOfficeName] => Landmark Elite Homes Corp
[ListAgentMlsId] => 222451
[ListOfficeMlsId] => LNDK01
[OriginatingSystemName] => OneKey
[PublicRemarks] => Welcome to this charming 3-bedroom, 2-bathroom home located in the Village of Valley Stream, NY, offering comfort and endless possibilities. This inviting residence features gleaming hardwood floors, open-concept living room, eat-in-kitchen and a walk-up attic.
Conveniently located minutes from Green Acres Mall, restaurants, shopping, parks, hospitals, colleges, major roadways, and the Long Island Rail Road. Enjoy the convenience of suburban living with close proximity to New York City, making commuting and everyday amenities easily accessible.
This home offers a great opportunity to enjoy the convenience of Valley Stream living with access to all that Long Island has to offer.
[Appliances] => Array
(
[0] => Dishwasher
[1] => Dryer
[2] => Gas Range
[3] => Oven
[4] => Range
[5] => Refrigerator
[6] => Washer
[7] => Gas Water Heater
)
[ArchitecturalStyle] => Array
(
[0] => Cape Cod
)
[AttributionContact] => 347-569-5176
[Basement] => Array
(
[0] => Finished
[1] => Walk-Out Access
)
[BasementYN] => 1
[BathroomsFull] => 2
[BuildingAreaUnits] => Square Feet
[ConstructionMaterials] => Array
(
[0] => Frame
)
[Cooling] => Array
(
[0] => Wall/Window Unit(s)
)
[CountyOrParish] => Nassau County
[CreationDate] => 2026-06-22T19:08:20.381502+00:00
[CrossStreet] => S Central Avenue
[CumulativeDaysOnMarket] => 62
[DaysOnMarket] => 62
[Directions] => Off S. Central Avenue or use GPS.
[ElementarySchool] => Clearstream Avenue School
[ElementarySchoolDistrict] => Valley Stream - 30
[ExpirationDate] => 2026-12-18
[Flooring] => Array
(
[0] => Hardwood
)
[Heating] => Array
(
[0] => Natural Gas
[1] => Other
)
[HighSchool] => Valley Stream Central High School
[HighSchoolDistrict] => Valley Stream Central
[InteriorFeatures] => Array
(
[0] => First Floor Bedroom
[1] => First Floor Full Bath
[2] => Ceiling Fan(s)
[3] => Other
[4] => Primary Bathroom
[5] => Washer/Dryer Hookup
)
[RFTransactionType] => For Sale
[InternetEntireListingDisplayYN] => 1
[ListAOR] => LIBOR
[ListAgentAOR] => LIBOR
[ListAgentDirectPhone] => 631-526-8143
[ListAgentEmail] => ericalewis001@gmail.com
[ListAgentKey] => 326231349
[ListOfficeAOR] => LIBOR
[ListOfficeKey] => 406375201
[ListOfficePhone] => 347-569-5176
[ListingAgreement] => Exclusive Right To Sell
[ListingContractDate] => 2026-06-19
[LivingAreaSource] => Public Records
[LotSizeAcres] => 0.0918
[LotSizeSquareFeet] => 4000
[MajorChangeTimestamp] => 2026-08-23T15:59:25Z
[MajorChangeType] => Hold
[MiddleOrJuniorSchool] => Valley Stream Memorial Junior High School
[MiddleOrJuniorSchoolDistrict] => Valley Stream Central
[MlgCanUse] => Array
(
[0] => BO
[1] => PT
[2] => VOW
)
[MlsStatus] => Hold
[OffMarketDate] => 2026-08-23
[OnMarketDate] => 2026-06-22
[OriginalEntryTimestamp] => 2026-06-22T19:01:26Z
[OriginalListPrice] => 650000
[OriginatingSystemModificationTimestamp] => 2026-08-23T15:59:25Z
[OwnerName] => Mc Lennon
[ParcelNumber] => 2035-37-363-00-0065-0
[ParkingFeatures] => Array
(
[0] => Driveway
[1] => Private
)
[PhotosChangeTimestamp] => 2026-07-08T15:04:36Z
[PhotosCount] => 17
[PostalCity] => Valley Stream
[PostalCodePlus4] => 5228
[PreviousListPrice] => 650000
[PriceChangeTimestamp] => 2026-07-08T19:53:14Z
[RoomsTotal] => 6
[Sewer] => Array
(
[0] => Public Sewer
)
[ShowingContactPhone] => 6315268143
[ShowingRequirements] => Array
(
[0] => 24 Hour Notice
[1] => Appointment Only
[2] => Occupied
)
[SpecialListingConditions] => Array
(
[0] => None
)
[StateOrProvince] => NY
[StatusChangeTimestamp] => 2026-08-23T15:59:25Z
[StreetDirPrefix] => W
[StreetName] => Valley Stream
[StreetNumber] => 375
[StreetNumberNumeric] => 375
[StreetSuffix] => Boulevard
[SyndicateTo] => Array
(
[0] => Realtor.com
[1] => OneKeyMLS.com
)
[TaxAnnualAmount] => 9500
[TaxYear] => 2026
[Utilities] => Array
(
[0] => Electricity Connected
[1] => Natural Gas Connected
[2] => Sewer Connected
[3] => Water Connected
)
[WaterSource] => Array
(
[0] => Public
)
[KEY_Attic] => Stairs,Walkup
[KEY_Village] => Valley Stream
[KEY_HoldDate] => 2026-08-23
[KEY_TaxSource] => Municipality
[KEY_CurrentPrice] => 620000.00
[KEY_PreviousStatus] => Active
[KEY_ElectricCompany] => PSEG
[KEY_ShowingTimeFlagYN] => 0
[KEY_MlsMajorChangeType] => Temp Off Market
[KEY_LivingAreaSearchSqFt] => 576.00
[KEY_DownPaymentResourceYN] => 1
[KEY_RATIO_ListPrice_By_LivingArea] => 1076.38889
[KEY_RATIO_ListPrice_By_LotSizeAcres] => 6753812.6362
[KEY_RATIO_CurrentPrice_By_LivingArea] => 1076.38889
[KEY_SourceSystemModificationTimestamp] => 2026-06-20T18:59:19.267
[KEY_RATIO_ListPrice_By_BuildingAreaTotal] => 1076.38889
[KEY_RATIO_ListPrice_By_OriginalListPrice] => 0.95385
[KEY_RATIO_CurrentPrice_By_BuildingAreaTotal] => 1076.38889
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425549115')
[provider_name] => One Key
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6a39884c12f7d7df3935a080
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/3fbfb31c72ec3761216e72186ef523e7.webp
[MediaSize] => 615658
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/thumbnail-3fbfb31c72ec3761216e72186ef523e7.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1536
[ResourceRecordKey] => 425549115
[ImageSizeDescription] => 2048x1536
[MediaModificationTimestamp] => 2026-06-22T19:09:00.947Z
)
[1] => Array
(
[Order] => 1
[MediaKey] => 6a3986c381078884cf86ad63
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/ccdb6d9f75d62f36df690872a6b97382.webp
[MediaSize] => 106962
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/thumbnail-ccdb6d9f75d62f36df690872a6b97382.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 900
[ResourceRecordKey] => 425549115
[ImageSizeDescription] => 1200x900
[MediaModificationTimestamp] => 2026-06-22T19:02:27.765Z
)
[2] => Array
(
[Order] => 2
[MediaKey] => 6a3986c381078884cf86ad64
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/817ef3037efb2ff619e2ec7dbcc8ebab.webp
[MediaSize] => 99419
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/thumbnail-817ef3037efb2ff619e2ec7dbcc8ebab.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 900
[ResourceRecordKey] => 425549115
[ImageSizeDescription] => 1200x900
[MediaModificationTimestamp] => 2026-06-22T19:02:27.752Z
)
[3] => Array
(
[Order] => 3
[MediaKey] => 6a3986c381078884cf86ad65
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/c37b8f91e6e76a7177e9f8ac9e4058be.webp
[MediaSize] => 127225
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/thumbnail-c37b8f91e6e76a7177e9f8ac9e4058be.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 900
[ResourceRecordKey] => 425549115
[ImageSizeDescription] => 1200x900
[MediaModificationTimestamp] => 2026-06-22T19:02:27.750Z
)
[4] => Array
(
[Order] => 4
[MediaKey] => 6a3986c381078884cf86ad66
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/2719145448431c8c7c1fc4801d192ee6.webp
[MediaSize] => 118625
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/thumbnail-2719145448431c8c7c1fc4801d192ee6.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 900
[ResourceRecordKey] => 425549115
[ImageSizeDescription] => 1200x900
[MediaModificationTimestamp] => 2026-06-22T19:02:27.787Z
)
[5] => Array
(
[Order] => 5
[MediaKey] => 6a3986c381078884cf86ad67
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/514b932fc9110108e2ed676571036298.webp
[MediaSize] => 125791
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/thumbnail-514b932fc9110108e2ed676571036298.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 900
[ResourceRecordKey] => 425549115
[ImageSizeDescription] => 1200x900
[MediaModificationTimestamp] => 2026-06-22T19:02:27.765Z
)
[6] => Array
(
[Order] => 6
[MediaKey] => 6a3986c381078884cf86ad68
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/cc28f4e9ab16e506cc3ca5e39c656720.webp
[MediaSize] => 92970
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/thumbnail-cc28f4e9ab16e506cc3ca5e39c656720.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 900
[ResourceRecordKey] => 425549115
[ImageSizeDescription] => 1200x900
[MediaModificationTimestamp] => 2026-06-22T19:02:27.758Z
)
[7] => Array
(
[Order] => 7
[MediaKey] => 6a3986c381078884cf86ad69
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/fd5f48ee41b4da8886dc3d8dc40fb357.webp
[MediaSize] => 126728
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/thumbnail-fd5f48ee41b4da8886dc3d8dc40fb357.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 900
[ResourceRecordKey] => 425549115
[ImageSizeDescription] => 1200x900
[MediaModificationTimestamp] => 2026-06-22T19:02:27.760Z
)
[8] => Array
(
[Order] => 8
[MediaKey] => 6a3986c381078884cf86ad6a
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/0fc2ed04e30fc98f6d7d788d4cc3f453.webp
[MediaSize] => 78348
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/thumbnail-0fc2ed04e30fc98f6d7d788d4cc3f453.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 900
[ResourceRecordKey] => 425549115
[ImageSizeDescription] => 1200x900
[MediaModificationTimestamp] => 2026-06-22T19:02:27.746Z
)
[9] => Array
(
[Order] => 9
[MediaKey] => 6a3986c381078884cf86ad6b
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/abc6f38188c468cbb6785a7897635de1.webp
[MediaSize] => 86962
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/thumbnail-abc6f38188c468cbb6785a7897635de1.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 900
[ResourceRecordKey] => 425549115
[ImageSizeDescription] => 1200x900
[MediaModificationTimestamp] => 2026-06-22T19:02:27.754Z
)
[10] => Array
(
[Order] => 10
[MediaKey] => 6a39884c12f7d7df3935a081
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/c3e1fea8c5461aac15214f3e341d0e39.webp
[MediaSize] => 232585
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/thumbnail-c3e1fea8c5461aac15214f3e341d0e39.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1535
[ResourceRecordKey] => 425549115
[ImageSizeDescription] => 2048x1535
[MediaModificationTimestamp] => 2026-06-22T19:09:00.916Z
)
[11] => Array
(
[Order] => 11
[MediaKey] => 6a3986c381078884cf86ad6c
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/591d0e3cfcc136da5bfc420a4c967424.webp
[MediaSize] => 128283
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/thumbnail-591d0e3cfcc136da5bfc420a4c967424.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 900
[ResourceRecordKey] => 425549115
[ImageSizeDescription] => 1200x900
[MediaModificationTimestamp] => 2026-06-22T19:02:27.752Z
)
[12] => Array
(
[Order] => 12
[MediaKey] => 6a3986c381078884cf86ad6d
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/9c963cf826974738643f8ab8f8954d46.webp
[MediaSize] => 97313
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/thumbnail-9c963cf826974738643f8ab8f8954d46.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 900
[ResourceRecordKey] => 425549115
[ImageSizeDescription] => 1200x900
[MediaModificationTimestamp] => 2026-06-22T19:02:27.788Z
)
[13] => Array
(
[Order] => 13
[MediaKey] => 6a3986c381078884cf86ad6f
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/c8efcf4d9543effca44247550c0c52e1.webp
[MediaSize] => 95971
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/thumbnail-c8efcf4d9543effca44247550c0c52e1.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 900
[ResourceRecordKey] => 425549115
[ImageSizeDescription] => 1200x900
[MediaModificationTimestamp] => 2026-06-22T19:02:27.761Z
)
[14] => Array
(
[Order] => 14
[MediaKey] => 6a39884c12f7d7df3935a082
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/7747a849c88e21b7c15df11da909ce61.webp
[MediaSize] => 142073
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/thumbnail-7747a849c88e21b7c15df11da909ce61.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 900
[ResourceRecordKey] => 425549115
[ImageSizeDescription] => 1200x900
[MediaModificationTimestamp] => 2026-06-22T19:09:00.906Z
)
[15] => Array
(
[Order] => 15
[MediaKey] => 6a3986c381078884cf86ad70
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/bb8d86f83a0577531df5104f314d1b83.webp
[MediaSize] => 95215
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/thumbnail-bb8d86f83a0577531df5104f314d1b83.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 900
[ResourceRecordKey] => 425549115
[ImageSizeDescription] => 1200x900
[MediaModificationTimestamp] => 2026-06-22T19:02:27.766Z
)
[16] => Array
(
[Order] => 16
[MediaKey] => 6a3986c381078884cf86ad71
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/0255b001d06ab133ccd2db6b7b28f3d4.webp
[MediaSize] => 211271
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425549115/thumbnail-0255b001d06ab133ccd2db6b7b28f3d4.webp
[ImageWidth] => 1200
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 900
[ResourceRecordKey] => 425549115
[ImageSizeDescription] => 1200x900
[MediaModificationTimestamp] => 2026-06-22T19:02:27.769Z
)
)
[ID] => 31816
)
[3] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 31799
[post_author] => 1
[ListingKey] => KEY425546100
[ListingId] => 1016230
[PropertyType] => Residential
[PropertySubType] => Single Family Residence
[StandardStatus] => Pending
[ModificationTimestamp] => 2026-09-14T07:08:37Z
[RFModificationTimestamp] => 2026-09-14T07:12:40Z
[ListPrice] => 899000
[BathroomsTotalInteger] => 3
[BathroomsHalf] => 0
[BedroomsTotal] => 4
[LotSizeArea] => 0
[LivingArea] => 1749
[BuildingAreaTotal] => 1749
[City] => Hempstead
[PostalCode] => 11572
[UnparsedAddress] => 3824 Illona Lane, Hempstead, New York 11572
[Coordinates] => Array
(
[0] => -73.630561
[1] => 40.6177821
)
[Latitude] => 40.6177821
[Longitude] => -73.630561
[YearBuilt] => 1966
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => Wendy A. Ponte CBR
[ListOfficeName] => Stonegate Real Estate
[ListAgentMlsId] => 107144
[ListOfficeMlsId] => STNE01
[OriginatingSystemName] => OneKey
[PublicRemarks] => Beautiful Madison Section High Ranch - Updated beautiful Bright Eat In Kitchen - Granite counters, Electric Range, Dishwasher, Spcious Living Room w/ Crown Moldings, leads into Formal Dining room, Sliding doors leads out to Deck with Water View, Steps down to large backyard. Primary Bedroom w/Full Bath Stall Shower, Bedroom, Bedroom, Full updated Bath. Down to large Family room w/ Wood burning Fireplace w/New Chimney, Bedroom, Laundry Room w/ New Washer/Dryer, Full Bath w/Stall Shower, Sliding doors leads out to backyard. Two Car oversized Garage, 200 Amps, Anderson Windows, One Year Old A/C Units. Inground Sprinklers.
[Appliances] => Array
(
[0] => Dishwasher
[1] => Dryer
[2] => Electric Range
[3] => Microwave
[4] => Refrigerator
[5] => Washer
[6] => Gas Water Heater
)
[ArchitecturalStyle] => Array
(
[0] => Hi Ranch
)
[AttributionContact] => 516-740-2777
[BathroomsFull] => 3
[BuildingAreaUnits] => Square Feet
[BuyerAgentAOR] => LIBOR
[BuyerAgentDirectPhone] => 917-370-3343
[BuyerAgentEmail] => Claudia.Algeri@redfin.com
[BuyerAgentFullName] => Claudia Algeri E-PRO
[BuyerAgentKey] => 326183712
[BuyerAgentMlsId] => 172648
[BuyerOfficeAOR] => LIBOR
[BuyerOfficeKey] => 326110429
[BuyerOfficeMlsId] => CNDE01
[BuyerOfficeName] => Redfin Real Estate
[BuyerOfficePhone] => 631-337-8238
[ConstructionMaterials] => Array
(
[0] => Vinyl Siding
)
[Cooling] => Array
(
[0] => Central Air
)
[CountyOrParish] => Nassau County
[CreationDate] => 2026-06-20T14:46:42.619854+00:00
[CumulativeDaysOnMarket] => 85
[DaysOnMarket] => 85
[Directions] => Oceanside Road East to Illona
[ElementarySchool] => School 9E-Boardman Elem School
[ElementarySchoolDistrict] => Oceanside
[ExpirationDate] => 2026-12-20
[FireplaceFeatures] => Array
(
[0] => Family Room
[1] => Wood Burning
)
[FireplaceYN] => 1
[FireplacesTotal] => 1
[Flooring] => Array
(
[0] => Ceramic Tile
[1] => Vinyl
[2] => Wood
)
[FoundationDetails] => Array
(
[0] => Slab
)
[GarageSpaces] => 2
[GarageYN] => 1
[Heating] => Array
(
[0] => Baseboard
[1] => Natural Gas
)
[HighSchool] => School 7-Oceanside Senior Hs
[HighSchoolDistrict] => Oceanside
[InteriorFeatures] => Array
(
[0] => First Floor Bedroom
[1] => Crown Molding
[2] => Eat-in Kitchen
[3] => Entrance Foyer
[4] => Formal Dining
[5] => Granite Counters
[6] => Open Floorplan
[7] => Primary Bathroom
[8] => Stone Counters
[9] => Walk Through Kitchen
[10] => Walk-In Closet(s)
[11] => Washer/Dryer Hookup
)
[RFTransactionType] => For Sale
[InternetEntireListingDisplayYN] => 1
[LaundryFeatures] => Array
(
[0] => Laundry Room
)
[Levels] => Array
(
[0] => Two
)
[ListAOR] => LIBOR
[ListAgentAOR] => LIBOR
[ListAgentEmail] => wendy.ponte@gmail.com
[ListAgentKey] => 326123387
[ListOfficeAOR] => LIBOR
[ListOfficeKey] => 326115823
[ListOfficePhone] => 516-740-2777
[ListingAgreement] => Exclusive Agency
[ListingContractDate] => 2026-06-20
[LivingAreaSource] => Other
[LotFeatures] => Array
(
[0] => Front Yard
[1] => Landscaped
[2] => Sprinklers In Front
[3] => Sprinklers In Rear
[4] => Views
)
[LotSizeAcres] => 0.1377
[LotSizeDimensions] => 60 x 100
[LotSizeSquareFeet] => 6000
[MajorChangeTimestamp] => 2026-09-13T16:20:01Z
[MajorChangeType] => Pending
[MiddleOrJuniorSchool] => School 9M-Oceanside Middle School
[MiddleOrJuniorSchoolDistrict] => Oceanside
[MlgCanUse] => Array
(
[0] => IDX
)
[MlgCanView] => 1
[MlsStatus] => Pending
[OffMarketDate] => 2026-09-13
[OnMarketDate] => 2026-06-20
[OriginalEntryTimestamp] => 2026-06-20T14:39:42Z
[OriginalListPrice] => 949000
[OriginatingSystemModificationTimestamp] => 2026-09-13T16:20:01Z
[OwnerName] => Heller
[ParcelNumber] => 2089-60-071-00-0028-0
[ParkingFeatures] => Array
(
[0] => Driveway
)
[ParkingTotal] => 4
[PatioAndPorchFeatures] => Array
(
[0] => Deck
[1] => Patio
)
[PhotosChangeTimestamp] => 2026-08-01T14:03:36Z
[PhotosCount] => 24
[PostalCity] => Oceanside
[PostalCodePlus4] => 5974
[PreviousListPrice] => 949000
[PriceChangeTimestamp] => 2026-08-17T21:02:44Z
[PropertyCondition] => Array
(
[0] => Updated/Remodeled
)
[PurchaseContractDate] => 2026-09-13
[RoomsTotal] => 8
[Sewer] => Array
(
[0] => Public Sewer
)
[ShowingContactPhone] => 516-317-8889
[ShowingRequirements] => Array
(
[0] => 24 Hour Notice
[1] => Appointment Only
[2] => Call Listing Agent
[3] => Occupied
)
[SpecialListingConditions] => Array
(
[0] => None
)
[StateOrProvince] => NY
[StatusChangeTimestamp] => 2026-09-13T16:20:01Z
[StreetName] => Illona
[StreetNumber] => 3824
[StreetNumberNumeric] => 3824
[StreetSuffix] => Lane
[SyndicateTo] => Array
(
[0] => Realtor.com
[1] => OneKeyMLS.com
)
[TaxAnnualAmount] => 13390.71
[TaxAssessedValue] => 524
[TaxYear] => 2024
[Utilities] => Array
(
[0] => Cable Available
[1] => Electricity Available
[2] => Natural Gas Available
[3] => Sewer Connected
[4] => Trash Collection Private
[5] => Trash Collection Public
)
[WaterSource] => Array
(
[0] => Public
)
[KEY_Attic] => Unfinished
[KEY_TaxSource] => Municipality
[KEY_ConcessionYN] => 0
[KEY_CurrentPrice] => 899000.00
[KEY_ContractPrice] => 899000.00
[KEY_OpenHouseCount] => 1
[KEY_PreviousStatus] => Active
[KEY_ElectricCompany] => PSEG
[KEY_NumberOfKitchens] => 1
[KEY_ShowingTimeFlagYN] => 0
[KEY_MlsMajorChangeType] => Pending
[KEY_BuyerRepresentation] => Buyer's Agent
[KEY_LivingAreaSearchSqFt] => 1749.00
[KEY_NumberOfHeatingZones] => 2
[KEY_OpenHousePublicCount] => 0
[KEY_DownPaymentResourceYN] => 1
[KEY_RATIO_ListPrice_By_LivingArea] => 514.00800
[KEY_RATIO_ListPrice_By_LotSizeAcres] => 6528685.5483
[KEY_RATIO_CurrentPrice_By_LivingArea] => 514.00800
[KEY_SourceSystemModificationTimestamp] => 2026-06-20T10:39:42.070
[KEY_RATIO_ListPrice_By_BuildingAreaTotal] => 514.00800
[KEY_RATIO_ListPrice_By_OriginalListPrice] => 0.94731
[KEY_RATIO_CurrentPrice_By_BuildingAreaTotal] => 514.00800
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425546100')
[provider_name] => One Key
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6a36a72055bd58a5b76908ef
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/a5dcd60402d8174448cb6bda96d79122.webp
[MediaSize] => 205650
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-a5dcd60402d8174448cb6bda96d79122.webp
[ImageWidth] => 1320
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 837
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1320x837
[MediaModificationTimestamp] => 2026-06-20T14:43:44.655Z
)
[1] => Array
(
[Order] => 1
[MediaKey] => 6a36a72055bd58a5b76908f0
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/9cf47687cd1f2b2218dd5cf5179d25dd.webp
[MediaSize] => 244231
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-9cf47687cd1f2b2218dd5cf5179d25dd.webp
[ImageWidth] => 1305
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 863
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1305x863
[MediaModificationTimestamp] => 2026-06-20T14:43:44.622Z
)
[2] => Array
(
[Order] => 2
[MediaKey] => 6a36a72055bd58a5b76908f1
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/5d50d160400f0cb71ce8a567209e0968.webp
[MediaSize] => 113618
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-5d50d160400f0cb71ce8a567209e0968.webp
[ImageWidth] => 1320
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 881
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1320x881
[MediaModificationTimestamp] => 2026-06-20T14:43:44.622Z
)
[3] => Array
(
[Order] => 3
[MediaKey] => 6a36a72055bd58a5b76908f2
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/b3b8b45729e0d85639b46e179c661647.webp
[MediaSize] => 98661
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-b3b8b45729e0d85639b46e179c661647.webp
[ImageWidth] => 1320
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 872
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1320x872
[MediaModificationTimestamp] => 2026-06-20T14:43:44.630Z
)
[4] => Array
(
[Order] => 4
[MediaKey] => 6a36a72055bd58a5b76908f3
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/730b67d49237a4fab0c84997bd95b754.webp
[MediaSize] => 152683
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-730b67d49237a4fab0c84997bd95b754.webp
[ImageWidth] => 1320
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 883
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1320x883
[MediaModificationTimestamp] => 2026-06-20T14:43:44.622Z
)
[5] => Array
(
[Order] => 5
[MediaKey] => 6a36a72055bd58a5b76908f4
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/8a4459a0db7e3df7be550c47cdd0dbd0.webp
[MediaSize] => 140274
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-8a4459a0db7e3df7be550c47cdd0dbd0.webp
[ImageWidth] => 1320
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 889
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1320x889
[MediaModificationTimestamp] => 2026-06-20T14:43:44.622Z
)
[6] => Array
(
[Order] => 6
[MediaKey] => 6a36a72055bd58a5b76908f5
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/8364406962a8fb0ed0d3f77d8269dda5.webp
[MediaSize] => 124889
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-8364406962a8fb0ed0d3f77d8269dda5.webp
[ImageWidth] => 1320
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 869
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1320x869
[MediaModificationTimestamp] => 2026-06-20T14:43:44.588Z
)
[7] => Array
(
[Order] => 7
[MediaKey] => 6a36a72055bd58a5b76908f6
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/ecb9b9f19ae52de8554c11205be77a7f.webp
[MediaSize] => 129453
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-ecb9b9f19ae52de8554c11205be77a7f.webp
[ImageWidth] => 1320
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 883
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1320x883
[MediaModificationTimestamp] => 2026-06-20T14:43:44.622Z
)
[8] => Array
(
[Order] => 8
[MediaKey] => 6a36a72055bd58a5b76908f7
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/36fd4e3670f7db48681c8d733d65c7b5.webp
[MediaSize] => 98071
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-36fd4e3670f7db48681c8d733d65c7b5.webp
[ImageWidth] => 1320
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 872
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1320x872
[MediaModificationTimestamp] => 2026-06-20T14:43:44.590Z
)
[9] => Array
(
[Order] => 9
[MediaKey] => 6a36a72055bd58a5b76908f8
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/ff7915dadfa90c90cc61821e3588d47f.webp
[MediaSize] => 111123
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-ff7915dadfa90c90cc61821e3588d47f.webp
[ImageWidth] => 1320
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 869
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1320x869
[MediaModificationTimestamp] => 2026-06-20T14:43:44.596Z
)
[10] => Array
(
[Order] => 10
[MediaKey] => 6a36a72055bd58a5b76908f9
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/e61fe4fd9bb19378beda5db71dfa5f05.webp
[MediaSize] => 87337
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-e61fe4fd9bb19378beda5db71dfa5f05.webp
[ImageWidth] => 1320
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 869
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1320x869
[MediaModificationTimestamp] => 2026-06-20T14:43:44.588Z
)
[11] => Array
(
[Order] => 11
[MediaKey] => 6a36a72055bd58a5b76908fa
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/4cb790f98ca5b08532c819fa78c33946.webp
[MediaSize] => 82785
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-4cb790f98ca5b08532c819fa78c33946.webp
[ImageWidth] => 1320
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 860
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1320x860
[MediaModificationTimestamp] => 2026-06-20T14:43:44.622Z
)
[12] => Array
(
[Order] => 12
[MediaKey] => 6a36a72055bd58a5b76908fb
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/ef0b6b2c2db76ccd017915669e80f588.webp
[MediaSize] => 141594
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-ef0b6b2c2db76ccd017915669e80f588.webp
[ImageWidth] => 1320
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 893
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1320x893
[MediaModificationTimestamp] => 2026-06-20T14:43:44.622Z
)
[13] => Array
(
[Order] => 13
[MediaKey] => 6a36a72055bd58a5b76908fc
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/4f476a0a43ca2926f8cfc87f9c2e2dbf.webp
[MediaSize] => 107103
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-4f476a0a43ca2926f8cfc87f9c2e2dbf.webp
[ImageWidth] => 1320
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 892
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1320x892
[MediaModificationTimestamp] => 2026-06-20T14:43:44.622Z
)
[14] => Array
(
[Order] => 14
[MediaKey] => 6a36a72055bd58a5b76908fd
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/bb06f0624dad9df56c9ed12523ff8320.webp
[MediaSize] => 153501
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-bb06f0624dad9df56c9ed12523ff8320.webp
[ImageWidth] => 1320
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 889
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1320x889
[MediaModificationTimestamp] => 2026-06-20T14:43:44.588Z
)
[15] => Array
(
[Order] => 15
[MediaKey] => 6a36a72055bd58a5b76908fe
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/6e03f8c1dbdfae2b2e9f52a3f17b7c2a.webp
[MediaSize] => 141953
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-6e03f8c1dbdfae2b2e9f52a3f17b7c2a.webp
[ImageWidth] => 1320
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 880
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1320x880
[MediaModificationTimestamp] => 2026-06-20T14:43:44.592Z
)
[16] => Array
(
[Order] => 16
[MediaKey] => 6a36a72055bd58a5b76908ff
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/473bce5ec798833991d01779bca1042c.webp
[MediaSize] => 82361
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-473bce5ec798833991d01779bca1042c.webp
[ImageWidth] => 1320
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 878
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1320x878
[MediaModificationTimestamp] => 2026-06-20T14:43:44.585Z
)
[17] => Array
(
[Order] => 17
[MediaKey] => 6a36a72055bd58a5b7690900
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/ee42b4f8ce412f416a7ff20d94ed406d.webp
[MediaSize] => 60613
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-ee42b4f8ce412f416a7ff20d94ed406d.webp
[ImageWidth] => 1320
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 867
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1320x867
[MediaModificationTimestamp] => 2026-06-20T14:43:44.585Z
)
[18] => Array
(
[Order] => 18
[MediaKey] => 6a36a72055bd58a5b7690901
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/4e0a271ba3bd64d543779cd5757c2135.webp
[MediaSize] => 142243
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-4e0a271ba3bd64d543779cd5757c2135.webp
[ImageWidth] => 1320
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 893
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1320x893
[MediaModificationTimestamp] => 2026-06-20T14:43:44.622Z
)
[19] => Array
(
[Order] => 19
[MediaKey] => 6a36a72055bd58a5b7690902
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/623f0e1cbb3eab25fcce8c2aa0814cc1.webp
[MediaSize] => 221568
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-623f0e1cbb3eab25fcce8c2aa0814cc1.webp
[ImageWidth] => 1320
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 878
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1320x878
[MediaModificationTimestamp] => 2026-06-20T14:43:44.600Z
)
[20] => Array
(
[Order] => 20
[MediaKey] => 6a36a72055bd58a5b7690903
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/c21d86335806a24bad86b4c064d06504.webp
[MediaSize] => 256852
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-c21d86335806a24bad86b4c064d06504.webp
[ImageWidth] => 1320
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 893
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1320x893
[MediaModificationTimestamp] => 2026-06-20T14:43:44.622Z
)
[21] => Array
(
[Order] => 21
[MediaKey] => 6a36a72055bd58a5b7690904
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/d86a11c2f6a1b17021664ef1020e850b.webp
[MediaSize] => 194436
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-d86a11c2f6a1b17021664ef1020e850b.webp
[ImageWidth] => 1320
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 889
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1320x889
[MediaModificationTimestamp] => 2026-06-20T14:43:44.591Z
)
[22] => Array
(
[Order] => 22
[MediaKey] => 6a36a72055bd58a5b7690905
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/fc5c2316af229e0359e93a11cfb4cc59.webp
[MediaSize] => 260346
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-fc5c2316af229e0359e93a11cfb4cc59.webp
[ImageWidth] => 1320
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 953
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 1320x953
[MediaModificationTimestamp] => 2026-06-20T14:43:44.618Z
)
[23] => Array
(
[Order] => 23
[MediaKey] => 6a6dfc85ca0e0841f8d591ea
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/263d0222181cbefc348f5d8ae56dd30f.webp
[MediaSize] => 693070
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425546100/thumbnail-263d0222181cbefc348f5d8ae56dd30f.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1536
[LongDescription] => water view from deck
[ResourceRecordKey] => 425546100
[ImageSizeDescription] => 2048x1536
[MediaModificationTimestamp] => 2026-08-01T14:02:45.282Z
)
)
[ID] => 31799
)
[4] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 31798
[post_author] => 1
[ListingKey] => KEY425540241
[ListingId] => 1016090
[PropertyType] => Residential
[PropertySubType] => Single Family Residence
[StandardStatus] => Pending
[ModificationTimestamp] => 2026-08-07T07:12:41Z
[RFModificationTimestamp] => 2026-08-07T07:15:00Z
[ListPrice] => 824900
[BathroomsTotalInteger] => 2
[BathroomsHalf] => 0
[BedroomsTotal] => 3
[LotSizeArea] => 0
[LivingArea] => 1480
[BuildingAreaTotal] => 1480
[City] => Hempstead
[PostalCode] => 11566
[UnparsedAddress] => 2698 Rosebud Avenue, Hempstead, New York 11566
[Coordinates] => Array
(
[0] => -73.55332
[1] => 40.650425
)
[Latitude] => 40.650425
[Longitude] => -73.55332
[YearBuilt] => 1931
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => Salvatore Burruano CBR
[ListOfficeName] => American Pride Realty Inc
[ListAgentMlsId] => 9060085
[ListOfficeMlsId] => APR101
[OriginatingSystemName] => OneKey
[PublicRemarks] => Welcome to 2698 Rosebud Avenue! This beautiful home with awesome landscaping and exceptional curb appeal, creates a wonderful first impression! The first floor offers an open floor plan with living room, dining room and kitchen as well as 1 Bedroom, full bath and a Family Room, which has direct access to the rear patio and a fully fenced backyard that feels as a park-like private retreat with a large deck for unforgettable entertaining. The second floor has 2 Bedrooms, the primary with a walk-in closet, full bathroom, as well as a Laundry Room and plenty of storage space.. The location offers a sense of community and tranquility while this prime location places you just moments from parks, shopping, restaurants, major roadways, everything that makes Merrick such a sought-after community, including public transportation since it is situated approximately five minutes from the LIRR station, making commuting to Manhattan a breeze. Don’t miss this opportunity to own a beautifully maintained home in one of Merrick’s most sought-after locations.
[Appliances] => Array
(
[0] => Dishwasher
[1] => Gas Oven
[2] => Microwave
[3] => Refrigerator
)
[ArchitecturalStyle] => Array
(
[0] => Cape Cod
)
[AttributionContact] => 516-546-9090
[Basement] => Array
(
[0] => Crawl Space
)
[BathroomsFull] => 2
[BuildingAreaUnits] => Square Feet
[BuyerAgentAOR] => LIBOR
[BuyerAgentDirectPhone] => 631-337-8238
[BuyerAgentEmail] => sandra.glaser@redfin.com
[BuyerAgentFullName] => Sandra Glaser E-PRO MRP PSA SRS GR
[BuyerAgentKey] => 326182327
[BuyerAgentMlsId] => 171164
[BuyerOfficeAOR] => LIBOR
[BuyerOfficeKey] => 326110429
[BuyerOfficeMlsId] => CNDE01
[BuyerOfficeName] => Redfin Real Estate
[BuyerOfficePhone] => 631-337-8238
[ConstructionMaterials] => Array
(
[0] => Shingle Siding
)
[Cooling] => Array
(
[0] => Central Air
)
[CountyOrParish] => Nassau County
[CreationDate] => 2026-06-20T10:35:04.486163+00:00
[CumulativeDaysOnMarket] => 47
[DaysOnMarket] => 47
[DirectionFaces] => East
[Directions] => From Merrick road south on Beach Dr. left on Benard St. Right on Rosebud Ave.
[Disclosures] => Array
(
[0] => Lead Paint
)
[ElementarySchool] => Norman J Levy Lakeside School
[ElementarySchoolDistrict] => Merrick
[ExpirationDate] => 2026-12-31
[Flooring] => Array
(
[0] => Hardwood
)
[GarageSpaces] => 1
[GarageYN] => 1
[Heating] => Array
(
[0] => Hot Water
)
[HighSchool] => John F Kennedy High School
[HighSchoolDistrict] => Bellmore-Merrick
[InteriorFeatures] => Array
(
[0] => First Floor Bedroom
[1] => Crown Molding
[2] => Granite Counters
[3] => Recessed Lighting
)
[RFTransactionType] => For Sale
[InternetConsumerCommentYN] => 1
[InternetEntireListingDisplayYN] => 1
[ListAOR] => LIBOR
[ListAgentAOR] => LIBOR
[ListAgentEmail] => salvatore@americanpriderealty.com
[ListAgentKey] => 326260223
[ListOfficeAOR] => LIBOR
[ListOfficeKey] => 326109443
[ListOfficePhone] => 516-546-9090
[ListingAgreement] => Exclusive Right To Sell
[ListingContractDate] => 2026-06-19
[LivingAreaSource] => Public Records
[LotSizeAcres] => 0.0918
[LotSizeDimensions] => 4000
[LotSizeSquareFeet] => 4000
[MajorChangeTimestamp] => 2026-08-06T15:11:28Z
[MajorChangeType] => Pending
[MiddleOrJuniorSchool] => Merrick Avenue Middle School
[MiddleOrJuniorSchoolDistrict] => Merrick
[MlgCanUse] => Array
(
[0] => IDX
)
[MlgCanView] => 1
[MlsStatus] => Pending
[OffMarketDate] => 2026-08-06
[OnMarketDate] => 2026-06-20
[OriginalEntryTimestamp] => 2026-06-20T10:30:01Z
[OriginalListPrice] => 824900
[OriginatingSystemModificationTimestamp] => 2026-08-06T15:11:28Z
[OwnerName] => Salvatore & Carol Benna
[ParcelNumber] => 2089-62-008-00-0036-0
[ParkingFeatures] => Array
(
[0] => Driveway
)
[ParkingTotal] => 4
[PhotosChangeTimestamp] => 2026-06-19T19:36:36Z
[PhotosCount] => 28
[PostalCity] => Merrick
[PostalCodePlus4] => 4523
[PurchaseContractDate] => 2026-08-06
[RoomsTotal] => 8
[Sewer] => Array
(
[0] => Public Sewer
)
[ShowingContactPhone] => 855-293-3591
[ShowingRequirements] => Array
(
[0] => Showing Service
)
[SpecialListingConditions] => Array
(
[0] => None
)
[StateOrProvince] => NY
[StatusChangeTimestamp] => 2026-08-06T15:11:28Z
[StreetName] => Rosebud
[StreetNumber] => 2698
[StreetNumberNumeric] => 2698
[StreetSuffix] => Avenue
[SyndicateTo] => Array
(
[0] => Realtor.com
[1] => OneKeyMLS.com
)
[TaxAnnualAmount] => 11624.84
[TaxAssessedValue] => 453
[TaxBlock] => 008
[TaxLot] => 36
[TaxYear] => 2024
[Utilities] => Array
(
[0] => Cable Available
[1] => Electricity Connected
[2] => Natural Gas Connected
[3] => Sewer Connected
[4] => Water Connected
)
[WaterSource] => Array
(
[0] => Public
)
[KEY_Attic] => Crawl
[KEY_TaxSource] => Municipality
[KEY_TaxSection] => 62
[KEY_ConcessionYN] => 0
[KEY_CurrentPrice] => 824900.00
[KEY_ContractPrice] => 824900.00
[KEY_OpenHouseCount] => 1
[KEY_PreviousStatus] => Active
[KEY_DistanceToTrain] => 1.00
[KEY_ElectricCompany] => NYSEG
[KEY_ShowingTimeFlagYN] => 0
[KEY_MlsMajorChangeType] => Pending
[KEY_BuyerRepresentation] => Buyer's Agent
[KEY_LivingAreaSearchSqFt] => 1480.00
[KEY_NumberOfHeatingZones] => 2
[KEY_OpenHousePublicCount] => 0
[KEY_DownPaymentResourceYN] => 1
[KEY_RATIO_ListPrice_By_LivingArea] => 557.36486
[KEY_RATIO_ListPrice_By_LotSizeAcres] => 8985838.7800
[KEY_RATIO_CurrentPrice_By_LivingArea] => 557.36486
[KEY_SourceSystemModificationTimestamp] => 2026-06-19T15:27:41.273
[KEY_RATIO_ListPrice_By_BuildingAreaTotal] => 557.36486
[KEY_RATIO_ListPrice_By_OriginalListPrice] => 1.00000
[KEY_RATIO_CurrentPrice_By_BuildingAreaTotal] => 557.36486
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425540241')
[provider_name] => One Key
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6a359872bd6532a4f7ed4ff1
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/b1f4bb19d295271f6c526d560c3a793b.webp
[MediaSize] => 491346
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-b1f4bb19d295271f6c526d560c3a793b.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[LongDescription] => Two-story residence featuring light-colored siding and dark shutters
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.558Z
)
[1] => Array
(
[Order] => 1
[MediaKey] => 6a359872bd6532a4f7ed4ff2
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/ebf6479a837c87684512dd203d900352.webp
[MediaSize] => 462036
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-ebf6479a837c87684512dd203d900352.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.651Z
)
[2] => Array
(
[Order] => 2
[MediaKey] => 6a359872bd6532a4f7ed4ff3
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/382d607c48163cc4b5fcb0a7fbb54047.webp
[MediaSize] => 357587
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-382d607c48163cc4b5fcb0a7fbb54047.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.553Z
)
[3] => Array
(
[Order] => 3
[MediaKey] => 6a359872bd6532a4f7ed4ff4
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/60e7060096840fb0ff7a801d3cdb766b.webp
[MediaSize] => 447358
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-60e7060096840fb0ff7a801d3cdb766b.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[LongDescription] => Expansive multi-level wood deck with lattice detailing and privacy fencing
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.578Z
)
[4] => Array
(
[Order] => 4
[MediaKey] => 6a359872bd6532a4f7ed4ff5
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/4625b23c7e74fc86608cdc1a2cf7ba64.webp
[MediaSize] => 461882
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-4625b23c7e74fc86608cdc1a2cf7ba64.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.629Z
)
[5] => Array
(
[Order] => 5
[MediaKey] => 6a359872bd6532a4f7ed4ff6
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/256f592556d62c01ce5ad6ad54ea1908.webp
[MediaSize] => 403538
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-256f592556d62c01ce5ad6ad54ea1908.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.579Z
)
[6] => Array
(
[Order] => 6
[MediaKey] => 6a359872bd6532a4f7ed4ff7
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/f6a28bbd42c01365a756e7091f87783c.webp
[MediaSize] => 321726
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-f6a28bbd42c01365a756e7091f87783c.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[LongDescription] => Spacious living area featuring wood-finish flooring, recessed lighting, crown molding, and two multi-pane windows with valances
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.605Z
)
[7] => Array
(
[Order] => 7
[MediaKey] => 6a359872bd6532a4f7ed4ff8
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/1c44c2681fe75c3486b3c9b36becc6fa.webp
[MediaSize] => 338077
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-1c44c2681fe75c3486b3c9b36becc6fa.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.584Z
)
[8] => Array
(
[Order] => 8
[MediaKey] => 6a359872bd6532a4f7ed4ff9
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/968305827e789bb7fcc8f4497524d872.webp
[MediaSize] => 273721
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-968305827e789bb7fcc8f4497524d872.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[LongDescription] => Kitchen featuring light-toned cabinetry, dark countertops, and a stainless steel sink with a gooseneck faucet
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.542Z
)
[9] => Array
(
[Order] => 9
[MediaKey] => 6a359872bd6532a4f7ed4ffa
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/372ca68afb15998f53f91855335bcf83.webp
[MediaSize] => 258700
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-372ca68afb15998f53f91855335bcf83.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.578Z
)
[10] => Array
(
[Order] => 10
[MediaKey] => 6a359872bd6532a4f7ed4ffb
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/775002fd08dd905abbe25a2994a3e1df.webp
[MediaSize] => 302968
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-775002fd08dd905abbe25a2994a3e1df.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.578Z
)
[11] => Array
(
[Order] => 11
[MediaKey] => 6a359872bd6532a4f7ed4ffc
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/36759c7d620f7577d514bb4f205c9fbb.webp
[MediaSize] => 329139
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-36759c7d620f7577d514bb4f205c9fbb.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.578Z
)
[12] => Array
(
[Order] => 12
[MediaKey] => 6a359872bd6532a4f7ed4ffd
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/00980d25f61dc1dbd9b042832abd8fe6.webp
[MediaSize] => 270350
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-00980d25f61dc1dbd9b042832abd8fe6.webp
[ImageWidth] => 1366
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 2048
[LongDescription] => Bathroom featuring a single vanity with a granite countertop, undermount sink, and polished chrome faucet
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 1366x2048
[MediaModificationTimestamp] => 2026-06-19T19:28:50.548Z
)
[13] => Array
(
[Order] => 13
[MediaKey] => 6a359872bd6532a4f7ed4ffe
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/9d2d729f150fb0741054a2753a29bf0b.webp
[MediaSize] => 258705
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-9d2d729f150fb0741054a2753a29bf0b.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[LongDescription] => Hardwood-finish flooring highlights this room featuring a built-in closet with bifold doors, light gray wall paint, and white trim
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.542Z
)
[14] => Array
(
[Order] => 14
[MediaKey] => 6a359872bd6532a4f7ed4fff
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/54a657cd9c6351805ddf4f11d6fea165.webp
[MediaSize] => 249092
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-54a657cd9c6351805ddf4f11d6fea165.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.544Z
)
[15] => Array
(
[Order] => 15
[MediaKey] => 6a359872bd6532a4f7ed5000
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/428fdde9199afc0651f0d636f68030cd.webp
[MediaSize] => 273436
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-428fdde9199afc0651f0d636f68030cd.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.549Z
)
[16] => Array
(
[Order] => 16
[MediaKey] => 6a359872bd6532a4f7ed5001
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/176eac58e08ab6f7ab4c1d0964f0d5ab.webp
[MediaSize] => 294904
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-176eac58e08ab6f7ab4c1d0964f0d5ab.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[LongDescription] => Living area featuring wood-finish flooring, light neutral wall paint, and a sliding glass door with grid detailing
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.604Z
)
[17] => Array
(
[Order] => 17
[MediaKey] => 6a359872bd6532a4f7ed5002
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/177033fc1a1342213bf0fbb1e9c86678.webp
[MediaSize] => 310531
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-177033fc1a1342213bf0fbb1e9c86678.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.621Z
)
[18] => Array
(
[Order] => 18
[MediaKey] => 6a359872bd6532a4f7ed5003
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/0f9b1a15d28bfda5565106acd56f20e9.webp
[MediaSize] => 218109
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-0f9b1a15d28bfda5565106acd56f20e9.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.564Z
)
[19] => Array
(
[Order] => 19
[MediaKey] => 6a359872bd6532a4f7ed5004
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/99ba1aa2e26afba080f1b0bda8b2d4e8.webp
[MediaSize] => 223259
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-99ba1aa2e26afba080f1b0bda8b2d4e8.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.578Z
)
[20] => Array
(
[Order] => 20
[MediaKey] => 6a359872bd6532a4f7ed5005
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/05bcd8d80a4dbeac719faf7f5f8cc2c5.webp
[MediaSize] => 231177
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-05bcd8d80a4dbeac719faf7f5f8cc2c5.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.539Z
)
[21] => Array
(
[Order] => 21
[MediaKey] => 6a359872bd6532a4f7ed5006
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/d0140fa4faac6592b383d1b7d0cbb737.webp
[MediaSize] => 210819
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-d0140fa4faac6592b383d1b7d0cbb737.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.559Z
)
[22] => Array
(
[Order] => 22
[MediaKey] => 6a359872bd6532a4f7ed5007
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/75fb29a5ba988063d4a6aaad1a7b1ec3.webp
[MediaSize] => 226410
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-75fb29a5ba988063d4a6aaad1a7b1ec3.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.555Z
)
[23] => Array
(
[Order] => 23
[MediaKey] => 6a359872bd6532a4f7ed5008
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/78b43e34063dfa583cc7a64add35ce72.webp
[MediaSize] => 236746
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-78b43e34063dfa583cc7a64add35ce72.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.547Z
)
[24] => Array
(
[Order] => 24
[MediaKey] => 6a359a375b7f363519fda572
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/a6104b9ca499dcf357cb9a51769032aa.webp
[MediaSize] => 314335
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-a6104b9ca499dcf357cb9a51769032aa.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:36:23.935Z
)
[25] => Array
(
[Order] => 25
[MediaKey] => 6a359a375b7f363519fda573
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/87b44fde35a4298d803748a77e3966b1.webp
[MediaSize] => 330875
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-87b44fde35a4298d803748a77e3966b1.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:36:23.949Z
)
[26] => Array
(
[Order] => 26
[MediaKey] => 6a359a375b7f363519fda574
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/56c15c6caa8c19b113f430fbaf616a69.webp
[MediaSize] => 304569
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-56c15c6caa8c19b113f430fbaf616a69.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:36:23.935Z
)
[27] => Array
(
[Order] => 27
[MediaKey] => 6a359872bd6532a4f7ed5009
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/b001a82c9490eb2d40af122ba36337c2.webp
[MediaSize] => 201904
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540241/thumbnail-b001a82c9490eb2d40af122ba36337c2.webp
[ImageWidth] => 2048
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1366
[ResourceRecordKey] => 425540241
[ImageSizeDescription] => 2048x1366
[MediaModificationTimestamp] => 2026-06-19T19:28:50.578Z
)
)
[ID] => 31798
)
[5] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 31833
[post_author] => 1
[ListingKey] => KEY425540129
[ListingId] => 1016086
[PropertyType] => Residential
[PropertySubType] => Single Family Residence
[StandardStatus] => Active
[ModificationTimestamp] => 2026-07-06T22:59:36Z
[RFModificationTimestamp] => 2026-07-06T23:04:05Z
[ListPrice] => 2999999
[BathroomsTotalInteger] => 5
[BathroomsHalf] => 1
[BedroomsTotal] => 7
[LotSizeArea] => 0
[LivingArea] => 4330
[BuildingAreaTotal] => 2260
[City] => Hempstead
[PostalCode] => 11516
[UnparsedAddress] => 235 Oakwood Avenue, Hempstead, New York 11516
[Coordinates] => Array
(
[0] => -73.7232411
[1] => 40.6255863
)
[Latitude] => 40.6255863
[Longitude] => -73.7232411
[YearBuilt] => 1920
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListAgentFullName] => Rivka Goldman
[ListOfficeName] => Avid Homes Inc
[ListAgentMlsId] => 208397
[ListOfficeMlsId] => AVDU01
[OriginatingSystemName] => OneKey
[PublicRemarks] => Welcome to this stunning, newly constructed masterpiece situated on one of the neighborhood's most highly desirable blocks. Designed with an exceptional blend of elegance and modern functionality, this expansive home offers unparalleled luxury and convenience, located just moments from the train, premier shopping, and houses of worship. The main level boasts a bright, airy layout designed for grand-scale entertaining. A sprawling formal dining room sets the stage for large holiday gatherings, while the chef’s custom eat-in kitchen serves as the heart of the home. This culinary masterpiece features premium finishes, custom cabinetry, and two of everything to easily accommodate specialized cooking needs. The kitchen flows effortlessly into a massive, sun-drenched great room, creating the ultimate hub for daily family life. Upstairs, the palatial primary suite offers a serene retreat, complete with expansive walk-in closets and a spa-like ensuite. Four additional generously sized bedrooms and two beautifully appointed full designer bathrooms complete this level, providing ample space for family and guests. The incredible, fully finished basement features high ceilings that maximize natural light throughout the massive recreation space. This lower level also includes two additional bedrooms and a full bathroom, offering private, comfortable accommodations for guests.
[Appliances] => Array
(
[0] => Convection Oven
[1] => Dishwasher
[2] => Dryer
[3] => Gas Cooktop
[4] => Oven
[5] => Stainless Steel Appliance(s)
[6] => Washer
)
[ArchitecturalStyle] => Array
(
[0] => Colonial
)
[AttributionContact] => 516-343-6891
[Basement] => Array
(
[0] => Finished
)
[BasementYN] => 1
[BathroomsFull] => 4
[BuildingAreaUnits] => Square Feet
[ConstructionMaterials] => Array
(
[0] => Stucco
)
[Cooling] => Array
(
[0] => Central Air
)
[Country] => US
[CountyOrParish] => Nassau County
[CreationDate] => 2026-06-23T18:31:22.399861+00:00
[CrossStreet] => park
[CumulativeDaysOnMarket] => 13
[DaysOnMarket] => 84
[Directions] => take W. Broadway to Oakwood
[ElementarySchool] => Lawrence Elementary School-Broadway
[ElementarySchoolDistrict] => Lawrence
[ExpirationDate] => 2026-12-31
[FireplacesTotal] => 1
[Flooring] => Array
(
[0] => Hardwood
[1] => Tile
)
[GarageSpaces] => 1
[GarageYN] => 1
[Heating] => Array
(
[0] => Natural Gas
)
[HighSchool] => Lawrence Senior High School
[HighSchoolDistrict] => Lawrence
[InteriorFeatures] => Array
(
[0] => Breakfast Bar
[1] => Built-in Features
[2] => Chefs Kitchen
[3] => Double Vanity
[4] => Eat-in Kitchen
[5] => Entrance Foyer
[6] => Formal Dining
[7] => His and Hers Closets
[8] => Kitchen Island
[9] => Natural Woodwork
[10] => Primary Bathroom
[11] => Recessed Lighting
[12] => Soaking Tub
[13] => Stone Counters
[14] => Storage
[15] => Walk-In Closet(s)
[16] => Washer/Dryer Hookup
)
[RFTransactionType] => For Sale
[InternetEntireListingDisplayYN] => 1
[LaundryFeatures] => Array
(
[0] => Multiple Locations
)
[ListAOR] => LIBOR
[ListAgentAOR] => LIBOR
[ListAgentDirectPhone] => 917-639-6169
[ListAgentEmail] => rivkags212@gmail.com
[ListAgentKey] => 326217739
[ListOfficeAOR] => LIBOR
[ListOfficeKey] => 326109563
[ListOfficePhone] => 516-343-6891
[ListingAgreement] => Exclusive Right To Sell
[ListingContractDate] => 2026-05-27
[LivingAreaSource] => Other
[LotSizeAcres] => 0.155
[LotSizeSquareFeet] => 6750
[MajorChangeTimestamp] => 2026-06-23T18:25:23Z
[MajorChangeType] => New Listing
[MiddleOrJuniorSchool] => LAWRENCE MIDDLE SCHOOL AT BROADWAY CAMPUS
[MiddleOrJuniorSchoolDistrict] => Lawrence
[MlgCanUse] => Array
(
[0] => IDX
)
[MlgCanView] => 1
[MlsStatus] => Active
[OnMarketDate] => 2026-06-23
[OriginalEntryTimestamp] => 2026-06-23T18:25:23Z
[OriginalListPrice] => 2999999
[OriginatingSystemModificationTimestamp] => 2026-07-06T22:58:22Z
[OwnerName] => 235 Oakwood Ave Llc
[ParcelNumber] => 2003-39-260-00-0318-0
[ParkingFeatures] => Array
(
[0] => Driveway
)
[PhotosChangeTimestamp] => 2026-06-23T18:26:36Z
[PhotosCount] => 6
[PostalCity] => Cedarhurst
[PostalCodePlus4] => 1732
[RoomsTotal] => 13
[Sewer] => Array
(
[0] => Public Sewer
)
[ShowingContactPhone] => 917-639-6169
[ShowingRequirements] => Array
(
[0] => Call Listing Agent
)
[SpecialListingConditions] => Array
(
[0] => None
)
[StateOrProvince] => NY
[StatusChangeTimestamp] => 2026-06-23T18:25:23Z
[StreetName] => Oakwood
[StreetNumber] => 235
[StreetNumberNumeric] => 235
[StreetSuffix] => Avenue
[SyndicateTo] => Array
(
[0] => Realtor.com
[1] => OneKeyMLS.com
)
[TaxAnnualAmount] => 12405.82
[TaxAssessedValue] => 883
[TaxYear] => 2024
[Utilities] => Array
(
[0] => Electricity Connected
[1] => Natural Gas Connected
[2] => Water Connected
)
[WaterSource] => Array
(
[0] => Public
)
[KEY_Attic] => Storage
[KEY_Village] => Cedarhurst
[KEY_TaxSource] => Municipality
[KEY_CurrentPrice] => 2999999.00
[KEY_ShowingTimeFlagYN] => 1
[KEY_MlsMajorChangeType] => New Listing
[KEY_LivingAreaSearchSqFt] => 4330.00
[KEY_DownPaymentResourceYN] => 0
[KEY_RATIO_ListPrice_By_LivingArea] => 692.84042
[KEY_RATIO_ListPrice_By_LotSizeAcres] => 19354832.2581
[KEY_RATIO_CurrentPrice_By_LivingArea] => 692.84042
[KEY_SourceSystemModificationTimestamp] => 2026-06-19T15:21:28.417
[KEY_RATIO_ListPrice_By_BuildingAreaTotal] => 1327.43319
[KEY_RATIO_ListPrice_By_OriginalListPrice] => 1.00000
[KEY_RATIO_CurrentPrice_By_BuildingAreaTotal] => 1327.43319
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('KEY425540129')
[provider_name] => One Key
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6a3acfc3fec0dda8867f24be
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540129/052b9ee44d25d46f3e315f6b76d1f42f.webp
[MediaSize] => 213726
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540129/thumbnail-052b9ee44d25d46f3e315f6b76d1f42f.webp
[ImageWidth] => 1280
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 1280
[ResourceRecordKey] => 425540129
[ImageSizeDescription] => 1280x1280
[MediaModificationTimestamp] => 2026-06-23T18:26:11.718Z
)
[1] => Array
(
[Order] => 1
[MediaKey] => 6a3acfc3fec0dda8867f24bf
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540129/3ed1ba267c7c389de4616e8f7aa721e9.webp
[MediaSize] => 99412
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540129/thumbnail-3ed1ba267c7c389de4616e8f7aa721e9.webp
[ImageWidth] => 1280
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 853
[ResourceRecordKey] => 425540129
[ImageSizeDescription] => 1280x853
[MediaModificationTimestamp] => 2026-06-23T18:26:11.665Z
)
[2] => Array
(
[Order] => 2
[MediaKey] => 6a3acfc3fec0dda8867f24c0
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540129/67b1810b08cd1ed628c16674863dc2ea.webp
[MediaSize] => 95298
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540129/thumbnail-67b1810b08cd1ed628c16674863dc2ea.webp
[ImageWidth] => 1280
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 853
[ResourceRecordKey] => 425540129
[ImageSizeDescription] => 1280x853
[MediaModificationTimestamp] => 2026-06-23T18:26:11.668Z
)
[3] => Array
(
[Order] => 3
[MediaKey] => 6a3acfc3fec0dda8867f24c1
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540129/7c02e09e0564b107b7db02b97e5dc209.webp
[MediaSize] => 113404
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540129/thumbnail-7c02e09e0564b107b7db02b97e5dc209.webp
[ImageWidth] => 1280
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 853
[ResourceRecordKey] => 425540129
[ImageSizeDescription] => 1280x853
[MediaModificationTimestamp] => 2026-06-23T18:26:11.700Z
)
[4] => Array
(
[Order] => 4
[MediaKey] => 6a3acfc3fec0dda8867f24c2
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540129/a4085de9fae86234a0ce3f32a43fa893.webp
[MediaSize] => 87620
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540129/thumbnail-a4085de9fae86234a0ce3f32a43fa893.webp
[ImageWidth] => 1280
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 853
[ResourceRecordKey] => 425540129
[ImageSizeDescription] => 1280x853
[MediaModificationTimestamp] => 2026-06-23T18:26:11.687Z
)
[5] => Array
(
[Order] => 5
[MediaKey] => 6a3acfc3fec0dda8867f24c3
[MediaURL] => https://cdn.realtyfeed.com/cdn/29/KEY425540129/929a9b0bf089285e7578aa380ae446ed.webp
[MediaSize] => 99484
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/29/KEY425540129/thumbnail-929a9b0bf089285e7578aa380ae446ed.webp
[ImageWidth] => 1280
[Permission] => Array
(
[0] => Public
)
[ImageHeight] => 853
[ResourceRecordKey] => 425540129
[ImageSizeDescription] => 1280x853
[MediaModificationTimestamp] => 2026-06-23T18:26:11.715Z
)
)
[ID] => 31833
)
)
[success] => 1
[page_size] => 6
[page_count] => 386
[count] => 2315
[after_key] =>
)
[RF Response Time] => 0.13 seconds
)
[RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=6&$skip=2058&$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' AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true] => Array
(
[RF Response] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse Object
(
[items] => Array
(
)
[success] => 1
[page_size] => 6
[page_count] => 334
[count] => 2000
[after_key] =>
)
[RF Response Time] => 0.07 seconds
)
[RF Cache Key: 0994f363cbe06885110e13d18678d2e1a5418f10992f657ec53b0700d8e266b4] => Array
(
[RF Cached Response] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse Object
(
[items] => Array
(
)
[success] => 1
[page_size] => 6
[page_count] => 334
[count] => 2000
[after_key] =>
)
)
)