array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30047422 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23472
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23474
+post_id: "1636878"
+post_author: 1
+"ListingKey": "30047422"
+"ListingId": "X13576166"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T15:20:07Z"
+"RFModificationTimestamp": "2026-07-17T17:03:14Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2A8"
+"UnparsedAddress": "364 STONEHEIGHT PLACE, Waterloo, Ontario N2V2A8"
+"Coordinates": array:2 [
0 => -80.570164
1 => 43.496971
]
+"Latitude": 43.496971
+"Longitude": -80.570164
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 364 Stoneheight Place! Situated on a quiet court in one of Waterloo's sought-after family neighbourhoods, this beautifully updated 4-bedroom detached home has been thoughtfully expanded with an impressive approximately 1,000 sq. ft. addition, creating the perfect blend of luxury, functionality and space. The showpiece of the home is the spectacular custom kitchen, complete with quartz countertops, premium cabinetry, stainless steel appliances, gas cooktop, built-in wall ovens, an oversized island and a spacious eat-in area designed for family gatherings and entertaining. Multiple living spaces, updated flooring and tasteful finishes create an inviting atmosphere throughout. Upstairs you'll find three generous bedrooms, including a stunning primary retreat featuring a spa-inspired ensuite with a soaker tub, oversized glass shower, dual vanity and an incredible custom walk-in dressing room. The fully finished basement adds even more versatility with its own kitchen, bedroom, 3-piece bathroom and spacious recreation area, making it an excellent option for multi-generational living, guests or a private in-law suite. Step outside and discover your own backyard oasis. The expansive deck surrounds a sparkling pool, creating the ultimate setting for summer entertaining, family fun and relaxing weekends at home. Offering exceptional living space, designer updates, an incredible addition and a prime Waterloo location close to schools, parks, shopping, universities and expressway access, 364 Stoneheight Place is a home that truly stands apart. (id:62650)"
+"Appliances": array:5 [
0 => "Water meter"
1 => "Water softener"
2 => "Freezer"
3 => "Oven - Built-In"
4 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T17:03:02.635022+00:00"
+"Directions": "Westmount Rd N/ Osprey Dr"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1901379"
+"ListOfficeKey": "277619"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Irregular lot size"
2 => "Flat site"
3 => "Conservation/green belt"
]
+"LotSizeDimensions": "52.3 x 116.3 FT ; 107.7ftx41.2ftx41.3ftx116.3ftx **"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T15:11:17Z"
+"PhotosCount": 48
+"PoolFeatures": array:1 [
0 => "On Ground Pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T15:11:17Z"
+"Stories": "2.0"
+"StreetName": "Stoneheight"
+"StreetNumber": "364"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "7510"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/364_stoneheight_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1686697519"
"RoomType" => "Kitchen"
"ListingId" => "X13576166"
"RoomLevel" => "Main level"
"RoomWidth" => 3.34
"ListingKey" => "30047422"
"RoomLength" => 5.01
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T15:11:17.75Z"
]
1 => array:11 [
"RoomKey" => "1686697520"
"RoomType" => "Bedroom 4"
"ListingId" => "X13576166"
"RoomLevel" => "Basement"
"RoomWidth" => 3.05
"ListingKey" => "30047422"
"RoomLength" => 4.53
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T15:11:17.75Z"
]
2 => array:11 [
"RoomKey" => "1686697521"
"RoomType" => "Dining room"
"ListingId" => "X13576166"
"RoomLevel" => "Main level"
"RoomWidth" => 3.12
"ListingKey" => "30047422"
"RoomLength" => 5.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T15:11:17.75Z"
]
3 => array:11 [
"RoomKey" => "1686697522"
"RoomType" => "Living room"
"ListingId" => "X13576166"
"RoomLevel" => "Main level"
"RoomWidth" => 5.39
"ListingKey" => "30047422"
"RoomLength" => 4.14
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T15:11:17.75Z"
]
4 => array:11 [
"RoomKey" => "1686697523"
"RoomType" => "Family room"
"ListingId" => "X13576166"
"RoomLevel" => "Main level"
"RoomWidth" => 4.57
"ListingKey" => "30047422"
"RoomLength" => 3.33
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T15:11:17.75Z"
]
5 => array:11 [
"RoomKey" => "1686697524"
"RoomType" => "Laundry room"
"ListingId" => "X13576166"
"RoomLevel" => "Main level"
"RoomWidth" => 1.79
"ListingKey" => "30047422"
"RoomLength" => 2.45
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T15:11:17.75Z"
]
6 => array:11 [
"RoomKey" => "1686697525"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13576166"
"RoomLevel" => "Second level"
"RoomWidth" => 5.45
"ListingKey" => "30047422"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T15:11:17.75Z"
]
7 => array:11 [
"RoomKey" => "1686697526"
"RoomType" => "Bedroom 2"
"ListingId" => "X13576166"
"RoomLevel" => "Second level"
"RoomWidth" => 2.78
"ListingKey" => "30047422"
"RoomLength" => 3.94
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T15:11:17.75Z"
]
8 => array:11 [
"RoomKey" => "1686697527"
"RoomType" => "Bedroom 3"
"ListingId" => "X13576166"
"RoomLevel" => "Second level"
"RoomWidth" => 3.19
"ListingKey" => "30047422"
"RoomLength" => 4.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T15:11:17.75Z"
]
9 => array:11 [
"RoomKey" => "1686697528"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13576166"
"RoomLevel" => "Basement"
"RoomWidth" => 5.74
"ListingKey" => "30047422"
"RoomLength" => 6.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T15:11:17.75Z"
]
10 => array:11 [
"RoomKey" => "1686697529"
"RoomType" => "Kitchen"
"ListingId" => "X13576166"
"RoomLevel" => "Basement"
"RoomWidth" => 3.08
"ListingKey" => "30047422"
"RoomLength" => 2.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-17T15:11:17.75Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30047422/364-stoneheight-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 52.3
+"OriginalEntryTimestamp": "2026-07-17T15:11:17.7Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1217537"
+"ListOfficeNationalAssociationId": "1286063"
+"Media": array:48 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30047422_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/456d0737a18d8ab72c8259e2fd3bd5f0.webp"
"MediaSize" => 425733
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-456d0737a18d8ab72c8259e2fd3bd5f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30047422_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/5613272866d1c52459fd19eb3261e412.webp"
"MediaSize" => 360296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-5613272866d1c52459fd19eb3261e412.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30047422_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/fcb645325184fc9e4e91f5a1a62cf2b4.webp"
"MediaSize" => 374899
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-fcb645325184fc9e4e91f5a1a62cf2b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30047422_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/fc010a755d60b80970a9ea77c544b159.webp"
"MediaSize" => 445682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-fc010a755d60b80970a9ea77c544b159.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30047422_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/06be4c8ead77392edf4b60497e467d18.webp"
"MediaSize" => 404244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-06be4c8ead77392edf4b60497e467d18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30047422_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/799ad111db182b210bf0094162108582.webp"
"MediaSize" => 343142
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-799ad111db182b210bf0094162108582.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30047422_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/0f782e01c8f7d5a4265104c31e0f73d4.webp"
"MediaSize" => 416371
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-0f782e01c8f7d5a4265104c31e0f73d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30047422_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/f1e7440b6fc1282b0f30dc5cecfd5bcf.webp"
"MediaSize" => 406929
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-f1e7440b6fc1282b0f30dc5cecfd5bcf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30047422_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/e0c063bf7f34bfcb5b65ca558d90f293.webp"
"MediaSize" => 222775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-e0c063bf7f34bfcb5b65ca558d90f293.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30047422_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/a29cd0e7273aeb1131f8839843457733.webp"
"MediaSize" => 166386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-a29cd0e7273aeb1131f8839843457733.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30047422_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/a448eed90df2c56290bdb18972e8ce9e.webp"
"MediaSize" => 206132
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-a448eed90df2c56290bdb18972e8ce9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30047422_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/12e7f7840dada466e30a4b4dd5aa4b34.webp"
"MediaSize" => 177000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-12e7f7840dada466e30a4b4dd5aa4b34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30047422_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/cb9910dd4afa11c11db58f69092a3b96.webp"
"MediaSize" => 174696
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-cb9910dd4afa11c11db58f69092a3b96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30047422_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/00459f92f2f5bfa19ab7b00c6516b358.webp"
"MediaSize" => 181722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-00459f92f2f5bfa19ab7b00c6516b358.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30047422_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/668a83f576a124a6dd516578c21fe32d.webp"
"MediaSize" => 192036
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-668a83f576a124a6dd516578c21fe32d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30047422_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/af4e24887209cd137cc2ac8339c40184.webp"
"MediaSize" => 168397
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-af4e24887209cd137cc2ac8339c40184.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30047422_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/a2bc2d24b0e61c8a278bdcffa9470101.webp"
"MediaSize" => 125338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-a2bc2d24b0e61c8a278bdcffa9470101.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30047422_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/25ea58a2a753a9141c0c39a1bac28021.webp"
"MediaSize" => 138203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-25ea58a2a753a9141c0c39a1bac28021.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30047422_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/d4f4c7f4fd5b38927d8294cb741d7189.webp"
"MediaSize" => 187517
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-d4f4c7f4fd5b38927d8294cb741d7189.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30047422_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/a0c30fa92a996466c7bcd7c7bdf311c9.webp"
"MediaSize" => 199346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-a0c30fa92a996466c7bcd7c7bdf311c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30047422_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/4e25e06646415afef3efac2fc33ee1cd.webp"
"MediaSize" => 202120
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-4e25e06646415afef3efac2fc33ee1cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30047422_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/4986417929bcecddfca3758af9b49525.webp"
"MediaSize" => 204030
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-4986417929bcecddfca3758af9b49525.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30047422_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/d1543e138c18c4bddc6046df3e5bdd9b.webp"
"MediaSize" => 243350
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-d1543e138c18c4bddc6046df3e5bdd9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30047422_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/b9133c5dfa63e6e614f956c95a937f6b.webp"
"MediaSize" => 272085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-b9133c5dfa63e6e614f956c95a937f6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30047422_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/3d4b2bf95bf450c5cd85e8e8319ae2d3.webp"
"MediaSize" => 268597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-3d4b2bf95bf450c5cd85e8e8319ae2d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30047422_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/1de140843fef43b0844520ccdb79da67.webp"
"MediaSize" => 102251
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-1de140843fef43b0844520ccdb79da67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30047422_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/d07cb84c96bb2c611130dfa05abf6eec.webp"
"MediaSize" => 131848
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-d07cb84c96bb2c611130dfa05abf6eec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30047422_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/ff759f73b99adb1d22cc856e87fb683b.webp"
"MediaSize" => 258275
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-ff759f73b99adb1d22cc856e87fb683b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30047422_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/65e9535caff6cc6d070e8d7749265599.webp"
"MediaSize" => 141103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-65e9535caff6cc6d070e8d7749265599.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30047422_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/b9d8a2ed9a5dcc99f90ccbe1fb9f9ae9.webp"
"MediaSize" => 228419
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-b9d8a2ed9a5dcc99f90ccbe1fb9f9ae9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30047422_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/8c388e176feb90b8a7d983b35d1174de.webp"
"MediaSize" => 176995
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-8c388e176feb90b8a7d983b35d1174de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30047422_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/35e773ff4e36a895888400ab08780770.webp"
"MediaSize" => 232573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-35e773ff4e36a895888400ab08780770.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30047422_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/b99df8da7e58e734e6ce5b0df7350bd3.webp"
"MediaSize" => 210087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-b99df8da7e58e734e6ce5b0df7350bd3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30047422_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/e1bcd0331a53b37c084e492454ad8bd0.webp"
"MediaSize" => 156885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-e1bcd0331a53b37c084e492454ad8bd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30047422_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/0eb14cabda79a92179a603e0bec83822.webp"
"MediaSize" => 146027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-0eb14cabda79a92179a603e0bec83822.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "30047422_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/4675faebd1dd8fe57786eb17407e3939.webp"
"MediaSize" => 164255
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-4675faebd1dd8fe57786eb17407e3939.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "30047422_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/8ed5026fa34439bcda8ae3faac540abb.webp"
"MediaSize" => 146557
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-8ed5026fa34439bcda8ae3faac540abb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "30047422_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/c447a7a168cc65f48a2dcc97860e3e83.webp"
"MediaSize" => 166275
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-c447a7a168cc65f48a2dcc97860e3e83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "30047422_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/152a7fae48d8cc8475e14ddd32fd608c.webp"
"MediaSize" => 209058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-152a7fae48d8cc8475e14ddd32fd608c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "30047422_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/a85da5809f663bd4cede738817a834f8.webp"
"MediaSize" => 173109
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-a85da5809f663bd4cede738817a834f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "30047422_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/f27c8be187e8bbb7e76cbee33e84cfa6.webp"
"MediaSize" => 190420
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-f27c8be187e8bbb7e76cbee33e84cfa6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "30047422_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/7b00a0c3da0686087005ee816c733d18.webp"
"MediaSize" => 194041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-7b00a0c3da0686087005ee816c733d18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "30047422_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/1b3fd981883710d5a357653bbe625776.webp"
"MediaSize" => 189675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-1b3fd981883710d5a357653bbe625776.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "30047422_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/bf3258707e34aa693c222c09c73acc2c.webp"
"MediaSize" => 135596
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-bf3258707e34aa693c222c09c73acc2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "30047422_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/01b5edd0b6b0a126d4d33a2f1e797d3c.webp"
"MediaSize" => 136785
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-01b5edd0b6b0a126d4d33a2f1e797d3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "30047422_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/70f6ba24a6f6c23fdec9d8d14b6e507f.webp"
"MediaSize" => 147042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-70f6ba24a6f6c23fdec9d8d14b6e507f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "30047422_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/2c4aff996003ea726e4f33a82daa7875.webp"
"MediaSize" => 127039
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-2c4aff996003ea726e4f33a82daa7875.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "30047422_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30047422/0c0e1bf9f90d2d12b48ab811eceb149a.webp"
"MediaSize" => 115191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30047422/thumbnail-0c0e1bf9f90d2d12b48ab811eceb149a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13576166"
"ResourceRecordKey" => "30047422"
"ModificationTimestamp" => "2026-07-17T15:11:17.7Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30047422')"
+"ID": "1636878"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Cache Key: 9ae3d5454b5a4803cebe8b01aea9bac092a363f7123ccb600f12b3119b0f7247" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24680
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24996
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "CENTURY 21 MILLENNIUM INC."
+"OfficeEmail": null
+"OfficePhone": "519-940-2100"
+"OfficeMlsId": "12905"
+"ModificationTimestamp": "2026-03-03T12:05:49Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "277619"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "232 BROADWAY AVENUE"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "ORANGEVILLE"
+"OfficePostalCode": "L9W1K5"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1286063"
+"OriginalEntryTimestamp": "2016-01-19T01:38:00Z"
+"OfficeFax": "519-941-0021"
+"OfficeAORKey": "82"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "318540"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "277619"
"SocialMediaUrlOrId" => "http://www.c21m.ca/"
"ModificationTimestamp" => "2023-07-11T18:33:00Z"
]
]
+"FranchiseNationalAssociationId": "1205554"
+"OfficeBrokerNationalAssociationId": "1035397"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('277619')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1901379" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24911
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30047422'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25319
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30047422' AND OpenHouseDate ge '2026-07-17'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25335
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.19 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30047422' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.570164 43.496971)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25408
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25402
+post_id: "1637109"
+post_author: 1
+"ListingKey": "30044668"
+"ListingId": "40848250"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:15:16Z"
+"RFModificationTimestamp": "2026-07-17T20:50:05Z"
+"ListPrice": 875000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.182
+"LivingArea": 2275.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1X2"
+"UnparsedAddress": "363 TWINFLOWER Crescent, Waterloo, Ontario N2V1X2"
+"Coordinates": array:2 [
0 => -80.5616005
1 => 43.4984169
]
+"Latitude": 43.4984169
+"Longitude": -80.5616005
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Empty nesters and not ready for condo living? Welcome to this bright, open-concept bungalow nestled in Waterloo’s highly desirable Lakeshore North neighborhood. Perfect for downsizers seeking convenient main-floor living or small families looking for a vibrant, established community. You'll love the luxurious main floor bathroom boasting a custom, spa-like 5-piece privilege ensuite bath and the convenience of main floor laundry. This home features custom finishes like 9' ceilings, hardwood flooring, 5 1/4 baseboards and pot lights. The sunken living room is an inviting space perfect for relaxation and offering a seamless transition to outdoor living. The sunny, private backyard is beautifully landscaped and fenced on 3 sides. The design is perfect for entertaining and outdoor enjoyment with a durable composite deck complete with a natural gas BBQ hookup. The rec room has space for all your toys including a snooker table. The lower level also has 9' ceilings and would accommodate a parent with a private bedroom and 3 piece bathroom. There's plenty of parking with a double garage and 3 spots outside for family and friends. All this located in one of Waterloo's premier communities, offering a peaceful, active lifestyle with everything you need just minutes away. It's located just steps from the quiet paths of Pinebrook Park and within close proximity to the stunning trails and reservoir at the Laurel Creek Conservation Area. Add in excellent local schools, community playgrounds, and the nearby Albert McCormick Community Centre and library. Enjoy easy access to premium shopping and dining at Conestoga Mall, local grocery stores, and essential services. It's also conveniently located near major transit routes, the LRT, and Highway 85, making commutes across Waterloo region a breeze. Don't miss the rare opportunity to own a turnkey bungalow in this highly coveted, friendly neighborhood! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:49:58.803696+00:00"
+"Directions": "Northlake to Monarch Place, turn right onto Twinflower"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563807"
+"ListOfficeKey": "76849"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Corner Site"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.182"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T19:03:05Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:09:39Z"
+"Stories": "1.0"
+"StreetName": "TWINFLOWER"
+"StreetNumber": "363"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "5915"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/363_twinflower_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1686994352"
"RoomType" => "Dinette"
"ListingId" => "40848250"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30044668"
"RoomLength" => null
"RoomDimensions" => "7'11'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:39.26Z"
]
1 => array:11 [
"RoomKey" => "1686994353"
"RoomType" => "Foyer"
"ListingId" => "40848250"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30044668"
"RoomLength" => null
"RoomDimensions" => "6'4'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:39.26Z"
]
2 => array:11 [
"RoomKey" => "1686994354"
"RoomType" => "5pc Bathroom"
"ListingId" => "40848250"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30044668"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:39.26Z"
]
3 => array:11 [
"RoomKey" => "1686994355"
"RoomType" => "Laundry room"
"ListingId" => "40848250"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30044668"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:39.26Z"
]
4 => array:11 [
"RoomKey" => "1686994356"
"RoomType" => "Primary Bedroom"
"ListingId" => "40848250"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30044668"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:39.26Z"
]
5 => array:11 [
"RoomKey" => "1686994357"
"RoomType" => "Bedroom"
"ListingId" => "40848250"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30044668"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 12'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:39.26Z"
]
6 => array:11 [
"RoomKey" => "1686994358"
"RoomType" => "Living room"
"ListingId" => "40848250"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30044668"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 18'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:39.26Z"
]
7 => array:11 [
"RoomKey" => "1686994359"
"RoomType" => "Dining room"
"ListingId" => "40848250"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30044668"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 14'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:39.26Z"
]
8 => array:11 [
"RoomKey" => "1686994360"
"RoomType" => "Kitchen"
"ListingId" => "40848250"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30044668"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:39.26Z"
]
9 => array:11 [
"RoomKey" => "1686994361"
"RoomType" => "Recreation room"
"ListingId" => "40848250"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30044668"
"RoomLength" => null
…4
]
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/30044668/363-twinflower-crescent-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 67.0
+"AboveGradeFinishedArea": 1456
+"BelowGradeFinishedArea": 819
+"OriginalEntryTimestamp": "2026-07-16T21:18:17.35Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070148"
+"ListOfficeNationalAssociationId": "1004401"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30044668')"
+"ID": "1637109"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25404
+post_id: "1637110"
+post_author: 1
+"ListingKey": "30032627"
+"ListingId": "40848012"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:20:07Z"
+"RFModificationTimestamp": "2026-07-17T20:44:06Z"
+"ListPrice": 674900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1075.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4N7"
+"UnparsedAddress": "514 HAVELOCK Drive, Waterloo, Ontario N2L4N7"
+"Coordinates": array:2 [
0 => -80.5582721
1 => 43.4895441
]
+"Latitude": 43.4895441
+"Longitude": -80.5582721
+"YearBuilt": 0
+"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-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 potential 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-07-17T20:44:00.821133+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750161"
+"ListOfficeKey": "283896"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-07-14T20:18:42Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:09:59Z"
+"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/30032627/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": 1075
+"OriginalEntryTimestamp": "2026-07-14T20:18:42.42Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1163644"
+"ListOfficeNationalAssociationId": "1349002"
+"Media": array:34 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30032627')"
+"ID": "1637110"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25401
+post_id: "1633477"
+post_author: 1
+"ListingKey": "30043986"
+"ListingId": "X13573118"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T03:15:03Z"
+"RFModificationTimestamp": "2026-07-18T03:18:23Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4Y2"
+"UnparsedAddress": "615 DOGWOOD LANE, Waterloo, Ontario N2L4Y2"
+"Coordinates": array:2 [
0 => -80.562739
1 => 43.486821
]
+"Latitude": 43.486821
+"Longitude": -80.562739
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 615 Dogwood Lane, Waterloo! This beautifully updated detached bungalow offers the perfect blend of comfort, versatility, and location. Featuring 3 spacious bedrooms and 1 full bathroom on the main level, plus a fully finished basement with a separate side entrance, second kitchen, additional bedroom, full bathroom, and excellent in-law or income potential. The main floor showcases a beautifully renovated kitchen with quartz countertops, new cabinetry, backsplash, flooring, and stainless steel appliances, complemented by pot lights throughout the home. Enjoy a large private backyard, perfect for entertaining or relaxing, in a family-friendly neighbourhood just minutes from the University of Waterloo, Wilfrid Laurier University, Conestoga College, schools, parks, shopping, transit, uptown Waterloo and a new hospital is planned approximately 5 minutes from the property. A fantastic opportunity for families, investors, or multi-generational living in one of Waterloo's most desirable communities. (id:62650)"
+"Appliances": array:1 [
0 => "Water softener"
]
+"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-07-17T00:00:23.294569+00:00"
+"Directions": "Highpoint Ave & Dogwood Ln"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2099530"
+"ListOfficeKey": "298485"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "45 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-16T19:40:09Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T03:08:30Z"
+"Stories": "1.0"
+"StreetName": "Dogwood"
+"StreetNumber": "615"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "3823.47"
+"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/30043986/615-dogwood-lane-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2169025"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "298485"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-07-16T19:40:09.22Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1369712"
+"ListOfficeNationalAssociationId": "1470118"
+"CoListAgentNationalAssociationId": "1419701"
+"CoListOfficeNationalAssociationId": "1470118"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30043986')"
+"ID": "1633477"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25405
+post_id: "1632395"
+post_author: 1
+"ListingKey": "30043808"
+"ListingId": "40846000"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T16:30:15Z"
+"RFModificationTimestamp": "2026-07-17T16:32:33Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1040.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1A9"
+"UnparsedAddress": "264 NORTHLAKE Drive Unit# A, Waterloo, Ontario N2V1A9"
+"Coordinates": array:2 [
0 => -80.5525039
1 => 43.4970467
]
+"Latitude": 43.4970467
+"Longitude": -80.5525039
+"YearBuilt": 1978
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Set in Waterloo's established Lakeshore neighbourhood, 264A Northlake Drive offers 3 bedrooms, 2 bathrooms, a partially fenced backyard, parking for up to three vehicles, and a layout with a walkout from the living room to the backyard. Step outside and you're minutes from Laurel Creek Conservation Area, St. Jacobs Farmers' Market, Conestoga Mall, both the University of Waterloo and Wilfrid Laurier University, excellent schools, parks, shopping, public transit, and Highway 85. Whether you're searching for a place to call home or your next investment, locations like this continue to stand the test of time—and this is your chance to make it your own. (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-16T20:54:44.142043+00:00"
+"Directions": "WEBER TO GOLDEN EAGLE, LEFT ON NORTHLAKE"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2248310"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"PhotosChangeTimestamp": "2026-07-17T16:23:54Z"
+"PhotosCount": 6
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T16:23:54Z"
+"Stories": "2.0"
+"StreetName": "NORTHLAKE"
+"StreetNumber": "264"
+"StreetSuffix": "Drive"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "3365.81"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30043808/264-northlake-drive-unit-a-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1040
+"OriginalEntryTimestamp": "2026-07-16T19:18:44.6Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1487214"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:6 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30043808')"
+"ID": "1632395"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25403
+post_id: "1631099"
+post_author: 1
+"ListingKey": "30042060"
+"ListingId": "X13571666"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-16T16:20:11Z"
+"RFModificationTimestamp": "2026-07-16T16:41:56Z"
+"ListPrice": 779900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1B3"
+"UnparsedAddress": "137 WHITE PINE CRESCENT, Waterloo, Ontario N2V1B3"
+"Coordinates": array:2 [
0 => -80.5554301
1 => 43.4975712
]
+"Latitude": 43.4975712
+"Longitude": -80.5554301
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Set on a mature lot in Waterloo's highly sought-after Lakeshore neighbourhood, this well cared for 4-level sidesplit is surrounded by everything that makes this community so desirable. Tucked away on a quiet, family-friendly crescent and backing directly onto a peaceful park with no rear neighbours, the private backyard feels like a natural extension of the home. Towering mature trees, beautiful views, and direct access to greenspace create a peaceful setting for relaxing, entertaining, or simply enjoying the outdoors. Inside, the bright main floor welcomes you with a spacious living room where a large picture window fills the space with natural light. The adjoining dining area flows into a thoughtfully updated kitchen featuring warm cabinetry, ample prep space, and a breakfast bar that's perfect for casual meals, morning coffee, or catching up at the end of the day. Just a few steps down, the inviting family room is anchored by a beautiful stone gas fireplace and offers a walkout to the backyard, creating a seamless connection between indoor and outdoor living. A convenient 2-piece powder room completes this level. Upstairs, you'll find three comfortable bedrooms, including a spacious primary bedroom, along with a 4-piece bathroom. The finished lower level adds flexibility with a generous recreation room, a fourth bedroom that's ideal for guests, teenagers, or extended family, a separate office for working from home or hobbies, and exceptional storage beneath the attached double garage. Beyond the home, you'll appreciate excellent schools, parks, walking and biking trails, Laurel Creek Conservation Area, St. Jacobs Farmers' Market, shopping, restaurants, both universities, the ION LRT, and quick access to the Expressway. With parking for up to eight vehicles, an attached double garage, and a peaceful park-side setting, this thoughtfully maintained home offers the space, privacy, and established neighbourhood buyers are searching for. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-16T16:41:45.740666+00:00"
+"Directions": "Cross Streets: Northfield Dr W & Weber St N. ** Directions: W on Golden Eagle from Weber, S on Northlake, N on White Pine."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1748204"
+"ListOfficeKey": "279258"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "55 x 107 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-16T16:10:44Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-16T16:10:44Z"
+"StreetName": "White Pine"
+"StreetNumber": "137"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "5184.78"
+"VirtualTourURLUnbranded": "https://youtu.be/tc4MwzSNSMI"
+"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/30042060/137-white-pine-crescent-waterloo"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 55.0
+"OriginalEntryTimestamp": "2026-07-16T16:10:44.68Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1180792"
+"ListOfficeNationalAssociationId": "1302363"
+"Media": array:34 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30042060')"
+"ID": "1631099"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25397
+post_id: "1628131"
+post_author: 1
+"ListingKey": "30036240"
+"ListingId": "40844012"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-16T12:30:10Z"
+"RFModificationTimestamp": "2026-07-16T12:44:44Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1179.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1G5"
+"UnparsedAddress": "606 FERN Road, Waterloo, Ontario N2V1G5"
+"Coordinates": array:2 [
0 => -80.5588933
1 => 43.4963322
]
+"Latitude": 43.4963322
+"Longitude": -80.5588933
+"YearBuilt": 1984
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 606 Fern Drive, a bright and beautifully maintained raised bungalow offering the perfect blend of comfort, style, and functionality. This move-in-ready home features 3 spacious bedrooms, 2 full bathrooms, and an inviting open-concept layout designed for both everyday living and effortless entertaining. Large windows throughout fill the home with natural light, creating warm and welcoming spaces you'll love coming home to. The sun-filled kitchen flows seamlessly into the main living and dining areas, making it easy to stay connected while preparing meals or hosting family and friends. Thoughtfully designed for modern living, the layout offers the perfect balance of openness and comfort. The fully finished lower level provides exceptional additional living space with a generous family room featuring a cozy gas fireplace and a built-in bar ideal for movie nights, holiday gatherings, game days, or simply relaxing at the end of a busy day. With plenty of room to spread out, this level offers flexibility for families of all sizes. Outside, enjoy your own private retreat with a fully fenced backyard and spacious deck, perfect for summer barbecues, outdoor dining, morning coffee, or giving children and pets a safe place to play. An attached garage and spacious driveway add everyday convenience while providing ample parking and storage. Located in a mature, family-friendly neighbourhood, you'll appreciate the easy access to excellent schools, parks, shopping, restaurants, public transit, and all the amenities Waterloo has to offer. Whether you're a first-time buyer, growing family, or downsizer looking for a home that offers space without compromise, 606 Fern Drive checks all the boxes. Meticulously cared for and ready for its next owners, this is a home where lasting memories are waiting to be made. Don't miss this incredible opportunity contact your REALTOR today to book your private showing! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T20:18:54.701362+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2101271"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-16T12:21:20Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-16T12:29:14Z"
+"Stories": "1.0"
+"StreetName": "FERN"
+"StreetNumber": "606"
+"StreetSuffix": "Road"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "4644"
+"VirtualTourURLUnbranded": "https://youriguide.com/606_fern_road_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30036240/606-fern-road-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 58.0
+"AboveGradeFinishedArea": 1179
+"OriginalEntryTimestamp": "2026-07-15T16:18:57.02Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1371199"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30036240')"
+"ID": "1628131"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "1625929"
+post_author: 1
+"ListingKey": "30031018"
+"ListingId": "X13561526"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T03:15:03Z"
+"RFModificationTimestamp": "2026-07-18T03:18:35Z"
+"ListPrice": 897000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2Y6"
+"UnparsedAddress": "606 PINERY TRAIL, Waterloo, Ontario N2V2Y6"
+"Coordinates": array:2 [
0 => -80.590278
1 => 43.490303
]
+"Latitude": 43.490303
+"Longitude": -80.590278
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to your dream home in the prestigious Conservation Meadows community - one of Waterloo's most sought-after, family-friendly neighbourhoods! This exquisite custom-built 4-bedroom, 3-bathroom detached home is loaded with high-end upgrades and modern design throughout. Soaring 9-foot ceilings on both floors, 8-foot doors, custom trim, steel-framed staircase, hardwood floors, and California shutters set the tone from the moment you enter. The gourmet eat-in kitchen features granite countertops, a large central island, and opens seamlessly to the living room with a stunning double-sided gas fireplace. An adjacent formal dining room and a main floor powder room complete this exquisite space. Upstairs, an expansive family room with its own gas fireplace and a walk-out to a private balcony add exceptional versatility and functionality. The primary suite comes with a luxurious 5-piece ensuite and a large walk-in closet with custom shelving. Three additional bright bedrooms, and 4-piece bathroom complete the second level. The unfinished basement roughed in for a bathroom, presents a blank slate for an entertainers dream or additional bedroom suite for guests and family. The curb appeal is striking with an exposed aggregate concrete driveway and professionally landscaped front yard. In the back, 8-foot sliding doors flooding the main floor with natural light open to a large deck and a fully fenced backyard. Additional features include main floor laundry room with garage access, owned water softener and rough-in central vac. Steps to scenic trails and Laurel Creek Conservation Area, and just minutes to St. Jacobs Market, the Boardwalk, Conestoga Mall, top-rated schools, parks, and major highways. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-14T19:49:41.681116+00:00"
+"Directions": "Conservation & Rideau River"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2102918"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Sump Pump"
]
+"LotSizeDimensions": "39.6 x 101.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-14T16:40:51Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T03:08:23Z"
+"Stories": "2.0"
+"StreetName": "Pinery"
+"StreetNumber": "606"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "7992"
+"VirtualTourURLUnbranded": "https://youriguide.com/606_pinery_trail_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30031018/606-pinery-trail-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 39.7
+"OriginalEntryTimestamp": "2026-07-14T16:40:51.12Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1372568"
+"ListOfficeNationalAssociationId": "1385020"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30031018')"
+"ID": "1625929"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25406
+post_id: "1625447"
+post_author: 1
+"ListingKey": "30031028"
+"ListingId": "X13561708"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-14T16:50:05Z"
+"RFModificationTimestamp": "2026-07-14T19:46:48Z"
+"ListPrice": 674900.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:5 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-14T19:46:37.177380+00:00"
+"Directions": "Glen Forrest Blvd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2127512"
+"ListOfficeKey": "283918"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "43.1 x 122.2 FT"
+"ParkingFeatures": array:3 [
0 => "Carport"
1 => "Covered"
2 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-14T16:40:52Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-14T16:40:52Z"
+"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": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30031028/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-07-14T16:40:52.2Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1380753"
+"ListOfficeNationalAssociationId": "1336772"
+"Media": array:34 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30031028')"
+"ID": "1625447"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25407
+post_id: "1621982"
+post_author: 1
+"ListingKey": "30028922"
+"ListingId": "40845774"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T02:30:01Z"
+"RFModificationTimestamp": "2026-07-18T02:35:05Z"
+"ListPrice": 897000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2613.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2Y6"
+"UnparsedAddress": "606 PINERY Trail, Waterloo, Ontario N2V2Y6"
+"Coordinates": array:2 [
0 => -80.5909464
1 => 43.4901449
]
+"Latitude": 43.4901449
+"Longitude": -80.5909464
+"YearBuilt": 2015
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to your dream home in the prestigious Conservation Meadows community — one of Waterloo's most sought-after, family-friendly neighbourhoods! This exquisite custom-built 4-bedroom, 3-bathroom detached home is loaded with high-end upgrades and modern design throughout. Soaring 9-foot ceilings on both floors, 8-foot doors, custom trim, steel-framed staircase, hardwood floors, and California shutters set the tone from the moment you enter. The gourmet eat-in kitchen features granite countertops, a large central island, and opens seamlessly to the living room with a stunning double-sided gas fireplace. An adjacent formal dining room and a main floor powder room complete this exquisite space. Upstairs, an expansive family room with its own gas fireplace and a walk-out to a private balcony add exceptional versatility and functionality. The primary suite comes with a luxurious 5-piece ensuite and a large walk-in closet with custom shelving. Three additional bright bedrooms, and 4-piece bathroom complete the second level. The unfinished basement roughed in for a bathroom, presents a blank slate for an entertainers dream or additional bedroom suite for guests and family. The curb appeal is striking with an exposed aggregate concrete driveway and professionally landscaped front yard. In the back, 8-foot sliding doors flooding the main floor with natural light open to a large deck and a fully fenced backyard. Additional features include main floor laundry room with garage access, owned water softener and rough-in central vac. Steps to scenic trails and Laurel Creek Conservation Area, and just minutes to St. Jacobs Market, the Boardwalk, Conestoga Mall, top-rated schools, parks, and major highways. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-14T03:23:27.756438+00:00"
+"Directions": "Conservation & Rideau River"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1930634"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-18T02:20:27Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T02:29:58Z"
+"Stories": "2.0"
+"StreetName": "PINERY"
+"StreetNumber": "606"
+"StreetSuffix": "Trail"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "7992"
+"VirtualTourURLUnbranded": "https://youriguide.com/606_pinery_trail_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30028922/606-pinery-trail-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2613
+"OriginalEntryTimestamp": "2026-07-14T02:29:30.86Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1231368"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30028922')"
+"ID": "1621982"
}
]
+success: true
+page_size: 9
+page_count: 10
+count: 83
+after_key: ""
}
"RF Response Time" => "0.38 seconds"
]
]