array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29894792 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1524533"
+post_author: 1
+"ListingKey": "29894792"
+"ListingId": "40835638"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T13:40:13Z"
+"RFModificationTimestamp": "2026-06-13T13:55:27Z"
+"ListPrice": 500000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1141.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4S3"
+"UnparsedAddress": "6 WILLOW Street Unit# 507, Waterloo, Ontario N2J4S3"
+"Coordinates": array:2 [
0 => -80.5170154
1 => 43.4657971
]
+"Latitude": 43.4657971
+"Longitude": -80.5170154
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Waterpark, a highly regarded condo community set on four acres in the heart of Uptown Waterloo. This bright and spacious two-bedroom suite offers comfortable, low-maintenance living in one of Waterloo’s most desirable buildings. Step in your front door and you'll love how bright and spacious your home feels with large windows bringing in both natural light and lovely views from the living room, kitchen, and primary bedroom, while the balcony offers a pleasant place to enjoy fresh air. The generous eat-in kitchen features fresh white cabinetry, rich-toned counters, and newer stainless steel appliances. Modern neutral décor with rich laminate flooring throughout. Both bedrooms include generous closet space, with a grand size walk-in closet in the the large primary bedroom. Added conveniences include in-unit laundry and a renovated bathroom with a large frameless glass step-in shower. This 1,100-square-foot floor plan provides plenty of room to live comfortably. Enjoy common amenities that make everyday life the best, including an indoor pool, sauna, exercise room, party and games rooms, guest suite, and more. Beautifully landscaped grounds with mature gardens, a gazebo, and a rear sitting area offer inviting outdoor spaces to relax. With an excellent walk score, this building is close to restaurants, shops, the LRT, Waterloo Park, and the Spur Line walking trail, making it easy to enjoy the neighbourhood without relying on a car. This inviting suite is an exceptional opportunity for those seeking comfort, convenience, and a strong sense of community. Call today to arrange your private viewing. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Sauna"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
]
+"AssociationFee": "769.97"
+"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-12T20:04:35.562276+00:00"
+"Directions": "CORNER OF WILLOW ST AND ERB ST"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1927397"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "No Pet Home"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-12T14:41:11Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T13:32:17Z"
+"Stories": "1.0"
+"StreetName": "WILLOW"
+"StreetNumber": "6"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "3960.02"
+"VirtualTourURLUnbranded": "https://youriguide.com/507_6_willow_street_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1658494096"
"RoomType" => "Laundry room"
"ListingId" => "40835638"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894792"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T13:32:17.18Z"
]
1 => array:11 [
"RoomKey" => "1658494097"
"RoomType" => "Bedroom"
"ListingId" => "40835638"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894792"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T13:32:17.18Z"
]
2 => array:11 [
"RoomKey" => "1658494098"
"RoomType" => "3pc Bathroom"
"ListingId" => "40835638"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894792"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T13:32:17.18Z"
]
3 => array:11 [
"RoomKey" => "1658494099"
"RoomType" => "Primary Bedroom"
"ListingId" => "40835638"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894792"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 17'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T13:32:17.19Z"
]
4 => array:11 [
"RoomKey" => "1658494100"
"RoomType" => "Dinette"
"ListingId" => "40835638"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894792"
"RoomLength" => null
"RoomDimensions" => "6'9'' x 9'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T13:32:17.19Z"
]
5 => array:11 [
"RoomKey" => "1658494101"
"RoomType" => "Kitchen"
"ListingId" => "40835638"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894792"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 9'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T13:32:17.19Z"
]
6 => array:11 [
"RoomKey" => "1658494102"
"RoomType" => "Dining room"
"ListingId" => "40835638"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894792"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 12'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T13:32:17.19Z"
]
7 => array:11 [
"RoomKey" => "1658494103"
"RoomType" => "Living room"
"ListingId" => "40835638"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894792"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 20'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T13:32:17.19Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29894792/6-willow-street-unit-507-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1564568"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Guest Suite"
2 => "Party Room"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1141
+"OriginalEntryTimestamp": "2026-06-12T14:41:11.11Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1230140"
+"ListOfficeNationalAssociationId": "1004387"
+"CoListAgentNationalAssociationId": "1070173"
+"CoListOfficeNationalAssociationId": "1004387"
+"Media": array:42 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29894792_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/7513d9a50abfc0704fcd2ff79a93a05a.webp"
"MediaSize" => 129828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-7513d9a50abfc0704fcd2ff79a93a05a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29894792_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/6cd0b856fa5ebad32fbb9dca7a516dc6.webp"
"MediaSize" => 102152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-6cd0b856fa5ebad32fbb9dca7a516dc6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29894792_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/8af15fb9547e784aea127f7291666bb3.webp"
"MediaSize" => 139095
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-8af15fb9547e784aea127f7291666bb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29894792_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/421e549d4b4f2b6a4f3c8190dbc2999a.webp"
"MediaSize" => 146139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-421e549d4b4f2b6a4f3c8190dbc2999a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29894792_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/d2cf0ade7996d63e1175e3dbd23afe40.webp"
"MediaSize" => 95970
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-d2cf0ade7996d63e1175e3dbd23afe40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29894792_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/0cfb9fefe8a51d3e123ca6740183205e.webp"
"MediaSize" => 119609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-0cfb9fefe8a51d3e123ca6740183205e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29894792_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/4c8e671dcaaad700cc885f2085e21b0c.webp"
"MediaSize" => 65533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-4c8e671dcaaad700cc885f2085e21b0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29894792_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/cba2ad6dd649e4963b9e7de7ae6b9529.webp"
"MediaSize" => 87148
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-cba2ad6dd649e4963b9e7de7ae6b9529.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29894792_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/228b0757a2a74b2cf9c36d3f02323cf8.webp"
"MediaSize" => 87866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-228b0757a2a74b2cf9c36d3f02323cf8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29894792_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/2da9f2031dbe308501f7594d7afb6f0a.webp"
"MediaSize" => 77494
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-2da9f2031dbe308501f7594d7afb6f0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29894792_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/4ae849a784a03140956f7a256de992d9.webp"
"MediaSize" => 71411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-4ae849a784a03140956f7a256de992d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29894792_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/796828d1ceae4eb2777b3d540d92ba02.webp"
"MediaSize" => 75842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-796828d1ceae4eb2777b3d540d92ba02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29894792_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/5eb69eb980a6f15b440f7609409c7de8.webp"
"MediaSize" => 58987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-5eb69eb980a6f15b440f7609409c7de8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29894792_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/d26287ced0768e75ffc0367ddb5ab7fc.webp"
"MediaSize" => 89876
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-d26287ced0768e75ffc0367ddb5ab7fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29894792_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/38f267326512fbd85287517df9e67c9e.webp"
"MediaSize" => 93684
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-38f267326512fbd85287517df9e67c9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29894792_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/3f6baf99997f49a3976da3cd184558cc.webp"
"MediaSize" => 105980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-3f6baf99997f49a3976da3cd184558cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29894792_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/5a49556e7ce79afba8f16c1631aca78f.webp"
"MediaSize" => 96712
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-5a49556e7ce79afba8f16c1631aca78f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29894792_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/9ef16d617d0d82f1d29817b031475ea5.webp"
"MediaSize" => 102512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-9ef16d617d0d82f1d29817b031475ea5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29894792_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/2f4522fcd3c99427f51d4448e5cdec67.webp"
"MediaSize" => 96422
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-2f4522fcd3c99427f51d4448e5cdec67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29894792_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/92553f138d5b00005199a1ba0c465649.webp"
"MediaSize" => 79266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-92553f138d5b00005199a1ba0c465649.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29894792_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/437b505323a8e9f3d50509914735864c.webp"
"MediaSize" => 81921
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-437b505323a8e9f3d50509914735864c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29894792_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/d933b4443f0be806433757817acef631.webp"
"MediaSize" => 75440
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-d933b4443f0be806433757817acef631.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29894792_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/7964274b31988786d60c6d1db6f2df8b.webp"
"MediaSize" => 92743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-7964274b31988786d60c6d1db6f2df8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29894792_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/c654fb8892d7aa4a55650eadc3dad97d.webp"
"MediaSize" => 60706
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-c654fb8892d7aa4a55650eadc3dad97d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29894792_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/4f84ba408b830ba1681b0ff4cdf49855.webp"
"MediaSize" => 59227
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-4f84ba408b830ba1681b0ff4cdf49855.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29894792_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/742fae32584d1e9933747ec306b7ec70.webp"
"MediaSize" => 53217
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-742fae32584d1e9933747ec306b7ec70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29894792_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/cb66e087cfa19a876763dec03b4ebc8e.webp"
"MediaSize" => 87147
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-cb66e087cfa19a876763dec03b4ebc8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29894792_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/a6bc1ef2e75536bfb825b228a48b3044.webp"
"MediaSize" => 85342
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-a6bc1ef2e75536bfb825b228a48b3044.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29894792_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/184a08f6b8da064cfc7754520d8fcfea.webp"
"MediaSize" => 61770
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-184a08f6b8da064cfc7754520d8fcfea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29894792_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/49b7a7a2444ab68a9a71771e3276fc28.webp"
"MediaSize" => 73823
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-49b7a7a2444ab68a9a71771e3276fc28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29894792_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/e5c973ec822b2ac1cff1cca12465f6ed.webp"
"MediaSize" => 89070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-e5c973ec822b2ac1cff1cca12465f6ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29894792_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/f16b1ae638274fedfcb5eba00954904c.webp"
"MediaSize" => 92264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-f16b1ae638274fedfcb5eba00954904c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29894792_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/70f88dc5906a2ab9ba29d6659e473545.webp"
"MediaSize" => 79647
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-70f88dc5906a2ab9ba29d6659e473545.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29894792_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/3a36c1d84b55f2c166562b7e51fe9895.webp"
"MediaSize" => 90911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-3a36c1d84b55f2c166562b7e51fe9895.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29894792_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/922eb339e6918a1547dd368b2a61ccef.webp"
"MediaSize" => 82775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-922eb339e6918a1547dd368b2a61ccef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29894792_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/21a0bd019e1c69668970e9460fc2c674.webp"
"MediaSize" => 82721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-21a0bd019e1c69668970e9460fc2c674.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29894792_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/fa341fa65d4151ce6a6b721d087527d6.webp"
"MediaSize" => 145256
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-fa341fa65d4151ce6a6b721d087527d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29894792_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/8a9146e5cd969f63e62833c7a27624e8.webp"
"MediaSize" => 162398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-8a9146e5cd969f63e62833c7a27624e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29894792_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/4383171fbe3ddc5af4db8d655bd2e0bc.webp"
"MediaSize" => 147073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-4383171fbe3ddc5af4db8d655bd2e0bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29894792_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/3d8cf209e1ab40689a242b4aa26d2998.webp"
"MediaSize" => 194484
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-3d8cf209e1ab40689a242b4aa26d2998.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29894792_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/7a1cfa12828121ae9516bc7f54a9e2d0.webp"
"MediaSize" => 206751
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-7a1cfa12828121ae9516bc7f54a9e2d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29894792_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894792/6393899fc84474766021a733342d2270.webp"
"MediaSize" => 27309
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894792/thumbnail-6393899fc84474766021a733342d2270.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835638"
"ResourceRecordKey" => "29894792"
"ModificationTimestamp" => "2026-06-12T14:41:11.11Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29894792')"
+"ID": "1524533"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 76826" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24809
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1927397" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24782
+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 '29894792'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25125
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29894792'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25143
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25141
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31462837"
+"ListingKey": "29894792"
+"ListingId": "40835638"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": "Updated and move in ready. A great opportunity to live the best life at Waterpark."
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-13T16:43:33Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31462837')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29894792' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5170154 43.4657971)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25216
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25190
+post_id: "1527184"
+post_author: 1
+"ListingKey": "29899170"
+"ListingId": "X13440456"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T23:55:14Z"
+"RFModificationTimestamp": "2026-06-13T04:14:40Z"
+"ListPrice": 349900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E5"
+"UnparsedAddress": "802 - 158 KING STREET N, Waterloo, Ontario N2J0E5"
+"Coordinates": array:2 [
0 => -80.523574
1 => 43.471807
]
+"Latitude": 43.471807
+"Longitude": -80.523574
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 802 at 158 King Street North, Waterloo, a fantastic opportunity for homeowners, investors, or parents looking to secure a property for their child in one of Waterloo's most desirable locations. Offering approximately 700 square feet of thoughtfully designed living space, this carpet-free condo features 2 spacious bedrooms, 2 full bathrooms, and an open-concept layout that perfectly blends functionality and comfort. From the moment you step inside, you'll appreciate the modern vinyl flooring that flows throughout the unit, creating a clean and contemporary feel. The kitchen is equipped with stainless steel appliances, ample cabinetry, and plenty of workspace, making meal preparation both convenient and enjoyable. Overlooking the bright living and dining area, the open-concept design creates the perfect setting for entertaining guests, hosting dinner with friends, or simply relaxing after a long day. The well-designed floor plan offers two generously sized bedrooms and two full bathrooms, providing flexibility and privacy for roommates, professionals, students, or small families. Step outside onto your private balcony and enjoy sweeping views of Waterloo's vibrant cityscape. Located in the heart of Waterloo, you're just minutes from the University of Waterloo, Wilfrid Laurier University, Conestoga College, restaurants, cafes, parks, shopping, public transit, and countless everyday amenities. Whether you're looking for a place to call home, an investment property, or a smart purchase for a student attending university, this condo checks all the boxes. Don't miss your chance to own in a prime Waterloo location with exceptional convenience and long-term value. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Intercom"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
]
+"AssociationFee": "479.4"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T04:14:32.306622+00:00"
+"Directions": "Cross Streets: King St N/ University Ave. ** Directions: King St N & Noecker St."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-12T23:45:22Z"
+"PhotosCount": 2
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T23:45:22Z"
+"StreetDirSuffix": "North"
+"StreetName": "King"
+"StreetNumber": "158"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3594.97"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1658110979"
"RoomType" => "Living room"
"ListingId" => "X13440456"
"RoomLevel" => "Main level"
"RoomWidth" => 2.03
"ListingKey" => "29899170"
"RoomLength" => 3.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T23:45:22.9Z"
]
1 => array:11 [
"RoomKey" => "1658110980"
"RoomType" => "Bedroom"
"ListingId" => "X13440456"
"RoomLevel" => "Main level"
"RoomWidth" => 2.39
"ListingKey" => "29899170"
"RoomLength" => 3.12
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T23:45:22.9Z"
]
2 => array:11 [
"RoomKey" => "1658110981"
"RoomType" => "Bathroom"
"ListingId" => "X13440456"
"RoomLevel" => "Main level"
"RoomWidth" => 2.0
"ListingKey" => "29899170"
"RoomLength" => 2.03
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T23:45:22.9Z"
]
3 => array:11 [
"RoomKey" => "1658110982"
"RoomType" => "Kitchen"
"ListingId" => "X13440456"
"RoomLevel" => "Main level"
"RoomWidth" => 2.03
"ListingKey" => "29899170"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T23:45:22.9Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29899170/802-158-king-street-n-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "GRAND RIVER"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-12T23:45:22.88Z"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:2 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29899170_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899170/c9f9edbe5d42a5401deaefe7bbeeb2ad.webp"
"MediaSize" => 218779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899170/thumbnail-c9f9edbe5d42a5401deaefe7bbeeb2ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13440456"
"ResourceRecordKey" => "29899170"
"ModificationTimestamp" => "2026-06-12T23:45:22.88Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29899170_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29899170/29c9f8302434e586e475615db2b07ffc.webp"
"MediaSize" => 137068
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29899170/thumbnail-29c9f8302434e586e475615db2b07ffc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440456"
"ResourceRecordKey" => "29899170"
"ModificationTimestamp" => "2026-06-12T23:45:22.88Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29899170')"
+"ID": "1527184"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25211
+post_id: "1526269"
+post_author: 1
+"ListingKey": "29898953"
+"ListingId": "40839172"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T23:00:14Z"
+"RFModificationTimestamp": "2026-06-13T01:24:25Z"
+"ListPrice": 349900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 761.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2H4Y7"
+"UnparsedAddress": "158 KING Street N Unit# 802, Waterloo, Ontario N2H4Y7"
+"Coordinates": array:2 [
0 => -80.5235595
1 => 43.4715456
]
+"Latitude": 43.4715456
+"Longitude": -80.5235595
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 802 at 158 King Street North, Waterloo, a fantastic opportunity for homeowners, investors, or parents looking to secure a property for their child in one of Waterloo's most desirable locations. Offering approximately 700 square feet of thoughtfully designed living space, this carpet-free condo features 2 spacious bedrooms, 2 full bathrooms, and an open-concept layout that perfectly blends functionality and comfort. From the moment you step inside, you'll appreciate the modern vinyl flooring that flows throughout the unit, creating a clean and contemporary feel. The kitchen is equipped with stainless steel appliances, ample cabinetry, and plenty of workspace, making meal preparation both convenient and enjoyable. Overlooking the bright living and dining area, the open-concept design creates the perfect setting for entertaining guests, hosting dinner with friends, or simply relaxing after a long day. The well-designed floor plan offers two generously sized bedrooms and two full bathrooms, providing flexibility and privacy for roommates, professionals, students, or small families. Step outside onto your private balcony and enjoy sweeping views of Waterloo's vibrant cityscape. Located in the heart of Waterloo, you're just minutes from the University of Waterloo, Wilfrid Laurier University, Conestoga College, restaurants, cafes, parks, shopping, public transit, and countless everyday amenities. Whether you're looking for a place to call home, an investment property, or a smart purchase for a student attending university, this condo checks all the boxes. Don't miss your chance to own in a prime Waterloo location with exceptional convenience and long-term value. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFee": "479.4"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T01:24:15.227570+00:00"
+"Directions": "King St N & Noecker St"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564507"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-12T22:50:31Z"
+"PhotosCount": 2
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T22:50:31Z"
+"Stories": "1.0"
+"StreetDirSuffix": "North"
+"StreetName": "KING"
+"StreetNumber": "158"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3594.97"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1658070448"
"RoomType" => "Kitchen"
"ListingId" => "40839172"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29898953"
"RoomLength" => null
"RoomDimensions" => "1'1'' x 1'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T22:50:31.92Z"
]
1 => array:11 [
"RoomKey" => "1658070449"
"RoomType" => "Bedroom"
"ListingId" => "40839172"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29898953"
"RoomLength" => null
"RoomDimensions" => "1'1'' x 1'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T22:50:31.92Z"
]
2 => array:11 [
"RoomKey" => "1658070450"
"RoomType" => "Full bathroom"
"ListingId" => "40839172"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29898953"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T22:50:31.92Z"
]
3 => array:11 [
"RoomKey" => "1658070451"
"RoomType" => "Primary Bedroom"
"ListingId" => "40839172"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29898953"
"RoomLength" => null
"RoomDimensions" => "1'1'' x 1'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T22:50:31.92Z"
]
4 => array:11 [
"RoomKey" => "1658070452"
"RoomType" => "3pc Bathroom"
"ListingId" => "40839172"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29898953"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T22:50:31.92Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29898953/158-king-street-n-unit-802-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2096014"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "289722"
+"GeocodeManualYN": true
+"ZoningDescription": "RMU-81"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 761
+"OriginalEntryTimestamp": "2026-06-12T22:50:31.89Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1123254"
+"ListOfficeNationalAssociationId": "1380559"
+"CoListAgentNationalAssociationId": "1368188"
+"CoListOfficeNationalAssociationId": "1380559"
+"Media": array:2 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29898953_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898953/c885bc1030a4a2288bde096709459610.webp"
"MediaSize" => 115123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898953/thumbnail-c885bc1030a4a2288bde096709459610.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839172"
"ResourceRecordKey" => "29898953"
"ModificationTimestamp" => "2026-06-12T22:50:31.89Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29898953_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898953/34f6efe98c73f1b0ef268b4d17a34da3.webp"
"MediaSize" => 64277
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898953/thumbnail-34f6efe98c73f1b0ef268b4d17a34da3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839172"
"ResourceRecordKey" => "29898953"
"ModificationTimestamp" => "2026-06-12T22:50:31.89Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898953')"
+"ID": "1526269"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25189
+post_id: "1526270"
+post_author: 1
+"ListingKey": "29897383"
+"ListingId": "40837367"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T19:40:09Z"
+"RFModificationTimestamp": "2026-06-13T00:25:08Z"
+"ListPrice": 479900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 874.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3V9"
+"UnparsedAddress": "258B SUNVIEW Street Unit# 2127, Waterloo, Ontario N2L3V9"
+"Coordinates": array:2 [
0 => -80.5338798
1 => 43.4744269
]
+"Latitude": 43.4744269
+"Longitude": -80.5338798
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Amazing opportunity in the heart of Waterloo, just steps to University of Waterloo, Wilfrid Laurier University, and Conestoga College. This bright and spacious unit offers an exceptional layout ideal for students, young professionals, or savvy investors looking to secure property in a high-demand rental area.Featuring 3 generously sized bedrooms and 2 large full bathrooms, this well-designed suite provides comfortable shared living with excellent privacy. The open-concept living and dining area is filled with natural light, creating a warm and inviting atmosphere. A large kitchen with stainless steel appliances offers ample cabinetry and counter space, perfect for everyday living. Convenient in-suite laundry adds to the overall functionality of the unit.Fully furnished and move-in ready, this is a turnkey investment opportunity with strong rental potential due to its unbeatable proximity to major post-secondary institutions. An excellent option for parents looking to invest in their child's future - why pay rent when you can build equity instead? Allow your child to live comfortably while benefiting from ownership in one of Waterloo's most sought-after university locations.Whether you are expanding your investment portfolio or purchasing for personal use, this bright, spacious, and well-maintained unit presents outstanding value in a thriving academic community. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "535.84"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T00:21:35.373659+00:00"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2098833"
+"ListOfficeKey": "288559"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-12T19:32:10Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T19:32:10Z"
+"Stories": "1.0"
+"StreetName": "SUNVIEW"
+"StreetNumber": "258"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "5649.32"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1657926407"
"RoomType" => "3pc Bathroom"
"ListingId" => "40837367"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29897383"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T19:32:10.49Z"
]
1 => array:11 [
"RoomKey" => "1657926408"
"RoomType" => "Bedroom"
"ListingId" => "40837367"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29897383"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 7'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T19:32:10.49Z"
]
2 => array:11 [
"RoomKey" => "1657926409"
"RoomType" => "Bedroom"
"ListingId" => "40837367"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29897383"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 6'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T19:32:10.49Z"
]
3 => array:11 [
"RoomKey" => "1657926410"
"RoomType" => "Primary Bedroom"
"ListingId" => "40837367"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29897383"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T19:32:10.49Z"
]
4 => array:11 [
"RoomKey" => "1657926411"
"RoomType" => "Kitchen"
"ListingId" => "40837367"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29897383"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 5'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T19:32:10.49Z"
]
5 => array:11 [
"RoomKey" => "1657926412"
"RoomType" => "Living room"
"ListingId" => "40837367"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29897383"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T19:32:10.49Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29897383/258b-sunview-street-unit-2127-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "NMU-12"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 874
+"OriginalEntryTimestamp": "2026-06-12T19:32:10.45Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1369061"
+"ListOfficeNationalAssociationId": "1400312"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29897383_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897383/19c9589d3ed931716bd66d94540e3049.webp"
"MediaSize" => 119083
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897383/thumbnail-19c9589d3ed931716bd66d94540e3049.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary multi-story building featuring a facade of blue glass and orange paneling"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40837367"
"ResourceRecordKey" => "29897383"
"ModificationTimestamp" => "2026-06-12T19:32:10.45Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29897383_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897383/b05f5b9f473a3b2ceb4ab72850506f62.webp"
"MediaSize" => 97970
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897383/thumbnail-b05f5b9f473a3b2ceb4ab72850506f62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern residential building featuring bold blue and red facade elements"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837367"
"ResourceRecordKey" => "29897383"
"ModificationTimestamp" => "2026-06-12T19:32:10.45Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29897383_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897383/031e69cd13ddaf20f4f7ad06687e9208.webp"
"MediaSize" => 112226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897383/thumbnail-031e69cd13ddaf20f4f7ad06687e9208.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern high-rise residential building featuring a multi-story facade with gray, blue, and orange panels"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837367"
"ResourceRecordKey" => "29897383"
"ModificationTimestamp" => "2026-06-12T19:32:10.45Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29897383_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897383/2cad15abea68681a8dd231dbfb60800e.webp"
"MediaSize" => 102591
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897383/thumbnail-2cad15abea68681a8dd231dbfb60800e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern high-rise residential building featuring a vibrant blue and orange facade"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837367"
"ResourceRecordKey" => "29897383"
"ModificationTimestamp" => "2026-06-12T19:32:10.45Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29897383_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897383/950d8bcad8c625f819cd55315e85b114.webp"
"MediaSize" => 98705
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897383/thumbnail-950d8bcad8c625f819cd55315e85b114.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Building entrance featuring glass doors, a white facade with signage, and vibrant blue and orange exterior panels"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837367"
"ResourceRecordKey" => "29897383"
"ModificationTimestamp" => "2026-06-12T19:32:10.45Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29897383_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897383/3ad64c815e8678319be81c096a41af6b.webp"
"MediaSize" => 96185
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897383/thumbnail-3ad64c815e8678319be81c096a41af6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern high-rise building exterior featuring a dynamic facade with vibrant orange and deep blue panels"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837367"
"ResourceRecordKey" => "29897383"
"ModificationTimestamp" => "2026-06-12T19:32:10.45Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29897383_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897383/a7934fbf7e46db68a96dcfa71f64ee17.webp"
"MediaSize" => 62204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897383/thumbnail-a7934fbf7e46db68a96dcfa71f64ee17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837367"
"ResourceRecordKey" => "29897383"
"ModificationTimestamp" => "2026-06-12T19:32:10.45Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29897383_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897383/e698c23958957fa28e8fc2ec71a3d9cf.webp"
"MediaSize" => 71761
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897383/thumbnail-e698c23958957fa28e8fc2ec71a3d9cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40837367"
"ResourceRecordKey" => "29897383"
"ModificationTimestamp" => "2026-06-12T19:32:10.45Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29897383_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29897383/2fe1faecaa6385b8b155950910ff3a7c.webp"
"MediaSize" => 75114
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29897383/thumbnail-2fe1faecaa6385b8b155950910ff3a7c.webp"
"ResourceName" => "Property"
…6
]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29897383')"
+"ID": "1526270"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25213
+post_id: "1524534"
+post_author: 1
+"ListingKey": "29896343"
+"ListingId": "40837423"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T23:10:10Z"
+"RFModificationTimestamp": "2026-06-12T23:15:52Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 691.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J1R1"
+"UnparsedAddress": "191 KING Street S Unit# 607, Waterloo, Ontario N2J1R1"
+"Coordinates": array:2 [
0 => -80.5185628
1 => 43.4596196
]
+"Latitude": 43.4596196
+"Longitude": -80.5185628
+"YearBuilt": 2009
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to the prestigious Bauer Lofts in the heart of Uptown Waterloo! This stunning southeast-facing 1-BEDROOM, 2-BATHROOM , 1 PARKING, 1 STORAGE condominium has been EXTENSIVELY RENOVATED FROM TOP TO BOTTOM IN 2024, offering modern luxury and turnkey living in one of Waterloo's most desirable buildings. Featuring soaring 10-Foot Ceilings and an Open-Concept Layout, this bright and spacious unit is flooded with natural sunlight and showcases beautiful city views from the PRIVATE BALCONY. The FULLY RENOVATED KITCHEN boasts Custom Cabinetry, elegant Quartz Countertops, a stylish Backsplash, and a complete set of five new(2024) Stainless Steel Appliances. NEW FLOORING flows throughout the entire unit, complemented by Fresh Paint and contemporary finishes. The spacious Primary Bedroom features Large Windows, Double Closets, and a beautifully updated ESUITE BATHROOM WITH A CUSTOM WALK-IN SHOWER AND NEW FLOORING. Additional upgrades include a renovated Powder Room, Electric Blinds with both Sunscreen and Blackout options, and a NEW FURNACE for enhanced comfort and efficiency. This exceptional unit also includes IN-SUITE LAUNDRY, ONE UNDERGROUND PARKING SPACE, AND A STORAGE LOCKER. JUST BRING YOUR SUITCASE! AVAILABLE FURNISHED OR UNFURNISHED! Residents enjoy PREMIUM AMENITIES including a Fitness Centre, Party Room, and 0utdoor Terrace. Located just steps from Uptown Waterloo's vibrant Restaurants, Cafés, Shopping, Parks, with a Walk Score of 93, you're just steps from Vincenzo’s, The Bauer Kitchen, Belmont Village, Waterloo Park, Universities, and steps away to the Light Rail Transit ,this is a rare opportunity to own a fully renovated luxury condo in an unbeatable location. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "507.4"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Water"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:15:14.237085+00:00"
+"Directions": "KING ST. S."
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Heat Pump"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2028169"
+"ListOfficeKey": "289890"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-12T23:10:00Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T23:10:00Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "KING"
+"StreetNumber": "191"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "4478.65"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29896343/191-king-street-s-unit-607-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "U2-81"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 691
+"OriginalEntryTimestamp": "2026-06-12T17:32:36.53Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1307428"
+"ListOfficeNationalAssociationId": "1382470"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896343')"
+"ID": "1524534"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25191
+post_id: "1523727"
+post_author: 1
+"ListingKey": "29895944"
+"ListingId": "40839092"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T17:00:13Z"
+"RFModificationTimestamp": "2026-06-12T17:27:21Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1546.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2G2G5"
+"UnparsedAddress": "3 GLASGOW Street, Kitchener, Ontario N2G2G5"
+"Coordinates": array:2 [
0 => -80.5085859
1 => 43.4547473
]
+"Latitude": 43.4547473
+"Longitude": -80.5085859
+"YearBuilt": 1921
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "An incredible, rare opportunity awaits first-time homebuyers in a highly sought-after Midtown location! This classic century home seamlessly blends historic character with endless potential, offering a blank canvas to customize a spacious 2 + 1 bedroom, 2 bathroom layout to perfectly fit your lifestyle. Location is everything, and here you are just a short stroll from the vibrant and trendy Belmont Village, known for its unique boutique shops, exceptional dining, and lively community atmosphere. You can also walk to the downtown core to explore even more local restaurants, parks, and schools. With unmatched convenience to public transit and the Waterloo Regional Health Network (WRHN), this property offers a premier urban lifestyle with future-proof investment value. Recognized as a legal duplex and with this layout, and location, opportunities liked this do not come along often for buyers looking to break into the market. Schedule your private viewing today! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-06-12T17:27:12.480634+00:00"
+"Directions": "Heading towards Victoria St on King St W, turn right onto Green St. Then left onto Park St and then left onto Glasgow St. After Gruhn St, before the bend, the house will be on the right."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1830296"
+"ListOfficeKey": "156381"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-12T16:51:49Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T16:51:49Z"
+"Stories": "1.5"
+"StreetName": "GLASGOW"
+"StreetNumber": "3"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "4527.32"
+"VirtualTourURLUnbranded": "https://youriguide.com/3_glasgow_st_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29895944/3-glasgow-street-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1750055"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "289634"
+"GeocodeManualYN": true
+"ZoningDescription": "R2B"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 70.0
+"AboveGradeFinishedArea": 1302
+"BelowGradeFinishedArea": 244
+"OriginalEntryTimestamp": "2026-06-12T16:51:49.82Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1195691"
+"ListOfficeNationalAssociationId": "1003914"
+"CoListAgentNationalAssociationId": "1066154"
+"CoListOfficeNationalAssociationId": "1379718"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895944')"
+"ID": "1523727"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25186
+post_id: "1523522"
+post_author: 1
+"ListingKey": "29894773"
+"ListingId": "40839244"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T15:30:07Z"
+"RFModificationTimestamp": "2026-06-12T15:32:17Z"
+"ListPrice": 1049900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2494.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2M2S4"
+"UnparsedAddress": "186 UNION Boulevard, Kitchener, Ontario N2M2S4"
+"Coordinates": array:2 [
0 => -80.5216985
1 => 43.4544746
]
+"Latitude": 43.4544746
+"Longitude": -80.5216985
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "**186 Union Boulevard, Kitchener** Located in the heart of prestigious Old Westmount, this beautifully maintained family home offers four bedrooms and four baths, space, privacy, and timeless appeal on one of Kitchener's most desirable streets. Surrounded by mature trees and established gardens, the property provides a private outdoor retreat complete with a charming waterfall pond and inviting backyard setting. Inside, hardwood flooring flows throughout the home. Abundant windows throughout the house fill the living spaces with natural light, creating a bright and welcoming atmosphere. The second floor features four generous bedrooms, including a spacious primary suite with large windows and a private ensuite bathroom. A stunning family bathroom with beautiful tile work serves the additional bedrooms. The main floor is designed for both everyday living and entertaining. A renovated kitchen opens to the breakfast and family rooms, where walls of floor-to-ceiling windows overlook the gardens and flood the space with natural light. Through French doors, a formal dining room and living room provide additional space to gather, while a convenient two-piece bathroom completes the main level. The finished basement extends the living space with a large recreation room and an additional two-piece bathroom. An attached garage, spacious double wide driveway, mature landscaping, and an exceptional Old Westmount location near schools, a welcoming community, parks, shopping, and Uptown Waterloo complete this rare offering. A wonderful opportunity to own a thoughtfully updated family home in one of the Region's most established and sought-after neighbourhoods. (id:62650)"
+"Appliances": array:4 [
0 => "Dishwasher"
1 => "Freezer"
2 => "Window Coverings"
3 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Partial"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T15:32:10.805384+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:3 [
0 => "Baseboard heaters"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2068773"
+"ListOfficeKey": "259258"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T14:42:56Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T15:20:10Z"
+"Stories": "2.0"
+"StreetName": "UNION"
+"StreetNumber": "186"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "5413"
+"VirtualTourURLUnbranded": "https://youriguide.com/186_union_blvd_kitchener_on/"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29894773/186-union-boulevard-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 53.0
+"AboveGradeFinishedArea": 1904
+"BelowGradeFinishedArea": 590
+"OriginalEntryTimestamp": "2026-06-12T14:40:34.02Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1343939"
+"ListOfficeNationalAssociationId": "1217708"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29894773')"
+"ID": "1523522"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1520747"
+post_author: 1
+"ListingKey": "29889721"
+"ListingId": "X13431934"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T17:30:19Z"
+"RFModificationTimestamp": "2026-06-11T18:01:55Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2G0E4"
+"UnparsedAddress": "317 - 15 WELLINGTON STREET, Kitchener, Ontario N2G0E4"
+"Coordinates": array:2 [
0 => -80.503066
1 => 43.453487
]
+"Latitude": 43.453487
+"Longitude": -80.503066
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 317 at Union Towers in Station Park, this two bedroom condo offers bright, open concept living with floor-to-ceiling windows and a private balcony. This unit includes underground parking and a storage locker. Enjoy unbeatable convenience just steps to LRT, bus routes, GO Transit, and VIA Rail. Residents have access to EXCEPTIONAL amenities including a bowling alley, lounge with games tables, swim spa, hot tub, fitness centre, Peloton room, pet wash station, landscaped terrace with BBQs, concierge service, private dining room, and smart parcel lockers. Shops, restaurants, and a grocery store are right at your doorstep. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "581"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T18:01:44.827823+00:00"
+"Directions": "Cross Streets: Walter St. ** Directions: King St & Wellington St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2091690"
+"ListOfficeKey": "286835"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-11T16:58:27Z"
+"PhotosCount": 40
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T16:58:27Z"
+"StreetName": "Wellington"
+"StreetNumber": "15"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3039"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/3FIpv8qWs2k?si=aTsAXl9GRzwZ5bKq"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29889721/317-15-wellington-street-kitchener"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Security/Concierge"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"ZoningDescription": "C5&C3"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-11T16:58:27.28Z"
+"ListAgentNationalAssociationId": "1364243"
+"ListOfficeNationalAssociationId": "1364242"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889721')"
+"ID": "1520747"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25214
+post_id: "1519733"
+post_author: 1
+"ListingKey": "29889577"
+"ListingId": "40838999"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T16:50:11Z"
+"RFModificationTimestamp": "2026-06-11T17:23:13Z"
+"ListPrice": 719000.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.5117619
1 => 43.4610948
]
+"Latitude": 43.4610948
+"Longitude": -80.5117619
+"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:62783)"
+"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"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T17:23:07.822020+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-11T16:44:33Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T16:44:32Z"
+"Stories": "1.0"
+"StreetName": "BOWMAN"
+"StreetNumber": "256"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "4164.85"
+"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/29889577/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-11T16:44:32.67Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889577')"
+"ID": "1519733"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25215
+post_id: "1519189"
+post_author: 1
+"ListingKey": "29889115"
+"ListingId": "40838944"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T16:20:12Z"
+"RFModificationTimestamp": "2026-06-11T16:57:25Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 700.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2G0E4"
+"UnparsedAddress": "15 WELLINGTON Street S Unit# 317, Kitchener, Ontario N2G0E4"
+"Coordinates": array:2 [
0 => -80.5018802
1 => 43.4542993
]
+"Latitude": 43.4542993
+"Longitude": -80.5018802
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 317 at Union Towers in Station Park, this two bedroom condo offers bright, open concept living with floor-to-ceiling windows and a private balcony. This unit includes underground parking and a storage locker. Enjoy unbeatable convenience just steps to LRT, bus routes, GO Transit, and VIA Rail. Residents have access to EXCEPTIONAL amenities including a bowling alley, lounge with games tables, swim spa, hot tub, fitness centre, Peloton room, pet wash station, landscaped terrace with BBQs, concierge service, private dining room, and smart parcel lockers. Shops, restaurants, and a grocery store are right at your doorstep. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "581"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T16:57:15.499354+00:00"
+"Directions": "Wellington & King St W"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1989184"
+"ListOfficeKey": "86262"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Open"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-11T16:10:59Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T16:10:59Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "WELLINGTON"
+"StreetNumber": "15"
+"StreetSuffix": "Street"
+"SubdivisionName": "313 - Downtown Kitchener/W. Ward"
+"TaxAnnualAmount": "3039"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/3FIpv8qWs2k?si=aTsAXl9GRzwZ5bKq"
+"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/29889115/15-wellington-street-s-unit-317-kitchener"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1876026"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "86262"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "C 5 & 3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 700
+"OriginalEntryTimestamp": "2026-06-11T16:10:59.83Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1273173"
+"ListOfficeNationalAssociationId": "1004415"
+"CoListAgentNationalAssociationId": "1204241"
+"CoListOfficeNationalAssociationId": "1004415"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889115')"
+"ID": "1519189"
}
]
+success: true
+page_size: 9
+page_count: 53
+count: 474
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]