array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29200381/Property?$select=ALL&$top=20&$filter=ListingKey eq 29200381&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29200381/Property?$select=ALL&$top=20&$filter=ListingKey eq 29200381&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23484
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "498421"
+post_author: 1
+"ListingKey": "29200381"
+"ListingId": "X12646160"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T16:10:46Z"
+"RFModificationTimestamp": "2026-01-14T16:13:13Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4N3"
+"UnparsedAddress": "758 GRAND BANKS DRIVE, Waterloo, Ontario N2K4N3"
+"Coordinates": array:2 [
0 => -80.4993587
1 => 43.5135325
]
+"Latitude": 43.5135325
+"Longitude": -80.4993587
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to your new home in the highly sought-after Eastbridge community of Waterloo! This beautifully maintained 4-bedroom, 4-bathroom home offers about 2,500 sq. ft. of finished living space, perfect for families looking for comfort and convenience. new fridge and dishwasher, Freshly painted, The bright, open-concept main floor features a spacious kitchen and a breakfast bar, overlooking a warm and inviting living room. Walk out to a large deck and fully fenced backyard an ideal space for entertaining or relaxing with family and friends. Upstairs, youll find a large primary bedroom with vaulted ceilings, a walk-in closet, and a modern ensuite with a glass shower. three additional generous bedrooms and a full bath complete the upper level. The finished basement provides extra living space perfect for a family room, play area, or home office. Located close to top-rated schools, RIM Park, Grey Silo Golf Course, scenic trails, shopping, Conestoga Mall, public transit, and the expressway, this home has everything your family needs within minutes. A wonderful place to call home in one of Waterloos most desirable neighborhoods. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-22T18:26:40.072887+00:00"
+"Directions": "University Ave E/ New Bedford Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1596474"
+"ListOfficeKey": "290183"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-06T16:20:53Z"
+"PhotosCount": 24
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T15:51:18Z"
+"Stories": "2.0"
+"StreetName": "Grand Banks"
+"StreetNumber": "758"
+"StreetSuffix": "Drive"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1560261530"
"RoomType" => "Family room"
"ListingId" => "X12646160"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29200381"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T15:51:18.46Z"
]
1 => array:11 [
"RoomKey" => "1560261531"
"RoomType" => "Eating area"
"ListingId" => "X12646160"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29200381"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T15:51:18.46Z"
]
2 => array:11 [
"RoomKey" => "1560261532"
"RoomType" => "Kitchen"
"ListingId" => "X12646160"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29200381"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T15:51:18.46Z"
]
3 => array:11 [
"RoomKey" => "1560261533"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12646160"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29200381"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T15:51:18.46Z"
]
4 => array:11 [
"RoomKey" => "1560261534"
"RoomType" => "Bedroom 2"
"ListingId" => "X12646160"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29200381"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T15:51:18.46Z"
]
5 => array:11 [
"RoomKey" => "1560261535"
"RoomType" => "Bedroom 3"
"ListingId" => "X12646160"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29200381"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T15:51:18.46Z"
]
6 => array:11 [
"RoomKey" => "1560261536"
"RoomType" => "Bedroom 4"
"ListingId" => "X12646160"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29200381"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T15:51:18.46Z"
]
7 => array:11 [
"RoomKey" => "1560261537"
"RoomType" => "Family room"
"ListingId" => "X12646160"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29200381"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T15:51:18.46Z"
]
8 => array:11 [
"RoomKey" => "1560261538"
"RoomType" => "Laundry room"
"ListingId" => "X12646160"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29200381"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T15:51:18.46Z"
]
9 => array:11 [
"RoomKey" => "1560261539"
"RoomType" => "Other"
"ListingId" => "X12646160"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29200381"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T15:51:18.46Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29200381/758-grand-banks-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1598728"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "285271"
+"GeocodeManualYN": false
+"TotalActualRent": 3000
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-12-22T17:19:37.76Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:24 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6394012994"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/ee815e26ed38f2904c79e4313964e1f6.webp"
"MediaSize" => 22028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-ee815e26ed38f2904c79e4313964e1f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2026-01-06T16:20:46.79Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6394013002"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/f8cc7f85517a0c3cbba29f09a38830d5.webp"
"MediaSize" => 53000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-f8cc7f85517a0c3cbba29f09a38830d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2026-01-06T16:20:51.97Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6394013085"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/561f3e4b330f1e11ee74676dd5e0c2bd.webp"
"MediaSize" => 58335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-561f3e4b330f1e11ee74676dd5e0c2bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2026-01-06T16:20:52.85Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6394013131"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/969f4db08b2c45d201d32f465662ff75.webp"
"MediaSize" => 33506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-969f4db08b2c45d201d32f465662ff75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2026-01-06T16:20:52.39Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6394013151"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/c05378e6c1b71d973882ec0acc60e0a5.webp"
"MediaSize" => 32868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-c05378e6c1b71d973882ec0acc60e0a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2026-01-06T16:20:41.42Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6394013184"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/d8a5e7a2e45e6d36a7f590b32cc7e630.webp"
"MediaSize" => 33139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-d8a5e7a2e45e6d36a7f590b32cc7e630.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2026-01-06T16:20:41.44Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6380231736"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/54f4e7f044a900c5c247b7b8c40dfd2a.webp"
"MediaSize" => 36409
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-54f4e7f044a900c5c247b7b8c40dfd2a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2025-12-22T19:43:09.28Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6394013324"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/4a12ff7497326c04e08fd4313369098e.webp"
"MediaSize" => 29578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-4a12ff7497326c04e08fd4313369098e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2026-01-06T16:20:40.85Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6394013365"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/3df328df5c61480fde72ab0f4d859678.webp"
"MediaSize" => 26369
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-3df328df5c61480fde72ab0f4d859678.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2026-01-06T16:20:51.71Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6394013393"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/e06ed4746de7be4ab0f64fabfd6c13fd.webp"
"MediaSize" => 68086
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-e06ed4746de7be4ab0f64fabfd6c13fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2026-01-06T16:20:40.52Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6394013496"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/3223394e208f4891309bea137737b398.webp"
"MediaSize" => 64134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-3223394e208f4891309bea137737b398.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2026-01-06T16:20:40.35Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6394013538"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/4073c6a64d904e71795482b956596d9d.webp"
"MediaSize" => 32726
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-4073c6a64d904e71795482b956596d9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2026-01-06T16:20:41.45Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6394013617"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/f98020fdbef007cdce274efc99b03aa1.webp"
"MediaSize" => 81192
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-f98020fdbef007cdce274efc99b03aa1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2026-01-06T16:20:41.95Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6394013699"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/a65741626d9d27525e73bc024fe2cdbb.webp"
"MediaSize" => 82401
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-a65741626d9d27525e73bc024fe2cdbb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2026-01-06T16:20:52.14Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6394013769"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/a04f38bb3f91c5aa4f6ba8425dc88a01.webp"
"MediaSize" => 31288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-a04f38bb3f91c5aa4f6ba8425dc88a01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2026-01-06T16:20:52.38Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6380232178"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/75bdfb2a2a8343fae3854fa4e9b46d7a.webp"
"MediaSize" => 33128
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-75bdfb2a2a8343fae3854fa4e9b46d7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2025-12-22T19:43:27.33Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6394013814"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/040ca8d15446850e437061ecae6956ee.webp"
"MediaSize" => 33137
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-040ca8d15446850e437061ecae6956ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2026-01-06T16:20:50.99Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6394013844"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/b5d3bf377be442c7a646b639ffb8f770.webp"
"MediaSize" => 68080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-b5d3bf377be442c7a646b639ffb8f770.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2026-01-06T16:20:53.16Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6394013888"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/3ee379da7b04b10ae4fc6e2c3be86451.webp"
"MediaSize" => 24675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-3ee379da7b04b10ae4fc6e2c3be86451.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2026-01-06T16:20:49.97Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6380232363"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/b6899c68cdc0d64dca889f4c5fa86f81.webp"
"MediaSize" => 32662
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-b6899c68cdc0d64dca889f4c5fa86f81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2025-12-22T19:43:10.19Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6394014072"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/2698234a6f7ddfbb12e947c98bb889f7.webp"
"MediaSize" => 80597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-2698234a6f7ddfbb12e947c98bb889f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2026-01-06T16:20:41.29Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6394014129"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/3d92480f2cd78e98a924cc242206f290.webp"
"MediaSize" => 34845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-3d92480f2cd78e98a924cc242206f290.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2026-01-06T16:20:40.52Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6394014137"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/ef1a0d5b8d1c7170f88f7740ff7cdcd1.webp"
"MediaSize" => 40431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-ef1a0d5b8d1c7170f88f7740ff7cdcd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2026-01-06T16:20:50.34Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6394014220"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29200381/3786ab5f0c14551a5f6f672543af86eb.webp"
"MediaSize" => 41521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29200381/thumbnail-3786ab5f0c14551a5f6f672543af86eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12646160"
"ResourceRecordKey" => "29200381"
"ModificationTimestamp" => "2026-01-06T16:20:41.43Z"
]
]
+"Member": []
+"Office": array:1 [
0 => array:19 [
"OfficeName" => "RE/MAX GOLD REALTY INC."
"OfficePhone" => "905-290-6777"
"OfficeMlsId" => "187104"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "290183"
"ModificationTimestamp" => "2024-06-19T08:31:11Z"
"OfficeAddress1" => "5865 MCLAUGHLIN RD #6A"
"OfficeCity" => "MISSISSAUGA"
"OfficePostalCode" => "L5R1B8"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Toronto"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OriginalEntryTimestamp" => "2021-04-16T19:15:00Z"
"OfficeNationalAssociationId" => "1384540"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1051513"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29200381')"
+"ID": "498421"
}
]
+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=OfficeKey eq 290183/Office?$select=ALL&$top=10&$filter=OfficeKey eq 290183&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 290183/Office?$select=ALL&$top=10&$filter=OfficeKey eq 290183&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25293
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25295
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX GOLD REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "905-290-6777"
+"OfficeMlsId": "187104"
+"ModificationTimestamp": "2024-06-19T08:31:11Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "290183"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "5865 MCLAUGHLIN RD #6A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "MISSISSAUGA"
+"OfficePostalCode": "L5R1B8"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1384540"
+"OriginalEntryTimestamp": "2021-04-16T19:15:00Z"
+"OfficeAORKey": "82"
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1051513"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('290183')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1596474/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1596474&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1596474/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1596474&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25298
+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 29200381" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24926
+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 29200381/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29200381&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29200381/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29200381&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24908
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29200381 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.4993587 43.5135325)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29200381 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.4993587 43.5135325)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29200381 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.4993587 43.5135325)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29200381 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.4993587 43.5135325)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24745
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25148
+post_id: "528241"
+post_author: 1
+"ListingKey": "29239859"
+"ListingId": "40797385"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-12T16:10:57Z"
+"RFModificationTimestamp": "2026-01-12T20:09:59Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1785.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0A1"
+"UnparsedAddress": "875 UNIVERSITY Avenue E Unit# 35, Waterloo, Ontario N2K0A1"
+"Coordinates": array:2 [
0 => -80.4965135
1 => 43.5098035
]
+"Latitude": 43.5098035
+"Longitude": -80.4965135
+"YearBuilt": 2008
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to the Grand Bluffs, Waterloo’s premium address nestled along the scenic Grand River. This beautiful bungalow loft unit offers a unique blend of open-concept design and cozy charm, perfect for anyone seeking an upscale yet homey retreat. This unit features open and airy lofted ceilings, with abundant natural light from expansive windows and stunning river views. The spacious master suite is located on the main level with private ensuite and walk in closet. The main floor also has a formal dining space just off the living room which is open to the kitchen and dinette area with sliders to the large deck overlooking the Grand River and Snyder’s Flats. The upper loft space includes an additional bedroom with ensuite as well as a walk in closet and family room, perfect for guests! Main floor laundry with garage access and a large unfinished basement for additional storage complete this home. Located steps from walking trails, Grey Silo Golf Club, Rim Park, Conestogo Mall and highway access. Truly a rare offering in this exclusive complex. 1 year lease minimum, full credit report, application with references and confirmation of employment required. No students. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-12T20:09:34.411676+00:00"
+"Directions": "Off University between Northfield Drive and Lexington Road"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563706"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:8 [
0 => "Southern exposure"
1 => "Ravine"
2 => "Backs on greenbelt"
3 => "Conservation/green belt"
4 => "Balcony"
5 => "Paved driveway"
6 => "Sump Pump"
7 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-12T16:02:22Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-12T16:02:22Z"
+"Stories": "1.5"
+"StreetDirSuffix": "East"
+"StreetName": "UNIVERSITY"
+"StreetNumber": "875"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"View": "River view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1559466965"
"RoomType" => "Other"
"ListingId" => "40797385"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "59'5'' x 25'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
1 => array:11 [
"RoomKey" => "1559466966"
"RoomType" => "Family room"
"ListingId" => "40797385"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "19'3'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
2 => array:11 [
"RoomKey" => "1559466967"
"RoomType" => "4pc Bathroom"
"ListingId" => "40797385"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 5'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
3 => array:11 [
"RoomKey" => "1559466968"
"RoomType" => "Bedroom"
"ListingId" => "40797385"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
4 => array:11 [
"RoomKey" => "1559466969"
"RoomType" => "Primary Bedroom"
"ListingId" => "40797385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "21'3'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
5 => array:11 [
"RoomKey" => "1559466970"
"RoomType" => "Living room"
"ListingId" => "40797385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "15'1'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
6 => array:11 [
"RoomKey" => "1559466971"
"RoomType" => "Laundry room"
"ListingId" => "40797385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "7'3'' x 6'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
7 => array:11 [
"RoomKey" => "1559466972"
"RoomType" => "Kitchen"
"ListingId" => "40797385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
8 => array:11 [
"RoomKey" => "1559466973"
"RoomType" => "Dining room"
"ListingId" => "40797385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
9 => array:11 [
"RoomKey" => "1559466974"
"RoomType" => "Breakfast"
"ListingId" => "40797385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "7'4'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
10 => array:11 [
"RoomKey" => "1559466975"
"RoomType" => "Full bathroom"
"ListingId" => "40797385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
11 => array:11 [
"RoomKey" => "1559466976"
"RoomType" => "Foyer"
"ListingId" => "40797385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 5'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
12 => array:11 [
"RoomKey" => "1559466977"
"RoomType" => "2pc Bathroom"
"ListingId" => "40797385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 2'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29239859/875-university-avenue-e-unit-35-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 3650
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1785
+"OriginalEntryTimestamp": "2026-01-12T16:01:31.21Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:50 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6401488459"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/c1c5da983a66db237281533e58d83ebd.webp"
"MediaSize" => 164704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-c1c5da983a66db237281533e58d83ebd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.4Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6401488474"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/53a89b2284e8d748e7aca84e97c0cab5.webp"
"MediaSize" => 155144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-53a89b2284e8d748e7aca84e97c0cab5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.4Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6401488482"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/4a62bba66995e9d6d5e0059703e0698a.webp"
"MediaSize" => 157931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-4a62bba66995e9d6d5e0059703e0698a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.43Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6401488504"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/85b2314af4bf44e5f3d5e7fc674661bf.webp"
"MediaSize" => 145297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-85b2314af4bf44e5f3d5e7fc674661bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.43Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6401488564"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/1c22b5db65637b3e136bc910618c5e53.webp"
"MediaSize" => 42498
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-1c22b5db65637b3e136bc910618c5e53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.43Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6401488588"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/7eee6c9a8ec47a5953e12bca246f37ab.webp"
"MediaSize" => 74785
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-7eee6c9a8ec47a5953e12bca246f37ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.4Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6401488592"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/71981f344a4a15463010f5bed6fc231e.webp"
"MediaSize" => 76333
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-71981f344a4a15463010f5bed6fc231e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.4Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6401488689"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/48c0744cebe2d5131836a3912aefd0a4.webp"
"MediaSize" => 80979
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-48c0744cebe2d5131836a3912aefd0a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.43Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6401488714"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/6c5b34f2251e175b21fadb1e893381d7.webp"
"MediaSize" => 76927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-6c5b34f2251e175b21fadb1e893381d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.45Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6401488773"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/3e05b75da9292e6c3bb2584c23742e58.webp"
"MediaSize" => 80019
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-3e05b75da9292e6c3bb2584c23742e58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.4Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6401488796"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/ba5c323b2cf45e36021c5b75a51b9431.webp"
"MediaSize" => 75029
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-ba5c323b2cf45e36021c5b75a51b9431.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.4Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6401488889"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/0aa81adca8e51830a934c9f161bac11b.webp"
"MediaSize" => 78055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-0aa81adca8e51830a934c9f161bac11b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.4Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6401488927"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/ab2ec5768f73fcb512023cc95b436d94.webp"
"MediaSize" => 90054
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-ab2ec5768f73fcb512023cc95b436d94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.4Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6401488930"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/5cff468c16baf8ce756010978bc77891.webp"
"MediaSize" => 91521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-5cff468c16baf8ce756010978bc77891.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.43Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6401488999"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/a68db863f2dc4974fc9ce8ef465db5e9.webp"
"MediaSize" => 94653
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-a68db863f2dc4974fc9ce8ef465db5e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.4Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6401489003"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/b09d86f50579f3ef8e1f18581c6d63a1.webp"
"MediaSize" => 86932
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-b09d86f50579f3ef8e1f18581c6d63a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.41Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6401489094"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/3b8541743ae68be32b60228df0f7d887.webp"
"MediaSize" => 89215
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-3b8541743ae68be32b60228df0f7d887.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.92Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6401489095"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/7f35769a87570f9702cc119e96b10420.webp"
"MediaSize" => 96946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-7f35769a87570f9702cc119e96b10420.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.4Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6401489128"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/72babb3342e8d6e005da530ca1078b4d.webp"
"MediaSize" => 79548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-72babb3342e8d6e005da530ca1078b4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.91Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6401489135"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/9ada33e26ede402b88fe59655ce52420.webp"
"MediaSize" => 91072
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-9ada33e26ede402b88fe59655ce52420.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.4Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6401489195"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/90af9d4166e109326131a7f62c3ae876.webp"
"MediaSize" => 97134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-90af9d4166e109326131a7f62c3ae876.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.4Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6401489214"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/c466381a4bb9a4ca9d0de5d094f15481.webp"
"MediaSize" => 67290
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-c466381a4bb9a4ca9d0de5d094f15481.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.41Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6401489243"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/4d7a5acbc67976a22560b96f7ac5ddc6.webp"
…10
]
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]
]
+"Member": []
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29239859')"
+"ID": "528241"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25146
+post_id: "527450"
+post_author: 1
+"ListingKey": "29239809"
+"ListingId": "X12686048"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-12T17:25:51Z"
+"RFModificationTimestamp": "2026-01-12T17:30:18Z"
+"ListPrice": 1250000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4N7"
+"UnparsedAddress": "201 SPRING GARDEN DRIVE, Waterloo, Ontario N2J4N7"
+"Coordinates": array:2 [
0 => -80.4926404
1 => 43.5244789
]
+"Latitude": 43.5244789
+"Longitude": -80.4926404
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautiful house located in Waterloo's prestigious Carriage Crossing neighbourhood. This sunny corner house offers large windows and plenty of natural light. Spacious great room and dinning room with hardwood floors on the main floor. Large family room with walk out balcony and four bedrooms and three full bathrooms on the second floor. The home has large windows on the basement, whole-house ventilation system, newly purchased water heater (2024), air conditioner, washer, dryer, stove, dishwasher (brand new), walk-out deck. Garage with high ceiling storage rack. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-12T16:16:36.631368+00:00"
+"Directions": "Cross Streets: University/Millennium. ** Directions: Grey Silo/Millstream."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2023362"
+"ListOfficeKey": "292792"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "49.4 x 109.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-12T15:47:36Z"
+"PhotosCount": 28
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-12T17:13:27Z"
+"Stories": "2.0"
+"StreetName": "Spring Garden"
+"StreetNumber": "201"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "8576"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29239809/201-spring-garden-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 49.4
+"OriginalEntryTimestamp": "2026-01-12T15:47:36.7Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:28 [
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]
]
+"Member": []
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29239809')"
+"ID": "527450"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25149
+post_id: "526557"
+post_author: 1
+"ListingKey": "29238768"
+"ListingId": "40797113"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-11T22:55:35Z"
+"RFModificationTimestamp": "2026-01-12T00:48:56Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 518.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G9"
+"UnparsedAddress": "247 NORTHFIELD Drive E Unit# 405, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.5217691
1 => 43.5105762
]
+"Latitude": 43.5105762
+"Longitude": -80.5217691
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Blackstone, a unique Scandinavian-inspired community blending modern farmhouse vibes with ultimate comfort. This bright 1-bedroom unit features a balcony overlooking the beautiful RO courtyard, complete with a fire pit, BBQs, and a spa for relaxing. The sleek kitchen boasts stainless steel appliances and quartz countertops, and Browns Social House is just a short walk away for nights off from cooking. With onsite shopping, 24/7 security, a fitness centre, and easy access to trails, the Grand River, and transit, Blackstone offers a lifestyle you’ll love! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Heat"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-12T00:48:39.224990+00:00"
+"Directions": "CORNER OF NORTHFIELD DR AND BRIDGE ST"
+"ExteriorFeatures": array:3 [
0 => "Wood"
1 => "Stone"
2 => "Metal"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1950448"
+"ListOfficeKey": "299742"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-01-11T22:49:28Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-11T22:49:28Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "247"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"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/29238768/247-northfield-drive-e-unit-405-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1819312"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "76849"
+"GeocodeManualYN": true
+"TotalActualRent": 1950
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 518
+"OriginalEntryTimestamp": "2026-01-11T22:49:23.31Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:18 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29238768')"
+"ID": "526557"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24770
+post_id: "526569"
+post_author: 1
+"ListingKey": "29238726"
+"ListingId": "X12685032"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-11T21:50:35Z"
+"RFModificationTimestamp": "2026-01-11T22:36:32Z"
+"ListPrice": 889000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4B7"
+"UnparsedAddress": "503 BRIGANTINE DRIVE, Waterloo, Ontario N2K4B7"
+"Coordinates": array:2 [
0 => -80.5142811
1 => 43.5076026
]
+"Latitude": 43.5076026
+"Longitude": -80.5142811
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Prime Eastbridge Location The Perfect Family Home with Room to Grow! Welcome to this beautifully maintained home in the heart of Eastbridge, one of Waterloos most desirable family-friendly neighborhoods. Offering plenty of space, comfort, and charm, this home is designed for both everyday living and entertaining. The main floor features a bright, open-concept layout with a spacious living room highlighted by a cozy center fireplace and Palladium windows that flood the space with natural light. The carpet-free design adds a clean, modern touch throughout. The expansive kitchen boasts ample cabinetry, including a full pantry wall, and an adjoining dining area with a walkout to a large deck perfect for family dinners or weekend barbecues. Upstairs, you'll find a welcoming family room with oversized windows, offering the ideal spot for movie nights or kids playtime. The second floor includes three generous bedrooms, including a primary suite complete with a walk-in closet and a private ensuite bathroom. The basement is mostly finished, offering a spacious recreation room, games area, laundry, and ample storage giving your family even more room to grow and play. Step outside to enjoy the oversized deck with a charming gazebo, overlooking a large fenced yard thats perfect for children, pets, or summer gatherings with friends and family. This home is ideally located with quick access to schools, parks, shopping, and transit everything a growing family needs, right at your doorstep. Move-in ready and waiting for its next family to make lasting memories. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Blinds"
7 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-11T22:36:11.479436+00:00"
+"Directions": "Cross Streets: Chesapeake. ** Directions: Chesapeake to Bringantine."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2094417"
+"ListOfficeKey": "270562"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "36 x 148 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-11T21:40:59Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-11T21:40:59Z"
+"Stories": "2.0"
+"StreetName": "Brigantine"
+"StreetNumber": "503"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6069"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://iframe.videodelivery.net/36321914b51693ba3632b84777376e1e"
+"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": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29238726/503-brigantine-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R4 Residential"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 36.0
+"OriginalEntryTimestamp": "2026-01-11T21:40:59.09Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:35 [
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]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29238726')"
+"ID": "526569"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25147
+post_id: "519043"
+post_author: 1
+"ListingKey": "29228407"
+"ListingId": "40796808"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-10T21:30:34Z"
+"RFModificationTimestamp": "2026-01-10T21:31:57Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1836.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0E9"
+"UnparsedAddress": "271 GREY SILO Road Unit# 67, Waterloo, Ontario N2K0E9"
+"Coordinates": array:2 [
0 => -80.4962059
1 => 43.5244609
]
+"Latitude": 43.5244609
+"Longitude": -80.4962059
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This brand-new move-in ready three-storey condo townhome offers a rare combination of space, flexibility, and low-maintenance living — ideal for those who want room to grow without the upkeep of a traditional freehold home. The thoughtfully designed 1,836 sq ft layout features four true bedrooms, including three on the upper level and one on the main floor, perfect for guests or a home office. With 3.5 bathrooms, busy mornings and everyday routines are made easy. East and west exposures fill the home with natural light throughout the day, while current views over open farmland provide a sense of space. Included finishes such as 9' ceilings on ground and second floors, Quartz countertops and steel backed stairs. There is a premium insulated garage door and Duradeck, aluminum and glass railing on the two balconies. Enjoy the peace of mind that comes with warranty-backed brand-new construction, along with a double car garage for secure parking and storage. Set within the highly regarded Carriage Crossing neighbourhood, families will appreciate scenic trails along the river and golf course, year-round recreation at RIM Park, and a modern community library — all just minutes from St. Jacobs Farmers’ Market, Conestoga Mall, schools, parks, and everyday conveniences. It’s a rare opportunity to enjoy the feel of countryside living while staying closely connected to the city. Experience modern, low-maintenance living at The Trailside Towns - a smart move-up option in a growing community. List price reflects all current incentives/promotions. Select images include virtual staging for illustrative purposes. Offers will be presented on Fri, Jan 16th at 11am, irrevocable until 5pm. Pre-emptive offers may be considered provided they include a minimum 24-hr irrevocable period calculated during business hours only, being Mon-Fri from 9am-5pm. (id:62650)"
+"Appliances": array:1 [
0 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"AssociationFee": "575.4"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-08T15:19:10.446789+00:00"
+"Directions": "Millennium to Crossgate"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564466"
+"ListOfficeKey": "76840"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-01-08T17:09:02Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-10T21:18:46Z"
+"Stories": "3.0"
+"StreetName": "GREY SILO"
+"StreetNumber": "271"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "6223"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29228407/271-grey-silo-road-unit-67-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2217706"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "289722"
+"GeocodeManualYN": true
+"ZoningDescription": "R9"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1836
+"OriginalEntryTimestamp": "2026-01-08T14:39:38.17Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29228407')"
+"ID": "519043"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25157
+post_id: "515381"
+post_author: 1
+"ListingKey": "29223342"
+"ListingId": "40795022"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-07T15:15:05Z"
+"RFModificationTimestamp": "2026-01-07T15:16:59Z"
+"ListPrice": 339000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 562.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H1"
+"UnparsedAddress": "247 NORTHFIELD Street Unit# 308, Waterloo, Ontario N2K0H1"
+"Coordinates": array:2 [
0 => -80.5217286
1 => 43.5099657
]
+"Latitude": 43.5099657
+"Longitude": -80.5217286
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to your new home at the prestigious Blackstone building in Waterloo! This stunning one bedroom condo offers luxury living at its finest. Step into a modern space with high-end finishes including stainless appliances, sleek quartz countertops, and a spacious walk-in closet. This unit also comes with an owned storage locker and a conveniently located parking spot, W6 - the closest parking space to the front doors of the building, ensuring a hassle-free experience every time you come home. Condo fees include water and internet as well. Blackstone's amenities are second to none, with a fitness centre to keep you active, social rooms for entertaining guests, a co-working space with meeting rooms for your business needs, and even a pet wash station for your furry friends. Outdoor enthusiasts will love the courtyard with a hot tub, fire bowl, BBQ area, and harvest table - perfect for enjoying the fresh air. And don't forget about the rooftop terrace with lounge seating and BBQ facilities, offering stunning views of the city skyline. Experience convenience, luxury, and a vibrant community lifestyle at Blackstone. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFee": "469"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-07T06:53:42.491533+00:00"
+"Directions": "Northfield to entrance"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"Heating": array:1 [
0 => "Heat Pump"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2126426"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Country residential"
]
+"ParkingFeatures": array:1 [
0 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-01-07T05:21:44Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-07T15:00:51Z"
+"Stories": "1.0"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "247"
+"StreetSuffix": "Street"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "2822"
+"VirtualTourURLUnbranded": "https://youriguide.com/247_northfield_dr_e_suite_308_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29223342/247-northfield-street-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": 0
+"AboveGradeFinishedArea": 562
+"OriginalEntryTimestamp": "2026-01-07T05:18:38.79Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29223342')"
+"ID": "515381"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23498
+post_id: "512734"
+post_author: 1
+"ListingKey": "29220138"
+"ListingId": "40796187"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-06T17:35:37Z"
+"RFModificationTimestamp": "2026-01-06T17:52:54Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 538.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3H4"
+"UnparsedAddress": "251 NORTHFIELD Drive E Unit# 105, Waterloo, Ontario N2K3H4"
+"Coordinates": array:2 [
0 => -80.5217325
1 => 43.5105682
]
+"Latitude": 43.5105682
+"Longitude": -80.5217325
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Step into the welcoming embrace of 251 NORTHFIELD Drive E Unit #105, situated in the vibrant community of Waterloo. This delightful 1-bedroom, 1-bathroom unit invites you to experience comfort and convenience in a prime location. As you step inside, you'll be greeted by an inviting open-concept living space, perfect for both relaxation and entertaining guests. The kitchen comes fully equipped with everything you need to whip up delicious meals, while ample natural light floods the space, creating a warm and inviting atmosphere. When it's time to unwind, the bedroom offers a serene retreat, with plenty of storage space. The bathroom is modern and well-appointed, ensuring your comfort and convenience. Step outside onto your private balcony, where you can enjoy your morning coffee or soak up the sunshine in peace. With reserved parking and on-site laundry facilities, everyday tasks become a breeze. And for those with furry companions, rest assured that this apartment is pet-friendly, so your four-legged friends can feel right at home too. With shopping, dining, and entertainment options just moments away, everything you need is within easy reach. Ready to experience the charm and convenience of life at 251 NORTHFIELD Drive E Unit #105? Schedule a viewing today and discover your new home sweet home in Waterloo. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "School Bus"
1 => "Community Centre"
2 => "Industrial Park"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-06T17:52:35.282729+00:00"
+"Directions": "Northfield Dr. to Bridge St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1897408"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Industrial mall/subdivision"
]
+"PhotosChangeTimestamp": "2026-01-06T17:29:07Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-06T17:29:07Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "251"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "2662.77"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29220138/251-northfield-drive-e-unit-105-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 1850
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 538
+"OriginalEntryTimestamp": "2026-01-06T17:29:07.33Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:35 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29220138')"
+"ID": "512734"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25136
+post_id: "512605"
+post_author: 1
+"ListingKey": "29219150"
+"ListingId": "40795948"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T21:20:25Z"
+"RFModificationTimestamp": "2026-01-14T21:29:22Z"
+"ListPrice": 949000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3080.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3Y5"
+"UnparsedAddress": "537 WINDJAMMER Way, Waterloo, Ontario N2K3Y5"
+"Coordinates": array:2 [
0 => -80.5050792
1 => 43.506906
]
+"Latitude": 43.506906
+"Longitude": -80.5050792
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful Family Home in Highly Sought-After Eastbridge Community Welcome to this charming 4-bed, 3.5-bath home in the heart of Eastbridge—complete with a fully finished basement, covered outdoor living space, and no rear neighbours. With outstanding curb appeal in a family-friendly neighbourhood, this meticulously maintained home offers bright and thoughtfully designed living space. The spacious foyer includes a highly functional walk-in coat closet, ideal for busy families or hosting guests. A front living room provides the perfect spot for a home office or play area, with a clear view of the street to keep an eye on the kids. Elegant hardwood floors lead you to the renovated kitchen, featuring a gas stove, large island, and ambient pot lighting. The open-concept layout connects seamlessly to the second living area, complete with large windows and a cozy fireplace. Step through the sliding glass doors to your expansive covered deck, featuring a built-in BBQ, ample seating, and peaceful views—no rear neighbours make this private outdoor retreat exceptionally enjoyable. Upstairs, hardwood floors continue throughout. The large primary suite features two closets and a renovated spa-like 4-pc ensuite with heated floors and a steam shower. Three additional bedrooms, a linen closet, and a 5-pc bathroom complete the upper level. The fully finished basement offers engineered hardwood floors, a stone fireplace, a 3-pc bathroom, and generous storage space. This home has been exceptionally cared for and is truly move-in ready. Book your showing today! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-06T17:43:16.683185+00:00"
+"Directions": "Eastbridge Blvd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1879079"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Backs on greenbelt"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-06T15:00:44Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T21:09:21Z"
+"Stories": "2.0"
+"StreetName": "WINDJAMMER"
+"StreetNumber": "537"
+"StreetSuffix": "Way"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "6138"
+"VirtualTourURLUnbranded": "https://iguidephotos.com/95usa_537_windjammer_way_waterloo_on/"
+"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/29219150/537-windjammer-way-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2104
+"BelowGradeFinishedArea": 976
+"OriginalEntryTimestamp": "2026-01-06T15:00:44.44Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Assessor"
+"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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29219150')"
+"ID": "512605"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25139
+post_id: "508877"
+post_author: 1
+"ListingKey": "29214546"
+"ListingId": "40795077"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-06T21:40:15Z"
+"RFModificationTimestamp": "2026-01-06T21:59:42Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2276.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4G8"
+"UnparsedAddress": "460 WOOLWICH Street Unit# 23, Waterloo, Ontario N2K4G8"
+"Coordinates": array:2 [
0 => -80.4928114
1 => 43.5006805
]
+"Latitude": 43.5006805
+"Longitude": -80.4928114
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Luxury awaits at Riverstone Estates located at 460 Woolwich Street. This high end executive townhouse is ready for lease immediately offering 3 bedrooms and 3 bathrooms and is situated in the desirable east end of Waterloo. The spacious open concept main floor features engineered hardwood flooring and a cozy gas fireplace while connecting with the upgraded kitchen with quartz counters, breakfast bar, double sink, and premium stainless steel appliances. Upstairs you will find 3 large bedrooms including a primary bedroom with a 5 piece ensuite and walk in closet. With plenty of oversized windows throughout the home you will be able to enjoy natural light flowing in. The fully finished walk out downstairs offers a wet bar and massive rec room ready for entertaining or relaxing with your family. New appliances to the home include dishwasher, RO water system, washing machine, furnace, and AC. This remarkable townhouse is steps from the Grand River, Kiwanis Park, excellent schools, RIM park, Grey Silo Golf Course and the expressway. There are 2 parking spaces including the garage and plenty of visitor parking for guests. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"AssociationFeeIncludes": array:1 [
0 => "Property Management"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-05T16:18:28.534287+00:00"
+"Directions": "Woolwich & University"
+"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": "1910159"
+"ListOfficeKey": "246041"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-06T21:29:20Z"
+"PhotosCount": 38
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-06T21:29:20Z"
+"Stories": "2.5"
+"StreetName": "WOOLWICH"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"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/29214546/460-woolwich-street-unit-23-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 3600
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 2276
+"OriginalEntryTimestamp": "2026-01-05T16:00:10Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:38 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29214546')"
+"ID": "508877"
}
]
+success: true
+page_size: 9
+page_count: 6
+count: 54
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]