array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29843498 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23331
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23333
+post_id: "1487471"
+post_author: 1
+"ListingKey": "29843498"
+"ListingId": "X13231076"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T20:25:44Z"
+"RFModificationTimestamp": "2026-06-05T20:30:43Z"
+"ListPrice": 1299000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2M3"
+"UnparsedAddress": "236 NEILSON AVENUE, Waterloo, Ontario N2J2M3"
+"Coordinates": array:2 [
0 => -80.503783
1 => 43.473402
]
+"Latitude": 43.473402
+"Longitude": -80.503783
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 236 Neilson Avenue - a stunning custom-built luxury home in Waterloo's Lincoln Heights, minutes from the University of Waterloo, Wilfrid Laurier, Conestoga Mall, and Highway 85. The massive stamped concrete driveway sets the tone the moment you arrive. Step inside to soaring 9-foot ceilings and an open-concept main floor flooded with natural light. The main level features a versatile flex space with its own full bathroom - perfect as a home office, bedroom, in-law setup, or lounge. The chef's kitchen impresses with a 10-foot quartz island, high-end built-in appliances, stone backsplash, soft-close dual-tone cabinetry, and a dedicated water filtration system. Just off the kitchen, the sunroom with skylight is your year-round retreat for work, reading, or unwinding. Entertain effortlessly with a built-in 5.1 surround sound system and Sonos-powered ceiling speakers throughout. Upstairs, four generous bedrooms and three full bathrooms include a luxurious primary suite with 5-piece ensuite and specialized roller shutters for total privacy. The fully finished basement offers two bedrooms, a full bathroom, and a spacious rec room - ideal as a mortgage helper, in-law suite, or family retreat. Outside, over 1,100 square feet of interlocking stonework and beautiful gardens create the perfect entertaining oasis. The finished garage features built-in shelving, smart openers, and pre-installed Level 2 EV charger wiring. Refined, move-in-ready luxury - book your private showing today! (id:62650)"
+"Appliances": array:14 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Gas stove(s)"
6 => "Dishwasher"
7 => "Dryer"
8 => "Microwave"
9 => "Oven - Built-In"
10 => "Hood Fan"
11 => "Garage door opener"
12 => "Garage door opener remote(s)"
13 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-03T01:06:05.433923+00:00"
+"Directions": "Cross Streets: Bridgeport Road/Margaret Ave. ** Directions: From Highway 7, take the exit toward Waterloo and continue on regional roads to Neilson Avenue."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2138456"
+"ListOfficeKey": "300584"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "Sump Pump"
]
+"LotSizeDimensions": "50 x 120 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-02T22:44:43Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T20:15:32Z"
+"Stories": "2.0"
+"StreetName": "Neilson"
+"StreetNumber": "236"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "9096"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://virtualtours.jarts360view.com/236-neilson-avenue-waterloo/nb/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1652633603"
"RoomType" => "Dining room"
"ListingId" => "X13231076"
"RoomLevel" => "Main level"
"RoomWidth" => 4.72
"ListingKey" => "29843498"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T20:15:32.58Z"
]
1 => array:11 [
"RoomKey" => "1652633604"
"RoomType" => "Bedroom"
"ListingId" => "X13231076"
"RoomLevel" => "Basement"
"RoomWidth" => 4.62
"ListingKey" => "29843498"
"RoomLength" => 4.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T20:15:32.58Z"
]
2 => array:11 [
"RoomKey" => "1652633605"
"RoomType" => "Bedroom"
"ListingId" => "X13231076"
"RoomLevel" => "Basement"
"RoomWidth" => 3.94
"ListingKey" => "29843498"
"RoomLength" => 3.89
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T20:15:32.58Z"
]
3 => array:11 [
"RoomKey" => "1652633606"
"RoomType" => "Cold room"
"ListingId" => "X13231076"
"RoomLevel" => "Basement"
"RoomWidth" => 1.35
"ListingKey" => "29843498"
"RoomLength" => 4.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T20:15:32.59Z"
]
4 => array:11 [
"RoomKey" => "1652633607"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13231076"
"RoomLevel" => "Basement"
"RoomWidth" => 9.22
"ListingKey" => "29843498"
"RoomLength" => 4.52
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T20:15:32.59Z"
]
5 => array:11 [
"RoomKey" => "1652633608"
"RoomType" => "Utility room"
"ListingId" => "X13231076"
"RoomLevel" => "Basement"
"RoomWidth" => 4.52
"ListingKey" => "29843498"
"RoomLength" => 3.89
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T20:15:32.59Z"
]
6 => array:11 [
"RoomKey" => "1652633609"
"RoomType" => "Family room"
"ListingId" => "X13231076"
"RoomLevel" => "Main level"
"RoomWidth" => 5.38
"ListingKey" => "29843498"
"RoomLength" => 4.01
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T20:15:32.59Z"
]
7 => array:11 [
"RoomKey" => "1652633610"
"RoomType" => "Kitchen"
"ListingId" => "X13231076"
"RoomLevel" => "Main level"
"RoomWidth" => 7.32
"ListingKey" => "29843498"
"RoomLength" => 3.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T20:15:32.6Z"
]
8 => array:11 [
"RoomKey" => "1652633611"
"RoomType" => "Living room"
"ListingId" => "X13231076"
"RoomLevel" => "Main level"
"RoomWidth" => 3.28
"ListingKey" => "29843498"
"RoomLength" => 4.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T20:15:32.6Z"
]
9 => array:11 [
"RoomKey" => "1652633612"
"RoomType" => "Office"
"ListingId" => "X13231076"
"RoomLevel" => "Main level"
"RoomWidth" => 3.3
"ListingKey" => "29843498"
"RoomLength" => 3.12
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T20:15:32.6Z"
]
10 => array:11 [
"RoomKey" => "1652633613"
"RoomType" => "Sunroom"
"ListingId" => "X13231076"
"RoomLevel" => "Main level"
"RoomWidth" => 2.69
"ListingKey" => "29843498"
"RoomLength" => 2.64
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T20:15:32.6Z"
]
11 => array:11 [
"RoomKey" => "1652633614"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13231076"
"RoomLevel" => "Second level"
"RoomWidth" => 4.93
"ListingKey" => "29843498"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T20:15:32.6Z"
]
12 => array:11 [
"RoomKey" => "1652633615"
"RoomType" => "Bedroom"
"ListingId" => "X13231076"
"RoomLevel" => "Second level"
"RoomWidth" => 4.29
"ListingKey" => "29843498"
"RoomLength" => 3.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T20:15:32.6Z"
]
13 => array:11 [
"RoomKey" => "1652633616"
"RoomType" => "Bedroom"
"ListingId" => "X13231076"
"RoomLevel" => "Second level"
"RoomWidth" => 4.37
"ListingKey" => "29843498"
"RoomLength" => 4.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T20:15:32.61Z"
]
14 => array:11 [
"RoomKey" => "1652633617"
"RoomType" => "Bedroom"
"ListingId" => "X13231076"
"RoomLevel" => "Second level"
"RoomWidth" => 5.11
"ListingKey" => "29843498"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-05T20:15:32.61Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29843498/236-neilson-avenue-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Security system"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-06-02T22:44:43.23Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1390410"
+"ListOfficeNationalAssociationId": "1490403"
+"Media": array:41 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29843498_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/c11e0512601efc37628138df4d499a41.webp"
"MediaSize" => 128800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-c11e0512601efc37628138df4d499a41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29843498_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/4b71c17655a2710b92a2152c368160b1.webp"
"MediaSize" => 173524
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-4b71c17655a2710b92a2152c368160b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29843498_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/ab77ddc1f6a4d4452b56b6a900f16114.webp"
"MediaSize" => 195257
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-ab77ddc1f6a4d4452b56b6a900f16114.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29843498_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/c494eb57a54bca201f461adf3c57cb4f.webp"
"MediaSize" => 90228
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-c494eb57a54bca201f461adf3c57cb4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29843498_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/0f9939db02d5fe2306441a19fbcce758.webp"
"MediaSize" => 58768
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-0f9939db02d5fe2306441a19fbcce758.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29843498_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/45c957ca0b4befcbb1bda99a62aef8a9.webp"
"MediaSize" => 109328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-45c957ca0b4befcbb1bda99a62aef8a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29843498_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/9d1a5961bd287c05d8083464b6cf289c.webp"
"MediaSize" => 97329
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-9d1a5961bd287c05d8083464b6cf289c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29843498_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/9fb5e1f06c5d4e7bc00fbba4ec7ec384.webp"
"MediaSize" => 118609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-9fb5e1f06c5d4e7bc00fbba4ec7ec384.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29843498_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/eef0bdafbc26054e17bda1e0b20217fb.webp"
"MediaSize" => 80088
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-eef0bdafbc26054e17bda1e0b20217fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29843498_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/327d4034fd34a3d5ef4045f4b94518f1.webp"
"MediaSize" => 116301
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-327d4034fd34a3d5ef4045f4b94518f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29843498_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/d5253ece7c8e814e7a183c72f6c3163c.webp"
"MediaSize" => 110835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-d5253ece7c8e814e7a183c72f6c3163c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29843498_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/886215b06855f98c232cdb494aaa8144.webp"
"MediaSize" => 94580
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-886215b06855f98c232cdb494aaa8144.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29843498_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/b3ee8c41bf17a1306be8413111ad37fe.webp"
"MediaSize" => 84028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-b3ee8c41bf17a1306be8413111ad37fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29843498_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/164743ff8ac2e9702fb6c6ccde421f78.webp"
"MediaSize" => 117718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-164743ff8ac2e9702fb6c6ccde421f78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29843498_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/39c173a342ea2d592ab34d13f27f94f0.webp"
"MediaSize" => 66392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-39c173a342ea2d592ab34d13f27f94f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29843498_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/c26dd5f0d2995dfe667fbaf894a45d58.webp"
"MediaSize" => 66865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-c26dd5f0d2995dfe667fbaf894a45d58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29843498_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/86e2caa9a8e10f65a140bf51b7671a77.webp"
"MediaSize" => 56259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-86e2caa9a8e10f65a140bf51b7671a77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29843498_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/dca4917a8699d4167b08826aad23bddc.webp"
"MediaSize" => 62097
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-dca4917a8699d4167b08826aad23bddc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29843498_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/3399d95371969e1016c31aa0f176a52d.webp"
"MediaSize" => 68775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-3399d95371969e1016c31aa0f176a52d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29843498_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/443d727081c31350a1e3c97c2c2319e2.webp"
"MediaSize" => 84082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-443d727081c31350a1e3c97c2c2319e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29843498_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/62057d01d5f3e50d8593b8574c22dcf5.webp"
"MediaSize" => 53016
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-62057d01d5f3e50d8593b8574c22dcf5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29843498_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/65e5af8b06ba3d893862ca672fb6951a.webp"
"MediaSize" => 71758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-65e5af8b06ba3d893862ca672fb6951a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29843498_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/3d30d5d27a633cfb33b17a40cd19ab38.webp"
"MediaSize" => 87815
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-3d30d5d27a633cfb33b17a40cd19ab38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29843498_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/4103e22d44ac639c0ab19f92bbc63274.webp"
"MediaSize" => 66049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-4103e22d44ac639c0ab19f92bbc63274.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29843498_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/f80874e726ec7376592cbde6e7818d1b.webp"
"MediaSize" => 59823
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-f80874e726ec7376592cbde6e7818d1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29843498_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/3da33b8c96e731f9031dc9558b538f56.webp"
"MediaSize" => 69445
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-3da33b8c96e731f9031dc9558b538f56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29843498_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/43919d103386252f86751adf87fde9f9.webp"
"MediaSize" => 65927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-43919d103386252f86751adf87fde9f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29843498_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/2262d65c5135887465d49c2d02b0102d.webp"
"MediaSize" => 94701
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-2262d65c5135887465d49c2d02b0102d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29843498_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/758db5307ad55382b59a4a9d16408886.webp"
"MediaSize" => 120508
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-758db5307ad55382b59a4a9d16408886.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29843498_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/c596a7ab573e53257f6b9f9b02b14f40.webp"
"MediaSize" => 99073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-c596a7ab573e53257f6b9f9b02b14f40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29843498_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/6c7c690bd1f48f02d279015c770d9c35.webp"
"MediaSize" => 57465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-6c7c690bd1f48f02d279015c770d9c35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29843498_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/63d4dc1865b7111d9e2d078225d501bc.webp"
"MediaSize" => 61588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-63d4dc1865b7111d9e2d078225d501bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29843498_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/68309cec9d2b78a685607009a5c1a5f1.webp"
"MediaSize" => 89936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-68309cec9d2b78a685607009a5c1a5f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29843498_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/5c613ebb0dbef7afee46709cbab2185a.webp"
"MediaSize" => 63145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-5c613ebb0dbef7afee46709cbab2185a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29843498_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/1eeb13aa87d0ce60a67500f07d6d36db.webp"
"MediaSize" => 51539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-1eeb13aa87d0ce60a67500f07d6d36db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29843498_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/1991472b941f9fff4e87e842b0e99258.webp"
"MediaSize" => 53080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-1991472b941f9fff4e87e842b0e99258.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29843498_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/b5c9f5f3510651bfcf7e6b312922b2b1.webp"
"MediaSize" => 90743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-b5c9f5f3510651bfcf7e6b312922b2b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29843498_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/d932f7017036265bdeca05d163f4cbd6.webp"
"MediaSize" => 120927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-d932f7017036265bdeca05d163f4cbd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29843498_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/07af418038f0194d09c7ff451b4823d9.webp"
"MediaSize" => 187561
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-07af418038f0194d09c7ff451b4823d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29843498_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/d20d25ff6fa4b8fb6a794fc5fa7bc67a.webp"
"MediaSize" => 251159
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-d20d25ff6fa4b8fb6a794fc5fa7bc67a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29843498_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29843498/4b8ec9b3b3f24204a7c9353915d4d20b.webp"
"MediaSize" => 132909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29843498/thumbnail-4b8ec9b3b3f24204a7c9353915d4d20b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13231076"
"ResourceRecordKey" => "29843498"
"ModificationTimestamp" => "2026-06-02T22:44:43.23Z"
]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29843498')"
+"ID": "1487471"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 300584" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24691
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2138456" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24776
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29843498'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25097
+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 '29843498'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25115
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25113
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31336567"
+"ListingKey": "29843498"
+"ListingId": "X13231076"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-06"
+"OpenHouseStartTime": "2026-06-06T14:00:00Z"
+"OpenHouseEndTime": "2026-06-06T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-07T05:20:19Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31336567')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29843498' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.503783 43.473402)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25188
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25181
+post_id: "1504361"
+post_author: 1
+"ListingKey": "29867079"
+"ListingId": "X13411634"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-07T03:31:02Z"
+"RFModificationTimestamp": "2026-06-07T04:33:22Z"
+"ListPrice": 529990.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4L8"
+"UnparsedAddress": "13 - 285 BLUEVALE STREET N, Waterloo, Ontario N2J4L8"
+"Coordinates": array:2 [
0 => -80.5006995
1 => 43.4814054
]
+"Latitude": 43.4814054
+"Longitude": -80.5006995
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "London and St. Thomas Association of REALTORS®"
+"PublicRemarks": "Welcome to 13-285 Bluevale St N set up on top of the hill over looking the treed complex to the front and trees to the back. Very quiet and far away from the main road. This home boasts a large eat in kitchen with dining and living room. Step out through the back patio door into a green enclosed back yard. A little peace of heaven where you can BBQ and entertain your friends. Second floor has a large master bedroom and 2 more spacious bedrooms with a beautiful 4 pc bathroom. The basement has a den/4th bedroom and a 3 pc washroom. No carpet. Close to Conestoga Mall, Conestoga College, Waterloo University, YMCA and Parks. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Water Heater"
]
+"AssociationFee": "500"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-07T04:33:17.000028+00:00"
+"Directions": "Cross Streets: University Ave E and Lincoln Rd. ** Directions: Harvard PL to Bluevale St N."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2063124"
+"ListOfficeKey": "300585"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-07T03:22:06Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-07T03:22:06Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "Bluevale"
+"StreetNumber": "285"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2534"
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1653773991"
"RoomType" => "Kitchen"
"ListingId" => "X13411634"
"RoomLevel" => "Main level"
"RoomWidth" => 4.73
"ListingKey" => "29867079"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T03:22:06.53Z"
]
1 => array:11 [
"RoomKey" => "1653773992"
"RoomType" => "Dining room"
"ListingId" => "X13411634"
"RoomLevel" => "Main level"
"RoomWidth" => 3.49
"ListingKey" => "29867079"
"RoomLength" => 2.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T03:22:06.53Z"
]
2 => array:11 [
"RoomKey" => "1653773993"
"RoomType" => "Living room"
"ListingId" => "X13411634"
"RoomLevel" => "Main level"
"RoomWidth" => 5.01
"ListingKey" => "29867079"
"RoomLength" => 3.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T03:22:06.53Z"
]
3 => array:11 [
"RoomKey" => "1653773994"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13411634"
"RoomLevel" => "Second level"
"RoomWidth" => 4.19
"ListingKey" => "29867079"
"RoomLength" => 2.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T03:22:06.53Z"
]
4 => array:11 [
"RoomKey" => "1653773995"
"RoomType" => "Bedroom 2"
"ListingId" => "X13411634"
"RoomLevel" => "Second level"
"RoomWidth" => 3.96
"ListingKey" => "29867079"
"RoomLength" => 3.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T03:22:06.53Z"
]
5 => array:11 [
"RoomKey" => "1653773996"
"RoomType" => "Bedroom 3"
"ListingId" => "X13411634"
"RoomLevel" => "Second level"
"RoomWidth" => 3.76
"ListingKey" => "29867079"
"RoomLength" => 3.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T03:22:06.53Z"
]
6 => array:11 [
"RoomKey" => "1653773997"
"RoomType" => "Bedroom 4"
"ListingId" => "X13411634"
"RoomLevel" => "Basement"
"RoomWidth" => 3.03
"ListingKey" => "29867079"
"RoomLength" => 2.64
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T03:22:06.54Z"
]
7 => array:11 [
"RoomKey" => "1653773998"
"RoomType" => "Laundry room"
"ListingId" => "X13411634"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29867079"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-07T03:22:06.54Z"
]
]
+"ListAOR": "London and St. Thomas"
+"TaxYear": 2026
+"ListAORKey": "13"
+"ListingURL": "www.realtor.ca/real-estate/29867079/13-285-bluevale-street-n-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2063128"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Lee Management Solutions"
+"CoListOfficeKey": "300585"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-07T03:22:06.4Z"
+"ListAgentNationalAssociationId": "1338032"
+"ListOfficeNationalAssociationId": "1490392"
+"CoListAgentNationalAssociationId": "1338063"
+"CoListOfficeNationalAssociationId": "1490392"
+"Media": array:43 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29867079_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867079/30736f6afd033cf53b9b00148000888a.webp"
"MediaSize" => 449622
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867079/thumbnail-30736f6afd033cf53b9b00148000888a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13411634"
"ResourceRecordKey" => "29867079"
"ModificationTimestamp" => "2026-06-07T03:22:06.41Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29867079_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867079/81896c25fc04eaa85f54bf1a2ac5e3ac.webp"
"MediaSize" => 413904
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867079/thumbnail-81896c25fc04eaa85f54bf1a2ac5e3ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411634"
"ResourceRecordKey" => "29867079"
"ModificationTimestamp" => "2026-06-07T03:22:06.41Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29867079_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867079/294ea3350cf5cc6b461addf69dfec7ad.webp"
"MediaSize" => 344461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867079/thumbnail-294ea3350cf5cc6b461addf69dfec7ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411634"
"ResourceRecordKey" => "29867079"
"ModificationTimestamp" => "2026-06-07T03:22:06.41Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29867079_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867079/9fe50ed9ccddb099308fc3bc82857871.webp"
"MediaSize" => 125877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867079/thumbnail-9fe50ed9ccddb099308fc3bc82857871.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411634"
"ResourceRecordKey" => "29867079"
"ModificationTimestamp" => "2026-06-07T03:22:06.41Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29867079_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867079/b3e0d805fb5c9dbb043cddb9dd0aad79.webp"
"MediaSize" => 187588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867079/thumbnail-b3e0d805fb5c9dbb043cddb9dd0aad79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411634"
"ResourceRecordKey" => "29867079"
"ModificationTimestamp" => "2026-06-07T03:22:06.41Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29867079_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867079/7d8155f2ee28f6f9a007bfebb21cebd5.webp"
"MediaSize" => 184948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867079/thumbnail-7d8155f2ee28f6f9a007bfebb21cebd5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411634"
"ResourceRecordKey" => "29867079"
"ModificationTimestamp" => "2026-06-07T03:22:06.41Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29867079_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867079/bf378a3c65e7b60708230e639c10eccd.webp"
"MediaSize" => 225219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867079/thumbnail-bf378a3c65e7b60708230e639c10eccd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411634"
"ResourceRecordKey" => "29867079"
"ModificationTimestamp" => "2026-06-07T03:22:06.41Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29867079_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867079/70be5cff9b12c7dea748a0932136d918.webp"
"MediaSize" => 261427
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867079/thumbnail-70be5cff9b12c7dea748a0932136d918.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411634"
"ResourceRecordKey" => "29867079"
"ModificationTimestamp" => "2026-06-07T03:22:06.41Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29867079_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867079/8e7f2b02b68bb1817e4b3a56328ade85.webp"
"MediaSize" => 190862
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867079/thumbnail-8e7f2b02b68bb1817e4b3a56328ade85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411634"
"ResourceRecordKey" => "29867079"
"ModificationTimestamp" => "2026-06-07T03:22:06.41Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29867079_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867079/37ced888218c61b6e66ddb4c020205b2.webp"
"MediaSize" => 203548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867079/thumbnail-37ced888218c61b6e66ddb4c020205b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411634"
"ResourceRecordKey" => "29867079"
"ModificationTimestamp" => "2026-06-07T03:22:06.41Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29867079_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867079/da2f1254a770be522b721b1a97c12e4d.webp"
"MediaSize" => 222944
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29867079/thumbnail-da2f1254a770be522b721b1a97c12e4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13411634"
"ResourceRecordKey" => "29867079"
"ModificationTimestamp" => "2026-06-07T03:22:06.41Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29867079_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29867079/49f8d2f086878e0b853b993b215087f2.webp"
…10
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29867079')"
+"ID": "1504361"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25184
+post_id: "1502275"
+post_author: 1
+"ListingKey": "29864897"
+"ListingId": "40837030"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T01:15:21Z"
+"RFModificationTimestamp": "2026-06-06T01:35:14Z"
+"ListPrice": 888000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2104.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3H6"
+"UnparsedAddress": "8 HICKORY Street W Unit# 1105, Waterloo, Ontario N2L3H6"
+"Coordinates": array:2 [
0 => -80.5261101
1 => 43.4781786
]
+"Latitude": 43.4781786
+"Longitude": -80.5261101
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Luxury Penthouse Living in the Heart of Waterloo – Fully Furnished, Turn-Key & Prime Investment Opportunity. Experience exceptional penthouse living in this spectacular two-level suite, perfectly positioned on the top (11th) floor of a modern, upscale Waterloo residence. Offering over 2,100 sq. ft. of beautifully finished living space, this rare property combines sophisticated design, sweeping sunset views, and unmatched convenience; just steps from Wilfrid Laurier University and the University of Waterloo. Flooded with natural light, the contemporary 5-bedroom, 5-bathroom layout includes a dramatic two-storey lounge with soaring 20-ft ceilings, an open-concept gourmet kitchen complete with a large island and walk-in pantry, and full in-suite laundry. Spacious bedrooms feature private ensuite bathrooms, while the fifth bedroom enjoys direct access to the impressive two-storey balcony; an ideal space for entertaining or relaxing with panoramic city views. Thoughtfully furnished and fully equipped with appliances, this penthouse is entirely turn-key, offering a premium rental rate already secured - a hassle-free opportunity for both student housing and executive rental investors. Located in a high-demand neighbourhood, residents also benefit from outstanding building amenities including a fitness centre, social lounge, underground parking, and secure bike storage. note: Some images include virtual staging for illustration purposes. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "998.31"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Water"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-06T01:35:03.202741+00:00"
+"Directions": "King North / Hickory"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1992499"
+"ListOfficeKey": "274404"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-06T01:11:33Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T01:11:33Z"
+"Stories": "2.0"
+"StreetDirSuffix": "West"
+"StreetName": "HICKORY"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "7878"
+"View": "City view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29864897/8-hickory-street-w-unit-1105-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Monitored Alarm"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 2104
+"OriginalEntryTimestamp": "2026-06-06T01:09:24.25Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1275774"
+"ListOfficeNationalAssociationId": "1254957"
+"Media": array:24 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29864897')"
+"ID": "1502275"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25161
+post_id: "1501320"
+post_author: 1
+"ListingKey": "29863859"
+"ListingId": "X13259834"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T22:00:35Z"
+"RFModificationTimestamp": "2026-06-05T22:47:23Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J1A4"
+"UnparsedAddress": "516 - 103 ROGER STREET, Waterloo, Ontario N2J1A4"
+"Coordinates": array:2 [
0 => -80.510151
1 => 43.460097
]
+"Latitude": 43.460097
+"Longitude": -80.510151
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright & Spacious 2 Bdrm & 1 Bthrm Condo In Sought-After 'Uptown' Waterloo! Spur Line Common Development Built By Reputable Local Builder - Reid's Heritage Homes, Open Concept, 9 Ft Ceilings, Neutral Colours, Floor-To-Ceiling Windows, Quality Laminate Flooring, Kitchen w/ Island & Breakfast Bar, Backsplash, Stainless Steel Appliances & Quartz Counters, Pot Lights Thru-Out, Spacious Bdrms, Large Balcony w/ Unique View, 1 Car Parking, Walk To LRT, Spur Line Trail, Parks, Both Universities+++ (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Water Heater"
]
+"AssociationFee": "458.58"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T22:47:14.147065+00:00"
+"Directions": "Roger St & Moore Ave"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1527824"
+"ListOfficeKey": "280225"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Elevator"
1 => "Balcony"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-05T21:53:57Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T21:53:57Z"
+"StreetName": "Roger"
+"StreetNumber": "103"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4233.13"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29863859/516-103-roger-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Duka Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:3 [
0 => "Separate Heating Controls"
1 => "Party Room"
2 => "Visitor Parking"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-05T21:53:57.47Z"
+"ListAgentNationalAssociationId": "1130582"
+"ListOfficeNationalAssociationId": "1310773"
+"Media": array:37 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29863859')"
+"ID": "1501320"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25185
+post_id: "1499986"
+post_author: 1
+"ListingKey": "29861307"
+"ListingId": "X13248670"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T17:40:54Z"
+"RFModificationTimestamp": "2026-06-05T18:43:22Z"
+"ListPrice": 450000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2X9"
+"UnparsedAddress": "710 - 128 KING STREET N, Waterloo, Ontario N2J2X9"
+"Coordinates": array:2 [
0 => -80.523425
1 => 43.47038
]
+"Latitude": 43.47038
+"Longitude": -80.523425
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To One28 Condos On King Street. This Newest Uptown Waterloo Condo Comes With 9 Feet Ceiling. Amazing 1 Bed+Den Unit Used As 2 Bedroom or office On 7th Floor Comes With Very Open Concept. Spacious Living, Dining, Kitchen Area & Walk Out To Balcony, Stainless Steel Appliances, Quartz Countertops - In-Suite Laundry - Laminate Floors. Nice Size Bedroom With East View From Balcony, Easy Access To Ion Lrt Transit, Close Proximity To Waterloo And Laurier University, Downtown Waterloo, Shops & Nice Restaurants (id:62783)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Microwave"
]
+"AssociationFee": "370"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T18:43:16.033499+00:00"
+"Directions": "Cross Streets: King Street North & Elgin St. ** Directions: King St. North/University Ave. W/ Elgin Street."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2135106"
+"ListOfficeKey": "50929"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-05T17:33:12Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T17:33:12Z"
+"StreetDirSuffix": "North"
+"StreetName": "King"
+"StreetNumber": "128"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3754"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29861307/710-128-king-street-n-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2130202"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Cie Property Mngt & Consu"
+"CoListOfficeKey": "70066"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-05T17:33:12.21Z"
+"ListAgentNationalAssociationId": "1387492"
+"ListOfficeNationalAssociationId": "1003013"
+"CoListAgentNationalAssociationId": "1383190"
+"CoListOfficeNationalAssociationId": "1132867"
+"Media": array:27 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29861307')"
+"ID": "1499986"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25183
+post_id: "1499428"
+post_author: 1
+"ListingKey": "29858591"
+"ListingId": "40835405"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T21:10:51Z"
+"RFModificationTimestamp": "2026-06-06T21:25:03Z"
+"ListPrice": 329900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 900.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4Z5"
+"UnparsedAddress": "139 BRIGHTON Street Unit# 3C, Waterloo, Ontario N2J4Z5"
+"Coordinates": array:2 [
0 => -80.5183915
1 => 43.4711804
]
+"Latitude": 43.4711804
+"Longitude": -80.5183915
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This well maintained 2-bedroom, 1-bathroom stacked townhouse-style condo is perfect for first-time buyers, downsizers, or investors. Features an updated kitchen with stainless steel appliances, quartz counters and tiled backsplash, main floor in-suite laundry adds everyday convenience, along with main floor bedroom with generous closet space. An updated 4-piece bathroom complete the main level. Second bedroom is located on upper level. Just minutes from Wilfrid Laurier University, the University of Waterloo, major transit routes, 10min walk to uptown Waterloo, and all essential amenities, this home offers unbeatable convenience. Move-in ready and waiting for its new owner. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"AssociationFee": "377.41"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T18:05:20.855494+00:00"
+"Directions": "Noecker Street"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564020"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Paved driveway"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-05T11:49:54Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T21:01:43Z"
+"Stories": "2.0"
+"StreetName": "BRIGHTON"
+"StreetNumber": "139"
+"StreetSuffix": "Street"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "2567.19"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/139-Brighton-St-3c"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29858591/139-brighton-street-unit-3c-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 900
+"OriginalEntryTimestamp": "2026-06-05T11:49:54.31Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1120111"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:31 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29858591')"
+"ID": "1499428"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25158
+post_id: "1498869"
+post_author: 1
+"ListingKey": "29859011"
+"ListingId": "40836651"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T13:41:02Z"
+"RFModificationTimestamp": "2026-06-05T17:18:10Z"
+"ListPrice": 559900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1137.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4S3"
+"UnparsedAddress": "6 WILLOW Street Unit# 1907, Waterloo, Ontario N2J4S3"
+"Coordinates": array:2 [
0 => -80.5162327
1 => 43.4658906
]
+"Latitude": 43.4658906
+"Longitude": -80.5162327
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 1907 at 6 Willow Street in Waterloo! This bright and inviting 2-bedroom, 1-bathroom condo offers comfortable living in a quiet, well-maintained building just minutes from Uptown Waterloo. Large windows fill the home with natural light and city views as far as the eye can see. The light filled space highlights the hardwood flooring that runs throughout the main living areas and bedrooms. The functional eat-in kitchen features updated stainless steel appliances and ample cabinet space, making meal preparation a breeze. A spacious den/family room provides additional living space that can be used as a home office, reading nook, or entertainment area. The renovated 3-piece bathroom showcases a modern walk-in shower, adding both style and convenience. Residents enjoy an impressive selection of building amenities including an indoor pool, sauna, exercise room, games room, library, party room, guest suites, elevator access, and visitor parking. The unit also includes one underground parking space for added convenience. Located in a peaceful neighbourhood close to Uptown Waterloo, you'll enjoy easy access to shopping, restaurants, parks, public transit, and all the amenities this vibrant community has to offer. Whether you're a first-time buyer, downsizer, or investor, this well-appointed condo offers an excellent opportunity in a sought-after Waterloo location. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "769.92"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Water"
4 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T17:17:56.695403+00:00"
+"Directions": "Erb St. E to Willow St."
+"ExteriorFeatures": array:1 [
0 => "Other"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908292"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-05T13:30:56Z"
+"PhotosCount": 41
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T13:30:56Z"
+"Stories": "1.0"
+"StreetName": "WILLOW"
+"StreetNumber": "6"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "3973"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youriguide.com/1907_6_willow_street_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29859011/6-willow-street-unit-1907-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Guest Suite"
2 => "Party Room"
]
+"ZoningDescription": "RMU-81"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1137
+"OriginalEntryTimestamp": "2026-06-05T13:30:56.63Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1221205"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29859011')"
+"ID": "1498869"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23345
+post_id: "1497727"
+post_author: 1
+"ListingKey": "29858144"
+"ListingId": "X13245830"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T02:40:13Z"
+"RFModificationTimestamp": "2026-06-05T03:01:21Z"
+"ListPrice": 888000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3H6"
+"UnparsedAddress": "1105 - 8 HICKORY STREET W, Waterloo, Ontario N2L3H6"
+"Coordinates": array:2 [
0 => -80.5261295
1 => 43.4781827
]
+"Latitude": 43.4781827
+"Longitude": -80.5261295
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Luxury Penthouse Living in the Heart of Waterloo - Fully Furnished, Turn-Key & Prime Investment Opportunity. Experience exceptional penthouse living in this spectacular two-level suite, perfectly positioned on the top (11th) floor of a modern, upscale Waterloo residence. Offering over 2,100 sq. ft. of beautifully finished living space, this rare property combines sophisticated design, sweeping sunset views, and unmatched convenience; just steps from Wilfrid Laurier University and the University of Waterloo. Flooded with natural light, the contemporary 5-bedroom, 5-bathroom layout includes a dramatic two-storey lounge with soaring 20-ft ceilings, an open-concept gourmet kitchen complete with a large island and walk-in pantry, and full in-suite laundry. Spacious bedrooms feature private ensuite bathrooms, while the fifth bedroom enjoys direct access to the impressive two-storey balcony; an ideal space for entertaining or relaxing with panoramic city views. Thoughtfully furnished and fully equipped with appliances, this penthouse is entirely turn-key, offering a premium rental rate already secured - a hassle-free opportunity for both student housing and executive rental investors. Located in a high-demand neighbourhood, residents also benefit from outstanding building amenities including a fitness centre, social lounge, underground parking, and secure bike storage. note: Some images include virtual staging for illustration purposes. (id:66098)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "998.31"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T03:01:09.919156+00:00"
+"Directions": "Cross Streets: King. ** Directions: King North / Hickory."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Concrete Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2252863"
+"ListOfficeKey": "285253"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Other"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-05T02:32:24Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T02:32:24Z"
+"StreetDirSuffix": "West"
+"StreetName": "Hickory"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7878"
+"ListAOR": "OnePoint"
+"TaxYear": 2025
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29858144/1105-8-hickory-street-w-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 2249
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 5
+"OriginalEntryTimestamp": "2026-06-05T02:32:24.74Z"
+"ListAgentNationalAssociationId": "1491850"
+"ListOfficeNationalAssociationId": "1349485"
+"Media": array:23 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29858144')"
+"ID": "1497727"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25186
+post_id: "1493409"
+post_author: 1
+"ListingKey": "29851946"
+"ListingId": "40836587"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T20:30:52Z"
+"RFModificationTimestamp": "2026-06-06T20:47:37Z"
+"ListPrice": 475000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1245.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2C1"
+"UnparsedAddress": "279 SANDOWNE Drive Unit# 32, Waterloo, Ontario N2K2C1"
+"Coordinates": array:2 [
0 => -80.5048607
1 => 43.4910648
]
+"Latitude": 43.4910648
+"Longitude": -80.5048607
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautifully updated 3 bdrm, 2 bath townhouse in desirable Waterloo location. Just steps to Sandowne public school, the location is ideal for a young family, first-time buyer or investor. The main level features a nicely appointed kitchen with appliances included, a dining area, and a spacious living room. There is also a powder room on the main level with a convenient pocket door. Upstairs, you’ll find the modernized bathroom with gorgeous tile shower and vanity. Each bedroom is generously sized and the updated wooden stairs and railings add a modern look and feel to the home. The main living area on all floors is carpet free. The finished basement provides extra living space with a large rec room with new flooring, plenty of storage, laundry area and a rough-in for a bathroom. Step outside to enjoy your private patio and the convenient carport. This move-in ready home is in a well-established, family-friendly neighbourhood, and only minutes away from schools, parks, shopping and everyday amenities. It is close to Conestoga Mall, nearby restaurants, transit routes, and major roadways. This home has it all, from the remodeled main bathroom, updated kitchen, luxury vinyl flooring, modern stairs, nest thermostat, heat pump & furnace (2024), California stucco ceilings, and neutral décor throughout. In addition, the Condo Corp maintains the building and grounds exceptionally well with recent updates including; newer roof, concrete walkways, basement windows, eavestroughs and more. Additional parking is available at no charge and is only steps away. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"AssociationFee": "540"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T14:36:03.246715+00:00"
+"Directions": "Lexington to Dunvegan to Sandowne"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1672317"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Carport"
1 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-04T13:21:24Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T20:20:30Z"
+"Stories": "2.0"
+"StreetName": "SANDOWNE"
+"StreetNumber": "279"
+"StreetSuffix": "Drive"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "2758"
+"VirtualTourURLUnbranded": "https://youriguide.com/32_279_sandowne_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29851946/279-sandowne-drive-unit-32-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1245
+"OriginalEntryTimestamp": "2026-06-04T13:20:00.45Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1170621"
+"ListOfficeNationalAssociationId": "1004387"
+"Media": array:43 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29851946')"
+"ID": "1493409"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25187
+post_id: "1489588"
+post_author: 1
+"ListingKey": "29847259"
+"ListingId": "40836261"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-04T20:40:35Z"
+"RFModificationTimestamp": "2026-06-04T20:59:37Z"
+"ListPrice": 849000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1028.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J1E3"
+"UnparsedAddress": "251 UNION Street E, Waterloo, Ontario N2J1E3"
+"Coordinates": array:2 [
0 => -80.5001728
1 => 43.4669243
]
+"Latitude": 43.4669243
+"Longitude": -80.5001728
+"YearBuilt": 1955
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this charming all-brick detached bungalow offering comfortable family living in a highly sought-after neighborhood. Featuring 3 spacious bedrooms 2 Bath, this well-maintained home is perfect for families, downsizers, or investors alike. Enjoy a bright and functional layout with numerous upgrades throughout, providing both style and peace of mind. Situated in a friendly neighborhood , this home is conveniently located close to schools, shopping, public transit, and scenic walking trails, making everyday living easy and enjoyable. The oversized driveway offers parking for up to 6 vehicles in addition to a 2-car detached garage, providing exceptional convenience for families and guests. Updates include Flooring (2022) Heat Pump (2023) Furnace (2024) and many more updates You won't want to miss this one call today. (id:62783)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Gas stove(s)"
4 => "Range - Gas"
5 => "Dishwasher"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "High Traffic Area"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-03T17:56:00.506534+00:00"
+"Directions": "Margaret to Union"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1860816"
+"ListOfficeKey": "76831"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-03T18:10:53Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-04T20:31:55Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "UNION"
+"StreetNumber": "251"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "4755"
+"VirtualTourURLUnbranded": "https://youriguide.com/251_union_street_east_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29847259/251-union-street-e-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 55.0
+"AboveGradeFinishedArea": 1028
+"OriginalEntryTimestamp": "2026-06-03T17:10:50.84Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1200804"
+"ListOfficeNationalAssociationId": "1004391"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29847259')"
+"ID": "1489588"
}
]
+success: true
+page_size: 9
+page_count: 25
+count: 222
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]