array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30078824 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23584
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23586
+post_id: "1658650"
+post_author: 1
+"ListingKey": "30078824"
+"ListingId": "40851077"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-25T04:35:09Z"
+"RFModificationTimestamp": "2026-07-25T04:39:27Z"
+"ListPrice": 629900.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.5441273
1 => 43.4915382
]
+"Latitude": 43.4915382
+"Longitude": -80.5441273
+"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. Both UW and WLU are just 3–5 minutes by direct bus or a short bike trip away 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:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "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-25T04:39:23.562790+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-25T04:21:18Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-25T04:28:34Z"
+"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" => "1692991832"
"RoomType" => "Utility room"
"ListingId" => "40851077"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30078824"
"RoomLength" => null
"RoomDimensions" => "8'9'' x 15'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T04:28:34.53Z"
]
1 => array:11 [
"RoomKey" => "1692991833"
"RoomType" => "3pc Bathroom"
"ListingId" => "40851077"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30078824"
"RoomLength" => null
"RoomDimensions" => "5'5'' x 8'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T04:28:34.53Z"
]
2 => array:11 [
"RoomKey" => "1692991834"
"RoomType" => "Laundry room"
"ListingId" => "40851077"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30078824"
"RoomLength" => null
"RoomDimensions" => "3'3'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T04:28:34.53Z"
]
3 => array:11 [
"RoomKey" => "1692991835"
"RoomType" => "Bedroom"
"ListingId" => "40851077"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30078824"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 27'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T04:28:34.53Z"
]
4 => array:11 [
"RoomKey" => "1692991836"
"RoomType" => "4pc Bathroom"
"ListingId" => "40851077"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30078824"
"RoomLength" => null
"RoomDimensions" => "5'8'' x 6'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T04:28:34.53Z"
]
5 => array:11 [
"RoomKey" => "1692991837"
"RoomType" => "Bedroom"
"ListingId" => "40851077"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30078824"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T04:28:34.53Z"
]
6 => array:11 [
"RoomKey" => "1692991838"
"RoomType" => "Bedroom"
"ListingId" => "40851077"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30078824"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T04:28:34.53Z"
]
7 => array:11 [
"RoomKey" => "1692991839"
"RoomType" => "Bedroom"
"ListingId" => "40851077"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30078824"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T04:28:34.53Z"
]
8 => array:11 [
"RoomKey" => "1692991840"
"RoomType" => "2pc Bathroom"
"ListingId" => "40851077"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30078824"
"RoomLength" => null
"RoomDimensions" => "3'2'' x 8'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T04:28:34.53Z"
]
9 => array:11 [
"RoomKey" => "1692991841"
"RoomType" => "Bedroom"
"ListingId" => "40851077"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30078824"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T04:28:34.53Z"
]
10 => array:11 [
"RoomKey" => "1692991842"
"RoomType" => "Living room"
"ListingId" => "40851077"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30078824"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T04:28:34.53Z"
]
11 => array:11 [
"RoomKey" => "1692991843"
"RoomType" => "Kitchen"
"ListingId" => "40851077"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30078824"
"RoomLength" => null
"RoomDimensions" => "7'4'' x 15'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T04:28:34.53Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30078824/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-25T03:08:24.07Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1490334"
+"ListOfficeNationalAssociationId": "1004387"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30078824_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/7c071506352a10f9c6fea107ffe543ba.webp"
"MediaSize" => 164019
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-7c071506352a10f9c6fea107ffe543ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front exterior featuring a convenient carport, detached upper level, and a 53-foot driveway."
"PreferredPhotoYN" => true
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:18.81Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30078824_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/3cac8ef2e290e71dd62e74cf44b5a89d.webp"
"MediaSize" => 120971
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-3cac8ef2e290e71dd62e74cf44b5a89d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carport providing extremely convenient sheltering from snow, rain, and sun."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:17.87Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30078824_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/476b06e9b70b0baaab28186b78a6b10d.webp"
"MediaSize" => 56186
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-476b06e9b70b0baaab28186b78a6b10d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:17.9Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30078824_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/a441a818eb686922e82dec7505f7f4c2.webp"
"MediaSize" => 75332
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-a441a818eb686922e82dec7505f7f4c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:18.81Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30078824_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/a1fd6f69ff6a6e1f6edd66123840c3e6.webp"
"MediaSize" => 62950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-a1fd6f69ff6a6e1f6edd66123840c3e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:18.14Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30078824_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/f73347b1d9019a93acea598399944c68.webp"
"MediaSize" => 56232
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-f73347b1d9019a93acea598399944c68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:18.89Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30078824_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/abf77cc8ca529ff19cc5e18f1847238b.webp"
"MediaSize" => 56879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-abf77cc8ca529ff19cc5e18f1847238b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:18.81Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30078824_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/e772e296a1ce857e7b4464def97b6a25.webp"
"MediaSize" => 70227
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-e772e296a1ce857e7b4464def97b6a25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:18.13Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30078824_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/75e8df8434010bad5ae6ae82b07ad4d9.webp"
"MediaSize" => 77094
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-75e8df8434010bad5ae6ae82b07ad4d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:17.88Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30078824_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/8cd8dce00cc0c08769f3ab9fea3c7b56.webp"
"MediaSize" => 45548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-8cd8dce00cc0c08769f3ab9fea3c7b56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:17.89Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30078824_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/881381eaf163f43862179f5bdd824a81.webp"
"MediaSize" => 55667
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-881381eaf163f43862179f5bdd824a81.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" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:18.81Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30078824_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/e0fa4f1e440e4015700695596ef6d6a6.webp"
"MediaSize" => 74603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-e0fa4f1e440e4015700695596ef6d6a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:18.81Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30078824_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/2c6ededffa8d8a5900b13c394731f3d5.webp"
"MediaSize" => 45722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-2c6ededffa8d8a5900b13c394731f3d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main-floor 2-piece powder room with a vanity."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:18.75Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30078824_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/1a98767f7cfbda53f4735a4ecd714c26.webp"
"MediaSize" => 42548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-1a98767f7cfbda53f4735a4ecd714c26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:18.14Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30078824_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/d9cabfd2b4e789fc21afe31da7d9ab2d.webp"
"MediaSize" => 38116
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-d9cabfd2b4e789fc21afe31da7d9ab2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:18.13Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30078824_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/9eebccc90d5cb20d77b5b856316298d6.webp"
"MediaSize" => 50699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-9eebccc90d5cb20d77b5b856316298d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full 4-piece bathroom on the second floor."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:17.89Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30078824_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/4249b7ade118580faf2fecbca32f2752.webp"
"MediaSize" => 60750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-4249b7ade118580faf2fecbca32f2752.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious primary bedroom retreat."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:17.89Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30078824_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/f039a2070dc3ae9a0efefb2321b2b42c.webp"
"MediaSize" => 58213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-f039a2070dc3ae9a0efefb2321b2b42c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Alternate view of the primary bedroom showing the full wall-to-wall closet."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:18.13Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30078824_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/f7428991f8e5913be16eb05f97022f9f.webp"
"MediaSize" => 61375
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-f7428991f8e5913be16eb05f97022f9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright, south-facing second bedroom on the upper level."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:18.13Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30078824_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/285c78d301d2af402b4fdf35d4dd1a7c.webp"
"MediaSize" => 75441
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-285c78d301d2af402b4fdf35d4dd1a7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright, south-facing third upper-level bedroom."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:16.86Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30078824_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/89b21f6b81bb397885f24531dba25c4f.webp"
"MediaSize" => 33929
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-89b21f6b81bb397885f24531dba25c4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Separate back entrance leading directly to the basement."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:18.9Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30078824_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/a8091721796e6f7ced76b5e60933be0f.webp"
"MediaSize" => 73679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-a8091721796e6f7ced76b5e60933be0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:17.88Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30078824_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/8973d2c03e91ab6253b20bff9c38bb8c.webp"
"MediaSize" => 35911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-8973d2c03e91ab6253b20bff9c38bb8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lower-level 3-piece bathroom with shower."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:18.69Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30078824_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/b55c69c6a6f8b1b6c3a422ac0a4bdcb2.webp"
"MediaSize" => 62700
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-b55c69c6a6f8b1b6c3a422ac0a4bdcb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Massive 5th bedroom in the basement with high ceilings."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:18.89Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30078824_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/930f12109c73bab8f96e1cb0bb48da92.webp"
"MediaSize" => 42563
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-930f12109c73bab8f96e1cb0bb48da92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Alternate view highlighting the spacious basement bedroom."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:18.75Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30078824_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/bbd3d456207459272ba4e0bcc6ddbfe5.webp"
"MediaSize" => 45134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-bbd3d456207459272ba4e0bcc6ddbfe5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brightened by egress windows, this versatile basement space is perfect as a guest suite, family rec room, movie theatre, or home gym."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:18.14Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30078824_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/c57cdd97f66636b3549d1c9e71a7f47d.webp"
"MediaSize" => 177071
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-c57cdd97f66636b3549d1c9e71a7f47d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Freshly painted 16' x 8' private back deck."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:17.88Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30078824_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/2ad3f982f1e2e115bc81d272e6d5d8b8.webp"
"MediaSize" => 230503
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-2ad3f982f1e2e115bc81d272e6d5d8b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:18.9Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30078824_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/c0d8e5b4878e53b6d46f8408280e02d6.webp"
"MediaSize" => 232129
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-c0d8e5b4878e53b6d46f8408280e02d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:18.81Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30078824_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/27663f42ecd2290fc06c321e857997b5.webp"
"MediaSize" => 150476
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-27663f42ecd2290fc06c321e857997b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:18.75Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30078824_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078824/4a7155f119dd1717512d62ff8913cd85.webp"
"MediaSize" => 181591
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078824/thumbnail-4a7155f119dd1717512d62ff8913cd85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851077"
"ResourceRecordKey" => "30078824"
"ModificationTimestamp" => "2026-07-25T04:21:17.88Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30078824')"
+"ID": "1658650"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 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 {#25067
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25010
+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.11 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 {#25090
+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 '30078824'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25384
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30078824' AND OpenHouseDate ge '2026-07-24'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25400
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30078824' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5441273 43.4915382)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25453
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25447
+post_id: "1658885"
+post_author: 1
+"ListingKey": "30009471"
+"ListingId": "X13541492"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-12T16:30:03Z"
+"RFModificationTimestamp": "2026-07-25T07:29:27Z"
+"ListPrice": 274900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0G4"
+"UnparsedAddress": "501 - 321 SPRUCE STREET, Waterloo, Ontario N2L0G4"
+"Coordinates": array:2 [
0 => -80.52726
1 => 43.479262
]
+"Latitude": 43.479262
+"Longitude": -80.52726
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "London and St. Thomas Association of REALTORS®"
+"PublicRemarks": "Experience luxury and convenience in this bright 1+1 bedroom condo in the heart of Waterloo, just steps from University of Waterloo, Wilfrid Laurier University, and Conestoga College. Featuring high-end finishes, stainless steel appliances, quartz countertops, and floor-to-ceiling windows, this fully furnished unit offers a spacious den that can serve as a second bedroom or office, in-suite laundry, and included high-speed internet and weekly housekeeping. Residents enjoy concierge service, an exercise/recreation room, a rooftop patio, and guest suites in this well-maintained, modern building. Immediate occupancy is available book your viewing today! (id:62650)"
+"AssociationFee": "739.57"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-25T07:29:21.909464+00:00"
+"Directions": "Cross Streets: King and University. ** Directions: From Columbia St W turn onto Spruce St."
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100467"
+"ListOfficeKey": "302124"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T04:50:41Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-12T16:20:32Z"
+"StreetName": "Spruce"
+"StreetNumber": "321"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3452"
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1682128594"
"RoomType" => "Kitchen"
"ListingId" => "X13541492"
"RoomLevel" => "Main level"
"RoomWidth" => 3.53
"ListingKey" => "30009471"
"RoomLength" => 2.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-12T16:20:32.27Z"
]
1 => array:11 [
"RoomKey" => "1682128595"
"RoomType" => "Great room"
"ListingId" => "X13541492"
"RoomLevel" => "Main level"
"RoomWidth" => 3.53
"ListingKey" => "30009471"
"RoomLength" => 2.92
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-12T16:20:32.27Z"
]
2 => array:11 [
"RoomKey" => "1682128596"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13541492"
"RoomLevel" => "Main level"
"RoomWidth" => 2.57
"ListingKey" => "30009471"
"RoomLength" => 3.99
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-12T16:20:32.27Z"
]
3 => array:11 [
"RoomKey" => "1682128597"
"RoomType" => "Den"
"ListingId" => "X13541492"
"RoomLevel" => "Main level"
"RoomWidth" => 2.67
"ListingKey" => "30009471"
"RoomLength" => 2.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-12T16:20:32.27Z"
]
4 => array:11 [
"RoomKey" => "1682128598"
"RoomType" => "Bathroom"
"ListingId" => "X13541492"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "30009471"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-12T16:20:32.27Z"
]
]
+"ListAOR": "London and St. Thomas"
+"ListAORKey": "13"
+"ListingURL": "www.realtor.ca/real-estate/30009471/501-321-spruce-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Condo Board Self Manage"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-07-09T04:50:40.98Z"
+"ListAgentNationalAssociationId": "1370499"
+"ListOfficeNationalAssociationId": "1498650"
+"Media": array:13 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30009471_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009471/30c0cca7e6089e328f78c192bf545080.webp"
"MediaSize" => 104933
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009471/thumbnail-30c0cca7e6089e328f78c192bf545080.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13541492"
"ResourceRecordKey" => "30009471"
"ModificationTimestamp" => "2026-07-09T04:50:40.99Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30009471_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009471/296dabfd07b8a787d2821ba59c34c003.webp"
"MediaSize" => 181884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009471/thumbnail-296dabfd07b8a787d2821ba59c34c003.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541492"
"ResourceRecordKey" => "30009471"
"ModificationTimestamp" => "2026-07-09T04:50:40.99Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30009471_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009471/f339e0b35409c76c1dea8ebe5b880705.webp"
"MediaSize" => 181388
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009471/thumbnail-f339e0b35409c76c1dea8ebe5b880705.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541492"
"ResourceRecordKey" => "30009471"
"ModificationTimestamp" => "2026-07-09T04:50:40.99Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30009471_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009471/afe2b104da5989856d718ab378129135.webp"
"MediaSize" => 170830
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009471/thumbnail-afe2b104da5989856d718ab378129135.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541492"
"ResourceRecordKey" => "30009471"
"ModificationTimestamp" => "2026-07-09T04:50:40.99Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30009471_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009471/9e53ca2730880d03fccf9cc89ddc63a1.webp"
"MediaSize" => 141469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009471/thumbnail-9e53ca2730880d03fccf9cc89ddc63a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541492"
"ResourceRecordKey" => "30009471"
"ModificationTimestamp" => "2026-07-09T04:50:40.99Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30009471_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009471/af34a95e4e4233ae9fa9f3db4be18c6f.webp"
"MediaSize" => 132461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009471/thumbnail-af34a95e4e4233ae9fa9f3db4be18c6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541492"
"ResourceRecordKey" => "30009471"
"ModificationTimestamp" => "2026-07-09T04:50:40.99Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30009471_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009471/3e765ee3a3ecf9930d2fbbef9537bd27.webp"
"MediaSize" => 154808
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009471/thumbnail-3e765ee3a3ecf9930d2fbbef9537bd27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541492"
"ResourceRecordKey" => "30009471"
"ModificationTimestamp" => "2026-07-09T04:50:40.99Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30009471_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009471/8275e2eac39df7afdadd987d912affa3.webp"
"MediaSize" => 141927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009471/thumbnail-8275e2eac39df7afdadd987d912affa3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541492"
"ResourceRecordKey" => "30009471"
"ModificationTimestamp" => "2026-07-09T04:50:40.99Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30009471_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009471/9fb53723f5cefd3291b8b01c56c3c671.webp"
"MediaSize" => 185890
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009471/thumbnail-9fb53723f5cefd3291b8b01c56c3c671.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541492"
"ResourceRecordKey" => "30009471"
"ModificationTimestamp" => "2026-07-09T04:50:40.99Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30009471_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009471/1818ae215af8092078bf27a9cfd6572d.webp"
"MediaSize" => 192156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009471/thumbnail-1818ae215af8092078bf27a9cfd6572d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541492"
"ResourceRecordKey" => "30009471"
"ModificationTimestamp" => "2026-07-09T04:50:40.99Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30009471_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009471/11840eb13bf24421d55ab99f17aaa4bf.webp"
"MediaSize" => 180158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009471/thumbnail-11840eb13bf24421d55ab99f17aaa4bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541492"
"ResourceRecordKey" => "30009471"
"ModificationTimestamp" => "2026-07-09T04:50:40.99Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30009471_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009471/c4f3824fececc0418de5d967501614fa.webp"
"MediaSize" => 80082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009471/thumbnail-c4f3824fececc0418de5d967501614fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541492"
"ResourceRecordKey" => "30009471"
"ModificationTimestamp" => "2026-07-09T04:50:40.99Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30009471_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009471/487efbadd34e89377f67c76e6852e1e5.webp"
"MediaSize" => 178769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009471/thumbnail-487efbadd34e89377f67c76e6852e1e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13541492"
"ResourceRecordKey" => "30009471"
"ModificationTimestamp" => "2026-07-09T04:50:40.99Z"
]
]
+"DaysOnMarket": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30009471')"
+"ID": "1658885"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25449
+post_id: "1658427"
+post_author: 1
+"ListingKey": "30078660"
+"ListingId": "40851070"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-25T01:05:20Z"
+"RFModificationTimestamp": "2026-07-25T01:34:17Z"
+"ListPrice": 1249000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2857.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1G4"
+"UnparsedAddress": "667 FERN Road, Waterloo, Ontario N2V1G4"
+"Coordinates": array:2 [
0 => -80.5595415
1 => 43.499981
]
+"Latitude": 43.499981
+"Longitude": -80.5595415
+"YearBuilt": 1987
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare opportunity in sought-after Lakeshore North! Set on an impressive 69' x 159' mature, forested lot, this beautifully updated 4 bedroom home offers an incredible backyard oasis with a heated saltwater pool & hot tub surrounded by hardwood forest. The tranquil setting provides exceptional privacy, low maintenance landscaping & the perfect place to spend the summer relaxing, hosting family & friends, BBQing and entertaining. Inside you will find a spacious & functional layout with extensive upgrades! The kitchen is the heart of the home with an incredible 12 foot quartz island, gas stove, double ovens, updated stainless appliances, & a separate granite coffee & wine bar complete with a second sink, wine fridge & more cabinetry. The dining area is open to the cozy family room with engineered hardwood floors, overlooking the backyard with a wood burning fireplace & walkout to the deck. An additional living room provides even more space, open to the kitchen steps from the 2 pc bath and main floor laundry room. Upstairs you will find a primary bedroom with spa-like ensuite bath, 4 large bedrooms and & another renovated 4 piece bath, this is truly a family home! The finished basement offers a huge rec room with gas fireplace, 2 pc bath and spacious workshop for the woodworker or hobbyist. Many updates, including roof (2021), attic and cold cellar insulation (2018), owned water heater (2019), driveway restoration (2024), eavestroughs, soffits and leaf guards (2021), bathrooms (2024/2025). The backyard retreat has been improved with a new pool liner and heater (2024), pool pump (2026), pool cover (2025), hot tub (2024). Exceptional location, waking distance to Northlake Woods PS, nature trails, St Jacobs Farmer's Market, shopping and all amenities plus moments from expressway access. Combining modern updates, timeless character, and a s (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Hood Fan"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-25T01:34:16.698519+00:00"
+"Directions": "Northlake Drive to Fern Road"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1909721"
+"ListOfficeKey": "77518"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-25T00:59:00Z"
+"PhotosCount": 37
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-25T00:59:00Z"
+"Stories": "2.0"
+"StreetName": "FERN"
+"StreetNumber": "667"
+"StreetSuffix": "Road"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "7439"
+"VirtualTourURLUnbranded": "https://667fern.com/idx"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1692868076"
"RoomType" => "2pc Bathroom"
"ListingId" => "40851070"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30078660"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:59:00.74Z"
]
1 => array:11 [
"RoomKey" => "1692868077"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "40851070"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30078660"
"RoomLength" => null
"RoomDimensions" => "25'6'' x 15'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:59:00.74Z"
]
2 => array:11 [
"RoomKey" => "1692868078"
"RoomType" => "Bedroom"
"ListingId" => "40851070"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30078660"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:59:00.74Z"
]
3 => array:11 [
"RoomKey" => "1692868079"
"RoomType" => "4pc Bathroom"
"ListingId" => "40851070"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30078660"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:59:00.74Z"
]
4 => array:11 [
"RoomKey" => "1692868080"
"RoomType" => "Bedroom"
"ListingId" => "40851070"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30078660"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 14'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:59:00.74Z"
]
5 => array:11 [
"RoomKey" => "1692868081"
"RoomType" => "Bedroom"
"ListingId" => "40851070"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30078660"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:59:00.74Z"
]
6 => array:11 [
"RoomKey" => "1692868082"
"RoomType" => "3pc Bathroom"
"ListingId" => "40851070"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30078660"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:59:00.74Z"
]
7 => array:11 [
"RoomKey" => "1692868083"
"RoomType" => "Primary Bedroom"
"ListingId" => "40851070"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30078660"
"RoomLength" => null
"RoomDimensions" => "14'11'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:59:00.74Z"
]
8 => array:11 [
"RoomKey" => "1692868084"
"RoomType" => "2pc Bathroom"
"ListingId" => "40851070"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30078660"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:59:00.74Z"
]
9 => array:11 [
"RoomKey" => "1692868085"
"RoomType" => "Living room"
"ListingId" => "40851070"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30078660"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 16'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:59:00.75Z"
]
10 => array:11 [
"RoomKey" => "1692868086"
"RoomType" => "Dining room"
"ListingId" => "40851070"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30078660"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 15'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:59:00.75Z"
]
11 => array:11 [
"RoomKey" => "1692868087"
"RoomType" => "Family room"
"ListingId" => "40851070"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30078660"
…5
]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30078660/667-fern-road-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2172119"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "77518"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 69.0
+"AboveGradeFinishedArea": 2181
+"BelowGradeFinishedArea": 676
+"OriginalEntryTimestamp": "2026-07-25T00:59:00.72Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1222004"
+"ListOfficeNationalAssociationId": "1186916"
+"CoListAgentNationalAssociationId": "1422636"
+"CoListOfficeNationalAssociationId": "1186916"
+"Media": array:37 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30078660')"
+"ID": "1658427"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25446
+post_id: "1657615"
+post_author: 1
+"ListingKey": "30077951"
+"ListingId": "X13604388"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T21:45:06Z"
+"RFModificationTimestamp": "2026-07-24T22:43:34Z"
+"ListPrice": 525000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4T3"
+"UnparsedAddress": "A - 185 CEDARVALE CRESCENT, Waterloo, Ontario N2L4T3"
+"Coordinates": array:2 [
0 => -80.547015
1 => 43.488981
]
+"Latitude": 43.488981
+"Longitude": -80.547015
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Looking for an updated home with 4 bedrooms & 2 full baths? This Semi maybe the home for you! North end of University of Waterloo & new Hospital to be built, Conestoga Mall & LRT, this 3+1 bedroom, 2 full bath move-in condition semi on quiet Cedarvale Crescent! Freshly painted throughout, carpet free home with a huge fully fenced backyard is perfectly located on a quiet street with lots of beautiful mature tall trees. The main floor features a large Living room with plenty of natural light from the very large front window as well as the brand new ceiling potlights, Dining area with beautiful contemporary chandelier and large window, open to the brand new modern white shaker style kitchen with quartz counters and white fridge and stove. Take the hardwood stairs to the second storey featureing 3 very good size bedrooms and a modern 4 piece main bathroom. The basement features a large bonus room with a good size window and a closet that can be used as a bedroom or a Recroom, a full 3 piece bathroom, Laundry and Utility room with walk up to the backyard. To access the basement, you have 3 options: from the kitchen inside the house, or the separate enterance (exterior side door) from the drive way, or the stairs from the backyard going to the back door (please don't use the back stairs - they haven't been used recently). Updates include but are not limited to: fresh paint throughout 2026, Brand new kitchen with quarz counters 2026, Fridge & Stove 2025, Pot Lights in Living room 2026, LVP flooring in basement & on stairs going to basement 2026, Main water shut-offs 2026, Dryer 2024, Furnace 2020, Roof 2018, Laminate flooring on main and second floors 2018, Hardwood stairs going to second floor 2018, All plumbing replaced on main & second floors 2018. Close to schools, shopping, busses. Shows very well! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Separate entrance"
2 => "Walk-up"
3 => "N/A"
4 => "N/A"
5 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-24T22:43:26.088070+00:00"
+"Directions": "Cross Streets: Cedarbrae Av. & Parkside Dr. ** Directions: Parkside Dr. to Cedarbrae Av to Cedarvale Cres."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2160875"
+"ListOfficeKey": "290667"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "30.5 x 116.8 FT ; x 31.63ft. x 122.08ft."
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T21:36:29Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T21:36:28Z"
+"Stories": "2.0"
+"StreetName": "Cedarvale"
+"StreetNumber": "185"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3423"
+"VirtualTourURLUnbranded": "https://youriguide.com/185_a_cedarvale_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30077951/a-185-cedarvale-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 30.6
+"OriginalEntryTimestamp": "2026-07-24T21:36:28.81Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1411969"
+"ListOfficeNationalAssociationId": "1390130"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30077951')"
+"ID": "1657615"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25450
+post_id: "1657620"
+post_author: 1
+"ListingKey": "30078070"
+"ListingId": "X13604518"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T22:10:06Z"
+"RFModificationTimestamp": "2026-07-24T22:34:21Z"
+"ListPrice": 875000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2R8"
+"UnparsedAddress": "85 FOXHUNT ROAD, Waterloo, Ontario N2K2R8"
+"Coordinates": array:2 [
0 => -80.52037
1 => 43.496374
]
+"Latitude": 43.496374
+"Longitude": -80.52037
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "At 85 Foxhunt Road, every level has a purpose. This updated four-level side split in established Colonial Acres delivers bright, open living, multiple gathering spaces and a flexible lower-level layout. The main floor features wide-plank flooring, pot lights and a spacious living room anchored by a striking stone fireplace wall. The refreshed kitchen combines white cabinetry, a tile backsplash, gas range and contrasting island, while the adjoining dining area opens to a sun-filled 16'9" x 9'10" enclosed sunroom overlooking the backyard. Upstairs, three well-proportioned bedrooms are grouped with an updated four-piece bathroom. The lower level adds a generous family room, two-piece powder room and attached single garage. Down one more level, a versatile room currently staged as a bedroom is joined by a beautifully finished three-piece bathroom with glass shower, a second kitchenette area and laundry space. This flexible configuration provides valuable options for overnight guests, extended-household living, recreation or work-from-home needs. Outside, the deep fenced backyard offers mature greenery, a deck and plenty of room to garden, entertain or simply enjoy the outdoors. Colonial Acres is an established north Waterloo neighbourhood known for its low-density residential character, mature streets and generous green space. Anndale Park and the surrounding trail network provide convenient opportunities to walk, cycle and enjoy the outdoors. Nearby RIM Park, Waterloo's largest recreation complex, offers rinks, courts, sports fields, trails and natural areas. Conestoga Mall places shopping, dining and everyday services within easy reach, while Conestoga Station provides access to ION light rail and multiple GRT routes. Highway 85 also offers convenient connections throughout Waterloo Region. (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Garage door opener remote(s)"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T22:34:15.876088+00:00"
+"Directions": "Cross Streets: Redfox Road. ** Directions: DAVENPORT ROAD TO KINGSCOURT DRIVE TO REDFOX ROAD TO FOXHUNT ROAD."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2242463"
+"ListOfficeKey": "286835"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Irregular lot size"
]
+"LotSizeDimensions": "130 x 60.1 FT ; 70.11x60.10x120.51x60.10"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T22:03:26Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T22:03:26Z"
+"StreetName": "Foxhunt"
+"StreetNumber": "85"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4683"
+"VirtualTourURLUnbranded": "https://youriguide.com/85_foxhunt_road_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30078070/85-foxhunt-road-waterloo"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 130.0
+"OriginalEntryTimestamp": "2026-07-24T22:03:26.32Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1480584"
+"ListOfficeNationalAssociationId": "1364242"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30078070')"
+"ID": "1657620"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25448
+post_id: "1656848"
+post_author: 1
+"ListingKey": "30076768"
+"ListingId": "X13603310"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T18:45:07Z"
+"RFModificationTimestamp": "2026-07-24T19:48:32Z"
+"ListPrice": 553000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0G9"
+"UnparsedAddress": "113 - 288 ALBERT STREET, Waterloo, Ontario N2L0G9"
+"Coordinates": array:2 [
0 => -80.533768
1 => 43.477153
]
+"Latitude": 43.477153
+"Longitude": -80.533768
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "RARELY VACANT, Fully Furnished, Freshly Painted Turn Key Investment Steps from University of Waterloo, and Laurier University! Potential Positive Cashflow with Rent and Low Vacancy Rate due to student housing demand for Universities. COMES WITH 1 PARKING SPOT! Main Floor, Corner unit, with Three Bedrooms, Three FULL Washrooms, Large Main Floor Den, along with another lower level study Area, with 1 Surface Level Parking, Ensuite Laundry. Each Bedroom comes Fully Equipped with Bed Frame, Mattress, Side Table, and Study Desk. Open Concept Living, and Dinning with TV, Sofas and Dinning Table Set. Large U-Shaped Kitchen with stainless steel appliances, Quarts Counter Tops/Backsplash and Bar Stool Seating. Main Floor Den Also Comes with Sofas, TV, and Storage Cabinet. Must See, Everything in the Unit comes with it! Perfect for if you or a loved one will be attending University or if you are looking to build your Investment Portfolio. (id:62650)"
+"Appliances": array:5 [
0 => "All"
1 => "Washer"
2 => "Dryer"
3 => "Furniture"
4 => "Window Coverings"
]
+"AssociationFee": "582.02"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T19:48:23.436678+00:00"
+"Directions": "Cross Streets: University Ave & Albert St. ** Directions: Turn East into Complex from Albert St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Ceramic"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2087935"
+"ListOfficeKey": "292212"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T18:39:36Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T18:39:35Z"
+"StreetName": "Albert"
+"StreetNumber": "288"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4779.34"
+"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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30076768/113-288-albert-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management Inc"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"OriginalEntryTimestamp": "2026-07-24T18:39:35.65Z"
+"ListAgentNationalAssociationId": "1361256"
+"ListOfficeNationalAssociationId": "1409372"
+"Media": array:28 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30076768')"
+"ID": "1656848"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25443
+post_id: "1656993"
+post_author: 1
+"ListingKey": "30075685"
+"ListingId": "40850923"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T16:35:23Z"
+"RFModificationTimestamp": "2026-07-24T19:27:42Z"
+"ListPrice": 589900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.14
+"LivingArea": 2026.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4N1"
+"UnparsedAddress": "602 HIGHPOINT Avenue, Waterloo, Ontario N2L4N1"
+"Coordinates": array:2 [
0 => -80.5629215
1 => 43.4867268
]
+"Latitude": 43.4867268
+"Longitude": -80.5629215
+"YearBuilt": 1972
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "OPPORTUNITY KNOCKS IN LAKESHORE ! Welcome to 602 Highpoint Avenue, a rock-solid, all-brick raised bungalow nestled in one of Waterloo’s most desirable family neighborhoods. Offered as a clean blank canvas ready for its next chapter. The main floor features an exceptionally bright, expansive living room with a massive front bay window, a formal dining area, a functional kitchen with a rear walkout, three bedrooms, and a full 4-piece bathroom. Distinct from conventional raised bungalows, the low-profile design features a highly accessible entry with just a single step into the home. The fully finished lower level massively expands your living space, showcasing a huge family room anchored by a rustic brick feature wall and a cozy wood-burning stove. This level also includes a spacious fourth bedroom, a powder room, a dedicated laundry area, and a separate workshop/utility space with abundant storage. Step outside to your private wood deck overlooking a wide, beautifully landscaped, fully fenced yard framed by a pristine cedar hedge and mature fruit trees. Additional features include a deep asphalt driveway and vinyl windows (approximately 10 years old). Ashphalt Roof (approximately 10 years old) Walk to top-rated schools, parks, and local amenities. Unlock this home’s massive potential today! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-24T19:27:30.471780+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Other"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2214101"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.14"
+"PhotosChangeTimestamp": "2026-07-24T16:29:59Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T16:29:59Z"
+"Stories": "1.0"
+"StreetName": "HIGHPOINT"
+"StreetNumber": "602"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "3987"
+"VirtualTourURLUnbranded": "https://youriguide.com/602_highpoint_avenue_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30075685/602-highpoint-avenue-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 1050
+"BelowGradeFinishedArea": 976
+"OriginalEntryTimestamp": "2026-07-24T16:29:59.14Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1459821"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30075685')"
+"ID": "1656993"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23598
+post_id: "1656367"
+post_author: 1
+"ListingKey": "30076062"
+"ListingId": "40850502"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T18:40:04Z"
+"RFModificationTimestamp": "2026-07-24T18:44:07Z"
+"ListPrice": 525000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1605.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4T3"
+"UnparsedAddress": "185 CEDARVALE Crescent Unit# A, Waterloo, Ontario N2L4T3"
+"Coordinates": array:2 [
0 => -80.5470388
1 => 43.4889802
]
+"Latitude": 43.4889802
+"Longitude": -80.5470388
+"YearBuilt": 1971
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Looking for an updated home with 4 bedrooms & 2 full baths? This Semi maybe the home for you! North end of University of Waterloo & new Hospital to be built, Conestoga Mall & LRT, this 3+1 bedroom, 2 full bath move-in condition semi on quiet Cedarvale Crescent! Freshly painted throughout, carpet free home with a huge fully fenced backyard is perfectly located on a quiet street with lots of beautiful mature tall trees. The main floor features a large Living room with plenty of natural light from the very large front window as well as the brand new ceiling potlights, Dining area with beautiful contemporary chandelier and large window, open to the brand new modern white shaker style kitchen with quartz counters and white fridge and stove. Take the hardwood stairs to the second storey featureing 3 very good size bedrooms and a modern 4 piece main bathroom. The basement features a large bonus room with a good size window and a closet that can be used as a bedroom or a Recroom, a full 3 piece bathroom, Laundry and Utility room with walk up to the backyard. To access the basement, you have 3 options: from the kitchen inside the house, or the separate enterance (exterior side door) from the drive way, or the stairs from the backyard going to the back door (please don't use the back stairs - they haven't been used recently). Updates include but are not limited to: fresh paint throughout 2026, Brand new kitchen with quarz counters 2026, Fridge & Stove 2025, Pot Lights in Living room 2026, LVP flooring in basement & on stairs going to basement 2026, Main water shut-offs 2026, Dryer 2024, Furnace 2020, Roof 2018, Laminate flooring on main and second floors 2018, Hardwood stairs going to second floor 2018, All plumbing replaced on main & second floors 2018. Close to schools, shopping, busses. Shows very well! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-24T18:14:38.397112+00:00"
+"Directions": "Parkside Dr/Cedarbrae Ave"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564444"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-07-24T18:33:27Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T18:33:27Z"
+"Stories": "2.0"
+"StreetName": "CEDARVALE"
+"StreetNumber": "185"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "3423.1"
+"VirtualTourURLUnbranded": "https://youriguide.com/185_a_cedarvale_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30076062/185-cedarvale-crescent-unit-a-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2070594"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1600658"
+"CoListAgentKey3": "1630441"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "290620"
+"CoListOfficeKey3": "76826"
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1066
+"BelowGradeFinishedArea": 539
+"OriginalEntryTimestamp": "2026-07-24T17:08:29.5Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1122502"
+"ListOfficeNationalAssociationId": "1389824"
+"CoListAgentNationalAssociationId": "1345744"
+"CoListAgentNationalAssociationId2": "1153962"
+"CoListAgentNationalAssociationId3": "1162058"
+"CoListOfficeNationalAssociationId": "1004387"
+"CoListOfficeNationalAssociationId2": "1389824"
+"CoListOfficeNationalAssociationId3": "1004387"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30076062')"
+"ID": "1656367"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25451
+post_id: "1655783"
+post_author: 1
+"ListingKey": "30075063"
+"ListingId": "40849840"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T15:05:31Z"
+"RFModificationTimestamp": "2026-07-24T17:06:19Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1428.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1A9"
+"UnparsedAddress": "274 NORTHLAKE Drive Unit# B, Waterloo, Ontario N2V1A9"
+"Coordinates": array:2 [
0 => -80.5511816
1 => 43.4974065
]
+"Latitude": 43.4974065
+"Longitude": -80.5511816
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this well-maintained raised bungalow semi-detached home in one of Waterloo's most desirable family-friendly neighbourhoods. Backing onto beautiful parkland, this home offers privacy and a peaceful setting. Featuring 3 spacious bedrooms, 2 full bathrooms, a bright living room with a large bay window, and an eat-in kitchen with a breakfast bar. The finished lower level features a recreation room with a walkout, a 3-piece bathroom, and a laundry area, offering added flexibility and potential for an in-law setup. Step outside to the fully fenced backyard, complete with a patio and storage shed, perfect for relaxing or entertaining. Conveniently located close to schools, parks, shopping, transit, and all amenities, this is an excellent opportunity for first-time buyers, families, or investors. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T17:06:09.845889+00:00"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1897040"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T14:59:39Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T14:59:39Z"
+"Stories": "1.0"
+"StreetName": "NORTHLAKE"
+"StreetNumber": "274"
+"StreetSuffix": "Drive"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "3630"
+"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/30075063/274-northlake-drive-unit-b-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 883
+"BelowGradeFinishedArea": 545
+"OriginalEntryTimestamp": "2026-07-24T14:59:39.45Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1215043"
+"ListOfficeNationalAssociationId": "1004370"
+"Media": array:21 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30075063')"
+"ID": "1655783"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25452
+post_id: "1650469"
+post_author: 1
+"ListingKey": "30068043"
+"ListingId": "40848945"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T11:55:10Z"
+"RFModificationTimestamp": "2026-07-23T11:56:22Z"
+"ListPrice": 850000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3031.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1X2"
+"UnparsedAddress": "353 TWINFLOWER Crescent, Waterloo, Ontario N2V1X2"
+"Coordinates": array:2 [
0 => -80.5607806
1 => 43.4989658
]
+"Latitude": 43.4989658
+"Longitude": -80.5607806
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 353 Twinflower Crescent, a mature community wrapped in tree lined streets with walkable amenities. The fact that this beautifully maintained home has only had one owner since built in 1988 should tell you everything you need to know about this property. Factor in that a fully excavated addition was completed by Menno Martin in 2000, which DOUBLED THE SIZE OF THE KITCHEN, makes this truly a one of a kind offering! Inside, you are welcomed by a sweeping sunken foyer which greets your guests in style. Accompanied by the main floor living room, and just a step up to a formal dining room, this entry level is completed by a massive Chef's kitchen that everyone dreams of. The Centre Island layout allows for more than ample prep space or simply allows for company to cheerlead you on as you prepare that special family feast. The upper level of this 4 level backsplit features 3 bedrooms, a primary en-suite bath & walk-in closet while the 5 pc main bath will service others on this upper level. The lower level, allows for large look out windows for an abundance of natural daylight. This level features a bountiful family room with natural gas fireplace, a 2 pc bath, finished laundry room & 4th bedroom for the growing family or guest room needs. Down below in the FULLY FINISHED 4th level, there is an abundance of much desired space for a recreation room plus a games room & a 5th bedroom! The backyard is your private oasis. Not directly backing onto any neighbours, you can enjoy the privacy of the mature landscaping for all you outdoor gatherings. The amenities of Northlake are plenty & access to shopping at Conestoga Mall & the Expressway are just minutes away. You're also just a stones throw from St Jacobs & their famous Farmer's Market. Schools, parks, greenspace and trails are all within walking distance of Twinflower Crescent. We hope to see you either Sat or Sun between 2 & 4 pm & encourage you to call your Realtor to book a private viewing before it's too late. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Gas stove(s)"
6 => "Dishwasher"
7 => "Dryer"
8 => "Microwave"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T22:37:15.125360+00:00"
+"Directions": "Northlake Drive to Monarch Place, first right is Twinflower Crescent, first house on your left."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1854697"
+"ListOfficeKey": "76840"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
3 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T07:10:15Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T11:48:44Z"
+"Stories": "2.0"
+"StreetName": "TWINFLOWER"
+"StreetNumber": "353"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "5603"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/353-Twinflower-Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30068043/353-twinflower-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1564118"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76840"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 1747
+"BelowGradeFinishedArea": 1284
+"OriginalEntryTimestamp": "2026-07-22T22:08:23.49Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1199521"
+"ListOfficeNationalAssociationId": "1004363"
+"CoListAgentNationalAssociationId": "1126014"
+"CoListOfficeNationalAssociationId": "1004363"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30068043')"
+"ID": "1650469"
}
]
+success: true
+page_size: 9
+page_count: 24
+count: 212
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]