array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30040392 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: "1630122"
+post_author: 1
+"ListingKey": "30040392"
+"ListingId": "40844270"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T00:25:15Z"
+"RFModificationTimestamp": "2026-07-18T00:28:56Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1536.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5E1"
+"UnparsedAddress": "506 LONELM Court Unit# A, Waterloo, Ontario N2L5E1"
+"Coordinates": array:2 [
0 => -80.5441208
1 => 43.491533
]
+"Latitude": 43.491533
+"Longitude": -80.5441208
+"YearBuilt": 1973
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This rare, newly renovated, and well-maintained FREEHOLD LINK home offers unmatched privacy on a peaceful cul-de-sac. With 1,536 sq ft of finished living space, this flexible layout can accommodate up to 5 bedrooms. With no shared walls in the primary living areas and a completely detached second floor, it looks almost like a detached home from the outside. The entire home is carpet-free, with waterproof vinyl flooring, modern baseboards, and matching staircases (all 2026). It also features new LED lighting and premium SW paint throughout (all 2026). The fully updated kitchen showcases new cabinets, countertops, a stylish sink and faucet, and a built-in pantry (all 2026). Three upgraded washrooms, one on each floor, offer new vanities, flooring, and faucets (all 2026). The home also includes smart thermostats and a heat pump (2023) that can both heat and cool. A separate back entrance leads to the professionally finished lower level, featuring higher-than-average ceilings, bright egress windows, and a versatile 27-foot space ideal as a family rec room, movie theatre, or an oversized 5th bedroom. Exterior updates include a freshly painted private deck and front siding (2026). The extended carport is extremely useful as a shelter from snow, rain, and sun. The newly sealed 53-foot driveway provides parking for up to 3 cars (2026). Nestled in a mature and established community, this home is perfectly situated between the universities and Waterloo's business sector. Enjoy being just minutes from UW, Laurier, and Conestoga College, while surrounded by trails, parks, and local schools. It is also close to Conestoga Mall, St. Jacobs Market, and the Albert McCormick CC, with seamless commuter access to the LRT, major bus routes (9, 19, 91), and Hwy 85. Beautifully updated and move-in ready, this property is an ideal home for growing families and an impressive opportunity for savvy investors. Schedule your showing today! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-16T06:41:31.137548+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2251406"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-07-17T05:01:50Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T00:18:41Z"
+"Stories": "2.0"
+"StreetName": "LONELM"
+"StreetNumber": "506"
+"StreetSuffix": "Court"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "3895.75"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1687221062"
"RoomType" => "Utility room"
"ListingId" => "40844270"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30040392"
"RoomLength" => null
"RoomDimensions" => "8'9'' x 15'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T00:18:41.76Z"
]
1 => array:11 [
"RoomKey" => "1687221063"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844270"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30040392"
"RoomLength" => null
"RoomDimensions" => "3'2'' x 8'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T00:18:41.76Z"
]
2 => array:11 [
"RoomKey" => "1687221064"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844270"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30040392"
"RoomLength" => null
"RoomDimensions" => "5'8'' x 6'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T00:18:41.76Z"
]
3 => array:11 [
"RoomKey" => "1687221065"
"RoomType" => "Bedroom"
"ListingId" => "40844270"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30040392"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T00:18:41.76Z"
]
4 => array:11 [
"RoomKey" => "1687221066"
"RoomType" => "Bedroom"
"ListingId" => "40844270"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30040392"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T00:18:41.76Z"
]
5 => array:11 [
"RoomKey" => "1687221067"
"RoomType" => "Bedroom"
"ListingId" => "40844270"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30040392"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T00:18:41.76Z"
]
6 => array:11 [
"RoomKey" => "1687221068"
"RoomType" => "Bedroom"
"ListingId" => "40844270"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30040392"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T00:18:41.76Z"
]
7 => array:11 [
"RoomKey" => "1687221069"
"RoomType" => "Living room"
"ListingId" => "40844270"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30040392"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T00:18:41.76Z"
]
8 => array:11 [
"RoomKey" => "1687221070"
"RoomType" => "Kitchen"
"ListingId" => "40844270"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30040392"
"RoomLength" => null
"RoomDimensions" => "7'4'' x 15'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T00:18:41.76Z"
]
9 => array:11 [
"RoomKey" => "1687221071"
"RoomType" => "Laundry room"
"ListingId" => "40844270"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30040392"
"RoomLength" => null
"RoomDimensions" => "3'3'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T00:18:41.76Z"
]
10 => array:11 [
"RoomKey" => "1687221072"
"RoomType" => "Bedroom"
"ListingId" => "40844270"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30040392"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 27'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T00:18:41.76Z"
]
11 => array:11 [
"RoomKey" => "1687221073"
"RoomType" => "3pc Bathroom"
"ListingId" => "40844270"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30040392"
"RoomLength" => null
"RoomDimensions" => "5'5'' x 8'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T00:18:41.76Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30040392/506-lonelm-court-unit-a-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 29.0
+"AboveGradeFinishedArea": 1072
+"BelowGradeFinishedArea": 464
+"OriginalEntryTimestamp": "2026-07-16T05:58:36.69Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1490334"
+"ListOfficeNationalAssociationId": "1004387"
+"Media": array:32 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30040392_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/9ab467cf512d251d5913e4ea854b98c6.webp"
"MediaSize" => 164019
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-9ab467cf512d251d5913e4ea854b98c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front exterior featuring a convenient carport, detached upper level, and a 53-foot driveway."
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.49Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30040392_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/ad7fa5cc39bbb54b3053f32c4a809747.webp"
"MediaSize" => 120971
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-ad7fa5cc39bbb54b3053f32c4a809747.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carport providing extremely convenient sheltering from snow, rain, and sun."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.51Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30040392_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/b9e06df4b2fa4b3fcda90f49d4f81845.webp"
"MediaSize" => 56186
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-b9e06df4b2fa4b3fcda90f49d4f81845.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.53Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30040392_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/653f994d167df718c57e44f3b7059bd7.webp"
"MediaSize" => 40552
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-653f994d167df718c57e44f3b7059bd7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.5Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30040392_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/2d6761b0cc2fe8da5909fae150a4a447.webp"
"MediaSize" => 75332
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-2d6761b0cc2fe8da5909fae150a4a447.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.5Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30040392_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/8abe736131e702954717e3339c6b7318.webp"
"MediaSize" => 62950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-8abe736131e702954717e3339c6b7318.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.49Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30040392_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/755670c2696c842353058959d71eb6e8.webp"
"MediaSize" => 56232
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-755670c2696c842353058959d71eb6e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.55Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30040392_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/a1b5bd36be1f1882428143c6f01a1a1e.webp"
"MediaSize" => 56879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-a1b5bd36be1f1882428143c6f01a1a1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.53Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30040392_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/731c568c642fc1861e0274e304443a81.webp"
"MediaSize" => 70227
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-731c568c642fc1861e0274e304443a81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.49Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30040392_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/e8a42a4f46765f8299977a723916ca27.webp"
"MediaSize" => 77094
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-e8a42a4f46765f8299977a723916ca27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.49Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30040392_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/1fb0678f60407ec83f84bfcd661c201b.webp"
"MediaSize" => 45548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-1fb0678f60407ec83f84bfcd661c201b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.53Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30040392_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/8509a9355929117cde163b7d70b2d7fb.webp"
"MediaSize" => 55667
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-8509a9355929117cde163b7d70b2d7fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Versatile and convenient main-floor bedroom. Perfect for anyone looking to avoid stairs or easily utilized as a dedicated home office."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.49Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30040392_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/afabe9b450f1675247222e0a70171d87.webp"
"MediaSize" => 74603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-afabe9b450f1675247222e0a70171d87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.51Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30040392_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/571c2496365e72d761be1e6eb40c3288.webp"
"MediaSize" => 45722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-571c2496365e72d761be1e6eb40c3288.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main-floor 2-piece powder room with a vanity."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.52Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30040392_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/78306cb841df0715c6640284e70b7170.webp"
"MediaSize" => 42548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-78306cb841df0715c6640284e70b7170.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.49Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30040392_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/67aa3d4a877d339c61d8f56daccf6ead.webp"
"MediaSize" => 38116
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-67aa3d4a877d339c61d8f56daccf6ead.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.51Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30040392_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/b95e2caefb2c8db5c1b0f51b3f8e56a9.webp"
"MediaSize" => 50699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-b95e2caefb2c8db5c1b0f51b3f8e56a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full 4-piece bathroom on the second floor."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.5Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30040392_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/3e1e2f588ccfc3fe253060fc30c71d8e.webp"
"MediaSize" => 60750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-3e1e2f588ccfc3fe253060fc30c71d8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious primary bedroom retreat."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.49Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30040392_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/850ec713ba48281a6685c9670e37772e.webp"
"MediaSize" => 58213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-850ec713ba48281a6685c9670e37772e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Alternate view of the primary bedroom showing the full wall-to-wall closet."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.51Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30040392_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/a1621c7dc78d06963225bc1f716a44ff.webp"
"MediaSize" => 61375
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-a1621c7dc78d06963225bc1f716a44ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright, south-facing second bedroom on the upper level."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.49Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30040392_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/0ef2d1abc5098c609502a6d87d6f128f.webp"
"MediaSize" => 75441
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-0ef2d1abc5098c609502a6d87d6f128f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright, south-facing third upper-level bedroom."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.5Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30040392_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/86a62f0494d9bea851b711f864a266f8.webp"
"MediaSize" => 33929
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-86a62f0494d9bea851b711f864a266f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Separate back entrance leading directly to the basement."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.5Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30040392_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/238afc914d37d07670a1f62eba462f03.webp"
"MediaSize" => 73679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-238afc914d37d07670a1f62eba462f03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.52Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30040392_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/3e64f858021b7983f984898f10765c1f.webp"
"MediaSize" => 35911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-3e64f858021b7983f984898f10765c1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lower-level 3-piece bathroom with shower."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.53Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30040392_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/77770653781f33ef05bafd5d66da717b.webp"
"MediaSize" => 62700
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-77770653781f33ef05bafd5d66da717b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Massive 5th bedroom in the basement with high ceilings."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.49Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30040392_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/793bcf31700d8c9b089747db734c5218.webp"
"MediaSize" => 42563
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-793bcf31700d8c9b089747db734c5218.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Alternate view highlighting the spacious basement bedroom."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.5Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30040392_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/30e1f43209156084ce0013c428ccd5a2.webp"
"MediaSize" => 45134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-30e1f43209156084ce0013c428ccd5a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Perfect as a guest suite, or easily utilized as a family rec room, movie theatre, or home gym."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.53Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30040392_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/15d85832a9c612d81e40efb7063a95d4.webp"
"MediaSize" => 177071
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-15d85832a9c612d81e40efb7063a95d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Freshly painted 16' x 8' private back deck."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.51Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30040392_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/1e61995d90d4d18e47f178429ba96325.webp"
"MediaSize" => 230503
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-1e61995d90d4d18e47f178429ba96325.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.53Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30040392_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/21452cbe8b709afe800818b173d0b18e.webp"
"MediaSize" => 232129
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-21452cbe8b709afe800818b173d0b18e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.52Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30040392_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/00999dd8461be8095a010b931eeffea7.webp"
"MediaSize" => 150476
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-00999dd8461be8095a010b931eeffea7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.49Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30040392_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30040392/904e54516f30caaddf24a4102251cfc7.webp"
"MediaSize" => 181591
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30040392/thumbnail-904e54516f30caaddf24a4102251cfc7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844270"
"ResourceRecordKey" => "30040392"
"ModificationTimestamp" => "2026-07-16T06:01:16.29Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30040392')"
+"ID": "1630122"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 76826" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24978
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24922
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "PEAK REALTY LTD."
+"OfficeEmail": null
+"OfficePhone": "519-747-0231"
+"OfficeMlsId": "KW162"
+"ModificationTimestamp": "2026-03-24T17:19:43Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "76826"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "5-25 Bruce St."
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Kitchener"
+"OfficePostalCode": "N2B1Y"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1004387"
+"OriginalEntryTimestamp": null
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "328123"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "76826"
"SocialMediaUrlOrId" => "http://www.peakrealtyltd.com/"
"ModificationTimestamp" => "2026-03-24T16:37:00Z"
]
]
+"FranchiseNationalAssociationId": "1230701"
+"OfficeBrokerNationalAssociationId": "1171153"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('76826')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2251406" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24932
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30040392'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25270
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30040392' AND OpenHouseDate ge '2026-07-17'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25293
+items: array:10 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25286
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "32018029"
+"ListingKey": "30040392"
+"ListingId": "40844270"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-17"
+"OpenHouseStartTime": "2026-07-17T14:00:00Z"
+"OpenHouseEndTime": "2026-07-17T18:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-16T22:20:35Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('32018029')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25288
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "32018028"
+"ListingKey": "30040392"
+"ListingId": "40844270"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-18"
+"OpenHouseStartTime": "2026-07-18T14:00:00Z"
+"OpenHouseEndTime": "2026-07-18T18:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-16T22:20:35Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('32018028')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25285
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "32018027"
+"ListingKey": "30040392"
+"ListingId": "40844270"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-19"
+"OpenHouseStartTime": "2026-07-19T14:00:00Z"
+"OpenHouseEndTime": "2026-07-19T18:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-16T22:20:35Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('32018027')"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25289
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "32027525"
+"ListingKey": "30040392"
+"ListingId": "40844270"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-17"
+"OpenHouseStartTime": "2026-07-17T14:00:00Z"
+"OpenHouseEndTime": "2026-07-17T18:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-17T02:44:37Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('32027525')"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25287
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "32027524"
+"ListingKey": "30040392"
+"ListingId": "40844270"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-18"
+"OpenHouseStartTime": "2026-07-18T14:00:00Z"
+"OpenHouseEndTime": "2026-07-18T18:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-17T02:44:37Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('32027524')"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25284
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "32027523"
+"ListingKey": "30040392"
+"ListingId": "40844270"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-19"
+"OpenHouseStartTime": "2026-07-19T14:00:00Z"
+"OpenHouseEndTime": "2026-07-19T18:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-17T02:44:37Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('32027523')"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25283
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "32033618"
+"ListingKey": "30040392"
+"ListingId": "40844270"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-18"
+"OpenHouseStartTime": "2026-07-18T14:00:00Z"
+"OpenHouseEndTime": "2026-07-18T18:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-17T15:48:34Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('32033618')"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25290
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "32033619"
+"ListingKey": "30040392"
+"ListingId": "40844270"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-17"
+"OpenHouseStartTime": "2026-07-17T14:00:00Z"
+"OpenHouseEndTime": "2026-07-17T18:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-17T15:48:34Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('32033619')"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25291
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "32033617"
+"ListingKey": "30040392"
+"ListingId": "40844270"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-19"
+"OpenHouseStartTime": "2026-07-19T14:00:00Z"
+"OpenHouseEndTime": "2026-07-19T18:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-17T15:48:34Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('32033617')"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25292
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "32044245"
+"ListingKey": "30040392"
+"ListingId": "40844270"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-19"
+"OpenHouseStartTime": "2026-07-19T14:00:00Z"
+"OpenHouseEndTime": "2026-07-19T18:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-17T20:16:48Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('32044245')"
}
]
+success: true
+page_size: 10
+page_count: 2
+count: 14
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30040392' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5441208 43.491533)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25376
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25370
+post_id: "1637877"
+post_author: 1
+"ListingKey": "30034574"
+"ListingId": "40848343"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:15:07Z"
+"RFModificationTimestamp": "2026-07-17T23:39:09Z"
+"ListPrice": 324900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1072.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4L6"
+"UnparsedAddress": "375 KING Street N Unit# 1608, Waterloo, Ontario N2J4L6"
+"Coordinates": array:2 [
0 => -80.527067
1 => 43.4824701
]
+"Latitude": 43.4824701
+"Longitude": -80.527067
+"YearBuilt": 1984
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this bright and generously sized 2-bedroom, 1-bathroom condo in the heart of Waterloo! Featuring over 1,000 sq. ft. of living space, this unit offers a functional layout with a large living/dining area, a well-appointed kitchen, and spacious bedrooms. Panoramic view from your private balcony. Conveniently located near shopping, transit, universities, and major highways, this unit is perfect for First Time home buyers, investors, or move up buyers looking to live in heart of Waterloo. Building amenities include a large gym, conference room, arts & crafts room, party room, ample visitor parking, indoor rooftop swimming pool, workshop, library , billiards table & a ping pong table. Also there is a free car wash in parking level for building residents. Book your showing today! ( Locker available & 1 covered parking available underground.) Also note that all utilities are included in the condo fees. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Sauna"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"AssociationFee": "900.76"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:8 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Electricity"
4 => "Water"
5 => "Insurance"
6 => "Other, See Remarks"
7 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T23:38:57.068795+00:00"
+"Directions": "Columbia Street West & King Street North"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2073879"
+"ListOfficeKey": "76775"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Backs on greenbelt"
1 => "Balcony"
2 => "Country residential"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-07-15T11:49:34Z"
+"PhotosCount": 47
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:09:31Z"
+"Stories": "1.0"
+"StreetDirSuffix": "North"
+"StreetName": "KING"
+"StreetNumber": "375"
+"StreetSuffix": "Street"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "2110"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Telephone"
]
+"View": "City view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1686993902"
"RoomType" => "4pc Bathroom"
"ListingId" => "40848343"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034574"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:31.4Z"
]
1 => array:11 [
"RoomKey" => "1686993903"
"RoomType" => "Bedroom"
"ListingId" => "40848343"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034574"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 14'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:31.4Z"
]
2 => array:11 [
"RoomKey" => "1686993904"
"RoomType" => "Bedroom"
"ListingId" => "40848343"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034574"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 19'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:31.4Z"
]
3 => array:11 [
"RoomKey" => "1686993905"
"RoomType" => "Kitchen"
"ListingId" => "40848343"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034574"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:31.4Z"
]
4 => array:11 [
"RoomKey" => "1686993906"
"RoomType" => "Dining room"
"ListingId" => "40848343"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034574"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 19'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:31.4Z"
]
5 => array:11 [
"RoomKey" => "1686993907"
"RoomType" => "Living room"
"ListingId" => "40848343"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30034574"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 20'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-17T20:09:31.4Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30034574/375-king-street-n-unit-1608-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "RMU-81"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1072
+"OriginalEntryTimestamp": "2026-07-15T11:49:34.62Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1355211"
+"ListOfficeNationalAssociationId": "1004341"
+"Media": array:47 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30034574_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/c7c73c70f992fbef15d9be6e13389cfb.webp"
"MediaSize" => 154301
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-c7c73c70f992fbef15d9be6e13389cfb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern high-rise residential building featuring multiple private balconies, a flat roofline, and a prominent blue and yellow facade"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30034574_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/1db92dd01fd803404c304bde8078a221.webp"
"MediaSize" => 160532
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-1db92dd01fd803404c304bde8078a221.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern high-rise building with multiple balconies"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30034574_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/94cc92555e8e061c08653342195d469c.webp"
"MediaSize" => 156260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-94cc92555e8e061c08653342195d469c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Multi-story residential building featuring a covered entryway with structural columns and a glass-enclosed entrance"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30034574_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/1e611d02fd1b49577da63acb73d3f42f.webp"
"MediaSize" => 127885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-1e611d02fd1b49577da63acb73d3f42f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious lobby featuring large windows, patterned carpet flooring, mirrored wall accents, and an arched entry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30034574_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/edcb4f34203b505819f42f12e010721f.webp"
"MediaSize" => 122478
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-edcb4f34203b505819f42f12e010721f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious lobby with patterned carpet flooring, dual chandeliers, and an arched entry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30034574_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/be0abfe404a3e757fb6e23d4481e0980.webp"
"MediaSize" => 88828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-be0abfe404a3e757fb6e23d4481e0980.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30034574_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/c61f6d8fae70a0cfc08f406a2244b834.webp"
"MediaSize" => 118961
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-c61f6d8fae70a0cfc08f406a2244b834.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Inviting common area featuring a mix of tile and carpet flooring, a large mail center with individual boxes, and track lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30034574_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/ebdeb36d61d806dd0b80fc64b0b0d0cc.webp"
"MediaSize" => 87647
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-ebdeb36d61d806dd0b80fc64b0b0d0cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway featuring patterned carpet flooring, white walls, and flush-mount ceiling lights"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30034574_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/3c136b3400b7e2f5c00a531afab60c43.webp"
"MediaSize" => 72458
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30034574/thumbnail-3c136b3400b7e2f5c00a531afab60c43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway featuring textured white brick-patterned wall and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40848343"
"ResourceRecordKey" => "30034574"
"ModificationTimestamp" => "2026-07-15T11:49:34.63Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30034574_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30034574/74d2c40a5727a7f91e073e1abac640fa.webp"
"MediaSize" => 50239
"MediaType" => "webp"
…8
]
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('30034574')"
+"ID": "1637877"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25372
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/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"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25369
+post_id: "1637038"
+post_author: 1
+"ListingKey": "30031718"
+"ListingId": "40847893"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:20:06Z"
+"RFModificationTimestamp": "2026-07-17T20:45:54Z"
+"ListPrice": 374900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1043.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4S8"
+"UnparsedAddress": "249 CEDARBRAE Avenue Unit# 1, Waterloo, Ontario N2L4S8"
+"Coordinates": array:2 [
0 => -80.5506971
1 => 43.4854032
]
+"Latitude": 43.4854032
+"Longitude": -80.5506971
+"YearBuilt": 1977
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Wonderful Property in Desirable Waterloo Location with a rental license for 5!!!! Great Investment opportunity! The carpet-free house is on a quiet street, a short walk to the Universities, Shopping stores, and bus routes (bus line 9 just at the corner). 3 Bedrooms on the second floor and two bedrooms in the basement, each bedroom is spacious. The Living Room is Sunny - very bright, and has a hardwood floor. The Kitchen is wide open, has Abundance Cabinets, the common areas are airy, with good-sized windows, and the whole house has a good layout and is well-maintained. Two full baths - one on the second floor, one in the basement. Beautiful front yard, 1 parking spot included at the back of the unit. Updates include a new kitchen with Quartz Countertops (2021), a new bathroom with Quartz Countertops on the 2nd floor (Dec 2024), a Hot Water Heater (2025), and new painting in the basement (2026. Walking Distance To University Of Waterloo! A MUST-SEE house. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "493.47"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-17T20:45:42.164166+00:00"
+"Directions": "GLEN FORREST BLVD Complex Parking Lot Is Off Glen Forrest Boulevard..."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955745"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-14T18:18:04Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:10:08Z"
+"Stories": "2.0"
+"StreetName": "CEDARBRAE"
+"StreetNumber": "249"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "2498.91"
+"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/30031718/249-cedarbrae-avenue-unit-1-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1043
+"OriginalEntryTimestamp": "2026-07-14T18:18:03.96Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1247419"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30031718')"
+"ID": "1637038"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25373
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25371
+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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25366
+post_id: "1632810"
+post_author: 1
+"ListingKey": "30044435"
+"ListingId": "X13573690"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:05:22Z"
+"RFModificationTimestamp": "2026-07-17T20:21:32Z"
+"ListPrice": 415000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5L6"
+"UnparsedAddress": "3 - 513 QUIET PLACE, Waterloo, Ontario N2L5L6"
+"Coordinates": array:2 [
0 => -80.543693
1 => 43.486532
]
+"Latitude": 43.486532
+"Longitude": -80.543693
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 513 Quiet Place, Unit 3, a beautifully maintained, move-in ready townhome located at the prime intersection of Albert Street and Phillip Street in Waterloo's highly sought-after Lakeshore South neighbourhood. This stylish home offers exceptional value for first-time buyers, families, professionals, and investors alike. From the moment you arrive, you'll appreciate the attractive two-tone exterior, black-trimmed windows, and charming front garden that create outstanding curb appeal. Inside, a bright and welcoming foyer with updated flooring in 2022 and pot lights throughout leads into the spacious living room, where an oversized front window fills the space with abundant natural light. The open-concept layout is perfect for both everyday living and entertaining. The updated kitchen features modern cabinetry, stainless steel appliances, a stylish tile backsplash, and generous counter space, while the adjoining dining area overlooks the front garden, creating a bright and inviting setting for family meals. Upstairs, you'll find three generously sized bedrooms and a beautifully renovated bathroom complete with sleek finishes, a modern vanity, and a tiled glass-enclosed shower. The spacious primary bedroom offers plenty of room to relax, while the additional bedrooms are ideal for children, guests, or a home office. The finished basement provides valuable additional living space and features a separate side entrance, a large recreation room, a full bathroom, and ample storage, offering excellent flexibility for extended family, guests, or future potential. Ideally located just steps from Albert McCormick Community Centre, parks, shopping, cafés, and two public schools, this home is also within walking distance of the ION LRT station, making commuting throughout Waterloo and Kitchener quick and convenient. Whether you're looking for your first home or an excellent investment opportunity, this is a property you won't want to miss. Book your showing today! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "670.6"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-16T22:43:31.189594+00:00"
+"Directions": "Cross Streets: Weber. ** Directions: Albert Street to Quiet place."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Irregular lot size"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T19:59:07Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T19:59:07Z"
+"Stories": "2.0"
+"StreetName": "Quiet"
+"StreetNumber": "513"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "2973"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/3_513_quiet_pl_waterloo_on/"
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30044435/3-513-quiet-place-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-07-16T20:39:42.28Z"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"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('30044435')"
+"ID": "1632810"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+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"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25374
+post_id: "1631896"
+post_author: 1
+"ListingKey": "30042236"
+"ListingId": "40847160"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:00:06Z"
+"RFModificationTimestamp": "2026-07-17T23:41:16Z"
+"ListPrice": 415000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1794.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5L6"
+"UnparsedAddress": "513 QUIET Place Unit# 3, Waterloo, Ontario N2L5L6"
+"Coordinates": array:2 [
0 => -80.5436938
1 => 43.486508
]
+"Latitude": 43.486508
+"Longitude": -80.5436938
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 513 Quiet Place, Unit 3, a beautifully maintained, move-in ready townhome located at the prime intersection of Albert Street and Phillip Street in Waterloo's highly sought-after Lakeshore South neighbourhood. This stylish home offers exceptional value for first-time buyers, families, professionals, and investors alike. From the moment you arrive, you'll appreciate the attractive two-tone exterior, black-trimmed windows, and charming front garden that create outstanding curb appeal. Inside, a bright and welcoming foyer with updated flooring in 2022 and pot lights throughout leads into the spacious living room, where an oversized front window fills the space with abundant natural light. The open-concept layout is perfect for both everyday living and entertaining. The updated kitchen features modern cabinetry, stainless steel appliances, a stylish tile backsplash, and generous counter space, while the adjoining dining area overlooks the front garden, creating a bright and inviting setting for family meals. Upstairs, you'll find three generously sized bedrooms and a beautifully renovated bathroom complete with sleek finishes, a modern vanity, and a tiled glass-enclosed shower. The spacious primary bedroom offers plenty of room to relax, while the additional bedrooms are ideal for children, guests, or a home office. The finished basement provides valuable additional living space and features a separate side entrance, a large recreation room, a full bathroom, and ample storage, offering excellent flexibility for extended family, guests, or future potential. Ideally located just steps from Albert McCormick Community Centre, parks, shopping and two public schools, this home is also within walking distance of the ION LRT station, making commuting throughout Waterloo and Kitchener quick and convenient. Whether you're looking for your first home or an excellent investment opportunity, this is a property you won't want to miss. Book your showing today! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "670.6"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Electricity"
3 => "Water"
4 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-16T19:54:35.362696+00:00"
+"Directions": "Albert Street to Quiet place"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564507"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-17T19:52:53Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T19:52:53Z"
+"Stories": "2.0"
+"StreetName": "QUIET"
+"StreetNumber": "513"
+"StreetSuffix": "Place"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "2973"
+"VirtualTourURLUnbranded": "https://youriguide.com/3_513_quiet_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30042236/513-quiet-place-unit-3-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "RMU-40"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1240
+"BelowGradeFinishedArea": 554
+"OriginalEntryTimestamp": "2026-07-16T16:30:18.95Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1123254"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30042236')"
+"ID": "1631896"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25375
+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"
}
]
+success: true
+page_size: 9
+page_count: 25
+count: 222
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]