array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29859011 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: "1498869"
+post_author: 1
+"ListingKey": "29859011"
+"ListingId": "40836651"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T17:55:11Z"
+"RFModificationTimestamp": "2026-06-10T18:05:43Z"
+"ListPrice": 559900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1137.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4S3"
+"UnparsedAddress": "6 WILLOW Street Unit# 1907, Waterloo, Ontario N2J4S3"
+"Coordinates": array:2 [
0 => -80.5162327
1 => 43.4658906
]
+"Latitude": 43.4658906
+"Longitude": -80.5162327
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 1907 at 6 Willow Street in Waterloo! This bright and inviting 2-bedroom, 1-bathroom condo offers comfortable living in a quiet, well-maintained building just minutes from Uptown Waterloo. Large windows fill the home with natural light and city views as far as the eye can see. The light filled space highlights the hardwood flooring that runs throughout the main living areas and bedrooms. The functional eat-in kitchen features updated stainless steel appliances and ample cabinet space, making meal preparation a breeze. A spacious den/family room provides additional living space that can be used as a home office, reading nook, or entertainment area. The renovated 3-piece bathroom showcases a modern walk-in shower, adding both style and convenience. Residents enjoy an impressive selection of building amenities including an indoor pool, sauna, exercise room, games room, library, party room, guest suites, elevator access, and visitor parking. The unit also includes one underground parking space for added convenience. Located in a peaceful neighbourhood close to Uptown Waterloo, you'll enjoy easy access to shopping, restaurants, parks, public transit, and all the amenities this vibrant community has to offer. Whether you're a first-time buyer, downsizer, or investor, this well-appointed condo offers an excellent opportunity in a sought-after Waterloo location. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "769.92"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Water"
4 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T17:17:56.695403+00:00"
+"Directions": "Erb St. E to Willow St."
+"ExteriorFeatures": array:1 [
0 => "Other"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908292"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "No Pet Home"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-10T17:45:52Z"
+"PhotosCount": 41
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T17:51:22Z"
+"Stories": "1.0"
+"StreetName": "WILLOW"
+"StreetNumber": "6"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "3973"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youriguide.com/1907_6_willow_street_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1656392094"
"RoomType" => "Primary Bedroom"
"ListingId" => "40836651"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859011"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 17'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T17:51:22.29Z"
]
1 => array:11 [
"RoomKey" => "1656392095"
"RoomType" => "Living room"
"ListingId" => "40836651"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859011"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 20'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T17:51:22.29Z"
]
2 => array:11 [
"RoomKey" => "1656392096"
"RoomType" => "Kitchen"
"ListingId" => "40836651"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859011"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T17:51:22.29Z"
]
3 => array:11 [
"RoomKey" => "1656392097"
"RoomType" => "Family room"
"ListingId" => "40836651"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859011"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 9'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T17:51:22.29Z"
]
4 => array:11 [
"RoomKey" => "1656392098"
"RoomType" => "Dinette"
"ListingId" => "40836651"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859011"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 6'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T17:51:22.3Z"
]
5 => array:11 [
"RoomKey" => "1656392099"
"RoomType" => "Bedroom"
"ListingId" => "40836651"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859011"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T17:51:22.3Z"
]
6 => array:11 [
"RoomKey" => "1656392100"
"RoomType" => "3pc Bathroom"
"ListingId" => "40836651"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29859011"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T17:51:22.3Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29859011/6-willow-street-unit-1907-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Guest Suite"
2 => "Party Room"
]
+"ZoningDescription": "RMU-81"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1137
+"OriginalEntryTimestamp": "2026-06-05T13:30:56.63Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1221205"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:41 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29859011_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/88f6cf2b374075fd4f1c4aa7183aa031.webp"
"MediaSize" => 125498
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-88f6cf2b374075fd4f1c4aa7183aa031.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29859011_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/15144945225d21316407dea0a7c5c76b.webp"
"MediaSize" => 129828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-15144945225d21316407dea0a7c5c76b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29859011_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/b6407a4480515f37a70efc3de89ecc7c.webp"
"MediaSize" => 145256
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-b6407a4480515f37a70efc3de89ecc7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29859011_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/71c2fd2e63d741affcea66161f814cc1.webp"
"MediaSize" => 146139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-71c2fd2e63d741affcea66161f814cc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29859011_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/15e082c43a149ab79f6cc533ed7ec78c.webp"
"MediaSize" => 95970
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-15e082c43a149ab79f6cc533ed7ec78c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29859011_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/2496bf63cf0329a67c44265e50421c23.webp"
"MediaSize" => 119609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-2496bf63cf0329a67c44265e50421c23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29859011_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/20f05f845cdc2b6e5398e16c71da9bef.webp"
"MediaSize" => 101335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-20f05f845cdc2b6e5398e16c71da9bef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29859011_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/2b93f1492bbe80a27a880bf66b629588.webp"
"MediaSize" => 59580
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-2b93f1492bbe80a27a880bf66b629588.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29859011_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/b01aef7e411bfb0f88f85d13d3b3e66e.webp"
"MediaSize" => 79121
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-b01aef7e411bfb0f88f85d13d3b3e66e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29859011_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/0e9ae0efdd60ef2c1af50f41b30506d4.webp"
"MediaSize" => 56067
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-0e9ae0efdd60ef2c1af50f41b30506d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29859011_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/edf177594653eb320d21c2a94180f096.webp"
"MediaSize" => 81505
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-edf177594653eb320d21c2a94180f096.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29859011_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/198faaf36a560518e6f5fd09b747fdd6.webp"
"MediaSize" => 66488
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-198faaf36a560518e6f5fd09b747fdd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29859011_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/2e7eaab4ba52c1ce7ffc80f63dd912fe.webp"
"MediaSize" => 65644
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-2e7eaab4ba52c1ce7ffc80f63dd912fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29859011_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/f46ba683f3d30ee6836d60271a4f2f4e.webp"
"MediaSize" => 80905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-f46ba683f3d30ee6836d60271a4f2f4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29859011_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/1663782a1dc7796806734e3bebb22821.webp"
"MediaSize" => 95863
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-1663782a1dc7796806734e3bebb22821.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29859011_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/079b0388654c6b65c56f1e6e33cd94bd.webp"
"MediaSize" => 76729
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-079b0388654c6b65c56f1e6e33cd94bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29859011_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/800ef82b14dc3bf9ed7f831049cddad9.webp"
"MediaSize" => 85216
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-800ef82b14dc3bf9ed7f831049cddad9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29859011_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/0061f9bd20ddae802d2fcc60777d5ff8.webp"
"MediaSize" => 84472
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-0061f9bd20ddae802d2fcc60777d5ff8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29859011_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/c24e73c62ab18b3b945393001a2dce73.webp"
"MediaSize" => 67515
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-c24e73c62ab18b3b945393001a2dce73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29859011_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/93accc1f9a0482d3244c0cf0e3941937.webp"
"MediaSize" => 69354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-93accc1f9a0482d3244c0cf0e3941937.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29859011_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/a4eebf560a8a16d8fbb87bbe9c0735fe.webp"
"MediaSize" => 45193
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-a4eebf560a8a16d8fbb87bbe9c0735fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29859011_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/211bf5f97d04c13f23dd29bba08efea6.webp"
"MediaSize" => 62468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-211bf5f97d04c13f23dd29bba08efea6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29859011_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/eefe656365b72a4a6bcda6e8b2f55529.webp"
"MediaSize" => 88195
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-eefe656365b72a4a6bcda6e8b2f55529.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29859011_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/975e866cbbb6c95fa316a1feef01fa0e.webp"
"MediaSize" => 44060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-975e866cbbb6c95fa316a1feef01fa0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29859011_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/550fd053d6916bc5dc56eb19095ef83f.webp"
"MediaSize" => 80285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-550fd053d6916bc5dc56eb19095ef83f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29859011_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/d282f8dd76d1aa9652f52f29822b3acc.webp"
"MediaSize" => 74484
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-d282f8dd76d1aa9652f52f29822b3acc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29859011_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/e290d5a3c3186b9829a6d0efaa0d772f.webp"
"MediaSize" => 58599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-e290d5a3c3186b9829a6d0efaa0d772f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29859011_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/13673468be33b945b2ab850494eec70a.webp"
"MediaSize" => 114074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-13673468be33b945b2ab850494eec70a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29859011_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/37f9dbcce194ece3474b81e2c063f39a.webp"
"MediaSize" => 139533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-37f9dbcce194ece3474b81e2c063f39a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29859011_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/37e31b6784248edeffc95809cca4cacf.webp"
"MediaSize" => 129424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-37e31b6784248edeffc95809cca4cacf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29859011_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/143f9b2f1042d3615a3c7aeaade0ed9d.webp"
"MediaSize" => 97353
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-143f9b2f1042d3615a3c7aeaade0ed9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29859011_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/5fea6a14cfc3982da3d6e267d0b090f7.webp"
"MediaSize" => 89070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-5fea6a14cfc3982da3d6e267d0b090f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29859011_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/4289e3e687c5bb65409f0be9abb348db.webp"
"MediaSize" => 92264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-4289e3e687c5bb65409f0be9abb348db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29859011_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/95a33ddb2498203117bbe4d664aec5ac.webp"
"MediaSize" => 90911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-95a33ddb2498203117bbe4d664aec5ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29859011_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/54b953a6e012ad3ddd18d6b4066fb05d.webp"
"MediaSize" => 82775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-54b953a6e012ad3ddd18d6b4066fb05d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29859011_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/d5879176e13463dce3d97c38355d29fd.webp"
"MediaSize" => 82721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-d5879176e13463dce3d97c38355d29fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29859011_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/7e3e18a6a780650292825394fc11495d.webp"
"MediaSize" => 147073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-7e3e18a6a780650292825394fc11495d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29859011_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/b129da23d62d545aa33f7fa874a6ecf0.webp"
"MediaSize" => 206751
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-b129da23d62d545aa33f7fa874a6ecf0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29859011_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/3adc9b51da69d42938357b54eb9c6770.webp"
"MediaSize" => 102152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-3adc9b51da69d42938357b54eb9c6770.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29859011_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/9fbfe288e89a384016d666e3db7cadf8.webp"
"MediaSize" => 139095
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-9fbfe288e89a384016d666e3db7cadf8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29859011_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29859011/b158b775171f45ce8dfc64bb47d1d2ab.webp"
"MediaSize" => 44914
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29859011/thumbnail-b158b775171f45ce8dfc64bb47d1d2ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836651"
"ResourceRecordKey" => "29859011"
"ModificationTimestamp" => "2026-06-05T13:30:56.63Z"
]
]
+"DaysOnMarket": 10
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29859011')"
+"ID": "1498869"
}
]
+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 289541" => 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.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1908292" => 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 '29859011'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25124
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29859011'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25140
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29859011' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5162327 43.4658906)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25213
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25187
+post_id: "1533540"
+post_author: 1
+"ListingKey": "29908184"
+"ListingId": "X13448740"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T03:50:00Z"
+"RFModificationTimestamp": "2026-06-16T04:03:05Z"
+"ListPrice": 409000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3T7"
+"UnparsedAddress": "113 - 253 ALBERT STREET, Waterloo, Ontario N2L3T7"
+"Coordinates": array:2 [
0 => -80.533259
1 => 43.47544
]
+"Latitude": 43.47544
+"Longitude": -80.533259
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "One Parking Space Included with this sleek, well-maintained condo. Enjoy high ceilings and a quiet environment for ultimate comfort and a modern touch throughout. The unit features In-Unit Laundry and a spacious Great Room with large windows, offering plenty of natural light. The modern kitchen boasts granite countertops and stainless steel appliances, perfect for cooking and entertaining. The condo includes 2 large bedrooms and 2 full bathrooms, offering ample space for comfort and privacy. The Master Bedroom features a generous walk-in closet and a private ensuite bathroom. This unit is also available fully furnished at no extra cost. Ceiling height of 12 feet adds to the airy and spacious feel of the home. Parking space #9 is included. This building offers a fantastic opportunity for anyone looking for a quiet condo near all amenities, ideal for investment or living in the sought-after University District of Waterloo, walking distance to campus! (id:62783)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Range"
4 => "Microwave"
]
+"AssociationFee": "805.05"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Water"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T04:02:59.260043+00:00"
+"Directions": "Cross Streets: Albert St & Columbia St W. ** Directions: University Ave. W & Albert St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2095720"
+"ListOfficeKey": "256758"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T03:42:45Z"
+"PhotosCount": 8
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T03:42:45Z"
+"StreetName": "Albert"
+"StreetNumber": "253"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4931.46"
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1660325623"
"RoomType" => "Kitchen"
"ListingId" => "X13448740"
"RoomLevel" => "Main level"
"RoomWidth" => 1.52
"ListingKey" => "29908184"
"RoomLength" => 5.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T03:42:45.79Z"
]
1 => array:11 [
"RoomKey" => "1660325624"
"RoomType" => "Dining room"
"ListingId" => "X13448740"
"RoomLevel" => "Main level"
"RoomWidth" => 1.83
"ListingKey" => "29908184"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T03:42:45.79Z"
]
2 => array:11 [
"RoomKey" => "1660325625"
"RoomType" => "Living room"
"ListingId" => "X13448740"
"RoomLevel" => "Main level"
"RoomWidth" => 3.66
"ListingKey" => "29908184"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T03:42:45.79Z"
]
3 => array:11 [
"RoomKey" => "1660325626"
"RoomType" => "Bedroom"
"ListingId" => "X13448740"
"RoomLevel" => "Main level"
"RoomWidth" => 3.66
"ListingKey" => "29908184"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T03:42:45.79Z"
]
4 => array:11 [
"RoomKey" => "1660325627"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13448740"
"RoomLevel" => "Main level"
"RoomWidth" => 5.49
"ListingKey" => "29908184"
"RoomLength" => 2.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T03:42:45.79Z"
]
5 => array:11 [
"RoomKey" => "1660325628"
"RoomType" => "Bathroom"
"ListingId" => "X13448740"
"RoomLevel" => "Main level"
"RoomWidth" => 1.8
"ListingKey" => "29908184"
"RoomLength" => 1.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T03:42:45.79Z"
]
6 => array:11 [
"RoomKey" => "1660325629"
"RoomType" => "Bathroom"
"ListingId" => "X13448740"
"RoomLevel" => "Main level"
"RoomWidth" => 1.7
"ListingKey" => "29908184"
"RoomLength" => 1.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T03:42:45.79Z"
]
7 => array:11 [
"RoomKey" => "1660325630"
"RoomType" => "Laundry room"
"ListingId" => "X13448740"
"RoomLevel" => "Main level"
"RoomWidth" => 1.0
"ListingKey" => "29908184"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T03:42:45.79Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29908184/113-253-albert-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-16T03:42:45.77Z"
+"ListAgentNationalAssociationId": "1367886"
+"ListOfficeNationalAssociationId": "1213267"
+"Media": array:8 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29908184_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908184/fc3439f8363293ef51b23946a27119de.webp"
"MediaSize" => 265629
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908184/thumbnail-fc3439f8363293ef51b23946a27119de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13448740"
"ResourceRecordKey" => "29908184"
"ModificationTimestamp" => "2026-06-16T03:42:45.77Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29908184_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908184/f2d72789aa6dd3aa929cd1ebef540e4b.webp"
"MediaSize" => 213148
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908184/thumbnail-f2d72789aa6dd3aa929cd1ebef540e4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448740"
"ResourceRecordKey" => "29908184"
"ModificationTimestamp" => "2026-06-16T03:42:45.77Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29908184_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908184/87d42c994161ff9eb755d3c62a5d4f68.webp"
"MediaSize" => 156907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908184/thumbnail-87d42c994161ff9eb755d3c62a5d4f68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448740"
"ResourceRecordKey" => "29908184"
"ModificationTimestamp" => "2026-06-16T03:42:45.77Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29908184_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908184/19cb7d68f5f8a63f58a5dc955e7c54e0.webp"
"MediaSize" => 143951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908184/thumbnail-19cb7d68f5f8a63f58a5dc955e7c54e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448740"
"ResourceRecordKey" => "29908184"
"ModificationTimestamp" => "2026-06-16T03:42:45.77Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29908184_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908184/e26d27ffe7a8a51048450d56afda34d0.webp"
"MediaSize" => 99863
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908184/thumbnail-e26d27ffe7a8a51048450d56afda34d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448740"
"ResourceRecordKey" => "29908184"
"ModificationTimestamp" => "2026-06-16T03:42:45.77Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29908184_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908184/188674c6fdcaac37212fc587e466ac21.webp"
"MediaSize" => 115099
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908184/thumbnail-188674c6fdcaac37212fc587e466ac21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448740"
"ResourceRecordKey" => "29908184"
"ModificationTimestamp" => "2026-06-16T03:42:45.77Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29908184_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908184/45b1c440a947c0044cd3caeebfdd9e2d.webp"
"MediaSize" => 127703
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908184/thumbnail-45b1c440a947c0044cd3caeebfdd9e2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448740"
"ResourceRecordKey" => "29908184"
"ModificationTimestamp" => "2026-06-16T03:42:45.77Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29908184_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29908184/4196d1f37426ea58c0ed147327132f5c.webp"
"MediaSize" => 121443
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29908184/thumbnail-4196d1f37426ea58c0ed147327132f5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13448740"
"ResourceRecordKey" => "29908184"
"ModificationTimestamp" => "2026-06-16T03:42:45.77Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908184')"
+"ID": "1533540"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25189
+post_id: "1531875"
+post_author: 1
+"ListingKey": "29905623"
+"ListingId": "40838864"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T19:00:16Z"
+"RFModificationTimestamp": "2026-06-15T21:51:31Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1086.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2H3Y6"
+"UnparsedAddress": "427 W DUKE Street W, Kitchener, Ontario N2H3Y6"
+"Coordinates": array:2 [
0 => -80.4991474
1 => 43.458489
]
+"Latitude": 43.458489
+"Longitude": -80.4991474
+"YearBuilt": 1902
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Attention Investors, Flippers & Families! Rare Midtown Corner Lot with massive potential available for the first time in 40+ years! This 1902 detached home sits on a premium 40’ x 119’ corner lot in a rapidly appreciating Midtown pocket near DTK, transit, and the Spur Line Trail. Surrounded by $1M+ redevelopments, this property offers ultimate flexibility for a high-end family renovation or a high-yield investment project. The existing 2-bed, 1.5-bath character home features great bones and excellent holding value. Major mechanical updates offer immediate peace of mind, including a furnace replaced in 2025 and a newer main roof from 2020. Move in, rent out, or renovate while finalizing your permits. The high density RES-5 zoning and dual street exposure are perfectly primed for intensification under Kitchener’s Growing Together framework. Capitalize on the corner configuration for separate unit entrances and streamlined parking logistics to build cluster townhouses, a multi-unit conversion, or an accessory dwelling. Best of all, leverage the 10 unit threshold for an expedited Zoning Certificate process, bypassing complex site plans. Whether you want to restore a piece of history or build a multi-unit legacy project, this prime piece of Midtown’s future is a must-see! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Satellite Dish"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-06-15T21:51:23.154049+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1988200"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Corner Site"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T18:51:20Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T18:51:20Z"
+"Stories": "2.0"
+"StreetDirPrefix": "West"
+"StreetDirSuffix": "West"
+"StreetName": "DUKE"
+"StreetNumber": "427"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "3488"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1660028009"
"RoomType" => "Mud room"
"ListingId" => "40838864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905623"
"RoomLength" => null
"RoomDimensions" => "6'3'' x 7'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:50:32.2Z"
]
1 => array:11 [
"RoomKey" => "1660028010"
"RoomType" => "Office"
"ListingId" => "40838864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905623"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:50:32.21Z"
]
2 => array:11 [
"RoomKey" => "1660028011"
"RoomType" => "Dining room"
"ListingId" => "40838864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905623"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:50:32.21Z"
]
3 => array:11 [
"RoomKey" => "1660028012"
"RoomType" => "Living room"
"ListingId" => "40838864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905623"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:50:32.22Z"
]
4 => array:11 [
"RoomKey" => "1660028013"
"RoomType" => "Kitchen"
"ListingId" => "40838864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905623"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:50:32.22Z"
]
5 => array:11 [
"RoomKey" => "1660028014"
"RoomType" => "Bedroom"
"ListingId" => "40838864"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29905623"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:50:32.22Z"
]
6 => array:11 [
"RoomKey" => "1660028015"
"RoomType" => "Primary Bedroom"
"ListingId" => "40838864"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29905623"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:50:32.23Z"
]
7 => array:11 [
"RoomKey" => "1660028016"
"RoomType" => "2pc Bathroom"
"ListingId" => "40838864"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29905623"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:50:32.23Z"
]
8 => array:11 [
"RoomKey" => "1660028017"
"RoomType" => "4pc Bathroom"
"ListingId" => "40838864"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29905623"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T18:50:32.24Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29905623/427-w-duke-street-w-kitchener"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RES-5/ Light Industrial"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 1086
+"OriginalEntryTimestamp": "2026-06-15T18:50:32.09Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1272354"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:37 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29905623_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/3755f498f36c429a3581ded2bc7fb1ac.webp"
"MediaSize" => 125191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-3755f498f36c429a3581ded2bc7fb1ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.24Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29905623_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/7cf926968d3edee281f1fd02e6ad575b.webp"
"MediaSize" => 148839
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-7cf926968d3edee281f1fd02e6ad575b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.62Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29905623_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/fbd7e68d2364a215889144bb39681227.webp"
"MediaSize" => 138690
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-fbd7e68d2364a215889144bb39681227.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.61Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29905623_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/5ff787643ad9913bd0a67541ef94b985.webp"
"MediaSize" => 143181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-5ff787643ad9913bd0a67541ef94b985.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.59Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29905623_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/0ede187f1da6c1d0f0eb1f6a9a22589c.webp"
"MediaSize" => 114884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-0ede187f1da6c1d0f0eb1f6a9a22589c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.63Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29905623_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/7e504ca892250bad931aa8a771198e47.webp"
"MediaSize" => 71961
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-7e504ca892250bad931aa8a771198e47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
…4
]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905623')"
+"ID": "1531875"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25186
+post_id: "1531876"
+post_author: 1
+"ListingKey": "29906649"
+"ListingId": "40840091"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T21:40:09Z"
+"RFModificationTimestamp": "2026-06-15T21:45:12Z"
+"ListPrice": 339000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 688.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3M7"
+"UnparsedAddress": "318 SPRUCE Street Unit# 1106, Waterloo, Ontario N2L3M7"
+"Coordinates": array:2 [
0 => -80.5265379
1 => 43.4788845
]
+"Latitude": 43.4788845
+"Longitude": -80.5265379
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This stylish and convenient condo is in excellent condition, featuring a 1-bedroom plus 1 den layout with 2 bathrooms. The unit is carpet-free, offering a modern and clean living space. It boasts a spacious 9 ft ceiling that creates an open and airy atmosphere. The balcony seamlessly connects the living room and bedroom, providing easy access to fresh air and outdoor relaxation. The den is a versatile space that can serve as a home office or a temporary guest room, catering to different needs. The built-in laundry room adds to the convenience, making everyday living effortless. The condo is ideally located with shopping plazas and restaurants just steps away, ensuring you have everything you need at your fingertips. It is adjacent to the prestigious Waterloo Collegiate Institute (WCI) and offers close proximity to Laurier University, the University of Waterloo, and Conestoga College (Waterloo Campus), making it an excellent choice for families, professionals, or students. Don't miss the opportunity to own this bright and functional condo that perfectly balances comfort, style, and location. Contact us today for more details or to schedule a viewing! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
5 => "Microwave Built-in"
]
+"AssociationFee": "497.23"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Water"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T21:34:29.172215+00:00"
+"Directions": "Columbia St W to Spruce St"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2073939"
+"ListOfficeKey": "253316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-15T21:32:00Z"
+"PhotosCount": 16
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T21:32:00Z"
+"Stories": "1.0"
+"StreetName": "SPRUCE"
+"StreetNumber": "318"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3919.05"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29906649/318-spruce-street-unit-1106-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Guest Suite"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 688
+"OriginalEntryTimestamp": "2026-06-15T21:10:52.76Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1349103"
+"ListOfficeNationalAssociationId": "1223329"
+"Media": array:16 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29906649')"
+"ID": "1531876"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25190
+post_id: "1531877"
+post_author: 1
+"ListingKey": "29903455"
+"ListingId": "40839531"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T15:00:15Z"
+"RFModificationTimestamp": "2026-06-15T21:09:21Z"
+"ListPrice": 1349900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2865.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2H3"
+"UnparsedAddress": "115 ROSLIN Avenue S, Waterloo, Ontario N2L2H3"
+"Coordinates": array:2 [
0 => -80.5262505
1 => 43.4554417
]
+"Latitude": 43.4554417
+"Longitude": -80.5262505
+"YearBuilt": 1948
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A rare offering in a prime Westmount location, this beautifully renovated home sits on an exceptional 70 ft x 250 ft private, tree-lined lot with no visible neighbours. Offering over 2700 square feet of total living space, the home is thoughtfully designed for both everyday living and entertaining. The main floor is anchored by a massive, modern kitchen with Elmwood cabinetry featuring eco-conscious materials. The huge windows that flood the space with natural light, loads of counter space with center island make this an exceptional space for entertaining. The formal living room features large windows, built-in bookshelves and wood burning fireplace. This space flows seamlessly to an open-concept spacious dining room ideal for hosting large gatherings. Additional main-floor highlights include a 2-piece powder room and a sunken family room with wood stove and stunning picturesque views of treed backyard. The family room leads directly to a massive 250-foot-deep, private, tree-lined backyard with western sun exposure, offering exceptional outdoor enjoyment. The space easily accommodates a hot tub, two-tier deck, and a generous kids’ play area, while still providing ample room for entertaining and relaxation. The upper level features hardwood flooring throughout and a spacious primary bedroom with a 5-piece ensuite. Two additional generously sized children’s bedrooms, a dedicated kids’ bathroom, and a convenient upper-floor laundry room complete this well-designed second level. The lower level offers additional functional living space, featuring a rec room with a wood-burning fireplace, a 2-piece bathroom, a dedicated home office with windows and ample storage. A unique opportunity to own a move-in-ready home on one of the largest and most private residential lots in the Old Westmount neighbourhood, close to parks, schools, UpTown Waterloo, LRT, Cigi, Perimeter Institute and Waterloo Park. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T21:09:09.930699+00:00"
+"Directions": "NORMAN TO ROSLIN OR JOHN STREET WEST TO ROSLIN"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceFeatures": array:4 [
0 => "Wood"
1 => "Wood"
2 => "Other - See remarks"
3 => "Stove"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1600661"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T14:52:11Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T14:52:11Z"
+"Stories": "2.0"
+"StreetDirSuffix": "South"
+"StreetName": "ROSLIN"
+"StreetNumber": "115"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "8687"
+"VirtualTourURLUnbranded": "https://youriguide.com/115_roslin_ave_s_waterloo_on/doc/floorplan_imperial_en.pdf"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29903455/115-roslin-avenue-s-waterloo"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 70.0
+"AboveGradeFinishedArea": 2465
+"BelowGradeFinishedArea": 400
+"OriginalEntryTimestamp": "2026-06-15T14:51:43.54Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1155649"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:34 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29903455')"
+"ID": "1531877"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25188
+post_id: "1531330"
+post_author: 1
+"ListingKey": "29906169"
+"ListingId": "X13447076"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T20:30:18Z"
+"RFModificationTimestamp": "2026-06-15T20:55:53Z"
+"ListPrice": 675000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3K9"
+"UnparsedAddress": "209 DIXIE CRESCENT, Waterloo, Ontario N2J3K9"
+"Coordinates": array:2 [
0 => -80.513059
1 => 43.477575
]
+"Latitude": 43.477575
+"Longitude": -80.513059
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 209 Dixie Crescent, a lovingly maintained bungalow that has been cherished by the same family for over 60 years and is now ready for its next chapter. Nestled on a quiet, tree-lined crescent in one of Waterloo's most established and family-friendly neighbourhoods, this home offers over 2,000 square feet of finished living space and endless potential. Featuring 3 bedrooms, 2 bathrooms, and a solid, well-built structure, this home provides the perfect opportunity to move in and enjoy or renovate and create the home of your dreams. Many of the major updates have already been completed, including windows, roof (2015), furnace (2022), and central air conditioning (2022), allowing you to focus on personalizing the interior to suit your style and needs. Inside, a bright and welcoming living room is filled with natural light from a large picture window. The adjoining dining area offers a comfortable space for everyday meals and family gatherings, with sliding patio doors leading to a covered deck-an ideal setting for morning coffee or entertaining. The finished basement with a separate entrance adds exceptional versatility, offering excellent potential for multi-generational living, rental possibilities, or simply additional space for recreation, hobbies, and family enjoyment. One of the standout features of this property is the mature backyard. Rarely found in newer developments, the expansive outdoor space provides privacy, room to play, and endless possibilities for gardening, entertaining, or future enhancements. Beyond the existing fence line, you'll discover approximately 20 additional feet of usable space, further expanding the potential of this remarkable lot. Conveniently located close to excellent schools, both universities, parks, trails, shopping, transit, and the expressway, this is more than just a home-it's an opportunity to establish roots in a sought-after Waterloo neighbourhood and create lasting memories for years to come. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T20:55:49.379184+00:00"
+"Directions": "Cross Streets: Marshall. ** Directions: Willowdale to Dixie."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:1 [
0 => "Free Standing Metal"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2133582"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "52 x 125 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T20:02:48Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T20:23:02Z"
+"Stories": "1.0"
+"StreetName": "Dixie"
+"StreetNumber": "209"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4397.04"
+"VirtualTourURLUnbranded": "https://youriguide.com/209_dixie_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29906169/209-dixie-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 52.0
+"OriginalEntryTimestamp": "2026-06-15T20:02:48.53Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1386021"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:49 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29906169')"
+"ID": "1531330"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25183
+post_id: "1530915"
+post_author: 1
+"ListingKey": "29905375"
+"ListingId": "40839708"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T18:40:17Z"
+"RFModificationTimestamp": "2026-06-15T19:18:31Z"
+"ListPrice": 675000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1944.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3K9"
+"UnparsedAddress": "209 DIXIE Crescent, Waterloo, Ontario N2J3K9"
+"Coordinates": array:2 [
0 => -80.5129309
1 => 43.4776275
]
+"Latitude": 43.4776275
+"Longitude": -80.5129309
+"YearBuilt": 1966
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 209 Dixie Crescent, a lovingly maintained bungalow that has been cherished by the same family for over 60 years and is now ready for its next chapter. Nestled on a quiet, tree-lined crescent in one of Waterloo’s most established and family-friendly neighbourhoods, this home offers over 2,000 square feet of finished living space and endless potential. Featuring 3 bedrooms, 2 bathrooms, and a solid, well-built structure, this home provides the perfect opportunity to move in and enjoy or renovate and create the home of your dreams. Many of the major updates have already been completed, including windows, roof (2015), furnace (2022), and central air conditioning (2022), allowing you to focus on personalizing the interior to suit your style and needs. Inside, a bright and welcoming living room is filled with natural light from a large picture window. The adjoining dining area offers a comfortable space for everyday meals and family gatherings, with sliding patio doors leading to a covered deck—an ideal setting for morning coffee or entertaining. The finished basement with a separate entrance adds exceptional versatility, offering excellent potential for multi-generational living, rental possibilities, or simply additional space for recreation, hobbies, and family enjoyment. One of the standout features of this property is the mature backyard. Rarely found in newer developments, the expansive outdoor space provides privacy, room to play, and endless possibilities for gardening, entertaining, or future enhancements. Beyond the existing fence line, you'll discover approximately 20 additional feet of usable space, further expanding the potential of this remarkable lot. Conveniently located close to excellent schools, both universities, parks, trails, shopping, transit, and the expressway, this is more than just a home—it's an opportunity to establish roots in a sought-after Waterloo neighbourhood and create lasting memories for years to come. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T19:18:29.343865+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563431"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Gazebo"
2 => "Private Yard"
]
+"PhotosChangeTimestamp": "2026-06-15T18:32:40Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T18:32:39Z"
+"Stories": "1.0"
+"StreetName": "DIXIE"
+"StreetNumber": "209"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "4397.04"
+"VirtualTourURLUnbranded": "https://youriguide.com/209_dixie_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29905375/209-dixie-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 52.0
+"AboveGradeFinishedArea": 1020
+"BelowGradeFinishedArea": 924
+"OriginalEntryTimestamp": "2026-06-15T18:32:39.94Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1069710"
+"ListOfficeNationalAssociationId": "1380559"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905375')"
+"ID": "1530915"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1530353"
+post_author: 1
+"ListingKey": "29904032"
+"ListingId": "X13444928"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T16:20:09Z"
+"RFModificationTimestamp": "2026-06-15T17:27:18Z"
+"ListPrice": 308000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K2"
+"UnparsedAddress": "257 HEMLOCK STREET, Waterloo, Ontario N2L0K2"
+"Coordinates": array:2 [
0 => -80.532334
1 => 43.475918
]
+"Latitude": 43.475918
+"Longitude": -80.532334
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Own a stylish, fully furnished 1-bedroom condo in the highly desirable Sage X Condos. Just steps from the University of Waterloo and Wilfrid Laurier University, this turnkey suite comes complete with a bed, sofa, large TV, wall desk with chair, dining set, and blinds. Perfect for investors, students, or young professionals seeking modern living in the heart of Waterloo's vibrant university district. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Oven"
4 => "Dryer"
5 => "Microwave"
6 => "Cooktop"
7 => "Blinds"
]
+"AssociationFee": "590.3"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T17:27:07.908669+00:00"
+"Directions": "University Ave & Hemlock St"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2006649"
+"ListOfficeKey": "273193"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T16:14:02Z"
+"PhotosCount": 19
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T16:14:01Z"
+"StreetName": "Hemlock"
+"StreetNumber": "257"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2835.87"
+"Utilities": array:2 [
0 => "Cable"
1 => "Telephone"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29904032/257-hemlock-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "WILSON BLANCHARD MANAGEMENT"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Party Room"
2 => "Security/Concierge"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 499
+"LivingAreaMinimum": 0
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-15T16:14:01.8Z"
+"ListAgentNationalAssociationId": "1288878"
+"ListOfficeNationalAssociationId": "1248888"
+"Media": array:19 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29904032')"
+"ID": "1530353"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25191
+post_id: "1530128"
+post_author: 1
+"ListingKey": "29902568"
+"ListingId": "40837716"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T17:00:13Z"
+"RFModificationTimestamp": "2026-06-15T17:10:22Z"
+"ListPrice": 814900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1469.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4S3"
+"UnparsedAddress": "6 WILLOW Street Unit# 602, Waterloo, Ontario N2J4S3"
+"Coordinates": array:2 [
0 => -80.5179177
1 => 43.4655354
]
+"Latitude": 43.4655354
+"Longitude": -80.5179177
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Waterpark Place, one of Waterloo’s most sought-after condominium communities. The Niagara, a beautifully remodeled, move-in-ready corner suite that is sure to impress even the most discerning buyer. Bright, spacious 2-bedroom unit enjoys southern exposure, filling the home with natural light and offering attractive views from the private balcony. Engineered hardwood flooring flows throughout the unit, complemented by a modern linear fireplace, den area. The generous dining space easily accommodates full-sized furnishings. Stunning custom-designed kitchen is a true highlight, featuring stainless steel appliances, pull-out drawers for convenient access, a pantry, and innovative vertical-lift cabinetry that combines style and functionality. Designed with privacy in mind, the split-bedroom layout places each bedroom at opposite ends of the suite. Spacious primary retreat boasts a custom closet system and a luxurious ensuite complete with an oversized frameless glass shower, double vanity, and abundant storage. The second bedroom is conveniently located beside an additional fully renovated bathroom. Additional features, custom window coverings, a large balcony, an oversized laundry room with Bosch appliances and a folding counter, a storage locker, and two owned side-by-side parking spaces ideally situated near the garage entrance. Residents of Waterpark Place enjoy an exceptional array of amenities, including guest suites, a party room, billiards room, indoor swimming pool, sauna, fitness center, and ample visitor parking. Set on more than three acres of beautifully landscaped, park-like grounds, the property offers inviting outdoor patio spaces, meticulous maintenance, and outstanding on-site management. Note some rooms have been virtually staged (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"AssociationFee": "1024.77"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T15:56:49.139074+00:00"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564020"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "No Pet Home"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-15T12:51:34Z"
+"PhotosCount": 49
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T16:52:17Z"
+"Stories": "6.0"
+"StreetName": "WILLOW"
+"StreetNumber": "6"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "5285.04"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/6-Willow-St-4/idx"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29902568/6-willow-street-unit-602-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1563505"
+"CommonInterest": "Condo/Strata"
+"CoListAgentKey2": "1563476"
+"CoListOfficeKey": "76807"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Guest Suite"
2 => "Party Room"
]
+"CoListOfficeKey2": "76807"
+"ZoningDescription": "RMU-81"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1469
+"OriginalEntryTimestamp": "2026-06-15T11:51:03.68Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1120111"
+"ListOfficeNationalAssociationId": "1380559"
+"CoListAgentNationalAssociationId": "1069688"
+"CoListAgentNationalAssociationId2": "1102411"
+"CoListOfficeNationalAssociationId": "1004370"
+"CoListOfficeNationalAssociationId2": "1004370"
+"Media": array:49 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29902568')"
+"ID": "1530128"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25211
+post_id: "1530170"
+post_author: 1
+"ListingKey": "29902563"
+"ListingId": "40839258"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T18:20:03Z"
+"RFModificationTimestamp": "2026-06-15T18:53:02Z"
+"ListPrice": 469900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 975.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0G2"
+"UnparsedAddress": "103 ROGER Street Unit# 102, Waterloo, Ontario N2J0G2"
+"Coordinates": array:2 [
0 => -80.5101562
1 => 43.4604752
]
+"Latitude": 43.4604752
+"Longitude": -80.5101562
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Condo living at its best! This stunning 2-bedroom, 2-bathroom corner suite offers nearly 1,000 sq. ft. of beautifully designed, carpet-free living space, flooded with natural light from its coveted south-east exposure and expansive windows. The moment you step inside, the 10-foot ceilings create an incredible sense of scale and openness. The thoughtfully designed kitchen is equal parts stylish and functional, featuring stainless steel appliances, granite countertops, a large centre island, and a modern backsplash—perfect for entertaining or everyday living. The spacious primary bedroom offers a walk-in closet and private ensuite, while the second bedroom provides flexibility for guests, a home office, or growing families. Freshly painted throughout, it also boasts in-suite laundry, abundant storage, and garage parking for added convenience. Step outside to your private balcony and enjoy your morning coffee or evening unwind. Positioned in an unbeatable central location, you're just moments from shopping, restaurants, transit, parks, and everyday amenities. Modern design. Exceptional natural light. An incredible location. This is the turnkey condo you've been waiting for. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Microwave Built-in"
]
+"AssociationFee": "520.4"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T15:49:22.522879+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1784347"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Corner Site"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T11:50:47Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T18:11:08Z"
+"Stories": "1.0"
+"StreetName": "ROGER"
+"StreetNumber": "103"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "4643"
+"VirtualTourURLUnbranded": "https://youriguide.com/102_103_roger_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29902563/103-roger-street-unit-102-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "GR1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 975
+"OriginalEntryTimestamp": "2026-06-15T11:50:47.03Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1188300"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:42 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29902563')"
+"ID": "1530170"
}
]
+success: true
+page_size: 9
+page_count: 52
+count: 468
+after_key: ""
}
"RF Response Time" => "0.19 seconds"
]
]