array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29878564 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1512894"
+post_author: 1
+"ListingKey": "29878564"
+"ListingId": "40836577"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T20:50:08Z"
+"RFModificationTimestamp": "2026-06-13T20:53:30Z"
+"ListPrice": 649000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1020.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4N2"
+"UnparsedAddress": "525 FALLINGBROOK Drive, Waterloo, Ontario N2L4N2"
+"Coordinates": array:2 [
0 => -80.5584541
1 => 43.4876412
]
+"Latitude": 43.4876412
+"Longitude": -80.5584541
+"YearBuilt": 1972
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 525 Fallingbrook Drive, a beautifully maintained home located in one of Waterloo’s most desirable and family-friendly neighbourhoods. This spacious property offers 3 bedrooms above grade plus 1 additional bedroom in the finished basement, along with 2 full bathrooms, making it an ideal choice for families, investors, or anyone seeking a move-in-ready home in a prime location. The home has been thoughtfully updated with major improvements already completed for you. Recent upgrades include a new furnace (2019), new gutters, new windows, new stamped concrete driveway, and updated kitchen cabinets. The kitchen also features five upgraded appliances and a newer water heater, providing modern convenience and long-term peace of mind. The layout offers bright, comfortable living spaces with excellent flow, while the finished basement provides additional living area perfect for guests, a home office, or recreation. The property sits in a quiet, mature neighbourhood close to top-rated schools, universities, parks, shopping, transit, and all amenities Waterloo is known for. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Range - Gas"
4 => "Dishwasher"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T22:28:22.448121+00:00"
+"Directions": "Glen Forrest Blvd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007860"
+"ListOfficeKey": "285135"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"NumberOfUnitsTotal": "1"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T20:39:29Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T20:40:34Z"
+"Stories": "1.0"
+"StreetName": "FALLINGBROOK"
+"StreetNumber": "525"
+"StreetSuffix": "Drive"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "4253.82"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1658732866"
"RoomType" => "Utility room"
"ListingId" => "40836577"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29878564"
"RoomLength" => null
"RoomDimensions" => "19'10'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:40:34.03Z"
]
1 => array:11 [
"RoomKey" => "1658732867"
"RoomType" => "Recreation room"
"ListingId" => "40836577"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29878564"
"RoomLength" => null
"RoomDimensions" => "16'2'' x 16'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:40:34.03Z"
]
2 => array:11 [
"RoomKey" => "1658732868"
"RoomType" => "4pc Bathroom"
"ListingId" => "40836577"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29878564"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:40:34.03Z"
]
3 => array:11 [
"RoomKey" => "1658732869"
"RoomType" => "Office"
"ListingId" => "40836577"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29878564"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 7'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:40:34.03Z"
]
4 => array:11 [
"RoomKey" => "1658732870"
"RoomType" => "Bedroom"
"ListingId" => "40836577"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29878564"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 13'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:40:34.03Z"
]
5 => array:11 [
"RoomKey" => "1658732871"
"RoomType" => "Dining room"
"ListingId" => "40836577"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29878564"
"RoomLength" => null
"RoomDimensions" => "7'10'' x 8'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:40:34.03Z"
]
6 => array:11 [
"RoomKey" => "1658732872"
"RoomType" => "Kitchen"
"ListingId" => "40836577"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29878564"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 9'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:40:34.03Z"
]
7 => array:11 [
"RoomKey" => "1658732873"
"RoomType" => "4pc Bathroom"
"ListingId" => "40836577"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29878564"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:40:34.03Z"
]
8 => array:11 [
"RoomKey" => "1658732874"
"RoomType" => "Bedroom"
"ListingId" => "40836577"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29878564"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:40:34.03Z"
]
9 => array:11 [
"RoomKey" => "1658732875"
"RoomType" => "Bedroom"
"ListingId" => "40836577"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29878564"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:40:34.03Z"
]
10 => array:11 [
"RoomKey" => "1658732876"
"RoomType" => "Bedroom"
"ListingId" => "40836577"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29878564"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:40:34.03Z"
]
11 => array:11 [
"RoomKey" => "1658732877"
"RoomType" => "Living room"
"ListingId" => "40836577"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29878564"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 17'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T20:40:34.03Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29878564/525-fallingbrook-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 1020
+"OriginalEntryTimestamp": "2026-06-09T20:39:29.56Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1289821"
+"ListOfficeNationalAssociationId": "1347769"
+"Media": array:29 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29878564_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/7588d6b60c8cf296da1a08041e8e2f20.webp"
"MediaSize" => 175194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-7588d6b60c8cf296da1a08041e8e2f20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick facade residence featuring a front entry with three steps, an attached single-car garage, and a stamped concrete driveway"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29878564_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/a7ceaaa4e92d41c999398132d067f87d.webp"
"MediaSize" => 78388
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-a7ceaaa4e92d41c999398132d067f87d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring gray cabinetry, white countertops, stainless steel appliances, a tiled backsplash, and light-toned floor tiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29878564_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/ced5ecb8b47c46b67667e01df1f66348.webp"
"MediaSize" => 93429
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-ced5ecb8b47c46b67667e01df1f66348.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living space featuring wood-finish flooring, two large windows, a white entry door, recessed lighting, and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29878564_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/791dae5fbecc1dfe73977045d7b6a9fb.webp"
"MediaSize" => 51628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-791dae5fbecc1dfe73977045d7b6a9fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring light gray walls, wood-finish flooring, and a single window with white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29878564_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/236b215ca8fad585835f5d575a5ed7f2.webp"
"MediaSize" => 94391
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-236b215ca8fad585835f5d575a5ed7f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a light-colored vanity with a built-in sink, a framed mirror, and a glass-enclosed shower with tiled walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29878564_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/46f31cf203a88fa460de000e7c12d6e3.webp"
"MediaSize" => 67389
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-46f31cf203a88fa460de000e7c12d6e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "White paneled entry door with decorative glass inserts"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29878564_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/deb5e9dcce6d79125bc707fbc8b19a84.webp"
"MediaSize" => 74407
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-deb5e9dcce6d79125bc707fbc8b19a84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Upper floor landing with wood railing, light blue walls, and ceramic tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29878564_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/399d0a9314b6a2d2ad2d68adda876715.webp"
"MediaSize" => 145362
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-399d0a9314b6a2d2ad2d68adda876715.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior featuring a white entry door with decorative glass, white-framed windows, and a panel garage door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29878564_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/65237dad7e720171bb7ee121c5b93834.webp"
"MediaSize" => 88020
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-65237dad7e720171bb7ee121c5b93834.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Recessed lighting illuminates the room with wood-finish flooring and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29878564_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/340c69b1865bd2e87aea9b4b85845b52.webp"
"MediaSize" => 85963
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-340c69b1865bd2e87aea9b4b85845b52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring light wood-finish flooring, recessed lighting, a neutral gray wall color, a white ceiling, and a hallway with white doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29878564_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/b90e7d4a66b12e108b6752c8aaa4d55b.webp"
"MediaSize" => 97657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-b90e7d4a66b12e108b6752c8aaa4d55b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring gray cabinetry, light countertops, and a subway tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29878564_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/a5850badaca374a6dc2604af28516020.webp"
"MediaSize" => 87469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-a5850badaca374a6dc2604af28516020.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring light gray cabinetry, integrated stainless steel appliances, and a built-in oven"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29878564_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/ea7e2c44ae238eeaffe6e6d2b8c18515.webp"
"MediaSize" => 94749
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-ea7e2c44ae238eeaffe6e6d2b8c18515.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring light gray cabinetry, quartz-finish countertops, and a subway tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29878564_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/771b3bd6cbd7a4e141461866c2ea6ae3.webp"
"MediaSize" => 83981
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-771b3bd6cbd7a4e141461866c2ea6ae3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Interior space featuring light gray walls and white tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29878564_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/4d204783b604c9d60b1a9c77c2547c0b.webp"
"MediaSize" => 94507
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-4d204783b604c9d60b1a9c77c2547c0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring grey cabinetry, white countertops, tile flooring, stainless steel range, and a coordinating range hood"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29878564_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/d654a109e389fb600423de4831b9c3ba.webp"
"MediaSize" => 93398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-d654a109e389fb600423de4831b9c3ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring gray cabinetry with glass-front upper cabinets, white countertops, and a subway tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29878564_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/2e7ddbf8e3b197342df5aa427eff4482.webp"
"MediaSize" => 91649
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-2e7ddbf8e3b197342df5aa427eff4482.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29878564_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/9386dd4110a9a26437cb38558c29d050.webp"
"MediaSize" => 42966
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-9386dd4110a9a26437cb38558c29d050.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light gray wall tones with wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29878564_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/b45cb3c008395220f47779119b4bc1a6.webp"
"MediaSize" => 86738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-b45cb3c008395220f47779119b4bc1a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a light-toned vanity with an integrated sink, a framed mirror, a toilet, and a glass-enclosed shower with a rainfall showerhead"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29878564_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/5da9ac2d9c5c51750523f3ae4b1d484d.webp"
"MediaSize" => 84286
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-5da9ac2d9c5c51750523f3ae4b1d484d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Finished lower level featuring wood-finish flooring, light grey walls, white trim, and a white paneled door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29878564_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/f2380e5c78ef633bcf3fc702852a65c4.webp"
"MediaSize" => 85788
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-f2380e5c78ef633bcf3fc702852a65c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Versatile room with wood-finish flooring, light grey walls, and two horizontal windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29878564_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/9214af484a51cd91d818c38d2b9562ef.webp"
"MediaSize" => 85622
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-9214af484a51cd91d818c38d2b9562ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Finished lower level featuring wood-finish flooring, recessed lighting, and multiple transom windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29878564_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/2bba8654dbbbab9419b72985a0255a04.webp"
"MediaSize" => 125625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-2bba8654dbbbab9419b72985a0255a04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29878564_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/cbc064b93580bc4d68bd810f9b23193c.webp"
"MediaSize" => 158566
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-cbc064b93580bc4d68bd810f9b23193c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29878564_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/60bd17a4f09eb0cf2c45ae7c1085b8f8.webp"
"MediaSize" => 219108
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-60bd17a4f09eb0cf2c45ae7c1085b8f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29878564_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/459486af30f777758424a12e61fc6eb3.webp"
"MediaSize" => 138002
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-459486af30f777758424a12e61fc6eb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Outdoor wood deck with a wooden railing, featuring a large sliding glass door and a horizontal window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29878564_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/0a337351bc10b3508d5232cbbdc3a83e.webp"
"MediaSize" => 192140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-0a337351bc10b3508d5232cbbdc3a83e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rear exterior featuring a wooden deck with railing, sliding glass doors, and two windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29878564_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/0a9990b36630cc0bf0804b3d625dd4bb.webp"
"MediaSize" => 48748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-0a9990b36630cc0bf0804b3d625dd4bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29878564_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29878564/c275c325a5a4e703e0ee2c7e422825fd.webp"
"MediaSize" => 45755
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29878564/thumbnail-c275c325a5a4e703e0ee2c7e422825fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836577"
"ResourceRecordKey" => "29878564"
"ModificationTimestamp" => "2026-06-09T20:39:29.57Z"
]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29878564')"
+"ID": "1512894"
}
]
+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=OfficeMlsId eq 285135" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24706
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2007860" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24700
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29878564'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25094
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29878564'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25113
+items: array:3 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25110
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31406373"
+"ListingKey": "29878564"
+"ListingId": "40836577"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-10T10:47:28Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31406373')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25112
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31409927"
+"ListingKey": "29878564"
+"ListingId": "40836577"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-10T15:27:46Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31409927')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25109
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31410611"
+"ListingKey": "29878564"
+"ListingId": "40836577"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-13"
+"OpenHouseStartTime": "2026-06-13T14:00:00Z"
+"OpenHouseEndTime": "2026-06-13T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-13T16:38:30Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31410611')"
}
]
+success: true
+page_size: 3
+page_count: 1
+count: 3
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29878564' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5584541 43.4876412)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25189
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25163
+post_id: "1536562"
+post_author: 1
+"ListingKey": "29912895"
+"ListingId": "X13453290"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T22:05:19Z"
+"RFModificationTimestamp": "2026-06-16T22:19:34Z"
+"ListPrice": 769000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4Y1"
+"UnparsedAddress": "591 DOGWOOD LANE, Waterloo, Ontario N2L4Y1"
+"Coordinates": array:2 [
0 => -80.560828
1 => 43.486633
]
+"Latitude": 43.486633
+"Longitude": -80.560828
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To Dogwood Lane! This Well-Maintained Bungalow Is Situated On A Quiet, Family-Friendly Street And Offers Comfortable Living With Excellent Income Potential. The Bright Living And Dining Areas Feature Hardwood Flooring And Large Windows For Plenty Of Natural Light. The Updated Kitchen Boasts Ceramic Flooring, Quartz Countertops, And A Stylish Backsplash. The Main Floor Includes Three Generously Sized Bedrooms With Parquet Flooring, Closets, And Separate Main Floor Laundry. The Fully Renovated (2022) Basement Features A Separate Entrance, Separate Laundry, Two Bedrooms, Vinyl Flooring, Pot Lights, A Cozy Fireplace, And A Spacious Living Area. The Bathroom Includes Ceramic Flooring, A Modern Vanity, And A Beautiful Clawfoot Soaker Tub. Enjoy A Large, Beautifully Landscaped Backyard Perfect For Entertaining. Recent Updates Include A.C./Heat Pump (Aug 2023), Furnace (Aug 2023), Tankless Water Heater (Aug 2023), Roof Insulation (Aug 2023), Water Purifier (Jun 2023), Water Filter (Jun 2023), And LeafFilter Gutter Protection (Aug 2023). Conveniently Located Close To Hwy 401, Schools, Shopping, Parks, Public Transit, And Within Walking Distance To The University Of Waterloo Campus. Move-In Ready Home Offering Comfort, Convenience, And Versatility. EXTRAS: Separate Entrance To Renovated Basement With Separate Laundry, Tankless Water Heater, Water Purifier, Water Filter, Heat Pump, LeafFilter Gutter Protection, Fireplace In Basement. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Water purifier"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
9 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Separate entrance"
2 => "Walk-up"
3 => "N/A"
4 => "N/A"
5 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T22:19:28.544312+00:00"
+"Directions": "Bearinger Road / Toll Gate/Dogwood Ln"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:4 [
0 => "Hardwood"
1 => "Parquet"
2 => "Ceramic"
3 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2105595"
+"ListOfficeKey": "164016"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "45 x 114 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T21:55:46Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T21:55:46Z"
+"Stories": "1.0"
+"StreetName": "Dogwood"
+"StreetNumber": "591"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "4316"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"View": "View"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1660771827"
"RoomType" => "Living room"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 3.6
"ListingKey" => "29912895"
"RoomLength" => 4.97
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.32Z"
]
1 => array:11 [
"RoomKey" => "1660771828"
"RoomType" => "Dining room"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29912895"
"RoomLength" => 2.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.32Z"
]
2 => array:11 [
"RoomKey" => "1660771829"
"RoomType" => "Kitchen"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 3.48
"ListingKey" => "29912895"
"RoomLength" => 4.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.32Z"
]
3 => array:11 [
"RoomKey" => "1660771830"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 3.14
"ListingKey" => "29912895"
"RoomLength" => 3.91
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.32Z"
]
4 => array:11 [
"RoomKey" => "1660771831"
"RoomType" => "Bedroom 2"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 2.69
"ListingKey" => "29912895"
"RoomLength" => 3.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.32Z"
]
5 => array:11 [
"RoomKey" => "1660771832"
"RoomType" => "Bedroom 3"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29912895"
"RoomLength" => 2.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.32Z"
]
6 => array:11 [
"RoomKey" => "1660771833"
"RoomType" => "Living room"
"ListingId" => "X13453290"
"RoomLevel" => "Basement"
"RoomWidth" => 4.72
"ListingKey" => "29912895"
"RoomLength" => 5.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.32Z"
]
7 => array:11 [
"RoomKey" => "1660771834"
"RoomType" => "Bedroom 4"
"ListingId" => "X13453290"
"RoomLevel" => "Basement"
"RoomWidth" => 3.96
"ListingKey" => "29912895"
"RoomLength" => 3.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.33Z"
]
8 => array:11 [
"RoomKey" => "1660771835"
"RoomType" => "Bedroom 5"
"ListingId" => "X13453290"
"RoomLevel" => "Basement"
"RoomWidth" => 3.02
"ListingKey" => "29912895"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.33Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29912895/591-dogwood-lane-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-16T21:55:46.28Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1374868"
+"ListOfficeNationalAssociationId": "1184644"
+"Media": array:38 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29912895_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/fb975b8a5449de12ebf6f2bbc2755134.webp"
"MediaSize" => 535748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-fb975b8a5449de12ebf6f2bbc2755134.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29912895_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/a1c63bdb354f10c613066fab83f1b315.webp"
"MediaSize" => 467201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-a1c63bdb354f10c613066fab83f1b315.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29912895_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/8d37c3159eedb5a52e519dfe3e28d123.webp"
"MediaSize" => 410878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-8d37c3159eedb5a52e519dfe3e28d123.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29912895_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/21b6eaffba637eadd7d7cbb83b64e548.webp"
"MediaSize" => 233326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-21b6eaffba637eadd7d7cbb83b64e548.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29912895_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/76996cf06e62124448ef7fc5a0d3ab4d.webp"
"MediaSize" => 181093
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-76996cf06e62124448ef7fc5a0d3ab4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29912895_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/b7583655d55f0c54bee9638d768aa66e.webp"
"MediaSize" => 188793
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-b7583655d55f0c54bee9638d768aa66e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29912895_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/765fd4c87d7fa914afd1e22fb78fe01f.webp"
"MediaSize" => 209197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-765fd4c87d7fa914afd1e22fb78fe01f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29912895_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/7ff4879424177e7f96f3a8e72d6c08ce.webp"
"MediaSize" => 164711
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-7ff4879424177e7f96f3a8e72d6c08ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29912895_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/3a38f301a955b2331a3f7ef232b712e3.webp"
"MediaSize" => 150405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-3a38f301a955b2331a3f7ef232b712e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29912895_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/8e43a39643f4fb4f7eaf5379ccc0319a.webp"
"MediaSize" => 154948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-8e43a39643f4fb4f7eaf5379ccc0319a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29912895_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/66cd52d9d1107e6eb72f74d278a49a46.webp"
"MediaSize" => 127490
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-66cd52d9d1107e6eb72f74d278a49a46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29912895_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/620645837387dc617bdacec22232e805.webp"
"MediaSize" => 206724
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-620645837387dc617bdacec22232e805.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29912895_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/9740899d4ed8c99bd09e163cab95ef3a.webp"
"MediaSize" => 178358
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-9740899d4ed8c99bd09e163cab95ef3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29912895_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/c1171762eccc0755a6101706ddeb7ef0.webp"
"MediaSize" => 181321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-c1171762eccc0755a6101706ddeb7ef0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29912895_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/60000bfb24cb1568204544017510f7a5.webp"
"MediaSize" => 175070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-60000bfb24cb1568204544017510f7a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29912895_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/585a01a791106aca4628eec3bc4f049a.webp"
"MediaSize" => 179129
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-585a01a791106aca4628eec3bc4f049a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29912895_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/8da9383aac5db4de0c4eb96abb9c118b.webp"
"MediaSize" => 177765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-8da9383aac5db4de0c4eb96abb9c118b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29912895_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/62367b8ee8a18f80062096452cc218a7.webp"
"MediaSize" => 147483
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-62367b8ee8a18f80062096452cc218a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29912895_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/1c42aaed56a33f8880786f0a640370e5.webp"
"MediaSize" => 170664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-1c42aaed56a33f8880786f0a640370e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29912895_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/60322702cbb69e899c1eb36a88ec3d15.webp"
"MediaSize" => 114303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-60322702cbb69e899c1eb36a88ec3d15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29912895_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/3c7f1288f42c1c5ddbefecd97391ef2b.webp"
"MediaSize" => 114303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-3c7f1288f42c1c5ddbefecd97391ef2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29912895_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/111633c212a4198625857ccaff229cf6.webp"
"MediaSize" => 98561
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-111633c212a4198625857ccaff229cf6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29912895_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/b8d9a782eddd3ded2aaa0e474a490602.webp"
"MediaSize" => 155117
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-b8d9a782eddd3ded2aaa0e474a490602.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29912895_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/85d0447ee6489d476a69bac74bc39bf5.webp"
"MediaSize" => 153346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-85d0447ee6489d476a69bac74bc39bf5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29912895_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/1fb5e580c160bfff24440230659cdda1.webp"
"MediaSize" => 184426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-1fb5e580c160bfff24440230659cdda1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912895')"
+"ID": "1536562"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25165
+post_id: "1536272"
+post_author: 1
+"ListingKey": "29912090"
+"ListingId": "40838984"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T02:40:13Z"
+"RFModificationTimestamp": "2026-06-17T02:46:19Z"
+"ListPrice": 800000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.12
+"LivingArea": 2776.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2J3"
+"UnparsedAddress": "491 SANDBANKS Crescent, Waterloo, Ontario N2V2J3"
+"Coordinates": array:2 [
0 => -80.5768545
1 => 43.4964646
]
+"Latitude": 43.4964646
+"Longitude": -80.5768545
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "IS THIS YOUR NEW HOME? Situated in desirable Conservation Meadows, this 2 Storey home offers a special option for those needing accessible features, including a main floor bedroom and ramp to the front door (2015) and also a ramp off the deck (2016). The stunning acacia engineered hardwood flooring (2019) greets you as you enter this bright and spacious main floor. The updates continue into the kitchen with new white cabinetry, quartz counters, stainless appliances and dimmable pot lights (2022). The sliders to the backyard walk out to the peaceful backyard showcasing lovely perennial gardens, and also features an Arctic Spa Yukon hot tub. Upstairs you will find 3 good-sized bedrooms including a spacious primary bedroom with large walk-in closet, and a long bathroom with potential for splitting it into two (a main bath and an ensuite bath). In the finished basement you will find a newly finished rec room, large utility room / workshop area, laundry room, cold cellar, and a separate den/office/storage room (potential for a 5th bedroom!). Additional updates include roof (2014), air conditioner (2017) washer/dryer (approx 2021), dishwasher (2024). (id:62783)"
+"AccessibilityFeatures": array:1 [
0 => "Accessible Approach with Ramp"
]
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T20:49:21.761386+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1990854"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Sump Pump"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T00:32:16Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T02:32:01Z"
+"Stories": "2.0"
+"StreetName": "SANDBANKS"
+"StreetNumber": "491"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "6158"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/491-Sandbanks-Crescent"
+"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/29912090/491-sandbanks-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 2063
+"BelowGradeFinishedArea": 713
+"OriginalEntryTimestamp": "2026-06-16T20:10:34.34Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1274526"
+"ListOfficeNationalAssociationId": "1378680"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912090')"
+"ID": "1536272"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25162
+post_id: "1536105"
+post_author: 1
+"ListingKey": "29911948"
+"ListingId": "40840389"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T21:40:11Z"
+"RFModificationTimestamp": "2026-06-16T21:44:59Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 2137.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4J3"
+"UnparsedAddress": "543 GLEN FORREST Boulevard, Waterloo, Ontario N2L4J3"
+"Coordinates": array:2 [
0 => -80.5539256
1 => 43.4861133
]
+"Latitude": 43.4861133
+"Longitude": -80.5539256
+"YearBuilt": 1967
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this detached bungalow in a desirable and tucked-away Waterloo location, offering over 1,800 sq. ft. of finished living space, a huge lot, and incredible potential inside and out. Perfect for first-time buyers, investors, or multi-generational families, this home features a bright main level with 3 bedrooms, 1 full bathroom, and comfortable living and dining areas. The separate entrance to the basement adds excellent flexibility, with 4 additional bedrooms and 2 full bathrooms, making it ideal for extended family use or potential mortgage-helper income. Set on a generous lot with 60 ft. frontage, this property offers parking for up to 4 vehicles in the driveway plus 1 in the garage. The backyard is a major highlight, offering so much potential to create a private outdoor retreat, garden space, patio area, or future entertaining setup. Located in a secluded area of Waterloo while still being close to everyday amenities, shopping, schools, public transportation, Conestoga College, and the University of Waterloo, this home provides both convenience and opportunity. Whether you are looking to move in, invest, or add value over time, this property is full of possibilities. Book your private showing today! * Some photos have been virtually staged. (id:62783)"
+"Appliances": array:3 [
0 => "Washer"
1 => "Stove"
2 => "Dryer"
]
+"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-16T20:34:13.849462+00:00"
+"Directions": "BEARINGER RD TO GLEN FORREST BLVD"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750682"
+"ListOfficeKey": "289792"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T19:50:57Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T21:32:44Z"
+"Stories": "1.0"
+"StreetName": "GLEN FORREST"
+"StreetNumber": "543"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "4425"
+"VirtualTourURLUnbranded": "https://youriguide.com/0frvu_543_glen_forrest_blvd_waterloo_on/"
+"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/29911948/543-glen-forrest-boulevard-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2172787"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "156376"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 1108
+"BelowGradeFinishedArea": 1029
+"OriginalEntryTimestamp": "2026-06-16T19:50:55.86Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1164848"
+"ListOfficeNationalAssociationId": "1381240"
+"CoListAgentNationalAssociationId": "1423270"
+"CoListOfficeNationalAssociationId": "1003925"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29911948')"
+"ID": "1536105"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25166
+post_id: "1534435"
+post_author: 1
+"ListingKey": "29909870"
+"ListingId": "X13450512"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:10:11Z"
+"RFModificationTimestamp": "2026-06-16T16:26:29Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4N7"
+"UnparsedAddress": "514 HAVELOCK DRIVE, Waterloo, Ontario N2L4N7"
+"Coordinates": array:2 [
0 => -80.55825
1 => 43.489526
]
+"Latitude": 43.489526
+"Longitude": -80.55825
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 514 Havelock Drive! Nestled in one of Waterloo's most sought-after family-friendly neighbourhoods, this well-maintained 3+1 bedroom, 2-bathroom bungalow offers the perfect combination of comfort, convenience, and future potential. The carpet-free main floor features a bright and functional layout with 3 spacious bedrooms, a full bathroom, a well-appointed kitchen, and inviting living and dining areas ideal for everyday living and entertaining. A separate side entrance provides excellent flexibility and potential for an in-law setup or multi-generational living. The fully finished basement expands your living space with a large rec room, an office or fourth bedroom, a 3-piece bathroom, laundry room, and a bonus workshop-perfect for hobbyists, DIY enthusiasts, or additional storage. Step outside to your own private retreat. The fully fenced backyard oasis is designed for relaxation and entertaining, featuring a spacious deck, storage shed, and a wooden gazebo covering the hot tub-an ideal space to unwind year-round. With parking for up to 5 vehicles, this home is perfectly suited for growing families and busy households. Deck (2023), Water Heater (2023), Washer & Dryer (2024), Roof (2023). Conveniently located just minutes from Highway 7 and Highway 8, as well as Wilfrid Laurier University, University of Waterloo, numerous parks and trails, and Conestoga Mall, this exceptional property offers an unbeatable location close to everything you need. Whether you're a growing family, investor, or buyer seeking multi-generational living potential, 514 Havelock Drive delivers outstanding value in an incredible Waterloo location. Book your private showing today! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T16:26:23.962076+00:00"
+"Directions": "Glen Forest Blvd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2127512"
+"ListOfficeKey": "283918"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Gazebo"
]
+"LotSizeDimensions": "43.1 x 122.2 FT"
+"ParkingFeatures": array:2 [
0 => "Covered"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T15:59:56Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:59:56Z"
+"Stories": "1.0"
+"StreetName": "Havelock"
+"StreetNumber": "514"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3987"
+"VirtualTourURLUnbranded": "https://youriguide.com/wqcfm_514_havelock_dr_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": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29909870/514-havelock-drive-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 43.1
+"OriginalEntryTimestamp": "2026-06-16T15:59:55.98Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1380753"
+"ListOfficeNationalAssociationId": "1336772"
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909870')"
+"ID": "1534435"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25164
+post_id: "1534290"
+post_author: 1
+"ListingKey": "29909459"
+"ListingId": "40836533"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T15:20:10Z"
+"RFModificationTimestamp": "2026-06-16T15:36:25Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2101.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4N7"
+"UnparsedAddress": "514 HAVELOCK Drive, Waterloo, Ontario N2L4N7"
+"Coordinates": array:2 [
0 => -80.5582589
1 => 43.4895518
]
+"Latitude": 43.4895518
+"Longitude": -80.5582589
+"YearBuilt": 1971
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 514 Havelock Drive! Nestled in one of Waterloo’s most sought-after family-friendly neighbourhoods, this well-maintained 3+1 bedroom, 2-bathroom bungalow offers the perfect combination of comfort, convenience, and future potential. The carpet-free main floor features a bright and functional layout with 3 spacious bedrooms, a full bathroom, a well-appointed kitchen, and inviting living and dining areas ideal for everyday living and entertaining. A separate side entrance provides excellent flexibility and potential for an in-law setup or multi-generational living. The fully finished basement expands your living space with a large rec room, an office or fourth bedroom, a 3-piece bathroom, laundry room, and a bonus workshop—perfect for hobbyists, DIY enthusiasts, or additional storage. Step outside to your own private retreat. The fully fenced backyard oasis is designed for relaxation and entertaining, featuring a spacious deck, storage shed, and a wooden gazebo covering the hot tub—an ideal space to unwind year-round. With parking for up to 5 vehicles, this home is perfectly suited for growing families and busy households. Deck (2023), Water Heater (2023), Washer & Dryer (2024), Roof (2023). Conveniently located just minutes from Highway 7 and Highway 8, as well as Wilfrid Laurier University, University of Waterloo, numerous parks and trails, and Conestoga Mall, this exceptional property offers an unbeatable location close to everything you need. Whether you're a growing family, investor, or buyer seeking multi-generational living potential, 514 Havelock Drive delivers outstanding value in an incredible Waterloo location. Book your private showing today! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T15:36:23.785553+00:00"
+"Directions": "Glen Forest Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750161"
+"ListOfficeKey": "283896"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-06-16T15:13:40Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:13:40Z"
+"Stories": "1.0"
+"StreetName": "HAVELOCK"
+"StreetNumber": "514"
+"StreetSuffix": "Drive"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "3987"
+"VirtualTourURLUnbranded": "https://youriguide.com/wqcfm_514_havelock_dr_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/29909459/514-havelock-drive-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 43.0
+"AboveGradeFinishedArea": 1071
+"BelowGradeFinishedArea": 1030
+"OriginalEntryTimestamp": "2026-06-16T15:11:23.62Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1163644"
+"ListOfficeNationalAssociationId": "1349002"
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909459')"
+"ID": "1534290"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25159
+post_id: "1534996"
+post_author: 1
+"ListingKey": "29908944"
+"ListingId": "40839096"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T14:20:09Z"
+"RFModificationTimestamp": "2026-06-16T14:34:59Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1202.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1Z2"
+"UnparsedAddress": "255 NORTHLAKE Drive Unit# 15, Waterloo, Ontario N2V1Z2"
+"Coordinates": array:2 [
0 => -80.55183
1 => 43.4976023
]
+"Latitude": 43.4976023
+"Longitude": -80.55183
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Don't miss this opportunity to own a well-maintained home in Waterloo's desirable North Lakeshore neighbourhood. Location is everything! Just minutes from the LRT, Conestoga Mall, the St. Jacobs Market District, excellent schools, restaurants, grocery stores, parks, trails, and major highways. Walk or bike to almost everything you need. The main floor features a spacious entryway with a double closet, an updated powder room, and a bright white kitchen with newer countertops and sink, open to the dining and living areas. The functional layout offers comfortable everyday living with direct access to the backyard deck, perfect for relaxing or entertaining. With over 1,500 sq. ft. of finished living space, this home offers 3 bedrooms, 1.5 bathrooms, and a fully finished basement complete with a recreation room, laundry area, and rough-in for a future bathroom. Recent updates include modern laminate flooring, interior doors, and hardware. Outside, enjoy a welcoming patio and the convenience of a single carport. Ideal for first-time buyers, families, commuters, or investors looking for a low-maintenance home in a prime Waterloo location. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
]
+"AssociationFee": "500"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T14:34:50.434290+00:00"
+"Directions": "Weber and Golden Eagle"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564276"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:2 [
0 => "Carport"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-16T14:12:31Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T14:12:31Z"
+"Stories": "2.0"
+"StreetName": "NORTHLAKE"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "3036.39"
+"VirtualTourURLUnbranded": "https://youriguide.com/unit_15_255_northlake_dr_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/29908944/255-northlake-drive-unit-15-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1202
+"OriginalEntryTimestamp": "2026-06-16T14:10:40.39Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1107226"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:40 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908944')"
+"ID": "1534996"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1532260"
+post_author: 1
+"ListingKey": "29903651"
+"ListingId": "40839157"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T15:40:08Z"
+"RFModificationTimestamp": "2026-06-15T20:50:40Z"
+"ListPrice": 330000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 800.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1Z1"
+"UnparsedAddress": "331 NORTHLAKE Drive Unit# 5, Waterloo, Ontario N2V1Z1"
+"Coordinates": array:2 [
0 => -80.5540193
1 => 43.5009095
]
+"Latitude": 43.5009095
+"Longitude": -80.5540193
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 5 at 331 Northlake Drive, a bright and move-in-ready condo offering a practical layout and everyday convenience, perfect for first-time buyers, downsizers, or young families. The spacious open-concept living area creates an inviting space to relax, dine, and entertain, while the kitchen offers great functionality with restored cabinetry and plenty of room for daily use. New flooring and fresh paint throughout give the unit a clean, updated feel. Two comfortable bedrooms offer versatile options for a nursery, guest room, or office, and the refreshed bathroom adds a polished touch. Enjoy the convenience of in-suite laundry, plus a storage locker for extra storage and organization. Close to schools, parks, and trails, you’ll love this location in a quiet, family-friendly Waterloo neighbourhood. Groceries, dining, and fitness options are conveniently around the corner, while Conestoga Mall and the ION Rail are nearby. If you’re looking for a low-maintenance lifestyle in a convenient location, this unit is for you! Book your private showing today. (id:62783)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"AssociationFee": "335"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-15T20:46:42.470151+00:00"
+"Directions": "Swallow Street / Northlake Drive"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2025082"
+"ListOfficeKey": "291822"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Laundry- Coin operated"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-15T15:31:21Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T15:31:20Z"
+"Stories": "1.0"
+"StreetName": "NORTHLAKE"
+"StreetNumber": "331"
+"StreetSuffix": "Drive"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "2019.49"
+"VirtualTourURLUnbranded": "https://youtu.be/tTqPA_pGGbw"
+"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/29903651/331-northlake-drive-unit-5-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1989189"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "292624"
+"GeocodeManualYN": true
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 800
+"OriginalEntryTimestamp": "2026-06-15T15:31:20.93Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1304786"
+"ListOfficeNationalAssociationId": "1405037"
+"CoListAgentNationalAssociationId": "1273184"
+"CoListOfficeNationalAssociationId": "1414872"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29903651')"
+"ID": "1532260"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25167
+post_id: "1528066"
+post_author: 1
+"ListingKey": "29900056"
+"ListingId": "40839552"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T13:40:14Z"
+"RFModificationTimestamp": "2026-06-13T14:02:37Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 546.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K7"
+"UnparsedAddress": "145 COLUMBIA Street W Unit# 1536, Waterloo, Ontario N2L0K7"
+"Coordinates": array:2 [
0 => -80.5389137
1 => 43.4769907
]
+"Latitude": 43.4769907
+"Longitude": -80.5389137
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Society 145, a brand-new luxury condominium ideally located in the heart of Waterloo, just steps from both the University of Waterloo and Wilfrid Laurier University. The unit is adorned with high-end finishes, including hardwood floors, quartz countertops, stylish light fixtures, and rich carpentry throughout, ensuring a sophisticated and comfortable living environment. Modern kitchen featuring stainless steel appliances, ample storage, and an open-concept living area perfect for entertaining. The bedroom and den are spacious and fully furnished. Residents of 145 Society enjoy top-tier amenities, including a state-of-the-art fitness center, yoga studio, indoor basketball court, games room with billiards, ping pong, and arcade games, as well as a movie theater and business lounge. The ideal blend of luxury, convenience, and modern living - a perfect choice for anyone looking to invest in one of Waterloo's best buildings. 145 Columbia St. W. unit 1536 is currently occupied by Tenant, generating more than $2500.00per month. The lease will be end of August 2026. (id:62783)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
]
+"AssociationFee": "311.45"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T14:02:10.081436+00:00"
+"Directions": "Phillip St to Columbia St W"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2175198"
+"ListOfficeKey": "292482"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Southern exposure"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-13T13:31:32Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T13:31:31Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "COLUMBIA"
+"StreetNumber": "145"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3304.57"
+"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/29900056/145-columbia-street-w-unit-1536-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Exercise Centre"
]
+"ZoningDescription": "RN-25"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 546
+"OriginalEntryTimestamp": "2026-06-13T13:31:31.86Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1425540"
+"ListOfficeNationalAssociationId": "1412629"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29900056')"
+"ID": "1528066"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25187
+post_id: "1525986"
+post_author: 1
+"ListingKey": "29897607"
+"ListingId": "X13439034"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T15:25:16Z"
+"RFModificationTimestamp": "2026-06-15T15:25:56Z"
+"ListPrice": 779000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4J8"
+"UnparsedAddress": "598 GLEN FORREST BOULEVARD, Waterloo, Ontario N2L4J8"
+"Coordinates": array:2 [
0 => -80.557071
1 => 43.48873
]
+"Latitude": 43.48873
+"Longitude": -80.557071
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Opportunity knocks at 598 Glen Forrest Boulevard! This spacious bungalow is very deceiving from the street! offers a versatile floor plan with 4 bedrooms on the main floor and 2 additional bedrooms in the finished lower level. The home is equipped with 2 kitchens, 2 bathrooms, and a fully separate entrance. The home is ideally suited for multi-generational living, an in-law setup, or potential income-generating possibilities. Numerous upgrades have been completed throughout the years, making this property move-in ready while still offering future potential. Enjoy a double driveway and garage for ample parking. A fantastic location close to top-rated schools, parks, shopping, transit, and Waterloo's renowned universities. 5 minutes from the future home of the new waterloo regional hospital. Quick possession available for buyers looking to make their move without delay. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T00:11:02.146610+00:00"
+"Directions": "Cross Streets: Weber St. ** Directions: Northfield to Weber St S to Glen Forrest Blvd."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2143277"
+"ListOfficeKey": "284147"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "65.6 x 114.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T15:18:48Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T15:18:48Z"
+"Stories": "1.0"
+"StreetName": "Glen Forrest"
+"StreetNumber": "598"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "5227.74"
+"VirtualTourURLUnbranded": "https://youriguide.com/598_glen_forrest_boulevard_waterloo_on/"
+"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/29897607/598-glen-forrest-boulevard-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 65.7
+"OriginalEntryTimestamp": "2026-06-12T19:50:44.02Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1406869"
+"ListOfficeNationalAssociationId": "1338998"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29897607')"
+"ID": "1525986"
}
]
+success: true
+page_size: 9
+page_count: 10
+count: 82
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]