array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29914698 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1539270"
+post_author: 1
+"ListingKey": "29914698"
+"ListingId": "40838131"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T13:40:09Z"
+"RFModificationTimestamp": "2026-06-17T17:16:57Z"
+"ListPrice": 489888.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1100.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4S3"
+"UnparsedAddress": "6 WILLOW Street Unit# 1807, Waterloo, Ontario N2J4S3"
+"Coordinates": array:2 [
0 => -80.5174295
1 => 43.4655213
]
+"Latitude": 43.4655213
+"Longitude": -80.5174295
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Waterpark Place, one of Waterloo’s most sought-after condo developments, offering BREATHTAKING VIEWS of the city skyline and a remarkable array of amenities designed to enhance your lifestyle. As you step into the building, you’re greeted by a warm, INVITING LOBBY. This stunning 2-bedroom, 1-bathroom features an impressive 1,100 sq. ft. of living space with southern exposure. The spacious living and dining areas offer new vinyl flooring and are anchored by the renovated kitchen that boasts ample cabinetry, quartz countertops, a stylish backsplash, and stainless appliances with built-in oven, making it a true chef’s delight. Sliders open to your PRIVATE BALCONY, where you can take in exceptional views of the Waterloo landscape. The primary bedroom is located at one end of the unit with a FULLY RENOVATED 4-PIECE main bathroom complete with a glass-enclosed walk-in shower, & quartz vanity. The 2nd bedroom provides additional space & comfort along with a convenient in-suite laundry. This unit includes 1 UNDERGROUND PARKING SPACE, and Waterpark Place offers an outstanding range of amenities designed for every lifestyle. Stay active with the ON-SITE GYM, enjoy leisurely games in the billiards room, relax by the POOL OR SAUNA, or host gatherings in the party room, which opens to an outdoor patio with a BBQ area. For quiet moments, the library area provides a peaceful retreat. Located in the heart of Uptown Waterloo, Waterpark Place sits on nearly 4 acres of beautifully landscaped grounds, making it a Walker’s and Biker’s Paradise. Enjoy easy access to local boutiques, a variety of dining options, Waterloo Park, and the nearby universities. With convenient access to the LRT and local highways, this location truly offers the best of urban living. Don’t miss the opportunity to own this corner unit in Waterpark Place and experience luxurious living in one of Waterloo’s most vibrant communities. Interior photos have been virtually staged inside unit. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Sauna"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Garage door opener"
]
+"AssociationFee": "737"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T17:16:51.087563+00:00"
+"Directions": "Willow Street / Erb Street"
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563948"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Covered"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-17T13:31:33Z"
+"PhotosCount": 35
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T13:31:33Z"
+"Stories": "1.0"
+"StreetName": "WILLOW"
+"StreetNumber": "6"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "4153.56"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1661101498"
"RoomType" => "Laundry room"
"ListingId" => "40838131"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914698"
"RoomLength" => null
"RoomDimensions" => "3'2'' x 6'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:31:33.14Z"
]
1 => array:11 [
"RoomKey" => "1661101499"
"RoomType" => "4pc Bathroom"
"ListingId" => "40838131"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914698"
"RoomLength" => null
"RoomDimensions" => "5'8'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:31:33.14Z"
]
2 => array:11 [
"RoomKey" => "1661101500"
"RoomType" => "Bedroom"
"ListingId" => "40838131"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914698"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:31:33.14Z"
]
3 => array:11 [
"RoomKey" => "1661101501"
"RoomType" => "Primary Bedroom"
"ListingId" => "40838131"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914698"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 16'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:31:33.14Z"
]
4 => array:11 [
"RoomKey" => "1661101502"
"RoomType" => "Kitchen"
"ListingId" => "40838131"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914698"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 15'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:31:33.14Z"
]
5 => array:11 [
"RoomKey" => "1661101503"
"RoomType" => "Dining room"
"ListingId" => "40838131"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914698"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 14'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:31:33.14Z"
]
6 => array:11 [
"RoomKey" => "1661101504"
"RoomType" => "Living room"
"ListingId" => "40838131"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914698"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 15'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:31:33.14Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29914698/6-willow-street-unit-1807-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": 1100
+"OriginalEntryTimestamp": "2026-06-17T13:31:32.44Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1135552"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:35 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29914698_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/4cf10ee34af59dd654ad6b3109c17e0b.webp"
"MediaSize" => 156578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-4cf10ee34af59dd654ad6b3109c17e0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29914698_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/d66ab4d221a743030876609a16edaf78.webp"
"MediaSize" => 160121
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-d66ab4d221a743030876609a16edaf78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29914698_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/b7be81b1f0eacf2a6813a88bd6d1b2d0.webp"
"MediaSize" => 118452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-b7be81b1f0eacf2a6813a88bd6d1b2d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29914698_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/c6f0bff4ec17f13ee6ac9eeea2006f96.webp"
"MediaSize" => 104455
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-c6f0bff4ec17f13ee6ac9eeea2006f96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29914698_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/34362ca475a14e6cd2f0b15f9bf00b53.webp"
"MediaSize" => 102826
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-34362ca475a14e6cd2f0b15f9bf00b53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29914698_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/d04bc0b7842d507c7746bf4610a5a751.webp"
"MediaSize" => 89694
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-d04bc0b7842d507c7746bf4610a5a751.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29914698_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/e8b2a3129949fa163d025f70656fd5ab.webp"
"MediaSize" => 89021
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-e8b2a3129949fa163d025f70656fd5ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29914698_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/61c59988481db1d81c0c6c2b1301af9a.webp"
"MediaSize" => 87678
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-61c59988481db1d81c0c6c2b1301af9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29914698_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/a36cc064d169fdc2209e79b0f1ec09d6.webp"
"MediaSize" => 71830
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-a36cc064d169fdc2209e79b0f1ec09d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29914698_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/54ad73d8f3d5fad725d7d1a6e038ffbc.webp"
"MediaSize" => 71057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-54ad73d8f3d5fad725d7d1a6e038ffbc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29914698_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/6c48d64d230bc79183c45c58b703f1eb.webp"
"MediaSize" => 77537
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-6c48d64d230bc79183c45c58b703f1eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29914698_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/6784b5041f40ac3120c857205456368d.webp"
"MediaSize" => 65532
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-6784b5041f40ac3120c857205456368d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29914698_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/9756768e8b3c007c59d02446d6b78440.webp"
"MediaSize" => 79006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-9756768e8b3c007c59d02446d6b78440.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29914698_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/8df827eccdb17dbbbd51995ed2429a9a.webp"
"MediaSize" => 72799
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-8df827eccdb17dbbbd51995ed2429a9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29914698_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/5562c7e6ff541d4eb7107df6da6628f8.webp"
"MediaSize" => 68067
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-5562c7e6ff541d4eb7107df6da6628f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29914698_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/9a44fe80db235a4f5422e8fca7c49e51.webp"
"MediaSize" => 52790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-9a44fe80db235a4f5422e8fca7c49e51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29914698_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/3763e15d49cc0d03b2a204a052506f3e.webp"
"MediaSize" => 140056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-3763e15d49cc0d03b2a204a052506f3e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29914698_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/2476800b597345c00c5ce7358f80b27e.webp"
"MediaSize" => 84621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-2476800b597345c00c5ce7358f80b27e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29914698_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/d39bf780c21695fd4886a6bba6a0bc61.webp"
"MediaSize" => 99866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-d39bf780c21695fd4886a6bba6a0bc61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29914698_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/d924404ed45b2334ff8475ffe3a2d27c.webp"
"MediaSize" => 86860
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-d924404ed45b2334ff8475ffe3a2d27c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29914698_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/1c503f98f8ab4e79b8f6337c0fa1a4b7.webp"
"MediaSize" => 97060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-1c503f98f8ab4e79b8f6337c0fa1a4b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29914698_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/e795e1af20371a43bc27f0267afd2003.webp"
"MediaSize" => 100434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-e795e1af20371a43bc27f0267afd2003.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29914698_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/d5d44dcbb785caa237143e0d441c04ac.webp"
"MediaSize" => 91541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-d5d44dcbb785caa237143e0d441c04ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29914698_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/4c4ebcb8712143f1b6f21e27e4d77d45.webp"
"MediaSize" => 99176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-4c4ebcb8712143f1b6f21e27e4d77d45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29914698_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/0e708b6d67684802cc5143abd31f62eb.webp"
"MediaSize" => 80946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-0e708b6d67684802cc5143abd31f62eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29914698_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/81f9e5b03eb5f80a19e5d159d6d714ba.webp"
"MediaSize" => 77931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-81f9e5b03eb5f80a19e5d159d6d714ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29914698_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/94e5c80be142d499a9935c56d2025555.webp"
"MediaSize" => 110212
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-94e5c80be142d499a9935c56d2025555.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29914698_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/6cd7a2aa82e27082388762308b5cb046.webp"
"MediaSize" => 102090
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-6cd7a2aa82e27082388762308b5cb046.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29914698_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/0a418e83d33b91700e7de90626ca72f8.webp"
"MediaSize" => 107637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-0a418e83d33b91700e7de90626ca72f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29914698_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/044813555d9cbcdfdb7a30401981b47e.webp"
"MediaSize" => 91198
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-044813555d9cbcdfdb7a30401981b47e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29914698_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/d176226b6c21c5b465f29ae0b1db9e14.webp"
"MediaSize" => 82059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-d176226b6c21c5b465f29ae0b1db9e14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29914698_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/3852e2943183d56d12c2c4d9f71161c0.webp"
"MediaSize" => 97979
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-3852e2943183d56d12c2c4d9f71161c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29914698_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/26c6cfa15da60f3dd0489df7124cc003.webp"
"MediaSize" => 96679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-26c6cfa15da60f3dd0489df7124cc003.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29914698_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/ee1f19bedb2da3b95d066a9477e1a551.webp"
"MediaSize" => 124968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-ee1f19bedb2da3b95d066a9477e1a551.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29914698_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914698/ee2962f81170ef95e56800cc92c2f107.webp"
"MediaSize" => 173703
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914698/thumbnail-ee2962f81170ef95e56800cc92c2f107.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838131"
"ResourceRecordKey" => "29914698"
"ModificationTimestamp" => "2026-06-17T13:31:32.45Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914698')"
+"ID": "1539270"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 289541" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24766
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1563948" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24851
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29914698'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25163
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29914698'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25179
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29914698' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5174295 43.4655213)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25232
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25226
+post_id: "1541125"
+post_author: 1
+"ListingKey": "29919010"
+"ListingId": "X13458736"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T22:05:06Z"
+"RFModificationTimestamp": "2026-06-17T22:39:51Z"
+"ListPrice": 538888.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3H6"
+"UnparsedAddress": "901 - 8 HICKORY STREET W, Waterloo, Ontario N2L3H6"
+"Coordinates": array:2 [
0 => -80.526206
1 => 43.478339
]
+"Latitude": 43.478339
+"Longitude": -80.526206
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Highly Sought After Investment Opportunity. Located In Waterloo's Ideal And Luxurious Residential Pocket. Walking Distance To University Of Waterloo & Wilfred Laurier University. Public Transportation At Your Finger Tips. This Functional Suites Boosts Approx 1400sqft, Featuring 3 Full Size Bedrooms With Full Closet & Windows. 1 With Ensuite & Walk In Closet, 2 Full Bathrooms, In-suite Laundry, Open Concept Kitchen And Large Dining Island, Separate Living Space With Balcony Walk Out Access. Full Size Kitchen Appliances, Laminate Flooring Throughout, Soaring 9ft Ceilings, South And East Facing Views, In-suite Thermostat, HVAC & Water Tank, Ample Amount Of Storage And Closet Space. Ideal For Contemporary Student Living, Well-Maintained Building With Amenities And Features Including But Not Limited To; Gym, Secure Bike Storage, & Meeting Room / Common Lounge Space Equipped With High Speed Internet. Safe And. Secured Fob Entry With Buzzer, Condo Is Equipped With CCTV To Offer Parents Of Residents A Peace Of Mind. Currently Tenanted With 3 Great Laurier Students On First Year Lease Agreement And Moving Out End Of August 2026. (id:62650)"
+"Appliances": array:1 [
0 => "Furniture"
]
+"AssociationFee": "673.24"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T22:39:39.661326+00:00"
+"Directions": "Cross Streets: University / King. ** Directions: As Per Google."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2037204"
+"ListOfficeKey": "70066"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-17T21:55:10Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T21:55:09Z"
+"StreetDirSuffix": "West"
+"StreetName": "Hickory"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5864"
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1661543485"
"RoomType" => "Kitchen"
"ListingId" => "X13458736"
"RoomLevel" => "Flat"
"RoomWidth" => 5.71
"ListingKey" => "29919010"
"RoomLength" => 4.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T21:55:09.96Z"
]
1 => array:11 [
"RoomKey" => "1661543486"
"RoomType" => "Dining room"
"ListingId" => "X13458736"
"RoomLevel" => "Flat"
"RoomWidth" => 3.0
"ListingKey" => "29919010"
"RoomLength" => 2.47
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T21:55:09.96Z"
]
2 => array:11 [
"RoomKey" => "1661543487"
"RoomType" => "Living room"
"ListingId" => "X13458736"
"RoomLevel" => "Flat"
"RoomWidth" => 3.0
"ListingKey" => "29919010"
"RoomLength" => 5.83
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T21:55:09.96Z"
]
3 => array:11 [
"RoomKey" => "1661543489"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13458736"
"RoomLevel" => "Flat"
"RoomWidth" => 2.92
"ListingKey" => "29919010"
"RoomLength" => 4.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T21:55:09.96Z"
]
4 => array:11 [
"RoomKey" => "1661543490"
"RoomType" => "Bedroom 2"
"ListingId" => "X13458736"
"RoomLevel" => "Flat"
"RoomWidth" => 2.48
"ListingKey" => "29919010"
"RoomLength" => 6.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T21:55:09.96Z"
]
5 => array:11 [
"RoomKey" => "1661543491"
"RoomType" => "Bedroom 3"
"ListingId" => "X13458736"
"RoomLevel" => "Flat"
"RoomWidth" => 2.99
"ListingKey" => "29919010"
"RoomLength" => 5.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T21:55:09.96Z"
]
6 => array:11 [
"RoomKey" => "1661543492"
"RoomType" => "Laundry room"
"ListingId" => "X13458736"
"RoomLevel" => "Flat"
"RoomWidth" => 0.0
"ListingKey" => "29919010"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T21:55:09.96Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29919010/901-8-hickory-street-w-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "WILSON BLANCHARD"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"SecurityFeatures": array:2 [
0 => "Smoke Detectors"
1 => "Monitored Alarm"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-17T21:55:09.9Z"
+"ListAgentNationalAssociationId": "1313612"
+"ListOfficeNationalAssociationId": "1132867"
+"Media": array:30 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29919010_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/e45830b4dd4b6ee9d4307a226179fd8e.webp"
"MediaSize" => 281007
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-e45830b4dd4b6ee9d4307a226179fd8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29919010_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/75be00e148f4834d1f42bdfbb43b6c4a.webp"
"MediaSize" => 316284
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-75be00e148f4834d1f42bdfbb43b6c4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29919010_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/a053838bdcea8c636e6b91c31940e97e.webp"
"MediaSize" => 238581
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-a053838bdcea8c636e6b91c31940e97e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29919010_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/eee182764f9f6f0aaccd8cd47da4b7ed.webp"
"MediaSize" => 96845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-eee182764f9f6f0aaccd8cd47da4b7ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29919010_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/c4b390321615e9be8262a2d9dcc394dc.webp"
"MediaSize" => 122424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-c4b390321615e9be8262a2d9dcc394dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29919010_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/016a90cd7cd391b82ed8a1f950e9eaa7.webp"
"MediaSize" => 177119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-016a90cd7cd391b82ed8a1f950e9eaa7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29919010_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/b31ca35e4d4087086bb3042bea85b92b.webp"
"MediaSize" => 117297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-b31ca35e4d4087086bb3042bea85b92b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29919010_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/e42b78f8e799ddbc07412ccd85147ab1.webp"
"MediaSize" => 132439
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-e42b78f8e799ddbc07412ccd85147ab1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29919010_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/7bb2feb90b13f84b04c89033e52f74f7.webp"
"MediaSize" => 150931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-7bb2feb90b13f84b04c89033e52f74f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29919010_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/b0df6019b2943e352c8e4bf8f35532fc.webp"
"MediaSize" => 146033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-b0df6019b2943e352c8e4bf8f35532fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29919010_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/38e16ffc4cc97f30963b8cd118b45c20.webp"
"MediaSize" => 215915
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-38e16ffc4cc97f30963b8cd118b45c20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29919010_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/8df74041af067d06ca9bb872bed629e7.webp"
"MediaSize" => 205625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-8df74041af067d06ca9bb872bed629e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29919010_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/48d582043f52c69ede160f6cca6b7240.webp"
"MediaSize" => 206001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-48d582043f52c69ede160f6cca6b7240.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29919010_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/7b3746dae26e8d025d4ace07b485e5a7.webp"
"MediaSize" => 216699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-7b3746dae26e8d025d4ace07b485e5a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29919010_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/7e61faf1f1c0c5f4917ff4e8c0b1fe6c.webp"
"MediaSize" => 170945
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-7e61faf1f1c0c5f4917ff4e8c0b1fe6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29919010_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/47852c525cc8be4ffd3bd64d044325d7.webp"
"MediaSize" => 130055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-47852c525cc8be4ffd3bd64d044325d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29919010_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/bff248a1cad08138e134630e54e4768b.webp"
"MediaSize" => 115922
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-bff248a1cad08138e134630e54e4768b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29919010_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/eb70d464ef5b74221799687a3571a1d3.webp"
"MediaSize" => 174284
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-eb70d464ef5b74221799687a3571a1d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29919010_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/2b095111ec3ec7a8e6a75aff7055ccae.webp"
"MediaSize" => 145837
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-2b095111ec3ec7a8e6a75aff7055ccae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29919010_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/5ba0edd1583533655d41c7a8c15c975a.webp"
"MediaSize" => 153392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-5ba0edd1583533655d41c7a8c15c975a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29919010_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/de1b34241abb19018a7b503009207f78.webp"
"MediaSize" => 139294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-de1b34241abb19018a7b503009207f78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29919010_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/13517ae2d1f6392fe255f36c50a537f6.webp"
"MediaSize" => 190322
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-13517ae2d1f6392fe255f36c50a537f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29919010_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/cefd596f1ee0267a99c8e55bf768e108.webp"
"MediaSize" => 129282
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-cefd596f1ee0267a99c8e55bf768e108.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29919010_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/367f751b50b954eeef21007c74f2e132.webp"
"MediaSize" => 172382
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-367f751b50b954eeef21007c74f2e132.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29919010_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/a3e9bcc5d27449f99c728c8acbcf6441.webp"
"MediaSize" => 236633
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-a3e9bcc5d27449f99c728c8acbcf6441.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29919010_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/524111086e0ebe7c85db4c0314365048.webp"
"MediaSize" => 302178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-524111086e0ebe7c85db4c0314365048.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29919010_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/6301bf22c04f03bdb3669f2b8e097087.webp"
"MediaSize" => 264667
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-6301bf22c04f03bdb3669f2b8e097087.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29919010_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/ca4cb56503d79aa6cfc066dae98457ef.webp"
"MediaSize" => 285309
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-ca4cb56503d79aa6cfc066dae98457ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
"ResourceRecordKey" => "29919010"
"ModificationTimestamp" => "2026-06-17T21:55:09.91Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29919010_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919010/5a7ed8fc556fe3b4ac0ed08b2d04a247.webp"
"MediaSize" => 243356
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919010/thumbnail-5a7ed8fc556fe3b4ac0ed08b2d04a247.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458736"
…2
]
29 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919010')"
+"ID": "1541125"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25228
+post_id: "1540111"
+post_author: 1
+"ListingKey": "29917252"
+"ListingId": "X13457062"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T18:30:07Z"
+"RFModificationTimestamp": "2026-06-17T19:44:07Z"
+"ListPrice": 549900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3M3"
+"UnparsedAddress": "221 WILLOWDALE AVENUE, Waterloo, Ontario N2J3M3"
+"Coordinates": array:2 [
0 => -80.512148
1 => 43.47866
]
+"Latitude": 43.47866
+"Longitude": -80.512148
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Same owner for close to 60 years, this well-loved home is ready for its next chapter. Offering 3 bedroom and 1 bath, its sits on a large lot and features oversized drive-thru garage. Conveniently located close to schools, universities, shopping and the expressway, this property is a great opportunity to make it your own. (id:62783)"
+"Appliances": array:1 [
0 => "Water softener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T19:44:04.198916+00:00"
+"Directions": "Cross Streets: Carter and Willowdale. ** Directions: University to Carter to Willowdale."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2138809"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "65 x 110 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T18:21:36Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T18:21:36Z"
+"Stories": "1.0"
+"StreetName": "Willowdale"
+"StreetNumber": "221"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4507"
+"VirtualTourURLUnbranded": "https://youriguide.com/221_willowdale_ave_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": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29917252/221-willowdale-avenue-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 65.0
+"OriginalEntryTimestamp": "2026-06-17T18:21:36.26Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1390648"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29917252')"
+"ID": "1540111"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25225
+post_id: "1539914"
+post_author: 1
+"ListingKey": "29917046"
+"ListingId": "40840083"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T18:10:06Z"
+"RFModificationTimestamp": "2026-06-17T18:54:12Z"
+"ListPrice": 299000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 527.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3M7"
+"UnparsedAddress": "318 SPRUCE Street Unit# 1009, Waterloo, Ontario N2L3M7"
+"Coordinates": array:2 [
0 => -80.526452
1 => 43.4787911
]
+"Latitude": 43.4787911
+"Longitude": -80.526452
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Low condo fee!!! This stylish and convenient condo is in excellent condition, featuring a 1-bedroom layout with 1 bathrooms. The unit is carpetfree, offering a modern and clean living space. It boasts a spacious 9 ft ceiling that creates an open and airy atmosphere. The balcony seamlessly connects the living room, providing easy access to fresh air and outdoor relaxation. The built-in laundry room adds to the convenience, making everyday living effortless. The condo is ideally located with shopping plazas and restaurants just steps away, ensuring you have everything you need at your fingertips. It is adjacent to the prestigious Waterloo Collegiate Institute (WCI) and offers close proximity to Laurier University, the University of Waterloo, and Conestoga College (Waterloo Campus), making it an excellent choice for families, professionals, or students. Don't miss the opportunity to own this bright and functional condo that perfectly balances comfort, style, and location. Contact us today for more details or to schedule a viewing! (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"AssociationFee": "337.21"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T18:54:02.414253+00:00"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2073939"
+"ListOfficeKey": "253316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-17T18:01:29Z"
+"PhotosCount": 14
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T18:01:29Z"
+"Stories": "1.0"
+"StreetName": "SPRUCE"
+"StreetNumber": "318"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3220"
+"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/29917046/318-spruce-street-unit-1009-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Guest Suite"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 527
+"OriginalEntryTimestamp": "2026-06-17T18:01:29.86Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1349103"
+"ListOfficeNationalAssociationId": "1223329"
+"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('29917046')"
+"ID": "1539914"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25229
+post_id: "1538279"
+post_author: 1
+"ListingKey": "29914289"
+"ListingId": "40838805"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T12:15:07Z"
+"RFModificationTimestamp": "2026-06-17T13:51:21Z"
+"ListPrice": 549900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.16
+"LivingArea": 1550.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3M3"
+"UnparsedAddress": "221 WILLOWDALE Avenue, Waterloo, Ontario N2J3M3"
+"Coordinates": array:2 [
0 => -80.512647
1 => 43.4788964
]
+"Latitude": 43.4788964
+"Longitude": -80.512647
+"YearBuilt": 1964
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Same owner for close to 60 years, this well-loved home is ready for its next chapter. Offering 3 bedroom and 1 bath, its sits on a large lot and features oversized drive-thru garage. Conveniently located close to schools, universities, shopping and the expressway, this property is a great opportunity to make it your own. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T13:51:18.138285+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564020"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0.16"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T11:50:29Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T12:10:05Z"
+"Stories": "1.0"
+"StreetName": "WILLOWDALE"
+"StreetNumber": "221"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "4712.13"
+"VirtualTourURLUnbranded": "https://youriguide.com/221_willowdale_ave_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/29914289/221-willowdale-avenue-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 65.0
+"AboveGradeFinishedArea": 1050
+"BelowGradeFinishedArea": 500
+"OriginalEntryTimestamp": "2026-06-17T11:50:29.09Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1120111"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914289')"
+"ID": "1538279"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25227
+post_id: "1536818"
+post_author: 1
+"ListingKey": "29912221"
+"ListingId": "X13452506"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T20:40:12Z"
+"RFModificationTimestamp": "2026-06-16T23:06:56Z"
+"ListPrice": 1499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2M2Y7"
+"UnparsedAddress": "140 ABERDEEN ROAD, Waterloo, Ontario N2M2Y7"
+"Coordinates": array:2 [
0 => -80.52919
1 => 43.451914
]
+"Latitude": 43.451914
+"Longitude": -80.52919
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "When it comes to Waterloo Region real estate, there's nothing better than a Westmount location! This is 140 Aberdeen Road - perched on a sprawling nearly 80 by 150-plus foot lot just steps from Westmount Golf and Country Club. The exclusivity of the immediate neighbourhood is unparalleled in our region, and next to no other opportunities remain that have not already been built upon in this most prestigious of enclaves. The options and potential for a spectacular dream home are endless on this .29-acre property! The existing custom four-bedroom residence with renovations by Country Lane Builders strikes a balance between elevated luxury and a warmly inviting atmosphere. Stepping inside from the manicured front gardens through a handsome solid wood door, you'll be struck by light flooding the main level with its barrel-vaulted ceiling and multiple skylights. Turn left into the airy dream kitchen with quartz counters and custom cabinetry, or right into the formal dining room with lighting to showcase your art. Downstairs lies an extended triple-aspect family room with vaulted ceiling, custom lighting, skylights, and gas fireplace. An enormous fully fenced yard featuring a two-tier deck, mature walnut tree, and room for outdoor entertaining walks out just beyond. The lower level also includes a den (or fourth bedroom), home office, mudroom, powder room, and garage access. One level below is the basement with ample storage and updated mechanicals: a new Viessmann boiler for heated floors in the north wing, an updated furnace, water softener, and sump pump. Upstairs are the three principal bedrooms, led by the primary suite with vaulted ceiling, deep walk-in closet, three-piece ensuite, and adjacent laundry. The main four-piece family bath is down the hall. With parking for up to nine vehicles via the attached garage and triple-wide driveway, this home is ideal for entertaining, or enjoy walks to Belmont Village or Uptown Waterloo for dining. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Garage door opener remote(s)"
]
+"Basement": array:4 [
0 => "Unfinished"
1 => "Partial"
2 => "Crawl space"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Wall unit"
]
+"CreationDate": "2026-06-16T23:06:43.274460+00:00"
+"Directions": "Cross Streets: Forsyth Drive. ** Directions: Westmount Rd S. to Forsyth Dr to Aberdeen Rd."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2213352"
+"ListOfficeKey": "296481"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Sump Pump"
]
+"LotSizeDimensions": "80.3 x 154.1 FT ; 79.99x154.11x80.35x161.97"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T20:30:58Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T20:30:58Z"
+"StreetName": "Aberdeen"
+"StreetNumber": "140"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "10294.04"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://www.wattyway.ca/multimedia/140-aberdeen-road/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29912221/140-aberdeen-road-waterloo"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "RES-1"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 80.3
+"OriginalEntryTimestamp": "2026-06-16T20:30:58.44Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1459170"
+"ListOfficeNationalAssociationId": "1470796"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912221')"
+"ID": "1536818"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25222
+post_id: "1535293"
+post_author: 1
+"ListingKey": "29911052"
+"ListingId": "40840266"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T19:40:08Z"
+"RFModificationTimestamp": "2026-06-16T19:45:41Z"
+"ListPrice": 1499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2786.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2M2Y7"
+"UnparsedAddress": "140 ABERDEEN Road, Kitchener, Ontario N2M2Y7"
+"Coordinates": array:2 [
0 => -80.5290676
1 => 43.452082
]
+"Latitude": 43.452082
+"Longitude": -80.5290676
+"YearBuilt": 1959
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "When it comes to Waterloo Region real estate,\u{A0}there’s\u{A0}nothing better than a Westmount location! This is 140 Aberdeen Road – perched on a sprawling 80\u{A0}by 150-plus foot\u{A0}lot just steps from Westmount Golf and Country Club. \u{A0}The exclusivity of the immediate neighbourhood is unparalleled in our region, and next to no other\u{A0}opportunities\u{A0}remain\u{A0}that have not already been built upon in this most prestigious of enclaves.\u{A0} The options and potential for a spectacular dream home are endless on this\u{A0}.29-acre\u{A0}property!\u{A0}The\u{A0}existing\u{A0}custom four-bedroom residence with renovations by Country Lane Builders strikes a balance between elevated luxury and a warmly inviting atmosphere. Stepping inside from the manicured front gardens through a handsome solid wood door,\u{A0}you’ll\u{A0}be struck by light flooding the main level with its barrel-vaulted ceiling and multiple skylights. Turn left into the airy dream kitchen with\u{A0}quartz\u{A0}counters\u{A0}and\u{A0}custom cabinetry, or right into the formal dining room with lighting to\u{A0}showcase\u{A0}your art.\u{A0}Downstairs\u{A0}lies an\u{A0}extended triple-aspect family room with vaulted ceiling, custom lighting, skylights, and gas fireplace.\u{A0}An\u{A0}enormous fully fenced yard featuring a two-tier deck, mature walnut tree, and room for outdoor\u{A0}entertaining\u{A0}walks out just beyond. The lower level also includes a den (or fourth bedroom), home office, mudroom, powder room, and garage access. One level below is the\u{A0}basement with ample storage and\u{A0}updated\u{A0}mechanicals:\u{A0}a\u{A0}new Viessmann boiler for heated floors in the north wing,\u{A0}an\u{A0}updated furnace, water softener, and sump pump. Upstairs are the three principal bedrooms, led by the primary suite with vaulted ceiling, deep walk-in closet, three-piece ensuite, and adjacent laundry. The main four-piece family bath is down the hall. With parking for up to nine vehicles via the attached garage and triple-wide driveway, this home is ideal for\u{A0}entertaining,\u{A0}or\u{A0}enjoy walks to Belmont Village or Uptown Waterloo for dining. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Wall unit"
]
+"CreationDate": "2026-06-16T18:57:05.467221+00:00"
+"Directions": "Westmount Rd S. to Forsyth Dr to Aberdeen Rd"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Stucco"
2 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Forced air"
1 => "In Floor Heating"
2 => "Boiler"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1833093"
+"ListOfficeKey": "296447"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Crushed stone driveway"
1 => "Skylight"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
4 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T19:31:46Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T19:31:46Z"
+"Stories": "2.0"
+"StreetName": "ABERDEEN"
+"StreetNumber": "140"
+"StreetSuffix": "Road"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "10294.04"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://www.wattyway.ca/multimedia/140-aberdeen-rd-/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29911052/140-aberdeen-road-kitchener"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RES-1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 80.0
+"AboveGradeFinishedArea": 2786
+"OriginalEntryTimestamp": "2026-06-16T18:11:12.68Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1196292"
+"ListOfficeNationalAssociationId": "1458684"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29911052')"
+"ID": "1535293"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1534881"
+post_author: 1
+"ListingKey": "29908756"
+"ListingId": "40840015"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T13:30:02Z"
+"RFModificationTimestamp": "2026-06-16T17:55:13Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1392.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J1W5"
+"UnparsedAddress": "256 BOWMAN Street, Waterloo, Ontario N2J1W5"
+"Coordinates": array:2 [
0 => -80.5116886
1 => 43.4611148
]
+"Latitude": 43.4611148
+"Longitude": -80.5116886
+"YearBuilt": 1939
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
+"PublicRemarks": "Cute as a button and perfectly situated in a sought-after pocket of Uptown Waterloo! This detached freehold home with a garage is tucked away on one of Uptown’s most desirable streets — close to shops, restaurants, parks, transit, and everything this vibrant neighbourhood has to offer. Location, location, location! One of the rarest finds in this price range? An incredibly private, oversized backyard. Whether it’s space for kids and dogs to run, summer entertaining, or relaxing in the hot tub under the stars, this backyard oasis offers endless possibilities all year round. Inside, you’ll find just under 1,400 square feet of beautifully maintained living space featuring 2+1 bedrooms and 2 full bathrooms. Original hardwood floors and rounded archways preserve the timeless charm of this 87-year-old home, while thoughtful updates throughout provide the convenience and comfort of modern living. The primary bedroom includes a large sliding door overlooking the backyard, complete with a motorized blind for an added touch of luxury. The second main floor bedroom allows easy access to the backyard as well and can be repurposed as a gorgeous home office. From stainless steel appliances and ceiling height cabinets in the kitchen to a classic tiled main floor washroom with deep soaker tub, this house checks all the boxes. The recently redone fully finished basement features a family room with fireplace and built-in surround sound speakers. The stylish dedicated laundry area flows into another full bathroom which is ensuite to the third bedroom. The extensive update list speaks for itself — there is truly nothing to do but move in and enjoy. 256 Bowman Street proves that good things really do come in small packages! (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:54:59.461170+00:00"
+"Directions": "See maps in supplements to avoid road closures due to temporary road work."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2197958"
+"ListOfficeKey": "291617"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T13:24:35Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T13:24:35Z"
+"Stories": "1.0"
+"StreetName": "BOWMAN"
+"StreetNumber": "256"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "4164.85"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=0Osv_Eo2TbM"
+"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": "Brantford"
+"ListAORKey": "41"
+"ListingURL": "www.realtor.ca/real-estate/29908756/256-bowman-street-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 770
+"BelowGradeFinishedArea": 622
+"OriginalEntryTimestamp": "2026-06-16T13:24:34.89Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1446324"
+"ListOfficeNationalAssociationId": "1400956"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908756')"
+"ID": "1534881"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25230
+post_id: "1534882"
+post_author: 1
+"ListingKey": "29909411"
+"ListingId": "X13449876"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T15:10:12Z"
+"RFModificationTimestamp": "2026-06-16T17:22:29Z"
+"ListPrice": 429900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2J3"
+"UnparsedAddress": "9 - 12 BRIDGEPORT ROAD E, Waterloo, Ontario N2J2J3"
+"Coordinates": array:2 [
0 => -80.522235
1 => 43.467941
]
+"Latitude": 43.467941
+"Longitude": -80.522235
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "FULLY VACANT!! Exceptional investment opportunity with strong rental appeal. This unique property offers a spacious multi-level layout featuring 4 bedrooms, a bathroom on each level, and a shared kitchen configuration ideal for student housing or multi-tenant occupancy. Freshly painted throughout and enhanced with new waterproof vinyl flooring on the upper level, the unit combines modern updates with character-rich design. Originally a 1900s industrial building converted to residential use in 2002, the property showcases soaring ceilings, exposed beams, exposed brick, and stone accents that create a distinctive urban loft aesthetic. Residents enjoy access to secured bike storage, a media lounge/hangout area, and onsite laundry facilities in the building. Ideally situated within walking distance to University of Waterloo, Wilfred Laurier University, public transit including the ION LRT, grocery stores, restaurants, and everyday amenities, with an impressive Walk Score of 94. A proven income-generating property with a strong rental history and consistently high occupancy. Book your private showing today! (id:62650)"
+"AssociationFee": "571.31"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-16T17:21:55.045353+00:00"
+"Directions": "Bridgeport Rd E And King St N"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2036658"
+"ListOfficeKey": "293284"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T15:02:21Z"
+"PhotosCount": 38
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:02:21Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "Bridgeport"
+"StreetNumber": "12"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3099.74"
+"VirtualTourURLUnbranded": "https://youtu.be/NT8oDHOsHqU"
+"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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29909411/9-12-bridgeport-road-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2145943"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management Inc."
+"CoListOfficeKey": "293284"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"ZoningDescription": "C8"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"OriginalEntryTimestamp": "2026-06-16T15:02:21.67Z"
+"ListAgentNationalAssociationId": "1313160"
+"ListOfficeNationalAssociationId": "1469475"
+"CoListAgentNationalAssociationId": "1397346"
+"CoListOfficeNationalAssociationId": "1469475"
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909411')"
+"ID": "1534882"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25231
+post_id: "1534883"
+post_author: 1
+"ListingKey": "29909783"
+"ListingId": "40839660"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T17:00:11Z"
+"RFModificationTimestamp": "2026-06-16T17:16:20Z"
+"ListPrice": 579000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1192.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0C6"
+"UnparsedAddress": "188 KING Street S Unit# 304, Waterloo, Ontario N2J0C6"
+"Coordinates": array:2 [
0 => -80.518475
1 => 43.460317
]
+"Latitude": 43.460317
+"Longitude": -80.518475
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright Corner Condo in the Heart of Uptown Waterloo! Welcome to this spacious 2-bedroom, 2-bathroom corner unit, perfectly located in one of Waterloo’s most sought-after neighbourhoods. Just steps from the LRT, shopping, restaurants, parks, and universities, this condominium unit offers the convenience of Uptown living at your doorstep. A private foyer leads into a bright open-concept living space featuring a modern kitchen with granite countertops, stainless steel appliances, and plenty of cabinet space. The large solarium is flooded with natural light and provides a quiet space to relax, work, or enjoy your morning coffee. Both bedrooms are generously sized with large windows, while the primary bedroom includes a walk-in closet and a private ensuite bathroom. The unit is completely carpet-free and finished with beautiful engineered hardwood flooring throughout. In-suite laundry adds everyday convenience. Residents enjoy excellent building amenities, including a fitness room, party room, rooftop terrace with BBQ area, private bike storage, exclusive underground parking space, and a storage designated locker. A fantastic opportunity to own a bright, well-maintained condo in an unbeatable Uptown Waterloo location. (id:62783)"
+"AccessibilityFeatures": array:1 [
0 => "Accessible Approach with Ramp"
]
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"AssociationFee": "984.81"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Water"
4 => "Insurance"
5 => "Other, See Remarks"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:16:10.100683+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2150801"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-16T15:51:53Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T16:51:22Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "KING"
+"StreetNumber": "188"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "6388"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youriguide.com/unit_304_188_king_st_s_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29909783/188-king-street-s-unit-304-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1736200"
+"CommonInterest": "Condo/Strata"
+"CoListAgentKey2": "2192963"
+"CoListOfficeKey": "289541"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"CoListOfficeKey2": "283125"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "C2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1192
+"OriginalEntryTimestamp": "2026-06-16T15:51:53.52Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1401593"
+"ListOfficeNationalAssociationId": "1324759"
+"CoListAgentNationalAssociationId": "1177848"
+"CoListAgentNationalAssociationId2": "1441925"
+"CoListOfficeNationalAssociationId": "1378680"
+"CoListOfficeNationalAssociationId2": "1324759"
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909783')"
+"ID": "1534883"
}
]
+success: true
+page_size: 9
+page_count: 52
+count: 467
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]