array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30055105 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23524
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23526
+post_id: "1641574"
+post_author: 1
+"ListingKey": "30055105"
+"ListingId": "40849316"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T22:40:04Z"
+"RFModificationTimestamp": "2026-07-21T22:47:39Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1621.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2H7"
+"UnparsedAddress": "421 BAIRSTOW Crescent, Waterloo, Ontario N2K2H7"
+"Coordinates": array:2 [
0 => -80.5093963
1 => 43.493022
]
+"Latitude": 43.493022
+"Longitude": -80.5093963
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome Home to this amazing SEMI-DETACHED(freehold) house in amazing location of Waterloo. This bright, open-concept home is perfect for family living and investment. It features a stylish kitchen with a large island and backyard access. A generously sized island serves as a versatile hub for casual dining, meal prep, and morning coffee, all beautifully tied together by an eye-catching backsplash. Upstairs offers three bedrooms decent sized and a 4 piece washroom. The finished basement(SEPRATE ENTRANCE) with a kitchenette and Washroom ideal for in-law suite or rent. There are lots of updates that includes Furnace(2025), Paint(2025), Electrical(2026). It's located near highways, University of Waterloo, Conestoga Mall, Shopping, RIM Park, Highway 85, St. Jacobs Farmers’ Market and much more. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-20T16:46:34.378329+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2086400"
+"ListOfficeKey": "285135"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Visual exposure"
1 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-21T22:30:43Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T22:38:09Z"
+"Stories": "2.0"
+"StreetName": "BAIRSTOW"
+"StreetNumber": "421"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "2987"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1690313815"
"RoomType" => "Kitchen"
"ListingId" => "40849316"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30055105"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T22:38:09.31Z"
]
1 => array:11 [
"RoomKey" => "1690313816"
"RoomType" => "3pc Bathroom"
"ListingId" => "40849316"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "30055105"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T22:38:09.31Z"
]
2 => array:11 [
"RoomKey" => "1690313817"
"RoomType" => "4pc Bathroom"
"ListingId" => "40849316"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30055105"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T22:38:09.31Z"
]
3 => array:11 [
"RoomKey" => "1690313818"
"RoomType" => "Recreation room"
"ListingId" => "40849316"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "30055105"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T22:38:09.31Z"
]
4 => array:11 [
"RoomKey" => "1690313819"
"RoomType" => "Bedroom"
"ListingId" => "40849316"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30055105"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T22:38:09.31Z"
]
5 => array:11 [
"RoomKey" => "1690313820"
"RoomType" => "Bedroom"
"ListingId" => "40849316"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30055105"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T22:38:09.32Z"
]
6 => array:11 [
"RoomKey" => "1690313821"
"RoomType" => "Bedroom"
"ListingId" => "40849316"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30055105"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T22:38:09.32Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30055105/421-bairstow-crescent-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1621
+"OriginalEntryTimestamp": "2026-07-20T15:38:10.17Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1359700"
+"ListOfficeNationalAssociationId": "1347769"
+"Media": array:33 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30055105_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/e914bc2f07f5600319c96545e65566bd.webp"
"MediaSize" => 57112
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-e914bc2f07f5600319c96545e65566bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen peninsula with white cabinetry and a speckled countertop"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30055105_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/de7f066865b9b9af1d60c4127fda4f2c.webp"
"MediaSize" => 76251
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-de7f066865b9b9af1d60c4127fda4f2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Multi-level exterior featuring brick and siding finishes"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30055105_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/041d63decdfe40c6a9fd14239472f431.webp"
"MediaSize" => 177645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-041d63decdfe40c6a9fd14239472f431.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick and siding exterior featuring a concrete staircase with black iron railings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30055105_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/23e0a76b136a8b58f14f467e851ca07d.webp"
"MediaSize" => 44269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-23e0a76b136a8b58f14f467e851ca07d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring cream-colored cabinetry, recessed lighting, and a tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30055105_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/48b7ae59871f3930a3a32a87bc44cf35.webp"
"MediaSize" => 71405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-48b7ae59871f3930a3a32a87bc44cf35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring a white electric range with a coordinating range hood, light-toned cabinetry, light-colored subway tile backsplash, and speckled countertops"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30055105_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/99f6667b0703ce2511e8719d99e7cd84.webp"
"MediaSize" => 76225
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-99f6667b0703ce2511e8719d99e7cd84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious kitchen featuring cream-toned cabinetry, granite-finish countertops, a subway tile backsplash, stainless steel appliances, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30055105_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/c470bfbd14e1d6830c4e53d3f8976029.webp"
"MediaSize" => 50644
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-c470bfbd14e1d6830c4e53d3f8976029.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring extensive cream-toned cabinetry, tile backsplash, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30055105_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/83cf2e59cfbfeb21fc75ed31a7f4ad8a.webp"
"MediaSize" => 53902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-83cf2e59cfbfeb21fc75ed31a7f4ad8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring wood-finish flooring, recessed lighting, and a sliding glass door leading to an outdoor deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30055105_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/354652d9627a783abd51179b1895fdbd.webp"
"MediaSize" => 66130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-354652d9627a783abd51179b1895fdbd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30055105_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/0462079693c52dd50b3af8eebb4eeaef.webp"
"MediaSize" => 69049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-0462079693c52dd50b3af8eebb4eeaef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring wood-finish flooring, recessed lighting, and a sliding glass door opening to an outdoor deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30055105_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/5ca2bdb9467d23570aa13209ab63b2e9.webp"
"MediaSize" => 68836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-5ca2bdb9467d23570aa13209ab63b2e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring rich wood-finish flooring, recessed lighting, and light neutral wall colors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30055105_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/998109e4ad6e8d9cead31588a788628d.webp"
"MediaSize" => 61209
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-998109e4ad6e8d9cead31588a788628d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept dining area featuring wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30055105_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/2e55f6752153921a52dbb7e9f68721e4.webp"
"MediaSize" => 35483
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-2e55f6752153921a52dbb7e9f68721e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30055105_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/558fa571a42b82e08b608597d79422de.webp"
"MediaSize" => 58031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-558fa571a42b82e08b608597d79422de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring a sliding window, dark wood-finish flooring, white baseboards, a flush-mount ceiling light, and a paneled interior door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30055105_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/6bac9ae7129b74a149d202ff58ef4c98.webp"
"MediaSize" => 47895
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-6bac9ae7129b74a149d202ff58ef4c98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hardwood-style flooring with white baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30055105_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/0590d650dc15e890f2be13ae8fe69530.webp"
"MediaSize" => 61125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-0590d650dc15e890f2be13ae8fe69530.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with integrated sink, chrome faucet, and a large wall mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30055105_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/eac22f2a80417321b5d197d4b9671b6a.webp"
"MediaSize" => 71779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-eac22f2a80417321b5d197d4b9671b6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathtub with full-height subway tile surround, mosaic accent bands, and chrome fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30055105_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/f6cd47db86a6d05e5d6764e4c224a353.webp"
"MediaSize" => 49946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-f6cd47db86a6d05e5d6764e4c224a353.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open hallway featuring wood-finish flooring and light wall finishes"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30055105_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/ff36b13a1485626168dd49b53ef78b63.webp"
"MediaSize" => 42039
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-ff36b13a1485626168dd49b53ef78b63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room with wood-finish flooring, light-toned walls, and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30055105_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/241e416b75fb33ecd13c26e8f46195ce.webp"
"MediaSize" => 40247
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-241e416b75fb33ecd13c26e8f46195ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hardwood-finish flooring complements light-toned walls and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30055105_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/b50716fd09b9c38b17803ef40a97b87e.webp"
"MediaSize" => 51770
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-b50716fd09b9c38b17803ef40a97b87e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring dark wood-finish flooring, white baseboards, and a white ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30055105_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/a1092391dab166cfc8850c28a81b1a39.webp"
"MediaSize" => 33383
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-a1092391dab166cfc8850c28a81b1a39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Interior space featuring dark wood-finish flooring, light-colored walls, and white baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30055105_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/005c48538070006ca18d79ad074f6bfc.webp"
"MediaSize" => 75847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-005c48538070006ca18d79ad074f6bfc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry area featuring stacked washer and dryer units"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30055105_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/10a10b1747064c86dab725ef693a7993.webp"
"MediaSize" => 40213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-10a10b1747064c86dab725ef693a7993.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Compact kitchen featuring white cabinetry, a single basin stainless steel sink, wood-finish flooring, a white electric range, and a white refrigerator"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30055105_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/1773934984bc9bac0185185d2c0f826c.webp"
"MediaSize" => 55273
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-1773934984bc9bac0185185d2c0f826c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, a bright window with blue curtains, and a rectangular light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30055105_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/ce3e42ce5325c90f0a3a4c0fae525ebd.webp"
"MediaSize" => 46640
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-ce3e42ce5325c90f0a3a4c0fae525ebd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Studio layout featuring wood-finish flooring and a white color palette"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30055105_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/ef5740752895c1d5892a46bd7a4ff679.webp"
"MediaSize" => 42242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-ef5740752895c1d5892a46bd7a4ff679.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30055105_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/074ea9064db9c1701440723fbe755d03.webp"
"MediaSize" => 59860
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-074ea9064db9c1701440723fbe755d03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a dark wood-finish vanity with a speckled countertop and an undermount sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30055105_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/097879ec7814e6c31c7b1421be952a55.webp"
"MediaSize" => 54956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-097879ec7814e6c31c7b1421be952a55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Frosted glass shower enclosure featuring a handheld showerhead"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30055105_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/d44a07f0dab243470d76195405b614de.webp"
"MediaSize" => 177489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-d44a07f0dab243470d76195405b614de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive rear yard featuring green space, mature trees, and privacy fencing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30055105_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/053fcfe25eb52626216997036657b717.webp"
"MediaSize" => 199396
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-053fcfe25eb52626216997036657b717.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior featuring a wood deck with stairs, a brown shingle roof, and multiple windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30055105_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/782338161ee3c33767046c265b950f17.webp"
"MediaSize" => 156315
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-782338161ee3c33767046c265b950f17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial view of a residential property with a brown shingle roof, a paved driveway, and a partially visible rear deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30055105_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30055105/0a1732b39518fa7a1533a242e454f19e.webp"
"MediaSize" => 139972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30055105/thumbnail-0a1732b39518fa7a1533a242e454f19e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Residential neighborhood featuring mature trees and established homes"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849316"
"ResourceRecordKey" => "30055105"
"ModificationTimestamp" => "2026-07-20T15:38:10.17Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30055105')"
+"ID": "1641574"
}
]
+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=OfficeKey eq 285135" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25008
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24955
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX Real Estate Centre Inc."
+"OfficeEmail": null
+"OfficePhone": "519-741-0950"
+"OfficeMlsId": "KW316"
+"ModificationTimestamp": "2026-06-09T16:24:08Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "285135"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "720 Westmount Road East, Unit B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Kitchener"
+"OfficePostalCode": "N2E2M"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1347769"
+"OriginalEntryTimestamp": "2019-04-25T17:54:00Z"
+"OfficeFax": "519-741-0957"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "328748"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "285135"
"SocialMediaUrlOrId" => "http://www.remaxcentre.ca/"
"ModificationTimestamp" => "2026-06-09T14:37:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1419927"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('285135')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2086400" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24942
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30055105'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25336
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30055105' AND OpenHouseDate ge '2026-07-22'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25352
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30055105' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5093963 43.493022)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25425
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25399
+post_id: "1642891"
+post_author: 1
+"ListingKey": "30057197"
+"ListingId": "40847669"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T20:45:02Z"
+"RFModificationTimestamp": "2026-07-20T20:47:29Z"
+"ListPrice": 875000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1807.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2R8"
+"UnparsedAddress": "85 FOXHUNT Road, Waterloo, Ontario N2K2R8"
+"Coordinates": array:2 [
0 => -80.5203746
1 => 43.4963584
]
+"Latitude": 43.4963584
+"Longitude": -80.5203746
+"YearBuilt": 1985
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "At 85 Foxhunt Road, every level has a purpose. This updated four-level side split in established Colonial Acres delivers bright, open living, multiple gathering spaces and a flexible lower-level layout. The main floor features wide-plank flooring, pot lights and a spacious living room anchored by a striking stone fireplace wall. The refreshed kitchen combines white cabinetry, a tile backsplash, gas range and contrasting island, while the adjoining dining area opens to a sun-filled 16'9 x 9'10 enclosed sunroom overlooking the backyard. Upstairs, three well-proportioned bedrooms are grouped with an updated four-piece bathroom. The lower level adds a generous family room, two-piece powder room and attached single garage. Down one more level, a versatile room currently staged as a bedroom is joined by a beautifully finished three-piece bathroom with glass shower, a second kitchenette area and laundry space. This flexible configuration provides valuable options for overnight guests, extended-household living, recreation or work-from-home needs. Outside, the deep fenced backyard offers mature greenery, a deck and plenty of room to garden, entertain or simply enjoy the outdoors. Colonial Acres is an established north Waterloo neighbourhood known for its low-density residential character, mature streets and generous green space. Anndale Park and the surrounding trail network provide convenient opportunities to walk, cycle and enjoy the outdoors. Nearby RIM Park, Waterloo’s largest recreation complex, offers rinks, courts, sports fields, trails and natural areas. Conestoga Mall places shopping, dining and everyday services within easy reach, while Conestoga Station provides access to ION light rail and multiple GRT routes. Highway 85 also offers convenient connections throughout Waterloo Region. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Freezer"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-20T20:47:21.750445+00:00"
+"Directions": "DAVENPORT ROAD TO KINGSCOURT DRIVE TO REDFOX ROAD TO FOXHUNT ROAD"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1963616"
+"ListOfficeKey": "289848"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-20T20:29:44Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T20:38:25Z"
+"Stories": "3.0"
+"StreetName": "FOXHUNT"
+"StreetNumber": "85"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "4683.23"
+"VirtualTourURLUnbranded": "https://youriguide.com/85_foxhunt_road_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1689520551"
"RoomType" => "Cold room"
"ListingId" => "40847669"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30057197"
"RoomLength" => null
"RoomDimensions" => "19'8'' x 3'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T20:38:25.89Z"
]
1 => array:11 [
"RoomKey" => "1689520552"
"RoomType" => "3pc Bathroom"
"ListingId" => "40847669"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30057197"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 9'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T20:38:25.89Z"
]
2 => array:11 [
"RoomKey" => "1689520553"
"RoomType" => "Bedroom"
"ListingId" => "40847669"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30057197"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T20:38:25.89Z"
]
3 => array:11 [
"RoomKey" => "1689520554"
"RoomType" => "Utility room"
"ListingId" => "40847669"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "30057197"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T20:38:25.89Z"
]
4 => array:11 [
"RoomKey" => "1689520555"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "40847669"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30057197"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T20:38:25.9Z"
]
5 => array:11 [
"RoomKey" => "1689520556"
"RoomType" => "2pc Bathroom"
"ListingId" => "40847669"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "30057197"
"RoomLength" => null
"RoomDimensions" => "3'1'' x 6'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T20:38:25.9Z"
]
6 => array:11 [
"RoomKey" => "1689520557"
"RoomType" => "Recreation room"
"ListingId" => "40847669"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "30057197"
"RoomLength" => null
"RoomDimensions" => "16'9'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T20:38:25.9Z"
]
7 => array:11 [
"RoomKey" => "1689520558"
"RoomType" => "4pc Bathroom"
"ListingId" => "40847669"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30057197"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T20:38:25.9Z"
]
8 => array:11 [
"RoomKey" => "1689520559"
"RoomType" => "Bedroom"
"ListingId" => "40847669"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30057197"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T20:38:25.9Z"
]
9 => array:11 [
"RoomKey" => "1689520560"
"RoomType" => "Bedroom"
"ListingId" => "40847669"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30057197"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T20:38:25.9Z"
]
10 => array:11 [
"RoomKey" => "1689520561"
"RoomType" => "Primary Bedroom"
"ListingId" => "40847669"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30057197"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T20:38:25.9Z"
]
11 => array:11 [
"RoomKey" => "1689520562"
"RoomType" => "Sitting room"
"ListingId" => "40847669"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30057197"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 16'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T20:38:25.9Z"
]
12 => array:11 [
"RoomKey" => "1689520563"
"RoomType" => "Kitchen"
"ListingId" => "40847669"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30057197"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T20:38:25.9Z"
]
13 => array:11 [
"RoomKey" => "1689520564"
"RoomType" => "Dining room"
"ListingId" => "40847669"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30057197"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T20:38:25.9Z"
]
14 => array:11 [
"RoomKey" => "1689520565"
"RoomType" => "Living room"
"ListingId" => "40847669"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30057197"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-20T20:38:25.9Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30057197/85-foxhunt-road-waterloo"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 130.0
+"AboveGradeFinishedArea": 1341
+"BelowGradeFinishedArea": 466
+"OriginalEntryTimestamp": "2026-07-20T20:29:44.63Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1252593"
+"ListOfficeNationalAssociationId": "1381908"
+"Media": array:42 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30057197_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057197/4e204b8796561f90b45c281af2c49cd5.webp"
"MediaSize" => 123816
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057197/thumbnail-4e204b8796561f90b45c281af2c49cd5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40847669"
"ResourceRecordKey" => "30057197"
"ModificationTimestamp" => "2026-07-20T20:29:44.64Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30057197_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057197/b2f86a44aa18a5c9ca967b517f5b0710.webp"
"MediaSize" => 87781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057197/thumbnail-b2f86a44aa18a5c9ca967b517f5b0710.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847669"
"ResourceRecordKey" => "30057197"
"ModificationTimestamp" => "2026-07-20T20:29:44.64Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30057197_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057197/598e570132f570b5c2e27fef2a85dcde.webp"
"MediaSize" => 83758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057197/thumbnail-598e570132f570b5c2e27fef2a85dcde.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847669"
"ResourceRecordKey" => "30057197"
"ModificationTimestamp" => "2026-07-20T20:29:44.64Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30057197_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057197/1908ed1caef39882bd8383707b4f6d0f.webp"
"MediaSize" => 69695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30057197/thumbnail-1908ed1caef39882bd8383707b4f6d0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847669"
"ResourceRecordKey" => "30057197"
"ModificationTimestamp" => "2026-07-20T20:29:44.64Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30057197_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30057197/23afaaf0d03f7dcf38db4132fdefa786.webp"
"MediaSize" => 87781
…9
]
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30057197')"
+"ID": "1642891"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25420
+post_id: "1641978"
+post_author: 1
+"ListingKey": "30055388"
+"ListingId": "40849520"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T00:00:02Z"
+"RFModificationTimestamp": "2026-07-21T00:12:33Z"
+"ListPrice": 875000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.148
+"LivingArea": 2360.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4Y5"
+"UnparsedAddress": "249 DEARBORN Boulevard, Waterloo, Ontario N2J4Y5"
+"Coordinates": array:2 [
0 => -80.5205663
1 => 43.4889151
]
+"Latitude": 43.4889151
+"Longitude": -80.5205663
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This stunning updated two-bedroom bungalow combines modern luxury with effortless main-floor living. The bright, open-concept kitchen boasts beautifully updated cabinets and countertops, flowing seamlessly into a spacious great room anchored by a cozy gas fireplace. The main floor features a primary bedroom retreat complete with a private ensuite bathroom, a second large bedroom, second full bath and a highly convenient main-floor laundry room. Stepping outside, the fully fenced and landscaped backyard serves as a private oasis, full fencing and accented by vibrant perennial gardens. The outdoor living space features a brand-new deck, a relaxing hot tub with privacy screening, a newly installed storage shed.. Other updates are a lifetime steel roof and new eaves, complemented by a premium stone driveway and an updated furnace for complete peace of mind. Downstairs, the fully finished basement exponentially expands your living space, offering two additional bedrooms, a full bathroom, a massive recreation area perfect for hosting, and a dedicated bonus zone tailored for a home gym. Access for Forwell Creek and Hillside Park trails are right across the road, step into nature with deer, owls, Forwell and Laurel Creeks with walking/biking paths that connect to the Laurel Trial and travel as far as Manulife with a short remaining walk on sidewalks to Conestoga Mall. Great access to shopping, U of W and link to the LRT with one quick bus. or hop on the expressway a short trip away. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-20T19:41:06.965397+00:00"
+"Directions": "From Lexington to Dearborn Blvd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564385"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.148"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-20T23:51:41Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T23:51:41Z"
+"Stories": "1.0"
+"StreetName": "DEARBORN"
+"StreetNumber": "249"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "5300"
+"VirtualTourURLUnbranded": "https://youriguide.com/249_dearborn_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30055388/249-dearborn-boulevard-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2182352"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283125"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 66.0
+"AboveGradeFinishedArea": 1260
+"BelowGradeFinishedArea": 1100
+"OriginalEntryTimestamp": "2026-07-20T16:29:19.95Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1140376"
+"ListOfficeNationalAssociationId": "1324759"
+"CoListAgentNationalAssociationId": "1432148"
+"CoListOfficeNationalAssociationId": "1324759"
+"Media": array:46 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30055388')"
+"ID": "1641978"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25398
+post_id: "1641573"
+post_author: 1
+"ListingKey": "30054688"
+"ListingId": "X13583064"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T23:45:02Z"
+"RFModificationTimestamp": "2026-07-21T23:48:37Z"
+"ListPrice": 1550000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4C5"
+"UnparsedAddress": "608 BLUENOSE CRESCENT, Waterloo, Ontario N2K4C5"
+"Coordinates": array:2 [
0 => -80.50276
1 => 43.510091
]
+"Latitude": 43.510091
+"Longitude": -80.50276
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to sough-after Eastbridge! Tucked away on a quiet crescent, this exceptional custom-built family home offers over 4,400 sq ft of beautifully finished living space designed for growing or multi-generational families. This home has so much to offer: 4 spacious bedrooms upstairs, 2 additional bedrooms in the professionally finished basement, a main floor office, upper media room, 3.5 bathrooms including a stunning primary ensuite - there's room for everyone!! The open concept layout showcases a stunning maple kitchen with granite countertops, a bright dining area overlooking the backyard, a grand great room with gas fireplace, quality maple and ceramic flooring, and elegant finishes throughout. Step outside to your private, fully-fenced backyard oasis complete with a patio, shed, beautiful landscaping, and lawn sprinkler system - perfect for relaxing or entertaining. An oversized double garage, aggregate concrete driveway with parking for 4 vehicles, and numerous updates complete the package. Located minutes from top-rated schools, RIM Park, Grey Silo Gold Course, walking trails, shopping, and all the amenities that make Eastbridge one of Waterloo's most desirable neighbourhoods. This is the forever family home you've been waiting for. (id:62650)"
+"Appliances": array:14 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Range"
6 => "Oven"
7 => "Dryer"
8 => "Microwave"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
12 => "Garage door opener remote(s)"
13 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-20T17:08:50.240518+00:00"
+"Directions": "Cross Streets: EASTBRIDGE BLVD. ** Directions: UNIVERSITY AVE 3. TO NEW BEDFORD DR. TO EASTBRIDGE BLVD. TO BLUENOSE CRES."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2102028"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "80.3 x 125.7 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-20T14:40:47Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T23:38:18Z"
+"Stories": "2.0"
+"StreetName": "Bluenose"
+"StreetNumber": "608"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "7906"
+"VirtualTourURLUnbranded": "https://youriguide.com/608_bluenose_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30054688/608-bluenose-crescent-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2240614"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "288578"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 80.3
+"OriginalEntryTimestamp": "2026-07-20T14:40:46.95Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1371816"
+"ListOfficeNationalAssociationId": "1369645"
+"CoListAgentNationalAssociationId": "1478594"
+"CoListOfficeNationalAssociationId": "1369645"
+"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('30054688')"
+"ID": "1641573"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25422
+post_id: "1639153"
+post_author: 1
+"ListingKey": "30051716"
+"ListingId": "40849228"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-22T15:40:06Z"
+"RFModificationTimestamp": "2026-07-22T15:52:23Z"
+"ListPrice": 1550000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 4403.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4C5"
+"UnparsedAddress": "608 BLUENOSE Crescent, Waterloo, Ontario N2K4C5"
+"Coordinates": array:2 [
0 => -80.502725
1 => 43.5101251
]
+"Latitude": 43.5101251
+"Longitude": -80.502725
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to sought-after Eastbridge! Tucked away on a quiet crescent, this exceptional custom-built family home offers over 4,400 sq ft of beautifully finished living space designed for growing or multi-generational families. This home has so much to offer: 4 spacious bedrooms upstairs, 2 additional bedrooms in the professionally finished basement, a main floor office, upper media room, 3.5 bathrooms including a stunning primary ensuite - there's room for everyone!! The open concept layout showcases a stunning maple kitchen with granite countertops, a bright dining area overlooking the backyard, a grand great room with gas fireplace, quality maple and ceramic flooring, and elegant finishes throughout. Step outside to your private, fully-fenced backyard oasis complete with a patio, shed, beautiful landscaping, and lawn sprinkler system - perfect for relaxing or entertaining. An oversized double garage, aggregate concrete driveway with parking for 4 vehicles, and numerous updates complete the package. Located minutes from top-rated schools, RIM Park, Grey Silo Golf Course, walking trails, shopping, and all the amenities that make Eastbridge one of Waterloo's most desirable neighbourhoods. This is the forever family home you've been waiting for. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Range - Gas"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-18T14:00:12.688051+00:00"
+"Directions": "UNIVERSITY AVE E. TO NEW BEDFORD DR. TO EASTBRIDGE BLVD. TO BLUENOSE CRES."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1645520"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-22T15:38:06Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-22T15:38:06Z"
+"Stories": "2.0"
+"StreetName": "BLUENOSE"
+"StreetNumber": "608"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "7906"
+"VirtualTourURLUnbranded": "https://youriguide.com/608_bluenose_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:20 [
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]
19 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30051716/608-bluenose-crescent-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1953029"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "289722"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 80.0
+"AboveGradeFinishedArea": 3053
+"BelowGradeFinishedArea": 1350
+"OriginalEntryTimestamp": "2026-07-18T13:28:29.41Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1166103"
+"ListOfficeNationalAssociationId": "1380559"
+"CoListAgentNationalAssociationId": "1246446"
+"CoListOfficeNationalAssociationId": "1380559"
+"Media": array:42 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30051716')"
+"ID": "1639153"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25400
+post_id: "1637877"
+post_author: 1
+"ListingKey": "30034574"
+"ListingId": "40848343"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:15:07Z"
+"RFModificationTimestamp": "2026-07-17T23:39:09Z"
+"ListPrice": 324900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1072.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4L6"
+"UnparsedAddress": "375 KING Street N Unit# 1608, Waterloo, Ontario N2J4L6"
+"Coordinates": array:2 [
0 => -80.527067
1 => 43.4824701
]
+"Latitude": 43.4824701
+"Longitude": -80.527067
+"YearBuilt": 1984
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this bright and generously sized 2-bedroom, 1-bathroom condo in the heart of Waterloo! Featuring over 1,000 sq. ft. of living space, this unit offers a functional layout with a large living/dining area, a well-appointed kitchen, and spacious bedrooms. Panoramic view from your private balcony. Conveniently located near shopping, transit, universities, and major highways, this unit is perfect for First Time home buyers, investors, or move up buyers looking to live in heart of Waterloo. Building amenities include a large gym, conference room, arts & crafts room, party room, ample visitor parking, indoor rooftop swimming pool, workshop, library , billiards table & a ping pong table. Also there is a free car wash in parking level for building residents. Book your showing today! ( Locker available & 1 covered parking available underground.) Also note that all utilities are included in the condo fees. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Sauna"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"AssociationFee": "900.76"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:8 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Electricity"
4 => "Water"
5 => "Insurance"
6 => "Other, See Remarks"
7 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T23:38:57.068795+00:00"
+"Directions": "Columbia Street West & King Street North"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2073879"
+"ListOfficeKey": "76775"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Backs on greenbelt"
1 => "Balcony"
2 => "Country residential"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-07-15T11:49:34Z"
+"PhotosCount": 47
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:09:31Z"
+"Stories": "1.0"
+"StreetDirSuffix": "North"
+"StreetName": "KING"
+"StreetNumber": "375"
+"StreetSuffix": "Street"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "2110"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Telephone"
]
+"View": "City view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30034574/375-king-street-n-unit-1608-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "RMU-81"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1072
+"OriginalEntryTimestamp": "2026-07-15T11:49:34.62Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1355211"
+"ListOfficeNationalAssociationId": "1004341"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30034574')"
+"ID": "1637877"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25395
+post_id: "1638163"
+post_author: 1
+"ListingKey": "30036629"
+"ListingId": "40848337"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T18:45:08Z"
+"RFModificationTimestamp": "2026-07-21T18:48:28Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3569.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3J2"
+"UnparsedAddress": "381 TIMLOCK Place, Waterloo, Ontario N2K3J2"
+"Coordinates": array:2 [
0 => -80.5015241
1 => 43.4976811
]
+"Latitude": 43.4976811
+"Longitude": -80.5015241
+"YearBuilt": 1987
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "You know a good street the moment you turn onto it. This one has mature trees, an easy quiet, and houses that rarely come up for sale, because once people land here, they tend to stop looking. The main floor is fully accessible, built for the way life actually unfolds day to day, and the primary suite lives right here too, ensuite renovated in 2021, zero stairs between you and any part of your routine. Simple, smart, and the kind of thing you'll be grateful for long after move-in day. Two fireplaces, two completely different moods. The living room's custom gas fireplace is made for slow, quiet nights. Down the hall, the family room plays a different game entirely, a WETT-certified wood burning fireplace that turns an ordinary Tuesday into something worth showing up for. Upstairs, three bedrooms and a full bath give everyone room to spread out. Downstairs, the finished basement is fully move-in ready as-is, with plenty of room to make it yours whenever you're ready for a refresh. Every update here was made by people who planned to stay for good: new flooring, a reverse osmosis system, and a brand new sump pump, all in 2026. Then step outside to a deck with a natural gas fire table, built for the first warm night of the year and every one after it. Minutes to UW, Laurier, Grey Silo, and the Waterloo Rec Complex, close enough for convenience, far enough to feel like its own world. Homes on this street rarely change hands. This is your shot. (id:62650)"
+"AccessibilityFeatures": array:1 [
0 => "Accessible Approach with Ramp"
]
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Central Vacuum - Roughed In"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T23:34:43.505895+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Baseboard heaters"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2087705"
+"ListOfficeKey": "292624"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T17:52:10Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T18:38:29Z"
+"Stories": "2.0"
+"StreetName": "TIMLOCK"
+"StreetNumber": "381"
+"StreetSuffix": "Place"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "6877"
+"VirtualTourURLUnbranded": "https://show.tours/jBj9bjy6"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30036629/381-timlock-place-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2213528"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "291822"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 64.0
+"AboveGradeFinishedArea": 2489
+"BelowGradeFinishedArea": 1080
+"OriginalEntryTimestamp": "2026-07-15T16:48:14.35Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1361010"
+"ListOfficeNationalAssociationId": "1414872"
+"CoListAgentNationalAssociationId": "1459332"
+"CoListOfficeNationalAssociationId": "1405037"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30036629')"
+"ID": "1638163"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23538
+post_id: "1637290"
+post_author: 1
+"ListingKey": "30049958"
+"ListingId": "40848397"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T17:45:04Z"
+"RFModificationTimestamp": "2026-07-20T17:47:47Z"
+"ListPrice": 839900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2587.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2V2"
+"UnparsedAddress": "369 CRIMSON Drive, Waterloo, Ontario N2K2V2"
+"Coordinates": array:2 [
0 => -80.4962545
1 => 43.4930651
]
+"Latitude": 43.4930651
+"Longitude": -80.4962545
+"YearBuilt": 1984
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 369 Crimson Drive! This spacious, beautifully maintained 3-bedroom bungalow offers 2,587 sqft of thoughtfully designed finished living space in one of Waterloo's most desirable neighbourhoods. The functional layout is perfect for families, professionals, or downsizers seeking the convenience of bungalow living without compromising on space. Bright principal rooms, generously sized bedrooms, ensuite bathroom plus 2 more full bathrooms, and a well-designed floor plan create a home that is both comfortable and inviting. The fully finished basement provides exceptional additional living space with two more bedrooms, a private office, a large recreation room, a full bathroom, and numerous storage rooms—ideal for growing families, guests, hobbies, or multi-generational living. Outside, enjoy a mature, established community where everything is within walking distance. Parks, scenic trails, playgrounds, schools, the library, community centre, shopping, and golf courses are all nearby, making it easy to enjoy an active lifestyle. Convenient access to the expressway, public transit, hospitals, universities, and major amenities adds to the home's outstanding location. Quality bungalows in this sought-after Waterloo neighbourhood are a rare find. Some updates include floors, ensuite bathroom, lighting, roof, windows, and more. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T21:30:09.235227+00:00"
+"Directions": "BRIDGE"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564276"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Paved driveway"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-20T17:42:04Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T17:42:04Z"
+"Stories": "1.0"
+"StreetName": "CRIMSON"
+"StreetNumber": "369"
+"StreetSuffix": "Drive"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "5743.36"
+"Utilities": array:1 [
0 => "Cable"
]
+"VirtualTourURLUnbranded": "https://paulreibelphotography.hd.pics/369-Crimson-Dr"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30049958/369-crimson-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 61.0
+"AboveGradeFinishedArea": 1472
+"BelowGradeFinishedArea": 1115
+"OriginalEntryTimestamp": "2026-07-17T20:29:17.88Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1107226"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30049958')"
+"ID": "1637290"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25423
+post_id: "1637269"
+post_author: 1
+"ListingKey": "30032462"
+"ListingId": "40848006"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T15:25:13Z"
+"RFModificationTimestamp": "2026-07-20T15:34:31Z"
+"ListPrice": 695000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2287.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4G8"
+"UnparsedAddress": "460 WOOLWICH Street Unit# 24, Waterloo, Ontario N2K4G8"
+"Coordinates": array:2 [
0 => -80.4929093
1 => 43.5006176
]
+"Latitude": 43.5006176
+"Longitude": -80.4929093
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Spacious executive townhome in desirable Riverstone Estates with 2,287 sq. ft. of finished living space, a low $235/month condo fee, garage + driveway parking, and a highly desirable East Waterloo location near the Grand River and Walter Bean Trail. Offering the space and function of a detached home with the convenience of condo living, this bright 3-bedroom, 3-bathroom multi-level home delivers exceptional value in a mature, well-located community. The open-concept main floor features generous living, dining, and kitchen areas, a gas fireplace, and walkout to a private deck. The second level includes two bedrooms and a 4-piece bath, while the private upper-level primary suite offers a full ensuite and walk-in closet. The finished walkout lower level provides valuable extra living space for a family room, office, gym, guest area, or media room, with inside garage access, laundry/mechanical space, and storage. Private driveway parking plus ample visitor parking directly in front of the unit adds everyday convenience. Close to Kiwanis Park, Grey Silo Golf Course, RIM Park, schools, shopping, expressway access, the Grand River, and connected trail systems. Flexible closing available. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"AssociationFee": "235"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:44:42.251968+00:00"
+"Directions": "Off Woolwich"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564596"
+"ListOfficeKey": "76831"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T15:04:18Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T15:18:45Z"
+"Stories": "3.0"
+"StreetName": "WOOLWICH"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "4712.14"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30032462/460-woolwich-street-unit-24-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1950017"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "299554"
+"GeocodeManualYN": true
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1620
+"BelowGradeFinishedArea": 667
+"OriginalEntryTimestamp": "2026-07-14T19:48:22.74Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1095797"
+"ListOfficeNationalAssociationId": "1004391"
+"CoListAgentNationalAssociationId": "1244287"
+"CoListOfficeNationalAssociationId": "1473831"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30032462')"
+"ID": "1637269"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25424
+post_id: "1635984"
+post_author: 1
+"ListingKey": "30048467"
+"ListingId": "40846494"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T15:35:20Z"
+"RFModificationTimestamp": "2026-07-21T15:41:39Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1197.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2E4"
+"UnparsedAddress": "327 GRANGEWOOD Drive, Waterloo, Ontario N2K2E4"
+"Coordinates": array:2 [
0 => -80.5005382
1 => 43.4915326
]
+"Latitude": 43.4915326
+"Longitude": -80.5005382
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 327 Grangewood Drive! This adorable 3-bedroom home is nestled in one of Waterloo's established family-friendly neighbourhoods. Bright and inviting, the spacious kitchen with dining area features large windows that fill the home with natural light, while the oversized living room offers plenty of space for family gatherings and entertaining. Ideal for first-time buyers, young families, or those looking to downsize. A convenient second entrance to the main floor includes additional closet space and provides easy access to the basement. Enjoy the private backyard with plenty of room to relax, entertain, or let children and pets play among the mature surroundings. Located close to excellent schools, parks, walking trails, shopping, public transit, and with quick access to the expressway, this home offers an exceptional lifestyle in a sought-after Waterloo community. Many updates have already been completed, including large windows, roof, kitchen, furnace, central air conditioning, water softener, and front door. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T19:15:19.565143+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Other"
]
+"FireplaceFeatures": array:1 [
0 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564276"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-07-21T15:25:23Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T15:29:26Z"
+"Stories": "1.0"
+"StreetName": "GRANGEWOOD"
+"StreetNumber": "327"
+"StreetSuffix": "Drive"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "4153.56"
+"VirtualTourURLUnbranded": "https://paulreibelphotography.hd.pics/327-Grangewood-Dr"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30048467/327-grangewood-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 44.0
+"AboveGradeFinishedArea": 1197
+"OriginalEntryTimestamp": "2026-07-17T17:18:39.36Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1107226"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30048467')"
+"ID": "1635984"
}
]
+success: true
+page_size: 9
+page_count: 12
+count: 103
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]