array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29152151/Property?$select=ALL&$top=20&$filter=ListingKey eq 29152151&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29152151/Property?$select=ALL&$top=20&$filter=ListingKey eq 29152151&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23308
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23310
+post_id: "455536"
+post_author: 1
+"ListingKey": "29152151"
+"ListingId": "40791635"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-01T20:26:00Z"
+"RFModificationTimestamp": "2025-12-01T21:07:07Z"
+"ListPrice": 649999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1575.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2A5"
+"UnparsedAddress": "510B ROSEMEADOW Crescent, Waterloo, Ontario N2T2A5"
+"Coordinates": array:2 [
0 => -80.5552223
1 => 43.4445519
]
+"Latitude": 43.4445519
+"Longitude": -80.5552223
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Move-in ready 3 bed, 2.5 bath home in the desirable Westvale neighborhood of Waterloo — a perfect home for a young family! Located on a quiet crescent steps to Westvale Park, Red River Park, Holy Rosary + Westvale PS. Convenient for those family bike rides and dog walks! Inside enjoy a bright main floor with powder room, kitchen (new countertops) opening to the dining/living area with sliders to your fully fenced backyard — complete with deck + gazebo for family BBQs. Upstairs features a spacious primary bedroom with 2 additional bedrooms. Bonus finished basement living space with a brand new 3pc bathroom. Major updates: Roof 2020, Garage door 2019, Furnace + AC 2017. Parking for 2 plus single car garage. A fantastic chance to own a home in one of Waterloo’s best family areas — book your showing today! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-01T21:07:01.409331+00:00"
+"Directions": "Fischer Hallman to Thorndale to Rosemeadow"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2024597"
+"ListOfficeKey": "283168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Gazebo"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-01T20:18:43Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-01T20:18:43Z"
+"Stories": "2.0"
+"StreetName": "ROSEMEADOW"
+"StreetNumber": "510"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "3468.44"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1543292528"
"RoomType" => "3pc Bathroom"
"ListingId" => "40791635"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29152151"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:43.77Z"
]
1 => array:11 [
"RoomKey" => "1543292529"
"RoomType" => "Recreation room"
"ListingId" => "40791635"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29152151"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 20'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:43.77Z"
]
2 => array:11 [
"RoomKey" => "1543292530"
"RoomType" => "Bonus Room"
"ListingId" => "40791635"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29152151"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:43.78Z"
]
3 => array:11 [
"RoomKey" => "1543292531"
"RoomType" => "Bedroom"
"ListingId" => "40791635"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29152151"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:43.78Z"
]
4 => array:11 [
"RoomKey" => "1543292532"
"RoomType" => "4pc Bathroom"
"ListingId" => "40791635"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29152151"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:43.78Z"
]
5 => array:11 [
"RoomKey" => "1543292533"
"RoomType" => "Bedroom"
"ListingId" => "40791635"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29152151"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:43.78Z"
]
6 => array:11 [
"RoomKey" => "1543292534"
"RoomType" => "Primary Bedroom"
"ListingId" => "40791635"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29152151"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:43.78Z"
]
7 => array:11 [
"RoomKey" => "1543292535"
"RoomType" => "2pc Bathroom"
"ListingId" => "40791635"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29152151"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:43.78Z"
]
8 => array:11 [
"RoomKey" => "1543292536"
"RoomType" => "Kitchen"
"ListingId" => "40791635"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29152151"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:43.78Z"
]
9 => array:11 [
"RoomKey" => "1543292537"
"RoomType" => "Dining room"
"ListingId" => "40791635"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29152151"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:43.78Z"
]
10 => array:11 [
"RoomKey" => "1543292538"
"RoomType" => "Living room"
"ListingId" => "40791635"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29152151"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 12'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-01T20:18:43.78Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29152151/510b-rosemeadow-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2008932"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283168"
+"GeocodeManualYN": true
+"ZoningDescription": "r4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1225
+"BelowGradeFinishedArea": 350
+"OriginalEntryTimestamp": "2025-12-01T20:18:43.65Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"Media": array:26 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6350367644"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/5a3592f23ab562fa4c076bb802f61c95.webp"
"MediaSize" => 67392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-5a3592f23ab562fa4c076bb802f61c95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6350367709"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/3a5be4b8795fe8c6b6997cb5530bf684.webp"
"MediaSize" => 141780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-3a5be4b8795fe8c6b6997cb5530bf684.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6350367746"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/10668f26eee091d4000db84fa5874f79.webp"
"MediaSize" => 54390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-10668f26eee091d4000db84fa5874f79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6350367758"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/9cd5b5791a6177770fcb4036336b264f.webp"
"MediaSize" => 56749
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-9cd5b5791a6177770fcb4036336b264f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6350367833"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/9b58f50f0c3b0d56ff009b9d1954f770.webp"
"MediaSize" => 63169
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-9b58f50f0c3b0d56ff009b9d1954f770.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6350367915"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/055c4d9dc699bb794a99b9e7ca696a67.webp"
"MediaSize" => 135726
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-055c4d9dc699bb794a99b9e7ca696a67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6350367959"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/85ffa8406d9d39f2f25d22d8f737c1ce.webp"
"MediaSize" => 64453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-85ffa8406d9d39f2f25d22d8f737c1ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6350368013"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/3fc8d153795ae15cdf6192933a22f8d0.webp"
"MediaSize" => 77913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-3fc8d153795ae15cdf6192933a22f8d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6350368100"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/9fe726910082bbc461ce411be1d0cca9.webp"
"MediaSize" => 73314
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-9fe726910082bbc461ce411be1d0cca9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6350368172"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/5bbb3b1a6f94e7f72a1e2a29b165b39b.webp"
"MediaSize" => 66991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-5bbb3b1a6f94e7f72a1e2a29b165b39b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6350368280"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/4f01487ef95dcb8a714dfbe311848061.webp"
"MediaSize" => 95570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-4f01487ef95dcb8a714dfbe311848061.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6350368365"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/921220b8852d917a33605831fd3d0188.webp"
"MediaSize" => 69638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-921220b8852d917a33605831fd3d0188.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6350368443"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/a2773eab95364d00672c85d9be81cce4.webp"
"MediaSize" => 67370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-a2773eab95364d00672c85d9be81cce4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6350368476"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/67121fc4e8a58177e2b2518fcbd67675.webp"
"MediaSize" => 108821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-67121fc4e8a58177e2b2518fcbd67675.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6350368535"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/39c3ed3442d88918431803b66fcb7a32.webp"
"MediaSize" => 132565
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-39c3ed3442d88918431803b66fcb7a32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6350368585"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/d5eb67bec5e8a5f1942cbd550fa087e9.webp"
"MediaSize" => 68231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-d5eb67bec5e8a5f1942cbd550fa087e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6350368639"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/23fb628a39f3769312ed348b1516e102.webp"
"MediaSize" => 73007
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-23fb628a39f3769312ed348b1516e102.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6350368673"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/ed061983abece2e564a8dd55c70004c7.webp"
"MediaSize" => 58334
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-ed061983abece2e564a8dd55c70004c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6350368727"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/d53eeb248a4a48b33ecb7c02d843e7ba.webp"
"MediaSize" => 88042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-d53eeb248a4a48b33ecb7c02d843e7ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6350368755"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/d9442e66fed935de92278ca3b25a33c2.webp"
"MediaSize" => 86540
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-d9442e66fed935de92278ca3b25a33c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6350368787"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/88be7e7b6d53d94e57c47536a45b6892.webp"
"MediaSize" => 144452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-88be7e7b6d53d94e57c47536a45b6892.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6350368807"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/b6fd0fc1d20b8befd559e6316f7dc22b.webp"
"MediaSize" => 144226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-b6fd0fc1d20b8befd559e6316f7dc22b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6350368843"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/b65990dea3dcd36ceb59ae6d3bb1689f.webp"
"MediaSize" => 75336
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-b65990dea3dcd36ceb59ae6d3bb1689f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6350368862"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/c03bf83706357ec1a6a3ca5c1222c42f.webp"
"MediaSize" => 134599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-c03bf83706357ec1a6a3ca5c1222c42f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6350368881"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/62adbc9ca51014589f562f10b988bf99.webp"
"MediaSize" => 59384
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-62adbc9ca51014589f562f10b988bf99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6350368889"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29152151/09c55478f8d6e7e14022b5b0408c9850.webp"
"MediaSize" => 62173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29152151/thumbnail-09c55478f8d6e7e14022b5b0408c9850.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791635"
"ResourceRecordKey" => "29152151"
"ModificationTimestamp" => "2025-12-01T20:18:43.65Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29152151')"
+"ID": "455536"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 283168/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283168&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283168/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283168&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25117
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25119
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Flux Realty"
+"OfficeEmail": null
+"OfficePhone": "226-336-7668"
+"OfficeMlsId": "KW43"
+"ModificationTimestamp": "2025-11-14T22:09:17Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "283168"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "196 Victoria St. S.,"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Kitchener"
+"OfficePostalCode": "N2G2B"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1325206"
+"OriginalEntryTimestamp": "2018-03-12T13:41:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "434078"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "283168"
"SocialMediaUrlOrId" => "http://www.fluxrealty.ca/"
"ModificationTimestamp" => "2025-11-14T18:28:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1224121"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('283168')"
+"Media": []
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2024597/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2024597&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2024597/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2024597&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25122
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29152151" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24743
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29152151/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29152151&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29152151/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29152151&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24723
+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 29152151 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5552223 43.4445519)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29152151 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5552223 43.4445519)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29152151 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5552223 43.4445519)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29152151 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5552223 43.4445519)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24997
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24604
+post_id: "449812"
+post_author: 1
+"ListingKey": "29144137"
+"ListingId": "40790569"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T23:06:06Z"
+"RFModificationTimestamp": "2025-11-28T01:19:12Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 875.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2M5B5"
+"UnparsedAddress": "423 WESTWOOD Drive Unit# 24, Kitchener, Ontario N2M5B5"
+"Coordinates": array:2 [
0 => -80.5409639
1 => 43.4426102
]
+"Latitude": 43.4426102
+"Longitude": -80.5409639
+"YearBuilt": 1973
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "TWO BEDROOM TOWNHOME in the established Westwood Estates community. Main floor with convenient Kitchen at the front includes Fridge, Stove & Microwave, Quartz countertop & subway tile Backsplash. Spacious Dining and Living Room at the back. The Main floor is carpet-free with a mix of ceramic and maple hardwood floors. Upstairs, 2 large bedrooms upstairs with a 4 piece bath complete with updated cabinet and quartz countertop. Unfinshed Basement rec Room area and Laundry. New Front Door has been ordered! A/C was recently installed! Private fenced backyard with gate that leads to the community in-ground swimming pool and playground. Located at the corner of Glasgow and Fischer Hallman, at the edge of Waterloo and conveniently located to schools, shopping and transit. This home is ready and available to move into immediately. Sorry, no dogs. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFeeIncludes": array:1 [
0 => "Landscaping"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-28T01:19:01.334567+00:00"
+"Directions": "First Townhome complex at the intersection of Glasgow & Westwood"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1967416"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2025-11-27T23:00:11Z"
+"PhotosCount": 26
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T23:00:11Z"
+"Stories": "2.0"
+"StreetName": "WESTWOOD"
+"StreetNumber": "423"
+"StreetSuffix": "Drive"
+"SubdivisionName": "323 - Victoria Hills"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"View": "City view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1541122810"
"RoomType" => "Recreation room"
"ListingId" => "40790569"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29144137"
"RoomLength" => null
"RoomDimensions" => "14'3'' x 29'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T23:00:11.44Z"
]
1 => array:11 [
"RoomKey" => "1541122811"
"RoomType" => "4pc Bathroom"
"ListingId" => "40790569"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29144137"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T23:00:11.44Z"
]
2 => array:11 [
"RoomKey" => "1541122812"
"RoomType" => "Bedroom"
"ListingId" => "40790569"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29144137"
"RoomLength" => null
"RoomDimensions" => "14'3'' x 7'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T23:00:11.45Z"
]
3 => array:11 [
"RoomKey" => "1541122813"
"RoomType" => "Primary Bedroom"
"ListingId" => "40790569"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29144137"
"RoomLength" => null
"RoomDimensions" => "14'3'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T23:00:11.45Z"
]
4 => array:11 [
"RoomKey" => "1541122814"
"RoomType" => "Living room"
"ListingId" => "40790569"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29144137"
"RoomLength" => null
"RoomDimensions" => "14'3'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T23:00:11.45Z"
]
5 => array:11 [
"RoomKey" => "1541122815"
"RoomType" => "Dining room"
"ListingId" => "40790569"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29144137"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T23:00:11.45Z"
]
6 => array:11 [
"RoomKey" => "1541122816"
"RoomType" => "Kitchen"
"ListingId" => "40790569"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29144137"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 9'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T23:00:11.45Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29144137/423-westwood-drive-unit-24-kitchener"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2100
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "RES-5"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 875
+"OriginalEntryTimestamp": "2025-11-27T23:00:11.37Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:26 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6343354403"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/ed259616b969ffd1352e1179a86e9f55.webp"
"MediaSize" => 49160
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-ed259616b969ffd1352e1179a86e9f55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinets, tasteful backsplash, light stone counters, and light tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6343354415"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/3436bc5b06b256c873c36170b76caddf.webp"
"MediaSize" => 42777
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-3436bc5b06b256c873c36170b76caddf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white appliances, white cabinets, light tile patterned floors, backsplash, and light stone countertops"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6343354489"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/acf2eeb01abd11b44c3de1e0b453b91c.webp"
"MediaSize" => 45763
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-acf2eeb01abd11b44c3de1e0b453b91c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6343354513"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/ad0854e8fed3729702863a7e59169177.webp"
"MediaSize" => 50653
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-ad0854e8fed3729702863a7e59169177.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room featuring wood-type flooring and baseboards and slider to backyard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6343354541"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/5a53db7ea6d62f790b209ed75651c314.webp"
"MediaSize" => 27616
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-5a53db7ea6d62f790b209ed75651c314.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Door to unfinished Laundry & Rec Room."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6343354620"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/94a8e75cbe4160d160a70051cb927c56.webp"
"MediaSize" => 37016
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-94a8e75cbe4160d160a70051cb927c56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Bedroom with a textured ceiling, carpet flooring, and ceiling fan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6343354628"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/f46ac4e79ff992b26fc9443a8ececca1.webp"
"MediaSize" => 30967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-f46ac4e79ff992b26fc9443a8ececca1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Bedroom featuring light carpet and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6343354717"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/53fcf7f9bf9754ef14e570a1d95c0aab.webp"
"MediaSize" => 38631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-53fcf7f9bf9754ef14e570a1d95c0aab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary bedroom featuring light carpet, a textured ceiling, ceiling fan, and a closet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6343354782"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/fa2ed13b9df2c468714472401a739d63.webp"
"MediaSize" => 33674
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-fa2ed13b9df2c468714472401a739d63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom #2 featuring carpet and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6343354873"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/4bf4eadab3b59005344ff9eba90689d6.webp"
"MediaSize" => 100689
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-4bf4eadab3b59005344ff9eba90689d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Backyard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6343354928"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/94a5bf3b2292b3e62955130e205b09e7.webp"
"MediaSize" => 35114
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-94a5bf3b2292b3e62955130e205b09e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom #2 featuring a textured ceiling, light carpet, and a closet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6343354968"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/9af80e2acdcadd91cc796978244dd5a7.webp"
"MediaSize" => 53722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-9af80e2acdcadd91cc796978244dd5a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bathroom featuring quartz vanity"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6343355028"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/d25a26f8aab00f641fc2febd03bd84e3.webp"
"MediaSize" => 114802
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-d25a26f8aab00f641fc2febd03bd84e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of backyard with play area and inground pool"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6343355040"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/5c9ff511f2074e83a3c75695c82aca7b.webp"
"MediaSize" => 87336
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-5c9ff511f2074e83a3c75695c82aca7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Property entrance featuring a lawn"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6343355074"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/ced2c3ca2731c6b5f39056ac312bdba6.webp"
"MediaSize" => 80782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-ced2c3ca2731c6b5f39056ac312bdba6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Doorway to property with board and batten siding and brick siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6343355125"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/1806a818211441b83abb9e1135b9d766.webp"
"MediaSize" => 41462
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-1806a818211441b83abb9e1135b9d766.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white appliances, under cabinet range hood, white cabinetry, light tile patterned flooring, and backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6343355144"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/a445132f866017cb73ad0d5e2486d2c5.webp"
"MediaSize" => 103909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-a445132f866017cb73ad0d5e2486d2c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Parking Spot #24 is near teh front door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6343355180"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/273ee2f3ff9f23138f7340464972e7b2.webp"
"MediaSize" => 21551
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-273ee2f3ff9f23138f7340464972e7b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring One-piece shower / bath combination"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6343355222"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/b315246a5883e7ad0b61f58e8135a481.webp"
"MediaSize" => 74426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-b315246a5883e7ad0b61f58e8135a481.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of community / neighborhood sign"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6343355258"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/7e8064e593e187b075ed9c60d832a860.webp"
"MediaSize" => 100531
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-7e8064e593e187b075ed9c60d832a860.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front of property with brick siding, a front lawn, and entry steps"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6343355303"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/50eddeabe3a41c0345714a6b3c004358.webp"
"MediaSize" => 48865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-50eddeabe3a41c0345714a6b3c004358.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Doorway with baseboards and tile patterned flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6343355336"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/3154c6cf2a5c0adaf499fea9babfce07.webp"
"MediaSize" => 34530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-3154c6cf2a5c0adaf499fea9babfce07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bar area featuring white cabinetry, black microwave, glass insert cabinets, light tile patterned flooring, and light countertops"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6343355346"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/62726612c1fe4edcc97e931bbe60eba2.webp"
"MediaSize" => 48901
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-62726612c1fe4edcc97e931bbe60eba2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room featuring hardwood / wood-style floors and a textured ceiling and slider to back yard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6343355371"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/238bc58639ae094642eede8c00fda6ca.webp"
"MediaSize" => 43975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-238bc58639ae094642eede8c00fda6ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement washer and dryer and light tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6343355383"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/64b525b35155901cf165edc5ed3f4477.webp"
"MediaSize" => 33821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-64b525b35155901cf165edc5ed3f4477.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Bedroom featuring light carpet, a textured ceiling, a closet, and ceiling fan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6343355410"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29144137/382fd260e48e66ebdfb29eeba4bbaf3f.webp"
"MediaSize" => 34255
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29144137/thumbnail-382fd260e48e66ebdfb29eeba4bbaf3f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom #2 featuring carpet floors and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790569"
"ResourceRecordKey" => "29144137"
"ModificationTimestamp" => "2025-11-27T23:00:11.4Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29144137')"
+"ID": "449812"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24605
+post_id: "449772"
+post_author: 1
+"ListingKey": "29143217"
+"ListingId": "40790210"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T19:40:57Z"
+"RFModificationTimestamp": "2025-11-28T00:03:25Z"
+"ListPrice": 1349000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 4528.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2V6"
+"UnparsedAddress": "340 COLERIDGE Drive, Waterloo, Ontario N2L2V6"
+"Coordinates": array:2 [
0 => -80.5501729
1 => 43.460955
]
+"Latitude": 43.460955
+"Longitude": -80.5501729
+"YearBuilt": 1967
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this expansive and fully finished, carpet-free 5-bedroom, 4-bath family home in the highly desirable Beechwood neighbourhood. Offering over 4,000 sq. ft. of finished living space, this property delivers exceptional comfort, functionality, and style for the modern family. The main floor features a large, welcoming foyer that opens to formal living and dining rooms, both with generous picture windows that fill the space with natural light. The heart of the home is the impressive family area, complete with a spacious chef’s kitchen featuring a grand centre island, ample cabinetry, and a dedicated wet bar with dinette. The adjoining family room offers built-in bookcases, a gas fireplace, and stunning views of the private rear yard. Upstairs, you’ll find five large bedrooms, including a primary suite with a fully updated ensuite featuring modern finishes. The main floor bath has also been tastefuly updated. The 4th bedroom features a beautiful balcony over looking the large private yard. The fully finished lower level, updated in 2021 by Chart Homes, provides exceptional additional living space with a large open rec area, custom wet bar, games zone, and media/TV space. A dedicated gym room, an updated bathroom featuring a sauna, a private office/bonus room, and new French doors leading directly to the backyard complete this level. Outside, the beautifully landscaped yard is designed for relaxation and entertainment. Enjoy the full-size pool, spacious patio, and grassy area perfect for play. The front yard features a newer stone interlock driveway, custom stone steps, and an interlock side pathway, adding to the home’s curb appeal. Home also features an oversized garage with EV charger. Ideally located close to both universities, Uptown Waterloo, a short walk to top-rated schools, parks, and scenic walking trails, this well-appointed home offers an exceptional lifestyle in a prime Waterloo location. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Sauna"
4 => "Dishwasher"
5 => "Wine Fridge"
6 => "Stove"
7 => "Dryer"
8 => "Garage door opener"
9 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-28T00:03:01.503118+00:00"
+"Directions": "KEATS WAY TO AMOS AVE. TO COLERIDGE DR."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563571"
+"ListOfficeKey": "292787"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-27T19:30:23Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T19:30:23Z"
+"Stories": "2.0"
+"StreetName": "COLERIDGE"
+"StreetNumber": "340"
+"StreetSuffix": "Drive"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "9189.99"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/340-Coleridge-Dr"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [
"RoomKey" => "1541002535"
"RoomType" => "Dinette"
"ListingId" => "40790210"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29143217"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 18'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:30:23.78Z"
]
1 => array:11 [
"RoomKey" => "1541002536"
"RoomType" => "2pc Bathroom"
"ListingId" => "40790210"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29143217"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:30:23.78Z"
]
2 => array:11 [
"RoomKey" => "1541002537"
"RoomType" => "Sauna"
"ListingId" => "40790210"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29143217"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:30:23.78Z"
]
3 => array:11 [
"RoomKey" => "1541002538"
"RoomType" => "3pc Bathroom"
"ListingId" => "40790210"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29143217"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:30:23.78Z"
]
4 => array:11 [
"RoomKey" => "1541002539"
"RoomType" => "Gym"
"ListingId" => "40790210"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29143217"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 25'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:30:23.78Z"
]
5 => array:11 [
"RoomKey" => "1541002540"
"RoomType" => "Office"
"ListingId" => "40790210"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29143217"
"RoomLength" => null
"RoomDimensions" => "16'2'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:30:23.78Z"
]
6 => array:11 [
"RoomKey" => "1541002541"
"RoomType" => "Recreation room"
"ListingId" => "40790210"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29143217"
"RoomLength" => null
"RoomDimensions" => "19'11'' x 29'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:30:23.78Z"
]
7 => array:11 [
"RoomKey" => "1541002542"
"RoomType" => "Full bathroom"
"ListingId" => "40790210"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29143217"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:30:23.79Z"
]
8 => array:11 [
"RoomKey" => "1541002543"
"RoomType" => "Primary Bedroom"
"ListingId" => "40790210"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29143217"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 16'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:30:23.79Z"
]
9 => array:11 [
"RoomKey" => "1541002544"
"RoomType" => "Bedroom"
"ListingId" => "40790210"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29143217"
"RoomLength" => null
"RoomDimensions" => "14'3'' x 13'11''"
"RoomDescription" => null
…2
]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29143217/340-coleridge-drive-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1935309"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1904174"
+"CoListOfficeKey": "292076"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "292076"
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 56.0
+"AboveGradeFinishedArea": 2965
+"BelowGradeFinishedArea": 1563
+"OriginalEntryTimestamp": "2025-11-27T19:30:23.72Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29143217')"
+"ID": "449772"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24616
+post_id: "443973"
+post_author: 1
+"ListingKey": "29136558"
+"ListingId": "X12576290"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T22:10:23Z"
+"RFModificationTimestamp": "2025-11-26T22:13:59Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L1W3"
+"UnparsedAddress": "416 - 312 ERB STREET W, Waterloo, Ontario N2L1W3"
+"Coordinates": array:2 [
0 => -80.543394
1 => 43.456293
]
+"Latitude": 43.456293
+"Longitude": -80.543394
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A newer unit 2 BR,2 Washroom Moda Unit in the City of Waterloo available for lease.Sleek finishes with modren amenities.Close to University of Waterloo and Laurrier University,transport,LRT line,major shopping,restaurants and much more.Internet also available in the Unit.The Tenant to pay for the Utilities.Furnishing of Unit also an option at nominal cost TBD (id:62650)"
+"Appliances": array:2 [
0 => "Washer"
1 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-25T22:13:17.805464+00:00"
+"Directions": "Cross Streets: Erb St W/University Ave. ** Directions: University Ave-Erb St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Tile"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1828927"
+"ListOfficeKey": "253781"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T22:00:15Z"
+"PhotosCount": 17
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T22:00:14Z"
+"StreetDirSuffix": "West"
+"StreetName": "Erb"
+"StreetNumber": "312"
+"StreetSuffix": "Street"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29136558/416-312-erb-street-w-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"TotalActualRent": 2400
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-25T21:35:26.18Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:17 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29136558')"
+"ID": "443973"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24999
+post_id: "441558"
+post_author: 1
+"ListingKey": "29132627"
+"ListingId": "40790199"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-30T21:41:07Z"
+"RFModificationTimestamp": "2025-11-30T21:45:08Z"
+"ListPrice": 699999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.112
+"LivingArea": 2247.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2N3E9"
+"UnparsedAddress": "62 WILDLARK Crescent, Kitchener, Ontario N2N3E9"
+"Coordinates": array:2 [
0 => -80.5389301
1 => 43.4318794
]
+"Latitude": 43.4318794
+"Longitude": -80.5389301
+"YearBuilt": 1992
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 62 Wildlark Crescent, a fantastic find in one of Kitchener’s most convenient neighbourhoods! This spacious four-bedroom, two-bathroom backsplit is bursting with natural light and offers an inviting main floor designed for effortless living and entertaining. The open-concept living and dining area flows seamlessly into a stylish kitchen complete with stainless steel appliances and plenty of storage. Head upstairs to discover three generously sized bedrooms, each offering great closet space and a warm, welcoming feel. The lower level expands your living space even further, featuring a cozy family room with gas fireplace and direct walkout access to the oversized back deck, plus a versatile fourth bedroom. The basement adds even more flexibility with a huge recreation room—perfect as a home office, playroom, fitness studio, hobby room, or comfortable guest suite. Outside, get ready to enjoy a sprawling backyard with an impressive wraparound deck and abundant green space—ideal for relaxing, hosting, or playing outdoors. Located close to schools, shopping, parks, and more, this home delivers exceptional comfort, space, and convenience. There’s room for everyone—and every lifestyle—at 62 Wildlark Crescent! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Partial"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-25T00:30:36.083972+00:00"
+"Directions": "Victoria Street to Eastforest Trail"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Aluminum siding"
2 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2172433"
+"ListOfficeKey": "283928"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Gazebo"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.112"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-24T20:19:07Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-30T21:30:05Z"
+"StreetName": "WILDLARK"
+"StreetNumber": "62"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "338 - Beechwood Forest/Highland W."
+"TaxAnnualAmount": "4382"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/62_wildlark_crescent_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/29132627/62-wildlark-crescent-kitchener"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R2B"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 44.0
+"AboveGradeFinishedArea": 1701
+"BelowGradeFinishedArea": 546
+"OriginalEntryTimestamp": "2025-11-24T20:19:06.86Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29132627')"
+"ID": "441558"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25000
+post_id: "441493"
+post_author: 1
+"ListingKey": "29132699"
+"ListingId": "40790154"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T22:20:37Z"
+"RFModificationTimestamp": "2025-11-27T22:24:22Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.231
+"LivingArea": 1563.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2H2N2"
+"UnparsedAddress": "17 ROOSEVELT Avenue, Waterloo, Ontario N2H2N2"
+"Coordinates": array:2 [
0 => -80.5484115
1 => 43.4530738
]
+"Latitude": 43.4530738
+"Longitude": -80.5484115
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "ENTIRE DETACHED 3 BEDROOM/2 BATHROOM HOUSE!!! Welcome to your - very cool - mid-century, backsplit home in beautiful Maple Hills! Lots of natural light in this updated, detached home. Enjoy having friends and family over for drinks and beverages - prepared on your quartz countertops and served in your vaulted ceiling great room! Walk down a few steps and kick back in your massive rec room to listen to music, watch TV - or enjoy the view of your backyard through the oversized glass doors and windows. It's true - in this neighbourhood it's not uncommon to see bunnies hopping through gardens! Close to everything - U of W; WLU; Conestoga College; Costco; Ira Needles Blvd. restaurants, stores and medical centres; Beechwood Plaza; Covenant Cafe (YUM!!!); QuickTrip Variety and MORE!!! Mature trees abound, easy access walking paths and sidewalks through the neighbourhood. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:4 [
0 => "Quiet Area"
1 => "High Traffic Area"
2 => "School Bus"
3 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-25T00:16:45.244652+00:00"
+"Directions": "Take ON-401 W to Fischer-Hallman Rd in Kitchener. Take the Fischer Hallman Road N exit from Hwy 8 W/ON-7/ON-8 W; Follow Fischer-Hallman Rd to Roosevelt Ave in Waterloo."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2095000"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.231"
+"PhotosChangeTimestamp": "2025-11-24T20:30:19Z"
+"PhotosCount": 32
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T22:08:38Z"
+"StreetName": "ROOSEVELT"
+"StreetNumber": "17"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"VirtualTourURLUnbranded": "https://youriguide.com/17_roosevelt_avenue_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29132699/17-roosevelt-avenue-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2895
+"ZoningDescription": "SR1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 55.0
+"AboveGradeFinishedArea": 1031
+"BelowGradeFinishedArea": 532
+"OriginalEntryTimestamp": "2025-11-24T20:30:18.88Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:32 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29132699')"
+"ID": "441493"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25009
+post_id: "432634"
+post_author: 1
+"ListingKey": "29121239"
+"ListingId": "X12561550"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-01T13:41:11Z"
+"RFModificationTimestamp": "2025-12-01T13:44:31Z"
+"ListPrice": 1049900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 4
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T0B7"
+"UnparsedAddress": "22 - 435 WINCHESTER DRIVE, Waterloo, Ontario N2T0B7"
+"Coordinates": array:2 [
0 => -80.561888
1 => 43.452439
]
+"Latitude": 43.452439
+"Longitude": -80.561888
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "DISCOVER LIFE IN THE VILLAGE. A rare executive townhome with over 3,100 sqft. of beautifully finished living space, offering privacy and convenience in a quiet enclave ideal for retirees, or busy professionals. The home makes a strong first impression with its attached double garage and meticulous curb appeal. Inside, you're greeted by an open concept main floor with a bright kitchen featuring granite countertops and ample cabinetry, a welcoming dining area and a living room with a cozy gas fireplace. Large windows fill the space with natural light and provide clear views of McCrae Park. A convenient 2 piece bathroom completes this level. Upstairs, a versatile family room provides additional living space or a dedicated office. The primary bedroom includes a walk-in closet and a luxurious 5 piece ensuite. The second bedroom also features its own walk-in closet and a 4 piece ensuite. The laundry room completes the upper level. The fully finished basement offers a large recreation room and a full 4 piece bathroom. Outside, enjoy a private patio area with a gas BBQ hookup. Living in Beechwood means enjoying one of Waterloo's most desirable and peaceful neighbourhoods, with nearby amenities, top rated schools and quick access to Uptown Waterloo. Homes in The Village rarely come to market, so this is an opportunity not to be missed. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Garage door opener"
]
+"AssociationFee": "617.18"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Water"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 4
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-20T15:41:10.504292+00:00"
+"Directions": "Cross Streets: Fischer-Hallman Road. ** Directions: Fischer-Hallman Road to Winchester Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2093834"
+"ListOfficeKey": "294392"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Backs on greenbelt"
1 => "Sump Pump"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-20T14:49:25Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-01T13:21:36Z"
+"Stories": "2.0"
+"StreetName": "Winchester"
+"StreetNumber": "435"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "8111.22"
+"VirtualTourURLUnbranded": "https://youriguide.com/435_winchester_dr_waterloo_on/"
+"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": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29121239/22-435-winchester-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2249
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-11-20T14:49:24.91Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29121239')"
+"ID": "432634"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23322
+post_id: "430777"
+post_author: 1
+"ListingKey": "29118735"
+"ListingId": "40789294"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T16:30:28Z"
+"RFModificationTimestamp": "2025-11-26T16:34:09Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1498.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2Y7"
+"UnparsedAddress": "567 CHABLIS Drive, Waterloo, Ontario N2T2Y7"
+"Coordinates": array:2 [
0 => -80.573577
1 => 43.449765
]
+"Latitude": 43.449765
+"Longitude": -80.573577
+"YearBuilt": 2004
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This beautiful and immaculately clean open-concept 2 story end unit townhome is truly a family's delight. Close to many elementary schools, universities, shopping, highways and other amenities. Contact us today to see this rental unit! 3 Bedrooms 2.5 Bathrooms with Soaker Tubs Finished Basement 5 Appliances Including Main Floor Laundry Central Air Conditioning Water Softener Garage with Opener Multi-Car Parking Deck Fenced Yard Mix of Hardwood, Tile & Carpet ** Available NOW!! ** *Non-Smoking Unit* *Tenant Insurance is Mandatory and Must be Provided on Move in Day* *Any Unit Listed by KWP That States All Inclusive Will Have a Cap Included* *See sales brochure below for showing instructions* (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-19T19:57:34.508163+00:00"
+"Directions": "Erbsville Rd From Erb Street West take first right on the round-about to Erbsville Road and take left on Chablis Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1834563"
+"ListOfficeKey": "300202"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "No Pet Home"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-19T19:00:35Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T16:18:56Z"
+"Stories": "2.0"
+"StreetName": "CHABLIS"
+"StreetNumber": "567"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29118735/567-chablis-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2600
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 26.0
+"AboveGradeFinishedArea": 1498
+"OriginalEntryTimestamp": "2025-11-19T19:00:35.29Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:13 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29118735')"
+"ID": "430777"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24579
+post_id: "430786"
+post_author: 1
+"ListingKey": "29118745"
+"ListingId": "X12559066"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T19:40:25Z"
+"RFModificationTimestamp": "2025-11-26T19:43:40Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1G3"
+"UnparsedAddress": "467 DRUMMERHILL CRESCENT, Waterloo, Ontario N2T1G3"
+"Coordinates": array:2 [
0 => -80.5512601
1 => 43.4455427
]
+"Latitude": 43.4455427
+"Longitude": -80.5512601
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to family-friendly Westvale! This thoughtfully updated 4-level backsplit sits on a quiet crescent, just steps from parks, playgrounds, walking trails, and top-rated schools. Offering 3 bedrooms, 2 full baths, and a practical layout, this detached home is built for comfortable modern living. The main level includes a bright kitchen, a formal dining area, and a living room. Upstairs are three bedrooms and a 4-piece main bath. The lower level features a warm, welcoming rec room - perfect for movie nights or relaxed gatherings. A few steps down, you'll find a 3-piece bath, a laundry area, and a finished bonus room ideal for an additional bedroom or home office. Situated only minutes from Costco, The Boardwalk, shops, restaurants, and entertainment, this move-in-ready home is a fantastic opportunity to experience the best of Westvale living! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2025-11-19T19:56:02.022546+00:00"
+"Directions": "Cross Streets: Westvale Dr/ Drummerhill Cres. ** Directions: THORNDALE DRIVE TO WESTVALE DRIVE TO DRUMMERHILLCRES."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2189224"
+"ListOfficeKey": "286835"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "31.1 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-19T19:00:42Z"
+"PhotosCount": 17
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T19:29:03Z"
+"StreetName": "Drummerhill"
+"StreetNumber": "467"
+"StreetSuffix": "Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29118745/467-drummerhill-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2750
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 31.1
+"OriginalEntryTimestamp": "2025-11-19T19:00:42.92Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:17 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29118745')"
+"ID": "430786"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24583
+post_id: "430516"
+post_author: 1
+"ListingKey": "29118413"
+"ListingId": "40789043"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T18:55:38Z"
+"RFModificationTimestamp": "2025-11-26T19:10:05Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1775.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1G3"
+"UnparsedAddress": "467 DRUMMERHILL Crescent, Waterloo, Ontario N2T1G3"
+"Coordinates": array:2 [
0 => -80.5512583
1 => 43.445542
]
+"Latitude": 43.445542
+"Longitude": -80.5512583
+"YearBuilt": 1982
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to family-friendly Westvale! This thoughtfully updated 4-level backsplit sits on a quiet crescent, just steps from parks, playgrounds, walking trails, and top-rated schools. Offering 3 bedrooms, 2 full baths, and a practical layout, this detached home is built for comfortable modern living. The main level includes a bright kitchen, a formal dining area, and a living room. Upstairs are three bedrooms and a 4-piece main bath. The lower level features a warm, welcoming rec room - perfect for movie nights or relaxed gatherings. A few steps down, you'll find a 3-piece bath, a laundry area, and a finished bonus room ideal for an additional bedroom or home office. Situated only minutes from Costco, The Boardwalk, shops, restaurants, and entertainment, this move-in-ready home is a fantastic opportunity to experience the best of Westvale living! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-19T19:00:07.975738+00:00"
+"Directions": "THORNDALE DRIVE TO WESTVALE DRIVE TO DRUMMERHILL CRES"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2140701"
+"ListOfficeKey": "289848"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0"
+"PhotosChangeTimestamp": "2025-11-19T18:19:24Z"
+"PhotosCount": 17
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T18:40:08Z"
+"StreetName": "DRUMMERHILL"
+"StreetNumber": "467"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "2540"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29118413/467-drummerhill-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2750
+"ZoningDescription": "SD-1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 31.0
+"AboveGradeFinishedArea": 1080
+"BelowGradeFinishedArea": 695
+"OriginalEntryTimestamp": "2025-11-19T18:19:24.41Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:17 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29118413')"
+"ID": "430516"
}
]
+success: true
+page_size: 9
+page_count: 12
+count: 102
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]