array:1 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 5450324&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#15359
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15357
+post_id: "44130"
+post_author: 1
+"ListingKey": "5450324"
+"ListingId": "4043812"
+"PropertyType": "Residential"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-31T12:07:23Z"
+"RFModificationTimestamp": "2026-09-05T11:32:36Z"
+"ListPrice": "1299000"
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": "1"
+"BedroomsTotal": "4"
+"LotSizeArea": 1.29
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Mahwah Twp."
+"PostalCode": "07430-1524"
+"UnparsedAddress": "27 Sparrowbush Rd, Mahwah Twp., NJ 07430-1524"
+"Coordinates": array:2 [
0 => -74.1105
1 => 41.08032
]
+"Latitude": "41.08032"
+"Longitude": "-74.1105"
+"YearBuilt": "2000"
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "KELLER WILLIAMS VILLAGE SQUARE"
+"ListAgentMlsId": "282009"
+"ListOfficeMlsId": "4182"
+"OriginatingSystemName": "gsmls"
+"PublicRemarks": "Set on 1.29 acres of park-like property, this impressive Colonial offers exceptional space, natural light, & a floor plan designed for comfortable living & effortless entertaining. A dramatic two-story foyer welcomes you into the home, where oversized rooms, soaring ceilings, & expansive windows create a bright, airy atmosphere throughout. Marble flooring throughout foyer, kitchen and dining room. An adjoining office/flex space provides endless possibilities for working from home, a playroom, or additional gathering space. The spacious living & dining rooms are ideal for hosting, while the two-story great room features a marble fireplace with walls of windows overlooking the private yard. The large eat-in kitchen offers abundant cabinetry, granite countertops, a center island & direct access to the expansive deck. Upstairs, the oversized primary suite boasts walk-in closet, & spacious marble bath with a soaking tub, oversized shower, & dual vanities. Three additional generously sized bedrooms and full hall bathroom provide plenty of room for all. The huge finished, walk-out lower level offers outstanding living space, media room, gym, or playroom. Outside, enjoy an incredible property surrounded by mature trees, exceptional privacy & endless possibilities for a pool, sports court, or outdoor oasis. An expansive deck overlooks the picturesque yard, creating the perfect setting for relaxing or entertaining."
+"Appliances": "Dishwasher, Microwave Oven, Range/Oven-Gas, Refrigerator"
+"ArchitecturalStyle": "Colonial"
+"AttributionContact": "201-294-2544"
+"Basement": "Finished, Full, Walkout"
+"BathroomsFull": "3"
+"BuildingAreaUnits": "Sqft"
+"Cooling": "Central Air"
+"CreationDate": "2026-09-05T11:32:31.869045+00:00"
+"Directions": "Carlough to Sparrowbush"
+"Exclusions": "Refrigerator in basement. Dryer"
+"FireplaceFeatures": "Wood Burning"
+"FireplacesTotal": "1"
+"GarageSpaces": "2"
+"Heating": "Baseboard - Hotwater, Multi-Zone"
+"InternetAutomatedValuationDisplayYN": false
+"InternetEntireListingDisplayYN": true
+"ListOfficePhone": "201-445-4300"
+"ListingContractDate": "2026-07-30"
+"LivingAreaUnits": "Sqft"
+"LotSizeDimensions": "1.29 AC."
+"LotSizeUnits": "Acres"
+"MajorChangeTimestamp": "2026-07-30T08:02:24Z"
+"MlsStatus": "Active"
+"OriginalEntryTimestamp": "2026-07-30 08:02:25.0"
+"Ownership": "Fee Simple"
+"ParcelNumber": "1133-00125-0000-00014-0000-"
+"PhotosChangeTimestamp": "2026-07-30T08:39:08Z"
+"PhotosCount": "29"
+"Possession": "See Remarks"
+"Roof": "Asphalt Shingle"
+"RoomsTotal": "9"
+"Sewer": "Public Sewer"
+"StateOrProvince": "NJ"
+"StreetName": "Sparrowbush Rd"
+"StreetNumber": "27"
+"TaxAnnualAmount": "18802"
+"TaxAssessedValue": "884000"
+"TaxBlock": "125"
+"TaxLot": "14"
+"TaxYear": "2025"
+"Utilities": "Gas-Natural"
+"WaterSource": "Public Water"
+"Township": "Mahwah Twp."
+"class_name": "RES"
+"LotSizeAcres": "1.29"
+"CountyOrParish": "Bergen"
+"GSMLS_RoomKitchenFeatures": "Center Island, Eat-In Kitchen"
+"Media": array:29 [
0 => array:11 [
"Order" => 0
"MediaKey" => "54503240"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/6201b9bbd8506c98856bf6eb0d2f2c1e.webp"
"ClassName" => null
"MediaSize" => 342105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-6201b9bbd8506c98856bf6eb0d2f2c1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
1 => array:11 [
"Order" => 1
"MediaKey" => "54503241"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/d23f7b3af38da7db89c38f443442766e.webp"
"ClassName" => null
"MediaSize" => 287499
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-d23f7b3af38da7db89c38f443442766e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
2 => array:11 [
"Order" => 2
"MediaKey" => "54503242"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/d6d7455061e251c0b4cba30a5b776217.webp"
"ClassName" => null
"MediaSize" => 278866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-d6d7455061e251c0b4cba30a5b776217.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
3 => array:11 [
"Order" => 3
"MediaKey" => "54503243"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/fbeb40315f973e6503bd33f2e3bb6f44.webp"
"ClassName" => null
"MediaSize" => 267798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-fbeb40315f973e6503bd33f2e3bb6f44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
4 => array:11 [
"Order" => 4
"MediaKey" => "54503244"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/70911101bcfa7f52e151190bfe74f1a5.webp"
"ClassName" => null
"MediaSize" => 273856
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-70911101bcfa7f52e151190bfe74f1a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
5 => array:11 [
"Order" => 5
"MediaKey" => "54503245"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/d112fc6f0c6ffb2b56689271bcb8c502.webp"
"ClassName" => null
"MediaSize" => 285522
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-d112fc6f0c6ffb2b56689271bcb8c502.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
6 => array:11 [
"Order" => 6
"MediaKey" => "54503246"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/65aec8857358b39b3c8106b16d3d5b95.webp"
"ClassName" => null
"MediaSize" => 207754
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-65aec8857358b39b3c8106b16d3d5b95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
7 => array:11 [
"Order" => 7
"MediaKey" => "54503247"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/98b14c948645f3aa5ab9750bf304c121.webp"
"ClassName" => null
"MediaSize" => 386150
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-98b14c948645f3aa5ab9750bf304c121.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
8 => array:11 [
"Order" => 8
"MediaKey" => "54503248"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/e76095b898217d67bf97769cf9e9a028.webp"
"ClassName" => null
"MediaSize" => 229839
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-e76095b898217d67bf97769cf9e9a028.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
9 => array:11 [
"Order" => 9
"MediaKey" => "54503249"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/8726ad42cd25670c1f5c93ee5abb63ac.webp"
"ClassName" => null
"MediaSize" => 253947
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-8726ad42cd25670c1f5c93ee5abb63ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
10 => array:11 [
"Order" => 10
"MediaKey" => "545032410"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/a399c7aadb738abdfd7eef289080e0d8.webp"
"ClassName" => null
"MediaSize" => 369643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-a399c7aadb738abdfd7eef289080e0d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
11 => array:11 [
"Order" => 11
"MediaKey" => "545032411"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/8a4b83d3965a85f08e3f5ebaf749308b.webp"
"ClassName" => null
"MediaSize" => 272325
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-8a4b83d3965a85f08e3f5ebaf749308b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
12 => array:11 [
"Order" => 12
"MediaKey" => "545032412"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/43710a56d1ad3035320396d38a16d1dd.webp"
"ClassName" => null
"MediaSize" => 300193
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-43710a56d1ad3035320396d38a16d1dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
13 => array:11 [
"Order" => 13
"MediaKey" => "545032413"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/b21921ec37f5aec9e5ca958f48a65f2c.webp"
"ClassName" => null
"MediaSize" => 278296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-b21921ec37f5aec9e5ca958f48a65f2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
14 => array:11 [
"Order" => 14
"MediaKey" => "545032414"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/eef8c98aecf8f19c872596deed262ff1.webp"
"ClassName" => null
"MediaSize" => 273365
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-eef8c98aecf8f19c872596deed262ff1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
15 => array:11 [
"Order" => 15
"MediaKey" => "545032415"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/8d95b986be0c1fa100fbe9205672a070.webp"
"ClassName" => null
"MediaSize" => 242727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-8d95b986be0c1fa100fbe9205672a070.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
16 => array:11 [
"Order" => 16
"MediaKey" => "545032416"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/0bd7bf4c45cb6c93a9f6f23c11a34465.webp"
"ClassName" => null
"MediaSize" => 249905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-0bd7bf4c45cb6c93a9f6f23c11a34465.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
17 => array:11 [
"Order" => 17
"MediaKey" => "545032417"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/ab8a4c7b226a4358a3fc93103b8b257c.webp"
"ClassName" => null
"MediaSize" => 244841
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-ab8a4c7b226a4358a3fc93103b8b257c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
18 => array:11 [
"Order" => 18
"MediaKey" => "545032418"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/5c5a30a78c0873ae6e6ad8391942f81a.webp"
"ClassName" => null
"MediaSize" => 269636
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-5c5a30a78c0873ae6e6ad8391942f81a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
19 => array:11 [
"Order" => 19
"MediaKey" => "545032419"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/21d579034a73ba0f2ebe1d89d99cd52a.webp"
"ClassName" => null
"MediaSize" => 356019
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-21d579034a73ba0f2ebe1d89d99cd52a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
20 => array:11 [
"Order" => 20
"MediaKey" => "545032420"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/7d51e280eea1c4a070356c45b56f848f.webp"
"ClassName" => null
"MediaSize" => 372799
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-7d51e280eea1c4a070356c45b56f848f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
21 => array:11 [
"Order" => 21
"MediaKey" => "545032421"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/3775f845b5baafaaba1ae9dfcbe0fb73.webp"
"ClassName" => null
"MediaSize" => 387147
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-3775f845b5baafaaba1ae9dfcbe0fb73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
22 => array:11 [
"Order" => 22
"MediaKey" => "545032422"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/760f4e72e3e7e4d951f5f286a4268e35.webp"
"ClassName" => null
"MediaSize" => 314049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-760f4e72e3e7e4d951f5f286a4268e35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
23 => array:11 [
"Order" => 23
"MediaKey" => "545032423"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/f1deff760d6ef64b2f1fca8ea2634fad.webp"
"ClassName" => null
"MediaSize" => 316646
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-f1deff760d6ef64b2f1fca8ea2634fad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
24 => array:11 [
"Order" => 24
"MediaKey" => "545032424"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/505d56e54d9c620b91a16d29f8725bed.webp"
"ClassName" => null
"MediaSize" => 274834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-505d56e54d9c620b91a16d29f8725bed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
25 => array:11 [
"Order" => 25
"MediaKey" => "545032425"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/08a947f49b226e00253e3a51a7c3e8bc.webp"
"ClassName" => null
"MediaSize" => 240876
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-08a947f49b226e00253e3a51a7c3e8bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
26 => array:11 [
"Order" => 26
"MediaKey" => "545032426"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/a3a2891c2e5c588c1bb9a6f9362800ca.webp"
"ClassName" => null
"MediaSize" => 244555
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-a3a2891c2e5c588c1bb9a6f9362800ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
27 => array:11 [
"Order" => 27
"MediaKey" => "545032427"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/208bb028f33608bfb8a592e855ca05fe.webp"
"ClassName" => null
"MediaSize" => 277662
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-208bb028f33608bfb8a592e855ca05fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
28 => array:11 [
"Order" => 28
"MediaKey" => "545032428"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/118/5450324/c2944215f98a448f8f5438c3191e7f4b.webp"
"ClassName" => null
"MediaSize" => 281108
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/118/5450324/thumbnail-c2944215f98a448f8f5438c3191e7f4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "5450324"
]
]
+"DaysOnMarket": 39
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('5450324')"
+"ID": "44130"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.05 seconds"
]
]