array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29908944 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1534996"
+post_author: 1
+"ListingKey": "29908944"
+"ListingId": "40839096"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T14:20:09Z"
+"RFModificationTimestamp": "2026-06-16T14:34:59Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1202.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1Z2"
+"UnparsedAddress": "255 NORTHLAKE Drive Unit# 15, Waterloo, Ontario N2V1Z2"
+"Coordinates": array:2 [
0 => -80.55183
1 => 43.4976023
]
+"Latitude": 43.4976023
+"Longitude": -80.55183
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Don't miss this opportunity to own a well-maintained home in Waterloo's desirable North Lakeshore neighbourhood. Location is everything! Just minutes from the LRT, Conestoga Mall, the St. Jacobs Market District, excellent schools, restaurants, grocery stores, parks, trails, and major highways. Walk or bike to almost everything you need. The main floor features a spacious entryway with a double closet, an updated powder room, and a bright white kitchen with newer countertops and sink, open to the dining and living areas. The functional layout offers comfortable everyday living with direct access to the backyard deck, perfect for relaxing or entertaining. With over 1,500 sq. ft. of finished living space, this home offers 3 bedrooms, 1.5 bathrooms, and a fully finished basement complete with a recreation room, laundry area, and rough-in for a future bathroom. Recent updates include modern laminate flooring, interior doors, and hardware. Outside, enjoy a welcoming patio and the convenience of a single carport. Ideal for first-time buyers, families, commuters, or investors looking for a low-maintenance home in a prime Waterloo location. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
]
+"AssociationFee": "500"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T14:34:50.434290+00:00"
+"Directions": "Weber and Golden Eagle"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564276"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:2 [
0 => "Carport"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-16T14:12:31Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T14:12:31Z"
+"Stories": "2.0"
+"StreetName": "NORTHLAKE"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "3036.39"
+"VirtualTourURLUnbranded": "https://youriguide.com/unit_15_255_northlake_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1660459494"
"RoomType" => "Utility room"
"ListingId" => "40839096"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908944"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 18'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T14:10:40.42Z"
]
1 => array:11 [
"RoomKey" => "1660459495"
"RoomType" => "Storage"
"ListingId" => "40839096"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908944"
"RoomLength" => null
"RoomDimensions" => "5'3'' x 3'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T14:10:40.42Z"
]
2 => array:11 [
"RoomKey" => "1660459496"
"RoomType" => "2pc Bathroom"
"ListingId" => "40839096"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908944"
"RoomLength" => null
"RoomDimensions" => "4'9'' x 4'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T14:10:40.42Z"
]
3 => array:11 [
"RoomKey" => "1660459497"
"RoomType" => "Dining room"
"ListingId" => "40839096"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908944"
"RoomLength" => null
"RoomDimensions" => "4'6'' x 14'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T14:10:40.42Z"
]
4 => array:11 [
"RoomKey" => "1660459498"
"RoomType" => "Kitchen"
"ListingId" => "40839096"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908944"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 7'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T14:10:40.42Z"
]
5 => array:11 [
"RoomKey" => "1660459499"
"RoomType" => "Living room"
"ListingId" => "40839096"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29908944"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 18'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T14:10:40.42Z"
]
6 => array:11 [
"RoomKey" => "1660459500"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839096"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908944"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T14:10:40.42Z"
]
7 => array:11 [
"RoomKey" => "1660459501"
"RoomType" => "Bedroom"
"ListingId" => "40839096"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908944"
"RoomLength" => null
"RoomDimensions" => "13'7'' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T14:10:40.42Z"
]
8 => array:11 [
"RoomKey" => "1660459502"
"RoomType" => "Bedroom"
"ListingId" => "40839096"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908944"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T14:10:40.42Z"
]
9 => array:11 [
"RoomKey" => "1660459503"
"RoomType" => "Primary Bedroom"
"ListingId" => "40839096"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29908944"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 15'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T14:10:40.42Z"
]
10 => array:11 [
"RoomKey" => "1660459504"
"RoomType" => "Other"
"ListingId" => "40839096"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908944"
"RoomLength" => null
"RoomDimensions" => "1'11'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T14:10:40.43Z"
]
11 => array:11 [
"RoomKey" => "1660459505"
"RoomType" => "Recreation room"
"ListingId" => "40839096"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29908944"
"RoomLength" => null
"RoomDimensions" => "16'5'' x 18'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-16T14:10:40.43Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29908944/255-northlake-drive-unit-15-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1202
+"OriginalEntryTimestamp": "2026-06-16T14:10:40.39Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1107226"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:40 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29908944_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/c5ab91266fe3c9e14691caa606461a75.webp"
"MediaSize" => 136133
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-c5ab91266fe3c9e14691caa606461a75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:29.03Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29908944_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/cdf0c911ec35e5399dad5ffb1d8a9571.webp"
"MediaSize" => 116471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-cdf0c911ec35e5399dad5ffb1d8a9571.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:29.04Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29908944_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/da649619be04e0de7e865abd9b3faaf6.webp"
"MediaSize" => 56386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-da649619be04e0de7e865abd9b3faaf6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:30.03Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29908944_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/54fea7ebae60bc2c60d4f3d287e996d5.webp"
"MediaSize" => 61202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-54fea7ebae60bc2c60d4f3d287e996d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:29.03Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29908944_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/836f6ac14e2ae9ba79c23eb1b62d5012.webp"
"MediaSize" => 59071
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-836f6ac14e2ae9ba79c23eb1b62d5012.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:30.97Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29908944_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/6eb2af623343e4b9888ef0e2b349a7a4.webp"
"MediaSize" => 57420
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-6eb2af623343e4b9888ef0e2b349a7a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:29.03Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29908944_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/ac9f750bb22c27e6f80d442332040a27.webp"
"MediaSize" => 65924
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-ac9f750bb22c27e6f80d442332040a27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:29.03Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29908944_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/7b5a5b6874a4cfd98b8218fe68722711.webp"
"MediaSize" => 52197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-7b5a5b6874a4cfd98b8218fe68722711.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:29.04Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29908944_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/b3fba8a7e460bba6c33e5922deba20d7.webp"
"MediaSize" => 58664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-b3fba8a7e460bba6c33e5922deba20d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:29.09Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29908944_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/2b7481bd56832e21a78085c4a40de755.webp"
"MediaSize" => 65307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-2b7481bd56832e21a78085c4a40de755.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:29.07Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29908944_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/4f8947243145d536d30d4973ba49e524.webp"
"MediaSize" => 66113
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-4f8947243145d536d30d4973ba49e524.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:30.97Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29908944_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/b7d932bda0e9d69e8991392bbbebe2b4.webp"
"MediaSize" => 29909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-b7d932bda0e9d69e8991392bbbebe2b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:30.97Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29908944_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/321f4baee065671d0436374c4bd04b1b.webp"
"MediaSize" => 51657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-321f4baee065671d0436374c4bd04b1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:29.08Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29908944_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/e8cd040bb5abb072ecb8d44d795bff51.webp"
"MediaSize" => 37271
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-e8cd040bb5abb072ecb8d44d795bff51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:27.96Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29908944_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/cce556bea0c7754c3d6269ffcfa28921.webp"
"MediaSize" => 53432
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-cce556bea0c7754c3d6269ffcfa28921.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:28.03Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29908944_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/f3ee130c491cb9d4ccb6ae660d29a703.webp"
"MediaSize" => 56039
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-f3ee130c491cb9d4ccb6ae660d29a703.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:27.96Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29908944_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/061d84df2b7cb2791cc03cdc4b7ecb03.webp"
"MediaSize" => 55509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-061d84df2b7cb2791cc03cdc4b7ecb03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:29.03Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29908944_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/ec79642e727d02f58298a9129819550b.webp"
"MediaSize" => 53597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-ec79642e727d02f58298a9129819550b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:29.03Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29908944_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/059295a9caa7f3c329cbf17ee263757d.webp"
"MediaSize" => 43797
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-059295a9caa7f3c329cbf17ee263757d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:27.96Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29908944_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/f0269f5480f982f15cff018a5c664fa3.webp"
"MediaSize" => 54287
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-f0269f5480f982f15cff018a5c664fa3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:27.97Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29908944_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/502fc4182969dc7a23f416976f81fa2f.webp"
"MediaSize" => 60807
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-502fc4182969dc7a23f416976f81fa2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:27.99Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29908944_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/3b9879ed0513d0be14f8e7d8efd3dd10.webp"
"MediaSize" => 59338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-3b9879ed0513d0be14f8e7d8efd3dd10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:29.03Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29908944_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/792df4a0e6d919dc95db77ee19d9ad00.webp"
"MediaSize" => 68781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-792df4a0e6d919dc95db77ee19d9ad00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:27.96Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29908944_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/126eea73de1894f8965095cec696666a.webp"
"MediaSize" => 52882
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-126eea73de1894f8965095cec696666a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:29.08Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29908944_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/2655eb14b6bfdb670903fc97a389817d.webp"
"MediaSize" => 58502
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-2655eb14b6bfdb670903fc97a389817d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:27.96Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29908944_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/07c3e2e742b614a9405c7692c1af60dc.webp"
"MediaSize" => 45383
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-07c3e2e742b614a9405c7692c1af60dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:29.05Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29908944_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/1b721d340ea46857b3011a98a00447da.webp"
"MediaSize" => 178422
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-1b721d340ea46857b3011a98a00447da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:28.05Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29908944_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/cfafdf3961cc264edf9fc51859504583.webp"
"MediaSize" => 175331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-cfafdf3961cc264edf9fc51859504583.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:27.96Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29908944_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/86a09535256983afedc554fdc8c0032e.webp"
"MediaSize" => 151139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-86a09535256983afedc554fdc8c0032e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:28.05Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29908944_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/5456b7f664d786b03a4fbd825701a8ff.webp"
"MediaSize" => 163141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-5456b7f664d786b03a4fbd825701a8ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:28.02Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29908944_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/cce582ea21be87e8a074050f778e18b6.webp"
"MediaSize" => 118738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-cce582ea21be87e8a074050f778e18b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:31.58Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29908944_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/cedac73f852450c44cee6a11604aed2c.webp"
"MediaSize" => 140178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-cedac73f852450c44cee6a11604aed2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:29.05Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29908944_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/856ed780410d7cec26654f9c6acbe890.webp"
"MediaSize" => 146376
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-856ed780410d7cec26654f9c6acbe890.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:27.97Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29908944_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/f179489aa68df253fb9758e8d01fb3da.webp"
"MediaSize" => 137744
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-f179489aa68df253fb9758e8d01fb3da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:29.06Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29908944_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/fabb1c0c4dcdeaa0d4f2ef3d08ca7c0f.webp"
"MediaSize" => 141202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-fabb1c0c4dcdeaa0d4f2ef3d08ca7c0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:31.67Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29908944_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/1576959a29efd4fb58103d975a671fcd.webp"
"MediaSize" => 119964
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-1576959a29efd4fb58103d975a671fcd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:28.03Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29908944_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/77e78ffb4d9598c21ec8c4c16c162904.webp"
"MediaSize" => 138355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-77e78ffb4d9598c21ec8c4c16c162904.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:27.96Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29908944_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/20c8db1376f5ca4d59baa1450baf8aa9.webp"
"MediaSize" => 43438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-20c8db1376f5ca4d59baa1450baf8aa9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:28.04Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29908944_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/2f9f42f7d38a968381a3b4470d53fe04.webp"
"MediaSize" => 48434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-2f9f42f7d38a968381a3b4470d53fe04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:31.58Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29908944_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908944/277d80fc05f75a95e94af025731cbe0c.webp"
"MediaSize" => 40327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908944/thumbnail-277d80fc05f75a95e94af025731cbe0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839096"
"ResourceRecordKey" => "29908944"
"ModificationTimestamp" => "2026-06-16T14:12:30.97Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908944')"
+"ID": "1534996"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.26 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 290168" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24776
+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 1564276" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24861
+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 '29908944'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25178
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29908944'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25194
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29908944' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.55183 43.4976023)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25267
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25241
+post_id: "1541891"
+post_author: 1
+"ListingKey": "29919897"
+"ListingId": "X13459364"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T02:10:15Z"
+"RFModificationTimestamp": "2026-06-18T02:20:23Z"
+"ListPrice": 929900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4V8"
+"UnparsedAddress": "535 SPRUCEHILL AVENUE, Waterloo, Ontario N2L4V8"
+"Coordinates": array:2 [
0 => -80.5485904
1 => 43.4901956
]
+"Latitude": 43.4901956
+"Longitude": -80.5485904
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Set well back from the road on a large, private lot in a fantastic neighbourhood, this charming two-storey Cape Cod style home boasts exceptional curb appeal and a peaceful setting. Inside, you will find over 3,000 square feet of finished living space that blends timeless character with thoughtful modern updates. The tastefully updated kitchen perfectly balances style and functionality, featuring quartz countertops, stainless steel appliances, a breakfast bar, and a bright dining area ideal for everyday living. The spacious living room provides a warm and welcoming setting to relax, while the adjoining formal dining space is enhanced by picturesque views of the backyard, creating a beautiful backdrop for entertaining and family gatherings. A full bathroom and convenient access to the backyard complete the main level. Step outside to discover a truly spectacular outdoor retreat. The private, fully fenced backyard is surrounded by mature trees, creating a serene and secluded atmosphere. The large deck offers ample space for dining and relaxing, and comes complete with gas BBQ hookup. You will also find a storage shed (with electricity)! Upstairs, you'll find three generously sized and beautifully appointed bedrooms, two of which include their own dedicated den or sitting areas-perfect for a home office, reading nook, or play space! The recently renovated bathroom provides a spa-like atmosphere with its tranquil design and modern finishes. The fully finished basement adds even more versatile living space, highlighted by a cozy wood-burning fireplace and two spacious areas that can easily serve as a recreation room, home office, fitness area, or whatever suits your lifestyle. For added peace of mind, the home's major mechanical systems-including the furnace, air conditioner, water heater, and water softener-have all been recently updated. Beautifully maintained and thoughtfully updated, this exceptional home is ready to welcome its new owners. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener remote(s)"
7 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T02:20:08.307374+00:00"
+"Directions": "Cross Streets: Parkside Dr. and Cedarbrae Ave. ** Directions: Cedarbrae Ave. to Sprucehill Ave."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2003422"
+"ListOfficeKey": "85457"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "65.1 x 130.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T01:32:36Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T02:03:33Z"
+"Stories": "2.0"
+"StreetName": "Sprucehill"
+"StreetNumber": "535"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "5270.72"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/535-Sprucehill-Ave/idx"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1661741697"
"RoomType" => "Foyer"
"ListingId" => "X13459364"
"RoomLevel" => "Main level"
"RoomWidth" => 2.73
"ListingKey" => "29919897"
"RoomLength" => 1.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.36Z"
]
1 => array:11 [
"RoomKey" => "1661741698"
"RoomType" => "Family room"
"ListingId" => "X13459364"
"RoomLevel" => "Basement"
"RoomWidth" => 4.41
"ListingKey" => "29919897"
"RoomLength" => 7.31
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.36Z"
]
2 => array:11 [
"RoomKey" => "1661741699"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13459364"
"RoomLevel" => "Basement"
"RoomWidth" => 3.35
"ListingKey" => "29919897"
"RoomLength" => 7.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.36Z"
]
3 => array:11 [
"RoomKey" => "1661741700"
"RoomType" => "Kitchen"
"ListingId" => "X13459364"
"RoomLevel" => "Main level"
"RoomWidth" => 3.46
"ListingKey" => "29919897"
"RoomLength" => 5.37
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.36Z"
]
4 => array:11 [
"RoomKey" => "1661741701"
"RoomType" => "Laundry room"
"ListingId" => "X13459364"
"RoomLevel" => "Basement"
"RoomWidth" => 2.72
"ListingKey" => "29919897"
"RoomLength" => 3.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.36Z"
]
5 => array:11 [
"RoomKey" => "1661741702"
"RoomType" => "Eating area"
"ListingId" => "X13459364"
"RoomLevel" => "Main level"
"RoomWidth" => 3.46
"ListingKey" => "29919897"
"RoomLength" => 2.4
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.36Z"
]
6 => array:11 [
"RoomKey" => "1661741703"
"RoomType" => "Living room"
"ListingId" => "X13459364"
"RoomLevel" => "Main level"
"RoomWidth" => 3.77
"ListingKey" => "29919897"
"RoomLength" => 6.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.37Z"
]
7 => array:11 [
"RoomKey" => "1661741704"
"RoomType" => "Dining room"
"ListingId" => "X13459364"
"RoomLevel" => "Main level"
"RoomWidth" => 3.77
"ListingKey" => "29919897"
"RoomLength" => 2.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.37Z"
]
8 => array:11 [
"RoomKey" => "1661741705"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13459364"
"RoomLevel" => "Second level"
"RoomWidth" => 3.49
"ListingKey" => "29919897"
"RoomLength" => 5.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.37Z"
]
9 => array:11 [
"RoomKey" => "1661741706"
"RoomType" => "Den"
"ListingId" => "X13459364"
"RoomLevel" => "Second level"
"RoomWidth" => 4.02
"ListingKey" => "29919897"
"RoomLength" => 5.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.37Z"
]
10 => array:11 [
"RoomKey" => "1661741707"
"RoomType" => "Bedroom"
"ListingId" => "X13459364"
"RoomLevel" => "Second level"
"RoomWidth" => 3.54
"ListingKey" => "29919897"
"RoomLength" => 3.42
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.37Z"
]
11 => array:11 [
"RoomKey" => "1661741708"
"RoomType" => "Bedroom"
"ListingId" => "X13459364"
"RoomLevel" => "Second level"
"RoomWidth" => 4.63
"ListingKey" => "29919897"
"RoomLength" => 2.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.37Z"
]
12 => array:11 [
"RoomKey" => "1661741709"
"RoomType" => "Den"
"ListingId" => "X13459364"
"RoomLevel" => "Second level"
"RoomWidth" => 4.34
"ListingKey" => "29919897"
"RoomLength" => 2.33
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.37Z"
]
]
+"ListAOR": "OnePoint"
+"TaxYear": 2026
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29919897/535-sprucehill-avenue-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 65.1
+"OriginalEntryTimestamp": "2026-06-18T01:32:36.43Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1286265"
+"ListOfficeNationalAssociationId": "1002051"
+"Media": array:45 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29919897_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/6102886661e607c8aae17a5cb8e1b24f.webp"
"MediaSize" => 430061
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-6102886661e607c8aae17a5cb8e1b24f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29919897_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/29f22fb52dca72901026632450ed70c3.webp"
"MediaSize" => 451342
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-29f22fb52dca72901026632450ed70c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29919897_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/ab67dfc1339632d5413e8a8f83616cf3.webp"
"MediaSize" => 413352
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-ab67dfc1339632d5413e8a8f83616cf3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29919897_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/765b7b1ce6d2f9e62ce8e468387be0d9.webp"
"MediaSize" => 332191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-765b7b1ce6d2f9e62ce8e468387be0d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29919897_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/3ab206bc4d39ef479fb9995f86491c89.webp"
"MediaSize" => 161135
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-3ab206bc4d39ef479fb9995f86491c89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29919897_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/7468331d3089afb33430e3404dc77a79.webp"
"MediaSize" => 165228
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-7468331d3089afb33430e3404dc77a79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29919897_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/b5cee3c1825d4cac207822ee5f3f711b.webp"
"MediaSize" => 180734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-b5cee3c1825d4cac207822ee5f3f711b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29919897_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/bc170c5e842e85b7303aa23651519b41.webp"
"MediaSize" => 170774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-bc170c5e842e85b7303aa23651519b41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29919897_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/29c65bea01d9c046805791c7975915aa.webp"
"MediaSize" => 205495
…9
]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919897')"
+"ID": "1541891"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25243
+post_id: "1541612"
+post_author: 1
+"ListingKey": "29919137"
+"ListingId": "X13458766"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T22:25:04Z"
+"RFModificationTimestamp": "2026-06-18T00:00:18Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4J3"
+"UnparsedAddress": "543 GLEN FORREST BOULEVARD, Waterloo, Ontario N2L4J3"
+"Coordinates": array:2 [
0 => -80.55401
1 => 43.486134
]
+"Latitude": 43.486134
+"Longitude": -80.55401
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this detached bungalow in a desirable and tucked-away Waterloo location, offering over 1,800 sq. ft. of finished living space, a huge lot, and incredible potential inside and out. Perfect for first-time buyers, investors, or multi-generational families, this home features a bright main level with 3 bedrooms, 1 full bathroom, and comfortable living and dining areas. The separate entrance to the basement adds excellent flexibility, with 4 additional bedrooms and 2 full bathrooms, making it ideal for extended family use or potential mortgage-helper income. Set on a generous lot with 60 ft. frontage, this property offers parking for up to 4 vehicles in the driveway plus 1 in the garage. The backyard is a major highlight, offering so much potential to create a private outdoor retreat, garden space, patio area, or future entertaining setup. Located in a secluded area of Waterloo while still being close to everyday amenities, shopping, schools, public transportation, Conestoga College, and the University of Waterloo, this home provides both convenience and opportunity. Whether you are looking to move in, invest, or add value over time, this property is full of possibilities. Book your private showing today! * Some photos have been virtually staged. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T00:00:06.866591+00:00"
+"Directions": "Cross Streets: BEARINGER RD / GLEN FORREST BLVD. ** Directions: BEARINGER RD TO GLEN FORREST BLVD."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2182896"
+"ListOfficeKey": "289816"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "60 x 101.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T22:19:46Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T22:19:46Z"
+"Stories": "1.0"
+"StreetName": "GLEN FORREST"
+"StreetNumber": "543"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "4425"
+"VirtualTourURLUnbranded": "https://youriguide.com/0frvu_543_glen_forrest_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29919137/543-glen-forrest-boulevard-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 60.0
+"OriginalEntryTimestamp": "2026-06-17T22:19:46.45Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1432697"
+"ListOfficeNationalAssociationId": "1381521"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919137')"
+"ID": "1541612"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25240
+post_id: "1536562"
+post_author: 1
+"ListingKey": "29912895"
+"ListingId": "X13453290"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T22:05:19Z"
+"RFModificationTimestamp": "2026-06-16T22:19:34Z"
+"ListPrice": 769000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4Y1"
+"UnparsedAddress": "591 DOGWOOD LANE, Waterloo, Ontario N2L4Y1"
+"Coordinates": array:2 [
0 => -80.560828
1 => 43.486633
]
+"Latitude": 43.486633
+"Longitude": -80.560828
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To Dogwood Lane! This Well-Maintained Bungalow Is Situated On A Quiet, Family-Friendly Street And Offers Comfortable Living With Excellent Income Potential. The Bright Living And Dining Areas Feature Hardwood Flooring And Large Windows For Plenty Of Natural Light. The Updated Kitchen Boasts Ceramic Flooring, Quartz Countertops, And A Stylish Backsplash. The Main Floor Includes Three Generously Sized Bedrooms With Parquet Flooring, Closets, And Separate Main Floor Laundry. The Fully Renovated (2022) Basement Features A Separate Entrance, Separate Laundry, Two Bedrooms, Vinyl Flooring, Pot Lights, A Cozy Fireplace, And A Spacious Living Area. The Bathroom Includes Ceramic Flooring, A Modern Vanity, And A Beautiful Clawfoot Soaker Tub. Enjoy A Large, Beautifully Landscaped Backyard Perfect For Entertaining. Recent Updates Include A.C./Heat Pump (Aug 2023), Furnace (Aug 2023), Tankless Water Heater (Aug 2023), Roof Insulation (Aug 2023), Water Purifier (Jun 2023), Water Filter (Jun 2023), And LeafFilter Gutter Protection (Aug 2023). Conveniently Located Close To Hwy 401, Schools, Shopping, Parks, Public Transit, And Within Walking Distance To The University Of Waterloo Campus. Move-In Ready Home Offering Comfort, Convenience, And Versatility. EXTRAS: Separate Entrance To Renovated Basement With Separate Laundry, Tankless Water Heater, Water Purifier, Water Filter, Heat Pump, LeafFilter Gutter Protection, Fireplace In Basement. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Water purifier"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
9 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Separate entrance"
2 => "Walk-up"
3 => "N/A"
4 => "N/A"
5 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T22:19:28.544312+00:00"
+"Directions": "Bearinger Road / Toll Gate/Dogwood Ln"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:4 [
0 => "Hardwood"
1 => "Parquet"
2 => "Ceramic"
3 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2105595"
+"ListOfficeKey": "164016"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "45 x 114 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T21:55:46Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T21:55:46Z"
+"Stories": "1.0"
+"StreetName": "Dogwood"
+"StreetNumber": "591"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "4316"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"View": "View"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …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]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29912895/591-dogwood-lane-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-16T21:55:46.28Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1374868"
+"ListOfficeNationalAssociationId": "1184644"
+"Media": array:38 [
0 => array:13 [ …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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912895')"
+"ID": "1536562"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25263
+post_id: "1536105"
+post_author: 1
+"ListingKey": "29911948"
+"ListingId": "40840389"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T21:40:06Z"
+"RFModificationTimestamp": "2026-06-17T21:44:09Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 2137.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4J3"
+"UnparsedAddress": "543 GLEN FORREST Boulevard, Waterloo, Ontario N2L4J3"
+"Coordinates": array:2 [
0 => -80.5539256
1 => 43.4861133
]
+"Latitude": 43.4861133
+"Longitude": -80.5539256
+"YearBuilt": 1967
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this detached bungalow in a desirable and tucked-away Waterloo location, offering over 1,800 sq. ft. of finished living space, a huge lot, and incredible potential inside and out. Perfect for first-time buyers, investors, or multi-generational families, this home features a bright main level with 3 bedrooms, 1 full bathroom, and comfortable living and dining areas. The separate entrance to the basement adds excellent flexibility, with 4 additional bedrooms and 2 full bathrooms, making it ideal for extended family use or potential mortgage-helper income. Set on a generous lot with 60 ft. frontage, this property offers parking for up to 4 vehicles in the driveway plus 1 in the garage. The backyard is a major highlight, offering so much potential to create a private outdoor retreat, garden space, patio area, or future entertaining setup. Located in a secluded area of Waterloo while still being close to everyday amenities, shopping, schools, public transportation, Conestoga College, and the University of Waterloo, this home provides both convenience and opportunity. Whether you are looking to move in, invest, or add value over time, this property is full of possibilities. Book your private showing today! * Some photos have been virtually staged. (id:62650)"
+"Appliances": array:3 [
0 => "Washer"
1 => "Stove"
2 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T20:34:13.849462+00:00"
+"Directions": "BEARINGER RD TO GLEN FORREST BLVD"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750682"
+"ListOfficeKey": "289792"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T19:50:57Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T21:31:27Z"
+"Stories": "1.0"
+"StreetName": "GLEN FORREST"
+"StreetNumber": "543"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "4425"
+"VirtualTourURLUnbranded": "https://youriguide.com/0frvu_543_glen_forrest_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29911948/543-glen-forrest-boulevard-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2172787"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "156376"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 1108
+"BelowGradeFinishedArea": 1029
+"OriginalEntryTimestamp": "2026-06-16T19:50:55.86Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1164848"
+"ListOfficeNationalAssociationId": "1381240"
+"CoListAgentNationalAssociationId": "1423270"
+"CoListOfficeNationalAssociationId": "1003925"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29911948')"
+"ID": "1536105"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25242
+post_id: "1534435"
+post_author: 1
+"ListingKey": "29909870"
+"ListingId": "X13450512"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:10:11Z"
+"RFModificationTimestamp": "2026-06-16T16:26:29Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4N7"
+"UnparsedAddress": "514 HAVELOCK DRIVE, Waterloo, Ontario N2L4N7"
+"Coordinates": array:2 [
0 => -80.55825
1 => 43.489526
]
+"Latitude": 43.489526
+"Longitude": -80.55825
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 514 Havelock Drive! Nestled in one of Waterloo's most sought-after family-friendly neighbourhoods, this well-maintained 3+1 bedroom, 2-bathroom bungalow offers the perfect combination of comfort, convenience, and future potential. The carpet-free main floor features a bright and functional layout with 3 spacious bedrooms, a full bathroom, a well-appointed kitchen, and inviting living and dining areas ideal for everyday living and entertaining. A separate side entrance provides excellent flexibility and potential for an in-law setup or multi-generational living. The fully finished basement expands your living space with a large rec room, an office or fourth bedroom, a 3-piece bathroom, laundry room, and a bonus workshop-perfect for hobbyists, DIY enthusiasts, or additional storage. Step outside to your own private retreat. The fully fenced backyard oasis is designed for relaxation and entertaining, featuring a spacious deck, storage shed, and a wooden gazebo covering the hot tub-an ideal space to unwind year-round. With parking for up to 5 vehicles, this home is perfectly suited for growing families and busy households. Deck (2023), Water Heater (2023), Washer & Dryer (2024), Roof (2023). Conveniently located just minutes from Highway 7 and Highway 8, as well as Wilfrid Laurier University, University of Waterloo, numerous parks and trails, and Conestoga Mall, this exceptional property offers an unbeatable location close to everything you need. Whether you're a growing family, investor, or buyer seeking multi-generational living potential, 514 Havelock Drive delivers outstanding value in an incredible Waterloo location. Book your private showing today! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T16:26:23.962076+00:00"
+"Directions": "Glen Forest Blvd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2127512"
+"ListOfficeKey": "283918"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Gazebo"
]
+"LotSizeDimensions": "43.1 x 122.2 FT"
+"ParkingFeatures": array:2 [
0 => "Covered"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T15:59:56Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:59:56Z"
+"Stories": "1.0"
+"StreetName": "Havelock"
+"StreetNumber": "514"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3987"
+"VirtualTourURLUnbranded": "https://youriguide.com/wqcfm_514_havelock_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29909870/514-havelock-drive-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 43.1
+"OriginalEntryTimestamp": "2026-06-16T15:59:55.98Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1380753"
+"ListOfficeNationalAssociationId": "1336772"
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909870')"
+"ID": "1534435"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25237
+post_id: "1534290"
+post_author: 1
+"ListingKey": "29909459"
+"ListingId": "40836533"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T15:20:10Z"
+"RFModificationTimestamp": "2026-06-16T15:36:25Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2101.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4N7"
+"UnparsedAddress": "514 HAVELOCK Drive, Waterloo, Ontario N2L4N7"
+"Coordinates": array:2 [
0 => -80.5582589
1 => 43.4895518
]
+"Latitude": 43.4895518
+"Longitude": -80.5582589
+"YearBuilt": 1971
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 514 Havelock Drive! Nestled in one of Waterloo’s most sought-after family-friendly neighbourhoods, this well-maintained 3+1 bedroom, 2-bathroom bungalow offers the perfect combination of comfort, convenience, and future potential. The carpet-free main floor features a bright and functional layout with 3 spacious bedrooms, a full bathroom, a well-appointed kitchen, and inviting living and dining areas ideal for everyday living and entertaining. A separate side entrance provides excellent flexibility and potential for an in-law setup or multi-generational living. The fully finished basement expands your living space with a large rec room, an office or fourth bedroom, a 3-piece bathroom, laundry room, and a bonus workshop—perfect for hobbyists, DIY enthusiasts, or additional storage. Step outside to your own private retreat. The fully fenced backyard oasis is designed for relaxation and entertaining, featuring a spacious deck, storage shed, and a wooden gazebo covering the hot tub—an ideal space to unwind year-round. With parking for up to 5 vehicles, this home is perfectly suited for growing families and busy households. Deck (2023), Water Heater (2023), Washer & Dryer (2024), Roof (2023). Conveniently located just minutes from Highway 7 and Highway 8, as well as Wilfrid Laurier University, University of Waterloo, numerous parks and trails, and Conestoga Mall, this exceptional property offers an unbeatable location close to everything you need. Whether you're a growing family, investor, or buyer seeking multi-generational living potential, 514 Havelock Drive delivers outstanding value in an incredible Waterloo location. Book your private showing today! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T15:36:23.785553+00:00"
+"Directions": "Glen Forest Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750161"
+"ListOfficeKey": "283896"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-06-16T15:13:40Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:13:40Z"
+"Stories": "1.0"
+"StreetName": "HAVELOCK"
+"StreetNumber": "514"
+"StreetSuffix": "Drive"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "3987"
+"VirtualTourURLUnbranded": "https://youriguide.com/wqcfm_514_havelock_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29909459/514-havelock-drive-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 43.0
+"AboveGradeFinishedArea": 1071
+"BelowGradeFinishedArea": 1030
+"OriginalEntryTimestamp": "2026-06-16T15:11:23.62Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1163644"
+"ListOfficeNationalAssociationId": "1349002"
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909459')"
+"ID": "1534290"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1525986"
+post_author: 1
+"ListingKey": "29897607"
+"ListingId": "X13439034"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T15:25:16Z"
+"RFModificationTimestamp": "2026-06-15T15:25:56Z"
+"ListPrice": 779000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4J8"
+"UnparsedAddress": "598 GLEN FORREST BOULEVARD, Waterloo, Ontario N2L4J8"
+"Coordinates": array:2 [
0 => -80.557071
1 => 43.48873
]
+"Latitude": 43.48873
+"Longitude": -80.557071
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Opportunity knocks at 598 Glen Forrest Boulevard! This spacious bungalow is very deceiving from the street! offers a versatile floor plan with 4 bedrooms on the main floor and 2 additional bedrooms in the finished lower level. The home is equipped with 2 kitchens, 2 bathrooms, and a fully separate entrance. The home is ideally suited for multi-generational living, an in-law setup, or potential income-generating possibilities. Numerous upgrades have been completed throughout the years, making this property move-in ready while still offering future potential. Enjoy a double driveway and garage for ample parking. A fantastic location close to top-rated schools, parks, shopping, transit, and Waterloo's renowned universities. 5 minutes from the future home of the new waterloo regional hospital. Quick possession available for buyers looking to make their move without delay. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T00:11:02.146610+00:00"
+"Directions": "Cross Streets: Weber St. ** Directions: Northfield to Weber St S to Glen Forrest Blvd."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2143277"
+"ListOfficeKey": "284147"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "65.6 x 114.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T15:18:48Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T15:18:48Z"
+"Stories": "1.0"
+"StreetName": "Glen Forrest"
+"StreetNumber": "598"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "5227.74"
+"VirtualTourURLUnbranded": "https://youriguide.com/598_glen_forrest_boulevard_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29897607/598-glen-forrest-boulevard-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 65.7
+"OriginalEntryTimestamp": "2026-06-12T19:50:44.02Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1406869"
+"ListOfficeNationalAssociationId": "1338998"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29897607')"
+"ID": "1525986"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25265
+post_id: "1525430"
+post_author: 1
+"ListingKey": "29898163"
+"ListingId": "40839188"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T00:30:11Z"
+"RFModificationTimestamp": "2026-06-18T00:41:47Z"
+"ListPrice": 830000.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.5383668
1 => 43.4902744
]
+"Latitude": 43.4902744
+"Longitude": -80.5383668
+"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 a 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 room, 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, treed, and spacious, with room to relax, host, garden, or simply enjoy the sounds of being outdoors. 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:62650)"
+"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-12T21:40:10.236473+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-12T21:11:39Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T00:21:01Z"
+"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/29898163/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-12T21:10:25.59Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1364566"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898163')"
+"ID": "1525430"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25266
+post_id: "1524761"
+post_author: 1
+"ListingKey": "29895419"
+"ListingId": "40834178"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T14:00:07Z"
+"RFModificationTimestamp": "2026-06-15T14:01:15Z"
+"ListPrice": 779000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 2733.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4J8"
+"UnparsedAddress": "598 GLEN FORREST Boulevard, Waterloo, Ontario N2L4J8"
+"Coordinates": array:2 [
0 => -80.5570508
1 => 43.4888424
]
+"Latitude": 43.4888424
+"Longitude": -80.5570508
+"YearBuilt": 1971
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Opportunity knocks at 598 Glen Forrest Boulevard! This spacious bungalow is very deceiving from the street! offers a versatile floor plan with 4 bedrooms on the main floor and 2 additional bedrooms in the finished lower level. The home is equipped with 2 kitchens, 2 bathrooms, and a fully separate entrance. The home is ideally suited for multi-generational living, an in-law setup, or potential income-generating possibilities. Numerous upgrades have been completed throughout the years, making this property move-in ready while still offering future potential. Enjoy a double driveway and garage for ample parking. A fantastic location close to top-rated schools, parks, shopping, transit, and Waterloo's renowned universities. 5 minutes from the future home of the new Waterloo Regional Hospital. Quick possession available for buyers looking to make their move without delay. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T16:27:21.155206+00:00"
+"Directions": "Northfield to Weber St S to Glen Forrest Blvd"
+"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": "1876463"
+"ListOfficeKey": "289890"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T15:52:46Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T13:51:27Z"
+"Stories": "1.0"
+"StreetName": "GLEN FORREST"
+"StreetNumber": "598"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "5227.74"
+"VirtualTourURLUnbranded": "https://youriguide.com/598_glen_forrest_boulevard_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29895419/598-glen-forrest-boulevard-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "S1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 66.0
+"AboveGradeFinishedArea": 1231
+"BelowGradeFinishedArea": 1502
+"OriginalEntryTimestamp": "2026-06-12T15:52:45.97Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1204368"
+"ListOfficeNationalAssociationId": "1382470"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895419')"
+"ID": "1524761"
}
]
+success: true
+page_size: 9
+page_count: 9
+count: 73
+after_key: ""
}
"RF Response Time" => "0.19 seconds"
]
]