array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30034584 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23472
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23474
+post_id: "1626530"
+post_author: 1
+"ListingKey": "30034584"
+"ListingId": "40844927"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T19:50:03Z"
+"RFModificationTimestamp": "2026-07-17T23:46:33Z"
+"ListPrice": 3150000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 6452.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2G3"
+"UnparsedAddress": "596 REGAL Place, Waterloo, Ontario N2V2G3"
+"Coordinates": array:2 [
0 => -80.6023274
1 => 43.4779011
]
+"Latitude": 43.4779011
+"Longitude": -80.6023274
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience upscale living in this stunning, over 6000 sq ft rarely found bungalow located in one of Waterloo’s most prestigious neighborhoods! The main level features three bedrooms, each with its own walk-in closet and private ensuite! A bright, welcoming foyer leads to a spacious living room with 12 ft ceiling, a gas fireplace, a stunning, open-concept kitchen with a large granite countertop, plenty of cabinets, butler's kitchen, high-end Miele appliances, and a sunny dining area that’s sure to impress. The main floor also includes an office with large windows for plenty of natural light, a separate dining room, a generous walk-in kitchen pantry, a beautiful 2 piece bathroom, and a laundry room. Head down to the expansive wide open basement and discover large windows, two large additional bedrooms (one currently serving as a gym), a luxurious three-piece bathroom, two spacious living areas, a bar/kitchenette, and plenty of room to let your creativity flow. The garage fits three cars and includes stairs leading down to the basement. This home features in-floor heating, granite countertops, high-end finishes throughout and top-of-the-line craftsmanship. The beautifully landscaped backyard is an entertainer’s dream, complete with an inground heated pool, a covered sitting area, and plenty of space for kids to play or for hosting parties. Regal Place is a private street with no through traffic and close to some of the best schools in the region and many amenities. Homes like this are rarely offered for sale. Don't let this one slip away! (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Range - Gas"
6 => "Dishwasher"
7 => "Dryer"
8 => "Freezer"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
12 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T14:09:19.084098+00:00"
+"Directions": "Erbsville Rd"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2046754"
+"ListOfficeKey": "76840"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T19:41:11Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T19:41:11Z"
+"Stories": "1.0"
+"StreetName": "REGAL"
+"StreetNumber": "596"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "17817.31"
+"VirtualTourURLUnbranded": "https://youriguide.com/596_regal_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:20 [
0 => array:11 [
"RoomKey" => "1685100514"
"RoomType" => "Living room"
"ListingId" => "40844927"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034584"
"RoomLength" => null
"RoomDimensions" => "17'4'' x 18'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T17:29:18.38Z"
]
1 => array:11 [
"RoomKey" => "1685100515"
"RoomType" => "Storage"
"ListingId" => "40844927"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30034584"
"RoomLength" => null
"RoomDimensions" => "15'5'' x 31'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T17:29:18.38Z"
]
2 => array:11 [
"RoomKey" => "1685100516"
"RoomType" => "Utility room"
"ListingId" => "40844927"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30034584"
"RoomLength" => null
"RoomDimensions" => "17'10'' x 22'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T17:29:18.38Z"
]
3 => array:11 [
"RoomKey" => "1685100517"
"RoomType" => "3pc Bathroom"
"ListingId" => "40844927"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30034584"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T17:29:18.38Z"
]
4 => array:11 [
"RoomKey" => "1685100518"
"RoomType" => "Kitchen"
"ListingId" => "40844927"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30034584"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T17:29:18.38Z"
]
5 => array:11 [
"RoomKey" => "1685100519"
"RoomType" => "Bedroom"
"ListingId" => "40844927"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30034584"
"RoomLength" => null
"RoomDimensions" => "15'11'' x 20'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T17:29:18.38Z"
]
6 => array:11 [
"RoomKey" => "1685100520"
"RoomType" => "Bedroom"
"ListingId" => "40844927"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30034584"
"RoomLength" => null
"RoomDimensions" => "13'8'' x 29'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T17:29:18.39Z"
]
7 => array:11 [
"RoomKey" => "1685100521"
"RoomType" => "Living room"
"ListingId" => "40844927"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30034584"
"RoomLength" => null
"RoomDimensions" => "36'10'' x 40'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T17:29:18.39Z"
]
8 => array:11 [
"RoomKey" => "1685100522"
"RoomType" => "Laundry room"
"ListingId" => "40844927"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034584"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T17:29:18.39Z"
]
9 => array:11 [
"RoomKey" => "1685100523"
"RoomType" => "Office"
"ListingId" => "40844927"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034584"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T17:29:18.39Z"
]
10 => array:11 [
"RoomKey" => "1685100524"
"RoomType" => "Breakfast"
"ListingId" => "40844927"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034584"
"RoomLength" => null
"RoomDimensions" => "8' x 14'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T17:29:18.39Z"
]
11 => array:11 [
"RoomKey" => "1685100525"
"RoomType" => "Kitchen"
"ListingId" => "40844927"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034584"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 21'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T17:29:18.39Z"
]
12 => array:11 [
"RoomKey" => "1685100526"
"RoomType" => "Dining room"
"ListingId" => "40844927"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034584"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 15'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T17:29:18.39Z"
]
13 => array:11 [
"RoomKey" => "1685100527"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844927"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034584"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T17:29:18.39Z"
]
14 => array:11 [
"RoomKey" => "1685100528"
"RoomType" => "3pc Bathroom"
"ListingId" => "40844927"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034584"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T17:29:18.39Z"
]
15 => array:11 [
"RoomKey" => "1685100529"
"RoomType" => "Bedroom"
"ListingId" => "40844927"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034584"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 15'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T17:29:18.39Z"
]
16 => array:11 [
"RoomKey" => "1685100530"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844927"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034584"
"RoomLength" => null
"RoomDimensions" => "''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T17:29:18.39Z"
]
17 => array:11 [
"RoomKey" => "1685100531"
"RoomType" => "Bedroom"
"ListingId" => "40844927"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034584"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 14'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T17:29:18.39Z"
]
18 => array:11 [
"RoomKey" => "1685100532"
"RoomType" => "Full bathroom"
"ListingId" => "40844927"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034584"
"RoomLength" => null
"RoomDimensions" => "''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T17:29:18.4Z"
]
19 => array:11 [
"RoomKey" => "1685100533"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844927"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034584"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 19'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T17:29:18.4Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30034584/596-regal-place-waterloo"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 78.0
+"AboveGradeFinishedArea": 3285
+"BelowGradeFinishedArea": 3167
+"OriginalEntryTimestamp": "2026-07-15T11:49:59.46Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1322161"
+"ListOfficeNationalAssociationId": "1004363"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30034584_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/23a40424bf22c34b21b445e9afb3af22.webp"
"MediaSize" => 149289
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-23a40424bf22c34b21b445e9afb3af22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30034584_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/654d2ca1109b16db61cb6b7c9a2ff44c.webp"
"MediaSize" => 132957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-654d2ca1109b16db61cb6b7c9a2ff44c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30034584_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/9e4cf8cde9b32631f6a10ba086c253c2.webp"
"MediaSize" => 170841
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-9e4cf8cde9b32631f6a10ba086c253c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30034584_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/95d3d0cc2d4f9a32c1efaebe4cc9ec88.webp"
"MediaSize" => 115192
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-95d3d0cc2d4f9a32c1efaebe4cc9ec88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30034584_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/e9d0143a010b348bbfd48957f67ae0b1.webp"
"MediaSize" => 147833
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-e9d0143a010b348bbfd48957f67ae0b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30034584_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/1bb46f9aed614851f89025b782391d88.webp"
"MediaSize" => 61878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-1bb46f9aed614851f89025b782391d88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30034584_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/3c379a23e553746e9e73e31cd8ce9c9b.webp"
"MediaSize" => 57897
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-3c379a23e553746e9e73e31cd8ce9c9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30034584_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/3181bacf70346f75a71f74aedd0c5328.webp"
"MediaSize" => 78787
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-3181bacf70346f75a71f74aedd0c5328.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30034584_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/f776b45890d6f9ade02ed186d73186c2.webp"
"MediaSize" => 79401
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-f776b45890d6f9ade02ed186d73186c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30034584_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/782a5e4bc80de828babe50534390b74f.webp"
"MediaSize" => 73451
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-782a5e4bc80de828babe50534390b74f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30034584_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/7bef0676c7deafa69a7594b77dfee235.webp"
"MediaSize" => 77065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-7bef0676c7deafa69a7594b77dfee235.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30034584_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/6088a195d7c6619434a073edb3aceb4b.webp"
"MediaSize" => 80580
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-6088a195d7c6619434a073edb3aceb4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30034584_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/ab947d3f30c8d9a38d9e50a6e5c0c2ea.webp"
"MediaSize" => 101742
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-ab947d3f30c8d9a38d9e50a6e5c0c2ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30034584_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/614bd8f170b5cefc8d9b03f6255d7cbd.webp"
"MediaSize" => 89865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-614bd8f170b5cefc8d9b03f6255d7cbd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30034584_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/a982eb371440d5a7d0f65b9da31ebf8d.webp"
"MediaSize" => 102372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-a982eb371440d5a7d0f65b9da31ebf8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30034584_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/9823c233c2bb2f4f1c5c99dcad3040d7.webp"
"MediaSize" => 73092
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-9823c233c2bb2f4f1c5c99dcad3040d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30034584_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/91020e284272260762299199fec1d026.webp"
"MediaSize" => 88399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-91020e284272260762299199fec1d026.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30034584_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/56ce208b5a9cfde929c561274bfe1070.webp"
"MediaSize" => 90861
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-56ce208b5a9cfde929c561274bfe1070.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30034584_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/df9140ca73d2d4a9af820fa62605affe.webp"
"MediaSize" => 84809
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-df9140ca73d2d4a9af820fa62605affe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30034584_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/60ad102b6bcd19a0b06cf1a5df2e8c5c.webp"
"MediaSize" => 84877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-60ad102b6bcd19a0b06cf1a5df2e8c5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30034584_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/67fb00a6dddc437f42d279d8f76ec5ac.webp"
"MediaSize" => 65117
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-67fb00a6dddc437f42d279d8f76ec5ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30034584_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/c21d94791d13a8278d787ddab019cd0e.webp"
"MediaSize" => 72606
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-c21d94791d13a8278d787ddab019cd0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30034584_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/7ed0bb97c3a50448df055928ca363d9c.webp"
"MediaSize" => 62321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-7ed0bb97c3a50448df055928ca363d9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30034584_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/716e5a659a97b4c08da6a77967f75707.webp"
"MediaSize" => 54824
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-716e5a659a97b4c08da6a77967f75707.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30034584_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/956d03e9cfea25d123f64d2c63357486.webp"
"MediaSize" => 64783
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-956d03e9cfea25d123f64d2c63357486.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30034584_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/86978640b1308e65a78319bd906223ae.webp"
"MediaSize" => 61135
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-86978640b1308e65a78319bd906223ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30034584_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/52f7f34bbba95dd2fd98e77e57ff4fb2.webp"
"MediaSize" => 53560
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-52f7f34bbba95dd2fd98e77e57ff4fb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30034584_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/964867052c96876355de865dfb41fd25.webp"
"MediaSize" => 66117
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-964867052c96876355de865dfb41fd25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30034584_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/41c48b2efcba6140849d531676b4b568.webp"
"MediaSize" => 63425
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-41c48b2efcba6140849d531676b4b568.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30034584_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/e9f11607b895cfbef667d076c90561fd.webp"
"MediaSize" => 60032
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-e9f11607b895cfbef667d076c90561fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30034584_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/b37bf6acc0bfcb2a797f138023f49c2e.webp"
"MediaSize" => 80384
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-b37bf6acc0bfcb2a797f138023f49c2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30034584_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/cc32f175351dbd25102232050ed54585.webp"
"MediaSize" => 54726
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-cc32f175351dbd25102232050ed54585.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30034584_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/86452a0b743a4244cc754db9cd7e5e2f.webp"
"MediaSize" => 69632
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-86452a0b743a4244cc754db9cd7e5e2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30034584_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/d3c6b22e8d6bffa99638ae915f9ae379.webp"
"MediaSize" => 84281
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-d3c6b22e8d6bffa99638ae915f9ae379.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30034584_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/687d3d0cb1d83515057ee14114b87059.webp"
"MediaSize" => 86875
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-687d3d0cb1d83515057ee14114b87059.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "30034584_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/9c96a4ee8f38a99117c0fd9902f4fbd6.webp"
"MediaSize" => 92510
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-9c96a4ee8f38a99117c0fd9902f4fbd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "30034584_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/4a0807f6b77368a0b3c7030f5779de43.webp"
"MediaSize" => 67529
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-4a0807f6b77368a0b3c7030f5779de43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "30034584_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/9893d396a8d2e9273d8b02723a8423e3.webp"
"MediaSize" => 72267
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-9893d396a8d2e9273d8b02723a8423e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "30034584_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/3f5196418ed270da4a4f6560ccae8eb9.webp"
"MediaSize" => 88773
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-3f5196418ed270da4a4f6560ccae8eb9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "30034584_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/971d810e72796d20260898cac85b3055.webp"
"MediaSize" => 64439
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-971d810e72796d20260898cac85b3055.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "30034584_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/a338730782902e756c491e6a57f74777.webp"
"MediaSize" => 74049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034584/thumbnail-a338730782902e756c491e6a57f74777.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844927"
"ResourceRecordKey" => "30034584"
"ModificationTimestamp" => "2026-07-15T11:49:59.46Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "30034584_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034584/21be72751ce18314fc85b1dd598e0eef.webp"
"MediaSize" => 65697
"MediaType" => "webp"
…8
]
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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30034584')"
+"ID": "1626530"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 76840" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25014
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24958
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "ROYAL LEPAGE WOLLE REALTY"
+"OfficeEmail": null
+"OfficePhone": "519-578-7300"
+"OfficeMlsId": "KW242"
+"ModificationTimestamp": "2026-03-24T17:19:43Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "76840"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "71 Weber Street E."
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "KITCHENER"
+"OfficePostalCode": "N2H1C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1004363"
+"OriginalEntryTimestamp": null
+"OfficeFax": "519-742-9904"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:3 [
0 => array:6 [ …6]
1 => array:6 [ …6]
2 => array:6 [ …6]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1070302"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('76840')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2046754" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24968
+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 '30034584'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25324
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30034584' AND OpenHouseDate ge '2026-07-17'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25342
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25340
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "32000730"
+"ListingKey": "30034584"
+"ListingId": "40844927"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-18"
+"OpenHouseStartTime": "2026-07-18T14:00:00Z"
+"OpenHouseEndTime": "2026-07-18T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-18T04:58:07Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('32000730')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30034584' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.6023274 43.4779011)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25415
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25409
+post_id: "1625929"
+post_author: 1
+"ListingKey": "30031018"
+"ListingId": "X13561526"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T03:15:03Z"
+"RFModificationTimestamp": "2026-07-18T03:18:35Z"
+"ListPrice": 897000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2Y6"
+"UnparsedAddress": "606 PINERY TRAIL, Waterloo, Ontario N2V2Y6"
+"Coordinates": array:2 [
0 => -80.590278
1 => 43.490303
]
+"Latitude": 43.490303
+"Longitude": -80.590278
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to your dream home in the prestigious Conservation Meadows community - one of Waterloo's most sought-after, family-friendly neighbourhoods! This exquisite custom-built 4-bedroom, 3-bathroom detached home is loaded with high-end upgrades and modern design throughout. Soaring 9-foot ceilings on both floors, 8-foot doors, custom trim, steel-framed staircase, hardwood floors, and California shutters set the tone from the moment you enter. The gourmet eat-in kitchen features granite countertops, a large central island, and opens seamlessly to the living room with a stunning double-sided gas fireplace. An adjacent formal dining room and a main floor powder room complete this exquisite space. Upstairs, an expansive family room with its own gas fireplace and a walk-out to a private balcony add exceptional versatility and functionality. The primary suite comes with a luxurious 5-piece ensuite and a large walk-in closet with custom shelving. Three additional bright bedrooms, and 4-piece bathroom complete the second level. The unfinished basement roughed in for a bathroom, presents a blank slate for an entertainers dream or additional bedroom suite for guests and family. The curb appeal is striking with an exposed aggregate concrete driveway and professionally landscaped front yard. In the back, 8-foot sliding doors flooding the main floor with natural light open to a large deck and a fully fenced backyard. Additional features include main floor laundry room with garage access, owned water softener and rough-in central vac. Steps to scenic trails and Laurel Creek Conservation Area, and just minutes to St. Jacobs Market, the Boardwalk, Conestoga Mall, top-rated schools, parks, and major highways. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-14T19:49:41.681116+00:00"
+"Directions": "Conservation & Rideau River"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2102918"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Sump Pump"
]
+"LotSizeDimensions": "39.6 x 101.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-14T16:40:51Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T03:08:23Z"
+"Stories": "2.0"
+"StreetName": "Pinery"
+"StreetNumber": "606"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "7992"
+"VirtualTourURLUnbranded": "https://youriguide.com/606_pinery_trail_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": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30031018/606-pinery-trail-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 39.7
+"OriginalEntryTimestamp": "2026-07-14T16:40:51.12Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1372568"
+"ListOfficeNationalAssociationId": "1385020"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30031018')"
+"ID": "1625929"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25411
+post_id: "1624331"
+post_author: 1
+"ListingKey": "30031061"
+"ListingId": "40847488"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T16:05:27Z"
+"RFModificationTimestamp": "2026-07-15T16:25:27Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1398.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2X1"
+"UnparsedAddress": "619 WILD GINGER Avenue Unit# H47, Waterloo, Ontario N2V2X1"
+"Coordinates": array:2 [
0 => -80.5939632
1 => 43.4698313
]
+"Latitude": 43.4698313
+"Longitude": -80.5939632
+"YearBuilt": 2006
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "***OPEN HOUSE: SATURDAY JULY 18TH AND SUNDAY JULY 19TH 2-4pm*** Welcome to Unit H47 at 619 Wild Ginger Avenue, a beautifully refreshed four-level townhome offering exceptional value for first-time buyers, families, or investors. Lovingly maintained by the same tenant since 2007, this home has been thoughtfully updated and is move-in ready. Freshly painted throughout, with new flooring, modern lighting, and a stylish new kitchen backsplash, it offers a bright feel from the moment you arrive. The Furnace and AC were replaced in 2024 and 2026 respectively. The front door was replaced in 2022. The main level features a spacious eat-in kitchen, a convenient two-piece powder room, and a generous living room overlooking your private backyard. Upstairs, you'll find two large bedrooms, including a primary bedroom with direct access to the four-piece main bathroom through a convenient cheater ensuite. The lower level offers an ideal third bedroom, home office, or family room, complete with its own three-piece ensuite bathroom. Sliding doors lead to a private deck and fenced backyard. The basement, accessible through the attached garage, houses the laundry area, HVAC system, and additional storage space. Located in a desirable neighbourhood, this home is close to excellent elementary and secondary schools, shopping, parks, public transit, and other everyday conveniences. Whether you're looking for your next home or a smart investment opportunity, this property is one you won't want to miss. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Central Vacuum - Roughed In"
]
+"AssociationFee": "277"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Insurance"
]
+"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-14T19:42:59.525510+00:00"
+"Directions": "First right turn into complex off of Wild Ginger Ave"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2067711"
+"ListOfficeKey": "286933"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-14T20:48:23Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T15:59:27Z"
+"Stories": "3.0"
+"StreetName": "WILD GINGER"
+"StreetNumber": "619"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3852.78"
+"VirtualTourURLUnbranded": "https://youriguide.com/h47_619_wild_ginger_ave_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30031061/619-wild-ginger-avenue-unit-h47-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1564408"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "286933"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "70-RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1398
+"OriginalEntryTimestamp": "2026-07-14T16:48:17.46Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1342782"
+"ListOfficeNationalAssociationId": "1364894"
+"CoListAgentNationalAssociationId": "1129302"
+"CoListOfficeNationalAssociationId": "1364894"
+"Media": array:37 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30031061')"
+"ID": "1624331"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25408
+post_id: "1621982"
+post_author: 1
+"ListingKey": "30028922"
+"ListingId": "40845774"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T02:30:01Z"
+"RFModificationTimestamp": "2026-07-18T02:35:05Z"
+"ListPrice": 897000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2613.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2Y6"
+"UnparsedAddress": "606 PINERY Trail, Waterloo, Ontario N2V2Y6"
+"Coordinates": array:2 [
0 => -80.5909464
1 => 43.4901449
]
+"Latitude": 43.4901449
+"Longitude": -80.5909464
+"YearBuilt": 2015
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to your dream home in the prestigious Conservation Meadows community — one of Waterloo's most sought-after, family-friendly neighbourhoods! This exquisite custom-built 4-bedroom, 3-bathroom detached home is loaded with high-end upgrades and modern design throughout. Soaring 9-foot ceilings on both floors, 8-foot doors, custom trim, steel-framed staircase, hardwood floors, and California shutters set the tone from the moment you enter. The gourmet eat-in kitchen features granite countertops, a large central island, and opens seamlessly to the living room with a stunning double-sided gas fireplace. An adjacent formal dining room and a main floor powder room complete this exquisite space. Upstairs, an expansive family room with its own gas fireplace and a walk-out to a private balcony add exceptional versatility and functionality. The primary suite comes with a luxurious 5-piece ensuite and a large walk-in closet with custom shelving. Three additional bright bedrooms, and 4-piece bathroom complete the second level. The unfinished basement roughed in for a bathroom, presents a blank slate for an entertainers dream or additional bedroom suite for guests and family. The curb appeal is striking with an exposed aggregate concrete driveway and professionally landscaped front yard. In the back, 8-foot sliding doors flooding the main floor with natural light open to a large deck and a fully fenced backyard. Additional features include main floor laundry room with garage access, owned water softener and rough-in central vac. Steps to scenic trails and Laurel Creek Conservation Area, and just minutes to St. Jacobs Market, the Boardwalk, Conestoga Mall, top-rated schools, parks, and major highways. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-14T03:23:27.756438+00:00"
+"Directions": "Conservation & Rideau River"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1930634"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-18T02:20:27Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T02:29:58Z"
+"Stories": "2.0"
+"StreetName": "PINERY"
+"StreetNumber": "606"
+"StreetSuffix": "Trail"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "7992"
+"VirtualTourURLUnbranded": "https://youriguide.com/606_pinery_trail_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/30028922/606-pinery-trail-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2613
+"OriginalEntryTimestamp": "2026-07-14T02:29:30.86Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1231368"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30028922')"
+"ID": "1621982"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25412
+post_id: "1621722"
+post_author: 1
+"ListingKey": "30027421"
+"ListingId": "40842165"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T20:55:28Z"
+"RFModificationTimestamp": "2026-07-13T23:04:11Z"
+"ListPrice": 149900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 700.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3Z4"
+"UnparsedAddress": "580 BEAVER CREEK Road Unit# Lot 158, Waterloo, Ontario N2J3Z4"
+"Coordinates": array:2 [
0 => -80.5851199
1 => 43.4834036
]
+"Latitude": 43.4834036
+"Longitude": -80.5851199
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Private serene setting in Green Acre Park. Located right next to beautiful forest and no rear or side neighbours. Approximately 700 sf plus 500 sf of freshly painted deck plus gazebo to enjoy a wonderful summer in a resort like park with lots of fun amenities. Newer French doors, roof furnace and AC. Nothing to do but enjoy. Tastefully decorated throughout with two bedrooms, one bathroom and an open concept kitchen dining and living room area. Lots of room to park on a dead end street. Large yard area with campfire pit and shed for storage. Park is closed January and February. Annual lease fees include use of all amenities to include heated swimming pool, playground, mini putt, fishing pond and more. Also includes water, sewer, garbage disposal, property taxes and common area maintenance. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T23:04:05.092522+00:00"
+"Directions": "Conservation Rd/Beaver Creek Rd"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "None"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1987928"
+"ListOfficeKey": "288925"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Crushed stone driveway"
1 => "Country residential"
2 => "Recreational"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-13T20:54:29Z"
+"PhotosCount": 22
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T20:54:29Z"
+"Stories": "1.0"
+"StreetName": "BEAVER CREEK"
+"StreetNumber": "580"
+"StreetSuffix": "Road"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30027421/580-beaver-creek-road-unit-lot-158-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Modular"
]
+"CommonInterest": "Leasehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 700
+"OriginalEntryTimestamp": "2026-07-13T20:49:06.49Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1272130"
+"ListOfficeNationalAssociationId": "1372539"
+"Media": array:22 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30027421')"
+"ID": "1621722"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25410
+post_id: "1619390"
+post_author: 1
+"ListingKey": "30024345"
+"ListingId": "40847363"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T17:20:05Z"
+"RFModificationTimestamp": "2026-07-13T17:22:08Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.12
+"LivingArea": 1793.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P1"
+"UnparsedAddress": "742 BROOKMILL Place, Waterloo, Ontario N2V2P1"
+"Coordinates": array:2 [
0 => -80.58336
1 => 43.4751863
]
+"Latitude": 43.4751863
+"Longitude": -80.58336
+"YearBuilt": 2000
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Positioned at the end of a quiet cul-de-sac in Waterloo's sought-after Laurelwood neighbourhood, this beautifully maintained home sits on a pie-shaped lot backing onto a conservation area with no rear neighbours. Offering 1,230 sq. ft. above grade and nearly 1,800 sq. ft. of finished living space, this smoke-free, pet-free home features 3 bedrooms, 2 bathrooms, and a finished basement with a rough-in for an additional bathroom. The bright, open-concept main floor features hardwood flooring and a spacious Great Room with soaring cathedral ceilings and views of the forest beyond. Upstairs, the generous primary bedroom offers cheater ensuite access, while two additional bedrooms provide room for family, guests, or a home office. The finished basement includes a bright recreation room, laundry and mechanical area, storage, and a rough-in for a future 2-piece bathroom. Outside, the pie-shaped backyard is a great place to unwind or entertain, with a multi-level, surrounded by trees. Recent updates include an RO water system (2026), broadloom in the basement and on the upper stairs (2026), kitchen faucet (2025), upper bathroom sink and faucet (2025), and washer and dryer (2024). Located close to excellent schools, parks, walking trails, shopping, the YMCA, library, and both universities, this is a wonderful opportunity to own a home in the heart of Laurelwood. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T17:20:08.994594+00:00"
+"Directions": "West on Laurelwood from Fischer-Hallman, then north on Brookmill Pl."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981704"
+"ListOfficeKey": "289890"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T17:18:16Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T17:18:16Z"
+"Stories": "2.0"
+"StreetName": "BROOKMILL"
+"StreetNumber": "742"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "4970.51"
+"VirtualTourURLUnbranded": "https://youriguide.com/742_brookmill_place_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/30024345/742-brookmill-place-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 22.0
+"AboveGradeFinishedArea": 1230
+"BelowGradeFinishedArea": 563
+"OriginalEntryTimestamp": "2026-07-13T13:48:07.94Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1267102"
+"ListOfficeNationalAssociationId": "1382470"
+"Media": array:46 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30024345')"
+"ID": "1619390"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25405
+post_id: "1618779"
+post_author: 1
+"ListingKey": "30024348"
+"ListingId": "40847107"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T16:00:05Z"
+"RFModificationTimestamp": "2026-07-13T16:01:30Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1050.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A8"
+"UnparsedAddress": "778 LAURELWOOD Drive Unit# 405, Waterloo, Ontario N2V0A8"
+"Coordinates": array:2 [
0 => -80.598786
1 => 43.4711667
]
+"Latitude": 43.4711667
+"Longitude": -80.598786
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience care-free condo living at its finest in Waterloo’s premier Laurelwood neighbourhood. Welcome to Suite 405 at Laurelwood Reflections Phase 2, a stunning unit boasting over 1,000 sq ft of bright, open-concept living. The versatile floor plan features a wealth of natural light, offering total flexibility for your ideal living and dining configurations. Culinary enthusiasts will love the upgraded chef’s kitchen, complete with granite countertops, stainless steel appliances, abundant storage, and a large island with seating for three. The split bedroom layout is ideal for privacy and both bedrooms are generously sized. The primary bedroom features a spacious walk-in closet and a private 3-piece ensuite with a modern glass shower. Step outside onto your private balcony to enjoy picturesque, northern views of Creekside Pond and breathtaking seasonal foliage. There are 2 parking spots with 1 underground and 1 surface spot. Building amenities include a party room, lounge, theatre room, bike storage, visitor parking, and an outdoor BBQ pavilion. You'll love the location in a AAA+ family-friendly area. Walk to groceries, top-rated schools, walking trails, and the Laurel Creek Conservation Area. Turn-key, modern mid-rise living awaits! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"AssociationFee": "480.57"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Property Management"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T14:57:25.447459+00:00"
+"Directions": "Erbsville / Laurelwood Drive"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "Electric"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563807"
+"ListOfficeKey": "76849"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Balcony"
3 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-13T15:58:58Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T15:58:58Z"
+"Stories": "5.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "778"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "4083"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"Rooms": array:7 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30024348/778-laurelwood-drive-unit-405-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "MR100"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1050
+"OriginalEntryTimestamp": "2026-07-13T13:48:09.69Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1070148"
+"ListOfficeNationalAssociationId": "1004401"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30024348')"
+"ID": "1618779"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "1618344"
+post_author: 1
+"ListingKey": "30023566"
+"ListingId": "40847402"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T17:05:21Z"
+"RFModificationTimestamp": "2026-07-17T17:10:50Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1086.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A8"
+"UnparsedAddress": "776 LAURELWOOD Drive Unit# 302, Waterloo, Ontario N2V0A8"
+"Coordinates": array:2 [
0 => -80.5988401
1 => 43.4699593
]
+"Latitude": 43.4699593
+"Longitude": -80.5988401
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning two-bedroom, two-bathroom corner suite featuring a rare southwest exposure and an abundance of natural light throughout the day. This bright and spacious open-concept layout offers comfortable living and effortless entertaining. The modern kitchen is equipped with ample cabinetry, stainless steel appliances, and a functional center island, with sliding doors leading to a private balcony overlooking the expansive green space of the neighboring school grounds. The sun-filled living room is enhanced by two large windows, while the primary bedroom features a large window and a private ensuite with a walk-in glass shower. The generously sized second bedroom is conveniently located next to a full four-piece bathroom, making it ideal for family members or guests. Additional features include in-suite laundry with a stackable washer and dryer, one above-grade parking space (#111), and an oversized exclusive storage locker (#1707) located in Locker Room 1700 on the main floor. Situated in the highly sought-after Laurelwood community, this exceptional condo backs onto top-rated Waterloo Region schools, including Laurel Heights Secondary School and Abraham Erb Public School. Public transit provides direct access to the University of Waterloo and major shopping destinations, while supermarkets, shops, the YMCA, library, parks, playgrounds, nature trails, and Laurel Creek Conservation Area are all within walking distance. Residents enjoy excellent building amenities including a welcoming lobby, elevator, outdoor BBQ area, games room, theatre room, party room, visitor parking, and bicycle storage. This is a rare opportunity to own a beautiful, move-in ready home in one of Waterloo's most desirable neighbourhoods (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFee": "446.94"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T00:50:54.970748+00:00"
+"Directions": "Erbsville Rd. turn to Laurelwood Dr."
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2139921"
+"ListOfficeKey": "291992"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-12T22:18:00Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T16:59:48Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "776"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3953.04"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30023566/776-laurelwood-drive-unit-302-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2247895"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "291992"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1086
+"OriginalEntryTimestamp": "2026-07-12T22:18:00.75Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1391697"
+"ListOfficeNationalAssociationId": "1407252"
+"CoListAgentNationalAssociationId": "1486775"
+"CoListOfficeNationalAssociationId": "1407252"
+"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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30023566')"
+"ID": "1618344"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25413
+post_id: "1615622"
+post_author: 1
+"ListingKey": "30020496"
+"ListingId": "X13551506"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T17:45:02Z"
+"RFModificationTimestamp": "2026-07-17T17:56:20Z"
+"ListPrice": 1399000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0E7"
+"UnparsedAddress": "787 SNOWBERRY COURT, Waterloo, Ontario N2V0E7"
+"Coordinates": array:2 [
0 => -80.602215
1 => 43.462072
]
+"Latitude": 43.462072
+"Longitude": -80.602215
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A great house in an equally great neighborhood! 787 Snowberry court is one of the few walkout lots on the quiet court in Vista Hills: a neighborhood emersed into nature surrounded by forests of walking trails and some of the top-rated schools in the region. This classic all brick and stone 2 story has beautiful curb appeal, further enhanced by its interlocking driveway and armour stone accents. The double front doors open to a large foyer; adjacent to it is the living room/office, a formal space at the front of the home. The main level was designed around an open spiral oak staircase providing a stunning centre piece that elegantly connects the main floor to the second. The flooring throughout the main is a combination of modern 12x24 tile and wide plank engineered hardwood. The design flows freely through the dining room, over sized kitchen, and dinette overlooking the fully fenced yard complete with composite fencing. The kitchen features abundant cabinet space, built-in stainless-steel appliances, and quartz countertops. The family room sits adjacent and showcases a beautiful fireplace feature wall with staggered floating shelves. The sunken mudroom achieves a partial separation from the main level and is an extremely practical space for access to and from the garage with groceries and preparations. Hardwood flooring continues to finish the space in the high traffic hallway of the second floor. Four bedrooms, 3 bathrooms and a conveniently located laundry make up the second-floor space. The primary bedroom sits at the back of the home and features a walk-in closet with elegant 5 piece ensuite; complete with glass shower and soaker tub. The second bedroom also features a private 3 piece ensuite with glass shower, leaving the 3rd and 4th bedrooms sharing a 5-piece jack and jill bathroom with all the vanities in the home finished in quartz. The basement is ready for your imagination; large windows and large footprint provide lots of finishing options! Don't miss it! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Water Heater"
]
+"Basement": array:4 [
0 => "Unfinished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-11T01:00:31.849246+00:00"
+"Directions": "Cross Streets: Pasture Rose. ** Directions: Columbia to Sundew L to Mayapple R on Autumn Willow R onto Snowberry."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2239281"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "46.1 x 108 M"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-10T22:35:26Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T17:39:30Z"
+"Stories": "2.0"
+"StreetName": "Snowberry"
+"StreetNumber": "787"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "10383.89"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=Vn1tecMngZM"
+"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": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30020496/787-snowberry-court-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 46.1
+"OriginalEntryTimestamp": "2026-07-10T22:35:25.94Z"
+"FrontageLengthNumericUnits": "meters"
+"ListAgentNationalAssociationId": "1477313"
+"ListOfficeNationalAssociationId": "1385020"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30020496')"
+"ID": "1615622"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25414
+post_id: "1614857"
+post_author: 1
+"ListingKey": "30019821"
+"ListingId": "40846992"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T16:30:13Z"
+"RFModificationTimestamp": "2026-07-17T16:33:37Z"
+"ListPrice": 1399000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3118.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0E7"
+"UnparsedAddress": "787 SNOWBERRY Court, Waterloo, Ontario N2V0E7"
+"Coordinates": array:2 [
0 => -80.6023722
1 => 43.4620727
]
+"Latitude": 43.4620727
+"Longitude": -80.6023722
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A great house in an equally great neighborhood! 787 Snowberry court is one of the few walkout lots on the quiet court in Vista Hills: a neighborhood emersed into nature surrounded by forests of walking trails and some of the top-rated schools in the region. This classic all brick and stone 2 story has beautiful curb appeal, further enhanced by its interlocking driveway and armour stone accents. The double front doors open to a large foyer; adjacent to it is the living room/office, a formal space at the front of the home. The main level was designed around an open spiral oak staircase providing a stunning centre piece that elegantly connects the main floor to the second. The flooring throughout the main is a combination of modern 12x24 tile and wide plank engineered hardwood. The design flows freely through the dining room, over sized kitchen, and dinette overlooking the fully fenced yard complete with composite fencing. The kitchen features abundant cabinet space, built-in stainless-steel appliances, and quartz countertops. The family room sits adjacent and showcases a beautiful fireplace feature wall with staggered floating shelves. The sunken mudroom achieves a partial separation from the main level and is an extremely practical space for access to and from the garage with groceries and preparations. Hardwood flooring continues to finish the space in the high traffic hallway of the second floor. Four bedrooms, 3 bathrooms and a conveniently located laundry make up the second-floor space. The primary bedroom sits at the back of the home and features a walk-in closet with elegant 5 piece ensuite; complete with glass shower and soaker tub. The second bedroom also features a private 3 piece ensuite with glass shower, leaving the 3rd and 4th bedrooms sharing a 5-piece jack and jill bathroom with all the vanities in the home finished in quartz. The basement is ready for your imagination; large windows and large footprint provide lots of finishing options! Don't miss it! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-10T22:19:17.065389+00:00"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1836163"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Cul-de-sac"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-14T17:41:32Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T16:18:32Z"
+"Stories": "2.0"
+"StreetName": "SNOWBERRY"
+"StreetNumber": "787"
+"StreetSuffix": "Court"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "10383.89"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=Vn1tecMngZM"
+"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/30019821/787-snowberry-court-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1563584"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76789"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 46.0
+"AboveGradeFinishedArea": 3118
+"OriginalEntryTimestamp": "2026-07-10T21:18:20.49Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1197077"
+"ListOfficeNationalAssociationId": "1384313"
+"CoListAgentNationalAssociationId": "1143001"
+"CoListOfficeNationalAssociationId": "1004357"
+"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": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30019821')"
+"ID": "1614857"
}
]
+success: true
+page_size: 9
+page_count: 8
+count: 67
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]