array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29940666 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411
+post_id: "1556740"
+post_author: 1
+"ListingKey": "29940666"
+"ListingId": "40842058"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T16:20:23Z"
+"RFModificationTimestamp": "2026-06-23T16:23:25Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2034.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4W9"
+"UnparsedAddress": "176 WOODVILLE Place, Waterloo, Ontario N2L4W9"
+"Coordinates": array:2 [
0 => -80.547439
1 => 43.4910554
]
+"Latitude": 43.4910554
+"Longitude": -80.547439
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Cul-de-sac living! Welcome to 176 Woodville Place, a beautifully maintained raised bungalow situated on a quiet cul-de-sac in a prime location. This spacious 5-bedroom, 2-bathroom home is perfect for families looking for a move-in-ready property with great potential. Freshly painted throughout, the functional layout features a fully finished walk-out basement with a separate entrance, offering excellent flexibility. The bright lower level has full sized windows, making this style of home perfect for an in-law set up or totally separate rental unit conversion. Some notable updates include : Furnace/AC/Roof (2022) and most windows (2021). The home comes with an attached single-car garage and 4 car driveway offers space for everyone. No rental contracts to worry about. Relax on the raised deck with newly installed stairs, or enjoy the inground concrete pool—a true serene oasis for the summer months. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T14:36:55.431146+00:00"
+"Directions": "Parkside Dr to Cedarbrae Ave to Mt Anne Dr to Woodville Place"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2053490"
+"ListOfficeKey": "76840"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T14:11:54Z"
+"PhotosCount": 40
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T16:11:31Z"
+"Stories": "1.0"
+"StreetName": "WOODVILLE"
+"StreetNumber": "176"
+"StreetSuffix": "Place"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "4891"
+"VirtualTourURLUnbranded": "https://youriguide.com/176_woodville_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1666110740"
"RoomType" => "Laundry room"
"ListingId" => "40842058"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29940666"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:11:31.73Z"
]
1 => array:11 [
"RoomKey" => "1666110741"
"RoomType" => "3pc Bathroom"
"ListingId" => "40842058"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29940666"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 5'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:11:31.73Z"
]
2 => array:11 [
"RoomKey" => "1666110742"
"RoomType" => "Bedroom"
"ListingId" => "40842058"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29940666"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:11:31.73Z"
]
3 => array:11 [
"RoomKey" => "1666110743"
"RoomType" => "Bedroom"
"ListingId" => "40842058"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29940666"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 8'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:11:31.73Z"
]
4 => array:11 [
"RoomKey" => "1666110744"
"RoomType" => "Laundry room"
"ListingId" => "40842058"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29940666"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:11:31.73Z"
]
5 => array:11 [
"RoomKey" => "1666110745"
"RoomType" => "Recreation room"
"ListingId" => "40842058"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29940666"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 22'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:11:31.74Z"
]
6 => array:11 [
"RoomKey" => "1666110746"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842058"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29940666"
"RoomLength" => null
"RoomDimensions" => "7'1'' x 6'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:11:31.74Z"
]
7 => array:11 [
"RoomKey" => "1666110747"
"RoomType" => "Bedroom"
"ListingId" => "40842058"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29940666"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 10'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:11:31.74Z"
]
8 => array:11 [
"RoomKey" => "1666110748"
"RoomType" => "Bedroom"
"ListingId" => "40842058"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29940666"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:11:31.74Z"
]
9 => array:11 [
"RoomKey" => "1666110749"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842058"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29940666"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:11:31.74Z"
]
10 => array:11 [
"RoomKey" => "1666110750"
"RoomType" => "Kitchen"
"ListingId" => "40842058"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29940666"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:11:31.74Z"
]
11 => array:11 [
"RoomKey" => "1666110751"
"RoomType" => "Bonus Room"
"ListingId" => "40842058"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29940666"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:11:31.74Z"
]
12 => array:11 [
"RoomKey" => "1666110752"
"RoomType" => "Dining room"
"ListingId" => "40842058"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29940666"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 9'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:11:31.74Z"
]
13 => array:11 [
"RoomKey" => "1666110753"
"RoomType" => "Living room"
"ListingId" => "40842058"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29940666"
"RoomLength" => null
"RoomDimensions" => "14'2'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:11:31.75Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29940666/176-woodville-place-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2102262"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76840"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1198
+"BelowGradeFinishedArea": 836
+"OriginalEntryTimestamp": "2026-06-23T14:11:54.56Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1328779"
+"ListOfficeNationalAssociationId": "1004363"
+"CoListAgentNationalAssociationId": "1372011"
+"CoListOfficeNationalAssociationId": "1004363"
+"Media": array:40 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29940666_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/75013668eae2a9b5d274d3ef2e1db5ba.webp"
"MediaSize" => 128809
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-75013668eae2a9b5d274d3ef2e1db5ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Welcome to 176 Woodville Pl."
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29940666_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/b41db6679c9c35f9e2f534491b95bb79.webp"
"MediaSize" => 137096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-b41db6679c9c35f9e2f534491b95bb79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "A bungalow featuring a brick and siding exterior, bay window, front entry with sidelight, integrated garage, and a sloped front lawn with mature trees"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29940666_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/44822d0831b696d3fb9b7b57f39b5d0b.webp"
"MediaSize" => 140554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-44822d0831b696d3fb9b7b57f39b5d0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29940666_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/72d362236c5393bcc06582ad605a9eef.webp"
"MediaSize" => 127508
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-72d362236c5393bcc06582ad605a9eef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29940666_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/5dd8084cb29899e1c0163f7929a49bff.webp"
"MediaSize" => 115803
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-5dd8084cb29899e1c0163f7929a49bff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a brown wood-finish door with decorative glass, a coordinating sidelight, and an overhead transom window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29940666_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/a9cf6af91ba42506ec6f2ad7bba60f65.webp"
"MediaSize" => 49919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-a9cf6af91ba42506ec6f2ad7bba60f65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29940666_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/c2611eb538636ca1737942c0f7974505.webp"
"MediaSize" => 66693
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-c2611eb538636ca1737942c0f7974505.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29940666_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/8d735ba5ed908e1cd0e90718c3ddd5eb.webp"
"MediaSize" => 66433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-8d735ba5ed908e1cd0e90718c3ddd5eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29940666_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/3fb7327299feb702d90edc794a2f6c5b.webp"
"MediaSize" => 68898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-3fb7327299feb702d90edc794a2f6c5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring light wood-finish flooring, light blue wall finishes, and recessed ceiling lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29940666_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/26f9bb3f7af8148d87dae7395098b027.webp"
"MediaSize" => 83331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-26f9bb3f7af8148d87dae7395098b027.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring light wood cabinetry, stainless steel appliances, and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29940666_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/fc67570a385dbf15374218a04f65c9ea.webp"
"MediaSize" => 84571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-fc67570a385dbf15374218a04f65c9ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring wood cabinetry, stainless steel appliances, and a window above the sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29940666_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/74e960ec5d232cffda2e316d45973b9e.webp"
"MediaSize" => 88413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-74e960ec5d232cffda2e316d45973b9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29940666_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/257fee1743b7e7ab0176f36814e6fedf.webp"
"MediaSize" => 109956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-257fee1743b7e7ab0176f36814e6fedf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29940666_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/e09c7a04367bb20647d48c0506852edb.webp"
"MediaSize" => 89931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-e09c7a04367bb20647d48c0506852edb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29940666_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/b585e0b38769842838a5344c94ab33ea.webp"
"MediaSize" => 84299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-b585e0b38769842838a5344c94ab33ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29940666_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/6446f94b037e6bd6211638722db670d3.webp"
"MediaSize" => 78539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-6446f94b037e6bd6211638722db670d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29940666_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/cc612ba34d4f4a2034de7339ad3eb574.webp"
"MediaSize" => 73146
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-cc612ba34d4f4a2034de7339ad3eb574.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29940666_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/21de25d226a04b5a93a0828605e4b340.webp"
"MediaSize" => 47406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-21de25d226a04b5a93a0828605e4b340.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29940666_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/a0aa47d12ef9e5bf3007eca42168a27a.webp"
"MediaSize" => 79758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-a0aa47d12ef9e5bf3007eca42168a27a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29940666_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/f6865c591b19005c27cdaba6bba9a4e8.webp"
"MediaSize" => 66271
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-f6865c591b19005c27cdaba6bba9a4e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29940666_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/f67247ac3b33e628ad761035d11797ea.webp"
"MediaSize" => 56258
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-f67247ac3b33e628ad761035d11797ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29940666_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/55569708d6794796a339b8444a824f07.webp"
"MediaSize" => 46202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-55569708d6794796a339b8444a824f07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29940666_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/e3c3c93dcdadcfb02031958a454d0b9e.webp"
"MediaSize" => 56007
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-e3c3c93dcdadcfb02031958a454d0b9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29940666_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/26329bff2fb6aadb8d406f024332eb80.webp"
"MediaSize" => 49878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-26329bff2fb6aadb8d406f024332eb80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29940666_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/abae1fb2b749dcfc4cdbd2e9555e5d19.webp"
"MediaSize" => 42530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-abae1fb2b749dcfc4cdbd2e9555e5d19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29940666_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/20e320d713d2ef0ab6134d7423cfb1ae.webp"
"MediaSize" => 42156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-20e320d713d2ef0ab6134d7423cfb1ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29940666_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/9317fe83f79229e3a08239324ad4deb5.webp"
"MediaSize" => 41125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-9317fe83f79229e3a08239324ad4deb5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29940666_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/66bad5904cfd6f103658683c20b7e1f3.webp"
"MediaSize" => 40627
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-66bad5904cfd6f103658683c20b7e1f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29940666_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/cff3c207f421e38964a372ca82fcaf3d.webp"
"MediaSize" => 58410
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-cff3c207f421e38964a372ca82fcaf3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry area featuring wood-finish flooring, a utility sink with a chrome faucet, white cabinetry, and a window providing natural light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29940666_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/c752bd9c9fd12e99d946e4316e824903.webp"
"MediaSize" => 31128
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-c752bd9c9fd12e99d946e4316e824903.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29940666_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/38c7ff178a1e1c4ec8929bfbc0db5da2.webp"
"MediaSize" => 164755
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-38c7ff178a1e1c4ec8929bfbc0db5da2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29940666_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/05ec2dd943196640471aaa599d1f7a42.webp"
"MediaSize" => 119728
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-05ec2dd943196640471aaa599d1f7a42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29940666_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/56d27cddff91161b2fa82cab97c16f85.webp"
"MediaSize" => 170589
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-56d27cddff91161b2fa82cab97c16f85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive outdoor living area featuring a wood deck with stairs, a spacious lawn, a wooden privacy fence, a storage shed, and mature trees"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29940666_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/ba4398cbeddab94207af6418b7eb6a48.webp"
"MediaSize" => 180077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-ba4398cbeddab94207af6418b7eb6a48.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious backyard featuring a wood privacy fence, mature trees, and a multi-level wooden play structure"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29940666_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/35c6c376d9a32dd692c7afb063f5764a.webp"
"MediaSize" => 139951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-35c6c376d9a32dd692c7afb063f5764a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Oval in-ground swimming pool with surrounding concrete decking"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29940666_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/385ffe74f72b6ea36e5e5be294b7af91.webp"
"MediaSize" => 143533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-385ffe74f72b6ea36e5e5be294b7af91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Oval-shaped in-ground pool with surrounding paved patio, situated beside a multi-level residential structure featuring a light brown shingle roof and a brick chimney"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29940666_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/f4c04c2d24d78de6ef955c9e21303653.webp"
"MediaSize" => 146376
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-f4c04c2d24d78de6ef955c9e21303653.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive aerial view showcasing a residential area with varied housing styles and mature trees"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29940666_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/d14cec4bd58f2f2946c362ab47b0d53d.webp"
"MediaSize" => 148179
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-d14cec4bd58f2f2946c362ab47b0d53d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial perspective showcasing a residential neighborhood with established trees and detached homes"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29940666_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/9b04abf1a3995e1a08edbc801ee19cfd.webp"
"MediaSize" => 45014
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-9b04abf1a3995e1a08edbc801ee19cfd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29940666_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29940666/9ef932972a97f0c3268910d5f831ac80.webp"
"MediaSize" => 41385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29940666/thumbnail-9ef932972a97f0c3268910d5f831ac80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842058"
"ResourceRecordKey" => "29940666"
"ModificationTimestamp" => "2026-06-23T14:11:54.57Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29940666')"
+"ID": "1556740"
}
]
+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 76840" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24829
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2053490" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24838
+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 '29940666'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25233
+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 '29940666'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25248
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25249
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31616170"
+"ListingKey": "29940666"
+"ListingId": "40842058"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-27"
+"OpenHouseStartTime": "2026-06-27T14:00:00Z"
+"OpenHouseEndTime": "2026-06-27T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-24T05:19:14Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31616170')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25251
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31616169"
+"ListingKey": "29940666"
+"ListingId": "40842058"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-28"
+"OpenHouseStartTime": "2026-06-28T14:00:00Z"
+"OpenHouseEndTime": "2026-06-28T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-24T05:19:14Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31616169')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29940666' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.547439 43.4910554)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25326
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25320
+post_id: "1558296"
+post_author: 1
+"ListingKey": "29943405"
+"ListingId": "40842220"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T20:40:39Z"
+"RFModificationTimestamp": "2026-06-23T20:43:36Z"
+"ListPrice": 855000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2760.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1E4"
+"UnparsedAddress": "108 MALLARD Crescent, Waterloo, Ontario N2V1E4"
+"Coordinates": array:2 [
0 => -80.5581303
1 => 43.4956839
]
+"Latitude": 43.4956839
+"Longitude": -80.5581303
+"YearBuilt": 1981
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Proudly positioned on a quiet street surrounded by mature trees on a beautifully landscaped pie-shaped lot, this property offers the kind of privacy and setting that's becoming harder and harder to find. Five cars fit on the newer cement-aggregate driveway, lots of toys fit in the oversized garage, and still there's room to dream bigger. Inside, a spacious foyer with not one, but two coat closets offers a warm welcome. The front living and dining rooms flow together effortlessly, framed by large windows, hardwood floors, and elegant plaster ceilings. The kitchen strikes the perfect balance between beauty and function, featuring stainless steel appliances, quartz countertops, a ceramic tile backsplash, under-mount lighting, and a pantry complete with a coffee bar. Just off the garage, you'll find the laundry room and an updated powder room, but it's the family room that steals the show. Centered around a beautifully updated gas fireplace with a stone feature wall and connected to the sunroom through sliding doors, it's easy to imagine everything from holiday gatherings to quiet evenings spent with family. Upstairs, natural oak hardwood floors continue throughout three generous bedrooms. Two full bathrooms help keep mornings running smoothly while giving everyone room to spread out comfortably. The primary suite offers a walk-in closet, a 3-piece ensuite, and a large wardrobe. Downstairs, the finished lower level is ready for movie nights, hobbies, and all the extras that make family life work a little better. The cold cellar will be perfect for your fall harvest, and the 2-piece bathroom is ready for a future shower, with a rough-in located in the utility room. The furnace (2021), water softener, most windows and doors have been updated, This is the dream property that you have been waiting for. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T20:05:29.899903+00:00"
+"Directions": "FERN/NORTHLAKE"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1878823"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Gazebo"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T19:32:27Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T20:31:46Z"
+"Stories": "2.0"
+"StreetName": "MALLARD"
+"StreetNumber": "108"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "5795"
+"VirtualTourURLUnbranded": "https://youtu.be/iujx2FoTj10"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
0 => array:11 [
"RoomKey" => "1666313397"
"RoomType" => "Utility room"
"ListingId" => "40842220"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "21'0'' x 18'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.36Z"
]
1 => array:11 [
"RoomKey" => "1666313398"
"RoomType" => "Den"
"ListingId" => "40842220"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "16'1'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.36Z"
]
2 => array:11 [
"RoomKey" => "1666313400"
"RoomType" => "Gym"
"ListingId" => "40842220"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "18'5'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.36Z"
]
3 => array:11 [
"RoomKey" => "1666313402"
"RoomType" => "2pc Bathroom"
"ListingId" => "40842220"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "4'7'' x 6'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.36Z"
]
4 => array:11 [
"RoomKey" => "1666313404"
"RoomType" => "Recreation room"
"ListingId" => "40842220"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 22'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.36Z"
]
5 => array:11 [
"RoomKey" => "1666313405"
"RoomType" => "Full bathroom"
"ListingId" => "40842220"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "5'8'' x 7'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.36Z"
]
6 => array:11 [
"RoomKey" => "1666313407"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842220"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.36Z"
]
7 => array:11 [
"RoomKey" => "1666313409"
"RoomType" => "Bedroom"
"ListingId" => "40842220"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 9'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.36Z"
]
8 => array:11 [
"RoomKey" => "1666313410"
"RoomType" => "Bedroom"
"ListingId" => "40842220"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 8'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.36Z"
]
9 => array:11 [
"RoomKey" => "1666313412"
"RoomType" => "5pc Bathroom"
"ListingId" => "40842220"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "7'9'' x 7'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.37Z"
]
10 => array:11 [
"RoomKey" => "1666313413"
"RoomType" => "Laundry room"
"ListingId" => "40842220"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 5'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.37Z"
]
11 => array:11 [
"RoomKey" => "1666313415"
"RoomType" => "2pc Bathroom"
"ListingId" => "40842220"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "3'11'' x 6'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.37Z"
]
12 => array:11 [
"RoomKey" => "1666313419"
"RoomType" => "Sunroom"
"ListingId" => "40842220"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 12'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.37Z"
]
13 => array:11 [
"RoomKey" => "1666313420"
"RoomType" => "Family room"
"ListingId" => "40842220"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "13'1'' x 21'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.37Z"
]
14 => array:11 [
"RoomKey" => "1666313422"
"RoomType" => "Kitchen"
"ListingId" => "40842220"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.37Z"
]
15 => array:11 [
"RoomKey" => "1666313424"
"RoomType" => "Dinette"
"ListingId" => "40842220"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "7'11'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.37Z"
]
16 => array:11 [
"RoomKey" => "1666313425"
"RoomType" => "Dining room"
"ListingId" => "40842220"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.37Z"
]
17 => array:11 [
"RoomKey" => "1666313427"
"RoomType" => "Living room"
"ListingId" => "40842220"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "15'9'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.37Z"
]
18 => array:11 [
"RoomKey" => "1666313428"
"RoomType" => "Foyer"
"ListingId" => "40842220"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 9'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.37Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29943405/108-mallard-crescent-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 43.0
+"AboveGradeFinishedArea": 1943
+"BelowGradeFinishedArea": 817
+"OriginalEntryTimestamp": "2026-06-23T19:32:27.61Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1205262"
+"ListOfficeNationalAssociationId": "1473831"
+"Media": array:39 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29943405_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943405/fac42beeaea9440413ef59baf8f256d4.webp"
"MediaSize" => 161932
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943405/thumbnail-fac42beeaea9440413ef59baf8f256d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842220"
"ResourceRecordKey" => "29943405"
"ModificationTimestamp" => "2026-06-23T19:32:27.62Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29943405_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943405/cdf061dc2e8a9f84eb8cfe51010d5a24.webp"
"MediaSize" => 155457
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943405/thumbnail-cdf061dc2e8a9f84eb8cfe51010d5a24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842220"
"ResourceRecordKey" => "29943405"
"ModificationTimestamp" => "2026-06-23T19:32:27.62Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29943405_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943405/f0d4b331eb1172558965d258b02cd6cf.webp"
"MediaSize" => 121612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943405/thumbnail-f0d4b331eb1172558965d258b02cd6cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842220"
"ResourceRecordKey" => "29943405"
"ModificationTimestamp" => "2026-06-23T19:32:27.62Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29943405_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943405/2b4c25eee8d41357e6c32d50c79f09fe.webp"
"MediaSize" => 75753
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943405/thumbnail-2b4c25eee8d41357e6c32d50c79f09fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842220"
"ResourceRecordKey" => "29943405"
"ModificationTimestamp" => "2026-06-23T19:32:27.62Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29943405_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943405/386bf117d84a4ce1f993a1b75e0575b0.webp"
"MediaSize" => 95722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943405/thumbnail-386bf117d84a4ce1f993a1b75e0575b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842220"
"ResourceRecordKey" => "29943405"
"ModificationTimestamp" => "2026-06-23T19:32:27.62Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29943405_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943405/4b9b523afe9de629f450dbcc73dde0eb.webp"
"MediaSize" => 102161
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943405/thumbnail-4b9b523afe9de629f450dbcc73dde0eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842220"
"ResourceRecordKey" => "29943405"
"ModificationTimestamp" => "2026-06-23T19:32:27.62Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29943405_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943405/c3331109e5671ece59adffdee4871ee8.webp"
"MediaSize" => 98956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943405/thumbnail-c3331109e5671ece59adffdee4871ee8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842220"
"ResourceRecordKey" => "29943405"
"ModificationTimestamp" => "2026-06-23T19:32:27.62Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29943405_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943405/2961105ae92e6b8474af844d298b2290.webp"
"MediaSize" => 79655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943405/thumbnail-2961105ae92e6b8474af844d298b2290.webp"
…7
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29943405')"
+"ID": "1558296"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25322
+post_id: "1557723"
+post_author: 1
+"ListingKey": "29942117"
+"ListingId": "40841769"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T17:41:21Z"
+"RFModificationTimestamp": "2026-06-23T17:49:50Z"
+"ListPrice": 1289000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2857.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1G4"
+"UnparsedAddress": "667 FERN Road, Waterloo, Ontario N2V1G4"
+"Coordinates": array:2 [
0 => -80.5596766
1 => 43.500152
]
+"Latitude": 43.500152
+"Longitude": -80.5596766
+"YearBuilt": 1987
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare opportunity in sought-after Lakeshore North! Set on an impressive 69' x 159' mature, forested lot, this beautifully updated 4 bedroom home offers an incredible backyard oasis with a heated saltwater pool & hot tub surrounded by hardwood forest. The tranquil setting provides exceptional privacy, low maintenance landscaping & the perfect place to spend the summer relaxing, hosting family & friends, BBQing and entertaining. Inside you will find a spacious & functional layout with extensive upgrades! The kitchen is the heart of the home with an incredible 12 foot quartz island, gas stove, double ovens, updated stainless appliances, & a separate granite coffee & wine bar complete with a second sink, wine fridge & more cabinetry. The dining area is open to the cozy family room with engineered hardwood floors, overlooking the backyard with a wood burning fireplace & walkout to the deck. An additional living room provides even more space, open to the kitchen steps from the 2 pc bath and main floor laundry room. Upstairs you will find a primary bedroom with spa-like ensuite bath, 4 large bedrooms and & another renovated 4 piece bath, this is truly a family home! The finished basement offers a huge rec room with gas fireplace, 2 pc bath and spacious workshop for the woodworker or hobbyist. Many updates, including roof (2021), attic and cold cellar insulation (2018), owned water heater (2019), driveway restoration (2024), eavestroughs, soffits and leaf guards (2021), bathrooms (2024/2025). The backyard retreat has been improved with a new pool liner and heater (2024), pool pump (2026), pool cover (2025), hot tub (2024). Exceptional location, waking distance to Northlake Woods PS, nature trails, St Jacobs Farmer's Market, shopping and all amenities plus moments from expressway access. Combining modern updates, timeless character, and a spectacular natural setting, this is your chance to own a move-in-ready home on one of Lakeshore North's most desirable oversized lots. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Hood Fan"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T17:49:42.644745+00:00"
+"Directions": "Northlake Drive to Fern Road"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1909721"
+"ListOfficeKey": "77518"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T17:00:08Z"
+"PhotosCount": 41
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T17:00:08Z"
+"Stories": "2.0"
+"StreetName": "FERN"
+"StreetNumber": "667"
+"StreetSuffix": "Road"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "7439"
+"VirtualTourURLUnbranded": "https://667fern.com/idx"
+"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/29942117/667-fern-road-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2172119"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "77518"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 69.0
+"AboveGradeFinishedArea": 2181
+"BelowGradeFinishedArea": 676
+"OriginalEntryTimestamp": "2026-06-23T16:51:25.46Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1222004"
+"ListOfficeNationalAssociationId": "1186916"
+"CoListAgentNationalAssociationId": "1422636"
+"CoListOfficeNationalAssociationId": "1186916"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29942117')"
+"ID": "1557723"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25319
+post_id: "1556439"
+post_author: 1
+"ListingKey": "29940076"
+"ListingId": "40842185"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T04:55:09Z"
+"RFModificationTimestamp": "2026-06-23T05:10:29Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.258
+"LivingArea": 1856.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4B6"
+"UnparsedAddress": "67 LONGWOOD Drive, Waterloo, Ontario N2L4B6"
+"Coordinates": array:2 [
0 => -80.5383933
1 => 43.4902508
]
+"Latitude": 43.4902508
+"Longitude": -80.5383933
+"YearBuilt": 1967
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "THE CALM OF A WOODED ESCAPE, WITHOUT LEAVING WATERLOO. Set on a mature 0.25 acre lot, this serene split-level home is tucked into one of Waterloo’s most established Lakeshore pockets, offering plenty of space, greenery, and a setting that feels removed from the everyday hustle of the city. Inside, the home has been beautifully cared for and thoughtfully updated, blending mid-century lines, warm wood details, and a nostalgic soul. The main floor welcomes you with a generous foyer and an inviting family room anchored by a wood-burning fireplace, with sliding doors that open to a private rear deck surrounded by nature. A few steps up, the main living area offers bright, well-proportioned living and dining spaces alongside an updated eat-in kitchen that brings modern function to the heart of the home. Upstairs, hardwood flooring adds warmth and continuity throughout the bedroom level. The primary bedroom features its own ensuite, while the updated main bathroom serves the additional bedrooms with style and ease. The lower level adds valuable flexibility with an additional bedroom, three-piece bathroom, workshop space, generous storage, and a separate walk-up to the backyard, creating excellent potential for a guest bedroom, hobby room, a home office, or extended family use. Outdoors, the backyard is a true highlight: private, lower-maintenance naturalized yard, with mature trees and space to relax, host, garden, or simply enjoy the sounds of being outdoors. Updates include: Kitchen (2025), 2nd Floor Bathrooms and Hardwood (2023), Humidifier (2023), AC (2020), Furnace and Water Softener (2017), Shingles (2012), most windows (2006). Located close to parks, trails, everyday shopping, transit, Conestoga Parkway access, both universities, and weekend favourites like Waterloo Park, Conestoga Mall, the St. Jacobs Farmers’ Market, and Uptown Waterloo, this is a lovingly cared for Lakeshore home with character, comfort, and lasting appeal. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Partial"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T05:10:26.729512+00:00"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2091993"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Crushed stone driveway"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.258"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T04:31:43Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T04:49:55Z"
+"Stories": "2.0"
+"StreetName": "LONGWOOD"
+"StreetNumber": "67"
+"StreetSuffix": "Drive"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "5141.81"
+"VirtualTourURLUnbranded": "https://youriguide.com/xd8uc_67_longwood_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/29940076/67-longwood-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 58.0
+"AboveGradeFinishedArea": 1669
+"BelowGradeFinishedArea": 187
+"OriginalEntryTimestamp": "2026-06-23T04:31:43.25Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1364566"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29940076')"
+"ID": "1556439"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25323
+post_id: "1554581"
+post_author: 1
+"ListingKey": "29937664"
+"ListingId": "X13475368"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T18:50:08Z"
+"RFModificationTimestamp": "2026-06-23T18:54:05Z"
+"ListPrice": 369900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3W5"
+"UnparsedAddress": "607 - 280 LESTER STREET, Waterloo, Ontario N2L3W5"
+"Coordinates": array:2 [
0 => -80.535648
1 => 43.475678
]
+"Latitude": 43.475678
+"Longitude": -80.535648
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "LOCATION LOCATION LOCATION!! Granite countertops, centre Island in Kitchen, open concept to living/dining room. Good size bedroom with sliding door leading to balcony. Ensuite Laundry, Stainless Appliances, walking distance to University of Waterloo and Wilfred Laurier University Close to all other ammenities. Make this affordable condo yours today!! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T19:22:08.570145+00:00"
+"Directions": "Cross Streets: University AV & King Street. ** Directions: University Ave & King St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2147194"
+"ListOfficeKey": "283372"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Other"
]
+"PhotosChangeTimestamp": "2026-06-23T18:43:30Z"
+"PhotosCount": 8
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T18:43:30Z"
+"StreetName": "Lester"
+"StreetNumber": "280"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3279.88"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29937664/607-280-lester-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 0
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-22T18:51:16.57Z"
+"ListAgentNationalAssociationId": "1398305"
+"ListOfficeNationalAssociationId": "1328417"
+"Media": array:8 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29937664')"
+"ID": "1554581"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25321
+post_id: "1553031"
+post_author: 1
+"ListingKey": "29934788"
+"ListingId": "40841744"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T17:00:22Z"
+"RFModificationTimestamp": "2026-06-23T17:06:57Z"
+"ListPrice": 369900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 549.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3W5"
+"UnparsedAddress": "280 LESTER Street, Waterloo, Ontario N2L3W5"
+"Coordinates": array:2 [
0 => -80.5362181
1 => 43.4762835
]
+"Latitude": 43.4762835
+"Longitude": -80.5362181
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "LOCATION LOCATION LOCATION!! Granite Countertops, centre Island in kitchen, Open concept to Living/Dining room. Good sized bedroom with sliding door leading to balcony. ensuite Laundry, stainless steel appliances, walking distance to University of Waterloo and Wilfred Laurier Uiversity. Close to all amenities as well. Make this sought after location your home today! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "398.03"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:7 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Water"
4 => "Insurance"
5 => "Parking"
6 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T03:32:44.540860+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1533906"
+"ListOfficeKey": "283362"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-23T16:51:26Z"
+"PhotosCount": 8
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T16:51:26Z"
+"Stories": "1.0"
+"StreetName": "LESTER"
+"StreetNumber": "280"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3279.88"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29934788/280-lester-street-unit-607-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 549
+"OriginalEntryTimestamp": "2026-06-22T01:09:50.95Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1143482"
+"ListOfficeNationalAssociationId": "1328262"
+"Media": array:8 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29934788')"
+"ID": "1553031"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25316
+post_id: "1551024"
+post_author: 1
+"ListingKey": "29932336"
+"ListingId": "X13470220"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T16:25:09Z"
+"RFModificationTimestamp": "2026-06-20T16:29:03Z"
+"ListPrice": 649000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1L2"
+"UnparsedAddress": "142 CORNERBROOK CRESCENT, Waterloo, Ontario N2V1L2"
+"Coordinates": array:2 [
0 => -80.565797
1 => 43.492815
]
+"Latitude": 43.492815
+"Longitude": -80.565797
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "ATTENTION FIRST-TIME HOME BUYERS & INVESTORS Step into modern living with this stunning fully renovated 3-bedroom detached home, linked only by the foundation, offering the perfect combination of luxury, comfort, and value. From the moment you arrive, this beautiful residence is designed to impress.The heart of the home features a chef-inspired kitchen complete with premium quartz countertops, a stylish backsplash, and sleek stainless steel appliances. Elegant 24x24 porcelain tiles flow throughout the main living areas and lead seamlessly to a private backyard retreat - perfect for entertaining family and friends.The professionally finished basement adds even more functionality with an upgraded bathroom and convenient lower-level laundry. Every detail has been thoughtfully updated to provide a move-in-ready experience.Ideally located in a highly sought-after neighborhood with quick access to major highways, the university, schools, shopping, restaurants, parks, and all everyday amenities. A rare opportunity to own a beautifully upgraded home in a prime location. Perfect for first-time buyers, growing families, or savvy investors. Pride of ownership is evident throughout. Don't miss your chance to make this exceptional property your own! (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-20T04:41:37.241885+00:00"
+"Directions": "Northfield Dr. & Westmount Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2141660"
+"ListOfficeKey": "277986"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "33 x 106 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-20T01:47:05Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T16:18:43Z"
+"Stories": "2.0"
+"StreetName": "Cornerbrook"
+"StreetNumber": "142"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3288"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29932336/142-cornerbrook-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 33.0
+"OriginalEntryTimestamp": "2026-06-20T01:47:05.64Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1393502"
+"ListOfficeNationalAssociationId": "1287892"
+"Media": array:1 [
0 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932336')"
+"ID": "1551024"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1548416"
+post_author: 1
+"ListingKey": "29929082"
+"ListingId": "X13467464"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T17:45:04Z"
+"RFModificationTimestamp": "2026-06-19T19:34:23Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4L2"
+"UnparsedAddress": "285 THORNCREST DRIVE, Waterloo, Ontario N2L4L2"
+"Coordinates": array:2 [
0 => -80.5537455
1 => 43.4829243
]
+"Latitude": 43.4829243
+"Longitude": -80.5537455
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Investors dream and ideal family home in a highly sought-after, family-friendly Waterloo neighborhood! Welcome to 285 Thorncrest Drive a spacious side-split situated on a deep lot with tranquil curb appeal and parking for up to 8 vehicles. This versatile home offers 6 bedrooms and 2 full bathrooms, making it perfect for large families, multigenerational living, or investors seeking strong rental income potential. The main level features hardwood flooring, a spacious open-concept living and dining area, and a walkout to the private backyard. A bright and functional kitchen serves as the heart of the home. You'll also find 3 well-sized bedrooms, a 4-piece bathroom, laundry on the main floor, and plenty of natural light throughout. The finished basement with a separate walk-up entrance offers 3 additional Rooms, a cozy living area, a second full bath, dedicated laundry, and a flexible layout that lends itself perfectly to an in-law suite or future legal duplex (buyer to verify with the city).Enjoy a private, fully fenced backyard with mature trees, perfect for outdoor relaxation and entertaining. All of this in a quiet, family-oriented neighborhood close to top-rated schools, the University of Waterloo, Wilfrid Laurier University, Conestoga College, shopping, public transit, and Laurel Creek Conservation Area. Don't miss this unique opportunity to own a turn-key property in one of Waterloos most desirable locations! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Walk-up"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T19:34:14.923364+00:00"
+"Directions": "Canewood cres./thorncrest dr."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Facing"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027523"
+"ListOfficeKey": "283291"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Wooded area"
]
+"LotSizeDimensions": "60 x 111 FT ; 59.98 ft x 111.48 ft x 93.67ft"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T16:59:21Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T16:59:21Z"
+"StreetName": "Thorncrest"
+"StreetNumber": "285"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4685"
+"VirtualTourURLUnbranded": "https://youtu.be/lBZKGuyQ3ig"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Cistern"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29929082/285-thorncrest-drive-waterloo"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2016236"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283291"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 60.0
+"OriginalEntryTimestamp": "2026-06-19T16:59:21.45Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1306909"
+"ListOfficeNationalAssociationId": "1326174"
+"CoListAgentNationalAssociationId": "1297487"
+"CoListOfficeNationalAssociationId": "1326174"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29929082')"
+"ID": "1548416"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25324
+post_id: "1547613"
+post_author: 1
+"ListingKey": "29928209"
+"ListingId": "40840623"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-21T19:40:09Z"
+"RFModificationTimestamp": "2026-06-21T19:44:16Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1408.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4G1"
+"UnparsedAddress": "513 WEBER Street N Unit# B, Waterloo, Ontario N2L4G1"
+"Coordinates": array:2 [
0 => -80.5393879
1 => 43.4918568
]
+"Latitude": 43.4918568
+"Longitude": -80.5393879
+"YearBuilt": 1972
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful condo townhome in an ideal location. This 2 story, one bathroom home features an open concept dining / living room with a sliding glass door to your brick patio and walking trail along the creek and park. The outdoor pool is fantastic for families to cool off in the summer! Upstairs you'll find 2 bedrooms, with a very spacious primary room and a 4 piece bath. The finished basement is great extra space with a rec room and home gym, office or crafts area. The wall split heating/cooling units offer consistent heating and cooling throughout the home plus a cozy gas fireplace in the living room when you want some extra ambiance. Located close to universities, shopping, public transit and the expressway, this is a great opportunity for young families to get into the housing market or for investors looking to add to their portfolio. Call today for a private showing! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "419.79"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:2 [
0 => "Wall unit"
1 => "Ductless"
]
+"CreationDate": "2026-06-19T16:49:27.120667+00:00"
+"Directions": "Turn south off Weber St N"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1993299"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Ravine"
]
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-19T15:32:23Z"
+"PhotosCount": 39
+"PoolFeatures": array:1 [
0 => "Pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-21T19:32:07Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "WEBER"
+"StreetNumber": "513"
+"StreetSuffix": "Street"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "2606.72"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/b_513_weber_st_n_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29928209/513-weber-street-n-unit-b-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 1.0
+"AboveGradeFinishedArea": 1110
+"BelowGradeFinishedArea": 298
+"OriginalEntryTimestamp": "2026-06-19T15:32:23.08Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1276434"
+"ListOfficeNationalAssociationId": "1473831"
+"Media": array:39 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29928209')"
+"ID": "1547613"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25325
+post_id: "1547614"
+post_author: 1
+"ListingKey": "29927265"
+"ListingId": "X13465672"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T13:45:08Z"
+"RFModificationTimestamp": "2026-06-19T16:29:19Z"
+"ListPrice": 449000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K7"
+"UnparsedAddress": "201 - 145 COLUMBIA STREET W, Waterloo, Ontario N2L0K7"
+"Coordinates": array:2 [
0 => -80.538414
1 => 43.476791
]
+"Latitude": 43.476791
+"Longitude": -80.538414
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 145 Society Condos, an exceptional opportunity in the heart of Waterloo's vibrant University District. This beautifully appointed, fully furnished 1+1 bedroom, 1 bathroom suite offers turnkey living for first-time buyers, students, professionals, and savvy investors alike. Perfectly positioned on the same floor as the building's impressive amenity level, this sought-after suite boasts rare 10-foot ceilings-a feature not found in most other units within the building. The added ceiling height creates an airy, open feel while providing unparalleled convenience with premium amenities just steps from your door. Designed for modern living, the sun-filled open-concept layout showcases floor-to-ceiling windows, a sleek contemporary kitchen with Energy Star appliances, granite countertops and backsplash, soft-close cabinetry, custom millwork, and LED lighting throughout. Residents enjoy access to an outstanding collection of amenities, including a state-of-the-art fitness centre, basketball court, sauna, yoga studio, media and games rooms, party lounge, rooftop terrace, 24-hour security, and even an on-site Starbucks. Ideally located directly across from the University of Waterloo and just minutes from Wilfrid Laurier University, Uptown Waterloo, shopping, restaurants, and the ION LRT, this is urban condo living at its finest in one of Waterloo's most desirable locations. (id:62650)"
+"Appliances": array:1 [
0 => "Window Coverings"
]
+"AssociationFee": "275"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T16:29:17.032906+00:00"
+"Directions": "Phillips St & Columbia St W"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2129982"
+"ListOfficeKey": "279541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T13:15:16Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T13:15:16Z"
+"StreetDirSuffix": "West"
+"StreetName": "Columbia"
+"StreetNumber": "145"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3294.2"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29927265/201-145-columbia-street-w-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Craft Property Group"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-19T13:15:16.29Z"
+"ListAgentNationalAssociationId": "1383017"
+"ListOfficeNationalAssociationId": "1305599"
+"Media": array:21 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29927265')"
+"ID": "1547614"
}
]
+success: true
+page_size: 9
+page_count: 19
+count: 167
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]