array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29950717 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411
+post_id: "1562848"
+post_author: 1
+"ListingKey": "29950717"
+"ListingId": "40842585"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T11:55:06Z"
+"RFModificationTimestamp": "2026-06-25T21:45:11Z"
+"ListPrice": 299900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 900.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4Z5"
+"UnparsedAddress": "139 BRIGHTON Street Unit# 3C, Waterloo, Ontario N2J4Z5"
+"Coordinates": array:2 [
0 => -80.51881
1 => 43.4715074
]
+"Latitude": 43.4715074
+"Longitude": -80.51881
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This well maintained 2-bedroom, 1-bathroom stacked townhouse-style condo is perfect for first-time buyers, downsizers, or investors. Features an updated kitchen with stainless steel appliances, quartz counters and tiled backsplash, main floor in-suite laundry adds everyday convenience, along with main floor bedroom with generous closet space. An updated 4-piece bathroom complete the main level. Second bedroom is located on upper level. Just minutes from Wilfrid Laurier University, the University of Waterloo, major transit routes, 10min walk to uptown Waterloo, and all essential amenities, this home offers unbeatable convenience. Move-in ready and waiting for its new owner. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"AssociationFee": "377.41"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T21:44:23.146754+00:00"
+"Directions": "Noecker Street"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564020"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Paved driveway"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-25T11:49:57Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T11:49:57Z"
+"Stories": "2.0"
+"StreetName": "BRIGHTON"
+"StreetNumber": "139"
+"StreetSuffix": "Street"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "2547.19"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/139-Brighton-St-3c/idx"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1667597734"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842585"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29950717"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T11:49:57.23Z"
]
1 => array:11 [
"RoomKey" => "1667597735"
"RoomType" => "Laundry room"
"ListingId" => "40842585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29950717"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T11:49:57.23Z"
]
2 => array:11 [
"RoomKey" => "1667597736"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29950717"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T11:49:57.23Z"
]
3 => array:11 [
"RoomKey" => "1667597737"
"RoomType" => "Bedroom"
"ListingId" => "40842585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29950717"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T11:49:57.23Z"
]
4 => array:11 [
"RoomKey" => "1667597738"
"RoomType" => "Kitchen"
"ListingId" => "40842585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29950717"
"RoomLength" => null
"RoomDimensions" => "15'5'' x 8'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T11:49:57.23Z"
]
5 => array:11 [
"RoomKey" => "1667597739"
"RoomType" => "Living room"
"ListingId" => "40842585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29950717"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 14'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T11:49:57.24Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29950717/139-brighton-street-unit-3c-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 900
+"OriginalEntryTimestamp": "2026-06-25T11:49:57.18Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1120111"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29950717_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/f9e6407426b5cb68e80c0d2f238c6202.webp"
"MediaSize" => 124021
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-f9e6407426b5cb68e80c0d2f238c6202.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Red brick and light-colored siding exterior featuring multiple windows"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29950717_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/a40f904ee96bab40d038f7c001e407d3.webp"
"MediaSize" => 126829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-a40f904ee96bab40d038f7c001e407d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29950717_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/d04b348e76797b616365ef4716593d9c.webp"
"MediaSize" => 153152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-d04b348e76797b616365ef4716593d9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior featuring multiple entryways"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29950717_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/6d4259037db08bdded04a27a43184405.webp"
"MediaSize" => 141652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-6d4259037db08bdded04a27a43184405.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior featuring an entry door with a storm door, a sidelight window, and an overhead outdoor light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29950717_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/d3f1192eada72d16524e7e87f28bd8fd.webp"
"MediaSize" => 61029
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-d3f1192eada72d16524e7e87f28bd8fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a white door with decorative frosted glass, a coordinating sidelight, and light neutral wall paint"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29950717_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/28fb83a836286056dc9d0a7fa7ae13d1.webp"
"MediaSize" => 63120
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-28fb83a836286056dc9d0a7fa7ae13d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29950717_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/17bdb544e0aa2f0a6823e5d29e0d7019.webp"
"MediaSize" => 62150
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-17bdb544e0aa2f0a6823e5d29e0d7019.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29950717_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/09383a443099507202ad7127a27f740f.webp"
"MediaSize" => 61825
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-09383a443099507202ad7127a27f740f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29950717_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/e46474036b66a54066c0e17057128fc1.webp"
"MediaSize" => 78755
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-e46474036b66a54066c0e17057128fc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtual staged living room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29950717_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/43fc222c359d549ec1694ec7a3f22bb6.webp"
"MediaSize" => 58631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-43fc222c359d549ec1694ec7a3f22bb6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29950717_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/986724ac51e0f3232093060a6f5ed6d8.webp"
"MediaSize" => 44065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-986724ac51e0f3232093060a6f5ed6d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring white cabinetry, subway tile backsplash, stainless steel dishwasher, and a semi-flush mount light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29950717_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/c62629976ea6cc85d715843b1233798a.webp"
"MediaSize" => 56156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-c62629976ea6cc85d715843b1233798a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white cabinetry, subway tile backsplash, stainless steel appliances, and light-toned flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29950717_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/c843188ad70394b6913ef3566774d286.webp"
"MediaSize" => 49308
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-c843188ad70394b6913ef3566774d286.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, stainless steel appliances, a white subway tile backsplash, white countertops, and light-toned flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29950717_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/11d331558375a20e3533ce03baf9da17.webp"
"MediaSize" => 53816
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-11d331558375a20e3533ce03baf9da17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring white cabinetry, a white subway tile backsplash, stainless steel appliances, a built-in dishwasher, and a stainless steel sink with a modern faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29950717_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/83948757349621c12ac13ce7fa97a258.webp"
"MediaSize" => 50618
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-83948757349621c12ac13ce7fa97a258.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29950717_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/7518b04c311f30b44ffb529210673c43.webp"
"MediaSize" => 46140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-7518b04c311f30b44ffb529210673c43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway featuring wood-finish flooring and light gray painted walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29950717_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/b64eff817d0e231852aef3384687f9fa.webp"
"MediaSize" => 51220
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-b64eff817d0e231852aef3384687f9fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with integrated sink, brushed nickel hardware, and an overhead lighting fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29950717_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/b703719b0ea6d02f69964819e734db54.webp"
"MediaSize" => 46081
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-b703719b0ea6d02f69964819e734db54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathtub and shower combination featuring neutral-toned tile surround, a handheld shower fixture, and a built-in soap dish"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29950717_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/5df309e707d09ea77dcd17ad12810c94.webp"
"MediaSize" => 36935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-5df309e707d09ea77dcd17ad12810c94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Laundry area featuring a stacked washer and dryer, white cabinetry, and a light-colored countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29950717_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/2bfb1d42913aeb5d7ff2197a1870169a.webp"
"MediaSize" => 52912
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-2bfb1d42913aeb5d7ff2197a1870169a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main floor bedroom featuring wood-finish flooring, light grey painted walls, white baseboards, and a semi-flush mount ceiling light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29950717_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/d755ac43d568096613a80ade9e69ac9d.webp"
"MediaSize" => 72810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-d755ac43d568096613a80ade9e69ac9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtual staged main floor bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29950717_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/4eda9b7895c22d64ccbdf91b6945481a.webp"
"MediaSize" => 63301
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-4eda9b7895c22d64ccbdf91b6945481a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main floor bedroom featuring wood-finish flooring, light grey painted walls, white trim, and a white ceiling with a textured finish"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29950717_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/c2aeac47ecef6509e243dbe8dacd3638.webp"
"MediaSize" => 62332
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-c2aeac47ecef6509e243dbe8dacd3638.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main floor bedroom featuring wood-finish flooring, light gray walls, and white baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29950717_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/6aa18e8845e099548ec7d96450c108c5.webp"
"MediaSize" => 54844
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-6aa18e8845e099548ec7d96450c108c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Staircase with carpeted treads and white handrail"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29950717_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/2f837e4961925abff11b837d7a184464.webp"
"MediaSize" => 31288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-2f837e4961925abff11b837d7a184464.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted staircase with white painted walls and a white handrail"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29950717_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/68550acd7d4caf1d3c5ffade3c02e32a.webp"
"MediaSize" => 67940
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-68550acd7d4caf1d3c5ffade3c02e32a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Upper level bedroom with a large window and privacy blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29950717_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/50b81a7e170f003d0d98e30ce8e844d2.webp"
"MediaSize" => 61654
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-50b81a7e170f003d0d98e30ce8e844d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Upper level bedroom featuring deep blue accent walls, light-colored carpeting, and a white window frame with a roller shade"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29950717_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/cdc9b7e5bce637760b9e492450b7d2f7.webp"
"MediaSize" => 54115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-cdc9b7e5bce637760b9e492450b7d2f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Upper level bedroom featuring blue walls and light-colored carpeting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29950717_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/c3c1fd78b396164e550351ac17266965.webp"
"MediaSize" => 143662
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-c3c1fd78b396164e550351ac17266965.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Community entrance sign for ""The Village at Brighton Park"" with brick base and metal archway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29950717_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/e4d9a9b5577e53ba9bb90d487da62548.webp"
"MediaSize" => 142067
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-e4d9a9b5577e53ba9bb90d487da62548.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Pedestrian walkway traversing a landscaped green space between two-story residences"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29950717_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29950717/3e4653593bc50c6bfd03a8500a9847b3.webp"
"MediaSize" => 139689
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29950717/thumbnail-3e4653593bc50c6bfd03a8500a9847b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Grey siding exterior with a covered porch and white railings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842585"
"ResourceRecordKey" => "29950717"
"ModificationTimestamp" => "2026-06-25T11:49:57.19Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29950717')"
+"ID": "1562848"
}
]
+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=OfficeMlsId eq 289722" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24812
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1564020" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24811
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29950717'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25200
+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 '29950717'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25215
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25216
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31642750"
+"ListingKey": "29950717"
+"ListingId": "40842585"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-28"
+"OpenHouseStartTime": "2026-06-28T11:00:00Z"
+"OpenHouseEndTime": "2026-06-28T13:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-26T03:33:07Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31642750')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25218
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31642751"
+"ListingKey": "29950717"
+"ListingId": "40842585"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-27"
+"OpenHouseStartTime": "2026-06-27T14:00:00Z"
+"OpenHouseEndTime": "2026-06-27T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-26T03:33:07Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31642751')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29950717' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.51881 43.4715074)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25273
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25267
+post_id: "1567144"
+post_author: 1
+"ListingKey": "29945896"
+"ListingId": "40842567"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T13:40:03Z"
+"RFModificationTimestamp": "2026-06-26T03:52:45Z"
+"ListPrice": 345000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1174.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4H5"
+"UnparsedAddress": "58 BRIDGEPORT Road E Unit# 806, Waterloo, Ontario N2J4H5"
+"Coordinates": array:2 [
0 => -80.5178587
1 => 43.4687759
]
+"Latitude": 43.4687759
+"Longitude": -80.5178587
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "With almost 1200 sq ft of l living space, this large 3 bedroom, 2 bathroom condo has many updates including newer kitchen and bathrooms, flooring and neutral decor. There is a large balcony overlooking Waterloo where you can enjoy evening sunsets. The location is just steps to Bridgeport Plaza and a short ride to the Universities. If you are looking for a spacious 3 bedroom condo at an affordable price that is in a great location, this unit checks all the boxes. The covered parking spot is conveniently located at the back of the building. Call today for a viewing. (id:62783)"
+"Appliances": array:2 [
0 => "Refrigerator"
1 => "Stove"
]
+"AssociationFee": "879.71"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:9 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Heat"
4 => "Electricity"
5 => "Water"
6 => "Insurance"
7 => "Parking"
8 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-26T03:51:57.627637+00:00"
+"Directions": "Take Bridgeport Rd E. past Weber St and turn right into Black Willow Condominiums"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"Heating": array:2 [
0 => "Hot water radiator heat"
1 => "Baseboard heaters"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1672317"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Backs on greenbelt"
1 => "Balcony"
2 => "Laundry- Coin operated"
]
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-24T13:30:38Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T13:30:38Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "BRIDGEPORT"
+"StreetNumber": "58"
+"StreetSuffix": "Road"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "2609"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1666816618"
"RoomType" => "Storage"
"ListingId" => "40842567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945896"
"RoomLength" => null
"RoomDimensions" => "4'4'' x 8'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T13:30:38.5Z"
]
1 => array:11 [
"RoomKey" => "1666816619"
"RoomType" => "2pc Bathroom"
"ListingId" => "40842567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945896"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T13:30:38.5Z"
]
2 => array:11 [
"RoomKey" => "1666816620"
"RoomType" => "Bedroom"
"ListingId" => "40842567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945896"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T13:30:38.5Z"
]
3 => array:11 [
"RoomKey" => "1666816621"
"RoomType" => "Bedroom"
"ListingId" => "40842567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945896"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T13:30:38.5Z"
]
4 => array:11 [
"RoomKey" => "1666816622"
"RoomType" => "Bedroom"
"ListingId" => "40842567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945896"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T13:30:38.5Z"
]
5 => array:11 [
"RoomKey" => "1666816623"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945896"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T13:30:38.5Z"
]
6 => array:11 [
"RoomKey" => "1666816624"
"RoomType" => "Dining room"
"ListingId" => "40842567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945896"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T13:30:38.5Z"
]
7 => array:11 [
"RoomKey" => "1666816625"
"RoomType" => "Living room"
"ListingId" => "40842567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945896"
"RoomLength" => null
"RoomDimensions" => "16'7'' x 21'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T13:30:38.5Z"
]
8 => array:11 [
"RoomKey" => "1666816626"
"RoomType" => "Kitchen"
"ListingId" => "40842567"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945896"
"RoomLength" => null
"RoomDimensions" => "7'9'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T13:30:38.51Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29945896/58-bridgeport-road-e-unit-806-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1944830"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1174
+"OriginalEntryTimestamp": "2026-06-24T13:30:38.45Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1170621"
+"ListOfficeNationalAssociationId": "1004387"
+"CoListAgentNationalAssociationId": "1240421"
+"CoListOfficeNationalAssociationId": "1004387"
+"Media": array:24 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29945896_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/9b483e4367c6e76c560e62b20be90673.webp"
"MediaSize" => 177598
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-9b483e4367c6e76c560e62b20be90673.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29945896_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/3c87c9b502b5073c48570cfd33658049.webp"
"MediaSize" => 82507
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-3c87c9b502b5073c48570cfd33658049.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Building Foyer"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29945896_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/dc8507aa117a884e74dabdb51bf666c1.webp"
"MediaSize" => 82777
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-dc8507aa117a884e74dabdb51bf666c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Building Foyer - ALternate Biew"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29945896_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/1c1f1a8d6cb1c21ef9d0ee0478ac9d72.webp"
"MediaSize" => 76568
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-1c1f1a8d6cb1c21ef9d0ee0478ac9d72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main Living Area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29945896_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/9c4223fdc1e3b375400ac95e661053c1.webp"
"MediaSize" => 73239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-9c4223fdc1e3b375400ac95e661053c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main Living Area showing walkout to Balcony"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29945896_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/6440bbbf11b7923bd4f7c2b9ada0c472.webp"
"MediaSize" => 72210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-6440bbbf11b7923bd4f7c2b9ada0c472.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main Living Area - Alternate View"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29945896_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/4b668b686f5537182e7a1be10c0ea7be.webp"
"MediaSize" => 69285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-4b668b686f5537182e7a1be10c0ea7be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Updated Kitchen with Granite Countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29945896_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/c5bc2c97d2a8ac418e523d3b79b7a5b8.webp"
"MediaSize" => 63089
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-c5bc2c97d2a8ac418e523d3b79b7a5b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen - Alternat View 1"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29945896_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/14da8bec0678b90aa4b00c32807dde2e.webp"
"MediaSize" => 57429
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-14da8bec0678b90aa4b00c32807dde2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen - ALternate View 2"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29945896_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/779b56dcac86f6670ac5a8a67d856ea1.webp"
"MediaSize" => 66603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-779b56dcac86f6670ac5a8a67d856ea1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining Area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29945896_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/0ac3ef2ad9af2930070eb54f3e76a0bf.webp"
"MediaSize" => 65358
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-0ac3ef2ad9af2930070eb54f3e76a0bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom 3"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29945896_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/c3e390ca11f0f3ed0347fe087bdae62c.webp"
"MediaSize" => 69637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-c3e390ca11f0f3ed0347fe087bdae62c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom 2"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29945896_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/ce04f8d9d7d0cfd0985cfde1052243d6.webp"
"MediaSize" => 63008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-ce04f8d9d7d0cfd0985cfde1052243d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious Primary Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29945896_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/e7ca33025530d5f9ae20bd5a80b7f4db.webp"
"MediaSize" => 70335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-e7ca33025530d5f9ae20bd5a80b7f4db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Bedroom - Alternate View"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29945896_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/3f578157bbdbe04df676e9d85d5c95f7.webp"
"MediaSize" => 47158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-3f578157bbdbe04df676e9d85d5c95f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Ensuite Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29945896_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/00a2cf9f400db1a9a48299a2f4872303.webp"
"MediaSize" => 68753
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-00a2cf9f400db1a9a48299a2f4872303.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View from Balcony"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29945896_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/210079f4d03bbccde6af9ae254fc9784.webp"
"MediaSize" => 74824
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-210079f4d03bbccde6af9ae254fc9784.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive Balcony with view of Waterloo"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29945896_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/a0d2b31869d2877d938f056be354bbef.webp"
"MediaSize" => 127962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-a0d2b31869d2877d938f056be354bbef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Library"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29945896_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/e28acf8a48e8ac571a7d4bc49c89fb67.webp"
"MediaSize" => 80886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-e28acf8a48e8ac571a7d4bc49c89fb67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Party Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29945896_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/87aafe6673ffba1f9297345f4cb9bfd6.webp"
"MediaSize" => 50763
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-87aafe6673ffba1f9297345f4cb9bfd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Party Room - Alternate View"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29945896_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/00f83f2f2f80ba4981f29674a4f626db.webp"
"MediaSize" => 78657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-00f83f2f2f80ba4981f29674a4f626db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Mail Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29945896_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/410d9025e611de4b3b3e4fee5eec043a.webp"
"MediaSize" => 76719
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-410d9025e611de4b3b3e4fee5eec043a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exercixe Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29945896_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/277a6ae97ea8c4c77eed2fcaddb342da.webp"
"MediaSize" => 77952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-277a6ae97ea8c4c77eed2fcaddb342da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Laundry Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29945896_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945896/3ebcf10ee37fa77a202245500ccbddfe.webp"
"MediaSize" => 49144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945896/thumbnail-3ebcf10ee37fa77a202245500ccbddfe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842567"
"ResourceRecordKey" => "29945896"
"ModificationTimestamp" => "2026-06-24T13:30:38.46Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29945896')"
+"ID": "1567144"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25269
+post_id: "1567515"
+post_author: 1
+"ListingKey": "29946102"
+"ListingId": "X13482722"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T14:20:04Z"
+"RFModificationTimestamp": "2026-06-26T03:43:39Z"
+"ListPrice": 709990.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3H6"
+"UnparsedAddress": "703 - 8 HICKORY STREET, Waterloo, Ontario N2L3H6"
+"Coordinates": array:2 [
0 => -80.526206
1 => 43.478339
]
+"Latitude": 43.478339
+"Longitude": -80.526206
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Incredible Turn Key Luxury Student Investment. Newly painted, New fridge. This Condo Is Fully Rented Until The End Of August 2026 With Options To Renew. Huge rental demand throughout the year. Recession proof income potential. Currently Rented for $4250/mth. AAA 3 working tenants continuing for last 3 years. Minutes Away From University Of Waterloo & Wilfred Laurier. Bike Lanes Run Right Up To Condo. Amenities, Shops, Restaurants & Transit Steps Away. Highway Is Only A Few Minutes Away. A Great Investment For Any Type Of Investor. 5 Bedrooms All 5 With Their Own Washrooms. Shared Common Space With Laundry, Living and huge balcony.Seller can hand over fully vacated unit if required. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Intercom"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Water Heater"
]
+"AssociationFee": "810.88"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T03:37:22.370040+00:00"
+"Directions": "University/King"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2085449"
+"ListOfficeKey": "272995"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Wheelchair access"
2 => "Balcony"
3 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T14:12:55Z"
+"PhotosCount": 11
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T14:12:55Z"
+"StreetName": "Hickory"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3652.79"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29946102/703-8-hickory-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Separate Electricity Meters"
3 => "Security/Concierge"
]
+"LivingAreaMaximum": 2249
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 5
+"OriginalEntryTimestamp": "2026-06-24T14:12:55.8Z"
+"ListAgentNationalAssociationId": "1358847"
+"ListOfficeNationalAssociationId": "1247661"
+"Media": array:11 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29946102_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946102/094c5b0e13e4a59e4bdfd30259dee816.webp"
"MediaSize" => 158050
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946102/thumbnail-094c5b0e13e4a59e4bdfd30259dee816.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13482722"
"ResourceRecordKey" => "29946102"
"ModificationTimestamp" => "2026-06-24T14:12:55.83Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29946102_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946102/6ae606865d57351b7c4ca102815b4b84.webp"
"MediaSize" => 86087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946102/thumbnail-6ae606865d57351b7c4ca102815b4b84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13482722"
"ResourceRecordKey" => "29946102"
"ModificationTimestamp" => "2026-06-24T14:12:55.83Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29946102_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946102/91c1bbb5246a8caa7ffb0a36481caa99.webp"
"MediaSize" => 77943
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946102/thumbnail-91c1bbb5246a8caa7ffb0a36481caa99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13482722"
"ResourceRecordKey" => "29946102"
"ModificationTimestamp" => "2026-06-24T14:12:55.83Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29946102_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946102/8aef06dd489cf8d284ef9890ffeab4a7.webp"
"MediaSize" => 77518
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946102/thumbnail-8aef06dd489cf8d284ef9890ffeab4a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13482722"
"ResourceRecordKey" => "29946102"
"ModificationTimestamp" => "2026-06-24T14:12:55.83Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29946102_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946102/9e67b905a61895f08e8b460c27a44b14.webp"
"MediaSize" => 91986
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946102/thumbnail-9e67b905a61895f08e8b460c27a44b14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13482722"
"ResourceRecordKey" => "29946102"
"ModificationTimestamp" => "2026-06-24T14:12:55.83Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29946102_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946102/08b2264df8cf7a79891751eeb77d14db.webp"
"MediaSize" => 61696
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946102/thumbnail-08b2264df8cf7a79891751eeb77d14db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13482722"
"ResourceRecordKey" => "29946102"
"ModificationTimestamp" => "2026-06-24T14:12:55.83Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29946102_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946102/be4f5b3fc2e7d43ca4fa1db4f9fc2b28.webp"
"MediaSize" => 108636
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946102/thumbnail-be4f5b3fc2e7d43ca4fa1db4f9fc2b28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13482722"
"ResourceRecordKey" => "29946102"
"ModificationTimestamp" => "2026-06-24T14:12:55.83Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29946102_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946102/f49c6028439e7e5fdc7fc1b5ca4832ae.webp"
"MediaSize" => 59031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946102/thumbnail-f49c6028439e7e5fdc7fc1b5ca4832ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13482722"
"ResourceRecordKey" => "29946102"
"ModificationTimestamp" => "2026-06-24T14:12:55.83Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29946102_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946102/c01f9f975d369af75ecb27ccd0fd4e98.webp"
"MediaSize" => 98829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946102/thumbnail-c01f9f975d369af75ecb27ccd0fd4e98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13482722"
"ResourceRecordKey" => "29946102"
"ModificationTimestamp" => "2026-06-24T14:12:55.83Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29946102_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946102/b1eec81084aa21c745b0bc68ccf018ab.webp"
"MediaSize" => 137100
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946102/thumbnail-b1eec81084aa21c745b0bc68ccf018ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13482722"
"ResourceRecordKey" => "29946102"
"ModificationTimestamp" => "2026-06-24T14:12:55.83Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29946102_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946102/057b6b3c68152c2001e57f48929ca6c3.webp"
"MediaSize" => 91176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946102/thumbnail-057b6b3c68152c2001e57f48929ca6c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13482722"
"ResourceRecordKey" => "29946102"
"ModificationTimestamp" => "2026-06-24T14:12:55.83Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946102')"
+"ID": "1567515"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25266
+post_id: "1564961"
+post_author: 1
+"ListingKey": "29948377"
+"ListingId": "X13484680"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T19:25:05Z"
+"RFModificationTimestamp": "2026-06-26T00:49:29Z"
+"ListPrice": 469000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K7"
+"UnparsedAddress": "611 - 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": "This stylish suite for two offers modern finishes and a bright open-concept layout, ideally located just minutes from the University of Waterloo and Laurier University. Residents enjoy exceptional amenities, including concierge service, a fully equipped fitness centre, sauna, games room, private theatre, and study lounges. Perfect for students, young professionals, or investors seeking a blend of convenience, comfort, and upscale living. The unit also includes one parking space. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Furniture"
6 => "Window Coverings"
]
+"AssociationFee": "342.6"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T00:48:52.091411+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": "1594283"
+"ListOfficeKey": "285001"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Partially cleared"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T18:56:16Z"
+"PhotosCount": 11
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T19:16:05Z"
+"StreetDirSuffix": "West"
+"StreetName": "Columbia"
+"StreetNumber": "145"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2646.96"
+"View": "View"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1667101242"
"RoomType" => "Kitchen"
"ListingId" => "X13484680"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29948377"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T19:16:05.55Z"
]
1 => array:11 [
"RoomKey" => "1667101243"
"RoomType" => "Living room"
"ListingId" => "X13484680"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29948377"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-24T19:16:05.55Z"
]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29948377/611-145-columbia-street-w-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Craft Property Group"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Party Room"
3 => "Security/Concierge"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-24T18:56:16.35Z"
+"ListAgentNationalAssociationId": "1155343"
+"ListOfficeNationalAssociationId": "1346507"
+"Media": array:11 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29948377')"
+"ID": "1564961"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25270
+post_id: "1563891"
+post_author: 1
+"ListingKey": "29949445"
+"ListingId": "X13485512"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T22:00:21Z"
+"RFModificationTimestamp": "2026-06-25T23:26:01Z"
+"ListPrice": 509000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3T7"
+"UnparsedAddress": "114 - 253 ALBERT STREET, Waterloo, Ontario N2L3T7"
+"Coordinates": array:2 [
0 => -80.533259
1 => 43.47544
]
+"Latitude": 43.47544
+"Longitude": -80.533259
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Desirable And Accommodating Off Campus Residency. A 5 Minute Walk To Wilfrid Laurier University And University Of Waterloo. Spacious 2 Bedrooms With 2 Baths. Opening To A Large Private Terrace. Floor To Ceiling Windows. Including Granite Countertops, In-Suite Laundry Facility, Ensuite Bath And Roomy Walk-In Closet. Has An Assigned Parking Spot. Fully Furnished Unit In "As Is" Condition. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Water Heater"
]
+"AssociationFee": "804.78"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:25:50.900110+00:00"
+"Directions": "University/Albert"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1416090"
+"ListOfficeKey": "275703"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Elevator"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T21:53:03Z"
+"PhotosCount": 1
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T21:53:03Z"
+"StreetName": "Albert"
+"StreetNumber": "253"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4826.72"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29949445/114-253-albert-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Separate Electricity Meters"
1 => "Separate Heating Controls"
]
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-24T21:53:03.64Z"
+"ListAgentNationalAssociationId": "1047244"
+"ListOfficeNationalAssociationId": "1267442"
+"Media": array:1 [
0 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29949445')"
+"ID": "1563891"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25268
+post_id: "1563386"
+post_author: 1
+"ListingKey": "29950027"
+"ListingId": "X13486384"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T00:25:18Z"
+"RFModificationTimestamp": "2026-06-25T22:36:05Z"
+"ListPrice": 451000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3W9"
+"UnparsedAddress": "N-808 - 330 PHILLIP STREET, Waterloo, Ontario N2L3W9"
+"Coordinates": array:2 [
0 => -80.538971
1 => 43.476309
]
+"Latitude": 43.476309
+"Longitude": -80.538971
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 330 Phillip North Tower Unit 808, perfectly located within walking distance to the University of Waterloo, offering the ideal balance of convenience and quiet living. Well-designed layout. it also comes with a locker for extra storage. Enjoy peaceful living while being just minutes away from campus, restaurants, shopping, cafes, grocery stores, and public transit. The building offers a wide range of amenities, including fitness and recreational facilities designed to enhance your lifestyle. Whether you are a student or young professional, this warm and inviting home provides comfort, convenience, and excellent value in one of Waterloo's most desirable locations. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "310.79"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Electricity"
3 => "Water"
4 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T22:35:57.819987+00:00"
+"Directions": "Phillip & Columbia St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1964358"
+"ListOfficeKey": "256184"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "Balcony"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T23:45:36Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T00:19:19Z"
+"StreetName": "Phillip"
+"StreetNumber": "330"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3706.48"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29950027/n-808-330-phillip-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Craft Property Group"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Recreation Centre"
3 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Security guard"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-24T23:45:36.9Z"
+"ListAgentNationalAssociationId": "1253109"
+"ListOfficeNationalAssociationId": "1212235"
+"Media": array:12 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29950027')"
+"ID": "1563386"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25263
+post_id: "1562849"
+post_author: 1
+"ListingKey": "29950838"
+"ListingId": "X13486974"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T00:20:08Z"
+"RFModificationTimestamp": "2026-06-26T01:06:17Z"
+"ListPrice": 709000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3H6"
+"UnparsedAddress": "203 - 8 HICKORY STREET W, Waterloo, Ontario N2L3H6"
+"Coordinates": array:2 [
0 => -80.526206
1 => 43.478339
]
+"Latitude": 43.478339
+"Longitude": -80.526206
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Calling All Investors! Welcome to 8 Hickory Street W, Unit 203, Waterloo - the ultimate income-generating investment property in a prime student rental location within walking distance to the University of Waterloo and Wilfrid Laurier University. This renovated condo offers over 2,000 sq. ft. of functional living space with laminate flooring throughout, 5 spacious bedrooms, 5 bathrooms, an open-concept living and dining area, and a walk-out to a spacious open balcony with room for outdoor furniture and enjoyment. The modern kitchen features stainless steel appliances, granite countertops, ceramic backsplash, a centre island, 2 stainless steel fridges, lots of cabinetry/pantry space and in-suite laundry for everyday convenience. All 5 rooms are fully rented from September 2026 to August 2027, generating a gross monthly income of $4,875 (covers 5 rooms $950/each monthly & parking $125/month), with the 1 owned underground parking space providing an additional $125 per month starting Sept. 2026. Monthly condo fees include unlimited Bell high-speed internet, water, parking, common elements, building insurance, and central air conditioning. The suite comes fully furnished with 5 double-sized bed frames, 5 desks, 5 side tables, washer and dryer, 3-seater couch, 2-seater couch, TV, barstools, dining chairs, window coverings, and electrical light fixtures. Building amenities include an exercise room, party/meeting room, games room, visitor parking, secure bike storage, elevator, and controlled entry. Ideally surrounded by parks and recreation including Kevin Strauss Football Field, Ansley Alumni Field, Hillside Park, Forwell Trail & Creek, Sugarbush Park, and Waterloo Park, with nearby access to University of Waterloo, Wilfrid Laurier University, Conestoga College. Steps to Grand River Transit, and the nearby Conestoga Parkway for easy travel throughout Waterloo Region, Ontario, and the GTA. (id:62650)"
+"Appliances": array:9 [
0 => "All"
1 => "Washer"
2 => "Refrigerator"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"AssociationFee": "889.34"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T21:35:35.727452+00:00"
+"Directions": "Cross Streets: King St. N. & University Ave. W. ** Directions: Exit Conestoga Pkwy West on University, North on King, West on Hickory."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1743624"
+"ListOfficeKey": "271789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Elevator"
1 => "Lighting"
2 => "Balcony"
3 => "Carpet Free"
4 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-25T12:16:59Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T00:14:33Z"
+"StreetDirSuffix": "West"
+"StreetName": "Hickory"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7483.08"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://vimeo.com/1204656519?fl=ml&fe=ec"
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29950838/203-8-hickory-street-w-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2193944"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management 519-620-8778"
+"CoListOfficeKey": "271789"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"SecurityFeatures": array:3 [
0 => "Smoke Detectors"
1 => "Controlled entry"
2 => "Monitored Alarm"
]
+"LivingAreaMaximum": 2249
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 5
+"OriginalEntryTimestamp": "2026-06-25T12:16:58.91Z"
+"ListAgentNationalAssociationId": "1179823"
+"ListOfficeNationalAssociationId": "1243258"
+"CoListAgentNationalAssociationId": "1442810"
+"CoListOfficeNationalAssociationId": "1243258"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29950838')"
+"ID": "1562849"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1562594"
+post_author: 1
+"ListingKey": "29951014"
+"ListingId": "X13487184"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T03:25:01Z"
+"RFModificationTimestamp": "2026-06-26T04:38:16Z"
+"ListPrice": 875000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3S6"
+"UnparsedAddress": "217 MAYFIELD AVENUE, Waterloo, Ontario N2J3S6"
+"Coordinates": array:2 [
0 => -80.510872
1 => 43.480402
]
+"Latitude": 43.480402
+"Longitude": -80.510872
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rare Find! Highly auspicious North-facing VASTU-compliant home; Fully Renovated LEGAL DUPLEX - Turnkey & Positive Cash Flow. Minutes from 3 universities 3+2 Bedrooms 2 Full Baths, 2 Kitchens. Detached bungalow on a large lot in a quiet, family-friendly avenue in the desirable Lincoln Heights / Glenridge neighbourhood - within the boundary of top-rated schools. MAIN FLOOR: Spacious layout with a Large primary bedroom and walk-out to a private deck overlooking the backyard, plus two additional regular bedrooms. LEGAL BASEMENT: 2 Large bedrooms + Office room. Highlights: Over 2,000 sq ft of finished living space; Detached oversized garage + long driveway with ample parking; Currently rented to respectful, responsible university students who pay on time and care for the property; POSITIVE CASH FLOW from day one; Bonus upside - BUILD BIG LATER: This large lot qualifies as-of-right for up to a 4-unit, 4-storey building under Waterloo's December 2024 "FOUR Units, FOUR Storeys" bylaw - no rezoning, no variances. A complete conceptual fourplex design (3D model + floor plans) is available for serious buyers. A standout opportunity for homeowners & investors alike. No gimmicks. NO offer date. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Water softener"
2 => "Dishwasher"
3 => "Range"
4 => "Dryer"
5 => "Microwave"
6 => "Furniture"
7 => "Water Heater"
8 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Apartment in basement"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T21:21:57.875346+00:00"
+"Directions": "Cross Streets: University Ave / Conestoga Pkwy. ** Directions: University Ave To Mayfield Ave."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:3 [
0 => "Laminate"
1 => "Vinyl"
2 => "Porcelain Tile"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2019588"
+"ListOfficeKey": "164016"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Sump Pump"
]
+"LotSizeDimensions": "60.1 x 120.7 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T13:13:58Z"
+"PhotosCount": 19
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T03:17:35Z"
+"Stories": "1.0"
+"StreetName": "Mayfield"
+"StreetNumber": "217"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4451.61"
+"View": "View"
+"VirtualTourURLUnbranded": "https://video-api.supreme.one/48PjWV?branded=true"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29951014/217-mayfield-avenue-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 60.1
+"OriginalEntryTimestamp": "2026-06-25T13:13:58.05Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1299556"
+"ListOfficeNationalAssociationId": "1184644"
+"Media": array:19 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29951014')"
+"ID": "1562594"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25271
+post_id: "1562395"
+post_author: 1
+"ListingKey": "29953586"
+"ListingId": "X13488440"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T18:45:13Z"
+"RFModificationTimestamp": "2026-06-25T21:07:38Z"
+"ListPrice": 469900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3W9"
+"UnparsedAddress": "S1007 - 330 PHILLIP STREET, Waterloo, Ontario N2L3W9"
+"Coordinates": array:2 [
0 => -80.538971
1 => 43.476309
]
+"Latitude": 43.476309
+"Longitude": -80.538971
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To ICON 330 - A Bright And Modern 1 Bedroom + Large Den Condo In The Heart Of Waterloo's University District! Offering Approximately 547 Sq Ft Of Functional Living Space, This Well-Designed Suite Features Granite Kitchen Countertops, Stainless Steel Appliances, Ensuite Laundry And A Smart Layout Maximizing Every Square Foot. The Spacious Den Offers Exceptional Flexibility And Is Currently Set Up As A Second Sleeping Area Complete With Closet, Double Bed And Desk.Includes The Added Convenience Of 1 Parking Space And Locker - A Valuable Bonus In This Prime Location. Perfect For Investors, Parents Of Students Or Buyers Looking For A Low-Maintenance Lifestyle Steps From The University Of Waterloo, Wilfrid Laurier University, Transit, Restaurants And Everyday Amenities. Residents Enjoy An Impressive Amenity Package Including A Fully Equipped Fitness Centre, Yoga Studio, Rooftop Patio, Basketball Court, Theatre Room, Games Room, Multiple Study Lounges And On-Site Retail. A Turnkey Opportunity In One Of Waterloo's Most Sought-After Buildings! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "410.79"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T21:07:26.481006+00:00"
+"Directions": "Colombia St/Phillip St"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Natural gas"
1 => "Coil Fan"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1502882"
+"ListOfficeKey": "299532"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Elevator"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-25T18:36:32Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T18:36:32Z"
+"StreetName": "Phillip"
+"StreetNumber": "330"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3482.09"
+"VirtualTourURLUnbranded": "https://iframe.videodelivery.net/a507a60ae9128debd77f4c64d6e8c700"
+"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/29953586/s1007-330-phillip-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Loyal Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Recreation Centre"
3 => "Security/Concierge"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-25T18:36:32.23Z"
+"ListAgentNationalAssociationId": "1136485"
+"ListOfficeNationalAssociationId": "1473708"
+"Media": array:35 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29953586')"
+"ID": "1562395"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25272
+post_id: "1562014"
+post_author: 1
+"ListingKey": "29953652"
+"ListingId": "X13489360"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T19:05:24Z"
+"RFModificationTimestamp": "2026-06-25T20:30:46Z"
+"ListPrice": 414999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4J1"
+"UnparsedAddress": "32 - 121 UNIVERSITY AVENUE E, Waterloo, Ontario N2J4J1"
+"Coordinates": array:2 [
0 => -80.515579
1 => 43.477294
]
+"Latitude": 43.477294
+"Longitude": -80.515579
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Calling all INVESTORS , FIRST TIME HOME BUYERS AND FAMILIES ALIKE ! This exceptional 5 bedroom townhouse has the potential of $3,500 to$4,000 per month rent !, For families and first time home buyers the square footage offers incredible value. The spacious layout seamlessly flows from room to room, creating an inviting atmosphere for both relaxation and entertainment. Enjoy preparing meals with ease as there is noshortage of counter space in the kitchen. Morning coffee or barbecues with friends on your patio. Each bedroom offering plenty of space, natural light, and closet storage. The master bedroom features an ensuite bath & walk in closet . Downstairs, is a rec room for movie nights and entertaining. There is an abundance of storage in the basement for all of your extra belongings. Take advantage of the proximity to excellent schools, Wilfred Laurier University, Waterloo University as well as the Conestoga College campus, Miles of scenic walking trails for outdoor enthusiasts to explore the natural beauty of the surrounding area. For those who enjoy shopping and dining, you're in luck! This property is conveniently located within walking distance to great shopping destinations and local eateries, providing endless opportunities for leisure! No scraping your car this upcoming winter as there is a underground parking space included. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "766"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Water"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T20:27:11.755530+00:00"
+"Directions": "Cross Streets: Marsland. ** Directions: University Ave East to Marsland drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2193931"
+"ListOfficeKey": "286835"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T18:36:48Z"
+"PhotosCount": 38
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T18:58:48Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "University"
+"StreetNumber": "121"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3304"
+"VirtualTourURLUnbranded": "https://youriguide.com/32_121_university_ave_e_waterloo_on/"
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29953652/32-121-university-avenue-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2247230"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "ONYX"
+"CoListOfficeKey": "286835"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-06-25T18:36:48.32Z"
+"ListAgentNationalAssociationId": "1443150"
+"ListOfficeNationalAssociationId": "1364242"
+"CoListAgentNationalAssociationId": "1486102"
+"CoListOfficeNationalAssociationId": "1364242"
+"Media": array:38 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29953652')"
+"ID": "1562014"
}
]
+success: true
+page_size: 9
+page_count: 48
+count: 430
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]