array:1 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 5461657&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#15621
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15619
+post_id: "54166"
+post_author: 1
+"ListingKey": "5461657"
+"ListingId": "4053616"
+"PropertyType": "Residential"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-09-17T21:19:39Z"
+"RFModificationTimestamp": "2026-09-18T01:33:21Z"
+"ListPrice": "2175000"
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": "1"
+"BedroomsTotal": "7"
+"LotSizeArea": 0.52
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Piscataway Twp."
+"PostalCode": "08854"
+"UnparsedAddress": "11 Scarlet Dr, Piscataway Twp., NJ 08854"
+"Coordinates": array:2 [
0 => -74.476241111952
1 => 40.516186827724
]
+"Latitude": "40.516186827723814"
+"Longitude": "-74.47624111195184"
+"YearBuilt": "2026"
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "KELLER WILLIAMS ELITE REALTORS"
+"ListAgentMlsId": "293257"
+"ListOfficeMlsId": "2765"
+"OriginatingSystemName": "gsmls"
+"PublicRemarks": "This exceptional River Road Estates residence offers impressive scale, versatility and thoughtful design with 7 bedrooms, 5.5 baths and approximately 6,600+ sq. ft. across four expansive levels. The dramatic foyer opens to formal living and dining rooms and a soaring two-story family room filled with natural light and anchored by a fireplace. The expansive kitchen features quartz countertops, a substantial center island, stainless steel appliances, abundant cabinetry, pantry and butler's serving area. A first-floor primary suite with private bath provides exceptional flexibility. Upstairs, the luxurious primary retreat features a sitting area, oversized WIC and beautifully appointed bath with dual sinks, freestanding soaking tub and large glass-enclosed shower. Two additional bedrooms offer private en-suite baths, complemented by a bonus/flex room and dedicated laundry room. The finished third floor adds two bedrooms, full bath, loft and finished storage. A partially finished walkout basement offers tremendous future potential including pre-plumbed full bathroom with ejector pit. Additional highlights include a 3-car garage, Anderson windows, 300-amp electrical service, EV charging capability, generator and security pre-wiring, ethernet wiring and solid-core doors. A covered composite deck overlooks the wooded backyard, completing this remarkable home. Schedule your private showing and discover what makes this River Road Estates residence truly different."
+"Appliances": "Dishwasher, Disposal, Generator-Hookup, Kitchen Exhaust Fan, Microwave Oven, Range/Oven-Gas, Wall Oven(s) - Gas"
+"ArchitecturalStyle": "Colonial, Custom Home"
+"AttributionContact": "732-549-1998"
+"Basement": "Finished-Partially, Full, Walkout"
+"BathroomsFull": "5"
+"BuildingAreaUnits": "Sqft"
+"Cooling": "Central Air, Multi-Zone Cooling"
+"CreationDate": "2026-09-18T01:32:56.837246+00:00"
+"Directions": "River Rd to Hoes Ln 1st street on right or Hoes Ln, last street on left before River Rd. Use Scarlet dr in the GPS it should bring you to the street"
+"ExteriorFeatures": "Deck, Open Porch(es), Patio, Sidewalk"
+"FireplaceFeatures": "Family Room, Gas Fireplace"
+"FireplacesTotal": "1"
+"Flooring": "Carpeting, Tile, Wood"
+"GarageSpaces": "3"
+"Heating": "Forced Hot Air, Multi-Zone"
+"InteriorFeatures": "CeilHigh,SoakTub,WlkInCls"
+"InternetAutomatedValuationDisplayYN": false
+"InternetEntireListingDisplayYN": true
+"ListOfficePhone": "732-549-1998"
+"ListingContractDate": "2026-09-17"
+"LivingAreaUnits": "Sqft"
+"LotFeatures": "Cul-De-Sac"
+"LotSizeDimensions": "0.52 ACRES"
+"LotSizeUnits": "Acres"
+"MajorChangeTimestamp": "2026-09-17T21:18:11Z"
+"MlsStatus": "Active"
+"OriginalEntryTimestamp": "2026-09-17 21:18:11.0"
+"Ownership": "Fee Simple"
+"ParcelNumber": "2117-11901-0000-00022-0022-"
+"PhotosCount": "0"
+"Possession": "See Remarks"
+"Roof": "Asphalt Shingle"
+"RoomsTotal": "16"
+"Sewer": "Public Sewer"
+"StateOrProvince": "NJ"
+"StreetName": "Scarlet Dr"
+"StreetNumber": "11"
+"TaxAnnualAmount": "4257"
+"TaxAssessedValue": "271800"
+"TaxBlock": "11901"
+"TaxLot": "22.22"
+"TaxYear": "2025"
+"Utilities": "Gas-Natural"
+"WaterSource": "Public Water"
+"Township": "Piscataway Twp."
+"class_name": "RES"
+"LotSizeAcres": "0.52"
+"CountyOrParish": "Middlesex"
+"GSMLS_RoomBed1Level": "Second"
+"GSMLS_RoomDiningLevel": "First"
+"GSMLS_RoomFamilyLevel": "First"
+"GSMLS_RoomLivingLevel": "First"
+"GSMLS_RoomBed1Features": "Full Bath, Sitting Room, Walk-In Closet"
+"GSMLS_RoomKitchenLevel": "First"
+"GSMLS_RoomDiningFeatures": "Formal Dining Room"
+"GSMLS_RoomKitchenFeatures": "Center Island, Eat-In Kitchen, Pantry"
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('5461657')"
+"ID": "54166"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.08 seconds"
]
]