array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30084442 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23584
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23586
+post_id: "1662798"
+post_author: 1
+"ListingKey": "30084442"
+"ListingId": "40851291"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-27T22:05:22Z"
+"RFModificationTimestamp": "2026-07-27T22:08:59Z"
+"ListPrice": 329900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1174.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4H5"
+"UnparsedAddress": "58 BRIDGEPORT Road Unit# 806, Waterloo, Ontario N2J4H5"
+"Coordinates": array:2 [
0 => -80.5177012
1 => 43.469579
]
+"Latitude": 43.469579
+"Longitude": -80.5177012
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright & Spacious 3-Bedroom, 2-Bathroom Condo! Boasting just under 1200 square feet! This move-in ready condo features a beautifully updated kitchen with quartz countertops and newer appliances. Spacious dining room with picturesque views of lush trees make this an elegant dining spot. The large living room with wall of windows lead to the massive private balcony and is the perfect spot for your morning coffee or evening relaxation. 3 spacious bedrooms (primary bedroom with 2 pc ensuite) make this an ideal home. Complete with parking and just steps from the universities, this home offers modern style, generous living space, and an unbeatable location for students, professionals, families, or investors. Close to Bus Routes, schools, LRT, shopping and Universities & Conestoga College! Some photos virtually staged (id:62650)"
+"Appliances": array:3 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
]
+"AssociationFee": "879.71"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Property Management"
1 => "Heat"
2 => "Electricity"
3 => "Water"
4 => "Insurance"
5 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-07-27T22:08:52.913900+00:00"
+"Directions": "Weber St to Bridgeport Road"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1600661"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-27T21:38:02Z"
+"PhotosCount": 15
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-27T21:59:05Z"
+"Stories": "1.0"
+"StreetName": "BRIDGEPORT"
+"StreetNumber": "58"
+"StreetSuffix": "Road"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "2735"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1694990462"
"RoomType" => "Bedroom"
"ListingId" => "40851291"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30084442"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T21:59:05.99Z"
]
1 => array:11 [
"RoomKey" => "1694990463"
"RoomType" => "Storage"
"ListingId" => "40851291"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30084442"
"RoomLength" => null
"RoomDimensions" => "4'4'' x 8'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T21:59:05.99Z"
]
2 => array:11 [
"RoomKey" => "1694990464"
"RoomType" => "Full bathroom"
"ListingId" => "40851291"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30084442"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T21:59:05.99Z"
]
3 => array:11 [
"RoomKey" => "1694990465"
"RoomType" => "Bedroom"
"ListingId" => "40851291"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30084442"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T21:59:05.99Z"
]
4 => array:11 [
"RoomKey" => "1694990466"
"RoomType" => "4pc Bathroom"
"ListingId" => "40851291"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30084442"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T21:59:05.99Z"
]
5 => array:11 [
"RoomKey" => "1694990467"
"RoomType" => "Bedroom"
"ListingId" => "40851291"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30084442"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T21:59:05.99Z"
]
6 => array:11 [
"RoomKey" => "1694990468"
"RoomType" => "Dining room"
"ListingId" => "40851291"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30084442"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T21:59:05.99Z"
]
7 => array:11 [
"RoomKey" => "1694990469"
"RoomType" => "Kitchen"
"ListingId" => "40851291"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30084442"
"RoomLength" => null
"RoomDimensions" => "16'7'' x 21'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T21:59:06Z"
]
8 => array:11 [
"RoomKey" => "1694990470"
"RoomType" => "Kitchen"
"ListingId" => "40851291"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30084442"
"RoomLength" => null
"RoomDimensions" => "7'9'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T21:59:06Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30084442/58-bridgeport-road-unit-806-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1174
+"OriginalEntryTimestamp": "2026-07-27T21:38:02.05Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1155649"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:15 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30084442_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30084442/e8cc83ccec7345510609688d8e42c663.webp"
"MediaSize" => 121303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30084442/thumbnail-e8cc83ccec7345510609688d8e42c663.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40851291"
"ResourceRecordKey" => "30084442"
"ModificationTimestamp" => "2026-07-27T21:38:02.05Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30084442_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30084442/31b788355a32ce437c410ed0aad02400.webp"
"MediaSize" => 170230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30084442/thumbnail-31b788355a32ce437c410ed0aad02400.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851291"
"ResourceRecordKey" => "30084442"
"ModificationTimestamp" => "2026-07-27T21:38:02.05Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30084442_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30084442/9c13ce69f086640b887e2d6cc399ba8a.webp"
"MediaSize" => 92108
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30084442/thumbnail-9c13ce69f086640b887e2d6cc399ba8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851291"
"ResourceRecordKey" => "30084442"
"ModificationTimestamp" => "2026-07-27T21:38:02.05Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30084442_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30084442/e06c6d1a6ec90370d535b60ae6e7d7da.webp"
"MediaSize" => 86624
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30084442/thumbnail-e06c6d1a6ec90370d535b60ae6e7d7da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851291"
"ResourceRecordKey" => "30084442"
"ModificationTimestamp" => "2026-07-27T21:38:02.05Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30084442_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30084442/e29b0d411479795961095e49fbf8a897.webp"
"MediaSize" => 72585
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30084442/thumbnail-e29b0d411479795961095e49fbf8a897.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851291"
"ResourceRecordKey" => "30084442"
"ModificationTimestamp" => "2026-07-27T21:38:02.05Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30084442_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30084442/253005f92a9fbd4d5d3aaded053db63a.webp"
"MediaSize" => 72387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30084442/thumbnail-253005f92a9fbd4d5d3aaded053db63a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851291"
"ResourceRecordKey" => "30084442"
"ModificationTimestamp" => "2026-07-27T21:38:02.05Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30084442_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30084442/d137d4a051391ff89b00be3a06233162.webp"
"MediaSize" => 65732
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30084442/thumbnail-d137d4a051391ff89b00be3a06233162.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851291"
"ResourceRecordKey" => "30084442"
"ModificationTimestamp" => "2026-07-27T21:38:02.05Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30084442_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30084442/80b5b9f25427fd1e8d4d42a37fed8df5.webp"
"MediaSize" => 90698
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30084442/thumbnail-80b5b9f25427fd1e8d4d42a37fed8df5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851291"
"ResourceRecordKey" => "30084442"
"ModificationTimestamp" => "2026-07-27T21:38:02.05Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30084442_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30084442/8a72d4ec38219f3fc11db19eb9282241.webp"
"MediaSize" => 90595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30084442/thumbnail-8a72d4ec38219f3fc11db19eb9282241.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851291"
"ResourceRecordKey" => "30084442"
"ModificationTimestamp" => "2026-07-27T21:38:02.05Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30084442_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30084442/ee3d9162079b9ba4ac6537097546f618.webp"
"MediaSize" => 83409
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30084442/thumbnail-ee3d9162079b9ba4ac6537097546f618.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851291"
"ResourceRecordKey" => "30084442"
"ModificationTimestamp" => "2026-07-27T21:38:02.05Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30084442_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30084442/32202e30dd449d81bbf237c570e952a0.webp"
"MediaSize" => 103606
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30084442/thumbnail-32202e30dd449d81bbf237c570e952a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851291"
"ResourceRecordKey" => "30084442"
"ModificationTimestamp" => "2026-07-27T21:38:02.05Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30084442_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30084442/6c825a0444ca29c701bfc58d674610e5.webp"
"MediaSize" => 43759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30084442/thumbnail-6c825a0444ca29c701bfc58d674610e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851291"
"ResourceRecordKey" => "30084442"
"ModificationTimestamp" => "2026-07-27T21:38:02.05Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30084442_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30084442/798d4d2bac189772ff5cbed9990283cd.webp"
"MediaSize" => 32364
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30084442/thumbnail-798d4d2bac189772ff5cbed9990283cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851291"
"ResourceRecordKey" => "30084442"
"ModificationTimestamp" => "2026-07-27T21:38:02.05Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30084442_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30084442/7d1ad03ef270ea1755e59f16179d97a7.webp"
"MediaSize" => 29327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30084442/thumbnail-7d1ad03ef270ea1755e59f16179d97a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851291"
"ResourceRecordKey" => "30084442"
"ModificationTimestamp" => "2026-07-27T21:38:02.05Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30084442_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30084442/a16bd85ae54e8e8b742b4df4f628d8ce.webp"
"MediaSize" => 153327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30084442/thumbnail-a16bd85ae54e8e8b742b4df4f628d8ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851291"
"ResourceRecordKey" => "30084442"
"ModificationTimestamp" => "2026-07-27T21:38:02.05Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30084442')"
+"ID": "1662798"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Cache Key: a19dffa2119fa68aaf3675f45457ce6ff62568acc8c0a9d6a882337345466506" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24724
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25054
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "519-885-0200"
+"OfficeMlsId": "KW207"
+"ModificationTimestamp": "2026-03-24T17:19:43Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "76789"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "83 ERB ST.W."
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "WATERLOO"
+"OfficePostalCode": "N2L6C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1004357"
+"OriginalEntryTimestamp": null
+"OfficeFax": "519-885-4914"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "431112"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "76789"
"SocialMediaUrlOrId" => "http://www.remaxtwincity.com/"
"ModificationTimestamp" => "2026-03-24T16:37:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1069905"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('76789')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1600661" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24970
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30084442'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25335
+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 '30084442' AND OpenHouseDate ge '2026-07-27'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25351
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30084442' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5177012 43.469579)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25404
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25398
+post_id: "1663479"
+post_author: 1
+"ListingKey": "30085017"
+"ListingId": "X13610856"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-28T00:35:20Z"
+"RFModificationTimestamp": "2026-07-28T00:44:17Z"
+"ListPrice": 775000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3T9"
+"UnparsedAddress": "285 ALBERT STREET W, Waterloo, Ontario N2L3T9"
+"Coordinates": array:2 [
0 => -80.534198
1 => 43.476672
]
+"Latitude": 43.476672
+"Longitude": -80.534198
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome to this charming brick home on a premium corner lot in one of Waterloo's most sought-after neighbourhoods. Situated just minutes from the University of Waterloo, Wilfrid Laurier University, shopping, transit, parks, and everyday amenities, this well-maintained property offers exceptional flexibility for homeowners, investors, and future-minded buyers alike. Featuring over 1,800 square feet of finished living space, this home offers 4 bedrooms, 2 bathrooms, a separate entrance to the partially finished basement, and a functional layout ideal for family living, multi-generational use, or income-generating opportunities. The property was licensed by the City of Waterloo as a Class B 4-bedroom rental property through March 31, 2026, highlighting its established rental history and appeal in this high-demand university market. Outside, enjoy a private backyard retreat complete with an inground pool, mature landscaping, patio space, and ample parking including an attached garage. Whether you're looking for a home in a prime Waterloo location, an investment property with strong rental demand, or a property with long-term upside, this opportunity delivers. The property's prominent corner location at Albert Street and Hickory Street offers excellent exposure and future potential within Waterloo's rapidly evolving Northdale neighbourhood. Adjacent properties at 289, 291 and 293 Albert Street are also available for sale, creating a rare opportunity for purchasers to explore a potential land assembly and redevelopment project in one of the city's most active growth corridors. Enjoy the property today while securing a strategic real estate asset for tomorrow. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Water Heater"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-28T00:44:13.609127+00:00"
+"Directions": "Cross Streets: Hickory. ** Directions: Corner of Albert St and Hickory St W."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2244183"
+"ListOfficeKey": "85302"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "55.4 x 132.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-28T00:29:45Z"
+"PhotosCount": 28
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-28T00:29:45Z"
+"Stories": "1.5"
+"StreetDirSuffix": "West"
+"StreetName": "Albert"
+"StreetNumber": "285"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6688.65"
+"VirtualTourURLUnbranded": "https://tours.eyefimedia.com/329702"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1695114467"
"RoomType" => "Kitchen"
"ListingId" => "X13610856"
"RoomLevel" => "Main level"
"RoomWidth" => 10.1
"ListingKey" => "30085017"
"RoomLength" => 11.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-28T00:29:45.37Z"
]
1 => array:11 [
"RoomKey" => "1695114468"
"RoomType" => "Furnace"
"ListingId" => "X13610856"
"RoomLevel" => "Basement"
"RoomWidth" => 11.3
"ListingKey" => "30085017"
"RoomLength" => 12.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-28T00:29:45.37Z"
]
2 => array:11 [
"RoomKey" => "1695114469"
"RoomType" => "Other"
"ListingId" => "X13610856"
"RoomLevel" => "Basement"
"RoomWidth" => 4.1
"ListingKey" => "30085017"
"RoomLength" => 9.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-28T00:29:45.37Z"
]
3 => array:11 [
"RoomKey" => "1695114470"
"RoomType" => "Living room"
"ListingId" => "X13610856"
"RoomLevel" => "Main level"
"RoomWidth" => 13.5
"ListingKey" => "30085017"
"RoomLength" => 15.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-28T00:29:45.37Z"
]
4 => array:11 [
"RoomKey" => "1695114471"
"RoomType" => "Bedroom"
"ListingId" => "X13610856"
"RoomLevel" => "Main level"
"RoomWidth" => 10.1
"ListingKey" => "30085017"
"RoomLength" => 14.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-28T00:29:45.37Z"
]
5 => array:11 [
"RoomKey" => "1695114472"
"RoomType" => "Bathroom"
"ListingId" => "X13610856"
"RoomLevel" => "Main level"
"RoomWidth" => 8.5
"ListingKey" => "30085017"
"RoomLength" => 9.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-28T00:29:45.37Z"
]
6 => array:11 [
"RoomKey" => "1695114473"
"RoomType" => "Bedroom 2"
"ListingId" => "X13610856"
"RoomLevel" => "Second level"
"RoomWidth" => 10.5
"ListingKey" => "30085017"
"RoomLength" => 13.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-28T00:29:45.37Z"
]
7 => array:11 [
"RoomKey" => "1695114474"
"RoomType" => "Bedroom 3"
"ListingId" => "X13610856"
"RoomLevel" => "Second level"
"RoomWidth" => 11.1
"ListingKey" => "30085017"
"RoomLength" => 12.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-28T00:29:45.37Z"
]
8 => array:11 [
"RoomKey" => "1695114475"
"RoomType" => "Bathroom"
"ListingId" => "X13610856"
"RoomLevel" => "Second level"
"RoomWidth" => 3.11
"ListingKey" => "30085017"
"RoomLength" => 4.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-28T00:29:45.37Z"
]
9 => array:11 [
"RoomKey" => "1695114476"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13610856"
"RoomLevel" => "Basement"
"RoomWidth" => 12.7
"ListingKey" => "30085017"
"RoomLength" => 16.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-28T00:29:45.37Z"
]
10 => array:11 [
"RoomKey" => "1695114477"
"RoomType" => "Bedroom 4"
"ListingId" => "X13610856"
"RoomLevel" => "Basement"
"RoomWidth" => 8.11
"ListingKey" => "30085017"
"RoomLength" => 13.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-28T00:29:45.37Z"
]
11 => array:11 [
"RoomKey" => "1695114478"
"RoomType" => "Laundry room"
"ListingId" => "X13610856"
"RoomLevel" => "Basement"
"RoomWidth" => 12.4
"ListingKey" => "30085017"
"RoomLength" => 13.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-28T00:29:45.37Z"
]
]
+"ListAOR": "OnePoint"
+"TaxYear": 2026
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/30085017/285-albert-street-w-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "RN6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 55.4
+"OriginalEntryTimestamp": "2026-07-28T00:29:45.31Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1482835"
+"ListOfficeNationalAssociationId": "1309439"
+"Media": array:28 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30085017_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/883939d928a0cf77a7cb0452e11d9c9c.webp"
"MediaSize" => 423730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-883939d928a0cf77a7cb0452e11d9c9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30085017_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/24b40fcc2aaa165d2547b7e6a8114b04.webp"
"MediaSize" => 387921
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-24b40fcc2aaa165d2547b7e6a8114b04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30085017_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/bc65ff1c3e740ba4bb2b7c27184a9be1.webp"
"MediaSize" => 527119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-bc65ff1c3e740ba4bb2b7c27184a9be1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30085017_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/ad7b8c5054df5437461393fd9af108f7.webp"
"MediaSize" => 467708
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-ad7b8c5054df5437461393fd9af108f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30085017_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/438a7df4f69a078fe914b599abb557dc.webp"
"MediaSize" => 437680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-438a7df4f69a078fe914b599abb557dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30085017_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/b35c9b547ad37879aa0d7c5536b2d188.webp"
"MediaSize" => 467417
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-b35c9b547ad37879aa0d7c5536b2d188.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30085017_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/1a4792f77fee3eab6c6fb81055e3e152.webp"
"MediaSize" => 295535
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-1a4792f77fee3eab6c6fb81055e3e152.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30085017_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/06b8108e99c5689915e9c5ec432c22a8.webp"
"MediaSize" => 267127
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-06b8108e99c5689915e9c5ec432c22a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30085017_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/5d5e244f3c570c96c72224708cd70692.webp"
"MediaSize" => 284674
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-5d5e244f3c570c96c72224708cd70692.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30085017_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/4b5c1bba8363faff798e4127fa97bc1a.webp"
"MediaSize" => 306194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-4b5c1bba8363faff798e4127fa97bc1a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30085017_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/60364805f872f9e6f5ef02e83c2521d8.webp"
"MediaSize" => 258953
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-60364805f872f9e6f5ef02e83c2521d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30085017_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/20250a7b1e6d745324cd485889b76996.webp"
"MediaSize" => 271101
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-20250a7b1e6d745324cd485889b76996.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30085017_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/4c1ad886f1ae77a759a4712a01c3f942.webp"
"MediaSize" => 296128
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-4c1ad886f1ae77a759a4712a01c3f942.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30085017_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/7f21d71cc94706a7ec5e68c429f4f56d.webp"
"MediaSize" => 224018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-7f21d71cc94706a7ec5e68c429f4f56d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30085017_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/69452d5671d2a1098e402bde06a61158.webp"
"MediaSize" => 202713
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-69452d5671d2a1098e402bde06a61158.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30085017_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/7a7a454409f51050bbd43fed9d889e3d.webp"
"MediaSize" => 213594
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-7a7a454409f51050bbd43fed9d889e3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30085017_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/8f065040e6ce7be8af33845c3533b47b.webp"
"MediaSize" => 205116
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-8f065040e6ce7be8af33845c3533b47b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30085017_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/7564b8e994b48391e125d0883651c847.webp"
"MediaSize" => 203533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-7564b8e994b48391e125d0883651c847.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30085017_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/7fc84bd362fa73a8f42d0d971da7bd75.webp"
"MediaSize" => 207462
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-7fc84bd362fa73a8f42d0d971da7bd75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30085017_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/f3b67f291cf3929a4291925118f72e67.webp"
"MediaSize" => 207173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-f3b67f291cf3929a4291925118f72e67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30085017_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/95847375378211467cd7a7daa1ae2e19.webp"
"MediaSize" => 543741
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-95847375378211467cd7a7daa1ae2e19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30085017_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/615ba37f3623cfa3fdc0d22d096b8aa7.webp"
"MediaSize" => 425024
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-615ba37f3623cfa3fdc0d22d096b8aa7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30085017_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/a3305e831692191e9df7deec96fc5182.webp"
"MediaSize" => 550863
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-a3305e831692191e9df7deec96fc5182.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30085017_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/0aaf954683fb74bf9f0bcb9800c94b4e.webp"
"MediaSize" => 487802
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-0aaf954683fb74bf9f0bcb9800c94b4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30085017_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/7fdc6458c8950c0bbd8853ef230a9b74.webp"
"MediaSize" => 112652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-7fdc6458c8950c0bbd8853ef230a9b74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30085017_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/868c1fd23e963b2cafb455444f68e447.webp"
"MediaSize" => 96358
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-868c1fd23e963b2cafb455444f68e447.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30085017_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/7a97cb9dd752581e57206072fb4d00b6.webp"
"MediaSize" => 94236
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-7a97cb9dd752581e57206072fb4d00b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30085017_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30085017/6f102ac18543bea67d897d77af896a63.webp"
"MediaSize" => 127891
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30085017/thumbnail-6f102ac18543bea67d897d77af896a63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13610856"
"ResourceRecordKey" => "30085017"
"ModificationTimestamp" => "2026-07-28T00:29:45.31Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30085017')"
+"ID": "1663479"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25400
+post_id: "1662364"
+post_author: 1
+"ListingKey": "30083272"
+"ListingId": "40850992"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-27T18:45:02Z"
+"RFModificationTimestamp": "2026-07-27T19:48:42Z"
+"ListPrice": 409900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 490.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K7"
+"UnparsedAddress": "145 COLUMBIA Street W Unit# 131, Waterloo, Ontario N2L0K7"
+"Coordinates": array:2 [
0 => -80.5381063
1 => 43.4764261
]
+"Latitude": 43.4764261
+"Longitude": -80.5381063
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Society145, one of Waterloo's premier luxury condominium communities! This stunning 1 bedroom suite offers a rare private walkout entrance, soaring 14 ft ceilings, and a bright, open concept layout that creates an exceptional sense of space. Enjoy modern finishes throughout and the convenience of ground floor l iving with direct outdoor access. Residents of Society145 have access to outstanding amenities, including a fully equipped fitness centre, indoor baseketball court, saunas, games room, movie theatre, concierge service, study lounges, and social spaces. Ideally located just steps from the University of Waterloo and Wilfrid Laurier University, with easy access to restaurants, shopping, transit, parks, and all the conveniences of Waterloo. Whether you're a student, young professional, or investor, this is an incredible opportunity to own in one of Waterloo's most sought after new developments. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "283.06"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-27T19:48:35.594599+00:00"
+"Directions": "Columbia and Phillip"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2078123"
+"ListOfficeKey": "283397"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-07-27T18:38:21Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-27T18:38:21Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "COLUMBIA"
+"StreetNumber": "145"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3136"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1694807335"
"RoomType" => "3pc Bathroom"
"ListingId" => "40850992"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30083272"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T18:38:21.63Z"
]
1 => array:11 [
"RoomKey" => "1694807336"
"RoomType" => "Bedroom"
"ListingId" => "40850992"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30083272"
"RoomLength" => null
"RoomDimensions" => "8'5'' x 9'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T18:38:21.63Z"
]
2 => array:11 [
"RoomKey" => "1694807337"
"RoomType" => "Living room"
"ListingId" => "40850992"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30083272"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 8'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T18:38:21.63Z"
]
3 => array:11 [
"RoomKey" => "1694807338"
"RoomType" => "Eat in kitchen"
"ListingId" => "40850992"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30083272"
"RoomLength" => null
"RoomDimensions" => "15'1'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T18:38:21.63Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30083272/145-columbia-street-w-unit-131-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RN-25"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 490
+"OriginalEntryTimestamp": "2026-07-27T18:38:21.61Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1352953"
+"ListOfficeNationalAssociationId": "1328541"
+"Media": array:34 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30083272_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/144e745bf0dca134cee67189091dac45.webp"
"MediaSize" => 119641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-144e745bf0dca134cee67189091dac45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30083272_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/7f51839c087e413889d9fc13288d236e.webp"
"MediaSize" => 124318
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-7f51839c087e413889d9fc13288d236e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30083272_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/34dce1800889aa530400bdbdfb326517.webp"
"MediaSize" => 120177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-34dce1800889aa530400bdbdfb326517.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30083272_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/6ba680fecc7f9337a9c49e56c75c2de8.webp"
"MediaSize" => 75405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-6ba680fecc7f9337a9c49e56c75c2de8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30083272_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/d9fe67cd0122698e5bcc9ce9c877ec49.webp"
"MediaSize" => 90259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-d9fe67cd0122698e5bcc9ce9c877ec49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30083272_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/298aa5073208d5b59514ccfe08af4d79.webp"
"MediaSize" => 88030
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-298aa5073208d5b59514ccfe08af4d79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30083272_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/ce62723b41476e8a8e9240c217b32094.webp"
"MediaSize" => 86034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-ce62723b41476e8a8e9240c217b32094.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30083272_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/6b32691b4685a9f5127e22b9721bf5cc.webp"
"MediaSize" => 97297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-6b32691b4685a9f5127e22b9721bf5cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30083272_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/295994014a5599a6ccda3bdd84b33a9e.webp"
"MediaSize" => 92656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-295994014a5599a6ccda3bdd84b33a9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30083272_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/8fa46b373114db64e21e64f89508203a.webp"
"MediaSize" => 88123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-8fa46b373114db64e21e64f89508203a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
10 => array:13 [
"Order" => 11
…12
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30083272')"
+"ID": "1662364"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25397
+post_id: "1661588"
+post_author: 1
+"ListingKey": "30081564"
+"ListingId": "40849396"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-27T14:40:20Z"
+"RFModificationTimestamp": "2026-07-27T17:18:15Z"
+"ListPrice": 775000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.18
+"LivingArea": 1872.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3T9"
+"UnparsedAddress": "285 ALBERT Street, Waterloo, Ontario N2L3T9"
+"Coordinates": array:2 [
0 => -80.5342011
1 => 43.4766498
]
+"Latitude": 43.4766498
+"Longitude": -80.5342011
+"YearBuilt": 1951
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this charming brick home on a premium corner lot in one of Waterloo's most sought-after neighbourhoods. Situated just minutes from the University of Waterloo, Wilfrid Laurier University, shopping, transit, parks, and everyday amenities, this well-maintained property offers exceptional flexibility for homeowners, investors, and future-minded buyers alike. Featuring over 1,800 square feet of finished living space, this home offers 4 bedrooms, 2 bathrooms, a separate entrance to the partially finished basement, and a functional layout ideal for family living, multi-generational use, or income-generating opportunities. The property was licensed by the City of Waterloo as a Class B 4-bedroom rental property through March 31, 2026, highlighting its established rental history and appeal in this high-demand university market. Outside, enjoy a private backyard retreat complete with an inground pool, mature landscaping, patio space, and ample parking including an attached garage. Whether you're looking for a home in a prime Waterloo location, an investment property with strong rental demand, or a property with long-term upside, this opportunity delivers. The property's prominent corner location at Albert Street and Hickory Street offers excellent exposure and future potential within Waterloo's rapidly evolving Northdale neighbourhood. Adjacent properties at 289, 291 and 293 Albert Street are also available for sale, creating a rare opportunity for purchasers to explore a potential land assembly and redevelopment project in one of the city's most active growth corridors. Enjoy the property today while securing a strategic real estate asset for tomorrow. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-27T17:17:55.433185+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Stove"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750163"
+"ListOfficeKey": "156288"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0.18"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-27T14:30:13Z"
+"PhotosCount": 22
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-27T14:30:13Z"
+"Stories": "1.5"
+"StreetName": "ALBERT"
+"StreetNumber": "285"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "6688.65"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30081564/285-albert-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1750102"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "156288"
+"GeocodeManualYN": true
+"ZoningDescription": "RN6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 55.0
+"AboveGradeFinishedArea": 1421
+"BelowGradeFinishedArea": 451
+"OriginalEntryTimestamp": "2026-07-27T14:30:13.38Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1131089"
+"ListOfficeNationalAssociationId": "1112493"
+"CoListAgentNationalAssociationId": "1066272"
+"CoListOfficeNationalAssociationId": "1112493"
+"Media": array:22 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30081564')"
+"ID": "1661588"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25401
+post_id: "1661082"
+post_author: 1
+"ListingKey": "30081330"
+"ListingId": "40850825"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-27T18:10:11Z"
+"RFModificationTimestamp": "2026-07-27T18:24:43Z"
+"ListPrice": 435999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 668.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E5"
+"UnparsedAddress": "158 KING Street N Unit# 2101, Waterloo, Ontario N2J2Y2"
+"Coordinates": array:2 [
0 => -80.5237304
1 => 43.4717316
]
+"Latitude": 43.4717316
+"Longitude": -80.5237304
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Sunlight, space, and an unbeatable Uptown Waterloo location! This bright fully furnished 2-bedroom, 2-bathroom condo features a spacious living area, in-suite laundry, and an oversized garage parking space. Walk to Uptown Waterloo, the University of Waterloo, Wilfrid Laurier University, shopping, restaurants, and the ION LRT. Enjoy fantastic building amenities including an exercise room, theatre room, and meeting room. A perfect opportunity for professionals, downsizers, students, or investors alike. All furniture included (except for bed/mattress in spare room). (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "483.99"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-27T14:01:24.642677+00:00"
+"Directions": "King St. N and Noecker St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2084847"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-07-27T18:03:26Z"
+"PhotosCount": 14
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-27T18:03:26Z"
+"Stories": "1.0"
+"StreetDirSuffix": "North"
+"StreetName": "KING"
+"StreetNumber": "158"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3566.33"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30081330/158-king-street-n-unit-2101-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 668
+"OriginalEntryTimestamp": "2026-07-27T13:38:45.12Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1358257"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:14 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30081330')"
+"ID": "1661082"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25399
+post_id: "1661059"
+post_author: 1
+"ListingKey": "30081240"
+"ListingId": "40849431"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-27T23:00:06Z"
+"RFModificationTimestamp": "2026-07-27T23:14:46Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.334
+"LivingArea": 2205.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3X6"
+"UnparsedAddress": "291 VILLA Place, Waterloo, Ontario N2J3X6"
+"Coordinates": array:2 [
0 => -80.5152523
1 => 43.4831403
]
+"Latitude": 43.4831403
+"Longitude": -80.5152523
+"YearBuilt": 1965
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled on a quiet, family-friendly cul-de-sac in one of Waterloo's most desirable neighbourhoods, this raised bungalow sits on an exceptionally rare 1/3-acre lot backing directly onto the Hillside Trail and Waterloo's extensive trail network. Offering privacy, space, and an incredible connection to nature, this is the kind of property where memories are made for generations. Step outside and discover a backyard oasis unlike anything else. Surrounded by mature landscaping, the expansive yard features a large covered deck, gazebo, in-ground pool with updated liner, pump and filter, and endless space for children to play, family gatherings, and summer entertaining. Whether you're hosting friends poolside or enjoying a quiet evening overlooking the greenspace, this outdoor retreat is truly an entertainer's dream. Inside, the bright main floor offers an open-concept kitchen and dining area with stone countertops, white cabinetry, centre island, JennAir gas range, Bosch dishwasher, glass tile backsplash, and engineered hardwood flooring. The welcoming living room features a wood-burning fireplace and walkout access to the front deck. Three bedrooms and an updated four-piece bathroom complete the main level. The finished walk-up lower level provides exceptional additional living space, including a spacious recreation room with natural gas fireplace and built-in cabinetry, a large games room with bar area, a cedar closet, three-piece bathroom, and laundry room. Additional updates include vinyl windows, ront door (2019), vinyl siding and eavestroughs (2018), roof (2018), and a rebuilt chimney (2026). The tandem garage accommodates two small vehicles and offers excellent storage. Properties offering this level of privacy, outdoor living, and direct access to nature are exceptionally rare in Waterloo. Don't miss your chance to secure a truly one-of-a-kind property in a location you'll treasure for years to come. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-27T13:36:17.367494+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564224"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.334"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-27T22:51:43Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-27T22:51:43Z"
+"Stories": "1.0"
+"StreetName": "VILLA"
+"StreetNumber": "291"
+"StreetSuffix": "Place"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "6029.81"
+"VirtualTourURLUnbranded": "https://youriguide.com/291_villa_place_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30081240/291-villa-place-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1976233"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283125"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 67.0
+"AboveGradeFinishedArea": 1180
+"BelowGradeFinishedArea": 1025
+"OriginalEntryTimestamp": "2026-07-27T13:08:25.87Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1102433"
+"ListOfficeNationalAssociationId": "1378680"
+"CoListAgentNationalAssociationId": "1262688"
+"CoListOfficeNationalAssociationId": "1324759"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30081240')"
+"ID": "1661059"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25394
+post_id: "1659904"
+post_author: 1
+"ListingKey": "30079766"
+"ListingId": "40851140"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-25T23:35:16Z"
+"RFModificationTimestamp": "2026-07-25T23:39:13Z"
+"ListPrice": 489000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 612.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3W5"
+"UnparsedAddress": "246 LESTER Street Unit# 1107, Waterloo, Ontario N2L3W5"
+"Coordinates": array:2 [
0 => -80.5342054
1 => 43.4735405
]
+"Latitude": 43.4735405
+"Longitude": -80.5342054
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Prime Waterloo Location — Steps to UW & WLU. An opportunity you simply don’t want to miss! This exceptionally well-maintained 1+1 bedroom, 2-bathroom condooffers a spacious den with large windows that can easily be used as a second bedroom, home office, or study space.Enjoy breathtaking views and abundant natural sunlight from the balcony. Featuring approximately 9-foot ceilings, an open-concept layout, and a modern kitchen, this home is ideal for students, young professionals, or investors. PROPERTY HIGHLIGHTS: 1 Bedroom + Spacious Den;2 Full Bathrooms;Den with Large Windows — Perfect for a Second Bedroom;Fully Furnished;Approximately 9-Foot Ceilings;Open-Concept Living & Dining Area; Private Balcony with Beautiful Views & Plenty of sunshine ; In-Suite Laundry; MODERN KITCHEN;Open-concept design;Modern cabinetry;Quartz countertops;Stainless steel appliances. BUILDING AMENITIES: Party Room;Rooftop Terrace; Study Room;Exercise Room;Visitor Parking; Security System in Common Areas UNBEATABLE LOCATION: 5-minute walk to the University of Waterloo;Steps to Wilfrid Laurier University;Close to Plaza & Supermarket;Surrounded by Restaurants, Shops & Daily Amenities; Convenient Public Transit Access A PERFECT OPPORTUNITY FOR STUDENTS, PROFESSIONALS & INVESTORS! Don’t miss your chance to own or rent this exceptional unit in one of Waterloo’s most desirable locations! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "363.32"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "High Traffic Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-25T22:47:38.794246+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2162407"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-07-25T23:20:25Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-25T23:28:23Z"
+"Stories": "12.0"
+"StreetName": "LESTER"
+"StreetNumber": "246"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2706.98"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30079766/246-lester-street-unit-1107-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "NMU12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 612
+"OriginalEntryTimestamp": "2026-07-25T19:28:39.96Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1413428"
+"ListOfficeNationalAssociationId": "1452740"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30079766')"
+"ID": "1659904"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23598
+post_id: "1659878"
+post_author: 1
+"ListingKey": "30079841"
+"ListingId": "40839997"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-25T20:20:10Z"
+"RFModificationTimestamp": "2026-07-25T22:42:55Z"
+"ListPrice": 272500.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1205.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5G6"
+"UnparsedAddress": "65 WESTMOUNT Road N Unit# 304, Waterloo, Ontario N2L5G6"
+"Coordinates": array:2 [
0 => -80.5394699
1 => 43.4616849
]
+"Latitude": 43.4616849
+"Longitude": -80.5394699
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Westmount Towers II-Here is your opporunity to own a bright and spacious 2 bedroom condo unit in an ideal location and at an exceptional value! Located in one of Waterloo's most desirable areas within walking distance to University's, Uptown Waterloo, numerous shops and restaurants, Waterloo Park and so much more. This unit offers low maintenance, care free living with your condo fees including ALL utilities. Unit 304 is a bright and spacious 2 bedroom, 2 bathroom unit and includes an underground parking space and storgage locker. The kitchen includes newer stainless steel appliances. The large primary bedroom includes a spacious walk in closet and a 2-piece ensuite bath. Here is your chance to get into affordable home ownership in the heart of Waterloo. (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Hood Fan"
]
+"AssociationFee": "1090"
+"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 => "Window air conditioner"
]
+"CreationDate": "2026-07-25T22:42:43.043324+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Hot water radiator heat"
1 => "Baseboard heaters"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1935309"
+"ListOfficeKey": "292076"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Laundry- Coin operated"
2 => "No Pet Home"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-25T20:11:28Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-25T20:11:28Z"
+"Stories": "9.0"
+"StreetDirSuffix": "North"
+"StreetName": "WESTMOUNT"
+"StreetNumber": "65"
+"StreetSuffix": "Road"
+"SubdivisionName": "417 - Beechwood/University"
+"VirtualTourURLUnbranded": "https://youriguide.com/65_westmount_rd_n_304_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30079841/65-westmount-road-n-unit-304-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1904174"
+"CoListOfficeKey": "292076"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 500.0
+"AboveGradeFinishedArea": 1205
+"OriginalEntryTimestamp": "2026-07-25T20:10:13.31Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1234734"
+"ListOfficeNationalAssociationId": "1408082"
+"CoListAgentNationalAssociationId": "1219174"
+"CoListOfficeNationalAssociationId": "1408082"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30079841')"
+"ID": "1659878"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25402
+post_id: "1658885"
+post_author: 1
+"ListingKey": "30009471"
+"ListingId": "X13541492"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-12T16:30:03Z"
+"RFModificationTimestamp": "2026-07-25T07:29:27Z"
+"ListPrice": 274900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0G4"
+"UnparsedAddress": "501 - 321 SPRUCE STREET, Waterloo, Ontario N2L0G4"
+"Coordinates": array:2 [
0 => -80.52726
1 => 43.479262
]
+"Latitude": 43.479262
+"Longitude": -80.52726
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "London and St. Thomas Association of REALTORS®"
+"PublicRemarks": "Experience luxury and convenience in this bright 1+1 bedroom condo in the heart of Waterloo, just steps from University of Waterloo, Wilfrid Laurier University, and Conestoga College. Featuring high-end finishes, stainless steel appliances, quartz countertops, and floor-to-ceiling windows, this fully furnished unit offers a spacious den that can serve as a second bedroom or office, in-suite laundry, and included high-speed internet and weekly housekeeping. Residents enjoy concierge service, an exercise/recreation room, a rooftop patio, and guest suites in this well-maintained, modern building. Immediate occupancy is available book your viewing today! (id:62650)"
+"AssociationFee": "739.57"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-25T07:29:21.909464+00:00"
+"Directions": "Cross Streets: King and University. ** Directions: From Columbia St W turn onto Spruce St."
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100467"
+"ListOfficeKey": "302124"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T04:50:41Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-12T16:20:32Z"
+"StreetName": "Spruce"
+"StreetNumber": "321"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3452"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "London and St. Thomas"
+"ListAORKey": "13"
+"ListingURL": "www.realtor.ca/real-estate/30009471/501-321-spruce-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Condo Board Self Manage"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-07-09T04:50:40.98Z"
+"ListAgentNationalAssociationId": "1370499"
+"ListOfficeNationalAssociationId": "1498650"
+"Media": array:13 [
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]
]
+"DaysOnMarket": 18
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30009471')"
+"ID": "1658885"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25403
+post_id: "1658495"
+post_author: 1
+"ListingKey": "30078622"
+"ListingId": "40851073"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-25T00:45:05Z"
+"RFModificationTimestamp": "2026-07-25T01:37:15Z"
+"ListPrice": 749000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2088.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3K7"
+"UnparsedAddress": "223 CARTER Avenue, Waterloo, Ontario N2J3K7"
+"Coordinates": array:2 [
0 => -80.5143402
1 => 43.4790371
]
+"Latitude": 43.4790371
+"Longitude": -80.5143402
+"YearBuilt": 1966
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover Mid-Century Charm Re-imagined with Modern Luxury. Perfectly positioned and completely transformed, this 4-bedroom, 2-bathroom residence offers an unparalleled turnkey lifestyle. From the curb this home commands immediate attention with the poured concrete walkway, immaculate lawn, and a striking front porch overhang featuring a warm cedar ceiling—a prelude to the architectural details within. Step inside to an open-concept living space unified by rich engineered hardwood flooring and a spectacular custom cedar ceiling that radiates organic warmth. The heart of the home is the bespoke chef’s kitchen, thoughtfully designed with custom Eucalyptus green cabinetry, a sprawling island, quartz counter-tops, airy exposed shelving, and an integrated hideaway bar cabinet to elevate your hosting game. Down the hall, the main bath has been re-imagined into a spa-like oasis, boasting custom cabinetry, quartz counters, refined gold trim, heated flooring, and a heated towel rack. The finished lower level maximizes both utility and leisure. Gather for movie nights anchored by a sleek gas fireplace, or entertain at the custom bar with seating. This versatile level also hosts a spacious fourth bedroom—that could double as a home gym or office—a beautifully appointed 3-piece bathroom, and a streamlined laundry and large storage area. The sophistication extends into a private backyard sanctuary. Designed for effortless enjoyment, the yard features a custom-poured concrete patio accented with detailed architectural ledges and finishes. Surrounded by professional, low-maintenance landscaping, it is the ultimate setting for alfresco dining. A premium steel storage shed completes the outdoor space. Situated in a highly desirable, family-friendly Waterloo neighbourhood, this home is moments from top-tier schools and parks. Every detail of 223 Carter Avenue has been meticulously executed, offering a rare blend of custom craftsmanship and move-in-ready living. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-25T01:37:05.447430+00:00"
+"Directions": "Lincoln Rd, to Marshall, to Carter Ave."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "In Floor Heating"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1953837"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Crushed stone driveway"
]
+"PhotosChangeTimestamp": "2026-07-25T00:38:09Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-25T00:38:09Z"
+"Stories": "1.0"
+"StreetName": "CARTER"
+"StreetNumber": "223"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "4081.94"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/223-carter-ave"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30078622/223-carter-avenue-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1050
+"BelowGradeFinishedArea": 1038
+"OriginalEntryTimestamp": "2026-07-25T00:38:09.75Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1247007"
+"ListOfficeNationalAssociationId": "1473831"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30078622')"
+"ID": "1658495"
}
]
+success: true
+page_size: 9
+page_count: 43
+count: 387
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]