array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29077583/Property?$select=ALL&$top=20&$filter=ListingKey eq 29077583&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29077583/Property?$select=ALL&$top=20&$filter=ListingKey eq 29077583&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23512
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23514
+post_id: "397312"
+post_author: 1
+"ListingKey": "29077583"
+"ListingId": "40786425"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T17:55:50Z"
+"RFModificationTimestamp": "2025-11-26T18:24:56Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 500.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4L7"
+"UnparsedAddress": "779 ANGLER Way, Waterloo, Ontario N2K4L7"
+"Coordinates": array:2 [
0 => -80.49998273
1 => 43.51488371
]
+"Latitude": 43.51488371
+"Longitude": -80.49998273
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "ALL INCLUSIVE LOWER level 1bedroom 1 bathroom apartment in very desirable location in Waterloo. This updated lower level LEGAL apartment with BIG windows, carpet free, 1 bedroom &1 bathroom with a tub includes 1 parking spot. Lower level has its own entrance. Free SHARED laundry. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-07T02:43:18.837577+00:00"
+"Directions": "University Ave. & New Hampshire St"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1768640"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Cul-de-sac"
]
+"PhotosChangeTimestamp": "2025-11-06T22:30:30Z"
+"PhotosCount": 8
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T17:39:23Z"
+"Stories": "1.0"
+"StreetName": "ANGLER"
+"StreetNumber": "779"
+"StreetSuffix": "Way"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1540476450"
"RoomType" => "4pc Bathroom"
"ListingId" => "40786425"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29077583"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T17:39:23.48Z"
]
1 => array:11 [
"RoomKey" => "1540476451"
"RoomType" => "Dinette"
"ListingId" => "40786425"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29077583"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T17:39:23.48Z"
]
2 => array:11 [
"RoomKey" => "1540476452"
"RoomType" => "Bedroom"
"ListingId" => "40786425"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29077583"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T17:39:23.48Z"
]
3 => array:11 [
"RoomKey" => "1540476453"
"RoomType" => "Living room"
"ListingId" => "40786425"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29077583"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T17:39:23.48Z"
]
4 => array:11 [
"RoomKey" => "1540476454"
"RoomType" => "Kitchen"
"ListingId" => "40786425"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29077583"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 7'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T17:39:23.48Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29077583/779-angler-way-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1350
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 24.0
+"AboveGradeFinishedArea": 0
+"BelowGradeFinishedArea": 500
+"OriginalEntryTimestamp": "2025-11-06T22:30:30.26Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:8 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6299747518"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077583/22d0f7a92447b4675a05cb8df4cfc53f.webp"
"MediaSize" => 58025
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077583/thumbnail-22d0f7a92447b4675a05cb8df4cfc53f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40786425"
"ResourceRecordKey" => "29077583"
"ModificationTimestamp" => "2025-11-06T22:30:30.27Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6299747539"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077583/e16872b1f0a4ede39acd89d2f1512242.webp"
"MediaSize" => 55836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077583/thumbnail-e16872b1f0a4ede39acd89d2f1512242.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786425"
"ResourceRecordKey" => "29077583"
"ModificationTimestamp" => "2025-11-06T22:30:30.27Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6299747575"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077583/0b01ceb70ab8cbef7e76bdae7b9b8bc1.webp"
"MediaSize" => 61490
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077583/thumbnail-0b01ceb70ab8cbef7e76bdae7b9b8bc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786425"
"ResourceRecordKey" => "29077583"
"ModificationTimestamp" => "2025-11-06T22:30:30.27Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6299747597"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077583/cc070a882d4a6dcc77c035f79bb80af6.webp"
"MediaSize" => 76592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077583/thumbnail-cc070a882d4a6dcc77c035f79bb80af6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786425"
"ResourceRecordKey" => "29077583"
"ModificationTimestamp" => "2025-11-06T22:30:30.27Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6299747668"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077583/28050633a1c4623c0b4d184d12a8e63f.webp"
"MediaSize" => 56493
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077583/thumbnail-28050633a1c4623c0b4d184d12a8e63f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786425"
"ResourceRecordKey" => "29077583"
"ModificationTimestamp" => "2025-11-06T22:30:30.27Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6299747707"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077583/5e94693c592d276afec230cbdbe891cf.webp"
"MediaSize" => 36836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077583/thumbnail-5e94693c592d276afec230cbdbe891cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786425"
"ResourceRecordKey" => "29077583"
"ModificationTimestamp" => "2025-11-06T22:30:30.27Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6299747763"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077583/a6cb01e17b24d45f6a271225b402405d.webp"
"MediaSize" => 36107
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077583/thumbnail-a6cb01e17b24d45f6a271225b402405d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786425"
"ResourceRecordKey" => "29077583"
"ModificationTimestamp" => "2025-11-06T22:30:30.27Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6299747775"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077583/09a660710c0169fec9384487afb60ea0.webp"
"MediaSize" => 53420
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077583/thumbnail-09a660710c0169fec9384487afb60ea0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786425"
"ResourceRecordKey" => "29077583"
"ModificationTimestamp" => "2025-11-06T22:30:30.27Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "RAJ VINEPAL"
"MemberFirstName" => "RAJ"
"MemberLastName" => "VINEPAL"
"MemberMlsId" => "KWkw6378"
"OriginatingSystemName" => 26
"MemberKey" => "1768640"
"ModificationTimestamp" => "2025-10-28T23:28:48Z"
"MemberStatus" => "Active"
"OfficeKey" => "76807"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberFax" => "519-579-3442"
"MemberCity" => "KITCHENER"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "519-574-3827"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2008-05-16T17:48:00Z"
"MemberNationalAssociationId" => "1185878"
"OfficeNationalAssociationId" => "1004370"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "RE/MAX TWIN CITY REALTY INC."
"OfficePhone" => "519-579-4110"
"OfficeMlsId" => "KW64"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "76807"
"ModificationTimestamp" => "2025-08-19T15:50:12Z"
"OfficeAddress1" => "901 VICTORIA ST. N."
"OfficeCity" => "KITCHENER"
"OfficePostalCode" => "N2B3C"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"OfficeFax" => "519-579-3442"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OfficeNationalAssociationId" => "1004370"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1069905"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29077583')"
+"ID": "397312"
}
]
+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 76807/Office?$select=ALL&$top=10&$filter=OfficeKey eq 76807&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 76807/Office?$select=ALL&$top=10&$filter=OfficeKey eq 76807&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25292
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25294
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "519-579-4110"
+"OfficeMlsId": "KW64"
+"ModificationTimestamp": "2025-08-19T15:50:12Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "76807"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "901 VICTORIA ST. N."
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "KITCHENER"
+"OfficePostalCode": "N2B3C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1004370"
+"OriginalEntryTimestamp": null
+"OfficeFax": "519-579-3442"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "431111"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "76807"
"SocialMediaUrlOrId" => "http://www.remaxtwincity.com/"
"ModificationTimestamp" => "2025-08-19T15:27:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1069905"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('76807')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1768640/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1768640&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1768640/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1768640&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25297
+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 29077583" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24948
+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 29077583/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29077583&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29077583/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29077583&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24928
+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 29077583 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.49998273 43.51488371)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29077583 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.49998273 43.51488371)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29077583 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.49998273 43.51488371)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29077583 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.49998273 43.51488371)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25136
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24883
+post_id: "491212"
+post_author: 1
+"ListingKey": "29196287"
+"ListingId": "40794602"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-19T17:45:10Z"
+"RFModificationTimestamp": "2025-12-19T19:12:15Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1299.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3Y8"
+"UnparsedAddress": "540 MARINER Drive, Waterloo, Ontario N2K3Y8"
+"Coordinates": array:2 [
0 => -80.507857
1 => 43.5060424
]
+"Latitude": 43.5060424
+"Longitude": -80.507857
+"YearBuilt": 1997
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A Beautiful 3 bed , 3.5 bath Freehold Townhome backing on green space with fully finished basement available for sale in Eastbridge neighborhood of Waterloo! Upon entrance through the foyer, you will find open concept main floor with spacious kitchen featuring plenty of kitchen cabinets, breakfast bar, glass tile backsplash, a powder room and a bright and spacious living room. Second floor features a huge master bedroom with 4 pc ensuite bathroom and huge closet. 2 more good sized bedrooms with huge closets and another 4 pc family bathroom. Very spacious Fully finished basement with rec room and full bath. Total 2 parking spaces - Single car garage and an asphalt private single driveway. Recent upgrades- New Roof 2023, New kitchen countertops and kitchen Appliances, Attic insulation, All bathroom fixtures, Carpet, hardwood on main floor, All door hardware's, All lights and switches, New patio sliding door, New paint, new owned water heater, New owned water softener. Conveniently located close to public schools, short walk to bus stop, parks, few minutes drive to (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Central Vacuum"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"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": "2025-12-19T19:12:07.057125+00:00"
+"Directions": "Eastbridge Blvd. & Mariner Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2000528"
+"ListOfficeKey": "291992"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Backs on greenbelt"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"PhotosChangeTimestamp": "2025-12-19T17:38:21Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-19T17:38:21Z"
+"Stories": "2.0"
+"StreetName": "MARINER"
+"StreetNumber": "540"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3782.5"
+"Utilities": array:1 [
0 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/540_mariner_dr_waterloo_on"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1551359046"
"RoomType" => "3pc Bathroom"
"ListingId" => "40794602"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 4'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.79Z"
]
1 => array:11 [
"RoomKey" => "1551359047"
"RoomType" => "Utility room"
"ListingId" => "40794602"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "17'8'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.8Z"
]
2 => array:11 [
"RoomKey" => "1551359048"
"RoomType" => "Recreation room"
"ListingId" => "40794602"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "17'7'' x 17'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.8Z"
]
3 => array:11 [
"RoomKey" => "1551359049"
"RoomType" => "Full bathroom"
"ListingId" => "40794602"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "7'3'' x 4'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.8Z"
]
4 => array:11 [
"RoomKey" => "1551359050"
"RoomType" => "4pc Bathroom"
"ListingId" => "40794602"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "5'11'' x 8'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.8Z"
]
5 => array:11 [
"RoomKey" => "1551359051"
"RoomType" => "Primary Bedroom"
"ListingId" => "40794602"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 13'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.8Z"
]
6 => array:11 [
"RoomKey" => "1551359052"
"RoomType" => "Bedroom"
"ListingId" => "40794602"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.8Z"
]
7 => array:11 [
"RoomKey" => "1551359053"
"RoomType" => "Bedroom"
"ListingId" => "40794602"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.8Z"
]
8 => array:11 [
"RoomKey" => "1551359054"
"RoomType" => "2pc Bathroom"
"ListingId" => "40794602"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "4'10'' x 5'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.8Z"
]
9 => array:11 [
"RoomKey" => "1551359055"
"RoomType" => "Dining room"
"ListingId" => "40794602"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 6'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.8Z"
]
10 => array:11 [
"RoomKey" => "1551359056"
"RoomType" => "Kitchen"
"ListingId" => "40794602"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 8'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.8Z"
]
11 => array:11 [
"RoomKey" => "1551359057"
"RoomType" => "Living room"
"ListingId" => "40794602"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "13'8'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.8Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29196287/540-mariner-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "MD3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 22.0
+"AboveGradeFinishedArea": 1299
+"OriginalEntryTimestamp": "2025-12-19T17:38:21.77Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:41 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6376185255"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/296694bff407976861fb0d11cd606f0b.webp"
"MediaSize" => 71722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-296694bff407976861fb0d11cd606f0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6376185353"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/9dd3b2d32c6bbe44ee1f8a2db0c1b0d8.webp"
"MediaSize" => 152695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-9dd3b2d32c6bbe44ee1f8a2db0c1b0d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6376185431"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/0a6d2120f56dedc7ed0c30194f5c5d44.webp"
"MediaSize" => 44274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-0a6d2120f56dedc7ed0c30194f5c5d44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6376185499"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/5bb09d644bf73ec9c489d53a8e0d5486.webp"
"MediaSize" => 156296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-5bb09d644bf73ec9c489d53a8e0d5486.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6376185593"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/d2ba72414e903206c7f4fb6ae340112d.webp"
"MediaSize" => 66660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-d2ba72414e903206c7f4fb6ae340112d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6376185648"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/cb887d5b4f013ad61d0d43e16e9d3e92.webp"
"MediaSize" => 64046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-cb887d5b4f013ad61d0d43e16e9d3e92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6376185722"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/36e63400e33ab2f1cf3bf429fa7ba871.webp"
"MediaSize" => 42657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-36e63400e33ab2f1cf3bf429fa7ba871.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6376185832"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/d147e8aaac8416e38356bfbffa2c37ed.webp"
"MediaSize" => 50936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-d147e8aaac8416e38356bfbffa2c37ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6376185925"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/5abf518f8e8229b0c25da7920d2c1655.webp"
"MediaSize" => 59669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-5abf518f8e8229b0c25da7920d2c1655.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6376185975"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/dd90cfef6a5b560a4316dab25e37376f.webp"
"MediaSize" => 61090
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-dd90cfef6a5b560a4316dab25e37376f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6376186019"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/34e6c2cb90c6faaa567ec1f0c6827db7.webp"
"MediaSize" => 73626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-34e6c2cb90c6faaa567ec1f0c6827db7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6376186116"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/2504cecfcee8953a75c6a845160cb9f2.webp"
"MediaSize" => 56903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-2504cecfcee8953a75c6a845160cb9f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6376186216"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/eade8606003febb0dd1c27b6200a9100.webp"
"MediaSize" => 63348
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-eade8606003febb0dd1c27b6200a9100.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6376186298"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/1b42dd7b38d7e9b862177e0a812099c8.webp"
"MediaSize" => 66365
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-1b42dd7b38d7e9b862177e0a812099c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6376186389"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/277f5ab3878cd6a400dcf75ff3b3d6a4.webp"
"MediaSize" => 52039
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-277f5ab3878cd6a400dcf75ff3b3d6a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6376186468"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/b7925e8a7166dd94b8976d5b81f8ae81.webp"
"MediaSize" => 65111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-b7925e8a7166dd94b8976d5b81f8ae81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6376186481"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/a142e7799f2fede0f895cb4a25d4f084.webp"
"MediaSize" => 40375
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-a142e7799f2fede0f895cb4a25d4f084.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6376186571"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/afbec23426f442d93a443b25c733a99a.webp"
"MediaSize" => 48159
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-afbec23426f442d93a443b25c733a99a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6376186670"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/418016b08706b7a6e753583c29de4659.webp"
"MediaSize" => 50023
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-418016b08706b7a6e753583c29de4659.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6376186737"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/965d2f8894e5de52891ef3a6b112ba06.webp"
"MediaSize" => 39918
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-965d2f8894e5de52891ef3a6b112ba06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6376186833"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/3dd624a6897e44d73a033682b39430c2.webp"
"MediaSize" => 53224
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-3dd624a6897e44d73a033682b39430c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6376186885"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/8fa92e1c7c96b9fa20a792d2416052b6.webp"
"MediaSize" => 145441
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-8fa92e1c7c96b9fa20a792d2416052b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6376186931"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/0980291cb57a69c5972154ba41c90046.webp"
"MediaSize" => 64768
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-0980291cb57a69c5972154ba41c90046.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6376186943"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/52da065dc6e896bacbfe92dda9ebecfe.webp"
"MediaSize" => 152244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-52da065dc6e896bacbfe92dda9ebecfe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6376187027"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/4d7c56a237aef17f2b2c862ed05c031d.webp"
"MediaSize" => 63586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-4d7c56a237aef17f2b2c862ed05c031d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6376187075"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/2fd3ceb7f07a7202ab3cce51dbd50e71.webp"
"MediaSize" => 84178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-2fd3ceb7f07a7202ab3cce51dbd50e71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6376187117"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/ab866621b79d68334c4909536a204ca8.webp"
"MediaSize" => 51923
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-ab866621b79d68334c4909536a204ca8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6376187156"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/e862664c72d4c66a4b31b6d80d2f88bf.webp"
"MediaSize" => 163691
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-e862664c72d4c66a4b31b6d80d2f88bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6376187161"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/06b67f8f65851aa9d8e96ef4e837dd86.webp"
"MediaSize" => 33519
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-06b67f8f65851aa9d8e96ef4e837dd86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6376187212"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/a3ade0f378087e8ed088c0a96479e736.webp"
"MediaSize" => 54265
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-a3ade0f378087e8ed088c0a96479e736.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6376187266"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/32ec467fabb3a0c9bff744e096461b27.webp"
"MediaSize" => 64027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-32ec467fabb3a0c9bff744e096461b27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6376187298"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/af8cf6d06303964db9f45e932c6c273f.webp"
"MediaSize" => 54716
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-af8cf6d06303964db9f45e932c6c273f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6376187319"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/a7d12af88414ca9a4ba724b0dad1ff0f.webp"
"MediaSize" => 66533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-a7d12af88414ca9a4ba724b0dad1ff0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6376187334"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/d27772033aab8a93c31e43d77d98cb86.webp"
"MediaSize" => 53220
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-d27772033aab8a93c31e43d77d98cb86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6376187369"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/7b1c997d649d8288fe45ac0e3ff77f20.webp"
"MediaSize" => 63405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-7b1c997d649d8288fe45ac0e3ff77f20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6376187395"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/7ee0e032a174daafe460babbd6487fd5.webp"
"MediaSize" => 45352
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-7ee0e032a174daafe460babbd6487fd5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6376187410"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/9b0bd7c6d60bfebd73d7ee482851e4d0.webp"
"MediaSize" => 66724
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-9b0bd7c6d60bfebd73d7ee482851e4d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6376187426"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/2e24ba7fba0c77f937fc7998894ae746.webp"
"MediaSize" => 118378
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-2e24ba7fba0c77f937fc7998894ae746.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6376187442"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/391125a12eff3276fe81b40f52fc545a.webp"
"MediaSize" => 148367
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-391125a12eff3276fe81b40f52fc545a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6376187458"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/a3f4ea16e4d81a53a1feb96b7bcc5fb4.webp"
"MediaSize" => 48711
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-a3f4ea16e4d81a53a1feb96b7bcc5fb4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6376187473"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/a9ee9f0a566017ebf5967703c65463d9.webp"
"MediaSize" => 115512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-a9ee9f0a566017ebf5967703c65463d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
]
+"Member": array:1 [
0 => array:24 [
"MemberFullName" => "SURJIT PABLAY"
"MemberFirstName" => "SURJIT"
"MemberLastName" => "PABLAY"
"MemberMlsId" => "KWkw8668"
"OriginatingSystemName" => 26
"MemberKey" => "2000528"
"ModificationTimestamp" => "2025-12-11T01:31:28Z"
"MemberMiddleName" => "SAM"
"MemberStatus" => "Active"
"OfficeKey" => "291992"
"MemberAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"JobTitle" => "Broker of Record"
"MemberFax" => "519-744-1212"
"MemberCity" => "KITCHENER"
"MemberType" => "Broker"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "519-897-0863"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2015-11-20T14:24:00Z"
"MemberNationalAssociationId" => "1283131"
"OfficeNationalAssociationId" => "1407252"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "CENTURY 21 RIGHT TIME REAL ESTATE INC."
"OfficePhone" => "519-743-6666"
"OfficeMlsId" => "KW382"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "291992"
"ModificationTimestamp" => "2025-08-19T15:49:32Z"
"OfficeAddress1" => "UNIT 1 - 1770 KING STREET EAST"
"OfficeCity" => "KITCHENER"
"OfficePostalCode" => "N2G2P"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"OfficeFax" => "519-744-1212"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2022-01-24T14:34:00Z"
"OfficeNationalAssociationId" => "1407252"
"FranchiseNationalAssociationId" => "1205554"
"OfficeBrokerNationalAssociationId" => "1283131"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29196287')"
+"ID": "491212"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24881
+post_id: "487319"
+post_author: 1
+"ListingKey": "29192639"
+"ListingId": "40794242"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-17T21:15:21Z"
+"RFModificationTimestamp": "2025-12-17T22:55:16Z"
+"ListPrice": 419900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 854.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G5"
+"UnparsedAddress": "255 NORTHFIELD Drive E Unit# 407, Waterloo, Ontario N2K0G5"
+"Coordinates": array:2 [
0 => -80.5212228
1 => 43.511129
]
+"Latitude": 43.511129
+"Longitude": -80.5212228
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover modern living at its finest at Blackstone Condos in Waterloo East! Built in 2020, this stunning 2-bed, 2-bath unit offers over 850 sqft of open-concept space with 9' ceilings, large windows, and a private balcony that fills the home with beautiful natural light. The sleek kitchen features white cabinetry, quartz countertops, stainless steel appliances, and a subway tile backsplash, complemented by premium laminate flooring throughout. The spacious layout includes a primary bedroom with ensuite and a second bedroom with a nicely sized closet, plus in-suite laundry for added convenience. Enjoy upscale amenitiesfitness center, co-working space, event lounge, bike storage, and a rooftop terrace with BBQs, fire pit, and courtyard views. Steps to Browns Socialhouse, shops, transit, and minutes to St. Jacobs Market, trails, and highways. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "648"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-17T22:54:59.167978+00:00"
+"Directions": "Bridge St W and Northfield Dr E"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stucco"
2 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130012"
+"ListOfficeKey": "283981"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"PhotosChangeTimestamp": "2025-12-17T21:08:23Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-17T21:08:23Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3754"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1550530082"
"RoomType" => "4pc Bathroom"
"ListingId" => "40794242"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29192639"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T21:08:23.57Z"
]
1 => array:11 [
"RoomKey" => "1550530083"
"RoomType" => "Living room"
"ListingId" => "40794242"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29192639"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 19'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T21:08:23.57Z"
]
2 => array:11 [
"RoomKey" => "1550530084"
"RoomType" => "Bedroom"
"ListingId" => "40794242"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29192639"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T21:08:23.58Z"
]
3 => array:11 [
"RoomKey" => "1550530085"
"RoomType" => "4pc Bathroom"
"ListingId" => "40794242"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29192639"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T21:08:23.58Z"
]
4 => array:11 [
"RoomKey" => "1550530086"
"RoomType" => "Primary Bedroom"
"ListingId" => "40794242"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29192639"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T21:08:23.58Z"
]
5 => array:11 [
"RoomKey" => "1550530087"
"RoomType" => "Kitchen"
"ListingId" => "40794242"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29192639"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T21:08:23.59Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29192639/255-northfield-drive-e-unit-407-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:3 [
0 => "Alarm system"
1 => "Security system"
2 => "Smoke Detectors"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 854
+"OriginalEntryTimestamp": "2025-12-17T21:08:23.47Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29192639')"
+"ID": "487319"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24884
+post_id: "487320"
+post_author: 1
+"ListingKey": "29192761"
+"ListingId": "X12639498"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-17T21:55:21Z"
+"RFModificationTimestamp": "2025-12-17T22:39:26Z"
+"ListPrice": 419900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G5"
+"UnparsedAddress": "407 - 255 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0G5"
+"Coordinates": array:2 [
0 => -80.521297
1 => 43.510381
]
+"Latitude": 43.510381
+"Longitude": -80.521297
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Discover modern living at its finest at Blackstone Condos in Waterloo East! Built in 2020, this stunning 2-bed, 2-bath unit offers over 850 sqft of open-concept space with 9' ceilings, large windows, and a private balcony that fills the home with beautiful natural light. The sleek kitchen features white cabinetry, quartz countertops, stainless steel appliances, and a subway tile backsplash, complemented by premium laminate flooring throughout. The spacious layout includes a primary bedroom with ensuite and a second bedroom with a nicely sized closet, plus in-suite laundry for added convenience. Enjoy upscale amenitiesfitness center, co-working space, event lounge, bike storage, and a rooftop terrace with BBQs, fire pit, and courtyard views. Steps to Browns Socialhouse, shops, transit, and minutes to St. Jacobs Market, trails, and highwaysthis is contemporary comfort in the perfect location! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "648"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-17T22:39:25.446373+00:00"
+"Directions": "Bridge St W and Northfield Dr E"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1967928"
+"ListOfficeKey": "164016"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-17T21:48:46Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-17T21:48:46Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3754"
+"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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29192761/407-255-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Five Rivers Property Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Separate Heating Controls"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-12-17T21:48:46.68Z"
+"MapCoordinateVerifiedYN": false
+"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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29192761')"
+"ID": "487320"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24880
+post_id: "481615"
+post_author: 1
+"ListingKey": "29185243"
+"ListingId": "X12632142"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-13T20:35:04Z"
+"RFModificationTimestamp": "2025-12-13T22:47:01Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G5"
+"UnparsedAddress": "413 - 255 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0G5"
+"Coordinates": array:2 [
0 => -80.521297
1 => 43.510381
]
+"Latitude": 43.510381
+"Longitude": -80.521297
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "~ WELCOME TO BLACKSTONE CONDOS ~~ Stylish 1-Bedroom & 1 Bath Suite on the 4th Floor offering almost 600 SQFT with UNOBSTRUCTED 180 SKY VIEWS ~ enjoy your morning coffee or sunsets! Open-Concept Layout ~ Functional & Elegant Kitchen with Quartz Countertops, Subway Tile Backsplash, Stainless Steel Appliances & Undermount Sink Bright Living Area flowing seamlessly to Balcony Spacious Walk-In Closet + In-Suite Laundry + Front Hall Closet Modern 3-Pc Bath 1 Surface Parking Space Included~ LUXURY AMENITIES ~ Designer Lounge w/ Bar & Fireplace Fitness & Study Rooms Secure Bike Storage + Repair Station Pet Wash Station 2 Outdoor Lounges with BBQs & Hot Tub ~ Perfect for Entertaining!~ Bakery, Salon, Restaurants, Pub & Dental Office ~ All Just Steps Away!Minutes to Conestoga Mall, Public Library, RIM Park (sports & rec), Golf, Conservation Areas & Miles of Trails for Walking & Cycling. ~ Don't Miss This Opportunity! AVAILABLE IMMEDIATELY ~ (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-13T22:46:50.369270+00:00"
+"Directions": "Northfield & Bridge St W"
+"ExteriorFeatures": array:2 [
0 => "Steel"
1 => "Stone"
]
+"Flooring": array:2 [
0 => "Carpeted"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2088809"
+"ListOfficeKey": "293791"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Elevator"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-13T20:22:38Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-13T20:22:38Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"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"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29185243/413-255-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2156054"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "FIVE RIVERS PROPERTY MANAGEMENT GROUP INC."
+"CoListOfficeKey": "293791"
+"GeocodeManualYN": false
+"TotalActualRent": 1800
+"BuildingFeatures": array:5 [
0 => "Exercise Centre"
1 => "Separate Electricity Meters"
2 => "Separate Heating Controls"
3 => "Party Room"
4 => "Visitor Parking"
]
+"SecurityFeatures": array:3 [
0 => "Security system"
1 => "Smoke Detectors"
2 => "Controlled entry"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-12-13T20:22:38.4Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:37 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29185243')"
+"ID": "481615"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24882
+post_id: "478869"
+post_author: 1
+"ListingKey": "29183515"
+"ListingId": "X12630486"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-12T19:55:38Z"
+"RFModificationTimestamp": "2025-12-12T23:40:07Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H1"
+"UnparsedAddress": "415 - 247 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0H1"
+"Coordinates": array:2 [
0 => -80.521945
1 => 43.509547
]
+"Latitude": 43.509547
+"Longitude": -80.521945
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright and modern one-bedroom, one-bathroom corner unit on the 4th floor with large windows overlooking a serene landscaped courtyard. This stylish apartment features quality white cabinetry, sleek gray floors, in-unit laundry, and a private balcony. Located steps from a park with walking trails, a playground & a dog wash station, perfect for pet lovers and outdoor enthusiasts. Enjoy premium amenities, including a chic party room with a bar/lounge, a fitness room, a study/meeting room, an outdoor entertainment area & a rooftop terrace. Underground parking is included for your convenience. Easy access to the highway, RIM Park, Grey Silo Golf Club & more! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener remote(s)"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-12T23:39:50.467805+00:00"
+"Directions": "Cross Streets: Bridge St. W. ** Directions: Northfield E Drive and Bridge Street."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2101285"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2025-12-12T19:49:56Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-12T19:49:56Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "247"
+"StreetSuffix": "Drive"
+"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"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29183515/415-247-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Five River"
+"GeocodeManualYN": false
+"TotalActualRent": 1795
+"BuildingFeatures": array:2 [
0 => "Separate Electricity Meters"
1 => "Separate Heating Controls"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-12-12T19:49:56.83Z"
+"MapCoordinateVerifiedYN": false
+"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]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29183515')"
+"ID": "478869"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24887
+post_id: "477497"
+post_author: 1
+"ListingKey": "29183318"
+"ListingId": "40793559"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-12T19:10:22Z"
+"RFModificationTimestamp": "2025-12-12T19:37:27Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 644.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H1"
+"UnparsedAddress": "247 NORTHFIELD Drive E Unit# 415, Waterloo, Ontario N2K0H1"
+"Coordinates": array:2 [
0 => -80.5218345
1 => 43.5102257
]
+"Latitude": 43.5102257
+"Longitude": -80.5218345
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright and modern one-bedroom, one-bathroom corner unit on the 4th floor with large windows overlooking a serene landscaped courtyard. This stylish apartment features quality white cabinetry, sleek gray floors, in-unit laundry, and a private balcony. Located steps from a park with walking trails, a playground & a dog wash station, perfect for pet lovers and outdoor enthusiasts. Enjoy premium amenities, including a chic party room with a bar/lounge, a fitness room, a study/meeting room, an outdoor entertainment area & a rooftop terrace. Underground parking is included for your convenience. Easy access to the highway, RIM Park, Grey Silo Golf Club & more! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "521"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Exterior Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Heat"
4 => "Insurance"
5 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "High Traffic Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-12T19:37:13.615169+00:00"
+"Directions": "Northfield E Drive and Bridge Street"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564314"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Balcony"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2025-12-12T19:00:28Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-12T19:00:27Z"
+"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: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/29183318/247-northfield-drive-e-unit-415-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 1795
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 644
+"OriginalEntryTimestamp": "2025-12-12T19:00:27.37Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29183318')"
+"ID": "477497"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23526
+post_id: "475760"
+post_author: 1
+"ListingKey": "29179982"
+"ListingId": "40793510"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-19T21:15:32Z"
+"RFModificationTimestamp": "2025-12-19T21:17:01Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 835.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G5"
+"UnparsedAddress": "251 NORTHFIELD Drive Unit# 415B, Waterloo, Ontario N2K0G5"
+"Coordinates": array:2 [
0 => -80.5213246
1 => 43.5104707
]
+"Latitude": 43.5104707
+"Longitude": -80.5213246
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to the modern and sought after Blackstone Condos, inspired by Scandinavian living and located in Colonial Acres in North Waterloo! This beautiful open concept 2BR/2BA unit is in exceptional condition with several upgrades.\u{A0} The unit features high ceilings, spacious dining/living area with access to an oversized balcony.\u{A0} The kitchen has been upgraded with quality stainless steel appliances, quartz countertops, subway tile backsplash, tall dishwasher and double undermount stainless steel sink.. Extra upgrades with under the cabinets lights and media charging station. The primary bedroom has a very sizeable walk-in closet and the upgraded all around tiled ensuite.\u{A0} The second bedroom/bathroom can also function as a second suite. There is a lot being offered with the many community amenities, which include a fitness center, a firepit area, outdoor kitchens with BBQs, a co-working space, 1-dedicated underground parking space and a 2,000 sqft event room! The complex also offers bicycle storage, keyless entry, parking garage elevators, close to restaurants and convenience stores, shopping malls, highways, St. Jacobs Farmers Market, entertainment, and so much more! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"AssociationFeeIncludes": array:3 [
0 => "Property Management"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-11T19:29:10.453555+00:00"
+"Directions": "Northfield Dr E and Bridge St W"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2180308"
+"ListOfficeKey": "283397"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2025-12-11T16:41:05Z"
+"PhotosCount": 16
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-19T21:00:13Z"
+"Stories": "1.0"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "251"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"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/29179982/251-northfield-drive-unit-415b-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2100
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 835
+"OriginalEntryTimestamp": "2025-12-11T16:38:17.64Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29179982')"
+"ID": "475760"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24879
+post_id: "473825"
+post_author: 1
+"ListingKey": "29177727"
+"ListingId": "40793297"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-19T05:40:46Z"
+"RFModificationTimestamp": "2025-12-19T05:42:36Z"
+"ListPrice": 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# 51, Waterloo, Ontario N2K0E9"
+"Coordinates": array:2 [
0 => -80.4951779
1 => 43.5235489
]
+"Latitude": 43.5235489
+"Longitude": -80.4951779
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this luxury Trailside Townhome located in the highly sought-after Carriage Crossing community in Waterloo! Enjoy a maintenance-free lifestyle with lawn care, landscaping, and snow removal included. This modern and elegant 4-bedroom, 4-bathroom home offers a double car garage and exceptional finishes throughout. The main floor provides a versatile office/bedroom complete with a stunning 3-piece ensuite featuring a quartz vanity and sleek tiled shower. The second level showcases an open-concept layout with a gourmet kitchen boasting an island, quartz countertops, stainless steel appliances, and a spacious walk-in pantry/storage. The adjoining great room and dining area feature warm hardwood flooring, along with a convenient 2-piece powder room and access to a balcony. On the third level, the primary bedroom offers a walk-in closet and a beautifully designed ensuite with tiled shower and quartz vanity. Two additional bedrooms share a stylish 4-piece bathroom. The upper-level laundry adds convenience, plus a second balcony for outdoor enjoyment. Situated just steps from the Walter Bean Trail, Grand River, RIM Park, Grey Silo Golf Course, and close to Conestoga Mall, Conestoga College, and University of Waterloo—this home provides an unbeatable lifestyle with easy access to premium amenities and top-rated schools. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-10T19:52:20.050381+00:00"
+"Directions": "Millennium to Crossgate"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2218013"
+"ListOfficeKey": "289539"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2025-12-10T19:31:02Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-19T05:29:47Z"
+"Stories": "3.0"
+"StreetName": "GREY SILO"
+"StreetNumber": "271"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "6247"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29177727/271-grey-silo-road-unit-51-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 3150
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "R9"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1836
+"OriginalEntryTimestamp": "2025-12-10T19:08:37.09Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:21 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29177727')"
+"ID": "473825"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24752
+post_id: "473700"
+post_author: 1
+"ListingKey": "29177287"
+"ListingId": "40793254"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-19T15:45:30Z"
+"RFModificationTimestamp": "2025-12-19T15:54:28Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1580.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3S4"
+"UnparsedAddress": "465 WOOLWICH Street N Unit# 17, Waterloo, Ontario N2K3S4"
+"Coordinates": array:2 [
0 => -80.4926409
1 => 43.4994817
]
+"Latitude": 43.4994817
+"Longitude": -80.4926409
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome home to unit 17 at 465 Woolwich St N., Waterloo. This bright condo townhome is situated close to Kaufman Flats and the Grand River, RIM Park, Kiwanis Park, steps to trails, public transit, shopping, highway 85 and so much more! Step inside the foyer and see the flood of natural light that comes through the main floor. This main floor has a nice sized eating area just off the galley kitchen. The living room is a nice size, with access to the deck and green views from your patio doors. Recently replaced deck. Upstairs you will find 3 bedrooms and a 4 pc bath. The fully finished basement is a bonus space with a rec room w. fireplace. There is a 3 pc bath on this level, laundry, and plenty of storage. This is a very well managed complex which is evident from the well maintained grounds, parking and buildings. Enjoy the private garbage pickup right at your front door! (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFee": "450.59"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-10T19:03:40.375141+00:00"
+"Directions": "University Ave to Woolwich St N"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908292"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2025-12-19T15:38:57Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-19T15:38:57Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "WOOLWICH"
+"StreetNumber": "465"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "3195.33"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29177287/465-woolwich-street-n-unit-17-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1065
+"BelowGradeFinishedArea": 515
+"OriginalEntryTimestamp": "2025-12-10T17:38:30.48Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:22 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29177287')"
+"ID": "473700"
}
]
+success: true
+page_size: 9
+page_count: 8
+count: 64
+after_key: ""
}
"RF Response Time" => "0.4 seconds"
]
]