array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29912090 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1536272"
+post_author: 1
+"ListingKey": "29912090"
+"ListingId": "40838984"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T02:40:13Z"
+"RFModificationTimestamp": "2026-06-17T02:46:19Z"
+"ListPrice": 800000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.12
+"LivingArea": 2776.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2J3"
+"UnparsedAddress": "491 SANDBANKS Crescent, Waterloo, Ontario N2V2J3"
+"Coordinates": array:2 [
0 => -80.5768545
1 => 43.4964646
]
+"Latitude": 43.4964646
+"Longitude": -80.5768545
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "IS THIS YOUR NEW HOME? Situated in desirable Conservation Meadows, this 2 Storey home offers a special option for those needing accessible features, including a main floor bedroom and ramp to the front door (2015) and also a ramp off the deck (2016). The stunning acacia engineered hardwood flooring (2019) greets you as you enter this bright and spacious main floor. The updates continue into the kitchen with new white cabinetry, quartz counters, stainless appliances and dimmable pot lights (2022). The sliders to the backyard walk out to the peaceful backyard showcasing lovely perennial gardens, and also features an Arctic Spa Yukon hot tub. Upstairs you will find 3 good-sized bedrooms including a spacious primary bedroom with large walk-in closet, and a long bathroom with potential for splitting it into two (a main bath and an ensuite bath). In the finished basement you will find a newly finished rec room, large utility room / workshop area, laundry room, cold cellar, and a separate den/office/storage room (potential for a 5th bedroom!). Additional updates include roof (2014), air conditioner (2017) washer/dryer (approx 2021), dishwasher (2024). (id:62783)"
+"AccessibilityFeatures": array:1 [
0 => "Accessible Approach with Ramp"
]
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T20:49:21.761386+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1990854"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Sump Pump"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T00:32:16Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T02:32:01Z"
+"Stories": "2.0"
+"StreetName": "SANDBANKS"
+"StreetNumber": "491"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "6158"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/491-Sandbanks-Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1660925768"
"RoomType" => "Laundry room"
"ListingId" => "40838984"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29912090"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:32:01.8Z"
]
1 => array:11 [
"RoomKey" => "1660925769"
"RoomType" => "Bonus Room"
"ListingId" => "40838984"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29912090"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 14'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:32:01.8Z"
]
2 => array:11 [
"RoomKey" => "1660925770"
"RoomType" => "Utility room"
"ListingId" => "40838984"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29912090"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:32:01.81Z"
]
3 => array:11 [
"RoomKey" => "1660925771"
"RoomType" => "Recreation room"
"ListingId" => "40838984"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29912090"
"RoomLength" => null
"RoomDimensions" => "25'1'' x 25'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:32:01.81Z"
]
4 => array:11 [
"RoomKey" => "1660925772"
"RoomType" => "3pc Bathroom"
"ListingId" => "40838984"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29912090"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:32:01.81Z"
]
5 => array:11 [
"RoomKey" => "1660925773"
"RoomType" => "4pc Bathroom"
"ListingId" => "40838984"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912090"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:32:01.82Z"
]
6 => array:11 [
"RoomKey" => "1660925774"
"RoomType" => "Bedroom"
"ListingId" => "40838984"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912090"
"RoomLength" => null
"RoomDimensions" => "14'1'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:32:01.82Z"
]
7 => array:11 [
"RoomKey" => "1660925775"
"RoomType" => "Bedroom"
"ListingId" => "40838984"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912090"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:32:01.83Z"
]
8 => array:11 [
"RoomKey" => "1660925776"
"RoomType" => "Primary Bedroom"
"ListingId" => "40838984"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29912090"
"RoomLength" => null
"RoomDimensions" => "17'9'' x 17'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:32:01.83Z"
]
9 => array:11 [
"RoomKey" => "1660925777"
"RoomType" => "3pc Bathroom"
"ListingId" => "40838984"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29912090"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:32:01.84Z"
]
10 => array:11 [
"RoomKey" => "1660925778"
"RoomType" => "Bedroom"
"ListingId" => "40838984"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29912090"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 13'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:32:01.84Z"
]
11 => array:11 [
"RoomKey" => "1660925779"
"RoomType" => "Kitchen"
"ListingId" => "40838984"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29912090"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:32:01.85Z"
]
12 => array:11 [
"RoomKey" => "1660925780"
"RoomType" => "Dining room"
"ListingId" => "40838984"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29912090"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:32:01.85Z"
]
13 => array:11 [
"RoomKey" => "1660925781"
"RoomType" => "Living room"
"ListingId" => "40838984"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29912090"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 33'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T02:32:01.85Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29912090/491-sandbanks-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 2063
+"BelowGradeFinishedArea": 713
+"OriginalEntryTimestamp": "2026-06-16T20:10:34.34Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1274526"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:45 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29912090_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/b2668276286491390ec37f810512ce6b.webp"
"MediaSize" => 136960
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-b2668276286491390ec37f810512ce6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.71Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29912090_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/9ff308f6f3a37dbfbca98cf4a7dd8d6e.webp"
"MediaSize" => 116910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-9ff308f6f3a37dbfbca98cf4a7dd8d6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.26Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29912090_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/b68943a49f4a35b269f80f33142ea355.webp"
"MediaSize" => 134699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-b68943a49f4a35b269f80f33142ea355.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Ramp and step entrance integrated into landscaping"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:26.79Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29912090_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/678d5a7ec01b7995ccafbb4f41d819d6.webp"
"MediaSize" => 137908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-678d5a7ec01b7995ccafbb4f41d819d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:29.36Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29912090_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/013d7b59a3a6de9076ccd65e176094a7.webp"
"MediaSize" => 61367
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-013d7b59a3a6de9076ccd65e176094a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.26Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29912090_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/7d53d1da042d84a82bb02a985f845bc9.webp"
"MediaSize" => 75116
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-7d53d1da042d84a82bb02a985f845bc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.02Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29912090_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/f64f8a8607d80f3d9027bbcd6439c422.webp"
"MediaSize" => 78253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-f64f8a8607d80f3d9027bbcd6439c422.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.26Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29912090_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/cec6b2e5d5e43e167c8314aafba9323b.webp"
"MediaSize" => 88279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-cec6b2e5d5e43e167c8314aafba9323b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.03Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29912090_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/b42ccf3dab610dd2f9ad2f15e3eb1b15.webp"
"MediaSize" => 70158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-b42ccf3dab610dd2f9ad2f15e3eb1b15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.04Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29912090_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/bd4f0c6a15ef3cd497e7d713351003ad.webp"
"MediaSize" => 68302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-bd4f0c6a15ef3cd497e7d713351003ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.26Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29912090_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/af3657167832da8adb25fc29e2cc94f1.webp"
"MediaSize" => 97437
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-af3657167832da8adb25fc29e2cc94f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.26Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29912090_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/917800f5e13f76ae56623348ab64c46f.webp"
"MediaSize" => 97859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-917800f5e13f76ae56623348ab64c46f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:26.88Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29912090_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/3fdf0fcec59c1a29ba549dd27bdb07c5.webp"
"MediaSize" => 73974
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-3fdf0fcec59c1a29ba549dd27bdb07c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.27Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29912090_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/2919658cafdbda49c346451edbc70552.webp"
"MediaSize" => 82930
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-2919658cafdbda49c346451edbc70552.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.07Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29912090_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/40d77630bc2f08e965e6727156ff2d81.webp"
"MediaSize" => 90500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-40d77630bc2f08e965e6727156ff2d81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.06Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29912090_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/845917392d1095acc21ef8a29fdef434.webp"
"MediaSize" => 84582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-845917392d1095acc21ef8a29fdef434.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.71Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29912090_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/5166082c9417bae9b890ae16cb75bd3a.webp"
"MediaSize" => 86941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-5166082c9417bae9b890ae16cb75bd3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.81Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29912090_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/ee1b796e0296f369aab09de80d8f0ce3.webp"
"MediaSize" => 74255
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-ee1b796e0296f369aab09de80d8f0ce3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.02Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29912090_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/86b617d48dfeb3dfb48c8e29447ac56f.webp"
"MediaSize" => 85351
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-86b617d48dfeb3dfb48c8e29447ac56f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.05Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29912090_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/11dbd64ed26d801b281110d50441a450.webp"
"MediaSize" => 80606
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-11dbd64ed26d801b281110d50441a450.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.71Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29912090_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/8ec2338e81e4309ee531850ea29ad125.webp"
"MediaSize" => 62538
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-8ec2338e81e4309ee531850ea29ad125.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:30.03Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29912090_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/3a192345073d3deeb8f17a40b695e94a.webp"
"MediaSize" => 66682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-3a192345073d3deeb8f17a40b695e94a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.26Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29912090_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/cd0198ad763d149d646932304cf0fd11.webp"
"MediaSize" => 60715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-cd0198ad763d149d646932304cf0fd11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.02Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29912090_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/437bdfe39a519c29dd1aeda44f574bc9.webp"
"MediaSize" => 47140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-437bdfe39a519c29dd1aeda44f574bc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.06Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29912090_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/cbbd207b6cb4469f5e4f5978c289638d.webp"
"MediaSize" => 75730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-cbbd207b6cb4469f5e4f5978c289638d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Large walk-in closet with built-in shelving"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.87Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29912090_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/c33a7767e6ec1c2480cea2f0d8434f94.webp"
"MediaSize" => 78794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-c33a7767e6ec1c2480cea2f0d8434f94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.06Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29912090_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/13eea77ee4cdd24bef490d9ccaa19925.webp"
"MediaSize" => 66492
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-13eea77ee4cdd24bef490d9ccaa19925.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.73Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29912090_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/950aed71ba308d960f1d8a095d9eb464.webp"
"MediaSize" => 63206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-950aed71ba308d960f1d8a095d9eb464.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.71Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29912090_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/486d348b2e0c1041ab6885d87b6e36dd.webp"
"MediaSize" => 68375
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-486d348b2e0c1041ab6885d87b6e36dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:29.36Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29912090_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/ed848bbcaa5d7200561dae51dfe10ee0.webp"
"MediaSize" => 57506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-ed848bbcaa5d7200561dae51dfe10ee0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.73Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29912090_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/38014f12407d82755332e79363be6e70.webp"
"MediaSize" => 61272
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-38014f12407d82755332e79363be6e70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:29.36Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29912090_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/60fbaf728d3aa6934237bec41d897416.webp"
"MediaSize" => 60832
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-60fbaf728d3aa6934237bec41d897416.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.71Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29912090_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/04b25be73a4b9c54af44300e7815d975.webp"
"MediaSize" => 74313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-04b25be73a4b9c54af44300e7815d975.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.71Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29912090_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/9a53c2ed0713120138271dcaf096d7b8.webp"
"MediaSize" => 67177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-9a53c2ed0713120138271dcaf096d7b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:30.03Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29912090_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/d09c39ab7c3004913f6c758a6111b138.webp"
"MediaSize" => 75854
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-d09c39ab7c3004913f6c758a6111b138.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.08Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29912090_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/1121870cee3e44b7adb71cfa3fed1725.webp"
"MediaSize" => 70994
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-1121870cee3e44b7adb71cfa3fed1725.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.06Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29912090_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/27850a0a80cad6e66cc543d7bb2934e5.webp"
"MediaSize" => 67444
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-27850a0a80cad6e66cc543d7bb2934e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:27.02Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29912090_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/39922b1c7abe04d780a684b06e32def9.webp"
"MediaSize" => 146486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-39922b1c7abe04d780a684b06e32def9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:30.02Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29912090_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/cd041f1901cda8ac253f06412bd9bf97.webp"
"MediaSize" => 137988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-cd041f1901cda8ac253f06412bd9bf97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-16T20:31:30.03Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29912090_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/f24a0d2e7e23e060092074a76b36c16f.webp"
"MediaSize" => 147220
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-f24a0d2e7e23e060092074a76b36c16f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-17T00:12:13.58Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29912090_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/f08a1b509852ee2326ebac3c229ccd50.webp"
"MediaSize" => 167456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-f08a1b509852ee2326ebac3c229ccd50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Ramp from deck to grass"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-17T00:12:13.6Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29912090_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/05ea843d898e282c8e2ef12509b66b69.webp"
"MediaSize" => 167585
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-05ea843d898e282c8e2ef12509b66b69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-17T00:12:13.52Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29912090_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/0c794a453f42ac8089df0a5bba4a6381.webp"
"MediaSize" => 144563
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-0c794a453f42ac8089df0a5bba4a6381.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-17T00:12:13.52Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29912090_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/1d1f207cd8749f5ee29d95c31e7a580a.webp"
"MediaSize" => 148540
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-1d1f207cd8749f5ee29d95c31e7a580a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-17T00:12:13.52Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29912090_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912090/a049364941ff37992d111a96e54ae1e3.webp"
"MediaSize" => 137074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912090/thumbnail-a049364941ff37992d111a96e54ae1e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838984"
"ResourceRecordKey" => "29912090"
"ModificationTimestamp" => "2026-06-17T00:12:13.61Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912090')"
+"ID": "1536272"
}
]
+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 289541" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24698
+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 1990854" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24699
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29912090'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25176
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29912090'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25191
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25192
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31507557"
+"ListingKey": "29912090"
+"ListingId": "40838984"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-20"
+"OpenHouseStartTime": "2026-06-20T13:00:00Z"
+"OpenHouseEndTime": "2026-06-20T15:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-16T22:27:06Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31507557')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25194
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31510939"
+"ListingKey": "29912090"
+"ListingId": "40838984"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-20"
+"OpenHouseStartTime": "2026-06-20T13:00:00Z"
+"OpenHouseEndTime": "2026-06-20T15:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-17T03:02:56Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31510939')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29912090' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5768545 43.4964646)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25250
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25244
+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 [
"RoomKey" => "1660771827"
"RoomType" => "Living room"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 3.6
"ListingKey" => "29912895"
"RoomLength" => 4.97
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.32Z"
]
1 => array:11 [
"RoomKey" => "1660771828"
"RoomType" => "Dining room"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29912895"
"RoomLength" => 2.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.32Z"
]
2 => array:11 [
"RoomKey" => "1660771829"
"RoomType" => "Kitchen"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 3.48
"ListingKey" => "29912895"
"RoomLength" => 4.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.32Z"
]
3 => array:11 [
"RoomKey" => "1660771830"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 3.14
"ListingKey" => "29912895"
"RoomLength" => 3.91
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.32Z"
]
4 => array:11 [
"RoomKey" => "1660771831"
"RoomType" => "Bedroom 2"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 2.69
"ListingKey" => "29912895"
"RoomLength" => 3.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.32Z"
]
5 => array:11 [
"RoomKey" => "1660771832"
"RoomType" => "Bedroom 3"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29912895"
"RoomLength" => 2.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.32Z"
]
6 => array:11 [
"RoomKey" => "1660771833"
"RoomType" => "Living room"
"ListingId" => "X13453290"
"RoomLevel" => "Basement"
"RoomWidth" => 4.72
"ListingKey" => "29912895"
"RoomLength" => 5.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.32Z"
]
7 => array:11 [
"RoomKey" => "1660771834"
"RoomType" => "Bedroom 4"
"ListingId" => "X13453290"
"RoomLevel" => "Basement"
"RoomWidth" => 3.96
"ListingKey" => "29912895"
"RoomLength" => 3.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.33Z"
]
8 => array:11 [
"RoomKey" => "1660771835"
"RoomType" => "Bedroom 5"
"ListingId" => "X13453290"
"RoomLevel" => "Basement"
"RoomWidth" => 3.02
"ListingKey" => "29912895"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-16T21:55:46.33Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29912895_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/fb975b8a5449de12ebf6f2bbc2755134.webp"
"MediaSize" => 535748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-fb975b8a5449de12ebf6f2bbc2755134.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29912895_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/a1c63bdb354f10c613066fab83f1b315.webp"
"MediaSize" => 467201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-a1c63bdb354f10c613066fab83f1b315.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29912895_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/8d37c3159eedb5a52e519dfe3e28d123.webp"
"MediaSize" => 410878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-8d37c3159eedb5a52e519dfe3e28d123.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912895')"
+"ID": "1536562"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25246
+post_id: "1534435"
+post_author: 1
+"ListingKey": "29909870"
+"ListingId": "X13450512"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:10:11Z"
+"RFModificationTimestamp": "2026-06-16T16:26:29Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4N7"
+"UnparsedAddress": "514 HAVELOCK DRIVE, Waterloo, Ontario N2L4N7"
+"Coordinates": array:2 [
0 => -80.55825
1 => 43.489526
]
+"Latitude": 43.489526
+"Longitude": -80.55825
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 514 Havelock Drive! Nestled in one of Waterloo's most sought-after family-friendly neighbourhoods, this well-maintained 3+1 bedroom, 2-bathroom bungalow offers the perfect combination of comfort, convenience, and future potential. The carpet-free main floor features a bright and functional layout with 3 spacious bedrooms, a full bathroom, a well-appointed kitchen, and inviting living and dining areas ideal for everyday living and entertaining. A separate side entrance provides excellent flexibility and potential for an in-law setup or multi-generational living. The fully finished basement expands your living space with a large rec room, an office or fourth bedroom, a 3-piece bathroom, laundry room, and a bonus workshop-perfect for hobbyists, DIY enthusiasts, or additional storage. Step outside to your own private retreat. The fully fenced backyard oasis is designed for relaxation and entertaining, featuring a spacious deck, storage shed, and a wooden gazebo covering the hot tub-an ideal space to unwind year-round. With parking for up to 5 vehicles, this home is perfectly suited for growing families and busy households. Deck (2023), Water Heater (2023), Washer & Dryer (2024), Roof (2023). Conveniently located just minutes from Highway 7 and Highway 8, as well as Wilfrid Laurier University, University of Waterloo, numerous parks and trails, and Conestoga Mall, this exceptional property offers an unbeatable location close to everything you need. Whether you're a growing family, investor, or buyer seeking multi-generational living potential, 514 Havelock Drive delivers outstanding value in an incredible Waterloo location. Book your private showing today! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T16:26:23.962076+00:00"
+"Directions": "Glen Forest Blvd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2127512"
+"ListOfficeKey": "283918"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Gazebo"
]
+"LotSizeDimensions": "43.1 x 122.2 FT"
+"ParkingFeatures": array:2 [
0 => "Covered"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T15:59:56Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:59:56Z"
+"Stories": "1.0"
+"StreetName": "Havelock"
+"StreetNumber": "514"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3987"
+"VirtualTourURLUnbranded": "https://youriguide.com/wqcfm_514_havelock_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": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29909870/514-havelock-drive-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 43.1
+"OriginalEntryTimestamp": "2026-06-16T15:59:55.98Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1380753"
+"ListOfficeNationalAssociationId": "1336772"
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909870')"
+"ID": "1534435"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25243
+post_id: "1534290"
+post_author: 1
+"ListingKey": "29909459"
+"ListingId": "40836533"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T15:20:10Z"
+"RFModificationTimestamp": "2026-06-16T15:36:25Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2101.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4N7"
+"UnparsedAddress": "514 HAVELOCK Drive, Waterloo, Ontario N2L4N7"
+"Coordinates": array:2 [
0 => -80.5582589
1 => 43.4895518
]
+"Latitude": 43.4895518
+"Longitude": -80.5582589
+"YearBuilt": 1971
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 514 Havelock Drive! Nestled in one of Waterloo’s most sought-after family-friendly neighbourhoods, this well-maintained 3+1 bedroom, 2-bathroom bungalow offers the perfect combination of comfort, convenience, and future potential. The carpet-free main floor features a bright and functional layout with 3 spacious bedrooms, a full bathroom, a well-appointed kitchen, and inviting living and dining areas ideal for everyday living and entertaining. A separate side entrance provides excellent flexibility and potential for an in-law setup or multi-generational living. The fully finished basement expands your living space with a large rec room, an office or fourth bedroom, a 3-piece bathroom, laundry room, and a bonus workshop—perfect for hobbyists, DIY enthusiasts, or additional storage. Step outside to your own private retreat. The fully fenced backyard oasis is designed for relaxation and entertaining, featuring a spacious deck, storage shed, and a wooden gazebo covering the hot tub—an ideal space to unwind year-round. With parking for up to 5 vehicles, this home is perfectly suited for growing families and busy households. Deck (2023), Water Heater (2023), Washer & Dryer (2024), Roof (2023). Conveniently located just minutes from Highway 7 and Highway 8, as well as Wilfrid Laurier University, University of Waterloo, numerous parks and trails, and Conestoga Mall, this exceptional property offers an unbeatable location close to everything you need. Whether you're a growing family, investor, or buyer seeking multi-generational living potential, 514 Havelock Drive delivers outstanding value in an incredible Waterloo location. Book your private showing today! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T15:36:23.785553+00:00"
+"Directions": "Glen Forest Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750161"
+"ListOfficeKey": "283896"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-06-16T15:13:40Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:13:40Z"
+"Stories": "1.0"
+"StreetName": "HAVELOCK"
+"StreetNumber": "514"
+"StreetSuffix": "Drive"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "3987"
+"VirtualTourURLUnbranded": "https://youriguide.com/wqcfm_514_havelock_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/29909459/514-havelock-drive-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 43.0
+"AboveGradeFinishedArea": 1071
+"BelowGradeFinishedArea": 1030
+"OriginalEntryTimestamp": "2026-06-16T15:11:23.62Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1163644"
+"ListOfficeNationalAssociationId": "1349002"
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909459')"
+"ID": "1534290"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25247
+post_id: "1532260"
+post_author: 1
+"ListingKey": "29903651"
+"ListingId": "40839157"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T15:40:08Z"
+"RFModificationTimestamp": "2026-06-15T20:50:40Z"
+"ListPrice": 330000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 800.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1Z1"
+"UnparsedAddress": "331 NORTHLAKE Drive Unit# 5, Waterloo, Ontario N2V1Z1"
+"Coordinates": array:2 [
0 => -80.5540193
1 => 43.5009095
]
+"Latitude": 43.5009095
+"Longitude": -80.5540193
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 5 at 331 Northlake Drive, a bright and move-in-ready condo offering a practical layout and everyday convenience, perfect for first-time buyers, downsizers, or young families. The spacious open-concept living area creates an inviting space to relax, dine, and entertain, while the kitchen offers great functionality with restored cabinetry and plenty of room for daily use. New flooring and fresh paint throughout give the unit a clean, updated feel. Two comfortable bedrooms offer versatile options for a nursery, guest room, or office, and the refreshed bathroom adds a polished touch. Enjoy the convenience of in-suite laundry, plus a storage locker for extra storage and organization. Close to schools, parks, and trails, you’ll love this location in a quiet, family-friendly Waterloo neighbourhood. Groceries, dining, and fitness options are conveniently around the corner, while Conestoga Mall and the ION Rail are nearby. If you’re looking for a low-maintenance lifestyle in a convenient location, this unit is for you! Book your private showing today. (id:62783)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"AssociationFee": "335"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-15T20:46:42.470151+00:00"
+"Directions": "Swallow Street / Northlake Drive"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2025082"
+"ListOfficeKey": "291822"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Laundry- Coin operated"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-15T15:31:21Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T15:31:20Z"
+"Stories": "1.0"
+"StreetName": "NORTHLAKE"
+"StreetNumber": "331"
+"StreetSuffix": "Drive"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "2019.49"
+"VirtualTourURLUnbranded": "https://youtu.be/tTqPA_pGGbw"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29903651/331-northlake-drive-unit-5-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1989189"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "292624"
+"GeocodeManualYN": true
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 800
+"OriginalEntryTimestamp": "2026-06-15T15:31:20.93Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1304786"
+"ListOfficeNationalAssociationId": "1405037"
+"CoListAgentNationalAssociationId": "1273184"
+"CoListOfficeNationalAssociationId": "1414872"
+"Media": array:12 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29903651')"
+"ID": "1532260"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25245
+post_id: "1525986"
+post_author: 1
+"ListingKey": "29897607"
+"ListingId": "X13439034"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T15:25:16Z"
+"RFModificationTimestamp": "2026-06-15T15:25:56Z"
+"ListPrice": 779000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4J8"
+"UnparsedAddress": "598 GLEN FORREST BOULEVARD, Waterloo, Ontario N2L4J8"
+"Coordinates": array:2 [
0 => -80.557071
1 => 43.48873
]
+"Latitude": 43.48873
+"Longitude": -80.557071
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Opportunity knocks at 598 Glen Forrest Boulevard! This spacious bungalow is very deceiving from the street! offers a versatile floor plan with 4 bedrooms on the main floor and 2 additional bedrooms in the finished lower level. The home is equipped with 2 kitchens, 2 bathrooms, and a fully separate entrance. The home is ideally suited for multi-generational living, an in-law setup, or potential income-generating possibilities. Numerous upgrades have been completed throughout the years, making this property move-in ready while still offering future potential. Enjoy a double driveway and garage for ample parking. A fantastic location close to top-rated schools, parks, shopping, transit, and Waterloo's renowned universities. 5 minutes from the future home of the new waterloo regional hospital. Quick possession available for buyers looking to make their move without delay. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T00:11:02.146610+00:00"
+"Directions": "Cross Streets: Weber St. ** Directions: Northfield to Weber St S to Glen Forrest Blvd."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2143277"
+"ListOfficeKey": "284147"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "65.6 x 114.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T15:18:48Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T15:18:48Z"
+"Stories": "1.0"
+"StreetName": "Glen Forrest"
+"StreetNumber": "598"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "5227.74"
+"VirtualTourURLUnbranded": "https://youriguide.com/598_glen_forrest_boulevard_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29897607/598-glen-forrest-boulevard-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 65.7
+"OriginalEntryTimestamp": "2026-06-12T19:50:44.02Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1406869"
+"ListOfficeNationalAssociationId": "1338998"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29897607')"
+"ID": "1525986"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25240
+post_id: "1524761"
+post_author: 1
+"ListingKey": "29895419"
+"ListingId": "40834178"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T14:00:07Z"
+"RFModificationTimestamp": "2026-06-15T14:01:15Z"
+"ListPrice": 779000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 2733.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4J8"
+"UnparsedAddress": "598 GLEN FORREST Boulevard, Waterloo, Ontario N2L4J8"
+"Coordinates": array:2 [
0 => -80.5570508
1 => 43.4888424
]
+"Latitude": 43.4888424
+"Longitude": -80.5570508
+"YearBuilt": 1971
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Opportunity knocks at 598 Glen Forrest Boulevard! This spacious bungalow is very deceiving from the street! offers a versatile floor plan with 4 bedrooms on the main floor and 2 additional bedrooms in the finished lower level. The home is equipped with 2 kitchens, 2 bathrooms, and a fully separate entrance. The home is ideally suited for multi-generational living, an in-law setup, or potential income-generating possibilities. Numerous upgrades have been completed throughout the years, making this property move-in ready while still offering future potential. Enjoy a double driveway and garage for ample parking. A fantastic location close to top-rated schools, parks, shopping, transit, and Waterloo's renowned universities. 5 minutes from the future home of the new Waterloo Regional Hospital. Quick possession available for buyers looking to make their move without delay. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T16:27:21.155206+00:00"
+"Directions": "Northfield to Weber St S to Glen Forrest Blvd"
+"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": "1876463"
+"ListOfficeKey": "289890"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T15:52:46Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T13:51:27Z"
+"Stories": "1.0"
+"StreetName": "GLEN FORREST"
+"StreetNumber": "598"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "5227.74"
+"VirtualTourURLUnbranded": "https://youriguide.com/598_glen_forrest_boulevard_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29895419/598-glen-forrest-boulevard-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "S1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 66.0
+"AboveGradeFinishedArea": 1231
+"BelowGradeFinishedArea": 1502
+"OriginalEntryTimestamp": "2026-06-12T15:52:45.97Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1204368"
+"ListOfficeNationalAssociationId": "1382470"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895419')"
+"ID": "1524761"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1522209"
+post_author: 1
+"ListingKey": "29892943"
+"ListingId": "X13434804"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T12:35:13Z"
+"RFModificationTimestamp": "2026-06-15T12:38:43Z"
+"ListPrice": 829900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4N8"
+"UnparsedAddress": "513 HAVELOCK DRIVE, Waterloo, Ontario N2L4N8"
+"Coordinates": array:2 [
0 => -80.558183
1 => 43.489124
]
+"Latitude": 43.489124
+"Longitude": -80.558183
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Lakeshore Village - One of Waterloo's Most Desirable Neighborhoods! This well-maintained 3+2 bedroom, 2 full bathroom home is perfectly situated in a sought-after, family-friendly community. Freshly painted in April 2025, the home features a custom wood kitchen with granite countertops and a functional layout ideal for everyday living. Enjoy the warmth of a wood-burning fireplace and the added versatility of a finished basement with a separate entrance, offering excellent potential for extended family or additional living space. A standout feature is the large detached garage/workshop (18' x 25') An additional garden shed provides even more utility. The large driveway offers ample parking. Step outside to a landscaped yard, perfect for relaxing or entertaining. Located just steps from the Laurel Trail system and within walking distance to public and Catholic elementary schools, this home is also minutes from Laurel Creek Conservation Area, Conestoga Mall, St. Jacobs Market, LRT, YMCA, and the expressway. A new hospital is currently being built nearby, adding future value and convenience. Additional features include a camera/security system and public transit just minutes away. A solid opportunity in a prime Waterloo location-book your showing today! (id:62783)"
+"Appliances": array:3 [
0 => "All"
1 => "Freezer"
2 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised 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-12T01:50:53.395190+00:00"
+"Directions": "Cross Streets: Northfield Dr W & Havelock Dr. ** Directions: Driving west on Northfield Drive, Turn left on Havelock drive. Property on right side."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Concrete"
1 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1923044"
+"ListOfficeKey": "279620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Irregular lot size"
1 => "Flat site"
2 => "Carpet Free"
3 => "Gazebo"
]
+"LotSizeDimensions": "43.1 x 57.6 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T23:18:32Z"
+"PhotosCount": 28
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T12:28:15Z"
+"Stories": "1.0"
+"StreetName": "Havelock"
+"StreetNumber": "513"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4383.33"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://zhrealestatephotography.com/513-Havelock-Dr"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29892943/513-havelock-drive-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:2 [
0 => "Smoke Detectors"
1 => "Monitored Alarm"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 43.1
+"OriginalEntryTimestamp": "2026-06-11T23:18:32.21Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1227826"
+"ListOfficeNationalAssociationId": "1306494"
+"Media": array:28 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29892943')"
+"ID": "1522209"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25248
+post_id: "1521288"
+post_author: 1
+"ListingKey": "29891164"
+"ListingId": "X13433326"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T01:25:11Z"
+"RFModificationTimestamp": "2026-06-17T01:26:03Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1G9"
+"UnparsedAddress": "B - 694 HIGHPOINT AVENUE, Waterloo, Ontario N2V1G9"
+"Coordinates": array:2 [
0 => -80.5645265
1 => 43.4919849
]
+"Latitude": 43.4919849
+"Longitude": -80.5645265
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this Beautiful FREEHOLD home, Renovated Top-to-Bottom with today's lifestyle in mind, where modern design meets everyday convenience! Explore a real gorgeous home featuring a tasteful & pleasant décor, a great overall layout designed for functionality with plenty of desirable features giving you an instant vibe of welcoming feel. Stylish & bright Main floor showcasing a great size living room as the main focal point to gather around and spend time with your loved ones, a well-appointed New Kitchen and Dinette. Second floor features 3 good size bedrooms with a modern Full 4-piece bathroom, where large windows fill with natural light, creating a warm and welcoming atmosphere. The lower level has been professionally finished with a large Recreation room and 3-piece bathroom with real & easy potential of adding a 4th Bedroom, and an abundance of storage offering expansion capability to accommodate more living space. Ample tandem parking for minimum 3 cars, cozy Landscaped private backyard with newer deck and shed, and an abundance of storage space. An abundance of professional Upgrades: Kitchen (2021), Roof (2021), Fascia and 5" seamless clog-free Eavestrough systems (2025) Windows/Sliders (2008 & 20023), Front Door (2022), Deck (2020), Bathrooms (2022), Flooring (2026 & 2016), Full Interior Painting (2026 & 2023), Washer/Dryer (2023), Sump Pump (2023), Pot Lights (2026), Sealed Driveway & Deck (2026), and more. Nestled in a desirable family-friendly community at walking distance to Laurel Creek Conservation, the home offers close & easy access to best Waterloo living, excellent Schools, public Transit, nearby Shopping, St. Jacobs Market, Highway access and much more. What an attractive package of comfort, convenience, and potential. Extremely well-kept and regularly maintained home in amazing condition reflecting an evident pride of ownership, don't miss this out ! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Freezer"
8 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T21:37:43.183097+00:00"
+"Directions": "Cross Streets: Northfield Drive N. ** Directions: Northfield Drive N to Highpoint."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2157419"
+"ListOfficeKey": "290667"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Gazebo"
2 => "Sump Pump"
]
+"LotSizeDimensions": "34 x 115.5 FT"
+"ParkingFeatures": array:2 [
0 => "No Garage"
1 => "Tandem"
]
+"PhotosChangeTimestamp": "2026-06-11T19:22:09Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T01:18:33Z"
+"Stories": "2.0"
+"StreetName": "Highpoint"
+"StreetNumber": "694"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3451.75"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/694-Highpoint-Ave"
+"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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29891164/b-694-highpoint-avenue-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 34.0
+"OriginalEntryTimestamp": "2026-06-11T19:22:09.26Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1408835"
+"ListOfficeNationalAssociationId": "1390130"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891164')"
+"ID": "1521288"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25249
+post_id: "1520303"
+post_author: 1
+"ListingKey": "29888323"
+"ListingId": "40838908"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T00:40:06Z"
+"RFModificationTimestamp": "2026-06-17T00:42:49Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1622.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1G9"
+"UnparsedAddress": "694 HIGHPOINT Avenue Unit# B, Waterloo, Ontario N2V1G9"
+"Coordinates": array:2 [
0 => -80.564572
1 => 43.4919692
]
+"Latitude": 43.4919692
+"Longitude": -80.564572
+"YearBuilt": 1983
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this Beautiful FREEHOLD home, Renovated Top-to-Bottom with today’s lifestyle in mind, where modern design meets everyday convenience! Explore a real gorgeous home featuring a tasteful & pleasant décor, a great overall layout designed for functionality with plenty of desirable features giving you an instant vibe of welcoming feel. Stylish & bright Main floor showcasing a great size living room as the main focal point to gather around and spend time with your loved ones, a well-appointed New Kitchen and Dinette. Second floor features 3 good size bedrooms with a modern Full 4-piece bathroom, where large windows fill with natural light, creating a warm and welcoming atmosphere. The lower level has been professionally finished with a large Recreation room and 3-piece bathroom with real & easy potential of adding a 4th Bedroom, and an abundance of storage offering expansion capability to accommodate more living space. Ample tandem parking for minimum 3 cars, cozy Landscaped private backyard with newer deck and shed, and an abundance of storage space. An abundance of professional Upgrades: Kitchen (2021), Roof (2021), Fascia and 5” seamless clog-free Eavestrough systems (2025) Windows/Sliders (2008 & 20023), Front Door (2022), Deck (2020), Bathrooms (2022), Flooring (2026 & 2016), Full Interior Painting (2026 & 2023), Washer/Dryer (2023), Sump Pump (2023), Pot Lights (2026), Sealed Driveway & Deck (2026), and more. Nestled in a desirable family-friendly community at walking distance to Laurel Creek Conservation, the home offers close & easy access to best Waterloo living, excellent Schools, public Transit, nearby Shopping, St. Jacobs Market, Highway access and much more. What an attractive package of comfort, convenience, and potential. Extremely well-kept and regularly maintained home in amazing condition reflecting an evident pride of ownership, don't miss this out ! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Contemporary"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T18:51:42.597087+00:00"
+"Directions": "Northfield Drive N, to Highpoint"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2019087"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Gazebo"
3 => "Sump Pump"
]
+"PhotosChangeTimestamp": "2026-06-11T14:52:21Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T00:32:17Z"
+"Stories": "2.0"
+"StreetName": "HIGHPOINT"
+"StreetNumber": "694"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "3451.75"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/694-Highpoint-Ave"
+"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/29888323/694-highpoint-avenue-unit-b-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 34.0
+"AboveGradeFinishedArea": 1123
+"BelowGradeFinishedArea": 499
+"OriginalEntryTimestamp": "2026-06-11T14:52:21.2Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1299259"
+"ListOfficeNationalAssociationId": "1389824"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29888323')"
+"ID": "1520303"
}
]
+success: true
+page_size: 9
+page_count: 8
+count: 64
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]