array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30081476 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23584
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23586
+post_id: "1661741"
+post_author: 1
+"ListingKey": "30081476"
+"ListingId": "40851151"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-27T14:15:13Z"
+"RFModificationTimestamp": "2026-07-27T17:27:48Z"
+"ListPrice": 949900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2680.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2M9"
+"UnparsedAddress": "530 RHEINLAND Place, Waterloo, Ontario N2V2M9"
+"Coordinates": array:2 [
0 => -80.5819163
1 => 43.4600792
]
+"Latitude": 43.4600792
+"Longitude": -80.5819163
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 530 Rhineland Place, a truly custom-designed bungalow tucked away on a quiet crescent in Waterloo’s desirable Columbia Forest neighbourhood. From the moment you enter, the quality of the home is immediately apparent. Bright, thoughtfully designed living spaces are complemented by hardwood and porcelain flooring throughout the main level, custom built-in cabinetry, striking architectural details and carefully selected lighting that gives the home a refined, gallery-like feel. The spacious primary suite offers a comfortable private retreat with dual closets, and a beautifully finished ensuite. Every closet throughout the home has been designed with function and organization in mind, while built-in cabinetry on the main floor provides additional storage without compromising the clean, elegant design. The kitchen and bathrooms showcase stone countertops and quality finishes, with remarkable attention paid to every surface and detail. Natural light fills the home, creating a warm and inviting atmosphere throughout the principal rooms. The fully finished lower level offers exceptional additional living space, including a large recreation room, guest bedroom, office area, full bathroom, extensive closet storage and a generous laundry room (2025 washer/dryer). Whether hosting family, working from home or creating a private space for overnight guests, the lower level provides impressive versatility. (Furnace/AC 2020) Outside, the fully landscaped backyard has been designed for low-maintenance enjoyment. A covered porch and deck create a comfortable outdoor living area, while the mature landscaping provides privacy and a beautiful setting throughout the seasons. Additional features include a double garage, close to trails, parks, schools and the amenities of west Waterloo, roof and fascia 2020. 530 Rhineland Place is a rare opportunity to own a bungalow where thoughtful design, craftsmanship and everyday functionality come together beautifully. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-27T17:27:43.219166+00:00"
+"ExteriorFeatures": array:2 [
0 => "Steel"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2068773"
+"ListOfficeKey": "259258"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-27T14:09:27Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-27T14:09:26Z"
+"Stories": "1.0"
+"StreetName": "RHEINLAND"
+"StreetNumber": "530"
+"StreetSuffix": "Place"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5110"
+"VirtualTourURLUnbranded": "https://youriguide.com/530_rheinland_place_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1694554643"
"RoomType" => "Den"
"ListingId" => "40851151"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30081476"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:09:26.98Z"
]
1 => array:11 [
"RoomKey" => "1694554644"
"RoomType" => "3pc Bathroom"
"ListingId" => "40851151"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30081476"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:09:26.98Z"
]
2 => array:11 [
"RoomKey" => "1694554645"
"RoomType" => "Utility room"
"ListingId" => "40851151"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30081476"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:09:26.98Z"
]
3 => array:11 [
"RoomKey" => "1694554646"
"RoomType" => "Recreation room"
"ListingId" => "40851151"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30081476"
"RoomLength" => null
"RoomDimensions" => "19'8'' x 23'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:09:26.98Z"
]
4 => array:11 [
"RoomKey" => "1694554647"
"RoomType" => "Laundry room"
"ListingId" => "40851151"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30081476"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 16'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:09:26.98Z"
]
5 => array:11 [
"RoomKey" => "1694554648"
"RoomType" => "Bedroom"
"ListingId" => "40851151"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30081476"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:09:26.98Z"
]
6 => array:11 [
"RoomKey" => "1694554649"
"RoomType" => "2pc Bathroom"
"ListingId" => "40851151"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "30081476"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:09:26.98Z"
]
7 => array:11 [
"RoomKey" => "1694554650"
"RoomType" => "Bedroom"
"ListingId" => "40851151"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30081476"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:09:26.98Z"
]
8 => array:11 [
"RoomKey" => "1694554651"
"RoomType" => "Full bathroom"
"ListingId" => "40851151"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30081476"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:09:26.98Z"
]
9 => array:11 [
"RoomKey" => "1694554652"
"RoomType" => "Primary Bedroom"
"ListingId" => "40851151"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30081476"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 21'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:09:26.98Z"
]
10 => array:11 [
"RoomKey" => "1694554653"
"RoomType" => "Dining room"
"ListingId" => "40851151"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30081476"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:09:26.98Z"
]
11 => array:11 [
"RoomKey" => "1694554654"
"RoomType" => "Foyer"
"ListingId" => "40851151"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30081476"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:09:26.98Z"
]
12 => array:11 [
"RoomKey" => "1694554655"
"RoomType" => "Living room"
"ListingId" => "40851151"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30081476"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 19'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:09:26.98Z"
]
13 => array:11 [
"RoomKey" => "1694554656"
"RoomType" => "Kitchen"
"ListingId" => "40851151"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30081476"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:09:26.99Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30081476/530-rheinland-place-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 39.0
+"AboveGradeFinishedArea": 1356
+"BelowGradeFinishedArea": 1324
+"OriginalEntryTimestamp": "2026-07-27T14:09:26.96Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1343939"
+"ListOfficeNationalAssociationId": "1217708"
+"Media": array:42 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30081476_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/487734742507ec416aafb60e45f49edf.webp"
"MediaSize" => 111962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-487734742507ec416aafb60e45f49edf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stone-clad exterior featuring a prominent gabled roofline, an integrated garage with transom windows, a concrete driveway, and established front landscaping"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30081476_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/ca201b87d6a9a0c77562d446f95196f4.webp"
"MediaSize" => 130489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-ca201b87d6a9a0c77562d446f95196f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stone facade residence featuring an attached garage with window inserts, a paved driveway, and mature landscaping"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30081476_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/d19d4278daaf86f6b5a13344ad370038.webp"
"MediaSize" => 66534
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-d19d4278daaf86f6b5a13344ad370038.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring tiled flooring, crown molding, and a transom window above the front door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30081476_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/b1c128ac14a2371d46c35260e2002193.webp"
"MediaSize" => 65861
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-b1c128ac14a2371d46c35260e2002193.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring neutral wall tones, crown molding, recessed lighting, and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30081476_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/5215b0e95dfa43b48fdcf91179b75ebe.webp"
"MediaSize" => 93399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-5215b0e95dfa43b48fdcf91179b75ebe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring an array of windows, crown molding, recessed lighting, and gas fire place"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30081476_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/c1ef79becb0f2d628609eac50caa8554.webp"
"MediaSize" => 69131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-c1ef79becb0f2d628609eac50caa8554.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive tiled flooring spans open-concept living spaces"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30081476_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/ce19730730c96288c99eaac488451ed4.webp"
"MediaSize" => 79528
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-ce19730730c96288c99eaac488451ed4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept layout featuring light-toned porcelain flooring throughout"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30081476_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/306c1df6b6663ef88e6a0217f6688b80.webp"
"MediaSize" => 90286
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-306c1df6b6663ef88e6a0217f6688b80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring wood cabinetry, stainless steel appliances, granite countertops, tile backsplash, and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30081476_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/305ca05a4742dc0947ff79de922c516a.webp"
"MediaSize" => 83814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-305ca05a4742dc0947ff79de922c516a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen counter featuring a dual stainless steel sink, a stone-finish countertop, and light wood-finish cabinetry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30081476_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/085735bdd5256e563a0ea7390e4e1bec.webp"
"MediaSize" => 46449
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-085735bdd5256e563a0ea7390e4e1bec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Designer layout"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30081476_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/1d676ca065e0580289a5582871059672.webp"
"MediaSize" => 96169
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-1d676ca065e0580289a5582871059672.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious dining area with porcelain flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30081476_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/0d7713cfa3a163f1d0f11ed9a2da7a67.webp"
"MediaSize" => 89434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-0d7713cfa3a163f1d0f11ed9a2da7a67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Custom built in cabinets, crown molding, built-in shelving, recessed lighting, and sliding glass doors opening to covered deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30081476_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/a35fab8e966e4018d85d6792ac0945ff.webp"
"MediaSize" => 86736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-a35fab8e966e4018d85d6792ac0945ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring tile flooring, built-in shelving, recessed lighting, and crown molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30081476_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/6c23172b5de2912ca0be6afd7f08d1e5.webp"
"MediaSize" => 78105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-6c23172b5de2912ca0be6afd7f08d1e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with an arched pass-through to a breakfast bar, recessed lighting, tile flooring, and stainless steel appliances"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30081476_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/74481c01c83b7be4a235b4d77a556098.webp"
"MediaSize" => 106520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-74481c01c83b7be4a235b4d77a556098.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive living area with crown molding, recessed lighting, and large windows with transom details"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30081476_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/ab66ec47aa42582e7aa4489117494d37.webp"
"MediaSize" => 85429
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-ab66ec47aa42582e7aa4489117494d37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hardwood flooring extends throughout this room, featuring vaulted ceilings and crown molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30081476_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/05f994185ec3c352b41849ae126f629c.webp"
"MediaSize" => 94291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-05f994185ec3c352b41849ae126f629c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring wood-finish flooring, crown molding, professionally designed"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30081476_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/aa48aef20e97fdb6ec88ae6cf3e65bd6.webp"
"MediaSize" => 71799
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-aa48aef20e97fdb6ec88ae6cf3e65bd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30081476_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/00b25273dff303200aef6e79c95620e8.webp"
"MediaSize" => 77356
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-00b25273dff303200aef6e79c95620e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "4 piece bathroom past double closets"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30081476_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/39a252a1a553005f41454852e5a69736.webp"
"MediaSize" => 91872
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-39a252a1a553005f41454852e5a69736.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom or mainfloor office featuring wood flooring, a ceiling fan, crown molding, custom closet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30081476_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/4f46e69f26f73ea10964da6d1851c37e.webp"
"MediaSize" => 56264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-4f46e69f26f73ea10964da6d1851c37e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Wood-finish staircase with natural wood balusters, step lighting."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30081476_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/a621c810c503d46de6e507a51b3a9c44.webp"
"MediaSize" => 54714
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-a621c810c503d46de6e507a51b3a9c44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Powder room. Custom Vanity"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30081476_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/5efaeae51972e352f8bd193451bc9b21.webp"
"MediaSize" => 68922
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-5efaeae51972e352f8bd193451bc9b21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office space with built in closets"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30081476_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/1d26f2930dd4b736f5481985ada0d52c.webp"
"MediaSize" => 56474
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-1d26f2930dd4b736f5481985ada0d52c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated workstation featuring built-in shelving and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30081476_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/ff01e0efa1ab55f8276b794d0c093e42.webp"
"MediaSize" => 66067
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-ff01e0efa1ab55f8276b794d0c093e42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lower level living space featuring Italian recessed lighting, carpeting, and multiple windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30081476_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/1d9fa356b4325e971a3f81690b56b268.webp"
"MediaSize" => 67828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-1d9fa356b4325e971a3f81690b56b268.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious lower-level area with recessed lighting, neutral carpeting, half tone designer painting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30081476_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/45ed05edfd36f26342287faadcc3dce2.webp"
"MediaSize" => 61948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-45ed05edfd36f26342287faadcc3dce2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "In wall plumbing for bar on far side"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30081476_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/5a629fb9f57b7a7f5104e9eb13434bd1.webp"
"MediaSize" => 63566
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-5a629fb9f57b7a7f5104e9eb13434bd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Natural Half tone painted."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30081476_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/883e12cc37d7dff5a2a3e6c6a3ceecb4.webp"
"MediaSize" => 73587
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-883e12cc37d7dff5a2a3e6c6a3ceecb4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted bedroom featuring neutral wall tones, large window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30081476_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/e6b228a2bc91cface799cb2f694efccd.webp"
"MediaSize" => 41941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-e6b228a2bc91cface799cb2f694efccd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom vanity created by local artist and custom cabinets"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30081476_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/3c90ac4444e674af774feffe764f4fb0.webp"
"MediaSize" => 63470
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-3c90ac4444e674af774feffe764f4fb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Walk-in shower featuring neutral-toned tile walls, a white shower pan, a wall-mounted showerhead, and chrome grab bars"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30081476_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/72322982b5095d92caab55397768ed9b.webp"
"MediaSize" => 79867
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-72322982b5095d92caab55397768ed9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry area featuring a utility sink, large capacity washer and dryer, and overhead storage shelving"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30081476_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/d6aff9f324ba4de5d0d27b8366fedcb8.webp"
"MediaSize" => 144796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-d6aff9f324ba4de5d0d27b8366fedcb8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "two level deck with low maintenance gardening"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30081476_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/59b6067c147e6f2dc65e9f6bcb134bd0.webp"
"MediaSize" => 136269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-59b6067c147e6f2dc65e9f6bcb134bd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30081476_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/df92a5bc1b4f44c40231a068b4470ffe.webp"
"MediaSize" => 170166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-df92a5bc1b4f44c40231a068b4470ffe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "30081476_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/1598be8c30306c73b574363a10d97424.webp"
"MediaSize" => 153382
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-1598be8c30306c73b574363a10d97424.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "30081476_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/e8746c2cdedc5ffc44665bab26f5015a.webp"
"MediaSize" => 153195
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-e8746c2cdedc5ffc44665bab26f5015a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Multi-level outdoor living space featuring a wooden deck, stone patio, mature landscaping, and a covered porch"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "30081476_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/dcab51e3d0bc02bbf77dd0c52667b26f.webp"
"MediaSize" => 131370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-dcab51e3d0bc02bbf77dd0c52667b26f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stone facade home featuring a two-car garage, concrete driveway, welcoming front porch, and mature landscaping"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "30081476_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/c0c5604c73d3c411995bf3e8939013c1.webp"
"MediaSize" => 178755
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-c0c5604c73d3c411995bf3e8939013c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Relaxing swing with stone no mow back yard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "30081476_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/cc12f657d2122e6d1dff8b2694f80477.webp"
"MediaSize" => 100161
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-cc12f657d2122e6d1dff8b2694f80477.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Park like manicured central island on quite crescent."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "30081476_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/141b6e2f758eebf30bf2d3f7e3219640.webp"
"MediaSize" => 51683
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-141b6e2f758eebf30bf2d3f7e3219640.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "30081476_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081476/ff13a55bb5de884465695a3822b6e960.webp"
"MediaSize" => 45057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081476/thumbnail-ff13a55bb5de884465695a3822b6e960.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851151"
"ResourceRecordKey" => "30081476"
"ModificationTimestamp" => "2026-07-27T14:09:26.96Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30081476')"
+"ID": "1661741"
}
]
+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 259258" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25086
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25029
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "MCINTYRE REAL ESTATE SERVICES INC."
+"OfficeEmail": null
+"OfficePhone": "519-342-6550"
+"OfficeMlsId": "KW284"
+"ModificationTimestamp": "2026-06-08T22:13:04Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "259258"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "368 ASH TREE PLACE"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "WATERLOO"
+"OfficePostalCode": "N2T1R"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1217708"
+"OriginalEntryTimestamp": "2010-11-23T18:33:00Z"
+"OfficeFax": "519-954-7575"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeBrokerNationalAssociationId": "1140384"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('259258')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2068773" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25109
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30081476'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25414
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30081476' AND OpenHouseDate ge '2026-07-27'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25430
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30081476' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5819163 43.4600792)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25503
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25477
+post_id: "1660126"
+post_author: 1
+"ListingKey": "30080034"
+"ListingId": "40851156"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-28T00:15:05Z"
+"RFModificationTimestamp": "2026-07-28T00:19:03Z"
+"ListPrice": 939999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2397.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2T5"
+"UnparsedAddress": "425 SPECKLED ALDER Street, Waterloo, Ontario N2V2T5"
+"Coordinates": array:2 [
0 => -80.5935659
1 => 43.4690718
]
+"Latitude": 43.4690718
+"Longitude": -80.5935659
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 425 Speckled Alder St, a stunning two-storey residence nestled in one of Waterloo's most desirable neighborhoods. Offering 1,742 sq ft of beautifully designed living space above grade, plus a fully finished 655 sq ft basement, for a total of 2,397 sq ft, this home is perfectly suited for growing families and those who love to entertain. Step inside to a bright and inviting open-concept main floor, anchored by a spacious living room featuring a cozy gas fireplace, the perfect setting for relaxing evenings or hosting guests. The convenience of main floor laundry adds to the home's thoughtful functionality. Freshly and recently painted throughout, this home is truly move-in ready, and a deck (2022) offers the ideal space for outdoor gatherings and summer evenings. Upstairs, you'll find four generously sized bedrooms, including an impressive master retreat with a private ensuite. The finished basement offers versatile space for entertaining or accommodating guests, complete with a stylish 4-piece bathroom. Location is everything, and this home delivers: enjoy the convenience of being within walking distance to Abraham Erb Public School, St. Nicholas Catholic Elementary School, and Laurel Heights Secondary School, a rare offering for families. Nearby, the Laurelwood Commons shopping plaza provides everyday essentials including Food Basics, Dollarama, Shoppers Drug Mart, and more, all just steps away. Transit is easily accessible with a nearby bus stop, and nature lovers will appreciate the scenic walking trails right at your doorstep. For added lifestyle appeal, this home is also close to the YMCA, Costco, the public library, and beautiful conservation areas, offering the perfect balance of comfort, convenience, and community. This exceptional property is ready to welcome its next chapter. Don't miss the opportunity to make 425 Speckled Alder St your forever home. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Garage door opener"
9 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-26T00:44:49.737530+00:00"
+"Directions": "Wild Ginger & Blue Beech"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100095"
+"ListOfficeKey": "291992"
+"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-07-27T23:51:39Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-28T00:08:22Z"
+"Stories": "2.0"
+"StreetName": "SPECKLED ALDER"
+"StreetNumber": "425"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5179"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1695095799"
"RoomType" => "Utility room"
"ListingId" => "40851156"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30080034"
"RoomLength" => null
"RoomDimensions" => "6'7'' x 9'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-28T00:08:22.23Z"
]
1 => array:11 [
"RoomKey" => "1695095800"
"RoomType" => "4pc Bathroom"
"ListingId" => "40851156"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30080034"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-28T00:08:22.23Z"
]
2 => array:11 [
"RoomKey" => "1695095801"
"RoomType" => "Bedroom"
"ListingId" => "40851156"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30080034"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 18'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-28T00:08:22.23Z"
]
3 => array:11 [
"RoomKey" => "1695095802"
"RoomType" => "4pc Bathroom"
"ListingId" => "40851156"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30080034"
"RoomLength" => null
"RoomDimensions" => "7'5'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-28T00:08:22.23Z"
]
4 => array:11 [
"RoomKey" => "1695095803"
"RoomType" => "Full bathroom"
"ListingId" => "40851156"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30080034"
"RoomLength" => null
"RoomDimensions" => "4'10'' x 5'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-28T00:08:22.23Z"
]
5 => array:11 [
"RoomKey" => "1695095804"
…10
]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30080034/425-speckled-alder-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RES"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1742
+"BelowGradeFinishedArea": 655
+"OriginalEntryTimestamp": "2026-07-25T23:28:22.38Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1370209"
+"ListOfficeNationalAssociationId": "1407252"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30080034')"
+"ID": "1660126"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25498
+post_id: "1658131"
+post_author: 1
+"ListingKey": "30077696"
+"ListingId": "40850819"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T21:15:06Z"
+"RFModificationTimestamp": "2026-07-24T22:57:09Z"
+"ListPrice": 729900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.12
+"LivingArea": 1793.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P1"
+"UnparsedAddress": "742 BROOKMILL Place, Waterloo, Ontario N2V2P1"
+"Coordinates": array:2 [
0 => -80.5832973
1 => 43.4752075
]
+"Latitude": 43.4752075
+"Longitude": -80.5832973
+"YearBuilt": 2000
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Positioned at the end of a quiet cul-de-sac in Waterloo's sought-after Laurelwood neighbourhood, this beautifully maintained home sits on a pie-shaped lot backing onto a conservation area with no rear neighbours. Offering 1,230 sq. ft. above grade and nearly 1,800 sq. ft. of finished living space, this smoke-free, pet-free home features 3 bedrooms, 2 bathrooms, and a finished basement with a rough-in for an additional bathroom. The bright, open-concept main floor features hardwood flooring and a spacious Great Room with soaring cathedral ceilings and views of the forest beyond. Upstairs, the generous primary bedroom offers cheater ensuite access, while two additional bedrooms provide room for family, guests, or a home office. The finished basement includes a bright recreation room, laundry and mechanical area, storage, and a rough-in for a future 2-piece bathroom. Outside, the pie-shaped backyard is a great place to unwind or entertain, with a multi-level, surrounded by trees. Recent updates include an RO water system (2026), broadloom in the basement and on the upper stairs (2026), kitchen faucet (2025), upper bathroom sink and faucet (2025), and washer and dryer (2024). Located close to excellent schools, parks, walking trails, shopping, the YMCA, library, and both universities, this is a wonderful opportunity to own a home in the heart of Laurelwood. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T22:56:59.691498+00:00"
+"Directions": "West on Laurelwood from Fischer-Hallman, then north on Brookmill Pl."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981704"
+"ListOfficeKey": "289890"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T21:08:19Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T21:08:19Z"
+"Stories": "2.0"
+"StreetName": "BROOKMILL"
+"StreetNumber": "742"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5213.43"
+"VirtualTourURLUnbranded": "https://youriguide.com/v6F5Z6CD5V8DD1/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30077696/742-brookmill-place-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 22.0
+"AboveGradeFinishedArea": 1230
+"BelowGradeFinishedArea": 563
+"OriginalEntryTimestamp": "2026-07-24T21:08:18.99Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1267102"
+"ListOfficeNationalAssociationId": "1382470"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30077696')"
+"ID": "1658131"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25476
+post_id: "1654553"
+post_author: 1
+"ListingKey": "30073974"
+"ListingId": "X13600694"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T03:40:01Z"
+"RFModificationTimestamp": "2026-07-24T04:37:45Z"
+"ListPrice": 990000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2W4"
+"UnparsedAddress": "735 KARLSFELD ROAD, Waterloo, Ontario N2T2W4"
+"Coordinates": array:2 [
0 => -80.57791
1 => 43.456617
]
+"Latitude": 43.456617
+"Longitude": -80.57791
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Nestled in the heart of Clair Hills, this bright and spacious home offers the perfect blend ofcomfort, nature, and community. Located just steps from scenic walking trails and a charmingneighbourhood park, the area is known for a very friendly, respectful atmosphere and top-ratedschools.This well-designed two-story home features an open-concept layout with 4 bedrooms, 3 bathrooms,and a 2-car garage plus a double driveway accommodating up to 4 vehicles.The main floor is ideal for both everyday living and entertaining. A generous living and diningarea flows seamlessly into a warm and inviting family room with large windows and a cozy gasfireplace. The kitchen offers ample cabinetry, an open connection to the family room, and apleasant view right from the kitchen sink window.Step outside to enjoy a southwest-facing deck overlooking the open area - perfect for relaxingevenings and sunsets.Upstairs, you'll find four spacious bedrooms, each with a good size closets. The primary suite features abundant natural light, a walk-in closet, and a private ensuite bathroom complete with a tub, separate shower, and oversized vanity.Unfinished basement has big windows and walk-in backyard entry, good for storage or as a fitness equipment room.Conveniently located just minutes from major amenities including Costco and T&T Supermarket, as well as top institutions such as University of Waterloo and Wilfrid Laurier University.This home is ideal for families seeking space, comfort, and a peaceful, nature-connected lifestyle. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"Basement": array:4 [
0 => "Unfinished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T04:37:35.038256+00:00"
+"Directions": "Cross Streets: Keats Way and Erbsville Rd. ** Directions: Erbsville Rd to Keats Way to Karlsfeld Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Tile"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1623242"
+"ListOfficeKey": "300429"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "34 x 128 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T03:32:27Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T03:32:27Z"
+"Stories": "2.0"
+"StreetName": "Karlsfeld"
+"StreetNumber": "735"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6359.23"
+"VirtualTourURLUnbranded": "https://view.tours4listings.com/cp/735-karlsfeld-road-waterloo/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30073974/735-karlsfeld-road-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 34.0
+"OriginalEntryTimestamp": "2026-07-24T03:32:27.72Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1160967"
+"ListOfficeNationalAssociationId": "1487853"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30073974')"
+"ID": "1654553"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25500
+post_id: "1652383"
+post_author: 1
+"ListingKey": "30071331"
+"ListingId": "X13598432"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-27T12:20:07Z"
+"RFModificationTimestamp": "2026-07-27T12:21:46Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V1"
+"UnparsedAddress": "519 YORKSHIRE DRIVE, Waterloo, Ontario N2T2V1"
+"Coordinates": array:2 [
0 => -80.572799
1 => 43.457509
]
+"Latitude": 43.457509
+"Longitude": -80.572799
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "RemarksPublic Remarks: Welcome to 519 Yorkshire Drive, Waterloo: Luxury Living in Prestigious Upper Beechwood! A beautifully updated detached 2-storey home, Nestled on a mature, tree-lined street in Upper Beechwood offers outstanding curb appeal with lush landscaping and parking for 4 vehicles (2 in oversized 13.5 ft high garage, 2 on concrete driveway. Step inside through a Grand porch to welcoming foyer leading to a thoughtfully renovated interior featuring updated flooring and pot lights throughout. The spacious living room is warm, airy and very bright. A rare main-floor bedroom offers incredible flexibility. The inviting family room creates the perfect setting for relaxing evenings, game nights or movie nights. The beautifully updated kitchen is fully equipped with stainless steel appliances, granite countertops, a chic tile backsplash and ample cabinetry. Adjacent is the spacious dining area, perfect for hosting dinner parties or creating lasting memories. A spacious Laundry room with ample storage and a convenient 2pc powder room completes the main level. Upstairs there are 4 generous bedrooms and 2 full bathrooms. The primary suite includes a walk-in closet and a luxurious ensuite with a Jacuzzi tub. Most windows in this house have been replaced. The fully finished basement adds exceptional living space with 2 additional bedrooms, 3pc bathroom and huge Rec area with kitchenette setup. Step outside to fully fenced backyard, featuring a spacious patio and charming gazebo, perfect for summer BBQs, entertaining or simply relaxing. Additional updates: Furnace and AC (2025) and a new water heater (2026). Located minutes from top-rated schools, University of Waterloo and Wilfrid Laurier, The Boardwalk Plaza, Costco, parks, Trails, public transit, restaurants and healthcare facilities, this location has it all. Offering 7 bedrooms, 4 bathrooms, this beautifully upgraded home is a rare opportunity, Book your private showing today and make it your forever home. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Freezer"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
11 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T19:02:42.717889+00:00"
+"Directions": "Cross Streets: Erbsville Rd/ Keatsway. ** Directions: Erbsville Road to Keatsway."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "47.9 x 102 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T17:39:27Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-27T12:10:38Z"
+"Stories": "2.0"
+"StreetName": "Yorkshire"
+"StreetNumber": "519"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6960"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/6d9ag_519_yorkshire_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30071331/519-yorkshire-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 47.1
+"OriginalEntryTimestamp": "2026-07-23T17:39:27.54Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30071331')"
+"ID": "1652383"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25478
+post_id: "1652258"
+post_author: 1
+"ListingKey": "30070302"
+"ListingId": "40849801"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-26T20:35:22Z"
+"RFModificationTimestamp": "2026-07-26T20:38:33Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 3733.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V1"
+"UnparsedAddress": "519 YORKSHIRE Drive, Waterloo, Ontario N2T2V1"
+"Coordinates": array:2 [
0 => -80.5727819
1 => 43.4575227
]
+"Latitude": 43.4575227
+"Longitude": -80.5727819
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 519 Yorkshire Drive, Waterloo: Luxury Living in Prestigious Upper Beechwood! A beautifully updated detached 2-storey home, Nestled on a mature, tree-lined street in Upper Beechwood offers outstanding curb appeal with lush landscaping and parking for 4 vehicles (2 in oversized 13.5 ft high garage, 2 on concrete driveway. Step inside through a Grand porch to welcoming foyer leading to a thoughtfully renovated interior featuring updated flooring and pot lights throughout. The spacious living room is warm, airy and very bright. A rare main-floor bedroom offers incredible flexibility. The inviting family room creates the perfect setting for relaxing evenings, game nights or movie nights. The beautifully updated kitchen is fully equipped with stainless steel appliances, granite countertops, a chic tile backsplash and ample cabinetry. Adjacent is the spacious dining area, perfect for hosting dinner parties or creating lasting memories. A spacious Laundry room with ample storage and a convenient 2pc powder room completes the main level. Upstairs there are 4 generous bedrooms and 2 full bathrooms. The primary suite includes a walk-in closet and a luxurious ensuite with a Jacuzzi tub. Most windows in this house have been replaced. The fully finished basement adds exceptional living space with 2 additional bedrooms, 3pc bathroom and huge Rec area with kitchenette setup. Step outside to fully fenced backyard, featuring a spacious patio and charming gazebo, perfect for summer BBQs, entertaining or simply relaxing. Additional updates: Furnace and AC (2025) and a new water heater (2026). Located minutes from top-rated schools, University of Waterloo and Wilfrid Laurier, The Boardwalk Plaza, Costco, parks, Trails, public transit, restaurants and healthcare facilities, this location has it all. Offering 7 bedrooms, 4 bathrooms, this beautifully upgraded home is a rare opportunity, Book your private showing today and make it your forever home. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Freezer"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T16:58:13.051179+00:00"
+"Directions": "Erbsville Road to Keatsway"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564507"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T15:38:28Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-26T20:29:31Z"
+"Stories": "2.0"
+"StreetName": "YORKSHIRE"
+"StreetNumber": "519"
+"StreetSuffix": "Drive"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "6960"
+"VirtualTourURLUnbranded": "https://youriguide.com/6d9ag_519_yorkshire_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/30070302/519-yorkshire-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 48.0
+"AboveGradeFinishedArea": 2447
+"BelowGradeFinishedArea": 1286
+"OriginalEntryTimestamp": "2026-07-23T15:38:28.07Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1123254"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30070302')"
+"ID": "1652258"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25473
+post_id: "1650535"
+post_author: 1
+"ListingKey": "30068427"
+"ListingId": "X13595566"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T16:45:05Z"
+"RFModificationTimestamp": "2026-07-23T16:53:47Z"
+"ListPrice": 587000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T0A5"
+"UnparsedAddress": "36 - 555 CHABLIS DRIVE, Waterloo, Ontario N2T0A5"
+"Coordinates": array:2 [
0 => -80.574031
1 => 43.449435
]
+"Latitude": 43.449435
+"Longitude": -80.574031
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rare end-unit condo townhome in sought-after Clair Hills offers the space and features of a detached home without the upkeep. A double-car garage plus double-wide driveway delivers parking for four - virtually unheard of in condo life. At 2,478 sq. ft. of total finished living area, the layout is generous throughout: open-concept main floor with hardwood, a well-appointed kitchen with gas range, breakfast peninsula, pantry and stainless appliances, three upstairs bedrooms including an oversized primary with walk-in closet and ensuite, upper-level laundry, and a flexible lower level ideal for a family room, office or gym. Move-in ready with 2026 updates including fresh paint, new upstairs carpet and updated lighting, while the bathrooms have been refreshed with new vanities, mirrors, faucets, toilets and coordinated black fixtures. Smart home features include app-based locks, lighting and garage access. Furnace and AC replaced 2023. The end-unit position brings extra windows, privacy and a rear deck overlooking landscaped green space - no street exposure. Steps to The Boardwalk's shops, restaurants, Costco and healthcare, with easy GRT access and 150+ km of trails nearby. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
]
+"AssociationFee": "280"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T00:54:31.814311+00:00"
+"Directions": "Ira Needles & Chablis"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2102918"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T16:07:11Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T16:39:54Z"
+"Stories": "2.0"
+"StreetName": "Chablis"
+"StreetNumber": "555"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4956"
+"VirtualTourURLUnbranded": "https://youriguide.com/unit_36_555_chablis_dr_waterloo_on/"
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30068427/36-555-chablis-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"ZoningDescription": "R7"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-07-22T23:33:34.65Z"
+"ListAgentNationalAssociationId": "1372568"
+"ListOfficeNationalAssociationId": "1385020"
+"Media": array:40 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30068427')"
+"ID": "1650535"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23598
+post_id: "1650445"
+post_author: 1
+"ListingKey": "30067509"
+"ListingId": "X13594960"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-22T20:45:03Z"
+"RFModificationTimestamp": "2026-07-22T23:01:01Z"
+"ListPrice": 799990.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B4"
+"UnparsedAddress": "274 BUTTONBUSH STREET, Waterloo, Ontario N2V0B4"
+"Coordinates": array:2 [
0 => -80.590313
1 => 43.451104
]
+"Latitude": 43.451104
+"Longitude": -80.590313
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To Vista Hills - Home To Some Of Waterloo's Highest-Ranked Schools And One Of The Region's Most In-Demand Family Neighbourhoods. Families Move Here For The Schools And Stay For The Trails, Parks, And True Community Feel -And This Detached 4+1 Bedroom, 4 Bathroom Home Puts You Right In The Heart Of It All. Offering Over 3,000 Sq Ft Of Finished Living Space, A Double Garage, And A Finished Basement With Separate Entrance, This Home Checks Every Box On The Family Wish List - And With Vacant Immediate Possession, You Can Be Settled Before The New School Term Begins. The Bright Open-Concept Main Floor Features Hardwood Floors, Pot Lights, And Large Windows Throughout, While The Chef-Inspired Kitchen Impresses With Quartz Counters, Stainless Steel Appliances, And An Oversized Centre Island Built For Busy Mornings And Weekend Gatherings Alike. Upstairs, The Spacious Primary Retreat Offers A Walk-In Closet And Private Ensuite, Joined By Generously Sized Bedrooms - Including A Rare Jr. Primary-Style Bedroom Perfect For Older Kids, Guests Extended Family, Or A Quiet Home Office. The Finished Lower Level Extends The Living Space With A Full Bedroom, 3-Piece Bath, Large Rec Room, And Separate Entrance Opening The Door To In-Law Suite Or Income Potential. Vacant, Easy To Show, And Ready For Immediate Closing. Space, Schools, And Value Rarely Line Up Like This In Waterloo. Don't Let This One Get Away! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T23:00:03.833971+00:00"
+"Directions": "Columbia St W and Ladyslipper Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1976739"
+"ListOfficeKey": "238732"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "In-Law Suite"
]
+"LotSizeDimensions": "34.1 x 98.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-22T20:36:31Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-22T20:36:31Z"
+"Stories": "2.5"
+"StreetName": "Buttonbush"
+"StreetNumber": "274"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6315.55"
+"VirtualTourURLUnbranded": "https://sites.happyhousegta.com/274buttonbushstreet"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30067509/274-buttonbush-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 34.1
+"OriginalEntryTimestamp": "2026-07-22T20:36:31.77Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1263079"
+"ListOfficeNationalAssociationId": "1200762"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30067509')"
+"ID": "1650445"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25501
+post_id: "1649189"
+post_author: 1
+"ListingKey": "30066738"
+"ListingId": "40850366"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-26T20:35:21Z"
+"RFModificationTimestamp": "2026-07-26T20:39:24Z"
+"ListPrice": 949999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1717.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2T4"
+"UnparsedAddress": "553 BLUE BEECH Boulevard, Waterloo, Ontario N2V2T4"
+"Coordinates": array:2 [
0 => -80.5942896
1 => 43.4684464
]
+"Latitude": 43.4684464
+"Longitude": -80.5942896
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "*** For more information, please click Brochure button. *** This unique abode backs to the most vast scenic forest trails and fronts no direct house across the street so you never have to risk an awkward encounter with a peeping neighbor, truly the most exceptional privacy. Being on high ground is also very advantageous with how much flooding is seen through the region in early spring. The sump pump has never had to work a day in its life. A second private entrance to the house leads to an incredibly spacious and finished basement, just the right amount of segregation for lending provisions to a studying/working kin or renting to generate some side income. Finally, save more utilities with the addition of a newly installed, high efficiency heat pump (2024). All in all 100% carpet free, pet free, open concept, and turnkey. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Freezer"
9 => "Central Vacuum - Roughed In"
10 => "Hood Fan"
11 => "Window Coverings"
12 => "Garage door opener"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T20:02:18.021489+00:00"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2220194"
+"ListOfficeKey": "296937"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Backs on greenbelt"
1 => "Conservation/green belt"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-22T23:03:22Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-26T20:29:22Z"
+"Stories": "2.0"
+"StreetName": "BLUE BEECH"
+"StreetNumber": "553"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5141.81"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30066738/553-blue-beech-boulevard-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1717
+"OriginalEntryTimestamp": "2026-07-22T18:38:05.84Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1464325"
+"ListOfficeNationalAssociationId": "1464303"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30066738')"
+"ID": "1649189"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25502
+post_id: "1649042"
+post_author: 1
+"ListingKey": "30065970"
+"ListingId": "40848982"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T16:10:07Z"
+"RFModificationTimestamp": "2026-07-23T16:26:37Z"
+"ListPrice": 587000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2478.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2Y7"
+"UnparsedAddress": "555 CHABLIS Drive Unit# 36, Waterloo, Ontario N2T2Y7"
+"Coordinates": array:2 [
0 => -80.5740634
1 => 43.4487988
]
+"Latitude": 43.4487988
+"Longitude": -80.5740634
+"YearBuilt": 2010
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare end-unit condo townhome in sought-after Clair Hills offers the space and features of a detached home without the upkeep. A double-car garage plus double-wide driveway delivers parking for four — virtually unheard of in condo life. At 2,478 sq. ft. of total finished living area, the layout is generous throughout: open-concept main floor with hardwood, a well-appointed kitchen with gas range, breakfast peninsula, pantry and stainless appliances, three upstairs bedrooms including an oversized primary with walk-in closet and ensuite, upper-level laundry, and a flexible lower level ideal for a family room, office or gym. Move-in ready with 2026 updates including fresh paint, new upstairs carpet and updated lighting, while the bathrooms have been refreshed with new vanities, mirrors, faucets, toilets and coordinated black fixtures. Smart home features include app-based locks, lighting and garage access. Furnace and AC replaced 2023. The end-unit position brings extra windows, privacy and a rear deck overlooking landscaped green space — no street exposure. Steps to The Boardwalk's shops, restaurants, Costco and healthcare, with easy GRT access and 150+ km of trails nearby. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Hood Fan"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"AssociationFee": "280"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T17:53:32.701198+00:00"
+"Directions": "Ira Needles & Chablis"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1930634"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T16:02:56Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T16:02:56Z"
+"Stories": "2.0"
+"StreetName": "CHABLIS"
+"StreetNumber": "555"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4956"
+"VirtualTourURLUnbranded": "https://youriguide.com/unit_36_555_chablis_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30065970/555-chablis-drive-unit-36-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R7"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1766
+"BelowGradeFinishedArea": 712
+"OriginalEntryTimestamp": "2026-07-22T17:08:17.78Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1231368"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30065970')"
+"ID": "1649042"
}
]
+success: true
+page_size: 9
+page_count: 12
+count: 108
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
]