array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29247131/Property?$select=ALL&$top=20&$filter=ListingKey eq 29247131&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29247131/Property?$select=ALL&$top=20&$filter=ListingKey eq 29247131&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23484
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "531765"
+post_author: 1
+"ListingKey": "29247131"
+"ListingId": "40798306"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T21:15:48Z"
+"RFModificationTimestamp": "2026-01-13T23:09:04Z"
+"ListPrice": 999900.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 2
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3355.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1Z4"
+"UnparsedAddress": "599 BEECHWOOD Drive, Waterloo, Ontario N2T1Z4"
+"Coordinates": array:2 [
0 => -80.5659349
1 => 43.4500093
]
+"Latitude": 43.4500093
+"Longitude": -80.5659349
+"YearBuilt": 1989
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "OFFER ANYTIME. All brick 4+1 beds and 5 baths single detached home located in Waterloo's desirable Beechwood neighbourhood. The main floor features a spacious living room and a formal dining room both with large windows. The kitchen features granite countertops and porcelain tiles. The Sunken great room has high ceilings and there is a door that opens to a large patio in the fully fenced backyard. The main floor also features a 2pc powder room and a laundry room. On the 2nd floor you'll find 4 generously sized bedrooms, one 3pc master bedroom en-suite, a 4pc main bathroom, and another 2pc en-suite washroom. The fully finished basement offers a 5th bedroom, a huge rec room, and a 5th bathroom plus plenty of storage space. Recent Updates: Newly installed hardwood staircase (2025), new paint throughout (2025), basement newly finished (2025), two upper floor bathrooms newly updated (2025). New master bedroom curtains (2025), Hot Water Heater Owned (2021). Added Extra Insulation in 2018. Newer Garage Door (2022). Newer Sump Pump (2023). Newer Washer and Dryer (2023). Fridge (2024). Furnace and AC (2024). Great location close to many amenities, within walking distance to schools, bus routes, shopping centers. A short drive to the Boardwalk, and both Waterloo and Laurier University. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T23:08:29.190474+00:00"
+"Directions": "Royal Beech Dr to Beechwood Dr"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1970409"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-13T21:08:44Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T21:08:44Z"
+"Stories": "2.0"
+"StreetName": "BEECHWOOD"
+"StreetNumber": "599"
+"StreetSuffix": "Drive"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "5994"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/599-Beechwood-Dr"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [
"RoomKey" => "1560032758"
"RoomType" => "Utility room"
"ListingId" => "40798306"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "18'8'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.7Z"
]
1 => array:11 [
"RoomKey" => "1560032759"
"RoomType" => "Bedroom"
"ListingId" => "40798306"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.71Z"
]
2 => array:11 [
"RoomKey" => "1560032760"
"RoomType" => "3pc Bathroom"
"ListingId" => "40798306"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "7'9'' x 4'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.72Z"
]
3 => array:11 [
"RoomKey" => "1560032761"
"RoomType" => "Recreation room"
"ListingId" => "40798306"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "29'7'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.72Z"
]
4 => array:11 [
"RoomKey" => "1560032762"
"RoomType" => "Full bathroom"
"ListingId" => "40798306"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "5'11'' x 7'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.72Z"
]
5 => array:11 [
"RoomKey" => "1560032763"
"RoomType" => "Primary Bedroom"
"ListingId" => "40798306"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "18'0'' x 12'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.73Z"
]
6 => array:11 [
"RoomKey" => "1560032764"
"RoomType" => "2pc Bathroom"
"ListingId" => "40798306"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "5'8'' x 4'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.74Z"
]
7 => array:11 [
"RoomKey" => "1560032765"
"RoomType" => "Bedroom"
"ListingId" => "40798306"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "18'3'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.74Z"
]
8 => array:11 [
"RoomKey" => "1560032766"
"RoomType" => "Bedroom"
"ListingId" => "40798306"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.75Z"
]
9 => array:11 [
"RoomKey" => "1560032767"
"RoomType" => "5pc Bathroom"
"ListingId" => "40798306"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.75Z"
]
10 => array:11 [
"RoomKey" => "1560032768"
"RoomType" => "Bedroom"
"ListingId" => "40798306"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.76Z"
]
11 => array:11 [
"RoomKey" => "1560032769"
"RoomType" => "Laundry room"
"ListingId" => "40798306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.76Z"
]
12 => array:11 [
"RoomKey" => "1560032770"
"RoomType" => "Great room"
"ListingId" => "40798306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "15'11'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.76Z"
]
13 => array:11 [
"RoomKey" => "1560032771"
"RoomType" => "2pc Bathroom"
"ListingId" => "40798306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "3'3'' x 5'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.77Z"
]
14 => array:11 [
"RoomKey" => "1560032772"
"RoomType" => "Living room"
"ListingId" => "40798306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "18'0'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.77Z"
]
15 => array:11 [
"RoomKey" => "1560032773"
"RoomType" => "Dining room"
"ListingId" => "40798306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.77Z"
]
16 => array:11 [
"RoomKey" => "1560032774"
"RoomType" => "Kitchen"
"ListingId" => "40798306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29247131"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:08:44.77Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29247131/599-beechwood-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2A"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 69.0
+"AboveGradeFinishedArea": 2324
+"BelowGradeFinishedArea": 1031
+"OriginalEntryTimestamp": "2026-01-13T21:08:44.37Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"Media": array:49 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6403449164"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/139698b13f81141eee2443140d3fe758.webp"
"MediaSize" => 147849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-139698b13f81141eee2443140d3fe758.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front facade featuring brick siding, a garage, and driveway"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6403449181"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/89ee7610d300823a129896b13a609545.webp"
"MediaSize" => 136858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-89ee7610d300823a129896b13a609545.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Traditional-style house with asphalt driveway and brick siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6403449234"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/b6859f3c3fcf1efe749e27e201dfde5e.webp"
"MediaSize" => 141653
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-b6859f3c3fcf1efe749e27e201dfde5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front of property with brick siding, asphalt driveway, and a garage"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6403449255"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/0a780e2cadac7d165184044afafb16f6.webp"
"MediaSize" => 148090
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-0a780e2cadac7d165184044afafb16f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of property exterior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6403449293"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/c87843a61a09da0483af0dd9dc389580.webp"
"MediaSize" => 161583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-c87843a61a09da0483af0dd9dc389580.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Property entrance featuring brick siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6403449327"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/d841bbb4ebe2e20e0231e8018f3a2f99.webp"
"MediaSize" => 50800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-d841bbb4ebe2e20e0231e8018f3a2f99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway with light tile patterned floors and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6403449376"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/f7322242e77b4ec81146a64ad83743c2.webp"
"MediaSize" => 50172
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-f7322242e77b4ec81146a64ad83743c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hall featuring washing machine and dryer, light tile patterned floors, and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6403449406"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/e9b9da2135dd67565322d6981ab3a1fe.webp"
"MediaSize" => 76108
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-e9b9da2135dd67565322d6981ab3a1fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Sitting room featuring dark wood-style flooring and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6403449410"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/594ef5be7f1a0791080b735e7115d9d4.webp"
"MediaSize" => 77254
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-594ef5be7f1a0791080b735e7115d9d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office space with wood finished floors, recessed lighting, and a chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6403449443"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/cc45c48cbc95ae4e8a24d1f3cdf1028f.webp"
"MediaSize" => 81971
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-cc45c48cbc95ae4e8a24d1f3cdf1028f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area with dark wood-style flooring and a chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6403449467"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/d5c88ebf5e54ec8fc1575b724a5b46db.webp"
"MediaSize" => 77236
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-d5c88ebf5e54ec8fc1575b724a5b46db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining space with a chandelier and dark wood-style flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6403449474"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/63b8f10e364056ae2c8928f1eba6bd68.webp"
"MediaSize" => 73530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-63b8f10e364056ae2c8928f1eba6bd68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with glass insert cabinets, stainless steel appliances, backsplash, a chandelier, and under cabinet range hood"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6403449519"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/578dd89af382a944c90ebee96e716b8a.webp"
"MediaSize" => 79502
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-578dd89af382a944c90ebee96e716b8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring glass insert cabinets, electric stove, backsplash, under cabinet range hood, and white cabinets"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6403449544"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/5d35d3f84f5b691ec64a6b7419e3f09c.webp"
"MediaSize" => 71987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-5d35d3f84f5b691ec64a6b7419e3f09c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with stainless steel appliances, tasteful backsplash, a center island, glass insert cabinets, and a breakfast bar"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6403449570"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/193e412a4a2d699d68db8946278fbdf1.webp"
"MediaSize" => 83760
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-193e412a4a2d699d68db8946278fbdf1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white dishwasher, stainless steel microwave, white cabinetry, backsplash, and light stone counters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6403449603"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/28bc4b6ecdc69d21062c56691336ca13.webp"
"MediaSize" => 74818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-28bc4b6ecdc69d21062c56691336ca13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with freestanding refrigerator, a kitchen breakfast bar, and light tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6403449639"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/94496f3b3b84acb756164fbe0c058b52.webp"
"MediaSize" => 68886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-94496f3b3b84acb756164fbe0c058b52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring glass insert cabinets, decorative backsplash, stainless steel appliances, under cabinet range hood, and white cabinets"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6403449663"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/8f545f37f80c88668c3dba9dc29a8ebd.webp"
"MediaSize" => 89338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-8f545f37f80c88668c3dba9dc29a8ebd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6403449696"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/79fdc5bb50c4b37a787483c36302e2e5.webp"
"MediaSize" => 67440
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-79fdc5bb50c4b37a787483c36302e2e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Sitting room with light wood-style floors and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6403449712"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/22c5cd2052cbdf4dddb0ca80a46109c4.webp"
"MediaSize" => 44706
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-22c5cd2052cbdf4dddb0ca80a46109c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring vanity and light tile patterned flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6403449733"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/0f325c39ccb9bb992714a52b9a568d43.webp"
"MediaSize" => 49988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-0f325c39ccb9bb992714a52b9a568d43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Washroom with cabinet space, light tile patterned floors, and washing machine and clothes dryer"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6403449759"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/7ef466a44b2906406310a15ab412387b.webp"
"MediaSize" => 58304
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-7ef466a44b2906406310a15ab412387b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office area with crown molding, light wood finished floors, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6403449781"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/5b584f42201363571d5539601d805fcb.webp"
"MediaSize" => 63339
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-5b584f42201363571d5539601d805fcb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with a desk, ornamental molding, light wood-style floors, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6403449811"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/c4d9ecb1bea4c7b6a2311f2cb583cfb0.webp"
"MediaSize" => 56142
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-c4d9ecb1bea4c7b6a2311f2cb583cfb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a stall shower, vanity, and dark tile patterned flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6403449831"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/8883065d6de4e29d71540906bdec81ad.webp"
"MediaSize" => 60812
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-8883065d6de4e29d71540906bdec81ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring vanity and dark wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6403449849"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/3f47980cf370a091626d00f59e9c769d.webp"
"MediaSize" => 56643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-3f47980cf370a091626d00f59e9c769d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with a baseboard radiator, wood finished floors, and lofted ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6403449863"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/f77967a77208eca1ebf861b595a6a541.webp"
"MediaSize" => 68376
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-f77967a77208eca1ebf861b595a6a541.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light wood-style flooring and vaulted ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6403449872"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/7977d3b8dbee808a48067582afe18335.webp"
"MediaSize" => 47191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-7977d3b8dbee808a48067582afe18335.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Half bath featuring toilet and vanity"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6403449887"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/17bbc1b50ef0aba366db8ea51f51d60e.webp"
"MediaSize" => 55074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-17bbc1b50ef0aba366db8ea51f51d60e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Home office with light wood finished floors and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6403449902"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/5779f36e24e9a919eee9513dca87a093.webp"
"MediaSize" => 46301
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-5779f36e24e9a919eee9513dca87a093.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Sitting room featuring light wood-type flooring and an upstairs landing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6403449916"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/b5e047958e8adf7dbaaccd087f1bd493.webp"
"MediaSize" => 71527
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-b5e047958e8adf7dbaaccd087f1bd493.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with light wood-style floors, an office area, and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6403449933"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/8cb2e0a720678aef62813c5423257255.webp"
"MediaSize" => 61620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-8cb2e0a720678aef62813c5423257255.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light wood-style floors and a closet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6403449979"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/cdc701042b4a73e687fc2bbaf958eae2.webp"
"MediaSize" => 53566
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-cdc701042b4a73e687fc2bbaf958eae2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with light wood-style flooring, an office area, and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6403449990"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/6a62206c16ba731dd2611fd3c6c2f5ba.webp"
"MediaSize" => 70206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-6a62206c16ba731dd2611fd3c6c2f5ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bathroom with double vanity, shower / bath combo, and light tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6403449999"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/0db125dc53ff26e92d0b130e5cc0fb64.webp"
"MediaSize" => 60746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-0db125dc53ff26e92d0b130e5cc0fb64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring double vanity and light tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6403450011"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/e7bdad90e8b44d5d82cb52e361b7ce8b.webp"
"MediaSize" => 40318
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-e7bdad90e8b44d5d82cb52e361b7ce8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement featuring light wood-type flooring and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6403450028"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/8612fa2f974b5310db0f068dff338070.webp"
"MediaSize" => 41769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-8612fa2f974b5310db0f068dff338070.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished room with recessed lighting and light wood-type flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6403450036"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/de01030c377557d6b9113a59dfc4f0b3.webp"
"MediaSize" => 37955
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-de01030c377557d6b9113a59dfc4f0b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Below grade area featuring light wood-style floors and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6403450050"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/5234b8196a6227feb5eadccb4ed700aa.webp"
"MediaSize" => 39127
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-5234b8196a6227feb5eadccb4ed700aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spare room with light wood-style flooring and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6403450060"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/855a6f364bfb7965d7de235962aa055a.webp"
"MediaSize" => 42795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-855a6f364bfb7965d7de235962aa055a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Empty room featuring baseboards and light wood-style flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6403450069"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/421bcbb326ee8963d43b7cb2755cbbc1.webp"
"MediaSize" => 53957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-421bcbb326ee8963d43b7cb2755cbbc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring vanity and a marble finish shower"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6403450101"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/b43664ead94eb296356917a53d4658a5.webp"
"MediaSize" => 161527
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-b43664ead94eb296356917a53d4658a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fenced backyard with a patio area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
42 => array:13 [
"Order" => 42
"MediaKey" => "6403450118"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/a47562ec3da108534133d0cfc0a55435.webp"
"MediaSize" => 160093
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-a47562ec3da108534133d0cfc0a55435.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Back of house featuring a patio area, brick siding, and a chimney"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
43 => array:13 [
"Order" => 43
"MediaKey" => "6403450122"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/c8419557245feea9069096a14a2fafd1.webp"
"MediaSize" => 145674
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-c8419557245feea9069096a14a2fafd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of patio"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
44 => array:13 [
"Order" => 44
"MediaKey" => "6403450128"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/22b24b6201b7fca0fe2bb136b93e4f83.webp"
"MediaSize" => 157210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-22b24b6201b7fca0fe2bb136b93e4f83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of fenced backyard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
45 => array:13 [
"Order" => 45
"MediaKey" => "6403450133"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/57a4a1d61b3c3198d0a2e32db5a2263d.webp"
"MediaSize" => 161026
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-57a4a1d61b3c3198d0a2e32db5a2263d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rear view of house featuring a fenced backyard, a chimney, a patio area, and brick siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
46 => array:13 [
"Order" => 46
"MediaKey" => "6403450140"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/7865835bf7a3999d573112bfe0b93740.webp"
"MediaSize" => 174401
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-7865835bf7a3999d573112bfe0b93740.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fenced backyard with a storage shed"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
47 => array:13 [
"Order" => 47
"MediaKey" => "6403450143"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/22ecfde6c4c2cae1b91d4693aacbcfab.webp"
"MediaSize" => 194982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-22ecfde6c4c2cae1b91d4693aacbcfab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of fenced backyard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
48 => array:13 [
"Order" => 48
"MediaKey" => "6403450146"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247131/c9450ba68569508223d3db402f3bc98d.webp"
"MediaSize" => 141593
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247131/thumbnail-c9450ba68569508223d3db402f3bc98d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rear view of property featuring a patio, a chimney, and brick siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798306"
"ResourceRecordKey" => "29247131"
"ModificationTimestamp" => "2026-01-13T21:08:44.39Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "DON XIA"
"MemberFirstName" => "DON"
"MemberLastName" => "XIA"
"MemberMlsId" => "KWkw8015"
"OriginatingSystemName" => 26
"MemberKey" => "1970409"
"ModificationTimestamp" => "2025-12-11T01:32:02Z"
"MemberStatus" => "Active"
"OfficeKey" => "295659"
"MemberAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberFax" => "905-707-0288"
"MemberCity" => "Waterloo"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "519-591-6888"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2014-02-19T13:08:00Z"
"MemberNationalAssociationId" => "1257707"
"OfficeNationalAssociationId" => "1452740"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "Royal LePage Peaceland Realty"
"OfficePhone" => "226-666-9766"
"OfficeMlsId" => "WR50789"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "295659"
"ModificationTimestamp" => "2025-08-19T15:49:32Z"
"OfficeAddress1" => "279 Weber St. N. Unit 20A"
"OfficeCity" => "Waterloo"
"OfficePostalCode" => "N2J3H"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"OfficeFax" => "905-707-0288"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2023-11-09T14:28:00Z"
"OfficeNationalAssociationId" => "1452740"
"FranchiseNationalAssociationId" => "1146708"
"OfficeBrokerNationalAssociationId" => "1452745"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29247131')"
+"ID": "531765"
}
]
+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 295659/Office?$select=ALL&$top=10&$filter=OfficeKey eq 295659&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 295659/Office?$select=ALL&$top=10&$filter=OfficeKey eq 295659&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25345
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25347
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage Peaceland Realty"
+"OfficeEmail": null
+"OfficePhone": "226-666-9766"
+"OfficeMlsId": "WR50789"
+"ModificationTimestamp": "2025-08-19T15:49:32Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "295659"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "279 Weber St. N. Unit 20A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Waterloo"
+"OfficePostalCode": "N2J3H"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1452740"
+"OriginalEntryTimestamp": "2023-11-09T14:28:00Z"
+"OfficeFax": "905-707-0288"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "335094"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "295659"
"SocialMediaUrlOrId" => "http://www.peacelandrealty.com/"
"ModificationTimestamp" => "2025-08-19T15:26:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1452745"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('295659')"
}
]
+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 1970409/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1970409&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1970409/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1970409&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25350
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29247131" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24953
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29247131/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29247131&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29247131/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29247131&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24935
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29247131 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5659349 43.4500093)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29247131 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5659349 43.4500093)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29247131 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5659349 43.4500093)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29247131 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5659349 43.4500093)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24806
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24873
+post_id: "532256"
+post_author: 1
+"ListingKey": "29246827"
+"ListingId": "X12692386"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T20:30:15Z"
+"RFModificationTimestamp": "2026-01-13T23:46:11Z"
+"ListPrice": 1269999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1C2"
+"UnparsedAddress": "166 WESTVALE DRIVE, Waterloo, Ontario N2T1C2"
+"Coordinates": array:2 [
0 => -80.5563613
1 => 43.4504619
]
+"Latitude": 43.4504619
+"Longitude": -80.5563613
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this stunning 4+1 bedroom, 4 bathroom home, completely reimagined with high-quality construction and modern design. Offering an impressive approx 3400 square feet of finished living space, this home seamlessly blends comfort, style, and functionality. The main floor features a chef's dream kitchen with a large island and striking quartz waterfall countertop, complemented by newer appliances and an open-concept layout that's perfect for both everyday living and entertaining. A soaring foyer welcomes you into spacious living and dining areas, with a cozy gas fireplace that adds warmth and charm to the space. Upstairs, you'll find generously sized bedrooms along with an additional family living room-an ideal spot for a kids' play area, media lounge, or quiet retreat that offers even more versatility for a growing household. The fully finished basement includes a large recreation room and a private in-law suite with its own wet bar and bedroom, making it perfect for multi-generational living, or guests. Recent upgrades include a new water softener installed in 2022, updated eavestroughs in 2024, and new basement windows/window wells added the same year. New kitchen appliances (2022), new washing machine (2025). Located in a fantastic neighborhood close to scenic trails, shopping, and a wide range of amenities, this beautifully updated home is truly move-in ready and designed to suit the needs of modern living. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Microwave"
7 => "Blinds"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T23:45:55.606871+00:00"
+"Directions": "Cross Streets: Gateview Drive. ** Directions: Gateview to Westvale."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2203316"
+"ListOfficeKey": "285194"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "49.2 x 111.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-13T20:18:09Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T20:18:09Z"
+"Stories": "2.0"
+"StreetName": "Westvale"
+"StreetNumber": "166"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7797"
+"VirtualTourURLUnbranded": "https://youriguide.com/c17s5_166_westvale_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [
"RoomKey" => "1560014672"
"RoomType" => "Bathroom"
"ListingId" => "X12692386"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29246827"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.88Z"
]
1 => array:11 [
"RoomKey" => "1560014673"
"RoomType" => "Bedroom 3"
"ListingId" => "X12692386"
"RoomLevel" => "Second level"
"RoomWidth" => 2.69
"ListingKey" => "29246827"
"RoomLength" => 3.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.88Z"
]
2 => array:11 [
"RoomKey" => "1560014674"
"RoomType" => "Bedroom 4"
"ListingId" => "X12692386"
"RoomLevel" => "Second level"
"RoomWidth" => 2.69
"ListingKey" => "29246827"
"RoomLength" => 3.17
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.88Z"
]
3 => array:11 [
"RoomKey" => "1560014675"
"RoomType" => "Bedroom"
"ListingId" => "X12692386"
"RoomLevel" => "Second level"
"RoomWidth" => 5.18
"ListingKey" => "29246827"
"RoomLength" => 3.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.88Z"
]
4 => array:11 [
"RoomKey" => "1560014676"
"RoomType" => "Dining room"
"ListingId" => "X12692386"
"RoomLevel" => "Main level"
"RoomWidth" => 5.13
"ListingKey" => "29246827"
"RoomLength" => 3.17
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.88Z"
]
5 => array:11 [
"RoomKey" => "1560014677"
"RoomType" => "Great room"
"ListingId" => "X12692386"
"RoomLevel" => "Second level"
"RoomWidth" => 6.25
"ListingKey" => "29246827"
"RoomLength" => 5.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.88Z"
]
6 => array:11 [
"RoomKey" => "1560014678"
"RoomType" => "Bathroom"
"ListingId" => "X12692386"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29246827"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.88Z"
]
7 => array:11 [
"RoomKey" => "1560014679"
"RoomType" => "Bedroom"
"ListingId" => "X12692386"
"RoomLevel" => "Basement"
"RoomWidth" => 3.4
"ListingKey" => "29246827"
"RoomLength" => 3.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.89Z"
]
8 => array:11 [
"RoomKey" => "1560014680"
"RoomType" => "Other"
"ListingId" => "X12692386"
"RoomLevel" => "Basement"
"RoomWidth" => 2.26
"ListingKey" => "29246827"
"RoomLength" => 2.69
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T20:18:09.89Z"
]
9 => array:11 [
"RoomKey" => "1560014681"
"RoomType" => "Recreational, Games room"
…9
]
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": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29246827/166-westvale-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2042908"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "47312"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 49.2
+"OriginalEntryTimestamp": "2026-01-13T20:18:09.84Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29246827')"
+"ID": "532256"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24875
+post_id: "530529"
+post_author: 1
+"ListingKey": "29244370"
+"ListingId": "40797633"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T14:20:20Z"
+"RFModificationTimestamp": "2026-01-14T14:23:59Z"
+"ListPrice": 1269999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3394.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1C2"
+"UnparsedAddress": "166 WESTVALE Drive, Waterloo, Ontario N2T1C2"
+"Coordinates": array:2 [
0 => -80.5562864
1 => 43.4505816
]
+"Latitude": 43.4505816
+"Longitude": -80.5562864
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning 4+1 bedroom, 4 bathroom home, completely reimagined with high-quality construction and modern design. Offering an impressive approx 3400 square feet of finished living space, this home seamlessly blends comfort, style, and functionality. The main floor features a chef’s dream kitchen with a large island and striking quartz waterfall countertop, complemented by newer appliances and an open-concept layout that's perfect for both everyday living and entertaining. A soaring foyer welcomes you into spacious living and dining areas, with a cozy gas fireplace that adds warmth and charm to the space. Upstairs, you'll find generously sized bedrooms along with an additional family living room—an ideal spot for a kids’ play area, media lounge, or quiet retreat that offers even more versatility for a growing household. The fully finished basement includes a large recreation room and a private in-law suite with its own wet bar and bedroom, making it perfect for multi-generational living, or guests. Recent upgrades include a new water softener installed in 2022, updated eavestroughs in 2024, and new basement windows/window wells added the same year. New kitchen appliances (2022), new washing machine (2025). Located in a fantastic neighborhood close to scenic trails, shopping, and a wide range of amenities, this beautifully updated home is truly move-in ready and designed to suit the needs of modern living. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Garage door opener"
5 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T17:43:01.518119+00:00"
+"Directions": "Gateview Drive to Westvale Drive"
+"ExteriorFeatures": array:4 [
0 => "Concrete"
1 => "Aluminum siding"
2 => "Shingles"
3 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2042710"
+"ListOfficeKey": "285135"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-13T13:18:45Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T14:08:28Z"
+"Stories": "2.0"
+"StreetName": "WESTVALE"
+"StreetNumber": "166"
+"StreetSuffix": "Drive"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "7797"
+"VirtualTourURLUnbranded": "https://youriguide.com/c17s5_166_westvale_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
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]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29244370/166-westvale-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 49.0
+"AboveGradeFinishedArea": 2411
+"BelowGradeFinishedArea": 983
+"OriginalEntryTimestamp": "2026-01-13T13:18:45.54Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29244370')"
+"ID": "530529"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24876
+post_id: "528194"
+post_author: 1
+"ListingKey": "29242090"
+"ListingId": "40797739"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T21:55:42Z"
+"RFModificationTimestamp": "2026-01-14T22:03:36Z"
+"ListPrice": 1050000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3132.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2M9"
+"UnparsedAddress": "508 RHEINLAND Place, Waterloo, Ontario N2V2M9"
+"Coordinates": array:2 [
0 => -80.5821652
1 => 43.4593802
]
+"Latitude": 43.4593802
+"Longitude": -80.5821652
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "O.H. Sat. (1-3) & Sun (2-4). Welcome to 508 Rheinland Place. A custom all-brick bungalow in desirable Clair Hills with southern exposure & greenbelt nature backdrop, offering privacy, abundant natural light & long-term livability. With a separate side entrance, the home pairs a w/o lower level with a flexible flr plan that can function as a two-bedroom in-law suite or integrate seamlessly as an extended living space. The main level is carpet-free & features maple hardwd, porcelain tile, granite countertops, 9-foot ceilings, crown mouldings & a smart kitchen with a full wall pantry. The layout emphasizes easy movement with wider hallways, an oversized foyer & double glass doors to the primary suite. Two sets of garden drs lead to a composite deck extending the living space outdoors to enjoy uninterrupted views of nature. A four-foot-wide staircase leads to the bright walk-out lower level, where large windows & garden drs maintain a strong connection to the greenspace. A generous kitchen with a built-in desk, a two-sided gas fireplace with custom cabinetry, & two bedrooms form a complete second residence suited for guests, in-law family, or multi-generational living, and the layout supports those planning ahead for mobility or aging in place. Outside, the property is fully landscaped front and back. Stamped concrete & stonework define low-maintenance, structured gardens with layered plantings tuned to sunlight and all four seasons. Beneath the deck, a sheltered patio provides covered storage and a shed with room for gardening tools & equipment. Southern exposure fills both levels with an abundance of natural light, while offering a quiet green backdrop & nature views at every turn. A rare blend of lot, exposure and flexibility delivering privacy, comfort & a layout that fits many chapters of life. From the street, the home presents as a classic bungalow; once inside, its generous footprint & dual-level layout reveal significantly more space than meets the eye. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-12T21:06:52.798144+00:00"
+"Directions": "Erbsville Rd to Columbia St. W. to Rheinland Place"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564736"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:7 [
0 => "Cul-de-sac"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Paved driveway"
4 => "Sump Pump"
5 => "Automatic Garage Door Opener"
6 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T21:41:24Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T21:48:43Z"
+"Stories": "1.0"
+"StreetName": "RHEINLAND"
+"StreetNumber": "508"
+"StreetSuffix": "Place"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5987"
+"View": "View of water"
+"VirtualTourURLUnbranded": "https://youriguide.com/508_rheinland_place_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
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]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29242090/508-rheinland-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 34.0
+"AboveGradeFinishedArea": 1583
+"BelowGradeFinishedArea": 1549
+"OriginalEntryTimestamp": "2026-01-12T20:29:47.08Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29242090')"
+"ID": "528194"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24888
+post_id: "526023"
+post_author: 1
+"ListingKey": "29238347"
+"ListingId": "X12684612"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-11T16:20:37Z"
+"RFModificationTimestamp": "2026-01-11T16:30:24Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2J7"
+"UnparsedAddress": "BSMT - 528 VALHALLA CRESCENT, Waterloo, Ontario N2T2J7"
+"Coordinates": array:2 [
0 => -80.5696359
1 => 43.453394
]
+"Latitude": 43.453394
+"Longitude": -80.5696359
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Spacious, bright and newly build 2-bedroom, 1-bathroom legal basement suite. Once you stepped in you will hardly get basement feeling. This Unit offers modern comfort and quality craftsmanship in the sought-after Waterloo West beechwood community. Designed with upgraded finishes throughout, this high Ceiling suite features an open-concept layout, a contemporary kitchen with appliances, stylish lighting, accent wall and vinyl flooring. Enjoy living in a family-friendly community surrounded by parks, trails, and top-rated schools. You would really appreciate the convenience of being just minutes from The Boardwalk, Costco, and both universities, with public transit steps from your door for easy commuting. This rental opportunity provides the perfect blend of modern living and everyday convenience in this beautifully upgraded home. As a bonus one driveway parking included. Ideal for small family but open for nice students who can share the room. 1850+25% utilities. No Pet!!! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Apartment in basement"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-11T16:30:22.650569+00:00"
+"Directions": "Erbsville Rd & Erb St W"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2127635"
+"ListOfficeKey": "238732"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-11T16:12:10Z"
+"PhotosCount": 9
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-11T16:12:10Z"
+"Stories": "2.0"
+"StreetName": "Valhalla"
+"StreetNumber": "528"
+"StreetSuffix": "Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29238347/bsmt-528-valhalla-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 1850
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-11T16:12:10.72Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:9 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
]
+"Member": []
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29238347')"
+"ID": "526023"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24874
+post_id: "525437"
+post_author: 1
+"ListingKey": "29237600"
+"ListingId": "40797604"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-10T20:31:03Z"
+"RFModificationTimestamp": "2026-01-10T20:34:29Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1050.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0J1"
+"UnparsedAddress": "D58-142 N FOAMFLOWER Common, Waterloo, Ontario N2V0J1"
+"Coordinates": array:2 [
0 => -80.5903072
1 => 43.4496086
]
+"Latitude": 43.4496086
+"Longitude": -80.5903072
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Spacious 1,050 sq. ft. ground-floor apartment in a prime Waterloo location. This well-maintained unit features a functional layout with 2 large bedrooms and 2 full bathrooms. The modern kitchen offers ample storage and opens into a bright, oversized living area with access to a private balcony boasting scenic views. Additional Storage room with ZEBRA blinds in all areas. Rare find with 2 dedicated parking spots and high-speed internet included in the rent! Unit have installed water filter! Conveniently situated behind Costco, just 3km from Wilfrid Laurier University, 5km from the University of Waterloo and next to Vista Hills Public School with top-rated elementary school ranking. Close to major shopping, dining, and transit hubs. Move-in ready and easy to show. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-10T19:46:00.618582+00:00"
+"Directions": "Columbia Street to Ladyslipper Place to Foamflower Place"
+"ExteriorFeatures": array:3 [
0 => "Stucco"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2203844"
+"ListOfficeKey": "290392"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"PhotosChangeTimestamp": "2026-01-10T19:29:44Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-10T20:18:40Z"
+"StreetName": "FOAMFLOWER"
+"StreetNumber": "58"
+"StreetSuffix": "Place"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29237600/d58-142-foamflower-place-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2450
+"ZoningDescription": "R6 R6-FT"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1050
+"OriginalEntryTimestamp": "2026-01-10T19:29:44.36Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:23 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29237600')"
+"ID": "525437"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24884
+post_id: "524039"
+post_author: 1
+"ListingKey": "29234905"
+"ListingId": "40795864"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-10T14:31:02Z"
+"RFModificationTimestamp": "2026-01-10T14:35:11Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1200.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L1W7"
+"UnparsedAddress": "401 ERB Street W Unit# 301, Waterloo, Ontario N2L1W7"
+"Coordinates": array:2 [
0 => -80.5510293
1 => 43.4527592
]
+"Latitude": 43.4527592
+"Longitude": -80.5510293
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this extra large 2 bedroom, 2 bathroom condo close to the universities in Waterloo with easy access to Kitchener. This well cared for, quiet and clean building boasts large units not normally found in today's market! Primary bedroom includes a convenient ensuite 2 piece bathroom all to itself. Large rooms carry you through to good sized kitchen, big living room and separate dining area. Generous balcony includes room for furniture and quiet summer nights. Tired of tiny condos with limited space? This might just be the one for you! Book your private viewing today. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "660"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-01-09T23:54:40.322755+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1951359"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"PhotosChangeTimestamp": "2026-01-09T19:39:36Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-10T14:18:27Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "ERB"
+"StreetNumber": "401"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "2621.8"
+"Utilities": array:1 [
0 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://iguidephotos.com/301_401_erb_st_w_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29234905/401-erb-street-w-unit-301-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1563756"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "289722"
+"GeocodeManualYN": true
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1200
+"OriginalEntryTimestamp": "2026-01-09T19:39:36.43Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"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]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29234905')"
+"ID": "524039"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23498
+post_id: "521600"
+post_author: 1
+"ListingKey": "29232281"
+"ListingId": "X12678880"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T02:25:09Z"
+"RFModificationTimestamp": "2026-01-09T02:26:25Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5S7"
+"UnparsedAddress": "2 - 433 KEATS WAY, Waterloo, Ontario N2L5S7"
+"Coordinates": array:2 [
0 => -80.557083
1 => 43.458011
]
+"Latitude": 43.458011
+"Longitude": -80.557083
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Amazing opportunity to lease in the highly sought-after Beechwood area, offering exceptional access to shopping, transit, and the University of Waterloo campus. This spacious 3-bedroom home checks all the boxes and showcases numerous upgrades, including bamboo hardwood flooring on the main and second levels, tasteful kitchen finishes, and a wet bar/summer kitchen in the finished basement. The exterior features a dedicated parking space and a large, fully fenced, landscaped backyard-perfect for outdoor enjoyment. A fantastic leasing opportunity in a prime location at excellent value in today's market. (id:62650)"
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T02:26:19.781275+00:00"
+"Directions": "Fischer Hallman"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1906649"
+"ListOfficeKey": "146431"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Carport"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T02:12:00Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T02:12:00Z"
+"Stories": "2.0"
+"StreetName": "Keats"
+"StreetNumber": "433"
+"StreetSuffix": "Way"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29232281/2-433-keats-way-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Weigel Prop Management"
+"GeocodeManualYN": false
+"TotalActualRent": 2400
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-09T01:40:13.15Z"
+"MapCoordinateVerifiedYN": false
+"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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29232281')"
+"ID": "521600"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24881
+post_id: "521503"
+post_author: 1
+"ListingKey": "29232199"
+"ListingId": "40796948"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T01:40:09Z"
+"RFModificationTimestamp": "2026-01-09T01:42:28Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1285.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5S7"
+"UnparsedAddress": "433 KEATS Way Unit# 2, Waterloo, Ontario N2L5S7"
+"Coordinates": array:2 [
0 => -80.5570764
1 => 43.4580334
]
+"Latitude": 43.4580334
+"Longitude": -80.5570764
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Amazing opportunity to lease in the highly sought-after Beechwood area, offering exceptional access to shopping, transit, and the University of Waterloo campus. This spacious 3-bedroom home checks all the boxes and showcases numerous upgrades, including bamboo hardwood flooring on the main and second levels, tasteful kitchen finishes, and a wet bar/summer kitchen in the finished basement. The exterior features a dedicated parking space and a large, fully fenced, landscaped backyard-perfect for outdoor enjoyment. A fantastic leasing opportunity in a prime location at excellent value in today's market. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T01:35:40.295606+00:00"
+"Directions": "Fischer Hallman"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2224068"
+"ListOfficeKey": "289628"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-01-09T01:29:14Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T01:29:14Z"
+"Stories": "2.0"
+"StreetName": "KEATS"
+"StreetNumber": "433"
+"StreetSuffix": "Way"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2281"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29232199/433-keats-way-unit-2-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2095641"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "284587"
+"GeocodeManualYN": true
+"TotalActualRent": 2400
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1285
+"OriginalEntryTimestamp": "2026-01-09T01:00:24.82Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:12 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29232199')"
+"ID": "521503"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25198
+post_id: "521065"
+post_author: 1
+"ListingKey": "29231368"
+"ListingId": "X12678026"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-08T21:50:28Z"
+"RFModificationTimestamp": "2026-01-08T22:46:00Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2N0C5"
+"UnparsedAddress": "B12 - 1331 COUNTRYSTONE DRIVE, Kitchener, Ontario N2N0C5"
+"Coordinates": array:2 [
0 => -80.557389
1 => 43.43517
]
+"Latitude": 43.43517
+"Longitude": -80.557389
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Ideal for professionals, couples, or anyone seeking low-maintenance living, this modern multi-level stacked townhome offers comfort, convenience, and style. The main floor features an open-concept kitchen and living area, a convenient powder room, and access to a private balcony. Upstairs, enjoy a spacious primary bedroom, full bathroom, in-suite laundry, and a second balcony-perfect for morning coffee or evening relaxation. Additional perks include one designated parking space and extra storage within the private entry stairway. Located close to shopping, restaurants, parks, and transit, this home offers exceptional lifestyle convenience. Move-in ready-schedule your viewing today! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-08T22:45:49.991596+00:00"
+"Directions": "Cross Streets: Ira Needles & University. ** Directions: Univesity to Countrystone Drive."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2075358"
+"ListOfficeKey": "252772"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-08T21:41:26Z"
+"PhotosCount": 17
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-08T21:41:26Z"
+"StreetName": "Countrystone"
+"StreetNumber": "1331"
+"StreetSuffix": "Drive"
+"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/29231368/b12-1331-countrystone-drive-kitchener"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Weigel Management"
+"GeocodeManualYN": false
+"TotalActualRent": 1850
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-08T21:41:26.13Z"
+"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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29231368')"
+"ID": "521065"
}
]
+success: true
+page_size: 9
+page_count: 10
+count: 84
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
]