array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29145430/Property?$select=ALL&$top=20&$filter=ListingKey eq 29145430&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29145430/Property?$select=ALL&$top=20&$filter=ListingKey eq 29145430&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23312
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23314
+post_id: "450780"
+post_author: 1
+"ListingKey": "29145430"
+"ListingId": "X12584700"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-28T18:45:34Z"
+"RFModificationTimestamp": "2025-11-28T18:50:17Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2Y2"
+"UnparsedAddress": "307 - 158 KING STREET, Waterloo, Ontario N2J2Y2"
+"Coordinates": array:2 [
0 => -80.523574
1 => 43.471807
]
+"Latitude": 43.471807
+"Longitude": -80.523574
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Spacious 773 sq. ft. corner unit featuring 2 bedrooms, an impressive west-facing view, modernfinishes, 9 ft. ceilings, and quality laminate and tile flooring. The open-concept contemporarykitchen enhances the bright, functional layout. Ideally located within walking distance to theUniversity of Waterloo, Wilfrid Laurier University, and Uptown Waterloo, with convenient busstops right at the building's doorstep. Excellent Place to live - this property is a must-see! Tenant occupied property, so will require prior notice before showing. SELLER IS WILLING TO OFFER 5% DOWN PAYMENT TO FIRST TIME HOME BUYERS OR SIMILAR COMPENSATION TO INVESTOR . (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "492.2"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Pets not Allowed"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-28T16:40:55.218987+00:00"
+"Directions": "UNIVERSITY AVE/KING ST N"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2243854"
+"ListOfficeKey": "293109"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-28T16:02:38Z"
+"PhotosCount": 15
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-28T18:33:14Z"
+"StreetName": "King"
+"StreetNumber": "158"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3523.06"
+"Rooms": array:1 [
0 => array:11 [
"RoomKey" => "1541531912"
"RoomType" => "Bedroom"
"ListingId" => "X12584700"
"RoomLevel" => "Main level"
"RoomWidth" => 2.5
"ListingKey" => "29145430"
"RoomLength" => 5.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-28T18:33:14.79Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29145430/307-158-king-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Grand River Property Management (519-778-5986)"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-11-28T16:02:38.75Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:15 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6344399795"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/8581e47275d0ff95d0233b18fa918c7b.webp"
"MediaSize" => 89594
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-8581e47275d0ff95d0233b18fa918c7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6344399814"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/a1ced41b76d6dbce04f71581c7d0b516.webp"
"MediaSize" => 122849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-a1ced41b76d6dbce04f71581c7d0b516.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6344399820"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/00a5108507f29e8fc84f2a9c7ab2c03a.webp"
"MediaSize" => 101111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-00a5108507f29e8fc84f2a9c7ab2c03a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6344399876"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/9899ce9a3b6e2a656cfa13d3a4ca761c.webp"
"MediaSize" => 89176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-9899ce9a3b6e2a656cfa13d3a4ca761c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6344399945"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/94d1a6e098fc04281144ed0bdaa782b2.webp"
"MediaSize" => 71767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-94d1a6e098fc04281144ed0bdaa782b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6344399970"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/b18299daf0434f0bc55025efe6d9a0a0.webp"
"MediaSize" => 88078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-b18299daf0434f0bc55025efe6d9a0a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6344400033"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/3c5878eaf736de80954f0aaf2a569247.webp"
"MediaSize" => 115006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-3c5878eaf736de80954f0aaf2a569247.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6344400068"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/ff9f4ccc4b686125bb4035e94350b13f.webp"
"MediaSize" => 139201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-ff9f4ccc4b686125bb4035e94350b13f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6344400100"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/7f059034b82b8c253452473b6144361d.webp"
"MediaSize" => 91064
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-7f059034b82b8c253452473b6144361d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6344400151"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/a1f9c2124a512a8a71642f16b4cd8a89.webp"
"MediaSize" => 221508
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-a1f9c2124a512a8a71642f16b4cd8a89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6344400192"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/062ab756708fdcb935ff1d4025211810.webp"
"MediaSize" => 69232
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-062ab756708fdcb935ff1d4025211810.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6344400214"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/1cc5265d11a531569f8eccb28958a39d.webp"
"MediaSize" => 205567
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-1cc5265d11a531569f8eccb28958a39d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6344400237"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/53e9cf7873af8391159628f6dc114ae0.webp"
"MediaSize" => 83717
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-53e9cf7873af8391159628f6dc114ae0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6344400340"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/d293b8469761d230ceb57d897abaf799.webp"
"MediaSize" => 131319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-d293b8469761d230ceb57d897abaf799.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6344400353"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29145430/68301e4df1bf1f47c3789d3a27b3714d.webp"
"MediaSize" => 72040
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29145430/thumbnail-68301e4df1bf1f47c3789d3a27b3714d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12584700"
"ResourceRecordKey" => "29145430"
"ModificationTimestamp" => "2025-11-28T16:02:38.76Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29145430')"
+"ID": "450780"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 293109/Office?$select=ALL&$top=10&$filter=OfficeKey eq 293109&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 293109/Office?$select=ALL&$top=10&$filter=OfficeKey eq 293109&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25115
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25117
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": null
+"OfficeEmail": null
+"OfficePhone": null
+"OfficeMlsId": "293109"
+"ModificationTimestamp": "2024-10-16T00:44:13Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "293109"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": null
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": null
+"OfficePostalCode": null
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": null
+"OfficeStatus": null
+"OfficeAOR": null
+"OfficeType": null
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": null
+"OriginalEntryTimestamp": null
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('293109')"
+"Media": []
}
]
+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 2243854/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2243854&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2243854/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2243854&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25112
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25120
+post_id: ? mixed
+post_author: ? mixed
+"MemberMlsId": "2243854"
+"ModificationTimestamp": "2025-11-28T16:40:49Z"
+"OriginatingSystemName": "CREA"
+"MemberKey": "2243854"
+"MemberPreferredPhoneExt": null
+"MemberMlsSecurityClass": null
+"MemberNationalAssociationId": null
+"MemberAddress1": null
+"MemberType": null
+"MemberDesignation": null
+"MemberCity": null
+"MemberStateOrProvince": null
+"MemberPostalCode": null
+"OriginalEntryTimestamp": null
+"MemberOfficePhone": null
+"MemberOfficePhoneExt": null
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Member('2243854')"
+"Media": []
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29145430" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24730
+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 29145430/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29145430&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29145430/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29145430&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24710
+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 29145430 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.523574 43.471807)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29145430 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.523574 43.471807)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29145430 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.523574 43.471807)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29145430 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.523574 43.471807)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24986
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24999
+post_id: "455825"
+post_author: 1
+"ListingKey": "29152788"
+"ListingId": "40791585"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-01T22:16:03Z"
+"RFModificationTimestamp": "2025-12-01T22:47:17Z"
+"ListPrice": 480900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 842.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0G3"
+"UnparsedAddress": "107 ROGER Street Unit# 516, Waterloo, Ontario N2J0G3"
+"Coordinates": array:2 [
0 => -80.5092707
1 => 43.4606278
]
+"Latitude": 43.4606278
+"Longitude": -80.5092707
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to urban living at its finest! This modern 2-bedroom, 1-bathroom condo with UNDERGROUND PARKING is ideally situated in Uptown Waterloo, placing you steps from everything the city has to offer. Whether you're heading to the universities, hopping on the LRT, dining out at local restaurants, or exploring downtown Kitchener, you'll love the unbeatable convenience of this prime location. Enjoy easy access to the Spur Line Trail, Grand River Hospital, and nearby shops-all just minutes from your front door. Inside, this bright and airy unit features large, beautiful windows that fill the space with natural light, complementing the sleek grey vinyl plank flooring throughout. The kitchen boasts concrete-inspired quartz countertops bringing a contemporary, urban feel to the space while providing the easy care and resilience quartz is known for. Both bedrooms come equipped with walk-in closets, providing ample storage and comfort. Step outside to your private balcony, perfect for morning coffee or relaxing after a long day. Whether you're a first-time buyer, downsizing, or investing in one of Waterloo's most desirable communities, this condo checks every box. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "458.35"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-01T22:46:54.391176+00:00"
+"Directions": "Moore Ave S & Roger St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1960561"
+"ListOfficeKey": "289792"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Covered"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2025-12-01T22:11:45Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-01T22:11:45Z"
+"Stories": "1.0"
+"StreetName": "ROGER"
+"StreetNumber": "107"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"VirtualTourURLUnbranded": "https://youtu.be/n6AdpUGq5ig"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1543348712"
"RoomType" => "Laundry room"
"ListingId" => "40791585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29152788"
"RoomLength" => null
"RoomDimensions" => "6'7'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T22:08:41.53Z"
]
1 => array:11 [
"RoomKey" => "1543348713"
"RoomType" => "Kitchen"
"ListingId" => "40791585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29152788"
"RoomLength" => null
"RoomDimensions" => "15'11'' x 18'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T22:08:41.54Z"
]
2 => array:11 [
"RoomKey" => "1543348714"
"RoomType" => "4pc Bathroom"
"ListingId" => "40791585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29152788"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 8'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T22:08:41.55Z"
]
3 => array:11 [
"RoomKey" => "1543348715"
"RoomType" => "Bedroom"
"ListingId" => "40791585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29152788"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T22:08:41.55Z"
]
4 => array:11 [
"RoomKey" => "1543348716"
"RoomType" => "Primary Bedroom"
"ListingId" => "40791585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29152788"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T22:08:41.55Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29152788/107-roger-street-unit-516-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "GR1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 842
+"OriginalEntryTimestamp": "2025-12-01T22:08:41.42Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:42 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6350559025"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/12b6c40378b9de456cf5a5c67aaf4e8c.webp"
"MediaSize" => 100588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-12b6c40378b9de456cf5a5c67aaf4e8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:41.05Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6350559091"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/4aa7d6f2a53de9d1c515db4bb62f53b6.webp"
"MediaSize" => 69436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-4aa7d6f2a53de9d1c515db4bb62f53b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:41.01Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6350559140"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/4d6ff3a929480217c578a30a583e4ec0.webp"
"MediaSize" => 56134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-4d6ff3a929480217c578a30a583e4ec0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:42.3Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6350559175"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/4ffdab7dab4c0c54246bab1470f84011.webp"
"MediaSize" => 84879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-4ffdab7dab4c0c54246bab1470f84011.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:39.8Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6350559230"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/0dde6e6afa5fcd022a30576d070dbc29.webp"
"MediaSize" => 46132
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-0dde6e6afa5fcd022a30576d070dbc29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:39.78Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6350559252"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/50338752889204a23d18e51edd0dd0db.webp"
"MediaSize" => 40235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-50338752889204a23d18e51edd0dd0db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:42.29Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6350559312"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/9d9a39f77901cf192d42c0d52ef91bed.webp"
"MediaSize" => 100801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-9d9a39f77901cf192d42c0d52ef91bed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:42.29Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6350559338"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/16dcf7bf9f7bd5701e2caea75de38511.webp"
"MediaSize" => 62655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-16dcf7bf9f7bd5701e2caea75de38511.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:41.02Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6350559390"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/290bd7d330bdf7e01bf8696e0753c188.webp"
"MediaSize" => 67577
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-290bd7d330bdf7e01bf8696e0753c188.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:39.78Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6350559440"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/ca500066e04f681d87dd1abcb0249edd.webp"
"MediaSize" => 174333
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-ca500066e04f681d87dd1abcb0249edd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:41.02Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6350559519"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/2852725ae412ed0d14862375ca97a4eb.webp"
"MediaSize" => 72754
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-2852725ae412ed0d14862375ca97a4eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:41.02Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6350559583"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/2da55b01db9bb0116efb810ef895a5a7.webp"
"MediaSize" => 66742
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-2da55b01db9bb0116efb810ef895a5a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:39.79Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6350559604"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/a8f03ca5b7952f53577939c6b29cc0a4.webp"
"MediaSize" => 90632
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-a8f03ca5b7952f53577939c6b29cc0a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:41.01Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6350559660"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/0c2b8450def90c88e3d41874a79dea0a.webp"
"MediaSize" => 79273
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-0c2b8450def90c88e3d41874a79dea0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:41.07Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6350559686"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/06e15631e8982a34c9741a446602d048.webp"
"MediaSize" => 76942
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-06e15631e8982a34c9741a446602d048.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:41.03Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6350559701"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/72cf4b72f1d48128377fdb9d2c4147bd.webp"
"MediaSize" => 187539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-72cf4b72f1d48128377fdb9d2c4147bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:41.05Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6350559745"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/e6b9f2676803409ba3940e3a233ddbd0.webp"
"MediaSize" => 80240
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-e6b9f2676803409ba3940e3a233ddbd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:41.02Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6350559774"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/cc01a89eee2586e0e4e90e66c49008c7.webp"
"MediaSize" => 144328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-cc01a89eee2586e0e4e90e66c49008c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:39.79Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6350559794"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/c93a6c347738f11070dd42ca58307724.webp"
"MediaSize" => 132426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-c93a6c347738f11070dd42ca58307724.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:42.29Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6350559853"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/cc52d0c1829cea5e8ec6291a452480cd.webp"
"MediaSize" => 48431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-cc52d0c1829cea5e8ec6291a452480cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:41.08Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6350559863"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/63f12b25da3a8bb27b2b25b0c52930db.webp"
"MediaSize" => 85725
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-63f12b25da3a8bb27b2b25b0c52930db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:41.05Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6350559891"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/66b06d682b2eeb84fa8ecebd2aefd345.webp"
"MediaSize" => 38306
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-66b06d682b2eeb84fa8ecebd2aefd345.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:41.02Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6350559917"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/2a2bc514a0c06bc63f7b50165ff8d90c.webp"
"MediaSize" => 85714
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-2a2bc514a0c06bc63f7b50165ff8d90c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:42.34Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6350559925"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/8d73bab6cc4fac170d994127dec7242a.webp"
"MediaSize" => 66268
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-8d73bab6cc4fac170d994127dec7242a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:41.08Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6350559950"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/aa87975d5a527bfae5fee49d66b188ee.webp"
"MediaSize" => 192841
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-aa87975d5a527bfae5fee49d66b188ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:41.05Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6350559980"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/ec3bdcb6f0f286d7f4aeed25afb0b620.webp"
"MediaSize" => 196894
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-ec3bdcb6f0f286d7f4aeed25afb0b620.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:42.29Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6350560013"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/9309d7852ee144c036865b01aaf55c66.webp"
"MediaSize" => 76566
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-9309d7852ee144c036865b01aaf55c66.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:41.02Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6350560037"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/fc7bdf54ffbeb9b08201252bf0d7ec62.webp"
"MediaSize" => 128739
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-fc7bdf54ffbeb9b08201252bf0d7ec62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:42.29Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6350560046"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/5536c314ffcf18604e1902da8dcf5a00.webp"
"MediaSize" => 48026
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-5536c314ffcf18604e1902da8dcf5a00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:39.8Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6350560071"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/61463742f5456749b75af9a181f80a22.webp"
"MediaSize" => 84425
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-61463742f5456749b75af9a181f80a22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:39.78Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6350560098"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/a9291d8f3dd5256efc3be1d913a947f7.webp"
"MediaSize" => 89386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-a9291d8f3dd5256efc3be1d913a947f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:42.34Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6350560125"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/fd455b84af3ebec5f9d2c163148ef15f.webp"
"MediaSize" => 57297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-fd455b84af3ebec5f9d2c163148ef15f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:45.44Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6350560152"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/303df3771f000a4de3a581a031ae318f.webp"
"MediaSize" => 57866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-303df3771f000a4de3a581a031ae318f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:41.07Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6350560170"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/0812a04519597b997bdeb798aa129533.webp"
"MediaSize" => 57459
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-0812a04519597b997bdeb798aa129533.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:41.05Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6350560186"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/630e0edd3a418aa6bb7e7e89c5f11519.webp"
"MediaSize" => 199979
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-630e0edd3a418aa6bb7e7e89c5f11519.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:41.02Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6350560204"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/21b2ac75c2b328be82abe5d9bcc2bb4a.webp"
"MediaSize" => 57669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-21b2ac75c2b328be82abe5d9bcc2bb4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:42.29Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6350560219"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/02eb95647c2af319c6be444e36603426.webp"
"MediaSize" => 55798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-02eb95647c2af319c6be444e36603426.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:41.01Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6350560239"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/b4eca5affbf975f2d19b96859f8e13ed.webp"
"MediaSize" => 125870
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-b4eca5affbf975f2d19b96859f8e13ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:45.45Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6350560258"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/5fcd8f5da8a19521ab733a6054829fa9.webp"
"MediaSize" => 72618
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-5fcd8f5da8a19521ab733a6054829fa9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:41.02Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6350560290"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/dc69e8a73c748943f96c0f291cb588cb.webp"
"MediaSize" => 117603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-dc69e8a73c748943f96c0f291cb588cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:39.79Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6350560303"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/9c5d6df16eea3a37a50c5473cc6a6abe.webp"
"MediaSize" => 28920
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-9c5d6df16eea3a37a50c5473cc6a6abe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:42.29Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6350560314"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152788/54e56a8195727eb2eb3815716d15c17d.webp"
"MediaSize" => 114848
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152788/thumbnail-54e56a8195727eb2eb3815716d15c17d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791585"
"ResourceRecordKey" => "29152788"
"ModificationTimestamp" => "2025-12-01T22:11:41.03Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29152788')"
+"ID": "455825"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24597
+post_id: "455575"
+post_author: 1
+"ListingKey": "29152156"
+"ListingId": "40791360"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-01T20:26:00Z"
+"RFModificationTimestamp": "2025-12-01T21:06:42Z"
+"ListPrice": 550000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1934.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J1N7"
+"UnparsedAddress": "278 ERB Street E, Waterloo, Ontario N2J1N7"
+"Coordinates": array:2 [
0 => -80.4999008
1 => 43.4718812
]
+"Latitude": 43.4718812
+"Longitude": -80.4999008
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This well maintained 1,934 sq ft home, with over $50,000 in recent updates, features a detached garage, five bedrooms, and brand new stainless steel appliances. The entire home has been freshly painted, updated with new light fixtures throughout, and finished with new basement carpet in 2025. The layout is versatile and functional across three levels. On the main floor, you’ll find a bright living area, 2 comfortable bedrooms, and an updated 2-piece powder room with quartz counters. The kitchen has been refreshed with quartz countertops, a modern glass tile backsplash, a built in microwave, and the 2025 stainless steel appliance package. A window over the sink overlooks the large backyard, and the dining area opens directly to the back deck, perfect for outdoor meals in warmer months. Upstairs, 2 additional bedrooms, including the primary, share a modern 4-piece bathroom finished with quartz counters and a large vessel sink. Head downstairs on the brand new plush carpet to a cozy rec room and a 5th bedroom. This level offers excellent flexibility, whether you envision a home gym, office, kids playroom, movie room, or even the foundation for a future in law suite. A large utility and laundry room, storage room, and cold cellar complete the space. Outside, the detached garage adds parking, storage, or workshop potential. The generous backyard is ideal for families, pets, gardening, or simply relaxing. With close proximity to Highway 85, commuting is easy. The Breithaupt Centre offers community programs and amenities, while Breithaupt Park provides expansive trails to explore. Groceries and essentials are nearby at Bridgeport Plaza, and uptown Waterloo’s shops and restaurants are just minutes away. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-01T21:06:35.396131+00:00"
+"Directions": "Erb St East and Bluevale St N"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1992008"
+"ListOfficeKey": "289848"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2025-12-01T20:18:45Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-01T20:18:45Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "ERB"
+"StreetNumber": "278"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "4233.13"
+"VirtualTourURLUnbranded": "https://youriguide.com/278_erb_st_e_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1543292582"
"RoomType" => "Storage"
"ListingId" => "40791360"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29152156"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:45.8Z"
]
1 => array:11 [
"RoomKey" => "1543292583"
"RoomType" => "Laundry room"
"ListingId" => "40791360"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29152156"
"RoomLength" => null
"RoomDimensions" => "26'0'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:45.8Z"
]
2 => array:11 [
"RoomKey" => "1543292584"
"RoomType" => "Bedroom"
"ListingId" => "40791360"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29152156"
"RoomLength" => null
"RoomDimensions" => "17'2'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:45.8Z"
]
3 => array:11 [
"RoomKey" => "1543292585"
"RoomType" => "Recreation room"
"ListingId" => "40791360"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29152156"
"RoomLength" => null
"RoomDimensions" => "16'6'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:45.8Z"
]
4 => array:11 [
"RoomKey" => "1543292586"
"RoomType" => "4pc Bathroom"
"ListingId" => "40791360"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29152156"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:45.8Z"
]
5 => array:11 [
"RoomKey" => "1543292587"
"RoomType" => "Bedroom"
"ListingId" => "40791360"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29152156"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:45.8Z"
]
6 => array:11 [
"RoomKey" => "1543292588"
"RoomType" => "Primary Bedroom"
"ListingId" => "40791360"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29152156"
"RoomLength" => null
"RoomDimensions" => "17'9'' x 17'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:45.8Z"
]
7 => array:11 [
"RoomKey" => "1543292589"
"RoomType" => "2pc Bathroom"
"ListingId" => "40791360"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29152156"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 5'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:45.81Z"
]
8 => array:11 [
"RoomKey" => "1543292590"
"RoomType" => "Bedroom"
"ListingId" => "40791360"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29152156"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:45.81Z"
]
9 => array:11 [
"RoomKey" => "1543292591"
"RoomType" => "Bedroom"
"ListingId" => "40791360"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29152156"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:45.81Z"
]
10 => array:11 [
"RoomKey" => "1543292592"
"RoomType" => "Dining room"
"ListingId" => "40791360"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29152156"
"RoomLength" => null
"RoomDimensions" => "7'4'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:45.81Z"
]
11 => array:11 [
"RoomKey" => "1543292593"
"RoomType" => "Kitchen"
"ListingId" => "40791360"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29152156"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:45.81Z"
]
12 => array:11 [
"RoomKey" => "1543292594"
"RoomType" => "Living room"
"ListingId" => "40791360"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29152156"
"RoomLength" => null
"RoomDimensions" => "21'2'' x 13'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:45.81Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29152156/278-erb-street-e-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1992003"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1565504"
+"CoListOfficeKey": "86262"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "86262"
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 61.0
+"AboveGradeFinishedArea": 1531
+"BelowGradeFinishedArea": 403
+"OriginalEntryTimestamp": "2025-12-01T20:18:45.75Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"Media": array:30 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6350367935"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152156/d9ba440361155b604faaaf3e0ce07160.webp"
"MediaSize" => 46707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152156/thumbnail-d9ba440361155b604faaaf3e0ce07160.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791360"
"ResourceRecordKey" => "29152156"
"ModificationTimestamp" => "2025-12-01T20:18:45.76Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6350368001"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152156/bfeef165701fe99700ab519e4597dc41.webp"
"MediaSize" => 47520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152156/thumbnail-bfeef165701fe99700ab519e4597dc41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791360"
"ResourceRecordKey" => "29152156"
"ModificationTimestamp" => "2025-12-01T20:18:45.76Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6350368022"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152156/d51aa0d3974f5e606d5d272991f70ac7.webp"
"MediaSize" => 80652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152156/thumbnail-d51aa0d3974f5e606d5d272991f70ac7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791360"
"ResourceRecordKey" => "29152156"
"ModificationTimestamp" => "2025-12-01T20:18:45.76Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6350368107"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152156/95ab52be4ff01379863e2394012e7fa6.webp"
"MediaSize" => 125512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152156/thumbnail-95ab52be4ff01379863e2394012e7fa6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791360"
"ResourceRecordKey" => "29152156"
"ModificationTimestamp" => "2025-12-01T20:18:45.76Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6350368163"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152156/b2f824c46401c8a8f2696142253b63d4.webp"
"MediaSize" => 94249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152156/thumbnail-b2f824c46401c8a8f2696142253b63d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40791360"
"ResourceRecordKey" => "29152156"
"ModificationTimestamp" => "2025-12-01T20:18:45.76Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6350368262"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152156/49c2585007c1706ed5a8cc4b9410c1c1.webp"
"MediaSize" => 59287
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152156/thumbnail-49c2585007c1706ed5a8cc4b9410c1c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791360"
"ResourceRecordKey" => "29152156"
"ModificationTimestamp" => "2025-12-01T20:18:45.76Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6350368293"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152156/c31472ae8554e946d560fbadc9f87961.webp"
"MediaSize" => 58128
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152156/thumbnail-c31472ae8554e946d560fbadc9f87961.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
…4
]
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29152156')"
+"ID": "455575"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24648
+post_id: "455365"
+post_author: 1
+"ListingKey": "29151877"
+"ListingId": "40791582"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-01T19:46:13Z"
+"RFModificationTimestamp": "2025-12-01T20:30:58Z"
+"ListPrice": 850000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1141.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2M2T9"
+"UnparsedAddress": "2 ESSON Street, Kitchener, Ontario N2M2T9"
+"Coordinates": array:2 [
0 => -80.5188053
1 => 43.4558943
]
+"Latitude": 43.4558943
+"Longitude": -80.5188053
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to your new home in the heart of Belmont Village! Backing onto the scenic Iron Horse Trail, this beautifully renovated property offerstwo spacious bedrooms, two full modern bathrooms, and a versatile loft, perfect for a home office, guest room, or creative space. Extensiverenovations were completed in 2023, including all new wiring, plumbing, insulation, central AC, appliances, and windows. Essentially, it’s abrand-new home on the inside, with a stylish, contemporary design and thoughtful upgrades throughout. The inviting living room sets a warmand welcoming tone, while the kitchen is a chef’s dream, featuring sleek cabinetry, ample counter space, and top-of-the-line stainless steelappliances. The primary suite boasts a luxurious ensuite bathroom, while the second bedroom and full bath provide comfort and convenience forfamily or guests. Upstairs, the loft adds flexibility to suit your lifestyle. Step outside to your private patio and enjoy peaceful views of the IronHorse Trail, ideal for your morning coffee or evening glass of wine. Located just steps from the shops, cafés, and restaurants of Belmont Village,and a short walk to Uptown Waterloo, this home blends urban living with natural surroundings. Additional highlights include new blindsthroughout, a reverse osmosis water treatment system, parking for two vehicles, and abundant storage in the basement. Don’t miss your chanceto own this exceptional, fully renovated home in one of the region’s most sought-after communities! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-01T20:30:51.091982+00:00"
+"Directions": "Corner of Union and Esson"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1777545"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Sump Pump"
]
+"PhotosChangeTimestamp": "2025-12-01T19:38:44Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-01T19:38:44Z"
+"Stories": "1.5"
+"StreetName": "ESSON"
+"StreetNumber": "2"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "4843"
+"VirtualTourURLUnbranded": "https://youriguide.com/2_esson_st_kitchener_on/"
+"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/29151877/2-esson-street-kitchener"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 106.0
+"AboveGradeFinishedArea": 920
+"BelowGradeFinishedArea": 221
+"OriginalEntryTimestamp": "2025-12-01T19:38:44.28Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29151877')"
+"ID": "455365"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24989
+post_id: "454669"
+post_author: 1
+"ListingKey": "29150063"
+"ListingId": "40791159"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-01T13:35:16Z"
+"RFModificationTimestamp": "2025-12-01T17:43:38Z"
+"ListPrice": 450000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1119.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4T3"
+"UnparsedAddress": "55 BLUE SPRINGS Drive Unit# 706, Waterloo, Ontario N2J4T3"
+"Coordinates": array:2 [
0 => -80.5225571
1 => 43.4871516
]
+"Latitude": 43.4871516
+"Longitude": -80.5225571
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover tranquil, sophisticated condo living at The Atriums. Nestled in a peaceful setting, you are surrounded by scenic trails yet minutes from major conveniences: Conestoga Mall, the LRT, prestigious Universities, and quick access to the expressway. This unit is a stunningly updated, bright, and spacious retreat. The gorgeous open-concept kitchen anchors the living space, featuring quartz counters, a tiled backsplash, built-in pantry, oversized pot drawers, soft-close cabinets, and high-end stainless steel appliances. Modern flooring, contemporary fixtures, and designer decor elevate the entire unit. Enjoy an abundance of natural light and wonderful forest views through the large windows. This sought-after unit offers 2 bedrooms, 2 full updated bathrooms, convenient in-suite laundry, and a storage locker. A rare find, it includes TWO owned parking spaces! Upgrades abound, including new laminate flooring and LED pot lights throughout. The expansive living/dining area is perfect for entertaining and family gatherings. The primary bedroom boasts an updated 4-piece ensuite and a double closet walk-through. The building's amenities enhance your lifestyle: controlled entry, library, workshop, underground parking, bicycle storage, a fantastic rooftop lounge/sun deck, two party rooms with full facilities, and a dedicated Guest Suite for visitors. Don't miss out on this exceptional opportunity! Call your agent today to schedule your private viewing. Note some photos are virtually staged. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "730.84"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-01T17:43:24.616911+00:00"
+"Directions": "King St N to Blue Springs Dr, turn right into ""The Atriums"", visitor parking is above the parking garage (stay right). From the parking lot, take the stairs down to the main front entrance."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564578"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Visual exposure"
1 => "Paved driveway"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Covered"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2025-12-01T13:29:27Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-01T13:29:27Z"
+"Stories": "1.0"
+"StreetName": "BLUE SPRINGS"
+"StreetNumber": "55"
+"StreetSuffix": "Drive"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "3195"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/55_blue_springs_dr_706_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29150063/55-blue-springs-drive-unit-706-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Guest Suite"
1 => "Party Room"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1119
+"OriginalEntryTimestamp": "2025-12-01T13:29:27.53Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:46 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29150063')"
+"ID": "454669"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24628
+post_id: "452072"
+post_author: 1
+"ListingKey": "29148015"
+"ListingId": "X12586976"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-29T01:05:22Z"
+"RFModificationTimestamp": "2025-11-29T01:21:16Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J1P7"
+"UnparsedAddress": "809 - 181 KING STREET S, Waterloo, Ontario N2J1P7"
+"Coordinates": array:2 [
0 => -80.520205
1 => 43.460368
]
+"Latitude": 43.460368
+"Longitude": -80.520205
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "RemarksPublic Remarks: Available January 1, this bright and stylish 1-bedroom suite at Circa 1877 offers 638 sq. ft. of modern, open-concept living in one of Uptown Waterloo's most exciting buildings. Enjoy wide-plank flooring, floor-to-ceiling windows, and a sleek contemporary kitchen with a mix of stainless steel and integrated appliances and quartz countertops. The spacious bedroom is filled with natural light, and the convenience of in-suite laundry and a large storage locker adds even more comfort. Please note: no parking is included. Circa 1877 brings resort-style living to the city with standout amenities, including a rooftop saltwater pool with cabanas, outdoor BBQs and fire tables, an indoor-outdoor lounge, a fully equipped fitness and yoga studio, co-working spaces, guest suite, bike storage, and on-site carshare. Plus, LaLa Social House is right in the building-perfect for grabbing dinner or drinks without going far. The location is unbeatable. You're right on the ION LRT line and just steps to Vincenzo's, the Bauer District shops and cafés, Waterloo Park, great restaurants, and all the energy of Uptown Waterloo. Close to major employers and both universities, this is vibrant, effortless living at its best. Bell high-speed internet is included; tenants pay hydro and water. (id:62650)"
+"Appliances": array:1 [
0 => "Oven - Built-In"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-29T01:20:57.018082+00:00"
+"Directions": "Cross Streets: Allen St W. ** Directions: Take King St and the building is in between Allen St and William St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2239407"
+"ListOfficeKey": "294121"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-29T00:56:57Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-29T00:56:57Z"
+"StreetDirSuffix": "South"
+"StreetName": "King"
+"StreetNumber": "181"
+"StreetSuffix": "Street"
+"View": "City view"
+"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/29148015/809-181-king-street-s-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "King Condo Management"
+"GeocodeManualYN": false
+"TotalActualRent": 2000
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-29T00:56:57.62Z"
+"MapCoordinateVerifiedYN": false
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29148015')"
+"ID": "452072"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24588
+post_id: "451976"
+post_author: 1
+"ListingKey": "29147851"
+"ListingId": "40790950"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-29T00:10:26Z"
+"RFModificationTimestamp": "2025-11-29T00:48:25Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 638.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J1P7"
+"UnparsedAddress": "181 KING Street S Unit# 809, Waterloo, Ontario N2J1P7"
+"Coordinates": array:2 [
0 => -80.5201882
1 => 43.4603796
]
+"Latitude": 43.4603796
+"Longitude": -80.5201882
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Available January 1, this bright and stylish 1-bedroom suite at Circa 1877 offers 638 sq. ft. of modern, open-concept living in one of Uptown Waterloo’s most exciting buildings. Enjoy wide-plank flooring, floor-to-ceiling windows, and a sleek contemporary kitchen with a mix of stainless steel and integrated appliances and quartz countertops. The spacious bedroom is filled with natural light, and the convenience of in-suite laundry and a large storage locker adds even more comfort. Please note: no parking is included. Circa 1877 brings resort-style living to the city with standout amenities, including a rooftop saltwater pool with cabanas, outdoor BBQs and fire tables, an indoor–outdoor lounge, a fully equipped fitness and yoga studio, co-working spaces, guest suite, bike storage, and on-site carshare. Plus, LaLa Social House is right in the building—perfect for grabbing dinner or drinks without going far. The location is unbeatable. You’re right on the ION LRT line and just steps to Vincenzo’s, the Bauer District shops and cafés, Waterloo Park, great restaurants, and all the energy of Uptown Waterloo. Close to major employers and both universities, this is vibrant, effortless living at its best. Bell high-speed internet is included; tenants pay hydro and water. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Hood Fan"
5 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-29T00:48:14.675406+00:00"
+"Directions": "Take King St and the building is in between Allen St and William St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2103647"
+"ListOfficeKey": "294047"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2025-11-29T00:01:09Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-29T00:01:09Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "KING"
+"StreetNumber": "181"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"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/29147851/181-king-street-s-unit-809-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2000
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Guest Suite"
2 => "Party Room"
]
+"ZoningDescription": "U2-81"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 638
+"OriginalEntryTimestamp": "2025-11-29T00:01:08.87Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29147851')"
+"ID": "451976"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23326
+post_id: "451917"
+post_author: 1
+"ListingKey": "29147256"
+"ListingId": "X12586322"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-29T17:40:42Z"
+"RFModificationTimestamp": "2025-11-29T17:43:23Z"
+"ListPrice": 438000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3R2"
+"UnparsedAddress": "G616 - 275 LARCH ST STREET, Waterloo, Ontario N2L3R2"
+"Coordinates": array:2 [
0 => -80.532235
1 => 43.476892
]
+"Latitude": 43.476892
+"Longitude": -80.532235
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "**Excellent Location!** This fully furnished 2-bedroom apartment is located very close to Wilfrid Laurier University, the University of Waterloo, and Conestoga College. It's also near restaurants, grocery stores, parks, and theaters. The maintenance fees is low and include internet, water, and heating. The building features a fully equipped gym, a yoga and meditation room, a study lounge, as well as a theater and games room. Enjoy living in a clean and quiet neighborhood-this property is a fantastic investment opportunity for university parents and first-time buyers! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"AssociationFee": "293.53"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-28T22:58:29.518925+00:00"
+"Directions": "University Ave W & Albert St"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2129792"
+"ListOfficeKey": "234480"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-28T21:28:58Z"
+"PhotosCount": 10
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-29T17:27:38Z"
+"StreetName": "Larch St"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2266.77"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29147256/g616-275-larch-st-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "CMC"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-11-28T21:28:58.06Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:10 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29147256')"
+"ID": "451917"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24988
+post_id: "450426"
+post_author: 1
+"ListingKey": "29144698"
+"ListingId": "X12583898"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-28T02:35:27Z"
+"RFModificationTimestamp": "2025-11-28T03:30:00Z"
+"ListPrice": 479000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K7"
+"UnparsedAddress": "1711 - 145 COLUMBIA STREET W, Waterloo, Ontario N2L0K7"
+"Coordinates": array:2 [
0 => -80.538414
1 => 43.476791
]
+"Latitude": 43.476791
+"Longitude": -80.538414
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 145 Columbia St W #1711 Luxury Living with Stunning Views in Waterloo's University District! Elevate your lifestyle with this gorgeous 2-bedroom, 1 bathroom condo perched on the 17th floor of the sought-after 145 Society Condos. Offering clear, unobstructed views and a fully furnished, turnkey layout, this modern unit is the perfect opportunity for investors, students, and first-time buyers alike. Enjoy thoughtfully designed interiors and high-end finishes throughout:? Sun-filled open-concept living space with floor-to-ceiling windows and breathtaking skyline views? Stylish kitchen with quartz countertops, chic backsplash, and built-in stainless steel appliances Sleek luxury laminate flooring, contemporary light fixtures, and a designer media accent wall? ? Two spacious bedrooms featuring built-in desks, beds, side tables, and trendy barn-style sliding doors World-Class Amenities Include:. Fully equipped fitness centre. Indoor basketball court?? Yoga studio & rejuvenating sauna. Games room, media lounge, and party room. Spectacular rooftop terrace with panoramic views. 24-hour security, keyless entry, and professional business/study lounges. On-site Starbucks in the lobby Prime Location: Ideally located just steps from University of Waterloo, and walking distance to Wilfrid Laurier University, Uptown Waterloo, and the LRT Station this location offers unbeatable convenience. This unit is cash flow positive with a current rental income of $2500 per month. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Wall Mounted TV"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Multi-level"
]
+"AssociationFee": "274.69"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-28T03:29:55.043452+00:00"
+"Directions": "Columbia St, Phillip St"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2082108"
+"ListOfficeKey": "277986"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Partially cleared"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-28T02:27:49Z"
+"PhotosCount": 41
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-28T02:27:49Z"
+"StreetDirSuffix": "West"
+"StreetName": "Columbia"
+"StreetNumber": "145"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3141"
+"View": "View"
+"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/29144698/1711-145-columbia-street-w-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Craft Property Group KWG Inc."
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Party Room"
3 => "Security/Concierge"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-11-28T02:27:49.05Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29144698')"
+"ID": "450426"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24987
+post_id: "449238"
+post_author: 1
+"ListingKey": "29142145"
+"ListingId": "X12581810"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T16:35:24Z"
+"RFModificationTimestamp": "2025-11-27T20:44:55Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0G4"
+"UnparsedAddress": "315 - 321 SPRUCE STREET, Waterloo, Ontario N2L0G4"
+"Coordinates": array:2 [
0 => -80.52726
1 => 43.479262
]
+"Latitude": 43.479262
+"Longitude": -80.52726
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "London and St. Thomas Association of REALTORS®"
+"PublicRemarks": "Experience luxury and convenience in this bright 1+1 bedroom condo in the heart of Waterloo, just steps from University of Waterloo, Wilfrid Laurier University, and Conestoga College. Featuring high-end finishes, stainless steel appliances, quartz countertops, and floor-to-ceiling windows, this fully furnished unit offers a spacious den that can serve as a second bedroom or office, in-suite laundry, and included high-speed internet and weekly housekeeping. Residents enjoy concierge service, an exercise/recreation room, a rooftop patio, and guest suites in this well-maintained, modern building. Available from Jan 1 -book your viewing today! (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T20:44:45.639182+00:00"
+"Directions": "Cross Streets: Hickory Street/Spruce Street. ** Directions: From Columbia St w to Spruce St."
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100467"
+"ListOfficeKey": "168772"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-27T16:23:09Z"
+"PhotosCount": 9
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T16:23:09Z"
+"StreetName": "Spruce"
+"StreetNumber": "321"
+"StreetSuffix": "Street"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "London and St. Thomas"
+"ListAORKey": "13"
+"ListingURL": "www.realtor.ca/real-estate/29142145/315-321-spruce-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Condo Board"
+"GeocodeManualYN": false
+"TotalActualRent": 1950
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-27T16:23:09.65Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:9 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29142145')"
+"ID": "449238"
}
]
+success: true
+page_size: 9
+page_count: 36
+count: 318
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]