array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29979277 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
+post_id: "1585264"
+post_author: 1
+"ListingKey": "29979277"
+"ListingId": "X13513406"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T00:20:40Z"
+"RFModificationTimestamp": "2026-07-03T00:23:03Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2S1"
+"UnparsedAddress": "430 KELSO DRIVE, Waterloo, Ontario N2V2S1"
+"Coordinates": array:2 [
0 => -80.583859
1 => 43.490424
]
+"Latitude": 43.490424
+"Longitude": -80.583859
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 430 Kelso Drive, Waterloo: a beautifully maintained family home nestled in the highly sought-after Lakeshore North community. Situated on an impressive 44 x 139 ft. lot and just steps from the scenic Laurel Creek Conservation Area, this exceptional property offers fantastic curb appeal and parking for up to 4 vehicles, including a 2-car garage and 2-car private driveway. Step inside to a bright, carpet-free interior featuring soaring 9-foot ceilings, an open-concept layout and abundant natural light throughout. The kitchen comes complete with updated appliances, ample cabinetry, and generous counter space, making meal preparation effortless. The adjoining dining and living areas, anchored by a cozy electric fireplace create a warm, inviting atmosphere. Main floor laundry adds everyday convenience. Upstairs, you'll find 4 generously sized bedrooms and two full bathrooms, including a primary retreat with a walk-in closet and private ensuite. Designed with growing families in mind, the upper level offers both comfort and functionality. The fully finished basement adds tremendous versatility with a large recreation room, an additional bedroom and 3pc bathroom, ideal for extended family, guests, an in-law suite or mortgage-helper potential. This home has been thoughtfully upgraded for comfort and efficiency: a new heat pump (2024, doubling as central air), a two-stage furnace and refreshed R-60 attic insulation (2022) keep utility costs down year-round. Step outside to a huge, fully fenced, pool-sized backyard with a concrete patio, perfect for summer bbq's, family gatherings or simply relaxing. Set on a quiet street in one of Waterloo's most desirable neighbourhoods, this home is close to top-rated schools, parks, trails, universities, the YMCA, Conestoga Mall, shopping, restaurants, public transit, and major highways. A premium lot in an outstanding location, this house truly checks all the boxes. Don't miss your chance, book your private showing today! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Hood Fan"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T19:09:35.541665+00:00"
+"Directions": "Cross Streets: LakeLouise Blvd. ** Directions: Kelso Dr To LakeLouise Blvd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "44.8 x 139.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T19:29:47Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T00:13:07Z"
+"Stories": "2.0"
+"StreetName": "Kelso"
+"StreetNumber": "430"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6672"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/c95ms_430_kelso_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1673760138"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13513406"
"RoomLevel" => "Second level"
"RoomWidth" => 5.0
"ListingKey" => "29979277"
"RoomLength" => 4.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:13:07.06Z"
]
1 => array:11 [
"RoomKey" => "1673760139"
"RoomType" => "Bathroom"
"ListingId" => "X13513406"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29979277"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:13:07.06Z"
]
2 => array:11 [
"RoomKey" => "1673760140"
"RoomType" => "Bedroom"
"ListingId" => "X13513406"
"RoomLevel" => "Basement"
"RoomWidth" => 2.69
"ListingKey" => "29979277"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:13:07.06Z"
]
3 => array:11 [
"RoomKey" => "1673760141"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13513406"
"RoomLevel" => "Basement"
"RoomWidth" => 4.65
"ListingKey" => "29979277"
"RoomLength" => 8.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:13:07.06Z"
]
4 => array:11 [
"RoomKey" => "1673760142"
"RoomType" => "Bathroom"
"ListingId" => "X13513406"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29979277"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:13:07.06Z"
]
5 => array:11 [
"RoomKey" => "1673760143"
"RoomType" => "Bathroom"
"ListingId" => "X13513406"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29979277"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:13:07.06Z"
]
6 => array:11 [
"RoomKey" => "1673760144"
"RoomType" => "Bedroom"
"ListingId" => "X13513406"
"RoomLevel" => "Second level"
"RoomWidth" => 3.96
"ListingKey" => "29979277"
"RoomLength" => 4.01
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:13:07.06Z"
]
7 => array:11 [
"RoomKey" => "1673760145"
"RoomType" => "Bedroom"
"ListingId" => "X13513406"
"RoomLevel" => "Second level"
"RoomWidth" => 4.34
"ListingKey" => "29979277"
"RoomLength" => 3.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:13:07.06Z"
]
8 => array:11 [
"RoomKey" => "1673760146"
"RoomType" => "Bedroom"
"ListingId" => "X13513406"
"RoomLevel" => "Second level"
"RoomWidth" => 5.18
"ListingKey" => "29979277"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:13:07.06Z"
]
9 => array:11 [
"RoomKey" => "1673760147"
"RoomType" => "Bathroom"
"ListingId" => "X13513406"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29979277"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:13:07.06Z"
]
10 => array:11 [
"RoomKey" => "1673760148"
"RoomType" => "Living room"
"ListingId" => "X13513406"
"RoomLevel" => "Main level"
"RoomWidth" => 4.85
"ListingKey" => "29979277"
"RoomLength" => 6.91
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:13:07.07Z"
]
11 => array:11 [
"RoomKey" => "1673760149"
"RoomType" => "Kitchen"
"ListingId" => "X13513406"
"RoomLevel" => "Main level"
"RoomWidth" => 3.12
"ListingKey" => "29979277"
"RoomLength" => 3.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:13:07.07Z"
]
12 => array:11 [
"RoomKey" => "1673760150"
"RoomType" => "Dining room"
"ListingId" => "X13513406"
"RoomLevel" => "Main level"
"RoomWidth" => 3.86
"ListingKey" => "29979277"
"RoomLength" => 3.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:13:07.07Z"
]
13 => array:11 [
"RoomKey" => "1673760151"
"RoomType" => "Laundry room"
"ListingId" => "X13513406"
"RoomLevel" => "Main level"
"RoomWidth" => 2.26
"ListingKey" => "29979277"
"RoomLength" => 1.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:13:07.07Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29979277/430-kelso-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 44.9
+"OriginalEntryTimestamp": "2026-07-02T17:00:50.97Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29979277_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/1fc8d457a48b4f3f7e6f3f2aa1605d49.webp"
"MediaSize" => 327683
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-1fc8d457a48b4f3f7e6f3f2aa1605d49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29979277_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/7220e0a8b0682edbc34addbc6346eadf.webp"
"MediaSize" => 367123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-7220e0a8b0682edbc34addbc6346eadf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29979277_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/cdecb4e2c4e869595631de9c4668d0b9.webp"
"MediaSize" => 394831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-cdecb4e2c4e869595631de9c4668d0b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29979277_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/95610d50437ae88194d8249ffe4ee273.webp"
"MediaSize" => 93686
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-95610d50437ae88194d8249ffe4ee273.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29979277_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/58e31b0bb238fd4149f6f7dcf4813e57.webp"
"MediaSize" => 180221
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-58e31b0bb238fd4149f6f7dcf4813e57.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29979277_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/69d42b29156a1e177d61953195139beb.webp"
"MediaSize" => 152458
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-69d42b29156a1e177d61953195139beb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29979277_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/75bff65c32b4384f99e9ea1a2d7dacb2.webp"
"MediaSize" => 107640
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-75bff65c32b4384f99e9ea1a2d7dacb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29979277_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/b012d4056f2023c5cfb6bf80db51e0a0.webp"
"MediaSize" => 205330
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-b012d4056f2023c5cfb6bf80db51e0a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29979277_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/77177fe5d232f73538104e2010b8aee6.webp"
"MediaSize" => 204061
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-77177fe5d232f73538104e2010b8aee6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29979277_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/f87ff53dd7279dd384226ddc293c5688.webp"
"MediaSize" => 243822
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-f87ff53dd7279dd384226ddc293c5688.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29979277_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/5da0c3241e824a70a10d6a53d5d8e0a9.webp"
"MediaSize" => 247819
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-5da0c3241e824a70a10d6a53d5d8e0a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29979277_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/e7c1a760126a6b9a639ebb4031f70f49.webp"
"MediaSize" => 210268
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-e7c1a760126a6b9a639ebb4031f70f49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29979277_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/eab5967e8f5f246a8b622f1aeb0c2ff8.webp"
"MediaSize" => 194271
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-eab5967e8f5f246a8b622f1aeb0c2ff8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29979277_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/e05d570ac6d833c40ddc11c02127d924.webp"
"MediaSize" => 231617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-e05d570ac6d833c40ddc11c02127d924.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29979277_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/b8fd6cb2826f8b1272005e7740870aec.webp"
"MediaSize" => 200148
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-b8fd6cb2826f8b1272005e7740870aec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29979277_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/ce820e9001e3ab6d4a86a5ac010c94da.webp"
"MediaSize" => 192796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-ce820e9001e3ab6d4a86a5ac010c94da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29979277_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/46c230d80a3a288631e76d0f2d27d739.webp"
"MediaSize" => 126683
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-46c230d80a3a288631e76d0f2d27d739.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29979277_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/e12df156e01ac1f28fcac45600f9b34e.webp"
"MediaSize" => 107105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-e12df156e01ac1f28fcac45600f9b34e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29979277_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/a351b17a41736d1a164e0364b54f404f.webp"
"MediaSize" => 186459
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-a351b17a41736d1a164e0364b54f404f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29979277_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/91818c84e32840ba359760d5d2b6aa38.webp"
"MediaSize" => 139429
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-91818c84e32840ba359760d5d2b6aa38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29979277_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/b00b04b7fe5928e82b9eaadc2a82f362.webp"
"MediaSize" => 106133
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-b00b04b7fe5928e82b9eaadc2a82f362.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29979277_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/332958fd35305803194f88702d40a943.webp"
"MediaSize" => 131428
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-332958fd35305803194f88702d40a943.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29979277_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/f668c6b3d5bed30cd5d21e27af601f54.webp"
"MediaSize" => 190573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-f668c6b3d5bed30cd5d21e27af601f54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29979277_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/7c0045acb683f83202f51c5962d2c48b.webp"
"MediaSize" => 164666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-7c0045acb683f83202f51c5962d2c48b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29979277_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/ff9aafb5d01fad3ec8687dd40223f938.webp"
"MediaSize" => 142359
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-ff9aafb5d01fad3ec8687dd40223f938.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29979277_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/9cc8bb2240f59c7e07d6d9774069b638.webp"
"MediaSize" => 162172
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-9cc8bb2240f59c7e07d6d9774069b638.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29979277_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/0d87a4a7c78bc05ae90fc3be1bf108d8.webp"
"MediaSize" => 77126
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-0d87a4a7c78bc05ae90fc3be1bf108d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29979277_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/9b580080292d1640c928130f997cfe7f.webp"
"MediaSize" => 188624
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-9b580080292d1640c928130f997cfe7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29979277_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/ffbf5a69668c49bc0bf924f5498a83c0.webp"
"MediaSize" => 164994
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-ffbf5a69668c49bc0bf924f5498a83c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29979277_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/a5957d709879f16884a5a126b33650cb.webp"
"MediaSize" => 182272
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-a5957d709879f16884a5a126b33650cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29979277_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/4c3bc6257c24ae2f5a676fe2294a0923.webp"
"MediaSize" => 188703
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-4c3bc6257c24ae2f5a676fe2294a0923.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29979277_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/91e27337f25ed36e89b669149dfc4b1b.webp"
"MediaSize" => 107569
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-91e27337f25ed36e89b669149dfc4b1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29979277_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/67552ad998963c3804d345e8ce49fb69.webp"
"MediaSize" => 87677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-67552ad998963c3804d345e8ce49fb69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29979277_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/ebef42fdeb96d2accaf9457d3d85dcec.webp"
"MediaSize" => 109126
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-ebef42fdeb96d2accaf9457d3d85dcec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29979277_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/d16b69ff50527c04b71ae09ad304b12f.webp"
"MediaSize" => 89479
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-d16b69ff50527c04b71ae09ad304b12f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29979277_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/1ea445f37ec88af3551fb54135afa08e.webp"
"MediaSize" => 118889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-1ea445f37ec88af3551fb54135afa08e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29979277_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/03d89997ec42cb6a90853d265e77fe81.webp"
"MediaSize" => 91453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-03d89997ec42cb6a90853d265e77fe81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29979277_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/8bb640ff758f6c2e1e9d6a2cd301a437.webp"
"MediaSize" => 113838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-8bb640ff758f6c2e1e9d6a2cd301a437.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29979277_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/b96ac9f8ddbccda439067d43ff72bfcd.webp"
"MediaSize" => 87852
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-b96ac9f8ddbccda439067d43ff72bfcd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29979277_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/9cc4e8768e8c4b1be4631754bd2d89a2.webp"
"MediaSize" => 96756
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-9cc4e8768e8c4b1be4631754bd2d89a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29979277_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/0a24ed0e3d42ffc6af1d3da1600f327d.webp"
"MediaSize" => 403887
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-0a24ed0e3d42ffc6af1d3da1600f327d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29979277_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/34ab628f4ac1be5e9c115cf991a88b01.webp"
"MediaSize" => 406970
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-34ab628f4ac1be5e9c115cf991a88b01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29979277_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/f905c1822cc4f7b49cc34246c4970e3d.webp"
"MediaSize" => 425199
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-f905c1822cc4f7b49cc34246c4970e3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29979277_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/0aa9a4cad8c10dafd483ba790af9188e.webp"
"MediaSize" => 377217
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29979277/thumbnail-0aa9a4cad8c10dafd483ba790af9188e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13513406"
"ResourceRecordKey" => "29979277"
"ModificationTimestamp" => "2026-07-02T17:00:50.98Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29979277_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29979277/d569131cc8a9ab6e046be3ba5a26316d.webp"
"MediaSize" => 444627
"MediaType" => "webp"
…8
]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29979277')"
+"ID": "1585264"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 288578" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24923
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2130557" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24881
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29979277'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25288
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29979277'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25303
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25304
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31766926"
+"ListingKey": "29979277"
+"ListingId": "X13513406"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-04"
+"OpenHouseStartTime": "2026-07-04T14:00:00Z"
+"OpenHouseEndTime": "2026-07-04T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-04T04:15:47Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31766926')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25306
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31766927"
+"ListingKey": "29979277"
+"ListingId": "X13513406"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-05"
+"OpenHouseStartTime": "2026-07-05T14:00:00Z"
+"OpenHouseEndTime": "2026-07-05T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-04T04:15:47Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31766927')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29979277' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.583859 43.490424)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25381
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25375
+post_id: "1584362"
+post_author: 1
+"ListingKey": "29977664"
+"ListingId": "40842487"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T16:25:14Z"
+"RFModificationTimestamp": "2026-07-03T16:29:59Z"
+"ListPrice": 949900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2733.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2J3"
+"UnparsedAddress": "500 GLACIER Street, Waterloo, Ontario N2V2J3"
+"Coordinates": array:2 [
0 => -80.5790234
1 => 43.4957774
]
+"Latitude": 43.4957774
+"Longitude": -80.5790234
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "**PUBLIC OPEN HOUSE: SAT & SUN 2-4 PM** Welcome to 500 Glacier Street in Waterloo-your dream home with a spectacular backyard retreat, including a heated above-ground saltwater pool, backing onto greenspace & trails. Situated on an oversized corner lot in the highly desirable & family-oriented neighbourhood of Conservation Meadows, this lovely 4-bedroom, 3-bathroom home offers over 2,700 sq. ft. of finished living space, many recent updates & a bright, spacious open-concept layout perfect for entertaining or relaxing with family. The recently renovated gourmet kitchen features stainless steel appliances, a beautiful backsplash & a convenient centre island for casual dining, while the oversized dining area offers plenty of space for more formal gatherings. Relax & unwind in the sophisticated family room, complete with a gas fireplace, oversized windows & sliding door access to the expansive deck & pool area. A 2-piece bathroom & main floor laundry complete the main level. Upstairs, the stunning primary suite features vaulted ceilings, custom built-ins, two walk-in closets & a newly updated spa-like 3-piece ensuite with tiled glass shower, rain shower fixture, heated floors & heated towel rack. Two additional spacious bedrooms & a 4-piece main bathroom complete this level. The fully finished basement offers a large recreation room, a potential 4th bedroom & the added convenience of a walk-up directly into the garage.. Notable updates include furnace & air conditioning in 2017, shingles in 2015 & above-ground saltwater pool in 2018. Additional features include a carpet-free main & lower level with luxury vinyl flooring, custom blinds & more. Backing onto greenspace & walking trails, surrounded by mature trees & lush perennial gardens, this lovely home is located on a quiet, tree-lined street in a premium location close to schools, parks, Laurel Creek Conservation Area, shopping, restaurants, Starbucks, Sobeys, St. Jacobs Farmers’ Market, quick highway access & more. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T17:41:40.814366+00:00"
+"Directions": "Conservation Drive to Lake Louise to Glacier"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564122"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Corner Site"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T15:31:21Z"
+"PhotosCount": 49
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T16:18:39Z"
+"Stories": "2.0"
+"StreetName": "GLACIER"
+"StreetNumber": "500"
+"StreetSuffix": "Street"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5653"
+"VirtualTourURLUnbranded": "https://youriguide.com/500_glacier_street_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29977664/500-glacier-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 63.0
+"AboveGradeFinishedArea": 1854
+"BelowGradeFinishedArea": 879
+"OriginalEntryTimestamp": "2026-07-02T14:33:21.61Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1142829"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977664')"
+"ID": "1584362"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25377
+post_id: "1583779"
+post_author: 1
+"ListingKey": "29977455"
+"ListingId": "40841745"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T18:45:15Z"
+"RFModificationTimestamp": "2026-07-02T19:10:05Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.144
+"LivingArea": 3238.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2S5"
+"UnparsedAddress": "430 KELSO Drive, Waterloo, Ontario N2V2S5"
+"Coordinates": array:2 [
0 => -80.5838742
1 => 43.4904493
]
+"Latitude": 43.4904493
+"Longitude": -80.5838742
+"YearBuilt": 2009
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 430 Kelso Drive, Waterloo: a beautifully maintained family home nestled in the highly sought-after Lakeshore North community. Situated on an impressive 44 x 139 ft. lot and just steps from the scenic Laurel Creek Conservation Area, this exceptional property offers fantastic curb appeal and parking for up to 4 vehicles, including a 2-car garage and 2-car private driveway. Step inside to a bright, carpet-free interior featuring soaring 9-foot ceilings, an open-concept layout and abundant natural light throughout. The kitchen comes complete with updated appliances, ample cabinetry, and generous counter space, making meal preparation effortless. The adjoining dining and living areas, anchored by a cozy electric fireplace create a warm, inviting atmosphere. Main floor laundry adds everyday convenience. Upstairs, you'll find 4 generously sized bedrooms and two full bathrooms, including a primary retreat with a walk-in closet and private ensuite. Designed with growing families in mind, the upper level offers both comfort and functionality. The fully finished basement adds tremendous versatility with a large recreation room, an additional bedroom and 3pc bathroom, ideal for extended family, guests, an in-law suite or mortgage-helper potential. This home has been thoughtfully upgraded for comfort and efficiency: a new heat pump (2024, doubling as central air), a two-stage furnace and refreshed R-60 attic insulation (2022) keep utility costs down year-round. Step outside to a huge, fully fenced, pool-sized backyard with a concrete patio, perfect for summer bbq's, family gatherings or simply relaxing. Set on a quiet street in one of Waterloo's most desirable neighbourhoods, this home is close to top-rated schools, parks, trails, universities, the YMCA, Conestoga Mall, shopping, restaurants, public transit, and major highways. A premium lot in an outstanding location, this house truly checks all the boxes. Don't miss your chance, book your private showing today! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Hood Fan"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T16:19:31.551916+00:00"
+"Directions": "Kelso Dr/LakeLouise Blvd"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564507"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.144"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T18:34:06Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T18:34:06Z"
+"Stories": "2.0"
+"StreetName": "KELSO"
+"StreetNumber": "430"
+"StreetSuffix": "Drive"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "6672"
+"VirtualTourURLUnbranded": "https://youriguide.com/c95ms_430_kelso_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29977455/430-kelso-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 2250
+"BelowGradeFinishedArea": 988
+"OriginalEntryTimestamp": "2026-07-02T14:12:03.26Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1123254"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977455')"
+"ID": "1583779"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25374
+post_id: "1584541"
+post_author: 1
+"ListingKey": "29977329"
+"ListingId": "X13511442"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T15:20:05Z"
+"RFModificationTimestamp": "2026-07-03T15:27:41Z"
+"ListPrice": 949900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2J3"
+"UnparsedAddress": "500 GLACIER STREET, Waterloo, Ontario N2V2J3"
+"Coordinates": array:2 [
0 => -80.578434
1 => 43.495943
]
+"Latitude": 43.495943
+"Longitude": -80.578434
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "**PUBLIC OPEN HOUSE: SAT & SUN, 2-4 PM** Welcome to 500 Glacier Street in Waterloo - your dream home with a spectacular backyard retreat, including a heated above-ground saltwater pool, backing onto greenspace & trails. Situated on an oversized corner lot in the highly desirable & family-oriented neighbourhood of Conservation Meadows, this lovely 4-bed, 3-bath home offers over 2,700 sq. ft. of finished living space, many recent updates & a bright, spacious open-concept layout perfect for entertaining or relaxing with family. The recently renovated gourmet kitchen features stainless steel appliances, a beautiful backsplash & a convenient centre island for casual dining, while the oversized dining area offers plenty of space for more formal gatherings. Relax & unwind in the sophisticated family room, complete with a gas fireplace, oversized windows & sliding door access to the expansive deck & pool area. A 2-piece bathroom & main floor laundry complete the main level. Upstairs, the stunning primary suite features vaulted ceilings, custom built-ins, two walk-in closets & a newly updated spa-like 3-piece ensuite with tiled glass shower, rain shower fixture, heated floors & heated towel rack. Two additional spacious bedrooms & a 4-piece main bathroom complete this level. The fully finished basement offers a large recreation room, a potential 4th bedroom & the added convenience of a walk-up directly into the garage. Notable updates include furnace & air conditioning in 2017, shingles in 2015 & above-ground saltwater pool in 2018. Additional features include a carpet-free main & lower level with luxury vinyl flooring, custom blinds & more. Backing onto greenspace & walking trails, surrounded by mature trees & lush perennial gardens, this lovely home is located on a quiet, tree-lined street in a premium location close to schools, parks, Laurel Creek Conservation Area, shopping, restaurants, Starbucks, Sobeys, St. Jacobs Farmers' Market, quick highway access & more. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Water Treatment"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T15:52:13.449772+00:00"
+"Directions": "Cross Streets: Lake Louise Blvd. ** Directions: Conservation Drive to Lake Louise to Glacier."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2099842"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Wooded area"
1 => "Conservation/green belt"
2 => "Sump Pump"
]
+"LotSizeDimensions": "63.1 x 124.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T15:37:24Z"
+"PhotosCount": 45
+"PoolFeatures": array:2 [
0 => "Above ground pool"
1 => "Salt Water Pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T15:12:24Z"
+"Stories": "2.0"
+"StreetName": "Glacier"
+"StreetNumber": "500"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5653"
+"View": "View"
+"VirtualTourURLUnbranded": "https://youriguide.com/500_glacier_street_waterloo_on/doc/floorplan_imperial.pdf"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29977329/500-glacier-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 63.1
+"OriginalEntryTimestamp": "2026-07-02T13:47:07.33Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1370032"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977329')"
+"ID": "1584541"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25378
+post_id: "1582426"
+post_author: 1
+"ListingKey": "29975146"
+"ListingId": "40843757"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T15:00:07Z"
+"RFModificationTimestamp": "2026-07-01T16:49:13Z"
+"ListPrice": 1995000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3951.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2G3"
+"UnparsedAddress": "585 REGAL Place, Waterloo, Ontario N2V2G3"
+"Coordinates": array:2 [
0 => -80.6020125
1 => 43.4785166
]
+"Latitude": 43.4785166
+"Longitude": -80.6020125
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Positioned on a beautifully landscaped corner lot at the end of a quiet cul-de-sac, 585 Regal Place offers an exceptional blend of luxury, comfort, and everyday livability in one of Waterloo's most sought-after neighbourhoods. This former model home showcases over 4,300 sq. ft. of thoughtfully designed living space, including more than 3,500 sq. ft. on the main level, complemented by an oversized triple-car garage with soaring ceilings and a dedicated workshop area. A cobblestone driveway and covered front entrance introduce an impressive interior where 10-foot ceilings, expansive windows, and spacious principal rooms create an inviting atmosphere filled with natural light. The chef-inspired kitchen serves as the heart of the home, offering custom cabinetry, granite countertops, premium appliances, a large island, and seamless access to the breakfast area and covered outdoor living space, making entertaining effortless in every season. Elegant formal living and dining rooms provide refined spaces for hosting, accented by rich hardwood flooring, statement lighting, and walls perfectly suited for displaying artwork. The luxurious primary suite is a private sanctuary featuring a spa-inspired ensuite with a double-sided fireplace, soaker tub, and an expansive custom dressing room. Two additional bedrooms, including a private ensuite, a dedicated home office, main-floor laundry, and a beautifully finished lower level with recreation, fitness, and guest accommodations ensure flexibility for every stage of life. Professionally landscaped gardens, mature trees, and multiple outdoor seating areas create a peaceful setting to relax or entertain. Just minutes from championship golf, scenic walking trails, the St. Jacobs Farmers' Market, shopping, and highly regarded schools, this remarkable residence delivers the space, quality, and lifestyle today's discerning buyer is seeking. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Wine Fridge"
6 => "Stove"
7 => "Dryer"
8 => "Microwave"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T16:49:07.978429+00:00"
+"Directions": "Erbsville Rd to Regal Place"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564461"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T14:50:30Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T14:50:30Z"
+"Stories": "1.0"
+"StreetName": "REGAL"
+"StreetNumber": "585"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "18533"
+"VirtualTourURLUnbranded": "https://youriguide.com/585_regal_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29975146/585-regal-place-waterloo"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Monitored Alarm"
]
+"ZoningDescription": "SR4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 87.0
+"AboveGradeFinishedArea": 3181
+"BelowGradeFinishedArea": 770
+"OriginalEntryTimestamp": "2026-07-01T14:50:30.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1070059"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:44 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29975146')"
+"ID": "1582426"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25376
+post_id: "1571384"
+post_author: 1
+"ListingKey": "29956800"
+"ListingId": "40843284"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T00:40:03Z"
+"RFModificationTimestamp": "2026-06-29T00:54:06Z"
+"ListPrice": 875000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.12
+"LivingArea": 2776.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2J3"
+"UnparsedAddress": "491 SANDBANKS Crescent, Waterloo, Ontario N2V2J3"
+"Coordinates": array:2 [
0 => -80.5768597
1 => 43.4964463
]
+"Latitude": 43.4964463
+"Longitude": -80.5768597
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "IS THIS YOUR NEW HOME? Situated in desirable Conservation Meadows, this 2 Storey home offers a special option for those needing accessible features, including a main floor bedroom and ramp to the front door (2015) and also a ramp off the deck (2016). The stunning acacia engineered hardwood flooring (2019) greets you as you enter this bright and spacious main floor. The updates continue into the kitchen with new white cabinetry, quartz counters, stainless appliances and dimmable pot lights (2022). The sliders to the backyard walk out to the peaceful backyard showcasing lovely perennial gardens, and also features an Arctic Spa Yukon hot tub. Upstairs you will find 3 good-sized bedrooms including a spacious primary bedroom with large walk-in closet, and a long bathroom with potential for splitting it into two (a main bath and an ensuite bath). In the finished basement you will find a newly finished rec room, large utility room / workshop area, laundry room, cold cellar, and a separate den/office/storage room (potential for a 5th bedroom!). Additional updates include roof (2014), air conditioner (2017) washer/dryer (approx 2021), dishwasher (2024). (id:62650)"
+"AccessibilityFeatures": array:1 [
0 => "Accessible Approach with Ramp"
]
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T13:40:39.835887+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1990854"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Sump Pump"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T00:21:11Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T00:31:28Z"
+"Stories": "1.5"
+"StreetName": "SANDBANKS"
+"StreetNumber": "491"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "6158"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/view/?s=3148434&nohit=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29956800/491-sandbanks-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 2063
+"BelowGradeFinishedArea": 713
+"OriginalEntryTimestamp": "2026-06-26T13:01:54.37Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1274526"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29956800')"
+"ID": "1571384"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25371
+post_id: "1566184"
+post_author: 1
+"ListingKey": "29947549"
+"ListingId": "40842250"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T19:20:11Z"
+"RFModificationTimestamp": "2026-06-28T19:24:36Z"
+"ListPrice": 725000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 2273.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2H4"
+"UnparsedAddress": "658 ELLESMERE Court, Waterloo, Ontario N2V2H4"
+"Coordinates": array:2 [
0 => -80.5729223
1 => 43.4973152
]
+"Latitude": 43.4973152
+"Longitude": -80.5729223
+"YearBuilt": 1998
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautiful Thomas built Executive FREEHOLD Townhome. The bungalow feature makes it wonderful for anyone thinking of downsizing. Open concept living room and dining. Look through Galley kitchen for wonderful entertaining purposes. Backing onto the trans Canada Trail. Home is located on a wonderful cul-de-sac location in the quiet area of conservation Meadows. Parking for four cars, including a double car garage. All appliances included. Entrance to rear yard and deck off living. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T01:56:05.034971+00:00"
+"Directions": "OFF LAKE LOUISE"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564596"
+"ListOfficeKey": "76831"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-27T17:20:06Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T19:10:47Z"
+"Stories": "1.0"
+"StreetName": "ELLESMERE"
+"StreetNumber": "658"
+"StreetSuffix": "Court"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "4497.29"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/658-Ellesmere-Ct"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29947549/658-ellesmere-court-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1950017"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299554"
+"GeocodeManualYN": true
+"ZoningDescription": "RB"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1133
+"BelowGradeFinishedArea": 1140
+"OriginalEntryTimestamp": "2026-06-24T17:11:15.95Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1095797"
+"ListOfficeNationalAssociationId": "1004391"
+"CoListAgentNationalAssociationId": "1244287"
+"CoListOfficeNationalAssociationId": "1473831"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947549')"
+"ID": "1566184"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1565600"
+post_author: 1
+"ListingKey": "29947558"
+"ListingId": "40841264"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T16:25:09Z"
+"RFModificationTimestamp": "2026-06-30T16:30:46Z"
+"ListPrice": 829900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1841.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2Y4"
+"UnparsedAddress": "419 RIDEAU RIVER Street, Waterloo, Ontario N2V2Y4"
+"Coordinates": array:2 [
0 => -80.5885442
1 => 43.4909309
]
+"Latitude": 43.4909309
+"Longitude": -80.5885442
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 419 Rideau River Street, a beautifully maintained 4-bedroom, 3-bathroom home in a sought-after Waterloo neighbourhood. A charming brick exterior, double garage, and covered front porch offer an inviting first impression.Inside, the bright main floor features hardwood flooring, California shutters throughout, and a comfortable open-concept living and dining area. The kitchen offers warm cabinetry, upgraded counters, stainless steel appliances, a centre island with seating, and plenty of workspace. The primary bedroom includes a walk-in closet and private ensuite with a glass shower, while a second bedroom and full bathroom complete the main level.The finished basement adds exceptional living space with a spacious recreation room, gas fireplace, two legal bedrooms, and a full bathroom, ideal for family, guests, or a home office setup.Enjoy a fully fenced backyard with a patio, landscaped gardens, and a gas BBQ line. The included Broil King BBQ is new in 2026. Notable updates include a 50-year shingle roof (2021), water softener (2017), reverse osmosis system with filters changed in 2026, upgraded kitchen counters (2022), Maytag washer (2022), LG dishwasher (2023), Maytag dryer (2025), and KitchenAid 30 electric range (2026).Outdoor lovers will appreciate being just 150 ft from the entrance to Stamm Woodlot and its 3.5 km wooded walking trail. Conveniently located approximately 4.8 km from St. Jacobs Farmers' Market and 5.5 km from Hwy 7/8 via Northfield Drive. (id:62650)"
+"Appliances": array:1 [
0 => "Water softener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T01:04:27.455329+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2238484"
+"ListOfficeKey": "292003"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-30T15:51:24Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T16:11:50Z"
+"Stories": "1.0"
+"StreetName": "RIDEAU RIVER"
+"StreetNumber": "419"
+"StreetSuffix": "Street"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5740"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29947558/419-rideau-river-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 1042
+"BelowGradeFinishedArea": 799
+"OriginalEntryTimestamp": "2026-06-24T17:11:26.5Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1476314"
+"ListOfficeNationalAssociationId": "1407357"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947558')"
+"ID": "1565600"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25379
+post_id: "1565003"
+post_author: 1
+"ListingKey": "29948730"
+"ListingId": "40842788"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T16:05:13Z"
+"RFModificationTimestamp": "2026-07-03T16:11:10Z"
+"ListPrice": 1139000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3143.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P1"
+"UnparsedAddress": "723 BROOKMILL Place, Waterloo, Ontario N2V2P1"
+"Coordinates": array:2 [
0 => -80.5842507
1 => 43.4746813
]
+"Latitude": 43.4746813
+"Longitude": -80.5842507
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 723 Brookmill Place in the desirable neighbourhood of Laurelwood in Waterloo. Just steps from the Laurel Creek Conservation area, this expansive 4 bedroom 4 bathroom family home offers over 3,000 square feet of updated living space you can move right into and immediately enjoy. Step inside through the double door entry way and appreciate the bright, open concept layout with hardwood & porcelain floors, 9 ft ceiling heights and updated finishes throughout. The chef’s kitchen has been carefully designed to cater to a passion for cooking and hosting, featuring a 10 ft quartz island, gas stove, wine bar with wine fridge, and two stainless steel dishwashers. Host a dinner party in the formal dining area with friends and family, or curl up by the gas fireplace in the family room on a cold night. Upstairs, the spacious primary suite serves as a luxurious retreat, complete with a beautifully appointed double sink ensuite bathroom with a glass shower and a functional walk-in closet. Three more generously sized bedrooms with hardwood floors and a 4 pc bathroom complete the upper level. The basement features a bright, expansive layout with brand new custom-ordered carpet, a 4th bathroom, and plenty of storage space. Outside, your backyard oasis awaits! Landscaped with both privacy and functionality in mind, this peaceful outdoor space with new sodding, solar lighting and a 12 ft gazebo makes you feel like you’ve escaped the busy city. Steps away from conservation trails, public and Catholic schools, the YMCA, shopping, dining, universities, golf courses and so much more. New furnace with air hydration system, new kitchen appliances, new hot Water heater tank. With an array of luxurious features and thoughtful touches inside & out, this distinguished residence offers a lifestyle of unparalleled comfort and convenience thats perfect for your family’s next chapter. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Wine Fridge"
7 => "Dryer"
8 => "Microwave"
9 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T00:27:20.571658+00:00"
+"Directions": "Laurelwood Dr/ Brookmill Ct"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2088817"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T16:00:57Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T16:00:57Z"
+"Stories": "2.0"
+"StreetName": "BROOKMILL"
+"StreetNumber": "723"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "6960.78"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29948730/723-brookmill-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R 5"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2459
+"BelowGradeFinishedArea": 684
+"OriginalEntryTimestamp": "2026-06-24T19:51:09.22Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1362124"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29948730')"
+"ID": "1565003"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25380
+post_id: "1565101"
+post_author: 1
+"ListingKey": "29946711"
+"ListingId": "X13483494"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T12:10:07Z"
+"RFModificationTimestamp": "2026-06-29T12:13:27Z"
+"ListPrice": 829900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2Y4"
+"UnparsedAddress": "419 RIDEAU RIVER STREET, Waterloo, Ontario N2V2Y4"
+"Coordinates": array:2 [
0 => -80.588549
1 => 43.49095
]
+"Latitude": 43.49095
+"Longitude": -80.588549
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome to 419 Rideau River Street, a beautifully maintained 4-bedroom, 3-bathroom home in a sought-after Waterloo neighbourhood. A charming brick exterior, double garage, and covered front porch offer an inviting first impression.Inside, the bright main floor features hardwood flooring, California shutters throughout, and a comfortable open-concept living and dining area. The kitchen offers warm cabinetry, upgraded counters, stainless steel appliances, a centre island with seating, and plenty of workspace. The primary bedroom includes a walk-in closet and private ensuite with a glass shower, while a second bedroom and full bathroom complete the main level.The finished basement adds exceptional living space with a spacious recreation room, gas fireplace, two legal bedrooms, and a full bathroom, ideal for family, guests, or a home office setup.Enjoy a fully fenced backyard with a patio, landscaped gardens, and a gas BBQ line. The included Broil King BBQ is new in 2026. Notable updates include a 50-year shingle roof (2021), water softener (2017), reverse osmosis system with filters changed in 2026, upgraded kitchen counters (2022), Maytag washer (2022), LG dishwasher (2023), Maytag dryer (2025), and KitchenAid 30" electric range (2026).Outdoor lovers will appreciate being just 150 ft from the entrance to Stamm Woodlot and its 3.5 km wooded walking trail. Conveniently located approximately 4.8 km from St. Jacobs Farmers' Market and 5.5 km from Hwy 7/8 via Northfield Drive. (id:62650)"
+"Appliances": array:1 [
0 => "Water softener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T20:21:03.319748+00:00"
+"Directions": "Conservation Dr & Rideau River St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1962651"
+"ListOfficeKey": "293196"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40 x 101.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T18:56:17Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T12:01:32Z"
+"Stories": "1.0"
+"StreetName": "Rideau River"
+"StreetNumber": "419"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5740"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "OnePoint"
+"TaxYear": 2025
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29946711/419-rideau-river-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1834162"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1899457"
+"CoListOfficeKey": "293196"
+"GeocodeManualYN": false
+"CoListOfficeKey2": "292096"
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2026-06-24T15:34:32.99Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1252137"
+"ListOfficeNationalAssociationId": "1423680"
+"CoListAgentNationalAssociationId": "1196633"
+"CoListAgentNationalAssociationId2": "1216506"
+"CoListOfficeNationalAssociationId": "1423680"
+"CoListOfficeNationalAssociationId2": "1408169"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946711')"
+"ID": "1565101"
}
]
+success: true
+page_size: 9
+page_count: 7
+count: 60
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]