array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29935245 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411
+post_id: "1553201"
+post_author: 1
+"ListingKey": "29935245"
+"ListingId": "40841524"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T00:00:17Z"
+"RFModificationTimestamp": "2026-06-23T00:05:32Z"
+"ListPrice": 580000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1737.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1Y9"
+"UnparsedAddress": "458 BEECHWOOD Place Unit# 3, Waterloo, Ontario N2T1Y9"
+"Coordinates": array:2 [
0 => -80.5578541
1 => 43.4523458
]
+"Latitude": 43.4523458
+"Longitude": -80.5578541
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Sophisticated Urban Living | Fully Furnished & Move-In Ready 2 Bed | 3 Bath | Townhouse Condo | Upper Beechwood Skip the months of sourcing furniture and styling — this rare fully furnished townhouse condo in Upper Beechwood is ready for its next owner from day one. Every room has been thoughtfully curated with top-quality pieces, so you can move in and simply start living. Blending the privacy and vertical flow of a townhouse with the low-maintenance ease of condo living, this home is the definition of effortless sophistication. The multi-level layout separates the generous open-concept dining and living areas from the two spacious bedrooms, offering the perfect balance of social space and personal retreat. Three full bathrooms mean no more morning queues, while the efficient, well-appointed kitchen makes everything from a solo espresso to a dinner party feel equally effortless. In-unit laundry with full-sized washer and dryer adds to the everyday convenience, and with storage space throughout, there's a place for everything. Arrive home through your dedicated, secure garage — a private entrance leads directly into the mudroom, keeping the elements firmly outside where they belong. Inside, a private office provides a quiet, productive workspace, while the dedicated gym downstairs gives you the perfect way to decompress after a long day. When the evening comes, step out onto the ample balcony and take in the sunset from your own private outdoor perch. Residents also enjoy access to a communal pool — the finishing touch on a lifestyle that asks very little of you and delivers everything. A true find in Upper Beechwood. Book your viewing today. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"AssociationFee": "775"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Water"
4 => "Insurance"
5 => "Parking"
]
+"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-06-22T14:06:57.347854+00:00"
+"Directions": "Beechwood Place is off of Erb St"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2107659"
+"ListOfficeKey": "259258"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T23:30:41Z"
+"PhotosCount": 27
+"PoolFeatures": array:1 [
0 => "Pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T23:50:25Z"
+"Stories": "2.0"
+"StreetName": "BEECHWOOD"
+"StreetNumber": "458"
+"StreetSuffix": "Place"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "3482.09"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Telephone"
]
+"View": "City view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1665730614"
"RoomType" => "Recreation room"
"ListingId" => "40841524"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29935245"
"RoomLength" => null
"RoomDimensions" => "16'1'' x 9'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T23:50:25.54Z"
]
1 => array:11 [
"RoomKey" => "1665730615"
"RoomType" => "Laundry room"
"ListingId" => "40841524"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29935245"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T23:50:25.55Z"
]
2 => array:11 [
"RoomKey" => "1665730616"
"RoomType" => "Den"
"ListingId" => "40841524"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29935245"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 5'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T23:50:25.55Z"
]
3 => array:11 [
"RoomKey" => "1665730617"
"RoomType" => "2pc Bathroom"
"ListingId" => "40841524"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29935245"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 4'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T23:50:25.56Z"
]
4 => array:11 [
"RoomKey" => "1665730618"
"RoomType" => "Full bathroom"
"ListingId" => "40841524"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29935245"
"RoomLength" => null
"RoomDimensions" => "14'1'' x 6'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T23:50:25.56Z"
]
5 => array:11 [
"RoomKey" => "1665730619"
"RoomType" => "Primary Bedroom"
"ListingId" => "40841524"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29935245"
"RoomLength" => null
"RoomDimensions" => "16'4'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T23:50:25.57Z"
]
6 => array:11 [
"RoomKey" => "1665730620"
"RoomType" => "Living room"
"ListingId" => "40841524"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29935245"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T23:50:25.57Z"
]
7 => array:11 [
"RoomKey" => "1665730621"
"RoomType" => "Kitchen"
"ListingId" => "40841524"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29935245"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 7'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T23:50:25.58Z"
]
8 => array:11 [
"RoomKey" => "1665730622"
"RoomType" => "Dining room"
"ListingId" => "40841524"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29935245"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T23:50:25.58Z"
]
9 => array:11 [
"RoomKey" => "1665730623"
"RoomType" => "Breakfast"
"ListingId" => "40841524"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29935245"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 6'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T23:50:25.58Z"
]
10 => array:11 [
"RoomKey" => "1665730624"
"RoomType" => "3pc Bathroom"
"ListingId" => "40841524"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29935245"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 8'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T23:50:25.59Z"
]
11 => array:11 [
"RoomKey" => "1665730625"
"RoomType" => "Bedroom"
"ListingId" => "40841524"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29935245"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T23:50:25.59Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29935245/458-beechwood-place-unit-3-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "MR150"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1245
+"BelowGradeFinishedArea": 492
+"OriginalEntryTimestamp": "2026-06-22T13:31:45.99Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1376648"
+"ListOfficeNationalAssociationId": "1217708"
+"Media": array:27 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29935245_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/690ecba5487b8c432d7470f00f24969f.webp"
"MediaSize" => 144232
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-690ecba5487b8c432d7470f00f24969f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T13:51:30.64Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29935245_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/e9fc34d9b4636dd16729d201508a0fc1.webp"
"MediaSize" => 134609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-e9fc34d9b4636dd16729d201508a0fc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T13:51:30.14Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29935245_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/15e98f6a0448347b8c93292fac160f88.webp"
"MediaSize" => 136823
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-15e98f6a0448347b8c93292fac160f88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exterior entry court featuring a patterned paver surface, brick facade, and integrated landscaping beds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T13:51:30.14Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29935245_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/f8bace25cdbb3492afd1668d17a707d3.webp"
"MediaSize" => 71996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-f8bace25cdbb3492afd1668d17a707d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring a vaulted ceiling with a suspended light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T23:30:37.86Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29935245_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/91146d3a3f36980c68230a42522cc2b0.webp"
"MediaSize" => 68515
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-91146d3a3f36980c68230a42522cc2b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T23:30:37.86Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29935245_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/a1e6e303e7559ce00ca5422e89ef4fa8.webp"
"MediaSize" => 75015
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-a1e6e303e7559ce00ca5422e89ef4fa8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T23:30:37.83Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29935245_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/1747a04b1490f0fef6fb224ad54740ac.webp"
"MediaSize" => 64640
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-1747a04b1490f0fef6fb224ad54740ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T23:30:37.85Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29935245_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/d0a243061174aa8876c73fa09531367a.webp"
"MediaSize" => 70851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-d0a243061174aa8876c73fa09531367a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T23:30:37.85Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29935245_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/71dbd296ecfc75f124194d22f12a75e6.webp"
"MediaSize" => 74531
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-71dbd296ecfc75f124194d22f12a75e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T23:30:38.62Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29935245_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/f58dc59aca6e811599947ecc7618ab73.webp"
"MediaSize" => 90004
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-f58dc59aca6e811599947ecc7618ab73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T23:30:37.87Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29935245_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/096eb1e3a170dc6f0142db46173db819.webp"
"MediaSize" => 75834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-096eb1e3a170dc6f0142db46173db819.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T23:30:37.84Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29935245_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/22da7e4cb9a88f8286363ffe1e7ef8b5.webp"
"MediaSize" => 75331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-22da7e4cb9a88f8286363ffe1e7ef8b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T23:30:41.05Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29935245_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/04198bac16267177fd139124f08dcf58.webp"
"MediaSize" => 79617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-04198bac16267177fd139124f08dcf58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Master Bedroom featuring wood-finish flooring, neutral wall tones, and two windows with horizontal blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T23:30:37.87Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29935245_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/67a5863301aa66c14346349d7c708d92.webp"
"MediaSize" => 56746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-67a5863301aa66c14346349d7c708d92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T18:32:31.05Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29935245_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/d36b863a6094365857cc011873d3d525.webp"
"MediaSize" => 84285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-d36b863a6094365857cc011873d3d525.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T23:30:40.2Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29935245_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/7ee3ed4bac1d83b0edf18e522630b74d.webp"
"MediaSize" => 65536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-7ee3ed4bac1d83b0edf18e522630b74d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light neutral wall paint, wood-finish flooring, a window with blinds, and white baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T23:30:37.83Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29935245_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/4daa73405f3a4c06678f0741e0816409.webp"
"MediaSize" => 59787
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-4daa73405f3a4c06678f0741e0816409.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with a laminate countertop, undermount sink, and a four-light vanity fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T23:30:38.4Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29935245_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/a54bf92ce3003fa36e60e6d534fa585b.webp"
"MediaSize" => 73805
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-a54bf92ce3003fa36e60e6d534fa585b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T23:30:38.62Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29935245_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/bd9f3be22f6f78cad8a0bc5f1ec47a69.webp"
"MediaSize" => 52936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-bd9f3be22f6f78cad8a0bc5f1ec47a69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T23:30:38.65Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29935245_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/f7ddf125dc45713388d3f8104baf41a9.webp"
"MediaSize" => 49680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-f7ddf125dc45713388d3f8104baf41a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T23:30:39.78Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29935245_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/8548d7bbb4312189d04009555dc3f977.webp"
"MediaSize" => 66833
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-8548d7bbb4312189d04009555dc3f977.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T23:30:38.42Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29935245_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/362aa367c65cfad9b94621c80bb40a78.webp"
"MediaSize" => 86934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-362aa367c65cfad9b94621c80bb40a78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room with light-toned wood-finish flooring, white baseboards, and a paneled door with a brass-finish knob"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T23:30:38.4Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29935245_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/58294c771e109473216d6916ea21ec77.webp"
"MediaSize" => 47531
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-58294c771e109473216d6916ea21ec77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated utility area featuring a paneled interior door, light-toned wood-finish flooring, and a drop ceiling with recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T23:30:39.78Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29935245_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/1f866d590c877926e4fbe5bf1c96e3d2.webp"
"MediaSize" => 62937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-1f866d590c877926e4fbe5bf1c96e3d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T23:30:38.42Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29935245_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/78c92e93fd7d06402a8d4a276bc2e359.webp"
"MediaSize" => 112424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-78c92e93fd7d06402a8d4a276bc2e359.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious outdoor terrace with a concrete surface, featuring a black metal railing and a beige brick exterior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T23:30:38.42Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29935245_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/ef2ea743766ce4576d9c07b62f127767.webp"
"MediaSize" => 112060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-ef2ea743766ce4576d9c07b62f127767.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T23:30:40.2Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29935245_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935245/23a16e34d2dba1c4b7c30d45456b0cab.webp"
"MediaSize" => 52776
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935245/thumbnail-23a16e34d2dba1c4b7c30d45456b0cab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841524"
"ResourceRecordKey" => "29935245"
"ModificationTimestamp" => "2026-06-22T18:32:31.21Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29935245')"
+"ID": "1553201"
}
]
+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=OfficeMlsId eq 259258" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24801
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2107659" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24888
+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 '29935245'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25190
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29935245'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25206
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29935245' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5578541 43.4523458)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25259
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25253
+post_id: "1556236"
+post_author: 1
+"ListingKey": "29939963"
+"ListingId": "40842183"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T03:00:04Z"
+"RFModificationTimestamp": "2026-06-23T04:38:39Z"
+"ListPrice": 339000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1250.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6E6"
+"UnparsedAddress": "300 KEATS Way Unit# 207, Waterloo, Ontario N2L6E6"
+"Coordinates": array:2 [
0 => -80.5442195
1 => 43.4623301
]
+"Latitude": 43.4623301
+"Longitude": -80.5442195
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 300 Keats Way unit 207—a beautifully appointed 1,250 square foot condo located at the back of the building, close to traffic but away from the noise. This bright and spacious 2-bedroom, 2-bathroom condo offers an ideal blend of comfort, functionality and peace. The open-concept layout is bathed in natural light, featuring new vinyl flooring, a seamless flow from living and dining areas to a large private balcony, and a primary suite complete with a private ensuite. Additional highlights include in-suite laundry, 1 underground parking spaces, and a dedicated storage locker. The building is exceptionally well-maintained, with recent updates including a new roof, newer underground garage, upgraded intercom system, and a strengthened reserve fund. Residents enjoy amenities such as a fitness centre and billiards room. Located in the heart of Beechwood/university, moments from Uptown Waterloo, University of Waterloo, Wilfrid Laurier University, Keats way public School , WCI Secondary School, T&T Supermarket, parks, trails, and transit—this move-in-ready home offers spacious living in a quiet, amenity-rich building. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "1037.87"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:7 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Water"
4 => "Insurance"
5 => "Parking"
6 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T04:38:32.452163+00:00"
+"Directions": "UNIVERSITY AVE TO KEATS WAY"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2175198"
+"ListOfficeKey": "292482"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-23T02:50:17Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T02:50:17Z"
+"Stories": "1.0"
+"StreetName": "KEATS"
+"StreetNumber": "300"
+"StreetSuffix": "Way"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2260"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1665824691"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842183"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939963"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 15'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:50:17Z"
]
1 => array:11 [
"RoomKey" => "1665824692"
"RoomType" => "Kitchen"
"ListingId" => "40842183"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939963"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 19'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:50:17.01Z"
]
2 => array:11 [
"RoomKey" => "1665824693"
"RoomType" => "Living room"
"ListingId" => "40842183"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939963"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 19'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:50:17.02Z"
]
3 => array:11 [
"RoomKey" => "1665824694"
"RoomType" => "Dining room"
"ListingId" => "40842183"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939963"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:50:17.02Z"
]
4 => array:11 [
"RoomKey" => "1665824695"
"RoomType" => "Bedroom"
"ListingId" => "40842183"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939963"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:50:17.02Z"
]
5 => array:11 [
"RoomKey" => "1665824696"
"RoomType" => "Laundry room"
"ListingId" => "40842183"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939963"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 5'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:50:17.02Z"
]
6 => array:11 [
"RoomKey" => "1665824697"
"RoomType" => "3pc Bathroom"
"ListingId" => "40842183"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939963"
"RoomLength" => null
"RoomDimensions" => "4'9'' x 7'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:50:17.03Z"
]
7 => array:11 [
"RoomKey" => "1665824698"
"RoomType" => "Full bathroom"
"ListingId" => "40842183"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29939963"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 7'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-23T02:50:17.03Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29939963/300-keats-way-unit-207-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Car Wash"
1 => "Party Room"
]
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1250
+"OriginalEntryTimestamp": "2026-06-23T02:50:16.8Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1425540"
+"ListOfficeNationalAssociationId": "1412629"
+"Media": array:34 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29939963_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/f41063dfc8a809eb13772f01299f3355.webp"
"MediaSize" => 62526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-f41063dfc8a809eb13772f01299f3355.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842183"
"ResourceRecordKey" => "29939963"
"ModificationTimestamp" => "2026-06-23T02:50:16.81Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29939963_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/cf300f873438f6ecae74cec7236525f7.webp"
"MediaSize" => 130812
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-cf300f873438f6ecae74cec7236525f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842183"
"ResourceRecordKey" => "29939963"
"ModificationTimestamp" => "2026-06-23T02:50:16.81Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29939963_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/2702eb2a17836f48b20a225462924b6a.webp"
"MediaSize" => 119283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-2702eb2a17836f48b20a225462924b6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842183"
"ResourceRecordKey" => "29939963"
"ModificationTimestamp" => "2026-06-23T02:50:16.81Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29939963_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/6838adcb751d36434b831453be3ed1e3.webp"
"MediaSize" => 87377
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-6838adcb751d36434b831453be3ed1e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842183"
"ResourceRecordKey" => "29939963"
"ModificationTimestamp" => "2026-06-23T02:50:16.81Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29939963_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/ef0529be6ed75df2a84c996051362018.webp"
"MediaSize" => 68847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-ef0529be6ed75df2a84c996051362018.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842183"
"ResourceRecordKey" => "29939963"
"ModificationTimestamp" => "2026-06-23T02:50:16.81Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29939963_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/0455bdcfba9e2d80f0dd0e4c5b534a0b.webp"
"MediaSize" => 81760
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-0455bdcfba9e2d80f0dd0e4c5b534a0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842183"
"ResourceRecordKey" => "29939963"
"ModificationTimestamp" => "2026-06-23T02:50:16.81Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29939963_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/44a53d41d8f4d0931383a4261e6a26a6.webp"
"MediaSize" => 56895
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-44a53d41d8f4d0931383a4261e6a26a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842183"
"ResourceRecordKey" => "29939963"
"ModificationTimestamp" => "2026-06-23T02:50:16.81Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29939963_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/9b9dfc320f2c73ee8d914e484714da33.webp"
"MediaSize" => 39290
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-9b9dfc320f2c73ee8d914e484714da33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842183"
"ResourceRecordKey" => "29939963"
"ModificationTimestamp" => "2026-06-23T02:50:16.81Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29939963_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/44e0559104a32cb5bbcf452d79785cfa.webp"
"MediaSize" => 32451
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-44e0559104a32cb5bbcf452d79785cfa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842183"
"ResourceRecordKey" => "29939963"
"ModificationTimestamp" => "2026-06-23T02:50:16.81Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29939963_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/58ef8bc4d4407b832d3a5b27936fac50.webp"
"MediaSize" => 37126
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-58ef8bc4d4407b832d3a5b27936fac50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842183"
"ResourceRecordKey" => "29939963"
"ModificationTimestamp" => "2026-06-23T02:50:16.81Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29939963_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/547c54ce46cfb2ec367d88ae640647d4.webp"
"MediaSize" => 81044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-547c54ce46cfb2ec367d88ae640647d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842183"
"ResourceRecordKey" => "29939963"
"ModificationTimestamp" => "2026-06-23T02:50:16.81Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29939963_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/7d4702e11075c0f8a5b3901ad4a0c669.webp"
"MediaSize" => 77441
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-7d4702e11075c0f8a5b3901ad4a0c669.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842183"
"ResourceRecordKey" => "29939963"
"ModificationTimestamp" => "2026-06-23T02:50:16.81Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29939963_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/e169d7dd023b891c7ea34b715bf1490a.webp"
"MediaSize" => 53971
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-e169d7dd023b891c7ea34b715bf1490a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842183"
"ResourceRecordKey" => "29939963"
"ModificationTimestamp" => "2026-06-23T02:50:16.81Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29939963_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/b9aa0b2dccfe35db9a79a5df49eb29f4.webp"
"MediaSize" => 91356
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-b9aa0b2dccfe35db9a79a5df49eb29f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842183"
"ResourceRecordKey" => "29939963"
"ModificationTimestamp" => "2026-06-23T02:50:16.81Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29939963_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/70c86106dc6f64248352b1c8d1f57860.webp"
"MediaSize" => 78188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-70c86106dc6f64248352b1c8d1f57860.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842183"
"ResourceRecordKey" => "29939963"
"ModificationTimestamp" => "2026-06-23T02:50:16.81Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29939963_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/9cfc711225d83bf91b207b4b57d8b968.webp"
"MediaSize" => 68758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-9cfc711225d83bf91b207b4b57d8b968.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842183"
"ResourceRecordKey" => "29939963"
"ModificationTimestamp" => "2026-06-23T02:50:16.81Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29939963_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/6b35823dc6cbf4e1d4fb9fc900bd6a56.webp"
"MediaSize" => 41735
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-6b35823dc6cbf4e1d4fb9fc900bd6a56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842183"
"ResourceRecordKey" => "29939963"
"ModificationTimestamp" => "2026-06-23T02:50:16.81Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29939963_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/eb2d26a230c37a4aafe65451e3360d87.webp"
"MediaSize" => 74023
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-eb2d26a230c37a4aafe65451e3360d87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842183"
"ResourceRecordKey" => "29939963"
"ModificationTimestamp" => "2026-06-23T02:50:16.81Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29939963_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/d5efd82539094d2f8bab5b67bb38d526.webp"
"MediaSize" => 103946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-d5efd82539094d2f8bab5b67bb38d526.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842183"
"ResourceRecordKey" => "29939963"
"ModificationTimestamp" => "2026-06-23T02:50:16.81Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29939963_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/19dd0c1b6e7523db3483625b1f6520ef.webp"
"MediaSize" => 103569
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-19dd0c1b6e7523db3483625b1f6520ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842183"
"ResourceRecordKey" => "29939963"
"ModificationTimestamp" => "2026-06-23T02:50:16.81Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29939963_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/86af95cf173cec86da4703741bb645de.webp"
"MediaSize" => 76662
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-86af95cf173cec86da4703741bb645de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842183"
"ResourceRecordKey" => "29939963"
"ModificationTimestamp" => "2026-06-23T02:50:16.81Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29939963_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/e4d4807dade90a666596f836b8fa7690.webp"
"MediaSize" => 101956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-e4d4807dade90a666596f836b8fa7690.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842183"
"ResourceRecordKey" => "29939963"
"ModificationTimestamp" => "2026-06-23T02:50:16.81Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29939963_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29939963/8957d20f48d5aee8569bcb6ae45163d6.webp"
"MediaSize" => 85428
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29939963/thumbnail-8957d20f48d5aee8569bcb6ae45163d6.webp"
…7
]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29939963')"
+"ID": "1556236"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25255
+post_id: "1556237"
+post_author: 1
+"ListingKey": "29940024"
+"ListingId": "X13477170"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T03:50:00Z"
+"RFModificationTimestamp": "2026-06-23T04:34:23Z"
+"ListPrice": 339000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6E6"
+"UnparsedAddress": "#207 - 300 KEATS WAY, Waterloo, Ontario N2L6E6"
+"Coordinates": array:2 [
0 => -80.544516
1 => 43.462144
]
+"Latitude": 43.462144
+"Longitude": -80.544516
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 300 Keats Way unit 207-a beautifully appointed 1,250 square foot condo located at the back of the building, close to traffic but away from the noise. This bright and spacious 2-bedroom, 2-bathroom condo offers an ideal blend of comfort, functionality and peace. The open-concept layout is bathed in natural light, featuring new vinyl flooring, a seamless flow from living and dining areas to a large private balcony, and a primary suite complete with a private ensuite. Additional highlights include in-suite laundry, 1 underground parking spaces, and a dedicated storage locker. The building is exceptionally well-maintained, with recent updates including a new roof, newer underground garage, upgraded intercom system, and a strengthened reserve fund. Residents enjoy amenities such as a fitness centre and billiards room. Located in the heart of Beechwood/university, moments from Uptown Waterloo, University of Waterloo, Wilfrid Laurier University, Keats way public School , WCI Secondary School, T&T Supermarket, parks, trails, and transit-this move-in-ready home offers spacious living in a quiet, amenity-rich building. (id:62650)"
+"AssociationFee": "1037.87"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T04:34:17.703271+00:00"
+"Directions": "UNIVERSITY AVE TO KEATS WAY"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2135760"
+"ListOfficeKey": "70066"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-23T03:41:02Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T03:41:02Z"
+"StreetName": "KEATS"
+"StreetNumber": "300"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "2260"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29940024/207-300-keats-way-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "TREVARREN PROP MGMT"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-23T03:41:02.41Z"
+"ListAgentNationalAssociationId": "1388108"
+"ListOfficeNationalAssociationId": "1132867"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29940024')"
+"ID": "1556237"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25252
+post_id: "1555410"
+post_author: 1
+"ListingKey": "29938461"
+"ListingId": "X13476114"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T01:05:19Z"
+"RFModificationTimestamp": "2026-06-23T01:09:52Z"
+"ListPrice": 1290000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2R2"
+"UnparsedAddress": "450 WESTHAVEN STREET, Waterloo, Ontario N2T2R2"
+"Coordinates": array:2 [
0 => -80.566908
1 => 43.445283
]
+"Latitude": 43.445283
+"Longitude": -80.566908
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 450 Westhaven Street, a beautifully upgraded Ritz Homes residence in one of Waterloo's most sought after family neighbourhoods. Less than one year old, this stunning home offers approximately 2,320 sq ft above grade plus a finished basement, featuring quartz countertops throughout, a designer kitchen with a custom coffee bar, engineered hardwood flooring, oak staircases with black metal pickets, and no carpet throughout. The finished lower level adds exceptional versatility with a spacious recreation room, additional bedroom, full bathroom, and a convenient kitchenette complete with a sink, making it ideal for extended family, guests, or multi generational living. Complete with 200 amp service, central air conditioning, gas lines for the stove and BBQ, and numerous builder upgrades, this move in ready home offers the perfect blend of style, comfort, and functionality.Ideally situated in the highly desirable Westvale area of Waterloo, this home is surrounded by excellent schools, beautiful parks, walking trails, playgrounds, and family friendly amenities. Enjoy convenient access to shopping, restaurants, Costco, The Boardwalk, universities, public transit, and major commuter routes including Highway 7/8. Whether you're raising a family, working from home, or simply looking for a newer home in a thriving community, 450 Westhaven Street delivers exceptional value in one of Waterloo's most convenient and connected locations. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
]
+"Basement": array:7 [
0 => "Finished"
1 => "Full"
2 => "Apartment in basement"
3 => "Separate entrance"
4 => "N/A"
5 => "N/A"
6 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T21:22:19.317367+00:00"
+"Directions": "Cross Streets: Erb Street W to Westhaven Street. ** Directions: Erb Street W."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2071055"
+"ListOfficeKey": "148048"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "Guest Suite"
2 => "In-Law Suite"
]
+"LotSizeDimensions": "31.5 x 113.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T00:57:44Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T00:57:44Z"
+"Stories": "2.0"
+"StreetName": "Westhaven"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3794.36"
+"VirtualTourURLUnbranded": "https://calibre-media.aryeo.com/sites/rojnzoxv/unbranded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29938461/450-westhaven-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "SR-1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 31.6
+"OriginalEntryTimestamp": "2026-06-22T20:49:22.68Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1346258"
+"ListOfficeNationalAssociationId": "1177786"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29938461')"
+"ID": "1555410"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25256
+post_id: "1554239"
+post_author: 1
+"ListingKey": "29936784"
+"ListingId": "40841223"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T17:35:20Z"
+"RFModificationTimestamp": "2026-06-22T18:58:38Z"
+"ListPrice": 2425000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 6105.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6M5"
+"UnparsedAddress": "248 THE LION'S Gate, Waterloo, Ontario N2L6M5"
+"Coordinates": array:2 [
0 => -80.5522568
1 => 43.4660801
]
+"Latitude": 43.4660801
+"Longitude": -80.5522568
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A rare offering in Beechwood, this distinguished executive residence occupies one of the community's most desirable lots on a quiet cul-de-sac, backing onto mature greenery and just steps from the amenities of the Beechwood Park Homes Association. Custom-built by Bob Loebsack and meticulously maintained by its original owners, the home showcases exceptional craftsmanship, custom millwork, and timeless architectural design. The grand foyer opens to a dramatic double-height living room featuring soaring windows, French doors, and a fireplace. The custom kitchen is appointed with antique-white cabinetry, granite countertops, premium appliances, dual islands, and a distinctive breakfast area surrounded by windows. An elegant dining room with coffered ceilings and custom wainscoting provides the perfect setting for formal entertaining. A stunning main-floor library, inspired by traditional English manor homes, features floor-to-ceiling custom cabinetry, a rolling library ladder, coffered ceilings, and a fireplace, creating an exceptional home office. Upstairs, four spacious bedrooms are complemented by three full bathrooms. The luxurious primary suite offers a gas fireplace, walk-in closet, spa-inspired ensuite, and a private loft of approximately 450 sq. ft., ideal as a sitting area, or family lounge. Professionally finished by Country Lane Builders, the lower level features a family room with fireplace, bar area, fitness room, and flexible multi-purpose space. Set on approximately one-third of an acre, the backyard is designed for both recreation and entertaining, featuring a fully equipped outdoor kitchen, gas fireplace, in-ground hot tub, basketball court, and professional landscaping. Beechwood residents enjoy access to top-rated schools, extensive trails, recreation facilities, shopping, and close proximity to everyday amenities. A rare opportunity to own a home of exceptional quality, and enduring craftsmanship in one of Waterloo's premier communities. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Central Vacuum"
5 => "Gas stove(s)"
6 => "Dishwasher"
7 => "Dryer"
8 => "Oven - Built-In"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
12 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T18:58:32.761073+00:00"
+"Directions": "Columbia St W / Westmount Rd N / The Lions Gate"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "4"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "Electric"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2005428"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T17:10:33Z"
+"PhotosCount": 45
+"PoolFeatures": array:1 [
0 => "Pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T17:10:33Z"
+"Stories": "2.0"
+"StreetName": "THE LION'S"
+"StreetNumber": "248"
+"StreetSuffix": "Gate"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "13749.7"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/248_the_lions_gate_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:26 [
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]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
22 => array:11 [ …11]
23 => array:11 [ …11]
24 => array:11 [ …11]
25 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29936784/248-the-lions-gate-waterloo"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2190750"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76807"
+"GeocodeManualYN": true
+"SecurityFeatures": array:3 [
0 => "Alarm system"
1 => "Security system"
2 => "Smoke Detectors"
]
+"ZoningDescription": "SR2A"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 4185
+"BelowGradeFinishedArea": 1920
+"OriginalEntryTimestamp": "2026-06-22T17:10:33.08Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1287777"
+"ListOfficeNationalAssociationId": "1384313"
+"CoListAgentNationalAssociationId": "1439796"
+"CoListOfficeNationalAssociationId": "1004370"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29936784')"
+"ID": "1554239"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25254
+post_id: "1553291"
+post_author: 1
+"ListingKey": "29935502"
+"ListingId": "X13473080"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T23:15:05Z"
+"RFModificationTimestamp": "2026-06-22T23:26:16Z"
+"ListPrice": 650000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2L2"
+"UnparsedAddress": "530 PENNY LANE, Waterloo, Ontario N2T2L2"
+"Coordinates": array:2 [
0 => -80.5576596
1 => 43.4383877
]
+"Latitude": 43.4383877
+"Longitude": -80.5576596
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Located in desirable Westvale, this beautifully cared-for open-concept 2-storey home offers comfort, character, and thoughtful updates throughout. Set close to schools, shopping, restaurants, and public transit, this home feels welcoming from the moment you arrive. An oversized front porch adds to the curb appeal and creates a charming spot to enjoy your morning coffee or unwind at the end of the day. Inside, soaring ceilings in the living room create an open, airy feel and a unique living experience. The newly renovated kitchen (2024) offers plenty of cabinetry, great functionality, and a walkout to the large back deck, making indoor-outdoor entertaining easy. A good-sized dining space is ready to welcome your guests, while the main floor bedroom and beautifully updated 4-piece bathroom add flexibility and convenience. Upstairs, the spacious primary bedroom features cathedral ceilings, along with a beautifully updated 3-piece bathroom with a walk-in shower and skylight. The lower level offers excellent flexibility, with space that could be used as an additional bedroom, rec room, or in-law setup, complete with a walkout to the backyard and renovated 3-piece bathroom. Out back, the large deck is surrounded by mature greenery, setting the scene for summer dinners and quiet evenings. The generous backyard, with a 144-foot lot depth, provides plenty of room for families to enjoy, while the custom shed offers great storage for tools, bikes, and outdoor essentials. Recent updates include the kitchen in 2024, main floor bathroom in 2024, basement bathroom in 2022, upstairs bathroom in 2026, reverse osmosis system in 2025, smart thermostat in 2026, and double-wide concrete driveway in 2017. An immaculate home in a wonderful neighbourhood, offering comfort, flexibility, and pride of ownership throughout. (id:62650)"
+"Appliances": array:2 [
0 => "Water purifier"
1 => "Water softener"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T15:51:10.613257+00:00"
+"Directions": "Cross Streets: Baker Street and University Ave. W. ** Directions: Turn East on University Ave from Ira Needles, Left on Baker Street, Right on Penny Lane. House is on the right side."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2213582"
+"ListOfficeKey": "296481"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "33.5 x 144.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T23:07:10Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T23:07:10Z"
+"Stories": "2.0"
+"StreetName": "Penny"
+"StreetNumber": "530"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "4239.49"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youtu.be/HO29w3ZmW30"
+"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/29935502/530-penny-lane-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 33.6
+"OriginalEntryTimestamp": "2026-06-22T14:18:23.49Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1459405"
+"ListOfficeNationalAssociationId": "1470796"
+"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('29935502')"
+"ID": "1553291"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25249
+post_id: "1553265"
+post_author: 1
+"ListingKey": "29935456"
+"ListingId": "40841785"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T16:00:12Z"
+"RFModificationTimestamp": "2026-06-22T16:04:56Z"
+"ListPrice": 299900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 699.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2N0B6"
+"UnparsedAddress": "931 GLASGOW Street Unit# 14D, Kitchener, Ontario N2N0B6"
+"Coordinates": array:2 [
0 => -80.543044
1 => 43.4395953
]
+"Latitude": 43.4395953
+"Longitude": -80.543044
+"YearBuilt": 2011
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 14D at 931 Glasgow Street — a stylish and strategically located Townhouse Condo in Kitchener-Waterloo. Perfectly positioned just minutes from Waterloo Regional Health Network at Midtown (formerly Grand River Hospital) and Queen's Blvd. (formerly St. Mary's General Hospital), Uptown Waterloo, Wilfrid Laurier University, and the University of Waterloo, this stylish 1 Bedroom, 1 Bathroom residence offers an exceptional opportunity for First-Time Home Buyers, young Professionals/Students, and savvy Investors alike. Designed with modern living in mind, the bright open-concept layout creates an inviting sense of space and flow. The Kitchen is both functional and elegant, featuring lots of cabinetry and generous counter space with an Island, complemented by sleek appliances. Whether preparing a quiet dinner at Home or hosting friends, this space delivers both style and practicality. The Living Room offers a warm and comfortable atmosphere — ideal for relaxing after a busy day or entertaining with ease. The spacious Primary Bedroom with ample closet space provides a peaceful and private retreat. A 4-pce Bathroom and Laundry/Utility Room complete the interior space. Outside, a charming private Patio is the perfect setting for morning coffee, evening unwinding, or a touch of outdoor living in the city. Adding to the convenience, an assigned parking spot is situated directly out your Front Door, with Visitor Parking close by. An exceptional opportunity in a prime location with strong living or rental appeal and lifestyle convenience, Unit 14D at 931 Glasgow Street blends comfort, sophistication, and investment potential in one impressive package. Schedule your private viewing today! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "173.5"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T15:29:47.374565+00:00"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1984104"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-22T15:51:54Z"
+"PhotosCount": 14
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T15:51:54Z"
+"StreetName": "GLASGOW"
+"StreetNumber": "931"
+"StreetSuffix": "Street"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "2719.66"
+"VirtualTourURLUnbranded": "https://www.instagram.com/reel/DZ49KNeOgRB"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29935456/931-glasgow-street-unit-14d-kitchener"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1984099"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "283125"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 699
+"OriginalEntryTimestamp": "2026-06-22T14:10:52.47Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1268887"
+"ListOfficeNationalAssociationId": "1378680"
+"CoListAgentNationalAssociationId": "1268885"
+"CoListOfficeNationalAssociationId": "1324759"
+"Media": array:14 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29935456')"
+"ID": "1553265"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1553184"
+post_author: 1
+"ListingKey": "29935012"
+"ListingId": "40839626"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T15:00:19Z"
+"RFModificationTimestamp": "2026-06-22T15:03:29Z"
+"ListPrice": 650000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1783.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2L2"
+"UnparsedAddress": "530 PENNY Lane, Waterloo, Ontario N2T2L2"
+"Coordinates": array:2 [
0 => -80.5576544
1 => 43.4383807
]
+"Latitude": 43.4383807
+"Longitude": -80.5576544
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located in desirable Westvale, this beautifully cared-for open-concept 2-storey home offers comfort, character, and thoughtful updates throughout. Set close to schools, shopping, restaurants, and public transit, this home feels welcoming from the moment you arrive. An oversized front porch adds to the curb appeal and creates a charming spot to enjoy your morning coffee or unwind at the end of the day. Inside, soaring ceilings in the living room create an open, airy feel and a unique living experience. The newly renovated kitchen (2024) offers plenty of cabinetry, great functionality, and a walkout to the large back deck, making indoor-outdoor entertaining easy. A good-sized dining space is ready to welcome your guests, while the main floor bedroom and beautifully updated 4-piece bathroom add flexibility and convenience. Upstairs, the spacious primary bedroom features cathedral ceilings, along with a beautifully updated 3-piece bathroom with a walk-in shower and skylight. The lower level offers excellent flexibility, with space that could be used as an additional bedroom, rec room, or in-law setup, complete with a walkout to the backyard and renovated 3-piece bathroom. Out back, the large deck is surrounded by mature greenery, setting the scene for summer dinners and quiet evenings. The generous backyard, with a 144-foot lot depth, provides plenty of room for families to enjoy, while the custom shed offers great storage for tools, bikes, and outdoor essentials. Recent updates include the kitchen in 2024, main floor bathroom in 2024, basement bathroom in 2022, upstairs bathroom in 2026, reverse osmosis system in 2025, smart thermostat in 2026, and double-wide concrete driveway in 2017. An immaculate home in a wonderful neighbourhood, offering comfort, flexibility, and pride of ownership throughout. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T13:42:31.889238+00:00"
+"Directions": "Turn East on University Ave from Ira Needles, Left on Baker Street, Right on Penny Lane. House is on the right side."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2082150"
+"ListOfficeKey": "296447"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Skylight"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T13:51:18Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T14:52:01Z"
+"Stories": "1.5"
+"StreetName": "PENNY"
+"StreetNumber": "530"
+"StreetSuffix": "Lane"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "4239.49"
+"VirtualTourURLUnbranded": "https://youtu.be/HO29w3ZmW30"
+"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/29935012/530-penny-lane-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2180308"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283397"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 34.0
+"AboveGradeFinishedArea": 1290
+"BelowGradeFinishedArea": 493
+"OriginalEntryTimestamp": "2026-06-22T11:50:44.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1356952"
+"ListOfficeNationalAssociationId": "1458684"
+"CoListAgentNationalAssociationId": "1430151"
+"CoListOfficeNationalAssociationId": "1328541"
+"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('29935012')"
+"ID": "1553184"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25257
+post_id: "1551452"
+post_author: 1
+"ListingKey": "29932781"
+"ListingId": "40837095"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T13:20:16Z"
+"RFModificationTimestamp": "2026-06-20T14:55:03Z"
+"ListPrice": 350000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1223.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5G6"
+"UnparsedAddress": "65 WESTMOUNT Road N Unit# 910, Waterloo, Ontario N2L5G6"
+"Coordinates": array:2 [
0 => -80.5393732
1 => 43.4615946
]
+"Latitude": 43.4615946
+"Longitude": -80.5393732
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Perched on the 9th floor with bright south-east-facing exposure, Unit 910 at Westmount Towers II offers space, light, and one of the best vantage points in the building. This is one of Waterloo’s most convenient addresses, within walking distance of Uptown Waterloo, Waterloo Park, both universities, transit, shopping, and everyday amenities. Inside, a functional 2-bedroom, 2-bathroom layout spans roughly 1,223 square feet, with hardwood floors through the living and kitchen areas, maple cabinetry, a separate dining space, a primary bedroom with a private 2-piece ensuite, a second bedroom, a main bathroom, and an enclosed balcony that adds comfortable year-round living space. The unit includes one owned underground parking space, an exclusive storage locker, and access to the building’s common laundry. Residents enjoy a full set of amenities, including an elevator, exercise room, games room, party room, workshop, bike storage, and visitor parking. The monthly fee is simple and predictable, covering property taxes along with heat, hydro, water, parking, insurance, building maintenance, management, snow removal, and more. Prefer something turnkey? A number of the furnishings can stay with the unit. Best of all, Westmount Towers II is currently in the process of converting to a standard condominium, a transition expected to open the door to conventional financing and added long-term value. A rare opportunity to own a bright, top-floor home in one of Waterloo’s most sought-after locations, with real upside ahead as the conversion progresses. (id:62783)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Garage door opener"
4 => "Microwave Built-in"
]
+"AssociationFee": "1140"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:9 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Heat"
4 => "Electricity"
5 => "Water"
6 => "Insurance"
7 => "Other, See Remarks"
8 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-20T14:55:01.817463+00:00"
+"Directions": "University to Westmount"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2246706"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Laundry- Coin operated"
3 => "No Pet Home"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-20T13:10:29Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T13:10:29Z"
+"Stories": "9.0"
+"StreetDirSuffix": "North"
+"StreetName": "WESTMOUNT"
+"StreetNumber": "65"
+"StreetSuffix": "Road"
+"SubdivisionName": "417 - Beechwood/University"
+"VirtualTourURLUnbranded": "https://youriguide.com/unit_910_65_westmount_rd_n_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29932781/65-westmount-road-n-unit-910-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1563569"
+"CoListAgentKey2": "1600603"
+"CoListOfficeKey": "290620"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"CoListOfficeKey2": "76826"
+"ZoningDescription": "RMU-60"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1223
+"OriginalEntryTimestamp": "2026-06-20T13:10:29.24Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1485557"
+"ListOfficeNationalAssociationId": "1004387"
+"CoListAgentNationalAssociationId": "1109914"
+"CoListAgentNationalAssociationId2": "1145016"
+"CoListOfficeNationalAssociationId": "1389824"
+"CoListOfficeNationalAssociationId2": "1004387"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932781')"
+"ID": "1551452"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25258
+post_id: "1548810"
+post_author: 1
+"ListingKey": "29928466"
+"ListingId": "X13466958"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T16:20:09Z"
+"RFModificationTimestamp": "2026-06-19T16:55:51Z"
+"ListPrice": 749000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5E6"
+"UnparsedAddress": "53 HELENE CRESCENT, Waterloo, Ontario N2L5E6"
+"Coordinates": array:2 [
0 => -80.546704
1 => 43.457956
]
+"Latitude": 43.457956
+"Longitude": -80.546704
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "LOCATION, LOCATION. 5 Minuts drive or walking distance to both Unitversities. Perfect for families, investors, or those seeking extra income! This home represents an opportunity with endless possibilities! This solid, well-maintained bungalow offers incredible versatility with two fully finished levels, each complete with its own living room, kitchen, bathrooms, and three generously sized bedrooms per level. Upstairs,. The kitchen offers plenty of cupboards, counter space and a spacious eat-in nook area with a large window. The lower level is a bright, self-sufficient living space with oversized windows, 3 bedrooms, 1 bathroom, kitchen, and a private separate entrance, ideal for extended family living or as a mortgage-helping rental unit. Enjoy a good-sized backyard perfect for gardening or relaxing, A long driveway fits up to 4 cars, making parking convenient for large families or tenants. (id:62650)"
+"Appliances": array:4 [
0 => "Dryer"
1 => "Two stoves"
2 => "Two Washers"
3 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Apartment in basement"
1 => "Walk-up"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T16:55:43.420266+00:00"
+"Directions": "Amos Ave"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2238838"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "42 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T15:59:11Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T15:59:11Z"
+"Stories": "1.0"
+"StreetName": "Helene"
+"StreetNumber": "53"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3836"
+"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": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29928466/53-helene-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "Res"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 42.0
+"OriginalEntryTimestamp": "2026-06-19T15:59:11.69Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1476652"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:26 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29928466')"
+"ID": "1548810"
}
]
+success: true
+page_size: 9
+page_count: 17
+count: 152
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]