array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29816315 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
+post_id: "1470250"
+post_author: 1
+"ListingKey": "29816315"
+"ListingId": "40833306"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T14:30:08Z"
+"RFModificationTimestamp": "2026-06-26T14:36:51Z"
+"ListPrice": 674900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1122.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1H2"
+"UnparsedAddress": "171 HERRON Place, Waterloo, Ontario N2T1H2"
+"Coordinates": array:2 [
0 => -80.5472998
1 => 43.4423154
]
+"Latitude": 43.4423154
+"Longitude": -80.5472998
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 171 Herron Place, located on a quiet cul-de-sac location in the desirable Westvale neighbourhood of Waterloo. This wonderful carpet-free raised bungalow sits on a corner lot and offers a practical layout with strong flexibility for families, multi-generational living, or anyone needing additional space. One of the standout features is the rare backyard access through the rear side gate, creating an excellent opportunity to store an RV, boat, trailer, or other recreational items right on the property. Inside, the main level offers a bright and comfortable layout, including a generous living room with a bay window, a modern white kitchen boasting quartz countertops with island, a dining room with sliding doors to a 10 ft x 15 ft deck, main level laundry, 2 bedrooms, 4-Piece Bathroom, and a clean carpet-free design throughout. The lower level adds further value with 2 additional bedrooms, a kitchenette, a 3-piece bathroom, a second laundry area, and separate entrance through the garage, making the space well-suited for extended family, guests, or added day-to-day flexibility. The backyard continues to add to the home’s appeal with fruit trees, beautifully landscaped gardens, an 8 ft x 10 ft garden shed, and useful storage underneath the deck. Important updates include the furnace in 2022 and heat pump in 2025. Call to schedule a private showing today! (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-28T19:29:43.263099+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2074267"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T14:11:24Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T14:22:46Z"
+"Stories": "1.0"
+"StreetName": "HERRON"
+"StreetNumber": "171"
+"StreetSuffix": "Place"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "4697.82"
+"VirtualTourURLUnbranded": "https://youriguide.com/171_herron_pl_waterloo_on/doc/branded_property_overview_imperial.pdf"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1668536520"
"RoomType" => "Kitchen"
"ListingId" => "40833306"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29816315"
"RoomLength" => null
"RoomDimensions" => "4'10'' x 6'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T14:22:46.11Z"
]
1 => array:11 [
"RoomKey" => "1668536521"
"RoomType" => "Bedroom"
"ListingId" => "40833306"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29816315"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T14:22:46.11Z"
]
2 => array:11 [
"RoomKey" => "1668536522"
"RoomType" => "Bedroom"
"ListingId" => "40833306"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29816315"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T14:22:46.12Z"
]
3 => array:11 [
"RoomKey" => "1668536523"
"RoomType" => "3pc Bathroom"
"ListingId" => "40833306"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29816315"
"RoomLength" => null
"RoomDimensions" => "4'10'' x 6'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T14:22:46.12Z"
]
4 => array:11 [
"RoomKey" => "1668536524"
"RoomType" => "Laundry room"
"ListingId" => "40833306"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29816315"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 5'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T14:22:46.12Z"
]
5 => array:11 [
"RoomKey" => "1668536525"
"RoomType" => "Family room"
"ListingId" => "40833306"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29816315"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 17'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T14:22:46.13Z"
]
6 => array:11 [
"RoomKey" => "1668536526"
"RoomType" => "Bedroom"
"ListingId" => "40833306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816315"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T14:22:46.13Z"
]
7 => array:11 [
"RoomKey" => "1668536527"
"RoomType" => "Primary Bedroom"
"ListingId" => "40833306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816315"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 20'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T14:22:46.14Z"
]
8 => array:11 [
"RoomKey" => "1668536528"
"RoomType" => "4pc Bathroom"
"ListingId" => "40833306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816315"
"RoomLength" => null
"RoomDimensions" => "6'10'' x 8'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T14:22:46.14Z"
]
9 => array:11 [
"RoomKey" => "1668536529"
"RoomType" => "Dining room"
"ListingId" => "40833306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816315"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T14:22:46.15Z"
]
10 => array:11 [
"RoomKey" => "1668536530"
"RoomType" => "Kitchen"
"ListingId" => "40833306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816315"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 14'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T14:22:46.15Z"
]
11 => array:11 [
"RoomKey" => "1668536531"
"RoomType" => "Living room"
"ListingId" => "40833306"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29816315"
"RoomLength" => null
"RoomDimensions" => "14'1'' x 15'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T14:22:46.15Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29816315/171-herron-place-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "r4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 37.0
+"AboveGradeFinishedArea": 1122
+"OriginalEntryTimestamp": "2026-05-28T11:51:13.84Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1349417"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:41 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29816315_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/b3efd77f717358a0f96c46220d8379b6.webp"
"MediaSize" => 180233
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-b3efd77f717358a0f96c46220d8379b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Raised bugalow residence featuring a prominent front entrance and an attached garage"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29816315_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/ed4209bbcbbd2fbd9531cb582bdd29d1.webp"
"MediaSize" => 183293
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-ed4209bbcbbd2fbd9531cb582bdd29d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Raised bugalow residence featuring a single-car garage and a paved driveway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29816315_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/72909294579cadbbfad5e9e5073c2ecc.webp"
"MediaSize" => 157590
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-72909294579cadbbfad5e9e5073c2ecc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior with white siding accents and a white garage door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29816315_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/958990f3d55dc872fb27b8f3f49c9981.webp"
"MediaSize" => 157726
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-958990f3d55dc872fb27b8f3f49c9981.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rear exterior featuring a white entry door, brick siding, a wood deck with a ramp, a metal railing, and an adjacent garden bed"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29816315_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/05a0074a8773965166bd17537c607c9d.webp"
"MediaSize" => 188071
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-05a0074a8773965166bd17537c607c9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29816315_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/b5974d5e9eee2c3d1fbc949b4a538add.webp"
"MediaSize" => 186865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-b5974d5e9eee2c3d1fbc949b4a538add.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive wood-finish deck with a perimeter of mature plantings and trees"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29816315_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/945032091624ac9eca7ff40f018eb4d1.webp"
"MediaSize" => 223505
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-945032091624ac9eca7ff40f018eb4d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive wooden deck featuring perimeter landscaping and mature trees"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29816315_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/279cdffdf36815e65dc72abc12744bfa.webp"
"MediaSize" => 161975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-279cdffdf36815e65dc72abc12744bfa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front entry with a white door featuring decorative glass, a concrete landing, an integrated ramp, vinyl siding, and brick detailing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29816315_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/e91f5722d793574d3303decbcdf9d3c0.webp"
"MediaSize" => 68754
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-e91f5722d793574d3303decbcdf9d3c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Split-level entry featuring wood-finish flooring, a white paneled entry door with frosted glass, and a white interior staircase with a dark handrail"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29816315_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/e2ce9ef5d0dccc26c0105c9744d74531.webp"
"MediaSize" => 79562
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-e2ce9ef5d0dccc26c0105c9744d74531.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area with laminate finish flooring, a large bay window, and a ceiling fan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29816315_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/5421e034f59eb32d4d160062ea0183c9.webp"
"MediaSize" => 75742
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-5421e034f59eb32d4d160062ea0183c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29816315_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/72a41b1e5e00e0697a72db2e8774cf6e.webp"
"MediaSize" => 69978
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-72a41b1e5e00e0697a72db2e8774cf6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry and a central island with a quartz countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29816315_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/1a6cf74c3706f4f84bbfb5f9c3316073.webp"
"MediaSize" => 78272
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-1a6cf74c3706f4f84bbfb5f9c3316073.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright kitchen featuring white cabinetry, stainless steel appliances, light-colored countertops, wood-finish flooring, and a tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29816315_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/77fe1ef9e9acff0ccae4f3d32b666d50.webp"
"MediaSize" => 74247
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-77fe1ef9e9acff0ccae4f3d32b666d50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen island with a quartz countertop and white cabinetry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29816315_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/c7aa15e1552c3efcb6dac41a111d4ef6.webp"
"MediaSize" => 72027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-c7aa15e1552c3efcb6dac41a111d4ef6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring laminate finish flooring, a contemporary ceiling light fixture, and a sliding glass door leading to an outdoor deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29816315_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/94d14763fce83d544ad9962186080c20.webp"
"MediaSize" => 177935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-94d14763fce83d544ad9962186080c20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Wood-finish deck with vertical slat railings, featuring a privacy lattice panel and an entry gate"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29816315_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/bc97fb6401652f66d7e4b9d412e0f81c.webp"
"MediaSize" => 214075
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-bc97fb6401652f66d7e4b9d412e0f81c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exterior staircase featuring black metal railings, leading down to a concrete path"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29816315_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/744df2e9fbbbd5b23f6b005a3506354f.webp"
"MediaSize" => 216981
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-744df2e9fbbbd5b23f6b005a3506354f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Tiered backyard with lush green lawn, mature trees, privacy fencing, and stone steps with metal railings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29816315_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/33ffc5a5b9e0800ee16fb3776aaf1d04.webp"
"MediaSize" => 98013
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-33ffc5a5b9e0800ee16fb3776aaf1d04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, a bright window bay with natural light, and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29816315_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/1a11d61c73eb3ed59b4c8639baa25441.webp"
"MediaSize" => 72245
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-1a11d61c73eb3ed59b4c8639baa25441.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, light-toned walls, and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29816315_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/b172cafb5b58a6989bd13a064e86f621.webp"
"MediaSize" => 71173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-b172cafb5b58a6989bd13a064e86f621.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room with laminate finish flooring, a single window, and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29816315_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/62840c810fbdf53c2fdd12e8eacbe19b.webp"
"MediaSize" => 80109
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-62840c810fbdf53c2fdd12e8eacbe19b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bathroom featuring a wood-finish vanity with an integrated sink, a stacked washer and dryer unit, and white subway tile in the shower area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29816315_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/3b12829d3ed3cc2544ce5339eca60d75.webp"
"MediaSize" => 80714
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-3b12829d3ed3cc2544ce5339eca60d75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring wood-finish flooring, a double window, white trim, sliding mirrored closet doors, and recessed panel bifold closet doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29816315_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/2adaa5886754f420b3d07cb98c3dbdb0.webp"
"MediaSize" => 79958
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-2adaa5886754f420b3d07cb98c3dbdb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29816315_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/e91b9fcdf3be2c9b450a563ba072a640.webp"
"MediaSize" => 100426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-e91b9fcdf3be2c9b450a563ba072a640.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring laminte finish flooring and a neutral color palette"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29816315_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/9cb6c244cf6f91f82ed081c9d09d1492.webp"
"MediaSize" => 78109
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-9cb6c244cf6f91f82ed081c9d09d1492.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring light laminte finish flooring, white walls, and a drop ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29816315_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/e0c64db125d41e8f539a9d15b527b58f.webp"
"MediaSize" => 75513
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-e0c64db125d41e8f539a9d15b527b58f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Compact kitchenette area featuring wood-finish cabinetry, an under-mount stainless steel sink, a microwave, and a refrigerator"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29816315_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/a3a7bd5657b44e1da6cf59cb544c7133.webp"
"MediaSize" => 54858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-a3a7bd5657b44e1da6cf59cb544c7133.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white ceramic toilet, a vanity with a white ceramic sink and brushed nickel faucet, a medicine cabinet with mirror, and a shower enclosure"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29816315_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/baf1feba8e1d1d03b2450580b5fec28d.webp"
"MediaSize" => 77407
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-baf1feba8e1d1d03b2450580b5fec28d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious interior room featuring light wood-finish flooring, white trim, and neutral wall tones"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29816315_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/38f5ce518fd3889210546796161e331a.webp"
"MediaSize" => 72255
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-38f5ce518fd3889210546796161e331a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring light laminte finish flooring, neutral wall tones, a ceiling-mounted light fixture, a recessed ceiling light, and a window with sheer coverings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29816315_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/d1eb2e349bdede9291264669e91e63ec.webp"
"MediaSize" => 92137
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-d1eb2e349bdede9291264669e91e63ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated utility closet featuring a stacked front-load washer and dryer, adjacent to mechanical systems"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29816315_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/29f95cbb8fa6154f29902e409546c55a.webp"
"MediaSize" => 167990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-29f95cbb8fa6154f29902e409546c55a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a manicured lawn, wood fencing, and a terraced garden area with wood-framed raised beds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29816315_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/09025ec04160aec24a71015b5eb44298.webp"
"MediaSize" => 197998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-09025ec04160aec24a71015b5eb44298.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive green lawn surrounded by mature trees, featuring a wood fence perimeter and a garden shed for additional storage"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29816315_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/6f56ee2f6ca5cefd5a7c3781abbca949.webp"
"MediaSize" => 209404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-6f56ee2f6ca5cefd5a7c3781abbca949.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a green lawn, mature trees, wood fence, and a storage shed"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29816315_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/1c4e62051e67f5cf281f50419b7c6a1a.webp"
"MediaSize" => 225497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-1c4e62051e67f5cf281f50419b7c6a1a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a manicured lawn, established perimeter fencing, and mature trees providing natural shade"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29816315_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/f20d9a2a4ac3fcf61d0678d85e56b3e2.webp"
"MediaSize" => 182051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-f20d9a2a4ac3fcf61d0678d85e56b3e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29816315_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/425d8c70187347321a79b1f781645774.webp"
"MediaSize" => 206450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-425d8c70187347321a79b1f781645774.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29816315_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/ad1430a466d6ebd7b136a52f1f5ec4a0.webp"
"MediaSize" => 187433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-ad1430a466d6ebd7b136a52f1f5ec4a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fenced backyard featuring a manicured lawn, stone paver pathway, mature trees, and an elevated wooden deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29816315_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/218dfeb35cb1f2bc2d21ccd7aa81bf4d.webp"
"MediaSize" => 47361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-218dfeb35cb1f2bc2d21ccd7aa81bf4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29816315_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/7bdfec05c63168359ef9c0d437d767f7.webp"
"MediaSize" => 28075
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-7bdfec05c63168359ef9c0d437d767f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29816315_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29816315/d354b5702e85be6c1434d01995ef9aca.webp"
"MediaSize" => 49715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29816315/thumbnail-d354b5702e85be6c1434d01995ef9aca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833306"
"ResourceRecordKey" => "29816315"
"ModificationTimestamp" => "2026-05-28T11:51:13.84Z"
]
]
+"DaysOnMarket": 37
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29816315')"
+"ID": "1470250"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 290168" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24904
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2074267" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24862
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29816315'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25260
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29816315'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25278
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25276
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31203730"
+"ListingKey": "29816315"
+"ListingId": "40833306"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-05-31"
+"OpenHouseStartTime": "2026-05-31T14:00:00Z"
+"OpenHouseEndTime": "2026-05-31T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-05-31T17:48:37Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31203730')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29816315' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5472998 43.4423154)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25351
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25325
+post_id: "1591176"
+post_author: 1
+"ListingKey": "29987087"
+"ListingId": "40844492"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T14:05:23Z"
+"RFModificationTimestamp": "2026-07-04T14:08:04Z"
+"ListPrice": 390000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 982.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N8"
+"UnparsedAddress": "459 BEECHWOOD Place Unit# 21, Waterloo, Ontario N2T2N8"
+"Coordinates": array:2 [
0 => -80.5590418
1 => 43.4510561
]
+"Latitude": 43.4510561
+"Longitude": -80.5590418
+"YearBuilt": 1993
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beechwood has long been one of Waterloo's most sought-after neighbourhoods, loved for its mature tree-lined streets, established community, and unbeatable everyday convenience. Nestled within a quiet condo complex, this home feels welcoming and peaceful, located just minutes from shopping, restaurants, parks, trails, transit, and both globally renowned universities. Inside, you will find an inviting, functional layout designed for comfortable living. The main floor features the kitchen, dining, and living areas. Upstairs, the two bedrooms are complemented by a full bathroom, while the primary bedroom enjoys the added luxury of its own private two-piece ensuite. The finished basement extends your living space even further, complete with a third bathroom and endless flexibility for a family room, home office, workout area, or guest retreat. Interior access to the attached garage, along with a second driveway parking space, adds convenience to your daily routine. In 2025, the furnace was upgraded to include a humidifier, and a new laundry machine set was added around 2023. The condominium corporation handles exterior maintenance, landscaping, and snow removal, allowing you to spend less time on upkeep and more time enjoying everything this exceptional neighbourhood has to offer. Whether you are searching for your first home or a smart investment in one of Waterloo's most consistently desirable communities, this is an opportunity you will not want to miss. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener"
6 => "Microwave Built-in"
]
+"AssociationFee": "464.42"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Other, See Remarks"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Partial"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T23:23:32.715919+00:00"
+"Directions": "Erb st to Beechwood pl"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2249661"
+"ListOfficeKey": "300896"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Balcony"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-03T20:18:20Z"
+"PhotosCount": 25
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T13:59:15Z"
+"Stories": "2.0"
+"StreetName": "BEECHWOOD"
+"StreetNumber": "459"
+"StreetSuffix": "Place"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "2512.57"
+"Utilities": array:1 [
0 => "Natural Gas"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/459_beechwood_pl_unit_21_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1674965378"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844492"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29987087"
"RoomLength" => null
"RoomDimensions" => "6'11'' x 5'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T13:59:15.08Z"
]
1 => array:11 [
"RoomKey" => "1674965379"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844492"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29987087"
"RoomLength" => null
"RoomDimensions" => "4'3'' x 4'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T13:59:15.09Z"
]
2 => array:11 [
"RoomKey" => "1674965380"
"RoomType" => "Recreation room"
"ListingId" => "40844492"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29987087"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T13:59:15.09Z"
]
3 => array:11 [
"RoomKey" => "1674965381"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844492"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29987087"
"RoomLength" => null
"RoomDimensions" => "6'3'' x 3'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T13:59:15.09Z"
]
4 => array:11 [
"RoomKey" => "1674965382"
"RoomType" => "Bedroom"
"ListingId" => "40844492"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29987087"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T13:59:15.09Z"
]
5 => array:11 [
"RoomKey" => "1674965383"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844492"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29987087"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T13:59:15.09Z"
]
6 => array:11 [
"RoomKey" => "1674965384"
"RoomType" => "Living room"
"ListingId" => "40844492"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987087"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T13:59:15.09Z"
]
7 => array:11 [
"RoomKey" => "1674965385"
"RoomType" => "Dining room"
"ListingId" => "40844492"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987087"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T13:59:15.09Z"
]
8 => array:11 [
"RoomKey" => "1674965386"
"RoomType" => "Kitchen"
"ListingId" => "40844492"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987087"
"RoomLength" => null
"RoomDimensions" => "7'9'' x 8'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T13:59:15.09Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29987087/459-beechwood-place-unit-21-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "CPPS-MUR1-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 838
+"BelowGradeFinishedArea": 144
+"OriginalEntryTimestamp": "2026-07-03T20:18:20.66Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1488485"
+"ListOfficeNationalAssociationId": "1494469"
+"Media": array:25 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29987087_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/4fa3b4ba9d48348e9abdb009a870a628.webp"
"MediaSize" => 126259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-4fa3b4ba9d48348e9abdb009a870a628.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29987087_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/cc7623e5ccce068aec4825d63d06f6cb.webp"
"MediaSize" => 133446
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-cc7623e5ccce068aec4825d63d06f6cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29987087_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/3464bc50a617e94faa4264743f389c12.webp"
"MediaSize" => 64694
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-3464bc50a617e94faa4264743f389c12.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29987087_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987087/94d73920fde920099c0562deda9e776e.webp"
"MediaSize" => 84686
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987087/thumbnail-94d73920fde920099c0562deda9e776e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844492"
"ResourceRecordKey" => "29987087"
"ModificationTimestamp" => "2026-07-03T20:18:20.66Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29987087_4890_5"
…11
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29987087')"
+"ID": "1591176"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25346
+post_id: "1590956"
+post_author: 1
+"ListingKey": "29987378"
+"ListingId": "X13520800"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T18:05:17Z"
+"RFModificationTimestamp": "2026-07-04T18:08:09Z"
+"ListPrice": 390000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N8"
+"UnparsedAddress": "21 - 459 BEECHWOOD PLACE, Waterloo, Ontario N2T2N8"
+"Coordinates": array:2 [
0 => -80.557278
1 => 43.451718
]
+"Latitude": 43.451718
+"Longitude": -80.557278
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Beechwood has long been one of Waterloo's most sought-after neighbourhoods, loved for its mature tree-lined streets, established community, and unbeatable everyday convenience. Nestled within a quiet condo complex, this home feels welcoming and peaceful, located just minutes from shopping, restaurants, parks, trails, transit, and both globally renowned universities. Inside, you will find an inviting, functional layout designed for comfortable living. The main floor features the kitchen, dining, and living areas. Upstairs, the two bedrooms are complemented by a full bathroom, while the primary bedroom enjoys the added luxury of its own private two-piece ensuite. The finished basement extends your living space even further, complete with a third bathroom and endless flexibility for a family room, home office, workout area, or guest retreat. Interior access to the attached garage, along with a second driveway parking space, adds convenience to your daily routine. In 2025, the furnace was upgraded to include a humidifier, and a new laundry machine set was added around 2023. The condominium corporation handles exterior maintenance, landscaping, and snow removal, allowing you to spend less time on upkeep and more time enjoying everything this exceptional neighbourhood has to offer. Whether you are searching for your first home or a smart investment in one of Waterloo's most consistently desirable communities, this is an opportunity you will not want to miss. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Blinds"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"AssociationFee": "464.42"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Water"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Partial"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T21:19:17.843583+00:00"
+"Directions": "Cross Streets: Erb St to Beechwood Pl. ** Directions: Erb S."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2253532"
+"ListOfficeKey": "300496"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Balcony"
2 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T20:59:56Z"
+"PhotosCount": 25
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T17:59:58Z"
+"Stories": "2.0"
+"StreetName": "Beechwood"
+"StreetNumber": "459"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "2521"
+"VirtualTourURLUnbranded": "https://youriguide.com/459_beechwood_pl_unit_21_waterloo_on/"
+"Rooms": array:9 [
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]
]
+"ListAOR": "OnePoint"
+"TaxYear": 2025
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29987378/21-459-beechwood-place-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-03T20:59:56Z"
+"ListAgentNationalAssociationId": "1492517"
+"ListOfficeNationalAssociationId": "1489080"
+"Media": array:25 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29987378')"
+"ID": "1590956"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25324
+post_id: "1589820"
+post_author: 1
+"ListingKey": "29983725"
+"ListingId": "X13517266"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T13:10:02Z"
+"RFModificationTimestamp": "2026-07-03T18:10:00Z"
+"ListPrice": 689000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1A7"
+"UnparsedAddress": "92 PINEMEADOW CRESCENT, Waterloo, Ontario N2T1A7"
+"Coordinates": array:2 [
0 => -80.553692
1 => 43.449029
]
+"Latitude": 43.449029
+"Longitude": -80.553692
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "The bright and inviting main level features spacious principal rooms, premium laminate flooring, fresh professional paint, updated interior doors and railings, and beautifully renovated bathrooms. At the heart of the home is the modern kitchen, showcasing refreshed cabinetry, sleek countertops, and stainless steel appliances-an ideal space for both everyday living and entertaining. The fully finished lower level adds exceptional flexibility with a spacious recreation room, a fourth bedroom, and a full bathroom, making it ideal for growing families, multi-generational living, overnight guests, a home office, or future income potential. Step outside to enjoy a fully fenced backyard offering privacy and plenty of space for children, pets, gardening, or summer BBQs. An attached garage and double driveway provide parking for up to three vehicles. Located on a quiet crescent in the desirable Westvale community, you'll appreciate the convenience of being just minutes from highly regarded schools, beautiful parks and trails, shopping, restaurants, public transit, and easy access to the University of Waterloo, Wilfrid Laurier University, and major commuter routes. Recent updates include premium laminate flooring (2023), stainless steel kitchen appliances, including the fridge and stove (2023), fresh professional paint (2024), roof shingles (2016), and a furnace (2018). This is an exceptional opportunity to own a beautifully maintained home in one of Waterloo's most established and family-friendly communities. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T18:09:54.238532+00:00"
+"Directions": "Cross Streets: Fischer-Hallman Road & Erb Street. ** Directions: Westvale Drive to Pinemeadow Crescent."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Concrete Block"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2188755"
+"ListOfficeKey": "291409"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40 x 108.5 FT ; 40.35ft. x 113.0ft. x 40.09ft x 108.45ft"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Tandem"
]
+"PhotosChangeTimestamp": "2026-07-03T13:04:24Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T13:04:24Z"
+"Stories": "1.0"
+"StreetName": "Pinemeadow"
+"StreetNumber": "92"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4096"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29983725/92-pinemeadow-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1418255"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "90198"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2026-07-03T13:04:24.39Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1437820"
+"ListOfficeNationalAssociationId": "1397659"
+"CoListAgentNationalAssociationId": "1105101"
+"CoListOfficeNationalAssociationId": "1153615"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983725')"
+"ID": "1589820"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25348
+post_id: "1588834"
+post_author: 1
+"ListingKey": "29983590"
+"ListingId": "40844806"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T12:40:07Z"
+"RFModificationTimestamp": "2026-07-03T13:44:45Z"
+"ListPrice": 689000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.102
+"LivingArea": 1572.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1A7"
+"UnparsedAddress": "92 PINEMEADOW Crescent, Waterloo, Ontario N2T1A7"
+"Coordinates": array:2 [
0 => -80.5538293
1 => 43.4490161
]
+"Latitude": 43.4490161
+"Longitude": -80.5538293
+"YearBuilt": 1980
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "The bright and inviting main level features spacious principal rooms, premium laminate flooring, fresh professional paint, updated interior doors and railings, and beautifully renovated bathrooms. At the heart of the home is the modern kitchen, showcasing refreshed cabinetry, sleek countertops, and stainless steel appliances—an ideal space for both everyday living and entertaining. The fully finished lower level adds exceptional flexibility with a spacious recreation room, a fourth bedroom, and a full bathroom, making it ideal for growing families, multi-generational living, overnight guests, a home office, or future income potential. Step outside to enjoy a fully fenced backyard offering privacy and plenty of space for children, pets, gardening, or summer BBQs. An attached garage and double driveway provide parking for up to three vehicles. Located on a quiet crescent in the desirable Westvale community, you'll appreciate the convenience of being just minutes from highly regarded schools, beautiful parks and trails, shopping, restaurants, public transit, and easy access to the University of Waterloo, Wilfrid Laurier University, and major commuter routes. Recent updates include premium laminate flooring (2023), stainless steel kitchen appliances including the fridge and stove (2023), fresh professional paint (2024), roof shingles (2016), and furnace (2018). This is an exceptional opportunity to own a beautifully maintained home in one of Waterloo's most established and family-friendly communities. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T13:44:33.076117+00:00"
+"Directions": "Westvale Drive to Pinemeadow Crescent"
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Brick"
2 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2180828"
+"ListOfficeKey": "290853"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.102"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T12:28:38Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T12:28:38Z"
+"Stories": "1.0"
+"StreetName": "PINEMEADOW"
+"StreetNumber": "92"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "4096"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29983590/92-pinemeadow-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 1066
+"BelowGradeFinishedArea": 506
+"OriginalEntryTimestamp": "2026-07-03T12:28:37.91Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1430684"
+"ListOfficeNationalAssociationId": "1394395"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983590')"
+"ID": "1588834"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25326
+post_id: "1588844"
+post_author: 1
+"ListingKey": "29983638"
+"ListingId": "40844336"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T13:05:20Z"
+"RFModificationTimestamp": "2026-07-03T13:40:17Z"
+"ListPrice": 459900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 871.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2N3G8"
+"UnparsedAddress": "42 WEST ACRES Crescent Unit# 6, Kitchener, Ontario N2N3G8"
+"Coordinates": array:2 [
0 => -80.5421456
1 => 43.4252848
]
+"Latitude": 43.4252848
+"Longitude": -80.5421456
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Offering a spacious, well-appointed interior, this beautifully maintained condo delivers an exceptional combination of value, comfort, and location, making it an ideal opportunity for first-time buyers, downsizers, and investors alike. The expansive open-concept living area provides plenty of room to relax, entertain, or work from home, while the stylish kitchen serves as the heart of the home, featuring white cabinetry, subway tile backsplash, quartz countertops, stainless steel appliances, an island with breakfast bar, and ample workspace and cabinetry. A thoughtfully designed layout includes a conveniently located 4-piece main bath, a generously sized secondary bedroom that is perfect for guests or a home office, and a private primary retreat complete with a large closet, 4-piece ensuite, and walkout to your own balcony. Additional storage is available in the hall closet and utility room, which also houses the in-suite laundry. Perfectly situated within a residential neighbourhood, yet just minutes from public transit, The Boardwalk, shopping, restaurants, and Highway 7/8, this home offers the convenience today's buyers are looking for. Combined with low monthly condo fees and professional property management, this is an outstanding opportunity to enjoy affordable, low-maintenance homeownership with the comfort, convenience, and lifestyle today's buyers value most. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"AssociationFee": "304"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T13:40:12.771084+00:00"
+"Directions": "Highland Rd W to Westheights Dr to West Acres Cres"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2101905"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-03T12:48:34Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T12:59:10Z"
+"Stories": "1.0"
+"StreetName": "WEST ACRES"
+"StreetNumber": "42"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "337 - Forest Heights"
+"TaxAnnualAmount": "2966.66"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/6_42_west_acres_crescent_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29983638/42-west-acres-crescent-unit-6-kitchener"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1908292"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "289541"
+"GeocodeManualYN": true
+"ZoningDescription": "RES-5"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 871
+"OriginalEntryTimestamp": "2026-07-03T12:48:34.35Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1371695"
+"ListOfficeNationalAssociationId": "1324759"
+"CoListAgentNationalAssociationId": "1221205"
+"CoListOfficeNationalAssociationId": "1378680"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29983638')"
+"ID": "1588844"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25321
+post_id: "1586550"
+post_author: 1
+"ListingKey": "29982077"
+"ListingId": "40844186"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T17:45:39Z"
+"RFModificationTimestamp": "2026-07-03T17:52:20Z"
+"ListPrice": 1099000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2230.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2A3K6"
+"UnparsedAddress": "46 HUNTINGDALE Drive, Kitchener, Ontario N2A3K6"
+"Coordinates": array:2 [
0 => -80.5348763
1 => 43.4438901
]
+"Latitude": 43.4438901
+"Longitude": -80.5348763
+"YearBuilt": 1989
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 46 Huntingdale Drive in Kitchener! One of Idlewood's most mature and high demand streets to live. This home has had the pleasure of having one owner. This solid brick custom built home sits on an over sized lot with 100 feet frontage on a beautiful corner with mature gardens and trees. The main floor features a welcoming front foyer, with wood spiral staircase, formal living room, dining room kitchen with dinette, family room with wood burning fireplace, laundry with two piece bathroom and two additional door entrances to the home. The second level features four bedrooms and two 4 piece bathrooms. You will love the spacious primary bedroom with separate closet/seating area and ensuite. The finished walkout has a spacious seating area with lots of room for storage and 3 piece bathroom and walk in utility room. The basement has large windows and separate entrance to the downstairs patio. This home has many large windows for natural light. You have plenty of room for parking with 5 spaces. This family and friendly neighborhood is minutes away to schools, school bus routes, public transit, shopping, Chicopee Ski Hills, walking trails and so much more. 46 Huntingdale Drive is waiting for its new owner......don't miss your chance to see this beautiful home. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Freezer"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T23:23:21.824538+00:00"
+"Directions": "Old Chicopee to Huntingdale Drive."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:4 [
0 => "Wood"
1 => "Electric"
2 => "Other - See remarks"
3 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2088562"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T22:10:38Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T17:18:55Z"
+"Stories": "2.0"
+"StreetName": "HUNTINGDALE"
+"StreetNumber": "46"
+"StreetSuffix": "Drive"
+"SubdivisionName": "232 - Idlewood/Lackner Woods"
+"TaxAnnualAmount": "6525.52"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/46_huntington_pl_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29982077/46-huntingdale-drive-kitchener"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R2A"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 100.0
+"AboveGradeFinishedArea": 2230
+"OriginalEntryTimestamp": "2026-07-02T22:10:37.98Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1361859"
+"ListOfficeNationalAssociationId": "1004370"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29982077')"
+"ID": "1586550"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1585840"
+post_author: 1
+"ListingKey": "29977000"
+"ListingId": "X13510020"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T12:25:22Z"
+"RFModificationTimestamp": "2026-07-02T19:49:22Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2N3P3"
+"UnparsedAddress": "302 OPRINGTON PLACE, Kitchener, Ontario N2N3P3"
+"Coordinates": array:2 [
0 => -80.534423
1 => 43.432297
]
+"Latitude": 43.432297
+"Longitude": -80.534423
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully refreshed detached home, perfectly situated on a desirable corner lot in one of Kitchener's most sought-after neighbourhoods. Offering 1,435 sq. ft. of thoughtfully designed living space, this move-in-ready home features 3 spacious bedrooms, 1.5 bathrooms, and a versatile upper-level family room-ideal as a second living area, home office, children's playroom, or media space. The recently updated kitchen is the heart of the home, providing a bright, functional space for everyday living and entertaining. Freshly painted throughout, the home offers a clean, modern feel that allows you to simply unpack and enjoy. Step through the walkout to the private rear yard, perfect for summer BBQs, relaxing, or creating your own outdoor oasis. The unfinished basement presents endless potential for future living space, a home gym, recreation room, or additional storage. Complete with an attached single-car garage and a private driveway accommodating two additional vehicles, this home delivers both comfort and convenience. Located close to excellent schools, parks, shopping, walking trails, public transit, and major commuter routes, this is an exceptional opportunity to own a well-maintained home in a family-friendly community. Fresh, functional, and full of potential-this is one you won't want to miss. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Wall Mounted TV"
5 => "Stove"
6 => "Dryer"
7 => "Blinds"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T19:49:16.866211+00:00"
+"Directions": "Cross Streets: Victoria St & Fischer-Hallman Rd. ** Directions: Corner lot."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Flooring": array:3 [
0 => "Tile"
1 => "Laminate"
2 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1891767"
+"ListOfficeKey": "280349"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "134.1 x 88.8 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T12:18:24Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T12:18:24Z"
+"Stories": "2.0"
+"StreetName": "Oprington"
+"StreetNumber": "302"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "4316.41"
+"VirtualTourURLUnbranded": "https://youriguide.com/302_oprington_pl_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29977000/302-oprington-place-kitchener"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 134.1
+"OriginalEntryTimestamp": "2026-07-02T12:18:24.39Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1211972"
+"ListOfficeNationalAssociationId": "1312983"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977000')"
+"ID": "1585840"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25349
+post_id: "1584208"
+post_author: 1
+"ListingKey": "29977963"
+"ListingId": "40841754"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T15:00:17Z"
+"RFModificationTimestamp": "2026-07-02T17:24:31Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2384.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1X7"
+"UnparsedAddress": "482 FOXHILL Place, Waterloo, Ontario N2T1X7"
+"Coordinates": array:2 [
0 => -80.560245
1 => 43.4482842
]
+"Latitude": 43.4482842
+"Longitude": -80.560245
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled on a quiet court and backing onto mature woodland & walking trails, this exceptional setting offers nature at your doorstep including an easy walk to Westvale Park, complete with play structures, a pond, sledding hills & scenic trails. This lovingly maintained family home is being offered for sale the first time in over 30 years. The beautiful winding staircase welcomes you into the spacious foyer. Formal living and dining rooms feature oak hardwood flooring, creating warm and inviting spaces for entertaining. The kitchen offers newer stainless steel appliances (2020), neutral vinyl flooring and a bright breakfast nook with w/o to the back deck, perfect for summer BBQs. The adjacent family room is highlighted by a cozy wood-burning fireplace & a second w/o overlooking the treed backyard. Outside, the tiered private rear yard offers multiple usable spaces that have hosted everything from a sandbox and playhouse to hammocks and winter sledding. Convenience is built into everyday living with a main floor laundry room featuring access to both the side yard and double garage. Parking for 6 cars total including garage and no sidewalk to shovel! A 2-piece powder room completes the main level. Upstairs you'll find 4 generous bedrooms, including a spacious primary retreat with double door entry, walk-in closet and a 4pc ensuite. The 4pc main bathroom serves the additional bedrooms. The partially finished basement already has finished walls and ceilings, allowing you to simply choose your flooring and create additional living space. A rec room, gym or play area, abundant storage and a framed 3pc bathroom r/i provide endless possibilities. Recent updates include a furnace (2022), AC (2019), toilets, sinks, faucets, lighting, switches, newly installed carpet throughout and freshly painted. Ideally located just minutes from The Boardwalk, excellent schools, parks and convenient highway access, this well-loved home offers the perfect blend of space, privacy and location. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T17:24:28.405491+00:00"
+"Directions": "Take Erb Street West to Gateview Drive. Turn right onto Westvale Drive and follow until Foxhill Place"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564283"
+"ListOfficeKey": "296447"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Paved driveway"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T14:51:47Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T14:51:47Z"
+"Stories": "2.0"
+"StreetName": "FOXHILL"
+"StreetNumber": "482"
+"StreetSuffix": "Place"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "6058.5"
+"VirtualTourURLUnbranded": "https://youriguide.com/482_foxhill_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
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]
18 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29977963/482-foxhill-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 46.0
+"AboveGradeFinishedArea": 2053
+"BelowGradeFinishedArea": 331
+"OriginalEntryTimestamp": "2026-07-02T14:51:47.56Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1129912"
+"ListOfficeNationalAssociationId": "1458684"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977963')"
+"ID": "1584208"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25350
+post_id: "1584209"
+post_author: 1
+"ListingKey": "29978533"
+"ListingId": "X13512444"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T16:05:05Z"
+"RFModificationTimestamp": "2026-07-02T16:41:50Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1X7"
+"UnparsedAddress": "482 FOXHILL PLACE, Waterloo, Ontario N2T1X7"
+"Coordinates": array:2 [
0 => -80.560114
1 => 43.448279
]
+"Latitude": 43.448279
+"Longitude": -80.560114
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "TBD (id:62650)"
+"Appliances": array:1 [
0 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T16:41:39.382696+00:00"
+"Directions": "Cross Streets: Westvale Drive. ** Directions: Take Westvale Drive to Foxhill Place."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2256203"
+"ListOfficeKey": "296481"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Wooded area"
2 => "Backs on greenbelt"
3 => "Conservation/green belt"
]
+"LotSizeDimensions": "45.9 x 114.8 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-07-02T15:58:07Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T15:58:07Z"
+"Stories": "2.0"
+"StreetName": "Foxhill"
+"StreetNumber": "482"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "6058.5"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/482_foxhill_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
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]
18 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29978533/482-foxhill-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 45.1
+"OriginalEntryTimestamp": "2026-07-02T15:58:07.63Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1495311"
+"ListOfficeNationalAssociationId": "1470796"
+"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('29978533')"
+"ID": "1584209"
}
]
+success: true
+page_size: 9
+page_count: 14
+count: 119
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]