array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29853961 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23331
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23333
+post_id: "1494914"
+post_author: 1
+"ListingKey": "29853961"
+"ListingId": "40826844"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T15:40:55Z"
+"RFModificationTimestamp": "2026-06-05T15:47:27Z"
+"ListPrice": 950000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.12
+"LivingArea": 1983.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N8"
+"UnparsedAddress": "670 SALZBURG Drive, Waterloo, Ontario N2V2N8"
+"Coordinates": array:2 [
0 => -80.5864412
1 => 43.4620439
]
+"Latitude": 43.4620439
+"Longitude": -80.5864412
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "The Holy Grail of Retirement Bungalows with PRICELESS VIEW! Modern-built, freehold (no condo fees!), and backing onto the serene Rosewood Pond in Waterloo’s coveted Clair Hills community — this rare walkout bungalow blends elegance, comfort, and true accessibility in one perfect package. Freshly painted and updated with new carpet, it’s completely move-in ready. Featuring 2+1 bedrooms, 3 bathrooms, and nearly 2,000 sq. ft. of beautifully finished living space, this home offers both style and ease. The open-concept main floor showcases rich maple hardwood and ceramic tile, flowing naturally to a raised deck with glass railings — where you’ll enjoy the definition of a million-dollar view. The spacious primary suite overlooks the water and includes a private 4-piece en-suite, while the second bedroom with built-in Murphy bed easily converts to a guest room or home office. The bright walkout basement features oversized windows, a cozy gas fireplace, and direct yard access — perfect for entertaining or quiet mornings by the water. A third bedroom with en-suite privileges and large storage area complete the lower level. Built with accessibility in mind, this home includes widened doorways, lowered switches, and modern mechanical systems. Add a double garage, quiet low-traffic street, and peaceful pond-side setting, and you have effortless living at its finest. Homes offering this combination of location, quality, and accessibility are seldom available. This is the perfect combination for those looking to downsize. Don’t miss your chance to call Rosewood Estates home! (id:62650)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T18:35:29.064556+00:00"
+"Directions": "Columbia to Salzburg Drive"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564479"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-04T16:52:02Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T15:34:26Z"
+"Stories": "1.0"
+"StreetName": "SALZBURG"
+"StreetNumber": "670"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5446"
+"VirtualTourURLUnbranded": "https://youriguide.com/670_salzburg_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1652408058"
"RoomType" => "Utility room"
"ListingId" => "40826844"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29853961"
"RoomLength" => null
"RoomDimensions" => "19'10'' x 18'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:34:26.82Z"
]
1 => array:11 [
"RoomKey" => "1652408059"
"RoomType" => "Recreation room"
"ListingId" => "40826844"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29853961"
"RoomLength" => null
"RoomDimensions" => "18'9'' x 22'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:34:26.82Z"
]
2 => array:11 [
"RoomKey" => "1652408060"
"RoomType" => "3pc Bathroom"
"ListingId" => "40826844"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29853961"
"RoomLength" => null
"RoomDimensions" => "5'3'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:34:26.82Z"
]
3 => array:11 [
"RoomKey" => "1652408061"
"RoomType" => "Bedroom"
"ListingId" => "40826844"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29853961"
"RoomLength" => null
"RoomDimensions" => "17'0'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:34:26.82Z"
]
4 => array:11 [
"RoomKey" => "1652408062"
"RoomType" => "4pc Bathroom"
"ListingId" => "40826844"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29853961"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:34:26.82Z"
]
5 => array:11 [
"RoomKey" => "1652408063"
"RoomType" => "3pc Bathroom"
"ListingId" => "40826844"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29853961"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:34:26.82Z"
]
6 => array:11 [
"RoomKey" => "1652408064"
"RoomType" => "Bedroom"
"ListingId" => "40826844"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29853961"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 9'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:34:26.82Z"
]
7 => array:11 [
"RoomKey" => "1652408065"
"RoomType" => "Dining room"
"ListingId" => "40826844"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29853961"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 9'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:34:26.82Z"
]
8 => array:11 [
"RoomKey" => "1652408066"
"RoomType" => "Kitchen"
"ListingId" => "40826844"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29853961"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:34:26.82Z"
]
9 => array:11 [
"RoomKey" => "1652408067"
"RoomType" => "Living room"
"ListingId" => "40826844"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29853961"
"RoomLength" => null
"RoomDimensions" => "18'10'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:34:26.83Z"
]
10 => array:11 [
"RoomKey" => "1652408068"
"RoomType" => "Primary Bedroom"
"ListingId" => "40826844"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29853961"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-05T15:34:26.83Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29853961/670-salzburg-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1223
+"BelowGradeFinishedArea": 760
+"OriginalEntryTimestamp": "2026-06-04T16:52:02.49Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1125580"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29853961_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/1f60e5747bf721c6c245d056596a3b04.webp"
"MediaSize" => 166233
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-1f60e5747bf721c6c245d056596a3b04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29853961_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/0890c34470d5cf19f90c391e7fb4ba7f.webp"
"MediaSize" => 215475
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-0890c34470d5cf19f90c391e7fb4ba7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29853961_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/f7ee108584a2f75bf52cf67c9a732aaa.webp"
"MediaSize" => 156290
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-f7ee108584a2f75bf52cf67c9a732aaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29853961_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/43d26e390ba04a1b389d8095ba70e5f3.webp"
"MediaSize" => 197218
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-43d26e390ba04a1b389d8095ba70e5f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29853961_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/8b0eabf907cdc0f0f2f61f1d563d353f.webp"
"MediaSize" => 162870
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-8b0eabf907cdc0f0f2f61f1d563d353f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29853961_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/2e4bb0a2e4c7c1dc025629882c3569f0.webp"
"MediaSize" => 74140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-2e4bb0a2e4c7c1dc025629882c3569f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29853961_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/ecb90894bee62a2d6bd6867b57b9899c.webp"
"MediaSize" => 91853
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-ecb90894bee62a2d6bd6867b57b9899c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29853961_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/45db3c951123e7dd9821d325a435a31c.webp"
"MediaSize" => 70006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-45db3c951123e7dd9821d325a435a31c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29853961_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/5f9656c92f5c0069e70b49702e48230c.webp"
"MediaSize" => 69344
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-5f9656c92f5c0069e70b49702e48230c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29853961_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/90a1d3d01127c4dae42f139a977534c9.webp"
"MediaSize" => 75658
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-90a1d3d01127c4dae42f139a977534c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29853961_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/f5cc2ef129c204038c54dfa14d372831.webp"
"MediaSize" => 72266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-f5cc2ef129c204038c54dfa14d372831.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29853961_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/816f14e082a2880a31939ed07ccee611.webp"
"MediaSize" => 82746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-816f14e082a2880a31939ed07ccee611.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29853961_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/8f603feb0ed181b28b278a92576b4969.webp"
"MediaSize" => 78411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-8f603feb0ed181b28b278a92576b4969.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29853961_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/fb8e401141546d221eaa8600394aabbc.webp"
"MediaSize" => 71631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-fb8e401141546d221eaa8600394aabbc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29853961_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/c27d4061d7c22ae4a395cfd2bb21740e.webp"
"MediaSize" => 89480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-c27d4061d7c22ae4a395cfd2bb21740e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29853961_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/4a3f30ee1ac1f72e67b981ebfc0d4e85.webp"
"MediaSize" => 85703
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-4a3f30ee1ac1f72e67b981ebfc0d4e85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29853961_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/9622c8ce1cf3c78d35a9816cb2ae3022.webp"
"MediaSize" => 97711
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-9622c8ce1cf3c78d35a9816cb2ae3022.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29853961_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/282e9b46226187b134663382c50b7d92.webp"
"MediaSize" => 94497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-282e9b46226187b134663382c50b7d92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29853961_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/d850c8ced111864918bb9df5a363473e.webp"
"MediaSize" => 99586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-d850c8ced111864918bb9df5a363473e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29853961_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/bba364b0d521ffe8a0919fa52db9d6df.webp"
"MediaSize" => 108722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-bba364b0d521ffe8a0919fa52db9d6df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29853961_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/04adc8858b05d723a64a2f0ab18bf15a.webp"
"MediaSize" => 85427
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-04adc8858b05d723a64a2f0ab18bf15a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29853961_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/0de562565a9926cd9170a32a866abecb.webp"
"MediaSize" => 81767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-0de562565a9926cd9170a32a866abecb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29853961_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/b2f73ec871c838545094c713d62e5a3e.webp"
"MediaSize" => 66034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-b2f73ec871c838545094c713d62e5a3e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29853961_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/14bc962c5bc273c4c278cea775267ed0.webp"
"MediaSize" => 67822
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-14bc962c5bc273c4c278cea775267ed0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29853961_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/55e4ce7935f50a9c52d6b27c0a29592e.webp"
"MediaSize" => 53781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-55e4ce7935f50a9c52d6b27c0a29592e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29853961_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/82fbc11528bedde3072420ac7d6f6261.webp"
"MediaSize" => 59285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-82fbc11528bedde3072420ac7d6f6261.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29853961_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/275cf142d5df133cdfaa830d60ca3e86.webp"
"MediaSize" => 61608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-275cf142d5df133cdfaa830d60ca3e86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29853961_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/b6b47732fc86fee772bbaf0a68f1c9b4.webp"
"MediaSize" => 56616
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-b6b47732fc86fee772bbaf0a68f1c9b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29853961_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/ee7ca870c4b7e2aac696f8ada2f695d4.webp"
"MediaSize" => 158118
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-ee7ca870c4b7e2aac696f8ada2f695d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29853961_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/1a0d8100fd010b76baba07bc397c27df.webp"
"MediaSize" => 208530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-1a0d8100fd010b76baba07bc397c27df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29853961_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/c7d10fa6b0f088f5ea20ed71efb4178d.webp"
"MediaSize" => 209649
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-c7d10fa6b0f088f5ea20ed71efb4178d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29853961_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/6e3481de6615e71e91a6f2edc1e35f63.webp"
"MediaSize" => 95649
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-6e3481de6615e71e91a6f2edc1e35f63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29853961_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/b43bb7c6c032dc69eae8e67f93e5c933.webp"
"MediaSize" => 89857
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-b43bb7c6c032dc69eae8e67f93e5c933.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29853961_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/42aceb348c9c7a71b67b89a2a3eb1df0.webp"
"MediaSize" => 83062
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-42aceb348c9c7a71b67b89a2a3eb1df0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29853961_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/30f29b30d0cfd5a387d2ad572a1ca0ae.webp"
"MediaSize" => 75015
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-30f29b30d0cfd5a387d2ad572a1ca0ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29853961_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/8304af5b22628e45fe8f51237311eb2e.webp"
"MediaSize" => 81987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-8304af5b22628e45fe8f51237311eb2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29853961_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/a9ff6524a6b53663cf371957d4435cb5.webp"
"MediaSize" => 85646
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-a9ff6524a6b53663cf371957d4435cb5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29853961_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/a0583222ec5345f920b6c610a4f37c11.webp"
"MediaSize" => 73485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-a0583222ec5345f920b6c610a4f37c11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29853961_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/cb9cec3d6a5f4421e4d4348d2cbfd474.webp"
"MediaSize" => 54991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-cb9cec3d6a5f4421e4d4348d2cbfd474.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29853961_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/a99910c6c22327b7e5f4a8a30712b635.webp"
"MediaSize" => 64591
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-a99910c6c22327b7e5f4a8a30712b635.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29853961_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/cad36d632eafd6265347e2019fd74b61.webp"
"MediaSize" => 75835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-cad36d632eafd6265347e2019fd74b61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29853961_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/c663080941ffc7e0a9c00e4c8f86a1b5.webp"
"MediaSize" => 150818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-c663080941ffc7e0a9c00e4c8f86a1b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29853961_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/07110d6dd2bb9eccbf704cb7cfcd7bc4.webp"
"MediaSize" => 184659
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-07110d6dd2bb9eccbf704cb7cfcd7bc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29853961_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/4a348265668ce39639e797da6756c40a.webp"
"MediaSize" => 133518
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-4a348265668ce39639e797da6756c40a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29853961_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/32c8d36d05bf430b46ec60958f451d50.webp"
"MediaSize" => 224412
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-32c8d36d05bf430b46ec60958f451d50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29853961_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/9511d3af39fb4df0f99adc73d1755b05.webp"
"MediaSize" => 213487
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-9511d3af39fb4df0f99adc73d1755b05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29853961_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/509eaa2934586841fd4b0e873060f86a.webp"
"MediaSize" => 206814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-509eaa2934586841fd4b0e873060f86a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29853961_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/ffa72baefcf872f3815ae9123d46f8e2.webp"
"MediaSize" => 222967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-ffa72baefcf872f3815ae9123d46f8e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "29853961_4890_49"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/0a28f0dfde4fb2e950ed58bb23fedab0.webp"
"MediaSize" => 48543
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-0a28f0dfde4fb2e950ed58bb23fedab0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
49 => array:13 [
"Order" => 50
"MediaKey" => "29853961_4890_50"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29853961/643b79092bd6e0f1fdb7dcae9dacd995.webp"
"MediaSize" => 40982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29853961/thumbnail-643b79092bd6e0f1fdb7dcae9dacd995.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40826844"
"ResourceRecordKey" => "29853961"
"ModificationTimestamp" => "2026-06-04T16:52:02.49Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29853961')"
+"ID": "1494914"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.27 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 289722" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24710
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1564479" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24795
+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 '29853961'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25125
+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 '29853961'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25143
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25141
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31330440"
+"ListingKey": "29853961"
+"ListingId": "40826844"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-07"
+"OpenHouseStartTime": "2026-06-07T13:00:00Z"
+"OpenHouseEndTime": "2026-06-07T15:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-07T00:48:47Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31330440')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29853961' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5864412 43.4620439)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25216
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25210
+post_id: "1503934"
+post_author: 1
+"ListingKey": "29866488"
+"ListingId": "X13411076"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-07T00:20:08Z"
+"RFModificationTimestamp": "2026-06-07T00:31:18Z"
+"ListPrice": 999999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V1"
+"UnparsedAddress": "505 YORKSHIRE DRIVE, Waterloo, Ontario N2T2V1"
+"Coordinates": array:2 [
0 => -80.572546
1 => 43.456625
]
+"Latitude": 43.456625
+"Longitude": -80.572546
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful custom built house in Upper Beechwood! Beautiful 18ft cathedral ceilings on the main level with an open concept, and a lovely library/office at the front of house. The kitchen has a breakfast bar, and sliders to a huge fully fenced backyard. Upstairs you will find 3 bedrooms with new flooring, no carpet. All generously sized bedroom, with a master bedroom featuring a large walk-in closet and a 4-piece en-suite. Bright basement offers a large family/rec room with a 4-piece bathroom and 2 more bedrooms. Walking distance to all amenities: parks, shops, cafes and both universities. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-06T21:12:01.898240+00:00"
+"Directions": "Erbsville Rd & Keats way"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2183926"
+"ListOfficeKey": "284345"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "Carpet Free"
2 => "Sump Pump"
]
+"LotSizeDimensions": "50.1 x 163.9 FT ; 169.75ftx50.42ftx163.90ftx50.08ft"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-07T00:12:12Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-07T00:12:12Z"
+"Stories": "2.0"
+"StreetName": "Yorkshire"
+"StreetNumber": "505"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7124"
+"VirtualTourURLUnbranded": "https://show.youriguide.com/OuOhKXjx-NXdHHae7aK"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1653641368"
"RoomType" => "Eating area"
"ListingId" => "X13411076"
"RoomLevel" => "Main level"
"RoomWidth" => 2.19
"ListingKey" => "29866488"
"RoomLength" => 4.94
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.21Z"
]
1 => array:11 [
"RoomKey" => "1653641369"
"RoomType" => "Den"
"ListingId" => "X13411076"
"RoomLevel" => "Basement"
"RoomWidth" => 1.83
"ListingKey" => "29866488"
"RoomLength" => 2.41
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.21Z"
]
2 => array:11 [
"RoomKey" => "1653641370"
"RoomType" => "Bedroom"
"ListingId" => "X13411076"
"RoomLevel" => "Basement"
"RoomWidth" => 2.62
"ListingKey" => "29866488"
"RoomLength" => 3.23
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.21Z"
]
3 => array:11 [
"RoomKey" => "1653641371"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13411076"
"RoomLevel" => "Basement"
"RoomWidth" => 6.38
"ListingKey" => "29866488"
"RoomLength" => 10.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.21Z"
]
4 => array:11 [
"RoomKey" => "1653641372"
"RoomType" => "Dining room"
"ListingId" => "X13411076"
"RoomLevel" => "Main level"
"RoomWidth" => 5.33
"ListingKey" => "29866488"
"RoomLength" => 4.85
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.21Z"
]
5 => array:11 [
"RoomKey" => "1653641373"
"RoomType" => "Kitchen"
"ListingId" => "X13411076"
"RoomLevel" => "Main level"
"RoomWidth" => 4.11
"ListingKey" => "29866488"
"RoomLength" => 4.94
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.21Z"
]
6 => array:11 [
"RoomKey" => "1653641374"
"RoomType" => "Living room"
"ListingId" => "X13411076"
"RoomLevel" => "Main level"
"RoomWidth" => 3.99
"ListingKey" => "29866488"
"RoomLength" => 5.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.22Z"
]
7 => array:11 [
"RoomKey" => "1653641375"
"RoomType" => "Office"
"ListingId" => "X13411076"
"RoomLevel" => "Main level"
"RoomWidth" => 4.24
"ListingKey" => "29866488"
"RoomLength" => 3.02
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.22Z"
]
8 => array:11 [
"RoomKey" => "1653641376"
"RoomType" => "Laundry room"
"ListingId" => "X13411076"
"RoomLevel" => "Main level"
"RoomWidth" => 2.13
"ListingKey" => "29866488"
"RoomLength" => 2.32
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.22Z"
]
9 => array:11 [
"RoomKey" => "1653641377"
"RoomType" => "Bedroom"
"ListingId" => "X13411076"
"RoomLevel" => "Second level"
"RoomWidth" => 6.86
"ListingKey" => "29866488"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T00:12:12.22Z"
]
10 => array:11 [
"RoomKey" => "1653641378"
"RoomType" => "Bedroom 2"
"ListingId" => "X13411076"
"RoomLevel" => "Second level"
…7
]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29866488/505-yorkshire-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 50.1
+"OriginalEntryTimestamp": "2026-06-06T19:46:17.01Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1433591"
+"ListOfficeNationalAssociationId": "1340429"
+"Media": array:43 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29866488')"
+"ID": "1503934"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25212
+post_id: "1502400"
+post_author: 1
+"ListingKey": "29863317"
+"ListingId": "40837217"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T20:26:00Z"
+"RFModificationTimestamp": "2026-06-06T20:34:31Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3125.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A3"
+"UnparsedAddress": "795 LAURELWOOD Drive Unit# C13, Waterloo, Ontario N2V0A3"
+"Coordinates": array:2 [
0 => -80.6003139
1 => 43.4707332
]
+"Latitude": 43.4707332
+"Longitude": -80.6003139
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully updated corner-unit townhouse in the highly sought-after Laurelwood community. Nestled on a quiet cul-de-sac and surrounded by mature trees, this maintenance-free home offers exceptional space, privacy, and abundant natural light. Featuring three separate living areas and a rare main-floor primary bedroom with a full ensuite, this home is designed for both comfort and convenience. The main floor boasts soaring ceilings, a versatile front living room, a dedicated office, a powder room, and a renovated kitchen (2023) complete with quartz countertops, an island, white cabinetry, stainless steel appliances, and an open-concept layout that flows seamlessly into the dining and living areas. Upstairs, you'll find two spacious bedrooms, a full bathroom, and a large family room with the potential to be converted into a fourth bedroom. Step outside through sliding doors to a private deck overlooking peaceful greenspace-perfect for relaxing or entertaining. The expansive unfinished basement offers endless possibilities for future living space and awaits your personal touch. Recent upgrades include a furnace, A/C, sump pump, flooring, smart lighting, and pot lights. Ideally located near Laurel Creek, top-rated Kitchener-Waterloo schools, the University of Waterloo, shopping, and everyday amenities. Enjoy worry-free living with lawn maintenance and snow removal included. A rare opportunity to own a spacious, move-in-ready home in one of Waterloo's most desirable neighbourhoods. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"AssociationFee": "314"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T21:33:03.183497+00:00"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2141441"
+"ListOfficeKey": "300100"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-05T20:50:57Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T20:20:13Z"
+"Stories": "2.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "795"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "4864"
+"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/29863317/795-laurelwood-drive-unit-c13-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "Md-3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1992
+"BelowGradeFinishedArea": 1133
+"OriginalEntryTimestamp": "2026-06-05T20:50:57.35Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1393129"
+"ListOfficeNationalAssociationId": "1482864"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29863317')"
+"ID": "1502400"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25209
+post_id: "1498873"
+post_author: 1
+"ListingKey": "29859873"
+"ListingId": "40837053"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T15:26:00Z"
+"RFModificationTimestamp": "2026-06-05T17:04:20Z"
+"ListPrice": 1083900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3782.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2X9"
+"UnparsedAddress": "512 WOOD NETTLE Way, Waterloo, Ontario N2V2X9"
+"Coordinates": array:2 [
0 => -80.6039602
1 => 43.4724714
]
+"Latitude": 43.4724714
+"Longitude": -80.6039602
+"YearBuilt": 2007
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "NO HOLDING OFFERS. MOVE-IN READY! Beautiful family home in one of Waterloo’s most desirable neighborhoods in Laurelwood, steps to top-ranked schools and bus routes. Spacious 3,782 sq ft comfortable living space with 4+1 bedrooms and 3.5 baths. Main floor boasts 9' ceilings, gleaming hardwood and porcelain tiles, a grand foyer, formal dining room, and a great room with gas fireplace. Gourmet kitchen with stainless appliances and quartz countertops. The spacious breakfast area has a door that opens to a generously sized deck in fully fenced backyard. On the upper level, the large primary suite with walk-in closet and luxurious 5pc en-suite featuring a glass shower and custom whirlpool tub, all other 3 bedrooms are nicely sized, and the main bathroom features double sinks and a large bonus linen cabinet. The fully finished basement (2021) has a mirrored wall great for yoga practice, a large rec room ideal for home theater, and a home gym, and the 5th bedroom can be used as a home office. Recent Updates: Roof (2021), Owned Hot Water Heater (2025), Kitchen Cabinets and Fireplace Professionally Repainted (2026), Added Additional Insulation in Attic (2022), Multiple Modern Light Fixtures Installed (2026). Convenient to Costco, parks, trails, and transit to both universities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T17:04:10.429784+00:00"
+"Directions": "Wideman Rd to Laurelwood Dr To Wood Nettle Way"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1970409"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-05T15:19:24Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T15:19:24Z"
+"Stories": "2.0"
+"StreetName": "WOOD NETTLE"
+"StreetNumber": "512"
+"StreetSuffix": "Way"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "7357"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/512-WOOD-NETTLE-Way"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29859873/512-wood-nettle-way-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "50-R5"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2627
+"BelowGradeFinishedArea": 1155
+"OriginalEntryTimestamp": "2026-06-05T15:19:24.78Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1257707"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29859873')"
+"ID": "1498873"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25213
+post_id: "1497649"
+post_author: 1
+"ListingKey": "29857988"
+"ListingId": "X13245602"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T16:10:58Z"
+"RFModificationTimestamp": "2026-06-05T16:29:36Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A3"
+"UnparsedAddress": "13 - 795 LAURELWOOD DRIVE, Waterloo, Ontario N2V0A3"
+"Coordinates": array:2 [
0 => -80.600804
1 => 43.471001
]
+"Latitude": 43.471001
+"Longitude": -80.600804
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully updated corner-unit townhouse in the highly sought-after Laurelwood community. Nestled on a quiet cul-de-sac and surrounded by mature trees, this maintenance-free home offers exceptional space, privacy, and abundant natural light. Featuring three separate living areas and a rare main-floor primary bedroom with a full ensuite, this home is designed for both comfort and convenience.The main floor boasts soaring ceilings, a versatile front living room, a dedicated office, a powder room, and a renovated kitchen (2023) complete with quartz countertops, an island, white cabinetry, stainless steel appliances, and an open-concept layout that flows seamlessly into the dining and living areas. Upstairs, you'll find two spacious bedrooms, a full bathroom, and a large family room with the potential to be converted into a fourth bedroom.Step outside through sliding doors to a private deck overlooking peaceful greenspace-perfect for relaxing or entertaining. The expansive unfinished basement offers endless possibilities for future living space and awaits your personal touch.Recent upgrades include a furnace, A/C, sump pump, flooring, smart lighting, and pot lights. Ideally located near Laurel Creek, top-rated Kitchener-Waterloo schools, the University of Waterloo, shopping, and everyday amenities. Enjoy worry-free living with lawn maintenance and snow removal included.A rare opportunity to own a spacious, move-in-ready home in one of Waterloo's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
11 => "Water Heater"
]
+"AssociationFee": "314"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T01:32:13.756962+00:00"
+"Directions": "Erbsville Road / Laurelwood Drive"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2245275"
+"ListOfficeKey": "299835"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-05T04:12:16Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T16:01:12Z"
+"Stories": "2.0"
+"StreetName": "Laurelwood"
+"StreetNumber": "795"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4864"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29857988/13-795-laurelwood-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2088481"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Self-managed"
+"CoListOfficeKey": "299835"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1999
+"LivingAreaMinimum": 1800
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-05T01:13:47.01Z"
+"ListAgentNationalAssociationId": "1484041"
+"ListOfficeNationalAssociationId": "1477585"
+"CoListAgentNationalAssociationId": "1361768"
+"CoListOfficeNationalAssociationId": "1477585"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29857988')"
+"ID": "1497649"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25211
+post_id: "1495724"
+post_author: 1
+"ListingKey": "29856070"
+"ListingId": "40830420"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T16:26:09Z"
+"RFModificationTimestamp": "2026-06-05T16:30:15Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2667.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2M3"
+"UnparsedAddress": "743 BUTTERNUT Avenue, Waterloo, Ontario N2V2M3"
+"Coordinates": array:2 [
0 => -80.5881761
1 => 43.4661322
]
+"Latitude": 43.4661322
+"Longitude": -80.5881761
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Loaction! Loacation!! Location!!! Located in the desirable Clair Hills community, Vista Hill PS and Laurel Height SS. This beautifully maintained home offers a double-car garage and an extended front walkway, providing both enhanced curb appeal and everyday convenience. The welcoming main level features a versatile front room that can serve as a home office, living room, or dining area, while upgraded waterproof flooring extends throughout the above-grade living space. Enjoy the spacious family room with nearly 9-foot ceilings, creating an open and comfortable atmosphere. The modern kitchen is equipped with quartz countertops, a large centre island, stylish backsplash, and a bright breakfast area with walkout access to the backyard, where a generous two-tier deck offers exceptional outdoor living and entertaining space. Upstairs, you'll find four well-sized bedrooms, two full bathrooms, a convenient laundry room, and an L-shaped staircase designed for added comfort and safety. The expansive primary suite features a private ensuite with a separate shower and soaker tub, while the three additional bedrooms provide excellent space for family or guests. The professionally finished basement offers distinct living areas, including a dedicated home theatre and a large recreation room, providing flexible space for entertainment, fitness, or family activities. Move-in ready and thoughtfully designed throughout, this home combines comfort, functionality, and an outstanding location. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "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-06-04T20:42:44.351317+00:00"
+"Directions": "From Erbsville heading North out of town, turn left on Columbia Forest then right on Butternut"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2073939"
+"ListOfficeKey": "253316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-04T20:11:34Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T16:11:54Z"
+"Stories": "2.0"
+"StreetName": "BUTTERNUT"
+"StreetNumber": "743"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5932"
+"VirtualTourURLUnbranded": "https://youtu.be/oYIjf4okJ_A"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29856070/743-butternut-avenue-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 2047
+"BelowGradeFinishedArea": 620
+"OriginalEntryTimestamp": "2026-06-04T20:11:34.21Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1349103"
+"ListOfficeNationalAssociationId": "1223329"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29856070')"
+"ID": "1495724"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25206
+post_id: "1494892"
+post_author: 1
+"ListingKey": "29854661"
+"ListingId": "X13241212"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T17:25:55Z"
+"RFModificationTimestamp": "2026-06-05T17:30:01Z"
+"ListPrice": 950000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N8"
+"UnparsedAddress": "670 SALZBURG DRIVE, Waterloo, Ontario N2V2N8"
+"Coordinates": array:2 [
0 => -80.586439
1 => 43.462061
]
+"Latitude": 43.462061
+"Longitude": -80.586439
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "The Holy Grail of Retirement Bungalows with a PRICELESS VIEW! Modern-built, freehold (no condo fees!), and backing onto the serene Rosewood Pond in Waterloo's coveted Clair Hills community - this rare walkout bungalow blends elegance, comfort, and true accessibility in one perfect package. Freshly painted and updated with new carpet, it's completely move-in ready. Featuring 2+1 bedrooms, 3 bathrooms, and nearly 2,000 sq. ft. of beautifully finished living space, this home offers both style and ease. The open-concept main floor showcases rich maple hardwood and ceramic tile, flowing naturally to a raised deck with glass railings - where you'll enjoy the definition of a million-dollar view. The spacious primary suite overlooks the water and includes a private 4-piece ensuite, while the second bedroom with built-in Murphy bed easily converts to a guest room or home office. The bright walkout basement features oversized windows, a cozy gas fireplace, and direct yard access - perfect for entertaining or quiet mornings by the water. A third bedroom with ensuite privileges and large storage area complete the lower level. Built with accessibility in mind, this home includes widened doorways, lowered switches, and modern mechanical systems. Add a double garage, quiet low-traffic street, and peaceful pond-side setting, and you have effortless living at its finest. Homes offering this combination of location, quality, and accessibility are seldom available. This is the perfect combination for those looking to downsize. Don't miss your chance to call Rosewood Estates home! (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T18:42:42.513496+00:00"
+"Directions": "Columbia to Salzburg Drive"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100955"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "45 x 118.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-04T17:59:37Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T16:57:37Z"
+"Stories": "1.0"
+"StreetName": "Salzburg"
+"StreetNumber": "670"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5864"
+"VirtualTourURLUnbranded": "https://youriguide.com/670_salzburg_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29854661/670-salzburg-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-04T17:59:37.17Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1370979"
+"ListOfficeNationalAssociationId": "1369645"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29854661')"
+"ID": "1494892"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23345
+post_id: "1490753"
+post_author: 1
+"ListingKey": "29847603"
+"ListingId": "40829482"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-03T22:20:52Z"
+"RFModificationTimestamp": "2026-06-03T22:22:04Z"
+"ListPrice": 829000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2337.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2T5"
+"UnparsedAddress": "435 SPECKLED ALDER Street, Waterloo, Ontario N2V2T5"
+"Coordinates": array:2 [
0 => -80.5941368
1 => 43.4689249
]
+"Latitude": 43.4689249
+"Longitude": -80.5941368
+"YearBuilt": 2004
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This elegant, carpet-free family home in the prestigious Laurel Creek neighborhood offers a perfect blend of modern comfort and unbeatable convenience, with Costco, the YMCA, and the local library all situated within a 5-minute drive. The bright, open-concept interior features three spacious bedrooms, a fully finished basement with a large recreation room, and a fresh coat of paint throughout. Ideally positioned for families and investors alike, the property is steps away from top-rated schools like Abraham Erb P.S. and Laurel Heights S.S., and just minutes from both UW and WLU. Boasting a double driveway and extensive recent upgrades—including a new furnace (2025), washer/dryer (2024), dishwasher (2023), fridge (2022), and roof (2021)—this stunning, move-in-ready home is designed for effortless contemporary living. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-03T18:57:35.796318+00:00"
+"Directions": "Laurelwood Drive to Blue Beech Blvd"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2081146"
+"ListOfficeKey": "253316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-03T22:20:27Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-03T22:20:26Z"
+"Stories": "2.0"
+"StreetName": "SPECKLED ALDER"
+"StreetNumber": "435"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4769.43"
+"VirtualTourURLUnbranded": "https://youriguide.com/8tiga_435_speckled_alder_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29847603/435-speckled-alder-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "50-R5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1647
+"BelowGradeFinishedArea": 690
+"OriginalEntryTimestamp": "2026-06-03T17:51:38.89Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1355928"
+"ListOfficeNationalAssociationId": "1223329"
+"Media": array:29 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29847603')"
+"ID": "1490753"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25214
+post_id: "1489104"
+post_author: 1
+"ListingKey": "29844777"
+"ListingId": "40835157"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T20:30:49Z"
+"RFModificationTimestamp": "2026-06-06T20:47:39Z"
+"ListPrice": 899999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1817.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2M3"
+"UnparsedAddress": "784 BUTTERNUT Avenue, Waterloo, Ontario N2V2M3"
+"Coordinates": array:2 [
0 => -80.5893984
1 => 43.4655833
]
+"Latitude": 43.4655833
+"Longitude": -80.5893984
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful move-in-ready 2 storey home in Waterloo’s highly sought-after Columbia Forest neighbourhood. Ideally located just minutes from the city’s largest natural walking trails, the Boardwalk shopping district, top-rated public schools, and both of Waterloo’s renowned universities, this location is perfect for the growing family. This charming 3+1 bedroom, 4-bathroom home offers over 1,700 square feet of finished living space, providing plenty of room for families both inside and outside of the home. Step outside and create lasting memories in your private backyard oasis, featuring mature trees, lush gardens, a dedicated dining area and your very own hot tub. The finished basement adds versatile living space and is the perfect setting for family recreation, an additional bedroom, or a home office. Recent improvements over the last few years include a new roof, full window replacement, new furnace and kitchen renovation. Don’t miss this rare opportunity to own a well-maintained home in one of Waterloo’s most desirable communities. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Tudor"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-03T16:03:35.919356+00:00"
+"Directions": "COL.FT/STAR FLOWER"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2061846"
+"ListOfficeKey": "284641"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0"
+"PhotosChangeTimestamp": "2026-06-03T11:59:28Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T20:21:36Z"
+"Stories": "2.0"
+"StreetName": "BUTTERNUT"
+"StreetNumber": "784"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4943.2"
+"Utilities": array:1 [
0 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29844777/784-butternut-avenue-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2217406"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "54949"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 44.0
+"AboveGradeFinishedArea": 1238
+"BelowGradeFinishedArea": 579
+"OriginalEntryTimestamp": "2026-06-03T11:59:27.95Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1336875"
+"ListOfficeNationalAssociationId": "1344650"
+"CoListAgentNationalAssociationId": "1463083"
+"CoListOfficeNationalAssociationId": "1003557"
+"Media": array:33 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29844777')"
+"ID": "1489104"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25215
+post_id: "1489105"
+post_author: 1
+"ListingKey": "29846036"
+"ListingId": "40836230"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-03T15:31:15Z"
+"RFModificationTimestamp": "2026-06-03T15:53:35Z"
+"ListPrice": 85000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 667.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3Z4"
+"UnparsedAddress": "580 BEAVER CREEK Road Unit# 203, Waterloo, Ontario N2J3Z4"
+"Coordinates": array:2 [
0 => -80.5822901
1 => 43.471847
]
+"Latitude": 43.471847
+"Longitude": -80.5822901
+"YearBuilt": 1992
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome Unit 203 in one of Waterloo's most established and beautifully maintained land-lease communities Green Acres Park! This modular home offers open-concept living, Step outside to your spacious private decks, perfect for morning coffee or summer BBQs surrounded by friendly neighbors. Green Acre Park features a community swimming pool, a game room, a catch and release fishing pond for plenty of outdoor activities. Enjoy resort-style amenities, peaceful surroundings, and low yearly carrying costs. Annual Park fees approx. $9,800-$11,200 + HST includes water & taxes (park closed Jan & Feb). Park approval required for all purchases. Enjoy the comforts of 10-month seasonal living (park closed Jan & Feb) with a turnkey home, surrounded by nature, old growth trees and a spacious lot. Call and book your appointment today!! (id:62650)"
+"Appliances": array:2 [
0 => "Refrigerator"
1 => "Gas stove(s)"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-06-03T15:53:26.359142+00:00"
+"Directions": "FROM NORTHFIELD EXIT-WEST ON NORTHFIELD DR., NORTH ON WESTMOUNT RD N. WEST ON CONSERVATION DR.,"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "None"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1860816"
+"ListOfficeKey": "76831"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Recreational"
]
+"PhotosChangeTimestamp": "2026-06-03T15:20:35Z"
+"PhotosCount": 12
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-03T15:20:35Z"
+"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/29846036/580-beaver-creek-road-unit-203-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Mobile Home"
]
+"CommonInterest": "Leasehold"
+"GeocodeManualYN": true
+"ZoningDescription": "Rec"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 667
+"OriginalEntryTimestamp": "2026-06-03T15:20:35.35Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1200804"
+"ListOfficeNationalAssociationId": "1004391"
+"Media": array:12 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29846036')"
+"ID": "1489105"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 109
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]