array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29143217/Property?$select=ALL&$top=20&$filter=ListingKey eq 29143217&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29143217/Property?$select=ALL&$top=20&$filter=ListingKey eq 29143217&$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: "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
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:30:23.79Z"
]
10 => array:11 [
"RoomKey" => "1541002545"
"RoomType" => "Bedroom"
"ListingId" => "40790210"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29143217"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:30:23.79Z"
]
11 => array:11 [
"RoomKey" => "1541002546"
"RoomType" => "Bedroom"
"ListingId" => "40790210"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29143217"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 13'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:30:23.79Z"
]
12 => array:11 [
"RoomKey" => "1541002547"
"RoomType" => "Bedroom"
"ListingId" => "40790210"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29143217"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 14'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:30:23.79Z"
]
13 => array:11 [
"RoomKey" => "1541002548"
"RoomType" => "5pc 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"
]
14 => array:11 [
"RoomKey" => "1541002549"
"RoomType" => "Family room"
"ListingId" => "40790210"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29143217"
"RoomLength" => null
"RoomDimensions" => "18'9'' x 17'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:30:23.79Z"
]
15 => array:11 [
"RoomKey" => "1541002550"
"RoomType" => "Kitchen"
"ListingId" => "40790210"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29143217"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 27'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:30:23.79Z"
]
16 => array:11 [
"RoomKey" => "1541002551"
"RoomType" => "Dining room"
"ListingId" => "40790210"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29143217"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 15'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:30:23.8Z"
]
17 => array:11 [
"RoomKey" => "1541002552"
"RoomType" => "Living room"
"ListingId" => "40790210"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29143217"
"RoomLength" => null
"RoomDimensions" => "13'9'' x 22'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T19:30:23.8Z"
]
]
+"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 [
"Order" => 0
"MediaKey" => "6342960769"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/507117e11e86ccf1b9a4a330a5546c4b.webp"
"MediaSize" => 72006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-507117e11e86ccf1b9a4a330a5546c4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6342960904"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/98238ada14a72f364d418c6a539f27c4.webp"
"MediaSize" => 130323
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-98238ada14a72f364d418c6a539f27c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6342960961"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/c66c223a9f5b45c8af0800854fdd24b2.webp"
"MediaSize" => 62522
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-c66c223a9f5b45c8af0800854fdd24b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6342960978"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/901453e80a52aa1fe3fa04c279acd117.webp"
"MediaSize" => 98289
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-901453e80a52aa1fe3fa04c279acd117.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6342961040"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/01a26fe7a645cb263fb7e4c02ce8f7d5.webp"
"MediaSize" => 67932
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-01a26fe7a645cb263fb7e4c02ce8f7d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6342961110"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/c128dd1dc7e26b69d16140b899ab054b.webp"
"MediaSize" => 192618
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-c128dd1dc7e26b69d16140b899ab054b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6342961199"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/2c18f900eed66672c0e134598d88fb0f.webp"
"MediaSize" => 72249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-2c18f900eed66672c0e134598d88fb0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6342961292"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/4fd510c8b02d59824e26a7d8a81b0373.webp"
"MediaSize" => 63403
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-4fd510c8b02d59824e26a7d8a81b0373.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6342961359"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/2bacd0b9181dabaf5a6cdde4ba4ff85e.webp"
"MediaSize" => 72571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-2bacd0b9181dabaf5a6cdde4ba4ff85e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6342961406"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/6960c8a6f42f9d78bf7bdf2c6005dfbc.webp"
"MediaSize" => 96834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-6960c8a6f42f9d78bf7bdf2c6005dfbc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6342961431"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/882e22ff8a244184c142c2f4bb10a356.webp"
"MediaSize" => 105325
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-882e22ff8a244184c142c2f4bb10a356.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6342961492"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/7c4e5c0eacffc5c55974b520b524ee5e.webp"
"MediaSize" => 70134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-7c4e5c0eacffc5c55974b520b524ee5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6342961597"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/3fe59176f7ce244bd7ed25094c8a0f9f.webp"
"MediaSize" => 87010
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-3fe59176f7ce244bd7ed25094c8a0f9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6342961619"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/27cc0a31e71b72f43b4fd7c7e0d2dadc.webp"
"MediaSize" => 67240
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-27cc0a31e71b72f43b4fd7c7e0d2dadc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6342961665"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/f554ed00a37084b0811a84dd2809448a.webp"
"MediaSize" => 54654
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-f554ed00a37084b0811a84dd2809448a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6342961705"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/d415dca083f5c06ccb3ea857da866cf0.webp"
"MediaSize" => 61008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-d415dca083f5c06ccb3ea857da866cf0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6342961724"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/c272ba4547a68da348726e8f364415cb.webp"
"MediaSize" => 69200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-c272ba4547a68da348726e8f364415cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6342961769"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/31b42a63d0df7c0a0d449644a6b93112.webp"
"MediaSize" => 193852
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-31b42a63d0df7c0a0d449644a6b93112.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6342961795"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/12e561854376b5f3c6217c158203e4ad.webp"
"MediaSize" => 92092
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-12e561854376b5f3c6217c158203e4ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6342961838"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/af60eeeff49f4e59d6175217a4dbd294.webp"
"MediaSize" => 91326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-af60eeeff49f4e59d6175217a4dbd294.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6342961883"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/34bf7033207099f4b85711c979c3eed6.webp"
"MediaSize" => 99575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-34bf7033207099f4b85711c979c3eed6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6342961929"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/0657a1c1b1242ff2480a660fb7a68d86.webp"
"MediaSize" => 63651
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-0657a1c1b1242ff2480a660fb7a68d86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6342961938"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/d4c77afadb23ffec3e602f810795afb1.webp"
"MediaSize" => 88671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-d4c77afadb23ffec3e602f810795afb1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6342961967"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/8a3a67d890751ee9118ea9b29eeb5f2e.webp"
"MediaSize" => 69945
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-8a3a67d890751ee9118ea9b29eeb5f2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6342961984"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/20e819dd49056ec4188e61f83f23534e.webp"
"MediaSize" => 56319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-20e819dd49056ec4188e61f83f23534e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6342962004"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/46ae24a8ddc2d5ccf36a53046fc4570c.webp"
"MediaSize" => 233119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-46ae24a8ddc2d5ccf36a53046fc4570c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6342962036"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/bdacb7ab1bab235ad64e5220c74533ef.webp"
"MediaSize" => 217060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-bdacb7ab1bab235ad64e5220c74533ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6342962063"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/1c22754bcfc429353956b8998ce642a5.webp"
"MediaSize" => 153667
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-1c22754bcfc429353956b8998ce642a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6342962086"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/07c28f95c6a20b089e37392e84891b29.webp"
"MediaSize" => 107886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-07c28f95c6a20b089e37392e84891b29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6342962104"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/e2e98edd609d4eb015674dd0866e8c88.webp"
"MediaSize" => 98029
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-e2e98edd609d4eb015674dd0866e8c88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6342962115"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/0246713738bf579283367aa987782ad3.webp"
"MediaSize" => 46714
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-0246713738bf579283367aa987782ad3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6342962136"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/7a088c570c99684c8c63769d9c9737c9.webp"
"MediaSize" => 71328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-7a088c570c99684c8c63769d9c9737c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6342962151"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/a089d603f5bb61bb9d072bfac844aa54.webp"
"MediaSize" => 98082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-a089d603f5bb61bb9d072bfac844aa54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6342962168"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/6ff869fec5e2cbc47718b221788d3232.webp"
"MediaSize" => 156040
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-6ff869fec5e2cbc47718b221788d3232.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6342962180"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/50d6d500a73d3cf22efbd3e0d645245c.webp"
"MediaSize" => 55021
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-50d6d500a73d3cf22efbd3e0d645245c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6342962188"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/d5ef673792196a6eed75e0ccfd5f2467.webp"
"MediaSize" => 66971
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-d5ef673792196a6eed75e0ccfd5f2467.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6342962200"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/f3b271ca77ab3c86b3eac186a28ca069.webp"
"MediaSize" => 69741
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-f3b271ca77ab3c86b3eac186a28ca069.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6342962207"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/81947a78c355d749b48eab71421b0028.webp"
"MediaSize" => 68452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-81947a78c355d749b48eab71421b0028.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6342962220"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/f33ddf96d6e3aeb8a4fed2d6c0a3a051.webp"
"MediaSize" => 93701
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-f33ddf96d6e3aeb8a4fed2d6c0a3a051.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6342962228"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/e54d668d1405400ab877ec785c466723.webp"
"MediaSize" => 57862
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-e54d668d1405400ab877ec785c466723.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6342962232"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/4a7f11c8058a8b76116ecc683488ea1b.webp"
"MediaSize" => 92260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-4a7f11c8058a8b76116ecc683488ea1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6342962236"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/422beb52fd069b79ae16a2870eeec71c.webp"
"MediaSize" => 177782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-422beb52fd069b79ae16a2870eeec71c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
42 => array:13 [
"Order" => 42
"MediaKey" => "6342962241"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/b7e2a87956b33ad88aec804a6e6a3a89.webp"
"MediaSize" => 59476
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-b7e2a87956b33ad88aec804a6e6a3a89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
43 => array:13 [
"Order" => 43
"MediaKey" => "6342962242"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/4ff4703aa3c0e4f89ef150b1a03ecd05.webp"
"MediaSize" => 62744
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-4ff4703aa3c0e4f89ef150b1a03ecd05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
44 => array:13 [
"Order" => 44
"MediaKey" => "6342962246"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/156ac128544745b3616b881a38fccf0e.webp"
"MediaSize" => 88547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-156ac128544745b3616b881a38fccf0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
45 => array:13 [
"Order" => 45
"MediaKey" => "6342962248"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/44870e685e2dbcd9a90e8b9754390a0d.webp"
"MediaSize" => 72453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-44870e685e2dbcd9a90e8b9754390a0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
46 => array:13 [
"Order" => 46
"MediaKey" => "6342962250"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/69f61caf9a5ba8e7c4e22b1a333adc73.webp"
"MediaSize" => 69269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-69f61caf9a5ba8e7c4e22b1a333adc73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
47 => array:13 [
"Order" => 47
"MediaKey" => "6342962253"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/1c56a007db37d4812f4f2e792f20102f.webp"
"MediaSize" => 58698
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-1c56a007db37d4812f4f2e792f20102f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
48 => array:13 [
"Order" => 48
"MediaKey" => "6342962255"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/94da1c5e99c65352b51689ce1403615e.webp"
"MediaSize" => 65571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-94da1c5e99c65352b51689ce1403615e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
49 => array:13 [
"Order" => 49
"MediaKey" => "6342962257"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29143217/f9213983e06899f90be91f710d902818.webp"
"MediaSize" => 60350
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29143217/thumbnail-f9213983e06899f90be91f710d902818.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790210"
"ResourceRecordKey" => "29143217"
"ModificationTimestamp" => "2025-11-27T19:30:23.73Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29143217')"
+"ID": "449772"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 292787/Office?$select=ALL&$top=10&$filter=OfficeKey eq 292787&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 292787/Office?$select=ALL&$top=10&$filter=OfficeKey eq 292787&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25163
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25165
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Forest Hill Real Estate Inc. Brokerage"
+"OfficeEmail": null
+"OfficePhone": "519-741-1400"
+"OfficeMlsId": "KW394"
+"ModificationTimestamp": "2025-08-19T15:49:32Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "292787"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "234 Frederick St., Unit: A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Kitchener"
+"OfficePostalCode": "N2H2M"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1417443"
+"OriginalEntryTimestamp": "2022-05-27T16:56:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "444190"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "292787"
"SocialMediaUrlOrId" => "http://fhwaterlooregion.com/"
"ModificationTimestamp" => "2025-08-19T15:26:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1048339"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('292787')"
+"Media": []
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1563571/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1563571&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1563571/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1563571&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25168
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29143217" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24765
+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 29143217/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29143217&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29143217/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29143217&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24725
+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 29143217 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5501729 43.460955)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29143217 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5501729 43.460955)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29143217 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5501729 43.460955)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29143217 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5501729 43.460955)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25033
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25040
+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
…2
]
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/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 [ …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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29152151')"
+"ID": "455536"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25052
+post_id: "446262"
+post_author: 1
+"ListingKey": "29139216"
+"ListingId": "X12578862"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T18:40:24Z"
+"RFModificationTimestamp": "2025-11-26T20:04:40Z"
+"ListPrice": 349900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6E4"
+"UnparsedAddress": "101 - 265 WESTCOURT PLACE, Waterloo, Ontario N2L6E4"
+"Coordinates": array:2 [
0 => -80.540494
1 => 43.460629
]
+"Latitude": 43.460629
+"Longitude": -80.540494
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 265 Westcourt Place, Unit 101, a rare ground level opportunity in one of Waterloo's most convenient and established condo communities. This spacious unit offers just over 1,200 square feet of living space with 2 bedrooms and 2 full bathrooms. It is a true handy person special, an ideal canvas for anyone looking to create a beautifully customized home finished exactly to their taste. Sold in as-is condition, it is ready for a full renovation and offers incredible potential for value and personalization. Enjoy a smart and practical layout with an eat in kitchen, a dedicated dining area, and a bright living space with large windows that fill the home with natural light. The primary bedroom features its own ensuite bath, and the unit includes three walkouts that lead to a large private terrace, perfect for morning coffee, container gardening, or relaxing outdoors. Easy access to the entrance and visitor parking adds daily convenience. This condo includes one parking space and a locker, and additional parking may be available through the corporation. Residents also enjoy an impressive list of amenities including guest suites, a fitness room, party room, library, hobby room, and a games room with ping pong. Carefree living with everything you need in one place. Located in a sought after Waterloo neighbourhood, you are minutes from the University of Waterloo, Waterloo Park, the Boardwalk, Uptown Waterloo, transit, restaurants, trails, and everyday conveniences. Whether you are an investor, first time buyer, downsizer, or someone with a vision, this is your chance to transform a well located unit into the home you have always imagined. Bring your ideas, roll up your sleeves, and make this condo shine. A fantastic opportunity in a prime location. (id:62650)"
+"Appliances": array:1 [
0 => "Water Treatment"
]
+"AssociationFee": "831"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T20:04:21.170022+00:00"
+"Directions": "Cross Streets: Erb St. W / University Ave W. ** Directions: Westmount to Westcourt Place."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2093834"
+"ListOfficeKey": "294392"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Elevator"
2 => "Guest Suite"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2025-11-26T18:30:24Z"
+"PhotosCount": 39
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T18:30:24Z"
+"StreetName": "Westcourt"
+"StreetNumber": "265"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "3618.64"
+"VirtualTourURLUnbranded": "https://youriguide.com/101_265_westcourt_pl_waterloo_on/"
+"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": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29139216/101-265-westcourt-place-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Canlight"
+"GeocodeManualYN": false
+"BuildingFeatures": array:5 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Recreation Centre"
3 => "Party Room"
4 => "Visitor Parking"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-11-26T18:30:24.84Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:39 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139216')"
+"ID": "446262"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25039
+post_id: "445304"
+post_author: 1
+"ListingKey": "29137863"
+"ListingId": "X12577472"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T07:00:39Z"
+"RFModificationTimestamp": "2025-11-26T07:31:14Z"
+"ListPrice": 435000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6E6"
+"UnparsedAddress": "407 - 300 KEATS WAY, Waterloo, Ontario N2L6E6"
+"Coordinates": array:2 [
0 => -80.544516
1 => 43.462144
]
+"Latitude": 43.462144
+"Longitude": -80.544516
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Fully Renovated 2-Bed, 2-Bath Condo in Desirable Beechwood, Waterloo. Welcome to this beautifully renovated corner unit in the sought-after Beechwood neighborhood - a quiet, family-friendly area in the heart of Waterloo. This bright and spacious condo offers 2 generous bedrooms and 2 full bathrooms, including an ensuite in the primary bedroom. Enjoy modern living with - almost new flooring, fresh paint throughout, a fully updated kitchen with almost new appliances, and upgraded washroom fittings. The large, functional balcony is perfect for relaxing or entertaining, and being a corner unit, it benefits from plenty of natural light. Step inside to a spacious open-concept living and dining area that flows seamlessly into the updated kitchen and out to the balcony. The layout is thoughtfully designed for both comfort and functionality. Additional features include: 2 underground parking spots, In-suite laundry, dedicated storage space, 24 hours surveillance CCTV system, Intercom system, Car wash. Located just minutes from University of Waterloo, Wilfrid Laurier University, shopping centers, School , parks, and public transit - everything you need is within easy reach. Don't miss this opportunity to own a move-in ready home in one of Waterloo's most desirable communities! (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Intercom"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Dryer"
7 => "Microwave"
8 => "Oven - Built-In"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
12 => "Garage door opener remote(s)"
]
+"AssociationFee": "1078.84"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T07:30:58.459614+00:00"
+"Directions": "Cross Streets: University Avenue West/Keats Way. ** Directions: University Avenue West to Keats Way."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Laminate"
]
+"FoundationDetails": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2136085"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Conservation/green belt"
1 => "Elevator"
2 => "Lighting"
3 => "Balcony"
4 => "Carpet Free"
5 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2025-11-26T06:51:01Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T06:51:01Z"
+"StreetName": "Keats"
+"StreetNumber": "300"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "3192"
+"View": "City view"
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29137863/407-300-keats-way-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Trevarren Property Management"
+"BuildingFeatures": array:8 [
0 => "Storage - Locker"
1 => "Car Wash"
2 => "Exercise Centre"
3 => "Recreation Centre"
4 => "Separate Electricity Meters"
5 => "Separate Heating Controls"
6 => "Party Room"
7 => "Visitor Parking"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-11-26T06:51:01.2Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29137863')"
+"ID": "445304"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24655
+post_id: "445221"
+post_author: 1
+"ListingKey": "29137829"
+"ListingId": "40790356"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T06:20:07Z"
+"RFModificationTimestamp": "2025-11-26T06:24:46Z"
+"ListPrice": 435000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1250.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6E6"
+"UnparsedAddress": "300 KEATS Way Unit# 407, Waterloo, Ontario N2L6E6"
+"Coordinates": array:2 [
0 => -80.544291
1 => 43.462005
]
+"Latitude": 43.462005
+"Longitude": -80.544291
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Fully Renovated 2-Bed, 2-Bath Condo in Desirable Beechwood, Waterloo. Welcome to this beautifully renovated corner unit in the sought-after Beechwood neighborhood — a quiet, family-friendly area in the heart of Waterloo. This bright and spacious condo offers 2 generous bedrooms and 2 full bathrooms, including an ensuite in the primary bedroom. Enjoy modern living with - almost new flooring, fresh paint throughout, a fully updated kitchen with almost new appliances, and upgraded washroom fittings. The large, functional balcony is perfect for relaxing or entertaining, and being a corner unit, it benefits from plenty of natural light. Step inside to a spacious open-concept living and dining area that flows seamlessly into the updated kitchen and out to the balcony. The layout is thoughtfully designed for both comfort and functionality. Additional features include: 2 underground parking spots, In-suite laundry, dedicated storage space, 24 hours surveillance CCTV system, Intercom system, Car wash. Located just minutes from University of Waterloo, Wilfrid Laurier University, shopping centers, School , parks, and public transit — everything you need is within easy reach. Don't miss this opportunity to own a move-in ready home in one of Waterloo’s most desirable communities! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"AssociationFee": "1078.84"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:8 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Heat"
4 => "Water"
5 => "Insurance"
6 => "Parking"
7 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T06:24:38.320922+00:00"
+"Directions": "University Avenue west/Keats Way"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2062546"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Corner Site"
1 => "Conservation/green belt"
2 => "Balcony"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Covered"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2025-11-26T05:59:26Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T06:08:39Z"
+"Stories": "1.0"
+"StreetName": "KEATS"
+"StreetNumber": "300"
+"StreetSuffix": "Way"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3192"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"View": "City view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29137829/300-keats-way-unit-407-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"BuildingFeatures": array:3 [
0 => "Car Wash"
1 => "Exercise Centre"
2 => "Party Room"
]
+"SecurityFeatures": array:3 [
0 => "Alarm system"
1 => "Security system"
2 => "Smoke Detectors"
]
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1250
+"OriginalEntryTimestamp": "2025-11-26T05:59:26.35Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29137829')"
+"ID": "445221"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25054
+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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25035
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23322
+post_id: "441138"
+post_author: 1
+"ListingKey": "29132632"
+"ListingId": "40789696"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-30T21:46:03Z"
+"RFModificationTimestamp": "2025-11-30T21:53:27Z"
+"ListPrice": 1100000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2301.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5V7"
+"UnparsedAddress": "424 CLAIRBROOK Crescent, Waterloo, Ontario N2L5V7"
+"Coordinates": array:2 [
0 => -80.5637594
1 => 43.465947
]
+"Latitude": 43.465947
+"Longitude": -80.5637594
+"YearBuilt": 1978
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 424 Clairbrook, nestled in the highly sought-after, family-friendly Beechwood neighbourhood. This spacious home features four generous bedrooms on the upper level, plus an additional bedroom in the fully finished basement—perfect for growing families, hosting guests, or creating a dedicated home office. Inside, you'll find a warm and inviting layout with large principal rooms and an open-concept kitchen and dining area designed for everyday living and easy entertaining. Step outside to a large, private, fully fenced backyard, ideal for gatherings, gardening, or simply unwinding in your own outdoor retreat. This is a rare opportunity to own a home in one of Waterloo’s most desirable communities. Don’t miss your chance to make 424 Clairbrook yours. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-24T21:21:29.987509+00:00"
+"Directions": "Fischer- Hallman - Beechlawn"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2193974"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-24T20:19:13Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-30T21:30:19Z"
+"Stories": "2.0"
+"StreetName": "CLAIRBROOK"
+"StreetNumber": "424"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "6384"
+"VirtualTourURLUnbranded": "https://youriguide.com/424_clairbrook_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29132632/424-clairbrook-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2A"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 44.0
+"AboveGradeFinishedArea": 2301
+"OriginalEntryTimestamp": "2025-11-24T20:19:13.13Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:37 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29132632')"
+"ID": "441138"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24656
+post_id: "433010"
+post_author: 1
+"ListingKey": "29121565"
+"ListingId": "X12561750"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-20T16:06:09Z"
+"RFModificationTimestamp": "2025-11-20T18:09:43Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6E6"
+"UnparsedAddress": "503 - 300 KEATS WAY, Waterloo, Ontario N2L6E6"
+"Coordinates": array:2 [
0 => -80.544516
1 => 43.462144
]
+"Latitude": 43.462144
+"Longitude": -80.544516
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright and spacious 2 bedroom 1.5 bath condo offering nearly 1000 square feet of comfortable living in a highly convenient Waterloo location. This top floor suite features a functional layout with a large living and dining area that opens to a private balcony, perfect for relaxing or entertaining. The primary bedroom includes an ensuite bath and walk in closet, while the second bedroom is ideal for guests or a home office. In suite laundry, one underground parking space. Tenant only pays hydro and internet, all other utilities are included. The building offers clean and well maintained common areas including a party room for residents to enjoy. A well managed and quiet building close to the University of Waterloo, Laurier, shopping, and transit. The unit can be leased partially furnished or vacant based on tenant preference. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Ventilation system"
]
+"CreationDate": "2025-11-20T18:09:17.324836+00:00"
+"Directions": "University Ave W & Keats Way"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2223335"
+"ListOfficeKey": "275438"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2025-11-20T15:58:25Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-20T15:58:25Z"
+"StreetName": "Keats"
+"StreetNumber": "300"
+"StreetSuffix": "Way"
+"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/29121565/503-300-keats-way-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Trevarren Property Management Services Inc."
+"TotalActualRent": 2150
+"BuildingFeatures": array:6 [
0 => "Car Wash"
1 => "Exercise Centre"
2 => "Recreation Centre"
3 => "Separate Electricity Meters"
4 => "Party Room"
5 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Monitored Alarm"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-20T15:58:25.65Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:26 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29121565')"
+"ID": "433010"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24723
+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"
}
]
+success: true
+page_size: 9
+page_count: 18
+count: 156
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
]
