array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29942117 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: "1557723"
+post_author: 1
+"ListingKey": "29942117"
+"ListingId": "40841769"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T17:41:21Z"
+"RFModificationTimestamp": "2026-06-23T17:49:50Z"
+"ListPrice": 1289000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2857.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1G4"
+"UnparsedAddress": "667 FERN Road, Waterloo, Ontario N2V1G4"
+"Coordinates": array:2 [
0 => -80.5596766
1 => 43.500152
]
+"Latitude": 43.500152
+"Longitude": -80.5596766
+"YearBuilt": 1987
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare opportunity in sought-after Lakeshore North! Set on an impressive 69' x 159' mature, forested lot, this beautifully updated 4 bedroom home offers an incredible backyard oasis with a heated saltwater pool & hot tub surrounded by hardwood forest. The tranquil setting provides exceptional privacy, low maintenance landscaping & the perfect place to spend the summer relaxing, hosting family & friends, BBQing and entertaining. Inside you will find a spacious & functional layout with extensive upgrades! The kitchen is the heart of the home with an incredible 12 foot quartz island, gas stove, double ovens, updated stainless appliances, & a separate granite coffee & wine bar complete with a second sink, wine fridge & more cabinetry. The dining area is open to the cozy family room with engineered hardwood floors, overlooking the backyard with a wood burning fireplace & walkout to the deck. An additional living room provides even more space, open to the kitchen steps from the 2 pc bath and main floor laundry room. Upstairs you will find a primary bedroom with spa-like ensuite bath, 4 large bedrooms and & another renovated 4 piece bath, this is truly a family home! The finished basement offers a huge rec room with gas fireplace, 2 pc bath and spacious workshop for the woodworker or hobbyist. Many updates, including roof (2021), attic and cold cellar insulation (2018), owned water heater (2019), driveway restoration (2024), eavestroughs, soffits and leaf guards (2021), bathrooms (2024/2025). The backyard retreat has been improved with a new pool liner and heater (2024), pool pump (2026), pool cover (2025), hot tub (2024). Exceptional location, waking distance to Northlake Woods PS, nature trails, St Jacobs Farmer's Market, shopping and all amenities plus moments from expressway access. Combining modern updates, timeless character, and a spectacular natural setting, this is your chance to own a move-in-ready home on one of Lakeshore North's most desirable oversized lots. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Hood Fan"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T17:49:42.644745+00:00"
+"Directions": "Northlake Drive to Fern Road"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1909721"
+"ListOfficeKey": "77518"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T17:00:08Z"
+"PhotosCount": 41
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T17:00:08Z"
+"Stories": "2.0"
+"StreetName": "FERN"
+"StreetNumber": "667"
+"StreetSuffix": "Road"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "7439"
+"VirtualTourURLUnbranded": "https://667fern.com/idx"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1666144253"
"RoomType" => "2pc Bathroom"
"ListingId" => "40841769"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29942117"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:51:25.49Z"
]
1 => array:11 [
"RoomKey" => "1666144254"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "40841769"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29942117"
"RoomLength" => null
"RoomDimensions" => "25'6'' x 15'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:51:25.49Z"
]
2 => array:11 [
"RoomKey" => "1666144255"
"RoomType" => "Bedroom"
"ListingId" => "40841769"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29942117"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:51:25.5Z"
]
3 => array:11 [
"RoomKey" => "1666144256"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841769"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29942117"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:51:25.5Z"
]
4 => array:11 [
"RoomKey" => "1666144257"
"RoomType" => "Bedroom"
"ListingId" => "40841769"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29942117"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 14'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:51:25.5Z"
]
5 => array:11 [
"RoomKey" => "1666144258"
"RoomType" => "Bedroom"
"ListingId" => "40841769"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29942117"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:51:25.5Z"
]
6 => array:11 [
"RoomKey" => "1666144259"
"RoomType" => "3pc Bathroom"
"ListingId" => "40841769"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29942117"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:51:25.5Z"
]
7 => array:11 [
"RoomKey" => "1666144260"
"RoomType" => "Primary Bedroom"
"ListingId" => "40841769"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29942117"
"RoomLength" => null
"RoomDimensions" => "14'11'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:51:25.5Z"
]
8 => array:11 [
"RoomKey" => "1666144261"
"RoomType" => "2pc Bathroom"
"ListingId" => "40841769"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29942117"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:51:25.5Z"
]
9 => array:11 [
"RoomKey" => "1666144262"
"RoomType" => "Living room"
"ListingId" => "40841769"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29942117"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 16'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:51:25.5Z"
]
10 => array:11 [
"RoomKey" => "1666144263"
"RoomType" => "Dining room"
"ListingId" => "40841769"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29942117"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 15'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:51:25.5Z"
]
11 => array:11 [
"RoomKey" => "1666144264"
"RoomType" => "Family room"
"ListingId" => "40841769"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29942117"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 20'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:51:25.5Z"
]
12 => array:11 [
"RoomKey" => "1666144265"
"RoomType" => "Kitchen"
"ListingId" => "40841769"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29942117"
"RoomLength" => null
"RoomDimensions" => "12'11'' x 16'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T16:51:25.5Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29942117/667-fern-road-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2172119"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "77518"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 69.0
+"AboveGradeFinishedArea": 2181
+"BelowGradeFinishedArea": 676
+"OriginalEntryTimestamp": "2026-06-23T16:51:25.46Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1222004"
+"ListOfficeNationalAssociationId": "1186916"
+"CoListAgentNationalAssociationId": "1422636"
+"CoListOfficeNationalAssociationId": "1186916"
+"Media": array:41 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29942117_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/97de5e17c061a8280f17a09fe8a90051.webp"
"MediaSize" => 192399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-97de5e17c061a8280f17a09fe8a90051.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29942117_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/dff2c7e95a1037d9ad4b884584625ec1.webp"
"MediaSize" => 146165
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-dff2c7e95a1037d9ad4b884584625ec1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29942117_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/5d2b51ff3b51537e5ae83d392e3db592.webp"
"MediaSize" => 141338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-5d2b51ff3b51537e5ae83d392e3db592.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:28.83Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29942117_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/b5a6b093c60ecff9a73e8a29f50afdd5.webp"
"MediaSize" => 140942
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-b5a6b093c60ecff9a73e8a29f50afdd5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29942117_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/dbeaea80c9217a636fb9995572f803c5.webp"
"MediaSize" => 93042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-dbeaea80c9217a636fb9995572f803c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29942117_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/9f6992fbd3884de3ed2a404c10391559.webp"
"MediaSize" => 85586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-9f6992fbd3884de3ed2a404c10391559.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29942117_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/bf653e0c515729177efa8b3ab7ab2ed3.webp"
"MediaSize" => 84118
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-bf653e0c515729177efa8b3ab7ab2ed3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29942117_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/d09c93125b76b80dfd15ebb758896306.webp"
"MediaSize" => 87866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-d09c93125b76b80dfd15ebb758896306.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29942117_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/a4848b93ccd13183fd9aa88286e701ca.webp"
"MediaSize" => 80122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-a4848b93ccd13183fd9aa88286e701ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29942117_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/8794574e80f618c58190637e5609be5b.webp"
"MediaSize" => 53655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-8794574e80f618c58190637e5609be5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29942117_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/b5513a25b49a7ea145de6638d4a6ecdc.webp"
"MediaSize" => 53630
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-b5513a25b49a7ea145de6638d4a6ecdc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29942117_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/3c02814ebcd07f9a5fc8fe82ea118746.webp"
"MediaSize" => 73616
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-3c02814ebcd07f9a5fc8fe82ea118746.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29942117_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/071407333e17f27c1ab2af23fcfae9d0.webp"
"MediaSize" => 87189
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-071407333e17f27c1ab2af23fcfae9d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29942117_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/25defc65d0ea1fceb4f19393198fc25e.webp"
"MediaSize" => 102359
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-25defc65d0ea1fceb4f19393198fc25e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T17:00:08.91Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29942117_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/49819b525d626b28e7d114a1674cd194.webp"
"MediaSize" => 103339
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-49819b525d626b28e7d114a1674cd194.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29942117_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/3ba3903f78b1ebd16aa641ea5fc5daca.webp"
"MediaSize" => 90180
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-3ba3903f78b1ebd16aa641ea5fc5daca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29942117_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/98271e3dc30634e829fce225125963ac.webp"
"MediaSize" => 95280
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-98271e3dc30634e829fce225125963ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29942117_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/a92b0d210796dc93d58282cf9e172185.webp"
"MediaSize" => 99878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-a92b0d210796dc93d58282cf9e172185.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29942117_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/09cd51435d7dc14b778aeaae5f464db3.webp"
"MediaSize" => 58664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-09cd51435d7dc14b778aeaae5f464db3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29942117_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/92f74cf997b6981404c99220f88e1b50.webp"
"MediaSize" => 52127
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-92f74cf997b6981404c99220f88e1b50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29942117_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/9e6d623eebbcfab20b9161b253b24c36.webp"
"MediaSize" => 67664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-9e6d623eebbcfab20b9161b253b24c36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29942117_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/0a9eaba9f26aa879e2fde2f48aa584dc.webp"
"MediaSize" => 71963
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-0a9eaba9f26aa879e2fde2f48aa584dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29942117_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/d075efe11697ebc2c210c6da7bf282f1.webp"
"MediaSize" => 78851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-d075efe11697ebc2c210c6da7bf282f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29942117_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/9b687e1bef8c5074e6ce3083640f06bd.webp"
"MediaSize" => 47497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-9b687e1bef8c5074e6ce3083640f06bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29942117_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/2e3cbb5dbde13397fc6bb564529e69cb.webp"
"MediaSize" => 72346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-2e3cbb5dbde13397fc6bb564529e69cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29942117_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/241e22831ae2550fc0ec6ecd5699ece9.webp"
"MediaSize" => 55900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-241e22831ae2550fc0ec6ecd5699ece9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29942117_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/de23f3c551acc7b8c2db5eb697c9c4a2.webp"
"MediaSize" => 70580
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-de23f3c551acc7b8c2db5eb697c9c4a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29942117_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/1c185061edf959846de254215a8be24f.webp"
"MediaSize" => 66157
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-1c185061edf959846de254215a8be24f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29942117_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/a5f01de035e4ab3405707b4861f274ea.webp"
"MediaSize" => 58600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-a5f01de035e4ab3405707b4861f274ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29942117_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/2b0b2a14620b26f5a908486a4a5b1206.webp"
"MediaSize" => 89611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-2b0b2a14620b26f5a908486a4a5b1206.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29942117_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/3c5a5c8fdde8229b5e2d07385e517d7c.webp"
"MediaSize" => 54728
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-3c5a5c8fdde8229b5e2d07385e517d7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:27.47Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29942117_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/4e1346e16fda029181e1162f814ed4f8.webp"
"MediaSize" => 150116
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-4e1346e16fda029181e1162f814ed4f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29942117_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/44527793ab0aaa5e603afacea5318bd7.webp"
"MediaSize" => 148560
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-44527793ab0aaa5e603afacea5318bd7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29942117_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/e61d0e0bfcb3c067843f207661853bb2.webp"
"MediaSize" => 132995
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-e61d0e0bfcb3c067843f207661853bb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29942117_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/f48567e7dfab38e8ad13ae8570f46c89.webp"
"MediaSize" => 161078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-f48567e7dfab38e8ad13ae8570f46c89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29942117_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/84af4403592388e22ff6e0cf403656b3.webp"
"MediaSize" => 145299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-84af4403592388e22ff6e0cf403656b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29942117_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/99558b392700797ece08eca2abd4250f.webp"
"MediaSize" => 139050
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-99558b392700797ece08eca2abd4250f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29942117_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/95bee40502468f0e3c6a6f1f7b4404cd.webp"
"MediaSize" => 151946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-95bee40502468f0e3c6a6f1f7b4404cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29942117_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/5cb7bd647237e404c5d4fd5a5bd4c98c.webp"
"MediaSize" => 188330
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-5cb7bd647237e404c5d4fd5a5bd4c98c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29942117_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/db5730a1c4f591163270f6fc84c7a220.webp"
"MediaSize" => 214769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-db5730a1c4f591163270f6fc84c7a220.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29942117_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29942117/ee1de51760a105d9972e1ae0cab337f4.webp"
"MediaSize" => 214007
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29942117/thumbnail-ee1de51760a105d9972e1ae0cab337f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841769"
"ResourceRecordKey" => "29942117"
"ModificationTimestamp" => "2026-06-23T16:51:25.47Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29942117')"
+"ID": "1557723"
}
]
+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 77518" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24828
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1909721" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24837
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29942117'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25233
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29942117'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25249
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29942117' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5596766 43.500152)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25322
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25316
+post_id: "1558296"
+post_author: 1
+"ListingKey": "29943405"
+"ListingId": "40842220"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T20:40:39Z"
+"RFModificationTimestamp": "2026-06-23T20:43:36Z"
+"ListPrice": 855000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2760.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1E4"
+"UnparsedAddress": "108 MALLARD Crescent, Waterloo, Ontario N2V1E4"
+"Coordinates": array:2 [
0 => -80.5581303
1 => 43.4956839
]
+"Latitude": 43.4956839
+"Longitude": -80.5581303
+"YearBuilt": 1981
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Proudly positioned on a quiet street surrounded by mature trees on a beautifully landscaped pie-shaped lot, this property offers the kind of privacy and setting that's becoming harder and harder to find. Five cars fit on the newer cement-aggregate driveway, lots of toys fit in the oversized garage, and still there's room to dream bigger. Inside, a spacious foyer with not one, but two coat closets offers a warm welcome. The front living and dining rooms flow together effortlessly, framed by large windows, hardwood floors, and elegant plaster ceilings. The kitchen strikes the perfect balance between beauty and function, featuring stainless steel appliances, quartz countertops, a ceramic tile backsplash, under-mount lighting, and a pantry complete with a coffee bar. Just off the garage, you'll find the laundry room and an updated powder room, but it's the family room that steals the show. Centered around a beautifully updated gas fireplace with a stone feature wall and connected to the sunroom through sliding doors, it's easy to imagine everything from holiday gatherings to quiet evenings spent with family. Upstairs, natural oak hardwood floors continue throughout three generous bedrooms. Two full bathrooms help keep mornings running smoothly while giving everyone room to spread out comfortably. The primary suite offers a walk-in closet, a 3-piece ensuite, and a large wardrobe. Downstairs, the finished lower level is ready for movie nights, hobbies, and all the extras that make family life work a little better. The cold cellar will be perfect for your fall harvest, and the 2-piece bathroom is ready for a future shower, with a rough-in located in the utility room. The furnace (2021), water softener, most windows and doors have been updated, This is the dream property that you have been waiting for. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T20:05:29.899903+00:00"
+"Directions": "FERN/NORTHLAKE"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1878823"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Gazebo"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T19:32:27Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T20:31:46Z"
+"Stories": "2.0"
+"StreetName": "MALLARD"
+"StreetNumber": "108"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "5795"
+"VirtualTourURLUnbranded": "https://youtu.be/iujx2FoTj10"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
0 => array:11 [
"RoomKey" => "1666313397"
"RoomType" => "Utility room"
"ListingId" => "40842220"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "21'0'' x 18'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.36Z"
]
1 => array:11 [
"RoomKey" => "1666313398"
"RoomType" => "Den"
"ListingId" => "40842220"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "16'1'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.36Z"
]
2 => array:11 [
"RoomKey" => "1666313400"
"RoomType" => "Gym"
"ListingId" => "40842220"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "18'5'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.36Z"
]
3 => array:11 [
"RoomKey" => "1666313402"
"RoomType" => "2pc Bathroom"
"ListingId" => "40842220"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "4'7'' x 6'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.36Z"
]
4 => array:11 [
"RoomKey" => "1666313404"
"RoomType" => "Recreation room"
"ListingId" => "40842220"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 22'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.36Z"
]
5 => array:11 [
"RoomKey" => "1666313405"
"RoomType" => "Full bathroom"
"ListingId" => "40842220"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "5'8'' x 7'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.36Z"
]
6 => array:11 [
"RoomKey" => "1666313407"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842220"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.36Z"
]
7 => array:11 [
"RoomKey" => "1666313409"
"RoomType" => "Bedroom"
"ListingId" => "40842220"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 9'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.36Z"
]
8 => array:11 [
"RoomKey" => "1666313410"
"RoomType" => "Bedroom"
"ListingId" => "40842220"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 8'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.36Z"
]
9 => array:11 [
"RoomKey" => "1666313412"
"RoomType" => "5pc Bathroom"
"ListingId" => "40842220"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "7'9'' x 7'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.37Z"
]
10 => array:11 [
"RoomKey" => "1666313413"
"RoomType" => "Laundry room"
"ListingId" => "40842220"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 5'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.37Z"
]
11 => array:11 [
"RoomKey" => "1666313415"
"RoomType" => "2pc Bathroom"
"ListingId" => "40842220"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "3'11'' x 6'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.37Z"
]
12 => array:11 [
"RoomKey" => "1666313419"
"RoomType" => "Sunroom"
"ListingId" => "40842220"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 12'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.37Z"
]
13 => array:11 [
"RoomKey" => "1666313420"
"RoomType" => "Family room"
"ListingId" => "40842220"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "13'1'' x 21'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.37Z"
]
14 => array:11 [
"RoomKey" => "1666313422"
"RoomType" => "Kitchen"
"ListingId" => "40842220"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.37Z"
]
15 => array:11 [
"RoomKey" => "1666313424"
"RoomType" => "Dinette"
"ListingId" => "40842220"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "7'11'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.37Z"
]
16 => array:11 [
"RoomKey" => "1666313425"
"RoomType" => "Dining room"
"ListingId" => "40842220"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.37Z"
]
17 => array:11 [
"RoomKey" => "1666313427"
"RoomType" => "Living room"
"ListingId" => "40842220"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "15'9'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.37Z"
]
18 => array:11 [
"RoomKey" => "1666313428"
"RoomType" => "Foyer"
"ListingId" => "40842220"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943405"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 9'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T20:31:46.37Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29943405/108-mallard-crescent-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 43.0
+"AboveGradeFinishedArea": 1943
+"BelowGradeFinishedArea": 817
+"OriginalEntryTimestamp": "2026-06-23T19:32:27.61Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1205262"
+"ListOfficeNationalAssociationId": "1473831"
+"Media": array:39 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29943405_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943405/fac42beeaea9440413ef59baf8f256d4.webp"
…10
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29943405')"
+"ID": "1558296"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25318
+post_id: "1556740"
+post_author: 1
+"ListingKey": "29940666"
+"ListingId": "40842058"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T16:20:23Z"
+"RFModificationTimestamp": "2026-06-23T16:23:25Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2034.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4W9"
+"UnparsedAddress": "176 WOODVILLE Place, Waterloo, Ontario N2L4W9"
+"Coordinates": array:2 [
0 => -80.547439
1 => 43.4910554
]
+"Latitude": 43.4910554
+"Longitude": -80.547439
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Cul-de-sac living! Welcome to 176 Woodville Place, a beautifully maintained raised bungalow situated on a quiet cul-de-sac in a prime location. This spacious 5-bedroom, 2-bathroom home is perfect for families looking for a move-in-ready property with great potential. Freshly painted throughout, the functional layout features a fully finished walk-out basement with a separate entrance, offering excellent flexibility. The bright lower level has full sized windows, making this style of home perfect for an in-law set up or totally separate rental unit conversion. Some notable updates include : Furnace/AC/Roof (2022) and most windows (2021). The home comes with an attached single-car garage and 4 car driveway offers space for everyone. No rental contracts to worry about. Relax on the raised deck with newly installed stairs, or enjoy the inground concrete pool—a true serene oasis for the summer months. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T14:36:55.431146+00:00"
+"Directions": "Parkside Dr to Cedarbrae Ave to Mt Anne Dr to Woodville Place"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2053490"
+"ListOfficeKey": "76840"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T14:11:54Z"
+"PhotosCount": 40
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T16:11:31Z"
+"Stories": "1.0"
+"StreetName": "WOODVILLE"
+"StreetNumber": "176"
+"StreetSuffix": "Place"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "4891"
+"VirtualTourURLUnbranded": "https://youriguide.com/176_woodville_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29940666/176-woodville-place-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2102262"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76840"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1198
+"BelowGradeFinishedArea": 836
+"OriginalEntryTimestamp": "2026-06-23T14:11:54.56Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1328779"
+"ListOfficeNationalAssociationId": "1004363"
+"CoListAgentNationalAssociationId": "1372011"
+"CoListOfficeNationalAssociationId": "1004363"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29940666')"
+"ID": "1556740"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25315
+post_id: "1552069"
+post_author: 1
+"ListingKey": "29917845"
+"ListingId": "40840697"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T20:40:17Z"
+"RFModificationTimestamp": "2026-06-20T20:44:29Z"
+"ListPrice": 949900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2735.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2H3"
+"UnparsedAddress": "599 COLDSTREAM Drive, Waterloo, Ontario N2V2H3"
+"Coordinates": array:2 [
0 => -80.5750905
1 => 43.4932507
]
+"Latitude": 43.4932507
+"Longitude": -80.5750905
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Custom-built 4-bedroom backsplit offering approximately 2,700 sq. ft. of finished living space on a stunning premium lot backing onto greenspace, a playground, and a scenic pond. The bright and spacious main level showcases soaring cathedral ceilings in the living and dining rooms, creating an impressive open-concept feel. The custom kitchen overlooks the family room and features a walkout to the deck, perfect for BBQ, Matching Custom made kitchen table and chairs included. The upper level offers three generous bedrooms with California Shutters and a spacious main bath complete with a relaxing jacuzzi tub. The expansive lower level features a large family room with a cozy gas fireplace, a fourth bedroom or ideal home office with California Shutters, and a walkout to a covered porch and fully fenced backyard with gate to park. The finished rec room provides additional living space for family gatherings, recreation, or a media room. An exceptional family home in a highly desirable setting with beautiful views and direct access to nature. Excellent location close to schools & Universities, walking trails, Laurel Creek Conservation area, community centres, library, St. Jacobs Farmers Market, quick highway access! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Stove"
5 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-20T20:44:21.682407+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564233"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T19:20:57Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T20:31:36Z"
+"Stories": "3.0"
+"StreetName": "COLDSTREAM"
+"StreetNumber": "599"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "6001.09"
+"VirtualTourURLUnbranded": "https://youriguide.com/599_coldstream_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29917845/599-coldstream-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 65.0
+"AboveGradeFinishedArea": 2119
+"BelowGradeFinishedArea": 616
+"OriginalEntryTimestamp": "2026-06-17T19:20:57.11Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070035"
+"ListOfficeNationalAssociationId": "1324759"
+"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('29917845')"
+"ID": "1552069"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25319
+post_id: "1551024"
+post_author: 1
+"ListingKey": "29932336"
+"ListingId": "X13470220"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T16:25:09Z"
+"RFModificationTimestamp": "2026-06-20T16:29:03Z"
+"ListPrice": 649000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1L2"
+"UnparsedAddress": "142 CORNERBROOK CRESCENT, Waterloo, Ontario N2V1L2"
+"Coordinates": array:2 [
0 => -80.565797
1 => 43.492815
]
+"Latitude": 43.492815
+"Longitude": -80.565797
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "ATTENTION FIRST-TIME HOME BUYERS & INVESTORS Step into modern living with this stunning fully renovated 3-bedroom detached home, linked only by the foundation, offering the perfect combination of luxury, comfort, and value. From the moment you arrive, this beautiful residence is designed to impress.The heart of the home features a chef-inspired kitchen complete with premium quartz countertops, a stylish backsplash, and sleek stainless steel appliances. Elegant 24x24 porcelain tiles flow throughout the main living areas and lead seamlessly to a private backyard retreat - perfect for entertaining family and friends.The professionally finished basement adds even more functionality with an upgraded bathroom and convenient lower-level laundry. Every detail has been thoughtfully updated to provide a move-in-ready experience.Ideally located in a highly sought-after neighborhood with quick access to major highways, the university, schools, shopping, restaurants, parks, and all everyday amenities. A rare opportunity to own a beautifully upgraded home in a prime location. Perfect for first-time buyers, growing families, or savvy investors. Pride of ownership is evident throughout. Don't miss your chance to make this exceptional property your own! (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-20T04:41:37.241885+00:00"
+"Directions": "Northfield Dr. & Westmount Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2141660"
+"ListOfficeKey": "277986"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "33 x 106 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-20T01:47:05Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T16:18:43Z"
+"Stories": "2.0"
+"StreetName": "Cornerbrook"
+"StreetNumber": "142"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3288"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29932336/142-cornerbrook-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 33.0
+"OriginalEntryTimestamp": "2026-06-20T01:47:05.64Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1393502"
+"ListOfficeNationalAssociationId": "1287892"
+"Media": array:1 [
0 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932336')"
+"ID": "1551024"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25317
+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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29929082')"
+"ID": "1548416"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25292
+post_id: "1547613"
+post_author: 1
+"ListingKey": "29928209"
+"ListingId": "40840623"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-21T19:40:09Z"
+"RFModificationTimestamp": "2026-06-21T19:44:16Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1408.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4G1"
+"UnparsedAddress": "513 WEBER Street N Unit# B, Waterloo, Ontario N2L4G1"
+"Coordinates": array:2 [
0 => -80.5393879
1 => 43.4918568
]
+"Latitude": 43.4918568
+"Longitude": -80.5393879
+"YearBuilt": 1972
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful condo townhome in an ideal location. This 2 story, one bathroom home features an open concept dining / living room with a sliding glass door to your brick patio and walking trail along the creek and park. The outdoor pool is fantastic for families to cool off in the summer! Upstairs you'll find 2 bedrooms, with a very spacious primary room and a 4 piece bath. The finished basement is great extra space with a rec room and home gym, office or crafts area. The wall split heating/cooling units offer consistent heating and cooling throughout the home plus a cozy gas fireplace in the living room when you want some extra ambiance. Located close to universities, shopping, public transit and the expressway, this is a great opportunity for young families to get into the housing market or for investors looking to add to their portfolio. Call today for a private showing! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "419.79"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:2 [
0 => "Wall unit"
1 => "Ductless"
]
+"CreationDate": "2026-06-19T16:49:27.120667+00:00"
+"Directions": "Turn south off Weber St N"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1993299"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Ravine"
]
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-19T15:32:23Z"
+"PhotosCount": 39
+"PoolFeatures": array:1 [
0 => "Pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-21T19:32:07Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "WEBER"
+"StreetNumber": "513"
+"StreetSuffix": "Street"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "2606.72"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/b_513_weber_st_n_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29928209/513-weber-street-n-unit-b-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 1.0
+"AboveGradeFinishedArea": 1110
+"BelowGradeFinishedArea": 298
+"OriginalEntryTimestamp": "2026-06-19T15:32:23.08Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1276434"
+"ListOfficeNationalAssociationId": "1473831"
+"Media": array:39 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29928209')"
+"ID": "1547613"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1541891"
+post_author: 1
+"ListingKey": "29919897"
+"ListingId": "X13459364"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T12:00:21Z"
+"RFModificationTimestamp": "2026-06-22T12:04:14Z"
+"ListPrice": 929900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4V8"
+"UnparsedAddress": "535 SPRUCEHILL AVENUE, Waterloo, Ontario N2L4V8"
+"Coordinates": array:2 [
0 => -80.5485904
1 => 43.4901956
]
+"Latitude": 43.4901956
+"Longitude": -80.5485904
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Set well back from the road on a large, private lot in a fantastic neighbourhood, this charming two-storey Cape Cod style home boasts exceptional curb appeal and a peaceful setting. Inside, you will find over 3,000 square feet of finished living space that blends timeless character with thoughtful modern updates. The tastefully updated kitchen perfectly balances style and functionality, featuring quartz countertops, stainless steel appliances, a breakfast bar, and a bright dining area ideal for everyday living. The spacious living room provides a warm and welcoming setting to relax, while the adjoining formal dining space is enhanced by picturesque views of the backyard, creating a beautiful backdrop for entertaining and family gatherings. A full bathroom and convenient access to the backyard complete the main level. Step outside to discover a truly spectacular outdoor retreat. The private, fully fenced backyard is surrounded by mature trees, creating a serene and secluded atmosphere. The large deck offers ample space for dining and relaxing, and comes complete with gas BBQ hookup. You will also find a storage shed (with electricity)! Upstairs, you'll find three generously sized and beautifully appointed bedrooms, two of which include their own dedicated den or sitting areas-perfect for a home office, reading nook, or play space! The recently renovated bathroom provides a spa-like atmosphere with its tranquil design and modern finishes. The fully finished basement adds even more versatile living space, highlighted by a cozy wood-burning fireplace and two spacious areas that can easily serve as a recreation room, home office, fitness area, or whatever suits your lifestyle. For added peace of mind, the home's major mechanical systems-including the furnace, air conditioner, water heater, and water softener-have all been recently updated. Beautifully maintained and thoughtfully updated, this exceptional home is ready to welcome its new owners. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener remote(s)"
7 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T02:20:08.307374+00:00"
+"Directions": "Cross Streets: Parkside Dr. and Cedarbrae Ave. ** Directions: Cedarbrae Ave. to Sprucehill Ave."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2003422"
+"ListOfficeKey": "85457"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "65.1 x 130.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T01:32:36Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T11:41:25Z"
+"Stories": "2.0"
+"StreetName": "Sprucehill"
+"StreetNumber": "535"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "5270.72"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/535-Sprucehill-Ave/idx"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
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]
]
+"ListAOR": "OnePoint"
+"TaxYear": 2026
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29919897/535-sprucehill-avenue-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 65.1
+"OriginalEntryTimestamp": "2026-06-18T01:32:36.43Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1286265"
+"ListOfficeNationalAssociationId": "1002051"
+"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": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919897')"
+"ID": "1541891"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25320
+post_id: "1541612"
+post_author: 1
+"ListingKey": "29919137"
+"ListingId": "X13458766"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T16:10:06Z"
+"RFModificationTimestamp": "2026-06-23T16:12:42Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4J3"
+"UnparsedAddress": "543 GLEN FORREST BOULEVARD, Waterloo, Ontario N2L4J3"
+"Coordinates": array:2 [
0 => -80.55401
1 => 43.486134
]
+"Latitude": 43.486134
+"Longitude": -80.55401
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this detached bungalow in a desirable and tucked-away Waterloo location, offering over 1,800 sq. ft. of finished living space, a huge lot, and incredible potential inside and out. Perfect for first-time buyers, investors, or multi-generational families, this home features a bright main level with 3 bedrooms, 1 full bathroom, and comfortable living and dining areas. The separate entrance to the basement adds excellent flexibility, with 4 additional bedrooms and 2 full bathrooms, making it ideal for extended family use or potential mortgage-helper income. Set on a generous lot with 60 ft. frontage, this property offers parking for up to 4 vehicles in the driveway plus 1 in the garage. The backyard is a major highlight, offering so much potential to create a private outdoor retreat, garden space, patio area, or future entertaining setup. Located in a secluded area of Waterloo while still being close to everyday amenities, shopping, schools, public transportation, Conestoga College, and the University of Waterloo, this home provides both convenience and opportunity. Whether you are looking to move in, invest, or add value over time, this property is full of possibilities. Book your private showing today! * Some photos have been virtually staged. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T00:00:06.866591+00:00"
+"Directions": "Cross Streets: BEARINGER RD / GLEN FORREST BLVD. ** Directions: BEARINGER RD TO GLEN FORREST BLVD."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2182896"
+"ListOfficeKey": "289816"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "60 x 101.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T22:19:46Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T16:03:05Z"
+"Stories": "1.0"
+"StreetName": "GLEN FORREST"
+"StreetNumber": "543"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "4425"
+"VirtualTourURLUnbranded": "https://youriguide.com/0frvu_543_glen_forrest_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29919137/543-glen-forrest-boulevard-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 60.0
+"OriginalEntryTimestamp": "2026-06-17T22:19:46.45Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1432697"
+"ListOfficeNationalAssociationId": "1381521"
+"Media": array:31 [
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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919137')"
+"ID": "1541612"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25321
+post_id: "1536562"
+post_author: 1
+"ListingKey": "29912895"
+"ListingId": "X13453290"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T17:41:06Z"
+"RFModificationTimestamp": "2026-06-23T18:00:41Z"
+"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:62650)"
+"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-23T17:20:53Z"
+"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": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912895')"
+"ID": "1536562"
}
]
+success: true
+page_size: 9
+page_count: 8
+count: 65
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]