array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29894120 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1523441"
+post_author: 1
+"ListingKey": "29894120"
+"ListingId": "40838919"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T23:40:06Z"
+"RFModificationTimestamp": "2026-06-29T23:41:37Z"
+"ListPrice": 349000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 584.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H2"
+"UnparsedAddress": "243 NORTHFIELD Drive E Unit# 408, Waterloo, Ontario N2K0H2"
+"Coordinates": array:2 [
0 => -80.5218062
1 => 43.510191
]
+"Latitude": 43.510191
+"Longitude": -80.5218062
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Blackstone Condominiums, where modern design meets convenient Waterloo living. This owner-occupied, carpet-free one-bedroom suite has been beautifully maintained and thoughtfully upgraded throughout. The bright open-concept layout overlooks the peaceful courtyard and features a stylish kitchen with upgraded cabinetry, quartz countertops, stainless steel appliances, subway tile backsplash, custom island, and modern pot lighting. Additional highlights include a spacious four-piece bathroom, in-suite laundry, custom remote-controlled blinds, and an owned underground parking space. Residents enjoy exceptional amenities including a fitness center, co-working lounge, party room, rooftop terrace, bike storage, pet wash station, and landscaped outdoor spaces. High-speed Internet is included in the condo fees. Ideally located steps from Brown's Social House, shopping, restaurants, and everyday amenities, with easy access to Conestoga Mall, the ION LRT, RIM Park, Grey Silo Golf Club, St. Jacobs, and Waterloo's universities and colleges. A fantastic opportunity for first-time buyers, professionals or investors seeking a move-in-ready home in one of Waterloo's most desirable communities. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"AssociationFee": "480"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T14:37:36.573103+00:00"
+"Directions": "Corner of Northfield Dr E & Bridge Street"
+"ExteriorFeatures": array:1 [
0 => "Steel"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2043154"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Open"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-12T12:50:34Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T23:32:44Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "243"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3122.33"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1671556606"
"RoomType" => "4pc Bathroom"
"ListingId" => "40838919"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894120"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T23:32:44.92Z"
]
1 => array:11 [
"RoomKey" => "1671556607"
"RoomType" => "Porch"
"ListingId" => "40838919"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894120"
"RoomLength" => null
"RoomDimensions" => "6'2'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T23:32:44.92Z"
]
2 => array:11 [
"RoomKey" => "1671556608"
"RoomType" => "Living room"
"ListingId" => "40838919"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894120"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 12'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T23:32:44.92Z"
]
3 => array:11 [
"RoomKey" => "1671556609"
"RoomType" => "Kitchen"
"ListingId" => "40838919"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894120"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T23:32:44.92Z"
]
4 => array:11 [
"RoomKey" => "1671556610"
"RoomType" => "Primary Bedroom"
"ListingId" => "40838919"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894120"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T23:32:44.93Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29894120/243-northfield-drive-e-unit-408-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "r1"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 584
+"OriginalEntryTimestamp": "2026-06-12T12:50:34.28Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1318898"
+"ListOfficeNationalAssociationId": "1004370"
+"Media": array:35 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29894120_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/3cab0f3ae2eb74be494bb5c6ab2a7d93.webp"
"MediaSize" => 81855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-3cab0f3ae2eb74be494bb5c6ab2a7d93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29894120_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/6c5a3c51af28d7101d7188c77ebeaa22.webp"
"MediaSize" => 92533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-6c5a3c51af28d7101d7188c77ebeaa22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29894120_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/de00fb607b145ed123c4c69ce298933e.webp"
"MediaSize" => 130915
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-de00fb607b145ed123c4c69ce298933e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29894120_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/b96c20345acd803ca2bb328d639af1f0.webp"
"MediaSize" => 108018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-b96c20345acd803ca2bb328d639af1f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29894120_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/366939b20d028ec4e25cd9c370036d2f.webp"
"MediaSize" => 66640
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-366939b20d028ec4e25cd9c370036d2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29894120_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/8ab908e1b940cfd90aaefd1417665fb3.webp"
"MediaSize" => 39074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-8ab908e1b940cfd90aaefd1417665fb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29894120_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/63c565ded73e246ce30e738c15fbebc9.webp"
"MediaSize" => 60666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-63c565ded73e246ce30e738c15fbebc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring stainless steel appliances, white cabinetry, a subway tile backsplash, and a dark-toned island with seating"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29894120_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/b96432cf351b0e9b4c815509ed37c33a.webp"
"MediaSize" => 62020
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-b96432cf351b0e9b4c815509ed37c33a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29894120_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/052c22b263ba27c8b0f67994ca349bef.webp"
"MediaSize" => 68903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-052c22b263ba27c8b0f67994ca349bef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29894120_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/bb6fd38af34148d64a863d38ef7f40be.webp"
"MediaSize" => 64567
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-bb6fd38af34148d64a863d38ef7f40be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29894120_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/c1b0bf18e908b94051d88227152d30b8.webp"
"MediaSize" => 62209
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-c1b0bf18e908b94051d88227152d30b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29894120_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/981e914122e442fb8b0ebb8ea1df033e.webp"
"MediaSize" => 61545
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-981e914122e442fb8b0ebb8ea1df033e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29894120_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/8f1a250c024793dd955fd362a018ec1c.webp"
"MediaSize" => 67862
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-8f1a250c024793dd955fd362a018ec1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29894120_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/d4e5e142f00fd53c2100022f04b2da67.webp"
"MediaSize" => 64798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-d4e5e142f00fd53c2100022f04b2da67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29894120_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/8303cef09715a4c232a8b4f4bb1432e3.webp"
"MediaSize" => 86289
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-8303cef09715a4c232a8b4f4bb1432e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29894120_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/2e6ef8f44f4bb6a08be67c551a1ced62.webp"
"MediaSize" => 73618
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-2e6ef8f44f4bb6a08be67c551a1ced62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29894120_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/7de5b222d660361ad76fcb70e6913ec7.webp"
"MediaSize" => 45614
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-7de5b222d660361ad76fcb70e6913ec7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29894120_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/a0923ccb8404e1461e38dc560628d852.webp"
"MediaSize" => 62042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-a0923ccb8404e1461e38dc560628d852.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29894120_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/56e4a91a46c3f92888212abec69efa90.webp"
"MediaSize" => 55624
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-56e4a91a46c3f92888212abec69efa90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29894120_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/d765006b0fdab153058b77e8f4e71028.webp"
"MediaSize" => 33828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-d765006b0fdab153058b77e8f4e71028.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29894120_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/3d3d600db8723ea34ec4ca73fc6b0fdf.webp"
"MediaSize" => 56960
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-3d3d600db8723ea34ec4ca73fc6b0fdf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29894120_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/f05e2b353e204d3bdac11d6e2ffbfb0f.webp"
"MediaSize" => 51356
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-f05e2b353e204d3bdac11d6e2ffbfb0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29894120_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/6efeae0bd534f9c5d9040bc9283205c1.webp"
"MediaSize" => 42237
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-6efeae0bd534f9c5d9040bc9283205c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29894120_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/4f0bda9789e105ff0b5a3376e3f428d6.webp"
"MediaSize" => 101192
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-4f0bda9789e105ff0b5a3376e3f428d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29894120_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/d547b2fbc94b17ebf4e61914561fd398.webp"
"MediaSize" => 93338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-d547b2fbc94b17ebf4e61914561fd398.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29894120_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/f9fe1ce4c29727f4d45ed23bd56aaa1c.webp"
"MediaSize" => 81770
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-f9fe1ce4c29727f4d45ed23bd56aaa1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29894120_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/1ea7e394c2d46fde5389743d54899f7c.webp"
"MediaSize" => 134601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-1ea7e394c2d46fde5389743d54899f7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29894120_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/1a08a8b3ebe99e782a661ec2d3f95ef7.webp"
"MediaSize" => 124221
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-1a08a8b3ebe99e782a661ec2d3f95ef7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29894120_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/5fa1708ed84ffca1e15bf49d88bfb64b.webp"
"MediaSize" => 107410
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-5fa1708ed84ffca1e15bf49d88bfb64b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29894120_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/ab1808b2608f17ee42d4f11f12a5b9dd.webp"
"MediaSize" => 112091
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-ab1808b2608f17ee42d4f11f12a5b9dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29894120_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/12295f7e3d7e1fc41a10246562dc7fe6.webp"
"MediaSize" => 133852
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-12295f7e3d7e1fc41a10246562dc7fe6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29894120_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/354c74ac3365f182aa4e7e15715b50a5.webp"
"MediaSize" => 161975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-354c74ac3365f182aa4e7e15715b50a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29894120_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/2cd45dfcb2ecb9398297fdbedfa56741.webp"
"MediaSize" => 122254
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-2cd45dfcb2ecb9398297fdbedfa56741.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29894120_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/ab5f641f7fbe3f1947537021b5810cce.webp"
"MediaSize" => 121778
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-ab5f641f7fbe3f1947537021b5810cce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29894120_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894120/1292fff33dbfb9c17c2e0ce26c352cd1.webp"
"MediaSize" => 111413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894120/thumbnail-1292fff33dbfb9c17c2e0ce26c352cd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838919"
"ResourceRecordKey" => "29894120"
"ModificationTimestamp" => "2026-06-12T12:50:34.29Z"
]
]
+"DaysOnMarket": 18
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29894120')"
+"ID": "1523441"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 76807" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24891
+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 2043154" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24849
+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 '29894120'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25241
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29894120'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25257
+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 '29894120' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5218062 43.510191)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25310
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25304
+post_id: "1574855"
+post_author: 1
+"ListingKey": "29964583"
+"ListingId": "40843675"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T03:45:02Z"
+"RFModificationTimestamp": "2026-06-30T03:49:17Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2615.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4M2"
+"UnparsedAddress": "729 GRAND BANKS Drive, Waterloo, Ontario N2K4M2"
+"Coordinates": array:2 [
0 => -80.4982397
1 => 43.5124183
]
+"Latitude": 43.5124183
+"Longitude": -80.4982397
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautiful family home in the highly desirable Eastbridge neighbourhood! Featuring a bright open-concept layout, this well-maintained home offers a grand two-storey foyer, spacious Great Room with maple hardwood flooring, California shutters, and a walkout to the deck with stunning seasonal views of the Grand River. The kitchen boasts abundant cabinetry, a breakfast bar, and updated appliances. Upstairs, the spacious primary bedroom features a walk-in closet, an elegant 9'4 tray ceiling, and a private ensuite. The finished walkout basement provides additional living space, direct access to a large stone patio, and a rough-in for a future bathroom. The fully fenced backyard is perfect for family enjoyment and entertaining. Recent updates include roof (2021), driveway resurfacing (2023), patio and deck improvements (2024), bathroom updates (2025), washer (2022), kitchen appliances (2019), and owned water softener. Ideally located within walking distance to top-rated schools and close to RIM Park, shopping, trails, transit, and the Expressway. A fantastic opportunity to own a move-in-ready home in one of Waterloo's most sought-after family communities! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T06:20:09.218915+00:00"
+"Directions": "TAKE UNIVERSITY AVE EAST; TURN LEFT ON TO NEW BEDFORD DR; THEN TURN RIGHT ON TO GRAND BANKS DR."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955745"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-30T03:39:21Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T03:39:21Z"
+"Stories": "2.0"
+"StreetName": "GRAND BANKS"
+"StreetNumber": "729"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "5946"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1671689606"
"RoomType" => "Utility room"
"ListingId" => "40843675"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.14Z"
]
1 => array:11 [
"RoomKey" => "1671689607"
"RoomType" => "Cold room"
"ListingId" => "40843675"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.15Z"
]
2 => array:11 [
"RoomKey" => "1671689608"
"RoomType" => "Laundry room"
"ListingId" => "40843675"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "7'11'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.15Z"
]
3 => array:11 [
"RoomKey" => "1671689609"
"RoomType" => "Recreation room"
"ListingId" => "40843675"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "13'11'' x 23'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.15Z"
]
4 => array:11 [
"RoomKey" => "1671689610"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843675"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.15Z"
]
5 => array:11 [
"RoomKey" => "1671689611"
"RoomType" => "Bedroom"
"ListingId" => "40843675"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.15Z"
]
6 => array:11 [
"RoomKey" => "1671689612"
"RoomType" => "Bedroom"
"ListingId" => "40843675"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 14'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.15Z"
]
7 => array:11 [
"RoomKey" => "1671689613"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843675"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.15Z"
]
8 => array:11 [
"RoomKey" => "1671689614"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843675"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "14'8'' x 17'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.16Z"
]
9 => array:11 [
"RoomKey" => "1671689615"
"RoomType" => "2pc Bathroom"
"ListingId" => "40843675"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.16Z"
]
10 => array:11 [
"RoomKey" => "1671689616"
"RoomType" => "Kitchen"
"ListingId" => "40843675"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "12'3'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.16Z"
]
11 => array:11 [
"RoomKey" => "1671689617"
"RoomType" => "Dining room"
"ListingId" => "40843675"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.16Z"
]
12 => array:11 [
"RoomKey" => "1671689618"
"RoomType" => "Great room"
"ListingId" => "40843675"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "14'9'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.16Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29964583/729-grand-banks-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1825
+"BelowGradeFinishedArea": 790
+"OriginalEntryTimestamp": "2026-06-29T05:59:41.08Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1247419"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:38 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29964583_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/2d983f4577119a075d858eaaeb7afa3a.webp"
"MediaSize" => 117065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-2d983f4577119a075d858eaaeb7afa3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring light-colored siding and a brown shingle roof"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.2Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29964583_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/8158296ffdd392857a8e057793bd6eb4.webp"
"MediaSize" => 126454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-8158296ffdd392857a8e057793bd6eb4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story home featuring light-colored siding, a prominent front garage with a panel design, and brick accents"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.18Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29964583_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/b035cc6d05ca57a9d6d5b3c4a83ccd6e.webp"
"MediaSize" => 119519
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-b035cc6d05ca57a9d6d5b3c4a83ccd6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story detached residence featuring light-colored siding and brick accents"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.22Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29964583_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/c334977cdef17d9d6ccff4d93b3061e2.webp"
"MediaSize" => 74541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-c334977cdef17d9d6ccff4d93b3061e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring light-toned siding, a prominent front gable, and an arched window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.19Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29964583_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/19ea2b14561a92face62f1a6f7fce7ce.webp"
"MediaSize" => 59009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-19ea2b14561a92face62f1a6f7fce7ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary two-story residence with a light-colored facade, featuring an attached two-car garage with a brown door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:56.81Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29964583_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/d2539857c00ff1c9f20a30b402db8066.webp"
"MediaSize" => 56936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-d2539857c00ff1c9f20a30b402db8066.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring light-toned siding and brick accents"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.19Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29964583_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/e315bd514d854b14d5ad135288368a53.webp"
"MediaSize" => 37762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-e315bd514d854b14d5ad135288368a53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front entry with a dark-paneled door and storm door, accented by dual sconce lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.19Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29964583_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/2f595db2c259465988671b745424edbc.webp"
"MediaSize" => 77494
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-2f595db2c259465988671b745424edbc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Image quality insufficient for description"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.18Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29964583_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/244092c5b8b79a63e91e27bf1a83437f.webp"
"MediaSize" => 70712
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-244092c5b8b79a63e91e27bf1a83437f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Foyer featuring wood-finish flooring, a white paneled entry door with brushed nickel hardware, and a carpeted staircase with white balusters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:56.7Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29964583_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/43a8a6ec3fb349820a41023581e149cf.webp"
"MediaSize" => 97695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-43a8a6ec3fb349820a41023581e149cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring light wood-finish flooring, a white paneled front door with sidelight window, and a flush-mount ceiling light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.18Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29964583_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/f83b56fd134ceb97b6154b581b73bb71.webp"
"MediaSize" => 79997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-f83b56fd134ceb97b6154b581b73bb71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a paneled main door with a frosted sidelight, wood-finish flooring, a carpeted staircase with white balusters, and a high ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.18Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29964583_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/3ed08ac0be9f871b6ea6b2d410153d1d.webp"
"MediaSize" => 59677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-3ed08ac0be9f871b6ea6b2d410153d1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with paneling, a white countertop, a mirror, and a window with wood-finish blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.19Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29964583_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/f43cc77c917c3b02176578bdc59fc1f1.webp"
"MediaSize" => 61820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-f43cc77c917c3b02176578bdc59fc1f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright living space featuring natural light from multiple windows with wooden shutters, light wood-finish flooring, and a white ceiling with a flush-mount light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.21Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29964583_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/7555d16acaaed6465fdcc98a367ce21b.webp"
"MediaSize" => 72952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-7555d16acaaed6465fdcc98a367ce21b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring light wood-finish flooring, multiple windows with wooden louvered shutters, and a prominent built-in ceiling light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.18Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29964583_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/c0e943d3689532f28e1860c3cbae7d5b.webp"
"MediaSize" => 60216
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-c0e943d3689532f28e1860c3cbae7d5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring wood-finish flooring, light-toned walls, and a window with natural wood shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:56.81Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29964583_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/3d3a4f3a835a637eb797fcb118ffc1b7.webp"
"MediaSize" => 56786
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-3d3a4f3a835a637eb797fcb118ffc1b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring light wood-finish flooring, light-toned walls, a glass-paned door, and a large window with wooden louvered shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:56.7Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29964583_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/d6b3d1786499b1e286aff31ddb3998ed.webp"
"MediaSize" => 52765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-d6b3d1786499b1e286aff31ddb3998ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Interior space featuring light wood-finish flooring and a white ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.19Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29964583_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/1e1d1a1137bf91107287648c8ef1b9a3.webp"
"MediaSize" => 70373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-1e1d1a1137bf91107287648c8ef1b9a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring, a dining area with a chandelier, and a kitchen with white cabinetry"
…4
]
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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964583')"
+"ID": "1574855"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25306
+post_id: "1574152"
+post_author: 1
+"ListingKey": "29963525"
+"ListingId": "40843481"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T00:30:35Z"
+"RFModificationTimestamp": "2026-06-28T01:33:44Z"
+"ListPrice": 354990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 582.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G5"
+"UnparsedAddress": "255 NORTHFIELD Drive Unit# 308, Waterloo, Ontario N2K0G5"
+"Coordinates": array:2 [
0 => -80.5213765
1 => 43.5107332
]
+"Latitude": 43.5107332
+"Longitude": -80.5213765
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning 1-bedroom plus den, 1-bath condo offering the perfect blend of style, comfort, and low-maintenance living in one of the area's most sought-after neighbourhoods. This beautifully appointed unit features high-end finishes, abundant natural light, a primary bedroom complete with a walk-in closet and ensuite access, convenient in-suite laundry, one underground parking space, and a private locker. The versatile den is ideal for a home office. Enjoy an impressive selection of building amenities, including a fitness centre, event room, rooftop terrace with BBQ area and beautiful views, bike storage, and even a dog washing station. The well-maintained building also offers keyless entry. Perfectly situated just minutes from restaurants, shopping, theatres, the community centre, and the renowned St. Jacobs Farmers' Market. Outdoor enthusiasts will appreciate the nearby Walter Bean Trail, Grand River, RIM Park, and Grey Silo Golf Course. Conveniently located close to two universities with quick access to Highways 85 and 401, making commuting a breeze. This exceptional condo truly has it all—don't miss your opportunity to make it yours. Book your private showing today! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"AssociationFee": "493"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-28T01:33:38.248335+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564233"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-28T00:20:47Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T00:20:47Z"
+"Stories": "3.0"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3137.65"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29963525/255-northfield-drive-unit-308-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 582
+"OriginalEntryTimestamp": "2026-06-28T00:20:47.64Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070035"
+"ListOfficeNationalAssociationId": "1324759"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29963525')"
+"ID": "1574152"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25303
+post_id: "1572262"
+post_author: 1
+"ListingKey": "29961016"
+"ListingId": "40843507"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-27T20:25:21Z"
+"RFModificationTimestamp": "2026-06-27T20:29:58Z"
+"ListPrice": 1630000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 4544.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3H9"
+"UnparsedAddress": "250 GREY SQUIRREL Place, Waterloo, Ontario N2K3H9"
+"Coordinates": array:2 [
0 => -80.5202288
1 => 43.5085201
]
+"Latitude": 43.5085201
+"Longitude": -80.5202288
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover exceptional family living at 250 Grey Squirrel Place, a beautifully maintained home nestled on a quiet crescent in Waterloo's sought-after Colonial Acres. Situated on a rare double-sized lot, this impressive property offers an outstanding blend of space, comfort, and privacy in one of the city's most established neighbourhoods. Step inside to an inviting interior highlighted by soaring 14-foot ceilings in the front living room, rich hardwood flooring, and a charming wood-burning fireplace. A second fireplace anchors the spacious family room, providing the perfect setting for relaxed evenings, while a dedicated main-floor office offers a quiet space for working from home. Everyday convenience is enhanced by the functional mudroom and laundry area with direct access from the double-car garage. At the heart of the home, the well-appointed kitchen features granite countertops, a Bosch stove, Miele appliances, and a walkout to the newly completed tiered wood deck (2025). The expansive backyard is a true standout, offering a sports court, mature landscaping, Honeycrisp apple trees, a peach tree, and ample room for entertaining, gardening, or family recreation. The upper level features four spacious bedrooms, including a private primary retreat with its own ensuite bath, as well as a second full bathroom to accommodate family and guests. The fully finished basement adds incredible versatility with two additional bedrooms, a three-piece bathroom, and a large recreation area ideal for movie nights, games, or multi-generational living. Surrounded by mature trees and enhanced by an interlock driveway, this home delivers both curb appeal and lasting quality. Ideally positioned just minutes from Uptown Waterloo, the University of Waterloo, Waterloo Park, RIM Park, Grey Silo Golf Course, and The Boardwalk, this exceptional property offers the perfect balance of peaceful family living and convenient access to the region's top amenities. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Hood Fan"
8 => "Garage door opener"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T22:36:56.385277+00:00"
+"Directions": "Deer Run Dr to Grey Squirrel Pl"
+"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": "2152269"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T21:50:05Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-27T20:19:50Z"
+"Stories": "2.0"
+"StreetName": "GREY SQUIRREL"
+"StreetNumber": "250"
+"StreetSuffix": "Place"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "9353.85"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:22 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29961016/250-grey-squirrel-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 114.0
+"AboveGradeFinishedArea": 2883
+"BelowGradeFinishedArea": 1661
+"OriginalEntryTimestamp": "2026-06-26T21:50:05.68Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1403932"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29961016')"
+"ID": "1572262"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25307
+post_id: "1538217"
+post_author: 1
+"ListingKey": "29914406"
+"ListingId": "X13454334"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T16:35:07Z"
+"RFModificationTimestamp": "2026-06-29T16:47:50Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H2"
+"UnparsedAddress": "405 - 243 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.522255
1 => 43.509258
]
+"Latitude": 43.509258
+"Longitude": -80.522255
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Blackstone Condominiums in Waterloo! This modern, carpet-free 2-bedroom, 2-bathroom suite offers stylish finishes throughout, including custom cabinetry, quartz countertops, backsplash, in-suite laundry, and a spacious storage room. Enjoy exceptional building amenities including a fitness centre, co-working lounge, party room, rooftop terrace, bike storage, pet wash station, and landscaped outdoor spaces. High-speed internet is included in the condo fees. Conveniently located steps from Brown's Socialhouse, shopping, restaurants, and transit, with easy access to Conestoga Mall, ION LRT, RIM Park, Grey Silo Golf Club, St. Jacobs, universities, and colleges. A fantastic opportunity to own in one of Waterloo's most desirable communities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
]
+"AssociationFee": "633"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T13:47:22.400606+00:00"
+"Directions": "Cross Streets: Northfield/bridge st w. ** Directions: on northfield dr e."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2249954"
+"ListOfficeKey": "292962"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T12:16:42Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T16:29:14Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "243"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3685"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/405_243_northfield_dr_e_waterloo_on"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29914406/405-243-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Five Rivers Property Mgmt"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-17T12:16:42.75Z"
+"ListAgentNationalAssociationId": "1488846"
+"ListOfficeNationalAssociationId": "1420223"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 14
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914406')"
+"ID": "1538217"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25305
+post_id: "1525405"
+post_author: 1
+"ListingKey": "29898015"
+"ListingId": "40839057"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T21:00:26Z"
+"RFModificationTimestamp": "2026-06-12T21:28:05Z"
+"ListPrice": 865000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2140.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4B2"
+"UnparsedAddress": "180 OLD ABBEY Road Unit# 14, Waterloo, Ontario N2K4B2"
+"Coordinates": array:2 [
0 => -80.5259326
1 => 43.5008878
]
+"Latitude": 43.5008878
+"Longitude": -80.5259326
+"YearBuilt": 1998
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "WELCOME TO YOUR NEW HOME! Located in the best location in the hidden enclave of Abbey Woods, this bungalow townhome unit is the one you've been waiting for. Backing onto the greenspace, double car garage, finished basement and updates galore. As you enter you'll walk the enginerred hardwood floors right into the open concept main floor with The great room holds room for your living area, dining area, and large kitchen. The kitchen has been updated with newer countertops, sink and taps .All with large bright windows, pot lights, and a gas fireplace. The convenient patio doors go out to the greenspace and large deck with awning. The primary suite offers double closets, and updated 3 piece ensuite with a newer shower, newer counters, sink, taps, and lights. Rounding up the main floor is laundry and an updated extra 3 piece bathroom as well as a second bedroom or office. The space continues downstairs with a large guest room, rec room, and additional bathroom. A walk-in storage closet, and utility room with tons of extra storage. No need to garden or shovel here as condo fees cover so you can close up and enjoy spending time doing the things you love to do. Book your Showing TODAY! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "640"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T21:27:58.329526+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1666913"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "No Pet Home"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T20:51:33Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T20:51:33Z"
+"Stories": "1.0"
+"StreetName": "OLD ABBEY"
+"StreetNumber": "180"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "5946"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/180-Old-Abbey-Rd-14"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29898015/180-old-abbey-road-unit-14-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1322
+"BelowGradeFinishedArea": 818
+"OriginalEntryTimestamp": "2026-06-12T20:51:33.62Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1169212"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 18
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898015')"
+"ID": "1525405"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25300
+post_id: "1514962"
+post_author: 1
+"ListingKey": "29880685"
+"ListingId": "40823911"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T21:10:05Z"
+"RFModificationTimestamp": "2026-06-30T21:15:48Z"
+"ListPrice": 569000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1210.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2G4"
+"UnparsedAddress": "435A LEE Avenue, Waterloo, Ontario N2K2G4"
+"Coordinates": array:2 [
0 => -80.5067851
1 => 43.4965407
]
+"Latitude": 43.4965407
+"Longitude": -80.5067851
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this charming, lovingly maintained semi-detached home, proudly offered by its second owner and located in the highly desirable Lincoln Village neighbourhood. The bright eat-in kitchen features an attractive accent wall, ample cabinetry, and plenty of space for everyday family meals. The spacious open-concept living room is filled with natural light from the large bay window and offers room for both comfortable living and dining. This thoughtfully designed home boasts three generously sized bedrooms, two full bathrooms, and a functional layout that has been lovingly cared for over the years. The basement offers excellent potential for additional living space and includes a full bathroom, laundry area, and abundant storage. Adding to the appeal are the often-overlooked benefits of wonderful neighbours, a large lot, and the only carport on the street. Step outside to the covered deck overlooking the fully fenced backyard, which backs directly onto lush, park greenspace—providing added privacy and a beautiful setting for relaxing, entertaining, or enjoying family time outdoors. Ideally located close to the expressway, schools, shopping, and all amenities, this exceptional property presents a fantastic opportunity for families, first-time buyers, and investors alike. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T16:48:04.415942+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908536"
+"ListOfficeKey": "274404"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-10T17:53:18Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T21:03:13Z"
+"Stories": "2.0"
+"StreetName": "LEE"
+"StreetNumber": "435"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3220"
+"VirtualTourURLUnbranded": "https://youriguide.com/a_435_lee_avenue_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29880685/435a-lee-avenue-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1210
+"OriginalEntryTimestamp": "2026-06-10T11:52:28.19Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1221358"
+"ListOfficeNationalAssociationId": "1254957"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 21
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29880685')"
+"ID": "1514962"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1510935"
+post_author: 1
+"ListingKey": "29876708"
+"ListingId": "X13420624"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T18:10:27Z"
+"RFModificationTimestamp": "2026-06-09T18:24:13Z"
+"ListPrice": 539900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G9"
+"UnparsedAddress": "312 - 251 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.5218383
1 => 43.5103022
]
+"Latitude": 43.5103022
+"Longitude": -80.5218383
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Beautiful residence nestled in one of Waterloo's most desirable communities, offering an exceptional blend of modern luxury, convenience, and lifestyle. Thoughtfully designed with elegant finishes throughout, this sophisticated 2-bed suite features expansive windows that flood the space with natural light, creating an airy and welcoming atmosphere. The primary bedroom features a spacious walk-through closet that leads to the ensuite bath. An additional full bathroom is perfect for guests or family. The stunning chef-inspired kitchen is complete with sleek stainless steel appliances, contemporary cabinetry, and stylish finishes that seamlessly flow into the open-concept living and dining areas. Rich laminate flooring extends throughout the unit, enhancing the home's refined aesthetic. Enjoy the two private balconies, including an exclusive retreat off the spacious primary bedroom; the perfect place to unwind with your morning coffee or evening glass of wine. Residents of Blackstone enjoy access to upscale amenities, including a residents' lounge and event space, co-working rooms, a fully equipped fitness studio, and beautifully designed outdoor terraces. This pet-friendly building even features a convenient dog washing station for your four-legged companions. High-speed internet is included in the condo fees for added value, and the owned parking space is an extra perk! Perfectly positioned near trails, RIM Park, St. Jacobs Farmer's Market, Conestoga Mall, and vibrant Uptown Waterloo this location offers effortless access to exceptional dining, shopping, recreation, and entertainment. Convenient highway access makes commuting simple, while the surrounding green spaces provide a peaceful connection to nature. Whether you are a professional seeking an elevated lifestyle, a first-time buyer looking for luxury and convenience, or an investor searching for a premium opportunity, this exceptional condo delivers. Experience sophisticated Waterloo living at its finest. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"AssociationFee": "788"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:2 [
0 => "Apartment in basement"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T18:02:32.806405+00:00"
+"Directions": "Cross Streets: Bridge St. ** Directions: NORTHFIELD DRIVE EAST."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1934633"
+"ListOfficeKey": "285253"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T17:02:24Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T18:04:48Z"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "251"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4424.3"
+"VirtualTourURLUnbranded": "https://video-api.supreme.one/CrjpcP?branded=true"
+"ListAOR": "OnePoint"
+"TaxYear": 2026
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29876708/312-251-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "5 Rivers"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-09T17:02:24.27Z"
+"ListAgentNationalAssociationId": "1234142"
+"ListOfficeNationalAssociationId": "1349485"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 21
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29876708')"
+"ID": "1510935"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25308
+post_id: "1498875"
+post_author: 1
+"ListingKey": "29859879"
+"ListingId": "40836527"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T17:00:10Z"
+"RFModificationTimestamp": "2026-06-11T17:06:07Z"
+"ListPrice": 345000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 584.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H2"
+"UnparsedAddress": "243 NORTHFIELD Drive Unit# 610, Waterloo, Ontario N2K0H2"
+"Coordinates": array:2 [
0 => -80.5226741
1 => 43.5094379
]
+"Latitude": 43.5094379
+"Longitude": -80.5226741
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Awesome opportunity to own in R/O - Blackstone Modern Condominiums in Waterloo! This is a Premium Suite and is on the top Penthouse Floor -- no one above you. Enjoy all the amenities of urban living, while giving you quick access to biking trails and surrounding rural communities to unwind. This is relaxed city living. Inspired by Scandinavian Living and designed around the comforts of a Modern Farmhouse. From our fully equipped gym and co-working space, to the great room and bike room, as a Blackstone tenant you have full access to all amenities across all buildings. No need to even step outside. Amenities include keyless entry, bike storage, dog wash station and 24/7 security. Enjoy full use of the terrace which is a beautiful oasis located on the 2nd floor of Nord. With manicured gardens and modern outdoor furnishings, the terrace is a serene, relaxing space, perfect for entertaining or just simply getting some fresh air. Stainless steel barbeques, a gas fire pit, loungers and dinettes ensure you have everything you need for dinner and drinks under the stars. This Premium ELENA model features quartz counter tops, an Upgraded Kitchen Island and stainless steel appliances, upgraded pot lights in the Living Room, has 1 bedroom, 1 bathroom with upgraded walk in shower with 2/3 glass enclosure and 1 underground parking spot.Walk out to your own 62 sqft Balcony. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFee": "480"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T17:03:33.231155+00:00"
+"Directions": "Corner of Northfield Drive and Bridge Street - enter off Bridge Street"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stucco"
2 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564166"
+"ListOfficeKey": "246041"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-05T15:19:30Z"
+"PhotosCount": 16
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T16:51:47Z"
+"Stories": "1.0"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "243"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3122.33"
+"View": "City view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29859879/243-northfield-drive-unit-610-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 584
+"OriginalEntryTimestamp": "2026-06-05T15:19:30.17Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1113692"
+"ListOfficeNationalAssociationId": "1202898"
+"Media": array:16 [
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]
]
+"DaysOnMarket": 25
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29859879')"
+"ID": "1498875"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25309
+post_id: "1496013"
+post_author: 1
+"ListingKey": "29854251"
+"ListingId": "X13240524"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T14:00:05Z"
+"RFModificationTimestamp": "2026-06-30T14:03:03Z"
+"ListPrice": 2050000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K1Z2"
+"UnparsedAddress": "345 OLD STONE ROAD, Waterloo, Ontario N2K1Z2"
+"Coordinates": array:2 [
0 => -80.511713
1 => 43.501889
]
+"Latitude": 43.501889
+"Longitude": -80.511713
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to an extraordinary Colonial Acres bungalow, offering over 4,000 sq. ft. of finished living space on a breathtaking 0.376-acre park-like lot. Combining luxury, comfort, and resort-style outdoor living, this exceptional property is a rare opportunity in one of Waterloo's most sought-after neighbourhoods. From the moment you arrive, you'll be impressed by the outstanding curb appeal, featuring an oversized double-car garage and an expansive driveway with parking for six or more vehicles. The beautifully landscaped grounds create a private backyard retreat complete with a stunning inground concrete pool,hot tub, and multiple outdoor entertaining spaces designed for relaxation and memorable gatherings. Inside, the thoughtfully designed open-concept main floor is highlighted by a dramatic two-sided stone gas fireplace that serves as the heart of the home. The custom gourmet kitchen is a chef's dream, showcasing premium appliances, a gas cooktop, built-in convection oven and microwave, wine fridge, oversized island, and peninsula seating-perfect for both everyday living and entertaining. The main level features three spacious bedrooms, including a generous primary retreat, along with a beautifully appointed main bathroom featuring a double-sink vanity, glass shower, and luxurious soaker tub. A separate front entrance leads to a functional mudroom and laundry area, complemented by a stylish powder room with a custom live-edge vanity. The finished lower level extends the home's impressive living space with a large family room featuring a cozy gas stove, two oversized bedrooms, a full bathroom, and a versatile office/library complete with custom built-in shelving. Offering the perfect blend of luxury and convenience, this private urban oasis is ideally located just minutes from the expressway, shopping, golf courses, parks, and everyday amenities. Experience resort-style living without ever leaving the city. (id:62783)"
+"Appliances": array:15 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Wine Fridge"
7 => "Dryer"
8 => "Microwave"
9 => "Oven - Built-In"
10 => "Hood Fan"
11 => "Window Coverings"
12 => "Garage door opener"
13 => "Garage door opener remote(s)"
14 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"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-04T19:09:52.050938+00:00"
+"Directions": "Cross Streets: Lexington Road and Lee Ave. ** Directions: Lee Ave to Green Acres to Old Stone."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2211703"
+"ListOfficeKey": "296481"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "125.2 x 132.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-30T13:51:51Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T13:51:51Z"
+"Stories": "1.0"
+"StreetName": "Old Stone"
+"StreetNumber": "345"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "9039.77"
+"VirtualTourURLUnbranded": "https://youriguide.com/345_old_stone_road_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29854251/345-old-stone-road-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 125.2
+"OriginalEntryTimestamp": "2026-06-04T17:13:02.9Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1457628"
+"ListOfficeNationalAssociationId": "1470796"
+"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": 26
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29854251')"
+"ID": "1496013"
}
]
+success: true
+page_size: 9
+page_count: 4
+count: 28
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]