array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29994550 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23448
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23450
+post_id: "1596983"
+post_author: 1
+"ListingKey": "29994550"
+"ListingId": "X13527834"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T18:20:09Z"
+"RFModificationTimestamp": "2026-07-06T20:15:54Z"
+"ListPrice": 824999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3S9"
+"UnparsedAddress": "225 DARTMOOR CRESCENT, Waterloo, Ontario N2K3S9"
+"Coordinates": array:2 [
0 => -80.487876
1 => 43.487142
]
+"Latitude": 43.487142
+"Longitude": -80.487876
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 225 Dartmoor Crescent in Waterloo, a spacious and well-maintained two-storey home offering over 2,500 sq. ft. of total living space in a sought-after family-friendly neighbourhood. This 3 bedroom, 4 bathroom home features a functional layout designed for both everyday living and entertaining. The main floor offers a large, inviting living room complete with a cozy fireplace, engineered hardwood floors, and extra large windows that fill the space with natural light. The living area flows seamlessly into the dining room, creating the perfect setting for family gatherings and hosting guests. The kitchen offers plenty of cabinet space, room for a breakfast table, and sliding glass doors leading to a private fully fenced backyard with patio, ideal for summer BBQs, outdoor dining, or relaxing evenings. Upstairs, you'll find three generously sized bedrooms with plush carpeting, including a spacious primary suite featuring its own private ensuite bathroom. The finished basement adds even more living space with a large rec room complete with a built-in bar, making it the perfect spot for entertaining, movie nights, or a games area. Additional highlights include a double car garage and ample storage throughout. Conveniently located close to Bechtel Park, Bridgeport Public School, shopping, amenities, and with easy access to Highway 85 for commuters, this home offers the perfect combination of comfort, space, and location. (id:62650)"
+"Appliances": array:1 [
0 => "Water softener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-06T20:15:41.243236+00:00"
+"Directions": "DARTMOOR CRES AND BRIDLE TRAIL"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "Natural gas"
2 => "Coil Fan"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2238795"
+"ListOfficeKey": "294429"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "56 x 115.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T18:12:14Z"
+"PhotosCount": 28
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T18:12:14Z"
+"Stories": "2.0"
+"StreetName": "Dartmoor"
+"StreetNumber": "225"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "5480"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1676704679"
"RoomType" => "Kitchen"
"ListingId" => "X13527834"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29994550"
"RoomLength" => 4.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T18:12:14.59Z"
]
1 => array:11 [
"RoomKey" => "1676704680"
"RoomType" => "Dining room"
"ListingId" => "X13527834"
"RoomLevel" => "Main level"
"RoomWidth" => 3.51
"ListingKey" => "29994550"
"RoomLength" => 3.15
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T18:12:14.61Z"
]
2 => array:11 [
"RoomKey" => "1676704681"
"RoomType" => "Living room"
"ListingId" => "X13527834"
"RoomLevel" => "Main level"
"RoomWidth" => 5.72
"ListingKey" => "29994550"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T18:12:14.61Z"
]
3 => array:11 [
"RoomKey" => "1676704682"
"RoomType" => "Laundry room"
"ListingId" => "X13527834"
"RoomLevel" => "Main level"
"RoomWidth" => 1.96
"ListingKey" => "29994550"
"RoomLength" => 2.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T18:12:14.62Z"
]
4 => array:11 [
"RoomKey" => "1676704683"
"RoomType" => "Bedroom"
"ListingId" => "X13527834"
"RoomLevel" => "Main level"
"RoomWidth" => 5.54
"ListingKey" => "29994550"
"RoomLength" => 3.53
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T18:12:14.62Z"
]
5 => array:11 [
"RoomKey" => "1676704684"
"RoomType" => "Bedroom 2"
"ListingId" => "X13527834"
"RoomLevel" => "Main level"
"RoomWidth" => 2.9
"ListingKey" => "29994550"
"RoomLength" => 3.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T18:12:14.63Z"
]
6 => array:11 [
"RoomKey" => "1676704685"
"RoomType" => "Bedroom 3"
"ListingId" => "X13527834"
"RoomLevel" => "Main level"
"RoomWidth" => 2.9
"ListingKey" => "29994550"
"RoomLength" => 3.33
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T18:12:14.63Z"
]
7 => array:11 [
"RoomKey" => "1676704686"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13527834"
"RoomLevel" => "Basement"
"RoomWidth" => 5.97
"ListingKey" => "29994550"
"RoomLength" => 5.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-06T18:12:14.64Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29994550/225-dartmoor-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 56.0
+"OriginalEntryTimestamp": "2026-07-06T18:12:14.54Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1476614"
+"ListOfficeNationalAssociationId": "1438893"
+"Media": array:28 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29994550_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/6f5b5ec9e628b627cc91bfae55cabe49.webp"
"MediaSize" => 317010
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-6f5b5ec9e628b627cc91bfae55cabe49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29994550_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/0588f218da544e675f70a385662257be.webp"
"MediaSize" => 376601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-0588f218da544e675f70a385662257be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29994550_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/921e378fb991587709839260b63eecab.webp"
"MediaSize" => 321076
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-921e378fb991587709839260b63eecab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29994550_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/f470fc5f403d410bc51ab4adf0dadceb.webp"
"MediaSize" => 275375
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-f470fc5f403d410bc51ab4adf0dadceb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29994550_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/0b94947e856256cd821f7de955895f78.webp"
"MediaSize" => 228683
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-0b94947e856256cd821f7de955895f78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29994550_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/c3a98f0d113aaf170b548f4bf02d2841.webp"
"MediaSize" => 84940
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-c3a98f0d113aaf170b548f4bf02d2841.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29994550_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/52ac1b349652ec52bc0caea564d287ba.webp"
"MediaSize" => 171317
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-52ac1b349652ec52bc0caea564d287ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29994550_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/9fb9effc6693bb1ed247ffb6ab5232f7.webp"
"MediaSize" => 171920
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-9fb9effc6693bb1ed247ffb6ab5232f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29994550_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/e97c8404f03f3ea5e037c21ca134f068.webp"
"MediaSize" => 168701
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-e97c8404f03f3ea5e037c21ca134f068.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29994550_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/9736d76c1fe11027377e7ff9326ec230.webp"
"MediaSize" => 180054
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-9736d76c1fe11027377e7ff9326ec230.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29994550_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/f46ee35f9fb91ba7b6759ac1a19e35a5.webp"
"MediaSize" => 184136
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-f46ee35f9fb91ba7b6759ac1a19e35a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29994550_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/f45245eeaeb20f24dfb804c748b99398.webp"
"MediaSize" => 105872
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-f45245eeaeb20f24dfb804c748b99398.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29994550_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/bdff288cd316fdd37e8c5a2f26c69115.webp"
"MediaSize" => 185128
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-bdff288cd316fdd37e8c5a2f26c69115.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29994550_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/ffca4eb51408b6ee13f59f39e7847702.webp"
"MediaSize" => 193960
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-ffca4eb51408b6ee13f59f39e7847702.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29994550_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/ec0dbcc9e1eda21e6f69cd551121ec58.webp"
"MediaSize" => 128382
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-ec0dbcc9e1eda21e6f69cd551121ec58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29994550_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/f33c2a8d4816e03565d656731ebff4cb.webp"
"MediaSize" => 124438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-f33c2a8d4816e03565d656731ebff4cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29994550_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/34a5a9dfede7dd7af8d05481c11d5a3d.webp"
"MediaSize" => 195660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-34a5a9dfede7dd7af8d05481c11d5a3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29994550_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/7b09ed04bfa30d9f48999afa7efe9ecb.webp"
"MediaSize" => 95122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-7b09ed04bfa30d9f48999afa7efe9ecb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29994550_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/59c586e3e652ff04dd14cd9e741fa1ce.webp"
"MediaSize" => 157102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-59c586e3e652ff04dd14cd9e741fa1ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29994550_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/ab442a2cb75a9987f22752f3d4d4f409.webp"
"MediaSize" => 144795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-ab442a2cb75a9987f22752f3d4d4f409.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29994550_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/b9f6116e76fc926ffa9ba250cedb7cd3.webp"
"MediaSize" => 163294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-b9f6116e76fc926ffa9ba250cedb7cd3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29994550_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/8e641c3a063403292a5b6646ec985a68.webp"
"MediaSize" => 126420
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-8e641c3a063403292a5b6646ec985a68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29994550_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/7ff0ce509df3f4bbadc310dd2b84a02b.webp"
"MediaSize" => 380386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-7ff0ce509df3f4bbadc310dd2b84a02b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29994550_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/e31d2227badb16e1e5509ef73e9360d3.webp"
"MediaSize" => 354496
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-e31d2227badb16e1e5509ef73e9360d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29994550_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/468193b6b52e97e45586e4abe57faf7c.webp"
"MediaSize" => 389040
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-468193b6b52e97e45586e4abe57faf7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29994550_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/8cf5d0ae46427f281ff688aba332bc01.webp"
"MediaSize" => 109354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-8cf5d0ae46427f281ff688aba332bc01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29994550_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/24d05e812e51c3bf135bc4cb61b13bc3.webp"
"MediaSize" => 106093
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-24d05e812e51c3bf135bc4cb61b13bc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29994550_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29994550/8512e4fff10e6c2c631f392a7641bb5d.webp"
"MediaSize" => 97796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29994550/thumbnail-8512e4fff10e6c2c631f392a7641bb5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13527834"
"ResourceRecordKey" => "29994550"
"ModificationTimestamp" => "2026-07-06T18:12:14.55Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29994550')"
+"ID": "1596983"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 294429" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24883
+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 2238795" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24852
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29994550'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25231
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29994550'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25247
+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 '29994550' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.487876 43.487142)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25300
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25294
+post_id: 1602740
+post_author: 1
+"ListingKey": "30002359"
+"ListingId": "40846189"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T22:25:18Z"
+"RFModificationTimestamp": "2026-07-08T01:14:58Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1766.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3Y4"
+"UnparsedAddress": "299 DALE Crescent, Waterloo, Ontario N2J3Y4"
+"Coordinates": array:2 [
0 => -80.5092637
1 => 43.4842672
]
+"Latitude": 43.4842672
+"Longitude": -80.5092637
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 299 Dale Crescent – your chance to own a beautifully updated home on a quiet crescent in Waterloo's sought-after Glenridge neighbourhood. This bright and inviting 3 bedroom, 2 bathroom home has been extensively renovated, featuring modern finishes, updated flooring, and lighting throughout. The spacious open concept main level boasts an updated kitchen with quartz countertops by Franklin Kitchens and upgraded stainless-steel appliances, a living room with an accent wall and large windows, and a dining room with a bay window. The second level offers 3 spacious bedrooms and a fully renovated bathroom. The lower level includes a separate entrance, a fully finished rec room, bathroom, and laundry room, an ideal space for relaxation or entertaining. Outside, enjoy a private fenced backyard with a large yard and detached double car garage. Don't miss this rare opportunity to own a turn-key home with major updates already complete. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-08T01:14:51.247886+00:00"
+"Directions": "University Ave to Dale Cres"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2060458"
+"ListOfficeKey": "292862"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Private Yard"
]
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Carport"
]
+"PhotosChangeTimestamp": "2026-07-07T22:01:10Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T22:18:29Z"
+"Stories": "2.0"
+"StreetName": "DALE"
+"StreetNumber": "299"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "4697.82"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1677682906"
"RoomType" => "Bedroom"
"ListingId" => "40846189"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30002359"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T22:18:29.7Z"
]
1 => array:11 [
"RoomKey" => "1677682907"
"RoomType" => "Bedroom"
"ListingId" => "40846189"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30002359"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T22:18:29.71Z"
]
2 => array:11 [
"RoomKey" => "1677682908"
"RoomType" => "Primary Bedroom"
"ListingId" => "40846189"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30002359"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T22:18:29.71Z"
]
3 => array:11 [
"RoomKey" => "1677682909"
"RoomType" => "4pc Bathroom"
"ListingId" => "40846189"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30002359"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T22:18:29.71Z"
]
4 => array:11 [
"RoomKey" => "1677682910"
"RoomType" => "Living room"
"ListingId" => "40846189"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30002359"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T22:18:29.71Z"
]
5 => array:11 [
"RoomKey" => "1677682911"
"RoomType" => "Kitchen"
"ListingId" => "40846189"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30002359"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T22:18:29.71Z"
]
6 => array:11 [
"RoomKey" => "1677682912"
"RoomType" => "Dining room"
"ListingId" => "40846189"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30002359"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 16'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T22:18:29.71Z"
]
7 => array:11 [
"RoomKey" => "1677682913"
"RoomType" => "Laundry room"
"ListingId" => "40846189"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30002359"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T22:18:29.71Z"
]
8 => array:11 [
"RoomKey" => "1677682914"
"RoomType" => "3pc Bathroom"
"ListingId" => "40846189"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30002359"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T22:18:29.71Z"
]
9 => array:11 [
"RoomKey" => "1677682915"
"RoomType" => "Recreation room"
"ListingId" => "40846189"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30002359"
"RoomLength" => null
"RoomDimensions" => "15'6'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T22:18:29.71Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30002359/299-dale-crescent-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 55.0
+"AboveGradeFinishedArea": 1194
+"BelowGradeFinishedArea": 572
+"OriginalEntryTimestamp": "2026-07-07T21:59:01.23Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1335588"
+"ListOfficeNationalAssociationId": "1418673"
+"Media": array:38 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30002359_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/062b656a33a3e266ba7b51e000d7fda9.webp"
"MediaSize" => 150806
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-062b656a33a3e266ba7b51e000d7fda9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Split-level residence featuring white siding and a brick foundation"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:03.92Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30002359_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/125b4764d37da4768e825eb4ed67e646.webp"
"MediaSize" => 124509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-125b4764d37da4768e825eb4ed67e646.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Split-level home featuring white siding, dark brick accents, and a red shingle roof"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:05.83Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30002359_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/57f9381f233fca1615aee28f9981026b.webp"
"MediaSize" => 126695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-57f9381f233fca1615aee28f9981026b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Split-level residence featuring brick and siding exterior, a prominent carport, dark-framed windows with shutters, and a red-toned roof"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:04.47Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30002359_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/c9f14bb972437f2a98c1791cf665d063.webp"
"MediaSize" => 157291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-c9f14bb972437f2a98c1791cf665d063.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:05.84Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30002359_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/a21c56eeb326792bd23f875f8e8a1fc2.webp"
"MediaSize" => 106248
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-a21c56eeb326792bd23f875f8e8a1fc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Covered front porch featuring brick facade, white siding, decorative white pillars, and a black entry door with leaded glass"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:05.03Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30002359_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/ead0407acc139e0c7529ed1bae94b9d1.webp"
"MediaSize" => 70236
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-ead0407acc139e0c7529ed1bae94b9d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light wood-finish flooring throughout the space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:04.47Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30002359_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/c3591b7337e52a8d2a75c37189231ee5.webp"
"MediaSize" => 85697
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-c3591b7337e52a8d2a75c37189231ee5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:05.83Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30002359_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/b9ee181439db5b2318a5598e86b410f9.webp"
"MediaSize" => 82620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-b9ee181439db5b2318a5598e86b410f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:04.99Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30002359_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/d3132bd422e79511110e7c62d8b3b2fd.webp"
"MediaSize" => 74177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-d3132bd422e79511110e7c62d8b3b2fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring light wood-finish flooring, recessed ceiling lighting, and a modern fireplace with a black slatted accent wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:04.99Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30002359_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/7a7ba82db8f141f0c3440e05e9fcb6c5.webp"
"MediaSize" => 72822
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-7a7ba82db8f141f0c3440e05e9fcb6c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring light wood-finish flooring, white walls, and a contemporary ceiling light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:04.99Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30002359_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/ac5a0babd80f747eada4708f7834ef50.webp"
"MediaSize" => 54612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-ac5a0babd80f747eada4708f7834ef50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept kitchen and dining area featuring light wood-finish flooring, a kitchen with white cabinetry and stainless steel appliances, a white tile backsplash, and a dining space with a prominent b"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:05.1Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30002359_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/219cfd1b198a9733f1485aa7d199d6d3.webp"
"MediaSize" => 56947
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-219cfd1b198a9733f1485aa7d199d6d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white cabinetry, stainless steel appliances, a tile backsplash, and light wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:06.08Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30002359_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/aa5ece5d007a11b756489ffb3f383ef3.webp"
"MediaSize" => 59459
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-aa5ece5d007a11b756489ffb3f383ef3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring white cabinetry with black hardware, white countertops, and a white subway tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:04.47Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30002359_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/854b515948dc14c890d73038cd6362ad.webp"
"MediaSize" => 57976
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-854b515948dc14c890d73038cd6362ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white cabinetry, stainless steel appliances, light wood-finish flooring, white countertops, and a subway tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:05.83Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30002359_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/2be50b9d0b239dd8a9506bb6c5dfb290.webp"
"MediaSize" => 56927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-2be50b9d0b239dd8a9506bb6c5dfb290.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light wood-finish flooring complements the bright interior paint"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:05Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30002359_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/36128779445ac24100a3f7275b08500c.webp"
"MediaSize" => 46158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-36128779445ac24100a3f7275b08500c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright hallway featuring light wood-finish flooring and white baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:05.84Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30002359_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/4e1972cc38d7c245b9f1b2eb593d2807.webp"
"MediaSize" => 46147
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-4e1972cc38d7c245b9f1b2eb593d2807.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright room featuring light wood-finish flooring, white baseboards, and a contemporary flush-mount ceiling light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:05.83Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30002359_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/52a6b1c084c2b1dad7723ee59414b1f5.webp"
"MediaSize" => 38853
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-52a6b1c084c2b1dad7723ee59414b1f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Interior room featuring light wood-finish flooring, white walls, and a single window with white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:06.99Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30002359_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/a6752e16216c3392489427bbf1d01f69.webp"
"MediaSize" => 60794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-a6752e16216c3392489427bbf1d01f69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright interior room featuring a window overlooking greenery, light-toned wood-finish flooring, and a flush mount ceiling light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:06.96Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30002359_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/da4c2daaf8d93091ca037a90961a9873.webp"
"MediaSize" => 54559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-da4c2daaf8d93091ca037a90961a9873.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright room featuring light wood-finish flooring, white walls, and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:06.95Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30002359_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/565b16a56419e064967666da9cab2472.webp"
"MediaSize" => 61897
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-565b16a56419e064967666da9cab2472.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright interior space featuring light wood-finish flooring, white walls, and a window with outdoor scenery"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:06.95Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30002359_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/e52783bd2f95087033093417bbaede05.webp"
"MediaSize" => 48340
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-e52783bd2f95087033093417bbaede05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright interior featuring light wood-finish flooring and white walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:08.66Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30002359_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/c627000ff89a5171ad8cfc6140a8f1ac.webp"
"MediaSize" => 46972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-c627000ff89a5171ad8cfc6140a8f1ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary bathroom featuring a white vanity with an integrated sink, polished chrome faucet, and expansive wall-mounted mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:10.41Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30002359_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/e6c659a4e0b926b2a0e29dcfada16f12.webp"
"MediaSize" => 22243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-e6c659a4e0b926b2a0e29dcfada16f12.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white bathtub with a built-in shower niche, marble-look tile surround, a window with privacy blinds, and light-toned tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:07Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30002359_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/b5f48d3407bc4c79d67b77324dbf1d4d.webp"
"MediaSize" => 56334
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-b5f48d3407bc4c79d67b77324dbf1d4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:06.95Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30002359_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/e1ba9f245abdc38e4e9b517e941b776a.webp"
"MediaSize" => 53306
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-e1ba9f245abdc38e4e9b517e941b776a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:07.01Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30002359_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/810707e7f45c9eef47a16df1ed0c2317.webp"
"MediaSize" => 58023
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-810707e7f45c9eef47a16df1ed0c2317.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:06.81Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30002359_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/4296b49544139cd1aac0fd220ba0d17c.webp"
"MediaSize" => 67969
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-4296b49544139cd1aac0fd220ba0d17c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:05.55Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30002359_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/58e448e21268eb40514ce0197f17b861.webp"
"MediaSize" => 59255
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-58e448e21268eb40514ce0197f17b861.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary bathroom featuring a spacious shower with black-framed glass enclosure, white marble-patterned tile, and two inset shelves"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
"ResourceRecordKey" => "30002359"
"ModificationTimestamp" => "2026-07-07T22:01:06.82Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30002359_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002359/de850ea552282724f8770c612e812e6a.webp"
"MediaSize" => 68626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002359/thumbnail-de850ea552282724f8770c612e812e6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry area featuring wood-finish flooring and a drop ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846189"
…2
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30002359')"
+"ID": 1602740
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25296
+post_id: "1602482"
+post_author: 1
+"ListingKey": "30002749"
+"ListingId": "40846121"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T23:10:10Z"
+"RFModificationTimestamp": "2026-07-08T01:00:12Z"
+"ListPrice": 600000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1333.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K1K9"
+"UnparsedAddress": "164 BRIDGE Street W, Waterloo, Ontario N2K1K9"
+"Coordinates": array:2 [
0 => -80.4907289
1 => 43.487282
]
+"Latitude": 43.487282
+"Longitude": -80.4907289
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this impeccably maintained bungalow on an impressive 70' x 140' lot in one of Waterloo's most sought after neighbourhoods. Offering exceptional space, timeless character and an unbeatable location, this home is just minutes from Waterloo Park, Bechtel Park, RIM Park, the Grand River trail system, Conestoga Mall, excellent schools, shopping and every amenity you could need. A spacious covered front porch welcomes you and is the perfect place to enjoy your morning coffee. Inside, this carpet free home features beautiful hardwood flooring throughout the main level, three bedrooms, two full bathrooms and a layout that offers both functionality and flexibility. The third bedroom could easily serve as a formal dining room, home office or guest bedroom. The heart of the home is the charming kitchen, showcasing beautiful tilework, stunning brick archways, a built in dining nook and a spacious walk in pantry. The adjoining living room is filled with warmth and personality, featuring exposed wood beams and beautiful brick accents that create a truly inviting space. The spacious lower level also offers an incredible workshop, abundant storage, a full bathroom and the potential for an additional bedroom or in law living space with the convenience of the separate side entrance. Outside, the expansive backyard features a large concrete patio with a covered awning, making it the perfect place to entertain or unwind. The oversized tandem three car garage offers exceptional space for vehicles, hobbies, tools and storage plus offers 40 amp service for your use. Lovingly maintained and thoughtfully updated with hardwood flooring throughout the main floor, California shutters, central air conditioning (2021), roof (2013) and newer washer and dryer, this home reflects true pride of ownership. Filled with warmth, character and endless possibilities, this is a rare opportunity to own a truly special home in one of Waterloo's most desirable locations. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:4 [
0 => "High Traffic Area"
1 => "School Bus"
2 => "Community Centre"
3 => "Industrial Park"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-08T01:00:10.124428+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1902312"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T22:59:00Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T22:59:00Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "BRIDGE"
+"StreetNumber": "164"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "4970.51"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/164-Bridge-St-W"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30002749/164-bridge-street-w-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 72.0
+"AboveGradeFinishedArea": 1333
+"OriginalEntryTimestamp": "2026-07-07T22:59:00.43Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1218041"
+"ListOfficeNationalAssociationId": "1473831"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30002749')"
+"ID": "1602482"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25293
+post_id: "1602484"
+post_author: 1
+"ListingKey": "30002447"
+"ListingId": "40846018"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-08T00:55:20Z"
+"RFModificationTimestamp": "2026-07-08T01:00:11Z"
+"ListPrice": 999900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0.415
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2H4V4"
+"UnparsedAddress": "351-355 LANCASTER Street W, Kitchener, Ontario N2H4V4"
+"Coordinates": array:2 [
0 => -80.4845853
1 => 43.4701705
]
+"Latitude": 43.4701705
+"Longitude": -80.4845853
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover an exceptional ±0.415-acre redevelopment opportunity in Kitchener, ideally suited for medium-density residential development. Preliminary development concepts indicate the potential for up to 14 stacked townhomes, making this a strong investment opportunity. Positioned on the highly visible Lancaster Street W and located less than 500 metres from Highway 7, the property offers excellent accessibility and regional connectivity. The site is currently improved with three fully serviced commercial buildings totaling approximately ±4,662 sq. ft. Surrounded by established neighbourhood amenities - including schools, parks, sports facilities, grocery stores, and restaurants - this property is well-positioned for future residential or mixed-use redevelopment. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2026-07-08T01:00:06.435003+00:00"
+"Directions": "Union Street to Lancaster Street W"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2000528"
+"ListOfficeKey": "291992"
+"LotFeatures": array:1 [
0 => "Visual exposure"
]
+"LotSizeDimensions": "0.415"
+"PhotosChangeTimestamp": "2026-07-07T22:18:30Z"
+"PhotosCount": 9
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-08T00:48:20Z"
+"StreetDirSuffix": "West"
+"StreetName": "LANCASTER"
+"StreetNumber": "351"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "8971.44"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30002447/351-355-lancaster-street-w-kitchener"
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "MIX-1"
+"FrontageLengthNumeric": 101.0
+"OriginalEntryTimestamp": "2026-07-07T22:18:30.36Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1283131"
+"ListOfficeNationalAssociationId": "1407252"
+"Media": array:9 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30002447')"
+"ID": "1602484"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25297
+post_id: "1601502"
+post_author: 1
+"ListingKey": "30002042"
+"ListingId": "40846006"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T21:35:16Z"
+"RFModificationTimestamp": "2026-07-07T22:43:56Z"
+"ListPrice": 200000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 930.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4H4"
+"UnparsedAddress": "225 HARVARD Place Unit# 310, Waterloo, Ontario N2J4H4"
+"Coordinates": array:2 [
0 => -80.504985
1 => 43.4838146
]
+"Latitude": 43.4838146
+"Longitude": -80.504985
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Bluevale Tower, where comfort, convenience and lifestyle come together in this spacious freshly painted 2-bedroom, 2-bathroom condo. This bright unit features a wonderful walk-out patio, offering a peaceful outdoor setting to enjoy. Located in Waterloo’s desirable Glenridge neighborhood, this home is just minutes from universities and the expressway, with public transit, shopping only steps from the building - making it an excellent option for seniors, first-time buyers, investors or those looking to downsize. This spacious unit offers a large living room and separate dining area and large windows that span the length and view of the greenery. The primary bedroom offers walkthrough closets leading to a 2 piece ensuite and there is an additional bedroom and 4-piece bath. Included with the unit is one underground parking spot, use of a tennis court, gym, workshop, party room, and library. The added bonus is heat, hydro and water are all included in your condo fees. This is an exceptional opportunity to enjoy spacious, low-maintenance living in one of Waterloo’s most established and convenient communities. (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Stove"
2 => "Microwave"
3 => "Window Coverings"
]
+"AssociationFee": "1041.16"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Landscaping"
1 => "Heat"
2 => "Electricity"
3 => "Water"
4 => "Insurance"
5 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-07T22:43:48.037024+00:00"
+"Directions": "Bluevale St N to the end of Harvard Pl"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Baseboard heaters"
1 => "Radiant heat"
2 => "Boiler"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1893344"
+"ListOfficeKey": "156357"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Southern exposure"
2 => "Balcony"
3 => "Laundry- Coin operated"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Covered"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-07T21:30:07Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T21:30:07Z"
+"Stories": "1.0"
+"StreetName": "HARVARD"
+"StreetNumber": "225"
+"StreetSuffix": "Place"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "2102.91"
+"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/30002042/225-harvard-place-unit-310-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Exercise Centre"
]
+"ZoningDescription": "RMU-40"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 930
+"OriginalEntryTimestamp": "2026-07-07T21:30:07.46Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1212827"
+"ListOfficeNationalAssociationId": "1003908"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30002042')"
+"ID": "1601502"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25295
+post_id: "1600977"
+post_author: 1
+"ListingKey": "29997819"
+"ListingId": "X13530684"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T12:20:13Z"
+"RFModificationTimestamp": "2026-07-07T19:50:13Z"
+"ListPrice": 630000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2K1S2"
+"UnparsedAddress": "69 WOOLWICH STREET, Kitchener, Ontario N2K1S2"
+"Coordinates": array:2 [
0 => -80.484615
1 => 43.484712
]
+"Latitude": 43.484712
+"Longitude": -80.484615
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 69 Woolwich Street, Kitchener-a beautifully maintained 3-bedroom, 3-bathroom townhouse that's perfect for first-time buyers, young families, or anyone looking for a move-in-ready home. This FREEHOLD (NO FEES) townhouse features tasteful updates throughout. Comfortable living spaces, a well-appointed kitchen, and spacious bedrooms designed for everyday living.Step outside to enjoy your own private backyard, ideal for relaxing, entertaining, or gardening, while the attached garage provides added convenience and storage.Located in a desirable neighbourhood too. You'll enjoy easy access to Highway 85 and Highway 7/8, making commuting throughout Waterloo Region simple. You're just minutes from shopping, restaurants, schools, parks, walking trails, public transit, the region's thriving tech hub and Grand River! Uptown Waterloo, Downtown Kitchener, and both universities are also within easy reach.Whether you're looking to enter the market or finally move into a house, this home offers the perfect blend of comfort, convenience, and value. Don't miss your opportunity to call 69 Woolwich Street home! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener remote(s)"
7 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T19:49:59.596853+00:00"
+"Directions": "Cross Streets: Bridge St W and Woolwich. ** Directions: Take Bridge St. One block West of Grand River."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1993499"
+"ListOfficeKey": "290358"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "24.3 x 121.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T12:09:02Z"
+"PhotosCount": 39
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T12:09:02Z"
+"Stories": "2.0"
+"StreetName": "Woolwich"
+"StreetNumber": "69"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3948"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29997819/69-woolwich-street-kitchener"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 24.3
+"OriginalEntryTimestamp": "2026-07-07T12:09:02.44Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1276617"
+"ListOfficeNationalAssociationId": "1386142"
+"Media": array:39 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29997819')"
+"ID": "1600977"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25290
+post_id: "1599845"
+post_author: 1
+"ListingKey": "29998331"
+"ListingId": "X13531056"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T14:25:15Z"
+"RFModificationTimestamp": "2026-07-07T17:48:11Z"
+"ListPrice": 1020000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2J9"
+"UnparsedAddress": "359 LEXINGTON ROAD, Waterloo, Ontario N2K2J9"
+"Coordinates": array:2 [
0 => -80.503252
1 => 43.498882
]
+"Latitude": 43.498882
+"Longitude": -80.503252
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to the home that makes every day feel like a vacation. This meticulously maintained 2-storey family home offers beautifully finished living space across three levels, combining timeless character, thoughtful updates, and an incredible backyard retreat that will have you rethinking summer getaways. The spacious kitchen features an oversized island with seating, abundant cabinetry, and generous prep space that is perfect for hosting family gatherings, holiday celebrations. Large windows throughout fill the home with natural light, creating warm and inviting spaces. With 4 bedrooms and 4 bathrooms, there is room for the entire family to spread out. The recently renovated main bathroom offers a spa-like experience with a luxurious deep soaker tub and skylight to let in the sunshine. The fully finished basement provides exceptional flexibility with additional living space and recreation areas ideal for teens, guests, multi-generational living, or work from home. Step outside and discover what truly sets this property apart. The private backyard oasis features a luxurious heated in ground fiberglass pool surrounded by expansive patio space and mature landscaping. Whether you're entertaining guests, enjoying family time, or simply unwinding after work, this outdoor retreat delivers resort-style living right at home. Additional highlights include a durable steel roof, recently upgraded gas fireplace, double-car garage, parking for six vehicles, abundant storage throughout, and pride of ownership evident in every corner of the property. Every update has been thoughtfully completed, creating a home that is move-in ready and designed to be enjoyed for years to come. Located close to schools, parks, shopping, and everyday amenities, this is more than a home-it's a lifestyle. Don't miss your opportunity to own this exceptional family home, where unforgettable summers, effortless entertaining, and everyday comfort come together in one remarkable property. (id:62650)"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T17:48:05.120236+00:00"
+"Directions": "Lexington Rd/Bridge St W"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1474342"
+"ListOfficeKey": "299885"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "65.6 x 148.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T14:10:48Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T14:10:47Z"
+"Stories": "2.0"
+"StreetName": "Lexington"
+"StreetNumber": "359"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6473.8"
+"VirtualTourURLUnbranded": "https://estate-shutter-portal.aryeo.com/videos/019e8357-4852-731f-b030-a69f8bc38f7c?v=301"
+"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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29998331/359-lexington-road-waterloo"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2185334"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299885"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 65.7
+"OriginalEntryTimestamp": "2026-07-07T14:10:47.92Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1129773"
+"ListOfficeNationalAssociationId": "1478640"
+"CoListAgentNationalAssociationId": "1435541"
+"CoListOfficeNationalAssociationId": "1478640"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29998331')"
+"ID": "1599845"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23462
+post_id: "1599273"
+post_author: 1
+"ListingKey": "29998457"
+"ListingId": "X13531516"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T15:40:12Z"
+"RFModificationTimestamp": "2026-07-07T15:45:04Z"
+"ListPrice": 744900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2K3V8"
+"UnparsedAddress": "47 MARISA STREET, Kitchener, Ontario N2K3V8"
+"Coordinates": array:2 [
0 => -80.4681
1 => 43.477335
]
+"Latitude": 43.477335
+"Longitude": -80.4681
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome to 47 Marisa St, nestled in a quiet, family-oriented neighbourhood of K/W, steps from a nearby park with a playground and scenic walking trails along the Grand River. Thoughtfully updated throughout, this two-storey home features a functional layout that perfectly blends style, flexibility, and everyday comfort. Offering over 2,000 sq. ft. of living space, this home boasts a newer modern eat-in kitchen featuring quartz countertops and a stylish backsplash. The unique yet highly functional L-shaped combined living/dining room offers a warm and welcoming atmosphere, highlighted by a cozy gas fireplace and overlooking the deck and large yard, creating the perfect setting for both everyday living and entertaining. Enjoy peace of mind as your children play in the spacious, private, fully fenced backyard. The elegant curved staircase leads to 3 spacious bedrooms and a bright 4-pc main bath, accented by a skylight, adding brightness and an open feel to the space. A true highlight of the home is the large primary bedroom, featuring a private 4-pc ensuite bath, 3 closets (a rare and highly desirable feature) and an abundance of windows that fill the space with natural light, creating an inviting retreat. Completing the home is the finished lower level, offering a spacious Rec room great for entertaining or relaxing, a rough-in for a future 3-piece bath, and ample storage space. Enjoy peace of mind knowing that the majority of upgrades have been recently completed. New shingles '22, furnace '24, air conditioning '21, skylight '25, sliding door and duct cleaning in the last 2-4 yrs. Upgraded kitchen cabinets, quartz countertops, backsplash, bathrooms and laminate flooring throughout all 3 levels. The entire home was just freshly painted and it's in move-in ready condition. Amazing location for commuters, Guelph & Cambridge are just 15-20 minutes away, and easy connections to Uptown Waterloo, UW, Wilfried Laurier University, Downtown Kitchener and Highway 401. (id:66098)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T15:14:54.696326+00:00"
+"Directions": "Bridge St E"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Tile"
1 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1562711"
+"ListOfficeKey": "85454"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "28.3 x 147.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T15:30:47Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T15:30:47Z"
+"Stories": "2.0"
+"StreetName": "Marisa"
+"StreetNumber": "47"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4527.32"
+"VirtualTourURLUnbranded": "https://youriguide.com/47_marisa_st_kitchener_on/"
+"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": "OnePoint"
+"TaxYear": 2026
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29998457/47-marisa-street-kitchener"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 28.3
+"OriginalEntryTimestamp": "2026-07-07T14:31:05.76Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1148656"
+"ListOfficeNationalAssociationId": "1187906"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29998457')"
+"ID": "1599273"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25298
+post_id: "1599298"
+post_author: 1
+"ListingKey": "29998049"
+"ListingId": "40845867"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T14:05:12Z"
+"RFModificationTimestamp": "2026-07-07T14:11:25Z"
+"ListPrice": 744900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2037.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2K3V8"
+"UnparsedAddress": "47 MARISA Street, Kitchener, Ontario N2K3V8"
+"Coordinates": array:2 [
0 => -80.4680933
1 => 43.4774197
]
+"Latitude": 43.4774197
+"Longitude": -80.4680933
+"YearBuilt": 1995
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 47 Marisa St, nestled in a quiet, family-oriented neighbourhood of K/W, steps from a nearby park with a playground and scenic walking trails along the Grand River. Thoughtfully updated throughout, this two-storey home features a functional layout that perfectly blends style, flexibility, and everyday comfort. Offering over 2,000 sq. ft. of living space, this home boasts a newer modern eat-in kitchen featuring quartz countertops and a stylish backsplash. The unique yet highly functional L-shaped combined living/dining room offers a warm and welcoming atmosphere, highlighted by a cozy gas fireplace and overlooking the deck and large yard, creating the perfect setting for both everyday living and entertaining. Enjoy peace of mind as your children play in the spacious, private, fully fenced backyard. The elegant curved staircase leads to 3 spacious bedrooms and a bright 4-pc main bath, accented by a skylight, adding brightness and an open feel to the space. A true highlight of the home is the large primary bedroom, featuring a private 4-pc ensuite bath, 3 closets (a rare and highly desirable feature) and an abundance of windows that fill the space with natural light, creating an inviting retreat. Completing the home is the finished lower level, offering a spacious Rec room great for entertaining or relaxing, a rough-in for a future 3-piece bath, and ample storage space. Enjoy peace of mind knowing that the majority of upgrades have been recently completed. New shingles '22, furnace '24, air conditioning '21, skylight '25, sliding door and duct cleaning in the last 2-4 yrs. Upgraded kitchen cabinets, quartz countertops, backsplash, bathrooms and laminate flooring throughout all 3 levels. The entire home was just freshly painted and it's in move-in ready condition. Amazing location for commuters, Guelph & Cambridge are just 15-20 minutes away, and easy connections to Uptown Waterloo, UW, Wilfried Laurier University, Downtown Kitchener and Highway 401. (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T14:11:15.622267+00:00"
+"Directions": "Bridge St and Stanley Ave"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1562711"
+"ListOfficeKey": "299731"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T13:18:18Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T13:59:17Z"
+"Stories": "2.0"
+"StreetName": "MARISA"
+"StreetNumber": "47"
+"StreetSuffix": "Street"
+"SubdivisionName": "122 - Bridgeport"
+"TaxAnnualAmount": "4527.32"
+"VirtualTourURLUnbranded": "https://youriguide.com/47_marisa_st_kitchener_on/"
+"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/29998049/47-marisa-street-kitchener"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1478
+"BelowGradeFinishedArea": 559
+"OriginalEntryTimestamp": "2026-07-07T13:18:18.67Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1148656"
+"ListOfficeNationalAssociationId": "1476052"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29998049')"
+"ID": "1599298"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25299
+post_id: "1597687"
+post_author: 1
+"ListingKey": "29995638"
+"ListingId": "40845441"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T13:35:15Z"
+"RFModificationTimestamp": "2026-07-07T13:38:53Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2579.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3C4"
+"UnparsedAddress": "277 CANTERBURY Drive, Waterloo, Ontario N2K3C4"
+"Coordinates": array:2 [
0 => -80.4982573
1 => 43.4962158
]
+"Latitude": 43.4962158
+"Longitude": -80.4982573
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully updated 3+1 bedroom, 3-bathroom home in a mature, family-friendly neighbourhood.... Thoughtfully designed for everyday living, this move-in-ready home features an updated kitchen with modern finishes, a bright dining room, and a warm, inviting family room with a gas fireplace..... The finished basement offers additional living space with a fourth bedroom and a spacious recreation room, perfect for guests, a home office, or a growing family..... Step outside to a covered deck overlooking the fully fenced backyard—ideal for entertaining, summer BBQs, or relaxing with family and friends. A powered shed provides the perfect space for a workshop, hobbies, or extra storage..... The exposed aggregate driveway adds outstanding curb appeal, while the exceptional location puts you just minutes from top-rated schools, parks, scenic walking trails, shopping, and convenient highway access for commuters..... This is the perfect place to call home—offering comfort, space, and an unbeatable location in one of the area's most established neighbourhoods. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-06T23:19:37.831141+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1890330"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T20:18:37Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T13:29:05Z"
+"Stories": "2.0"
+"StreetName": "CANTERBURY"
+"StreetNumber": "277"
+"StreetSuffix": "Drive"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "4841.04"
+"VirtualTourURLUnbranded": "https://youriguide.com/277_canterbury_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29995638/277-canterbury-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1962973"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "259258"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1756
+"BelowGradeFinishedArea": 823
+"OriginalEntryTimestamp": "2026-07-06T20:18:37.15Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1211160"
+"ListOfficeNationalAssociationId": "1324759"
+"CoListAgentNationalAssociationId": "1252469"
+"CoListOfficeNationalAssociationId": "1217708"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29995638')"
+"ID": "1597687"
}
]
+success: true
+page_size: 9
+page_count: 11
+count: 94
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
]