array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29935006 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411
+post_id: "1553272"
+post_author: 1
+"ListingKey": "29935006"
+"ListingId": "40841536"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T12:00:24Z"
+"RFModificationTimestamp": "2026-06-22T13:42:48Z"
+"ListPrice": 949999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2240.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2J2"
+"UnparsedAddress": "479 TIMBERCROFT Crescent, Waterloo, Ontario N2T2J2"
+"Coordinates": array:2 [
0 => -80.5707503
1 => 43.4704296
]
+"Latitude": 43.4704296
+"Longitude": -80.5707503
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This beautiful 4-bedroom backsplit home is located in the highly sought-after Laurelwood neighbourhood of Waterloo, offering the perfect blend of space, comfort, and convenience in one of the city's most established and family-friendly communities. Situated on a mature, tree-lined street, this well-maintained property features a double-car garage and a brand-new double-wide asphalt driveway, providing ample parking and impressive curb appeal. The spacious backsplit layout offers multiple levels of living space, ideal for growing families, entertaining guests, or creating dedicated work-from-home areas.Step outside to your private backyard retreat, complete with a sparkling inground saltwater pool—perfect for relaxing on warm summer days and hosting family gatherings and outdoor celebrations.The home enjoys an exceptional location close to many of Waterloo's most desirable amenities. Families will appreciate being within easy reach of Laurelwood Public School and St. Nicholas Catholic Elementary School. Post-secondary institutions including University of Waterloo and Wilfrid Laurier University are just a short drive away, making this location ideal for university staff, faculty, and families with students. Nature lovers will enjoy the close proximity to Laurel Creek Conservation Area, offering scenic trails, recreational activities, and year-round outdoor enjoyment. Everyday conveniences are also nearby, with shopping, restaurants, services, and amenities just minutes from your doorstep. Combining a desirable backsplit design, outstanding outdoor living, excellent schools, nearby universities, and access to nature, this home presents a rare opportunity to live in one of Waterloo's most desirable mature neighbourhoods. Whether you're raising a family, entertaining friends, or simply enjoying the peaceful surroundings, this Laurelwood property offers a lifestyle that is both comfortable and convenient. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Hood Fan"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T13:42:38.585379+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "Electric"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2069548"
+"ListOfficeKey": "274404"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T11:50:15Z"
+"PhotosCount": 38
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T11:50:15Z"
+"Stories": "2.0"
+"StreetName": "TIMBERCROFT"
+"StreetNumber": "479"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5727"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1665204082"
"RoomType" => "Recreation room"
"ListingId" => "40841536"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "15'2'' x 20'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.72Z"
]
1 => array:11 [
"RoomKey" => "1665204083"
"RoomType" => "Laundry room"
"ListingId" => "40841536"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 15'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.72Z"
]
2 => array:11 [
"RoomKey" => "1665204084"
"RoomType" => "Living room"
"ListingId" => "40841536"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "18'6'' x 19'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.72Z"
]
3 => array:11 [
"RoomKey" => "1665204085"
"RoomType" => "Bedroom"
"ListingId" => "40841536"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.72Z"
]
4 => array:11 [
"RoomKey" => "1665204086"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841536"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.72Z"
]
5 => array:11 [
"RoomKey" => "1665204087"
"RoomType" => "Bedroom"
"ListingId" => "40841536"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.72Z"
]
6 => array:11 [
"RoomKey" => "1665204088"
"RoomType" => "Bedroom"
"ListingId" => "40841536"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 14'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.72Z"
]
7 => array:11 [
"RoomKey" => "1665204089"
"RoomType" => "Primary Bedroom"
"ListingId" => "40841536"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 15'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.73Z"
]
8 => array:11 [
"RoomKey" => "1665204090"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841536"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.73Z"
]
9 => array:11 [
"RoomKey" => "1665204091"
"RoomType" => "Kitchen"
"ListingId" => "40841536"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 14'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.73Z"
]
10 => array:11 [
"RoomKey" => "1665204092"
"RoomType" => "Dining room"
"ListingId" => "40841536"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29935006"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 21'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T11:50:15.73Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29935006/479-timbercroft-crescent-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1177
+"BelowGradeFinishedArea": 1063
+"OriginalEntryTimestamp": "2026-06-22T11:50:15.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1344717"
+"ListOfficeNationalAssociationId": "1254957"
+"Media": array:38 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29935006_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/e0d6d4d1e97be6f0417f8f094c404cf0.webp"
"MediaSize" => 151115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-e0d6d4d1e97be6f0417f8f094c404cf0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29935006_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/96c462901e82fefb3440e0c163b433d4.webp"
"MediaSize" => 167326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-96c462901e82fefb3440e0c163b433d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29935006_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/3d6d00c7c481a54bcc8e479384bdb1bc.webp"
"MediaSize" => 133099
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-3d6d00c7c481a54bcc8e479384bdb1bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29935006_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/a502e9c7ef53b93da3caffa15a44135b.webp"
"MediaSize" => 146735
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-a502e9c7ef53b93da3caffa15a44135b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29935006_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/164b31ecc35201012e02425f5c54bbd4.webp"
"MediaSize" => 122584
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-164b31ecc35201012e02425f5c54bbd4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29935006_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/1ba4ac7535a93c2c713bea9094fd89f2.webp"
"MediaSize" => 64130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-1ba4ac7535a93c2c713bea9094fd89f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29935006_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/bc113c474e4b28ebf335be45a8616a98.webp"
"MediaSize" => 84158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-bc113c474e4b28ebf335be45a8616a98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29935006_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/46b02810a936fe288e8949e5e9dbca6c.webp"
"MediaSize" => 92102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-46b02810a936fe288e8949e5e9dbca6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29935006_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/74eeefb2b41d9e830624a7a869e8e868.webp"
"MediaSize" => 84407
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-74eeefb2b41d9e830624a7a869e8e868.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29935006_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/7ad2ca8e5da415e295d273d4777b99e1.webp"
"MediaSize" => 87212
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-7ad2ca8e5da415e295d273d4777b99e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29935006_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/d128c5413f5db6da1b76488ce5f4fc65.webp"
"MediaSize" => 88913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-d128c5413f5db6da1b76488ce5f4fc65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29935006_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/d956295f03e240b386ee71241632ee9f.webp"
"MediaSize" => 82675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-d956295f03e240b386ee71241632ee9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29935006_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/6e6206ad813c3fe943ebdde87726b96d.webp"
"MediaSize" => 78162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-6e6206ad813c3fe943ebdde87726b96d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29935006_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/2d5a36159ff0cdbd92b4c6159f8f3dbf.webp"
"MediaSize" => 71849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-2d5a36159ff0cdbd92b4c6159f8f3dbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29935006_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/780985eebdbe276eb74fd2cac3cd338b.webp"
"MediaSize" => 85303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-780985eebdbe276eb74fd2cac3cd338b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29935006_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/17aa9ed464acc403c5540917e693d1b1.webp"
"MediaSize" => 63985
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-17aa9ed464acc403c5540917e693d1b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29935006_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/3a2e99ca690fa847d31b75563c5838fc.webp"
"MediaSize" => 69973
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-3a2e99ca690fa847d31b75563c5838fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29935006_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/37059ecc0fe259cc43dc3df486014907.webp"
"MediaSize" => 109188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-37059ecc0fe259cc43dc3df486014907.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29935006_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/31d5f66469e888c59f29c91372a617ab.webp"
"MediaSize" => 95985
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-31d5f66469e888c59f29c91372a617ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29935006_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/f256ba4d84ad185518907b78b3caa64b.webp"
"MediaSize" => 66239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-f256ba4d84ad185518907b78b3caa64b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29935006_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/c49c2083064fe97885aeed4634becd61.webp"
"MediaSize" => 70021
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-c49c2083064fe97885aeed4634becd61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29935006_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/156f2b6de6b532e84e0183f68fc628ef.webp"
"MediaSize" => 81119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-156f2b6de6b532e84e0183f68fc628ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29935006_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/b8bdc68a03de04461a147cbb78b1c24c.webp"
"MediaSize" => 157582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-b8bdc68a03de04461a147cbb78b1c24c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29935006_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/634b26c9660711192bdd87ddfce19ac1.webp"
"MediaSize" => 146813
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-634b26c9660711192bdd87ddfce19ac1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29935006_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/2bcbbb4a524e5819ca7caec662ad1a17.webp"
"MediaSize" => 144139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-2bcbbb4a524e5819ca7caec662ad1a17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29935006_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/f02ddd7062cd868686f9eee380e1d46d.webp"
"MediaSize" => 127281
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-f02ddd7062cd868686f9eee380e1d46d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29935006_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/ebcada7ce841c39aaef8957dfdd3e8a4.webp"
"MediaSize" => 130489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-ebcada7ce841c39aaef8957dfdd3e8a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29935006_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/3346a19194ecdbde782fe87024937c66.webp"
"MediaSize" => 126206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-3346a19194ecdbde782fe87024937c66.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29935006_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/f6279c1d791201dc7c5b7884b703c77f.webp"
"MediaSize" => 131312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-f6279c1d791201dc7c5b7884b703c77f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29935006_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/8773661037f19a6d04d806ec747ddea8.webp"
"MediaSize" => 135983
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-8773661037f19a6d04d806ec747ddea8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29935006_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/dd29f7940089c86dfc8afd95c7e66e0d.webp"
"MediaSize" => 158158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-dd29f7940089c86dfc8afd95c7e66e0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29935006_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/8669deb733b927939751337cd08eb818.webp"
"MediaSize" => 143390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-8669deb733b927939751337cd08eb818.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29935006_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/0515df661f0b5505441e8322c660c709.webp"
"MediaSize" => 111413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-0515df661f0b5505441e8322c660c709.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29935006_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/7510ba81493ec209cd2cf7cc4990470c.webp"
"MediaSize" => 123613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-7510ba81493ec209cd2cf7cc4990470c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29935006_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/97e02fcae3fb42ba5983caf1623b7071.webp"
"MediaSize" => 35779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-97e02fcae3fb42ba5983caf1623b7071.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29935006_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/abe4f61ed1b7751c4bc3e936c980f568.webp"
"MediaSize" => 42207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-abe4f61ed1b7751c4bc3e936c980f568.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29935006_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/901af1940ff17eb99ebac3a536725e2f.webp"
"MediaSize" => 43981
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-901af1940ff17eb99ebac3a536725e2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29935006_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935006/ffdb17f428ac1c1283ef2cc5bdac92df.webp"
"MediaSize" => 34717
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935006/thumbnail-ffdb17f428ac1c1283ef2cc5bdac92df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841536"
"ResourceRecordKey" => "29935006"
"ModificationTimestamp" => "2026-06-22T11:50:15.67Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29935006')"
+"ID": "1553272"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 274404" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24821
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2069548" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24908
+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 '29935006'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25221
+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 '29935006'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25237
+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 '29935006' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5707503 43.4704296)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25310
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25284
+post_id: "1556233"
+post_author: 1
+"ListingKey": "29939876"
+"ListingId": "40842165"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T02:20:06Z"
+"RFModificationTimestamp": "2026-06-23T04:41:37Z"
+"ListPrice": 149900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 700.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3Z4"
+"UnparsedAddress": "580 BEAVER CREEK Road Unit# Lot 158, Waterloo, Ontario N2J3Z4"
+"Coordinates": array:2 [
0 => -80.5851199
1 => 43.4834036
]
+"Latitude": 43.4834036
+"Longitude": -80.5851199
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
+"PublicRemarks": "Private serene setting in Green Acre Park. Located right next to beautiful forest and no rear or side neighbours. Approximately 700 sf plus 500 sf of freshly painted deck plus gazebo to enjoy a wonderful summer in a resort like park with lots of fun amenities. Newer French doors, roof furnace and AC. Nothing to do but enjoy. Tastefully decorated throughout with two bedrooms, one bathroom and an open concept kitchen dining and living room area. Lots of room to park on a dead end street. Large yard area with campfire pit and shed for storage. Park is closed January and February. Annual lease fees include use of all amenities to include heated swimming pool, playground, mini putt, fishing pond and more. Also includes water, sewer, garbage disposal, property taxes and common area maintenance. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T04:41:34.277607+00:00"
+"Directions": "Conservation Rd/Beaver Creek Rd"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "None"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1987928"
+"ListOfficeKey": "291581"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Crushed stone driveway"
1 => "Country residential"
2 => "Recreational"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-23T02:14:58Z"
+"PhotosCount": 22
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T02:14:58Z"
+"Stories": "1.0"
+"StreetName": "BEAVER CREEK"
+"StreetNumber": "580"
+"StreetSuffix": "Road"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1665803707"
"RoomType" => "3pc Bathroom"
"ListingId" => "40842165"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939876"
"RoomLength" => null
"RoomDimensions" => "8' x 5'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:14:58.07Z"
]
1 => array:11 [
"RoomKey" => "1665803708"
"RoomType" => "Bedroom"
"ListingId" => "40842165"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939876"
"RoomLength" => null
"RoomDimensions" => "5'11'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:14:58.07Z"
]
2 => array:11 [
"RoomKey" => "1665803709"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842165"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939876"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:14:58.07Z"
]
3 => array:11 [
"RoomKey" => "1665803710"
"RoomType" => "Living room"
"ListingId" => "40842165"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939876"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 14'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:14:58.08Z"
]
4 => array:11 [
"RoomKey" => "1665803711"
"RoomType" => "Eat in kitchen"
"ListingId" => "40842165"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939876"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:14:58.08Z"
]
]
+"ListAOR": "Brantford"
+"ListAORKey": "41"
+"ListingURL": "www.realtor.ca/real-estate/29939876/580-beaver-creek-road-unit-lot-158-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Modular"
]
+"CommonInterest": "Leasehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 700
+"OriginalEntryTimestamp": "2026-06-23T02:14:57.98Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1272130"
+"ListOfficeNationalAssociationId": "1400487"
+"Media": array:22 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29939876_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/41bebb5583f0848a9f156f8762fe65a6.webp"
"MediaSize" => 101865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-41bebb5583f0848a9f156f8762fe65a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29939876_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/2e4f7262ddd67c1c95213575e414b28a.webp"
"MediaSize" => 103635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-2e4f7262ddd67c1c95213575e414b28a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29939876_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/6844a3480ce4c91e70314cb465f86481.webp"
"MediaSize" => 101103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-6844a3480ce4c91e70314cb465f86481.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29939876_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/07d4fe3adf0e27ba8ecfdbb575f8dd80.webp"
"MediaSize" => 103635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-07d4fe3adf0e27ba8ecfdbb575f8dd80.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29939876_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/ea3799368219881e646f005cca5837c6.webp"
"MediaSize" => 88881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-ea3799368219881e646f005cca5837c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29939876_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/021bee7972cd2eb60a7e14c38909c2c6.webp"
"MediaSize" => 97840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-021bee7972cd2eb60a7e14c38909c2c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29939876_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/59df0662a88af5d1842a1634f41dd394.webp"
"MediaSize" => 76740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-59df0662a88af5d1842a1634f41dd394.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29939876_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/08ef3c531cdae9014538e6d56ad3872c.webp"
"MediaSize" => 90113
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-08ef3c531cdae9014538e6d56ad3872c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29939876_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/eeee94ff5fe13b1cb9686bb5e8cddb6a.webp"
"MediaSize" => 84219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-eeee94ff5fe13b1cb9686bb5e8cddb6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29939876_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/d7932f797d43acb5c47324cf285253c3.webp"
"MediaSize" => 104626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-d7932f797d43acb5c47324cf285253c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29939876_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/6e05ed1714670887a0df8e860263c878.webp"
"MediaSize" => 122115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-6e05ed1714670887a0df8e860263c878.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29939876_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/61aba34eade769c25897480797a20dc4.webp"
"MediaSize" => 52329
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-61aba34eade769c25897480797a20dc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29939876_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/763db300599294291270749ea39449e7.webp"
"MediaSize" => 62817
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-763db300599294291270749ea39449e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29939876_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/79a2d09f17734c81a7610b4011ade9e8.webp"
"MediaSize" => 63803
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-79a2d09f17734c81a7610b4011ade9e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29939876_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/f23d047d6627006751f6816e741a404a.webp"
"MediaSize" => 65090
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-f23d047d6627006751f6816e741a404a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29939876_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/f6bb67718de7320a324a95016b64fbd4.webp"
"MediaSize" => 61993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-f6bb67718de7320a324a95016b64fbd4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842165"
"ResourceRecordKey" => "29939876"
"ModificationTimestamp" => "2026-06-23T02:14:57.98Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29939876_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939876/dbc652ec205a2768d7cec48e6277be35.webp"
"MediaSize" => 61811
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939876/thumbnail-dbc652ec205a2768d7cec48e6277be35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29939876')"
+"ID": "1556233"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25286
+post_id: "1554239"
+post_author: 1
+"ListingKey": "29936784"
+"ListingId": "40841223"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T17:35:20Z"
+"RFModificationTimestamp": "2026-06-22T18:58:38Z"
+"ListPrice": 2425000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 6105.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6M5"
+"UnparsedAddress": "248 THE LION'S Gate, Waterloo, Ontario N2L6M5"
+"Coordinates": array:2 [
0 => -80.5522568
1 => 43.4660801
]
+"Latitude": 43.4660801
+"Longitude": -80.5522568
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A rare offering in Beechwood, this distinguished executive residence occupies one of the community's most desirable lots on a quiet cul-de-sac, backing onto mature greenery and just steps from the amenities of the Beechwood Park Homes Association. Custom-built by Bob Loebsack and meticulously maintained by its original owners, the home showcases exceptional craftsmanship, custom millwork, and timeless architectural design. The grand foyer opens to a dramatic double-height living room featuring soaring windows, French doors, and a fireplace. The custom kitchen is appointed with antique-white cabinetry, granite countertops, premium appliances, dual islands, and a distinctive breakfast area surrounded by windows. An elegant dining room with coffered ceilings and custom wainscoting provides the perfect setting for formal entertaining. A stunning main-floor library, inspired by traditional English manor homes, features floor-to-ceiling custom cabinetry, a rolling library ladder, coffered ceilings, and a fireplace, creating an exceptional home office. Upstairs, four spacious bedrooms are complemented by three full bathrooms. The luxurious primary suite offers a gas fireplace, walk-in closet, spa-inspired ensuite, and a private loft of approximately 450 sq. ft., ideal as a sitting area, or family lounge. Professionally finished by Country Lane Builders, the lower level features a family room with fireplace, bar area, fitness room, and flexible multi-purpose space. Set on approximately one-third of an acre, the backyard is designed for both recreation and entertaining, featuring a fully equipped outdoor kitchen, gas fireplace, in-ground hot tub, basketball court, and professional landscaping. Beechwood residents enjoy access to top-rated schools, extensive trails, recreation facilities, shopping, and close proximity to everyday amenities. A rare opportunity to own a home of exceptional quality, and enduring craftsmanship in one of Waterloo's premier communities. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Central Vacuum"
5 => "Gas stove(s)"
6 => "Dishwasher"
7 => "Dryer"
8 => "Oven - Built-In"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
12 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T18:58:32.761073+00:00"
+"Directions": "Columbia St W / Westmount Rd N / The Lions Gate"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "4"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "Electric"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2005428"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T17:10:33Z"
+"PhotosCount": 45
+"PoolFeatures": array:1 [
0 => "Pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T17:10:33Z"
+"Stories": "2.0"
+"StreetName": "THE LION'S"
+"StreetNumber": "248"
+"StreetSuffix": "Gate"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "13749.7"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/248_the_lions_gate_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:26 [
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]
20 => array:11 [ …11]
21 => array:11 [ …11]
22 => array:11 [ …11]
23 => array:11 [ …11]
24 => array:11 [ …11]
25 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29936784/248-the-lions-gate-waterloo"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2190750"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76807"
+"GeocodeManualYN": true
+"SecurityFeatures": array:3 [
0 => "Alarm system"
1 => "Security system"
2 => "Smoke Detectors"
]
+"ZoningDescription": "SR2A"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 4185
+"BelowGradeFinishedArea": 1920
+"OriginalEntryTimestamp": "2026-06-22T17:10:33.08Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1287777"
+"ListOfficeNationalAssociationId": "1384313"
+"CoListAgentNationalAssociationId": "1439796"
+"CoListOfficeNationalAssociationId": "1004370"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29936784')"
+"ID": "1554239"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25283
+post_id: "1548416"
+post_author: 1
+"ListingKey": "29929082"
+"ListingId": "X13467464"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T17:45:04Z"
+"RFModificationTimestamp": "2026-06-19T19:34:23Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4L2"
+"UnparsedAddress": "285 THORNCREST DRIVE, Waterloo, Ontario N2L4L2"
+"Coordinates": array:2 [
0 => -80.5537455
1 => 43.4829243
]
+"Latitude": 43.4829243
+"Longitude": -80.5537455
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Investors dream and ideal family home in a highly sought-after, family-friendly Waterloo neighborhood! Welcome to 285 Thorncrest Drive a spacious side-split situated on a deep lot with tranquil curb appeal and parking for up to 8 vehicles. This versatile home offers 6 bedrooms and 2 full bathrooms, making it perfect for large families, multigenerational living, or investors seeking strong rental income potential. The main level features hardwood flooring, a spacious open-concept living and dining area, and a walkout to the private backyard. A bright and functional kitchen serves as the heart of the home. You'll also find 3 well-sized bedrooms, a 4-piece bathroom, laundry on the main floor, and plenty of natural light throughout. The finished basement with a separate walk-up entrance offers 3 additional Rooms, a cozy living area, a second full bath, dedicated laundry, and a flexible layout that lends itself perfectly to an in-law suite or future legal duplex (buyer to verify with the city).Enjoy a private, fully fenced backyard with mature trees, perfect for outdoor relaxation and entertaining. All of this in a quiet, family-oriented neighborhood close to top-rated schools, the University of Waterloo, Wilfrid Laurier University, Conestoga College, shopping, public transit, and Laurel Creek Conservation Area. Don't miss this unique opportunity to own a turn-key property in one of Waterloos most desirable locations! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Walk-up"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T19:34:14.923364+00:00"
+"Directions": "Canewood cres./thorncrest dr."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Facing"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027523"
+"ListOfficeKey": "283291"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Wooded area"
]
+"LotSizeDimensions": "60 x 111 FT ; 59.98 ft x 111.48 ft x 93.67ft"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T16:59:21Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T16:59:21Z"
+"StreetName": "Thorncrest"
+"StreetNumber": "285"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4685"
+"VirtualTourURLUnbranded": "https://youtu.be/lBZKGuyQ3ig"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Cistern"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29929082/285-thorncrest-drive-waterloo"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2016236"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283291"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 60.0
+"OriginalEntryTimestamp": "2026-06-19T16:59:21.45Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1306909"
+"ListOfficeNationalAssociationId": "1326174"
+"CoListAgentNationalAssociationId": "1297487"
+"CoListOfficeNationalAssociationId": "1326174"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29929082')"
+"ID": "1548416"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25287
+post_id: "1543514"
+post_author: 1
+"ListingKey": "29921932"
+"ListingId": "40841103"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T16:20:06Z"
+"RFModificationTimestamp": "2026-06-18T17:34:50Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1638.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2P7"
+"UnparsedAddress": "350 ERBSVILLE Road Unit# 13, Waterloo, Ontario N2T2P7"
+"Coordinates": array:2 [
0 => -80.5787185
1 => 43.4610221
]
+"Latitude": 43.4610221
+"Longitude": -80.5787185
+"YearBuilt": 1994
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 350 Erbsville Rd #13, Waterloo! Ideally located in a highly desirable neighbourhood with convenient access to the universities, Tech Park, YMCA, shopping centres, transit, and numerous amenities. This well-maintained home offers excellent potential for first-time buyers, investors, or parents seeking housing for university students. Main floor features a functional layout with a walkout from the living room to a private deck and spacious backyard—perfect for relaxing or entertaining. The finished basement adds valuable living space, complete with a large recreation room featuring good-sized windows, laminate flooring, and a 3-piece bathroom. this home presents a fantastic opportunity to build equity and create a comfortable living space in one of Waterloo’s most sought-after locations. Don't miss this affordable entry into the Waterloo market! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "230"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T17:34:37.381920+00:00"
+"Directions": "olumbia Street W/ Erbsville Road"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1834644"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-18T16:11:13Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T16:11:13Z"
+"Stories": "2.0"
+"StreetName": "ERBSVILLE"
+"StreetNumber": "350"
+"StreetSuffix": "Road"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "3652"
+"View": "City view"
+"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/29921932/350-erbsville-road-unit-13-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD-3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1223
+"BelowGradeFinishedArea": 415
+"OriginalEntryTimestamp": "2026-06-18T15:51:28.04Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1196787"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:23 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921932')"
+"ID": "1543514"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25285
+post_id: "1536562"
+post_author: 1
+"ListingKey": "29912895"
+"ListingId": "X13453290"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T22:05:19Z"
+"RFModificationTimestamp": "2026-06-16T22:19:34Z"
+"ListPrice": 769000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4Y1"
+"UnparsedAddress": "591 DOGWOOD LANE, Waterloo, Ontario N2L4Y1"
+"Coordinates": array:2 [
0 => -80.560828
1 => 43.486633
]
+"Latitude": 43.486633
+"Longitude": -80.560828
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To Dogwood Lane! This Well-Maintained Bungalow Is Situated On A Quiet, Family-Friendly Street And Offers Comfortable Living With Excellent Income Potential. The Bright Living And Dining Areas Feature Hardwood Flooring And Large Windows For Plenty Of Natural Light. The Updated Kitchen Boasts Ceramic Flooring, Quartz Countertops, And A Stylish Backsplash. The Main Floor Includes Three Generously Sized Bedrooms With Parquet Flooring, Closets, And Separate Main Floor Laundry. The Fully Renovated (2022) Basement Features A Separate Entrance, Separate Laundry, Two Bedrooms, Vinyl Flooring, Pot Lights, A Cozy Fireplace, And A Spacious Living Area. The Bathroom Includes Ceramic Flooring, A Modern Vanity, And A Beautiful Clawfoot Soaker Tub. Enjoy A Large, Beautifully Landscaped Backyard Perfect For Entertaining. Recent Updates Include A.C./Heat Pump (Aug 2023), Furnace (Aug 2023), Tankless Water Heater (Aug 2023), Roof Insulation (Aug 2023), Water Purifier (Jun 2023), Water Filter (Jun 2023), And LeafFilter Gutter Protection (Aug 2023). Conveniently Located Close To Hwy 401, Schools, Shopping, Parks, Public Transit, And Within Walking Distance To The University Of Waterloo Campus. Move-In Ready Home Offering Comfort, Convenience, And Versatility. EXTRAS: Separate Entrance To Renovated Basement With Separate Laundry, Tankless Water Heater, Water Purifier, Water Filter, Heat Pump, LeafFilter Gutter Protection, Fireplace In Basement. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Water purifier"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
9 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Separate entrance"
2 => "Walk-up"
3 => "N/A"
4 => "N/A"
5 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T22:19:28.544312+00:00"
+"Directions": "Bearinger Road / Toll Gate/Dogwood Ln"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:4 [
0 => "Hardwood"
1 => "Parquet"
2 => "Ceramic"
3 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2105595"
+"ListOfficeKey": "164016"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "45 x 114 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T21:55:46Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T21:55:46Z"
+"Stories": "1.0"
+"StreetName": "Dogwood"
+"StreetNumber": "591"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "4316"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"View": "View"
+"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"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29912895/591-dogwood-lane-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-16T21:55:46.28Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1374868"
+"ListOfficeNationalAssociationId": "1184644"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912895')"
+"ID": "1536562"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25280
+post_id: "1536566"
+post_author: 1
+"ListingKey": "29912368"
+"ListingId": "40840265"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-21T18:40:08Z"
+"RFModificationTimestamp": "2026-06-21T18:42:31Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3143.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P1"
+"UnparsedAddress": "723 BROOKMILL Place, Waterloo, Ontario N2V2P1"
+"Coordinates": array:2 [
0 => -80.5842507
1 => 43.4746813
]
+"Latitude": 43.4746813
+"Longitude": -80.5842507
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 723 Brookmill Place in the desirable neighbourhood of Laurelwood in Waterloo. Just steps from the Laurel Creek Conservation area, this expansive 4 bedroom 4 bathroom family home offers over 3,000 square feet of updated living space you can move right into and immediately enjoy. Step inside through the double door entry way and appreciate the bright, open concept layout with hardwood & porcelain floors, 9 ft ceiling heights and updated finishes throughout. The chef’s kitchen has been carefully designed to cater to a passion for cooking and hosting, featuring a 10 ft quartz island, gas stove, wine bar with wine fridge, and two stainless steel dishwashers. Host a dinner party in the formal dining area with friends and family, or curl up by the gas fireplace in the family room on a cold night. Upstairs, the spacious primary suite serves as a luxurious retreat, complete with a beautifully appointed double sink ensuite bathroom with a glass shower and a functional walk-in closet. Three more generously sized bedrooms with hardwood floors and a 4 pc bathroom complete the upper level. The basement features a bright, expansive layout with brand new custom-ordered carpet, a 4th bathroom, and plenty of storage space. Outside, your backyard oasis awaits! Landscaped with both privacy and functionality in mind, this peaceful outdoor space with new sodding, solar lighting and a 12 ft gazebo makes you feel like you’ve escaped the busy city. Steps away from conservation trails, public and Catholic schools, the YMCA, shopping, dining, universities, golf courses and so much more. New furnace with air hydration system, new kitchen appliances, new hot Water heater tank. With an array of luxurious features and thoughtful touches inside & out, this distinguished residence offers a lifestyle of unparalleled comfort and convenience thats perfect for your family’s next chapter. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Wine Fridge"
7 => "Dryer"
8 => "Microwave"
9 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T22:16:39.528562+00:00"
+"Directions": "Laurelwood Dr/ Brookmill Ct"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2088817"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T22:11:05Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-21T18:32:15Z"
+"Stories": "2.0"
+"StreetName": "BROOKMILL"
+"StreetNumber": "723"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "6960.78"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29912368/723-brookmill-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2459
+"BelowGradeFinishedArea": 684
+"OriginalEntryTimestamp": "2026-06-16T20:51:08.12Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1362124"
+"ListOfficeNationalAssociationId": "1004357"
+"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": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912368')"
+"ID": "1536566"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1535094"
+post_author: 1
+"ListingKey": "29908779"
+"ListingId": "40835169"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T20:00:05Z"
+"RFModificationTimestamp": "2026-06-20T20:08:06Z"
+"ListPrice": 1399900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3956.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5M1"
+"UnparsedAddress": "387 STILLMEADOW Circle, Waterloo, Ontario N2L5M1"
+"Coordinates": array:2 [
0 => -80.5618392
1 => 43.4673142
]
+"Latitude": 43.4673142
+"Longitude": -80.5618392
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 387 Stillmeadow Circle, a beautifully renovated family home in one of Waterloo's most sought-after neighbourhoods. Completely transformed from top to bottom in 2018, this exceptional property blends timeless design, quality craftsmanship, and modern functionality throughout. Offering over three finished levels of living space, the home features 4 spacious bedrooms upstairs, an additional bedroom in the fully finished lower level, and 4 beautifully appointed bathrooms. The thoughtfully designed layout is ideal for growing families, with generous principal rooms, stylish finishes, and plenty of space to gather, entertain, and unwind. Step outside to your private backyard retreat backing directly onto a park, providing peaceful views, added privacy, and direct access to green space. Whether you're enjoying morning coffee on the patio or hosting summer gatherings, this outdoor setting is truly special. Additional updates include a new furnace and air conditioner installed in 2025, offering peace of mind for years to come. Located within walking distance to the community pool and tennis courts, and close to excellent schools, trails, shopping, and amenities, this is a rare opportunity to own a turnkey home in a premier Waterloo location. Move in and enjoy the perfect combination of luxury, comfort, and community living. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:53:49.943718+00:00"
+"Directions": "Columbia to Beechlawn to Stillmeadow"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1688209"
+"ListOfficeKey": "296447"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-20T19:52:20Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T19:52:20Z"
+"Stories": "2.0"
+"StreetName": "STILLMEADOW"
+"StreetNumber": "387"
+"StreetSuffix": "Circle"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "10118.54"
+"VirtualTourURLUnbranded": "https://youriguide.com/387_stillmeadow_cir_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29908779/387-stillmeadow-circle-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2099327"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283397"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 55.0
+"AboveGradeFinishedArea": 2681
+"BelowGradeFinishedArea": 1275
+"OriginalEntryTimestamp": "2026-06-16T13:31:43.12Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1173922"
+"ListOfficeNationalAssociationId": "1458684"
+"CoListAgentNationalAssociationId": "1369514"
+"CoListOfficeNationalAssociationId": "1328541"
+"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": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908779')"
+"ID": "1535094"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25288
+post_id: "1534852"
+post_author: 1
+"ListingKey": "29908777"
+"ListingId": "40839715"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T02:00:06Z"
+"RFModificationTimestamp": "2026-06-23T02:02:00Z"
+"ListPrice": 535000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1487.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2V2"
+"UnparsedAddress": "600 WHITE ELM Boulevard Unit# 9, Waterloo, Ontario N2V2V2"
+"Coordinates": array:2 [
0 => -80.5870471
1 => 43.4667674
]
+"Latitude": 43.4667674
+"Longitude": -80.5870471
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained carpet-free 3-bedroom, 2-bathroom townhome in the highly sought-after Laurelwood/Columbia Forest community of Waterloo. Featuring elegant oak hardwood flooring throughout the living area and the entire second floor, this home offers both timeless style and easy maintenance. The bright and functional open-concept main floor boasts spacious living and dining areas with large windows and sliding doors that flood the space with natural light and lead to a private deck and backyard—perfect for entertaining or relaxing outdoors. The well-appointed kitchen provides ample cabinetry and workspace, while the upper level offers three generous bedrooms, including a spacious primary bedroom with a walk-in closet and convenient access to a full bathroom. The basement includes a bathroom rough-in, presenting an excellent opportunity to add a future washroom and customize additional living space to meet your needs. Complete with an attached garage and driveway parking, this home is ideally located steps to parks, trails, public transit, and top-rated schools, and just minutes from the Boardwalk Shopping Centre, YMCA, both universities, and all major amenities. The condo fees provide exceptional value by covering major exterior components, including roof, windows, and exterior doors repair and replacement, offering added peace of mind and reduced long-term maintenance costs. An outstanding opportunity for families, first-time buyers, or investors to own in one of Waterloo’s most desirable neighbourhoods. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Garage door opener"
]
+"AssociationFee": "713.32"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:53:42.414855+00:00"
+"Directions": "Erbsville Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2055634"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "0"
+"PhotosChangeTimestamp": "2026-06-16T13:30:50Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T01:51:23Z"
+"Stories": "2.0"
+"StreetName": "WHITE ELM"
+"StreetNumber": "600"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3308.52"
+"Utilities": array:1 [
0 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/9_600_white_elm_blvd_waterloo_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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29908777/600-white-elm-boulevard-unit-9-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R7"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1367
+"BelowGradeFinishedArea": 120
+"OriginalEntryTimestamp": "2026-06-16T13:30:49.96Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1330898"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:27 [
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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908777')"
+"ID": "1534852"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25308
+post_id: "1535095"
+post_author: 1
+"ListingKey": "29909404"
+"ListingId": "X13449772"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T15:10:12Z"
+"RFModificationTimestamp": "2026-06-16T17:22:49Z"
+"ListPrice": 1399900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5M1"
+"UnparsedAddress": "387 STILLMEADOW CIRCLE, Waterloo, Ontario N2L5M1"
+"Coordinates": array:2 [
0 => -80.561844
1 => 43.467325
]
+"Latitude": 43.467325
+"Longitude": -80.561844
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 387 Stillmeadow Circle, a beautifully renovated family home in one of Waterloo's most sought-after neighbourhoods. Completely transformed from top to bottom in 2018, this exceptional property blends timeless design, quality craftsmanship, and modern functionality throughout. Offering over three finished levels of living space, the home features 4 spacious bedrooms upstairs, an additional bedroom in the fully finished lower level, and 4 beautifully appointed bathrooms. The thoughtfully designed layout is ideal for growing families, with generous principal rooms, stylish finishes, and plenty of space to gather, entertain, and unwind. Step outside to your private backyard retreat backing directly onto a park, providing peaceful views, added privacy, and direct access to green space. Whether you're enjoying morning coffee on the patio or hosting summer gatherings, this outdoor setting is truly special. Additional updates include a new furnace and air conditioner installed in 2025, offering peace of mind for years to come. Located within walking distance to the community pool and tennis courts, and close to excellent schools, trails, shopping, and amenities, this is a rare opportunity to own a turnkey home in a premier Waterloo location. Move in and enjoy the perfect combination of luxury, comfort, and community living. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Cooktop"
8 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:22:35.484541+00:00"
+"Directions": "Cross Streets: Columbia and Fischer Hallman. ** Directions: Columbia to Beechlawn to Stillmeadow."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2211703"
+"ListOfficeKey": "296481"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "55.2 x 118.2 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T15:02:20Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:02:20Z"
+"Stories": "2.0"
+"StreetName": "Stillmeadow"
+"StreetNumber": "387"
+"StreetSuffix": "Circle"
+"TaxAnnualAmount": "10118.54"
+"VirtualTourURLUnbranded": "https://youriguide.com/387_stillmeadow_cir_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29909404/387-stillmeadow-circle-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 55.2
+"OriginalEntryTimestamp": "2026-06-16T15:02:20.75Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1457628"
+"ListOfficeNationalAssociationId": "1470796"
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909404')"
+"ID": "1535095"
}
]
+success: true
+page_size: 9
+page_count: 8
+count: 72
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]