array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30081564 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23584
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23586
+post_id: "1661588"
+post_author: 1
+"ListingKey": "30081564"
+"ListingId": "40849396"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-27T14:40:20Z"
+"RFModificationTimestamp": "2026-07-27T17:18:15Z"
+"ListPrice": 775000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.18
+"LivingArea": 1872.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3T9"
+"UnparsedAddress": "285 ALBERT Street, Waterloo, Ontario N2L3T9"
+"Coordinates": array:2 [
0 => -80.5342011
1 => 43.4766498
]
+"Latitude": 43.4766498
+"Longitude": -80.5342011
+"YearBuilt": 1951
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this charming brick home on a premium corner lot in one of Waterloo's most sought-after neighbourhoods. Situated just minutes from the University of Waterloo, Wilfrid Laurier University, shopping, transit, parks, and everyday amenities, this well-maintained property offers exceptional flexibility for homeowners, investors, and future-minded buyers alike. Featuring over 1,800 square feet of finished living space, this home offers 4 bedrooms, 2 bathrooms, a separate entrance to the partially finished basement, and a functional layout ideal for family living, multi-generational use, or income-generating opportunities. The property was licensed by the City of Waterloo as a Class B 4-bedroom rental property through March 31, 2026, highlighting its established rental history and appeal in this high-demand university market. Outside, enjoy a private backyard retreat complete with an inground pool, mature landscaping, patio space, and ample parking including an attached garage. Whether you're looking for a home in a prime Waterloo location, an investment property with strong rental demand, or a property with long-term upside, this opportunity delivers. The property's prominent corner location at Albert Street and Hickory Street offers excellent exposure and future potential within Waterloo's rapidly evolving Northdale neighbourhood. Adjacent properties at 289, 291 and 293 Albert Street are also available for sale, creating a rare opportunity for purchasers to explore a potential land assembly and redevelopment project in one of the city's most active growth corridors. Enjoy the property today while securing a strategic real estate asset for tomorrow. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-27T17:17:55.433185+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Stove"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750163"
+"ListOfficeKey": "156288"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0.18"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-27T14:30:13Z"
+"PhotosCount": 22
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-27T14:30:13Z"
+"Stories": "1.5"
+"StreetName": "ALBERT"
+"StreetNumber": "285"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "6688.65"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1694575013"
"RoomType" => "Storage"
"ListingId" => "40849396"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30081564"
"RoomLength" => null
"RoomDimensions" => "4'10'' x 9'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:30:13.48Z"
]
1 => array:11 [
"RoomKey" => "1694575014"
"RoomType" => "Bonus Room"
"ListingId" => "40849396"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30081564"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:30:13.49Z"
]
2 => array:11 [
"RoomKey" => "1694575015"
"RoomType" => "Laundry room"
"ListingId" => "40849396"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30081564"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 13'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:30:13.49Z"
]
3 => array:11 [
"RoomKey" => "1694575016"
"RoomType" => "Bedroom"
"ListingId" => "40849396"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30081564"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:30:13.49Z"
]
4 => array:11 [
"RoomKey" => "1694575017"
"RoomType" => "Recreation room"
"ListingId" => "40849396"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30081564"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 16'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:30:13.49Z"
]
5 => array:11 [
"RoomKey" => "1694575018"
"RoomType" => "2pc Bathroom"
"ListingId" => "40849396"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30081564"
"RoomLength" => null
"RoomDimensions" => "3'10'' x 4'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:30:13.49Z"
]
6 => array:11 [
"RoomKey" => "1694575019"
"RoomType" => "Bedroom"
"ListingId" => "40849396"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30081564"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:30:13.49Z"
]
7 => array:11 [
"RoomKey" => "1694575020"
"RoomType" => "Bedroom"
"ListingId" => "40849396"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30081564"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:30:13.49Z"
]
8 => array:11 [
"RoomKey" => "1694575021"
"RoomType" => "4pc Bathroom"
"ListingId" => "40849396"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30081564"
"RoomLength" => null
"RoomDimensions" => "8'5'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:30:13.49Z"
]
9 => array:11 [
"RoomKey" => "1694575022"
"RoomType" => "Bedroom"
"ListingId" => "40849396"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30081564"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 14'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:30:13.49Z"
]
10 => array:11 [
"RoomKey" => "1694575023"
"RoomType" => "Living room"
"ListingId" => "40849396"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30081564"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 15'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:30:13.49Z"
]
11 => array:11 [
"RoomKey" => "1694575024"
"RoomType" => "Kitchen"
"ListingId" => "40849396"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30081564"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T14:30:13.49Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30081564/285-albert-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1750102"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "156288"
+"GeocodeManualYN": true
+"ZoningDescription": "RN6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 55.0
+"AboveGradeFinishedArea": 1421
+"BelowGradeFinishedArea": 451
+"OriginalEntryTimestamp": "2026-07-27T14:30:13.38Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1131089"
+"ListOfficeNationalAssociationId": "1112493"
+"CoListAgentNationalAssociationId": "1066272"
+"CoListOfficeNationalAssociationId": "1112493"
+"Media": array:22 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30081564_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081564/8348293822f52190241a9ac3d48e94e7.webp"
"MediaSize" => 178997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081564/thumbnail-8348293822f52190241a9ac3d48e94e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40849396"
"ResourceRecordKey" => "30081564"
"ModificationTimestamp" => "2026-07-27T14:30:13.39Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30081564_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081564/0c25cd58f5ce5d45ef60bc74fd9b50d7.webp"
"MediaSize" => 186769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081564/thumbnail-0c25cd58f5ce5d45ef60bc74fd9b50d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849396"
"ResourceRecordKey" => "30081564"
"ModificationTimestamp" => "2026-07-27T14:30:13.39Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30081564_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081564/aab3f7350c58b9a7e4e780ff2aecebb0.webp"
"MediaSize" => 187671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081564/thumbnail-aab3f7350c58b9a7e4e780ff2aecebb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849396"
"ResourceRecordKey" => "30081564"
"ModificationTimestamp" => "2026-07-27T14:30:13.39Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30081564_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081564/e6cdf2a0cdd7ca0239d7c8e9f7843f63.webp"
"MediaSize" => 155013
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081564/thumbnail-e6cdf2a0cdd7ca0239d7c8e9f7843f63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849396"
"ResourceRecordKey" => "30081564"
"ModificationTimestamp" => "2026-07-27T14:30:13.39Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30081564_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081564/772b095d0e6bd9a881010712fa4e101c.webp"
"MediaSize" => 178042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081564/thumbnail-772b095d0e6bd9a881010712fa4e101c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849396"
"ResourceRecordKey" => "30081564"
"ModificationTimestamp" => "2026-07-27T14:30:13.39Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30081564_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081564/7c6a3563bea1c14d1ffe53312861687a.webp"
"MediaSize" => 116319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081564/thumbnail-7c6a3563bea1c14d1ffe53312861687a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849396"
"ResourceRecordKey" => "30081564"
"ModificationTimestamp" => "2026-07-27T14:30:13.39Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30081564_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081564/0dc0f3f88bafd33886c0e8cac577b4d3.webp"
"MediaSize" => 110932
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081564/thumbnail-0dc0f3f88bafd33886c0e8cac577b4d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849396"
"ResourceRecordKey" => "30081564"
"ModificationTimestamp" => "2026-07-27T14:30:13.39Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30081564_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081564/5d083a4fe074a4d6ce2dd3160c974f75.webp"
"MediaSize" => 107615
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081564/thumbnail-5d083a4fe074a4d6ce2dd3160c974f75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849396"
"ResourceRecordKey" => "30081564"
"ModificationTimestamp" => "2026-07-27T14:30:13.39Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30081564_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081564/0beb6b14d6490d58c96c66b1c9d845d4.webp"
"MediaSize" => 100111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081564/thumbnail-0beb6b14d6490d58c96c66b1c9d845d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849396"
"ResourceRecordKey" => "30081564"
"ModificationTimestamp" => "2026-07-27T14:30:13.39Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30081564_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081564/9cf3d3f0680a4b99439fec9597481266.webp"
"MediaSize" => 94093
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081564/thumbnail-9cf3d3f0680a4b99439fec9597481266.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849396"
"ResourceRecordKey" => "30081564"
"ModificationTimestamp" => "2026-07-27T14:30:13.39Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30081564_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081564/7fc3555b1adcda872c335a70166d627f.webp"
"MediaSize" => 90887
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081564/thumbnail-7fc3555b1adcda872c335a70166d627f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849396"
"ResourceRecordKey" => "30081564"
"ModificationTimestamp" => "2026-07-27T14:30:13.39Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30081564_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081564/a2fdf66270b84c819643defc489de1de.webp"
"MediaSize" => 89581
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081564/thumbnail-a2fdf66270b84c819643defc489de1de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849396"
"ResourceRecordKey" => "30081564"
"ModificationTimestamp" => "2026-07-27T14:30:13.39Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30081564_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081564/17036bd52dcd0e17819d88bd1a28c82c.webp"
"MediaSize" => 82611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081564/thumbnail-17036bd52dcd0e17819d88bd1a28c82c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849396"
"ResourceRecordKey" => "30081564"
"ModificationTimestamp" => "2026-07-27T14:30:13.39Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30081564_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081564/7a37523f45bffb30582b23104ffadfc5.webp"
"MediaSize" => 104208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081564/thumbnail-7a37523f45bffb30582b23104ffadfc5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849396"
"ResourceRecordKey" => "30081564"
"ModificationTimestamp" => "2026-07-27T14:30:13.39Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30081564_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081564/68ce4f74e3dd7a4def8575c754743129.webp"
"MediaSize" => 74530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081564/thumbnail-68ce4f74e3dd7a4def8575c754743129.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849396"
"ResourceRecordKey" => "30081564"
"ModificationTimestamp" => "2026-07-27T14:30:13.39Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30081564_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081564/8100161e936e7e8c001011199ad156a0.webp"
"MediaSize" => 72790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081564/thumbnail-8100161e936e7e8c001011199ad156a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849396"
"ResourceRecordKey" => "30081564"
"ModificationTimestamp" => "2026-07-27T14:30:13.39Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30081564_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081564/924e7cf3246579148f91f134d33b84ad.webp"
"MediaSize" => 82031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081564/thumbnail-924e7cf3246579148f91f134d33b84ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849396"
"ResourceRecordKey" => "30081564"
"ModificationTimestamp" => "2026-07-27T14:30:13.39Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30081564_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081564/a92c7a34bb2d2ccecb90602363ad08ad.webp"
"MediaSize" => 80080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081564/thumbnail-a92c7a34bb2d2ccecb90602363ad08ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849396"
"ResourceRecordKey" => "30081564"
"ModificationTimestamp" => "2026-07-27T14:30:13.39Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30081564_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081564/122e7147696fbf51f6e64df447e3ebf8.webp"
"MediaSize" => 63286
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081564/thumbnail-122e7147696fbf51f6e64df447e3ebf8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849396"
"ResourceRecordKey" => "30081564"
"ModificationTimestamp" => "2026-07-27T14:30:13.39Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30081564_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081564/45c08090fd1fbadb9e8a08021e2236f5.webp"
"MediaSize" => 168538
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081564/thumbnail-45c08090fd1fbadb9e8a08021e2236f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849396"
"ResourceRecordKey" => "30081564"
"ModificationTimestamp" => "2026-07-27T14:30:13.39Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30081564_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081564/9a07b33bca8b19730bd80b6c6c893eb7.webp"
"MediaSize" => 210353
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081564/thumbnail-9a07b33bca8b19730bd80b6c6c893eb7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849396"
"ResourceRecordKey" => "30081564"
"ModificationTimestamp" => "2026-07-27T14:30:13.39Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30081564_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081564/e68c4f799c1a82272b1fe54db446a186.webp"
"MediaSize" => 216066
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081564/thumbnail-e68c4f799c1a82272b1fe54db446a186.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849396"
"ResourceRecordKey" => "30081564"
"ModificationTimestamp" => "2026-07-27T14:30:13.39Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30081564')"
+"ID": "1661588"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 156288" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25048
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24991
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX REAL ESTATE CENTRE INC., BROKERAGE"
+"OfficeEmail": null
+"OfficePhone": "519-623-6200"
+"OfficeMlsId": "CA558"
+"ModificationTimestamp": "2026-03-24T17:19:43Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "156288"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "766 OLD HESPELER RD"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "CAMBRIDGE"
+"OfficePostalCode": "N3H5L"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1112493"
+"OriginalEntryTimestamp": "2008-03-03T22:46:00Z"
+"OfficeFax": "519-623-3541"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1066257"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('156288')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1750163" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25071
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30081564'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25356
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30081564' AND OpenHouseDate ge '2026-07-26'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25372
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30081564' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5342011 43.4766498)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25425
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25419
+post_id: "1662364"
+post_author: 1
+"ListingKey": "30083272"
+"ListingId": "40850992"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-27T18:45:02Z"
+"RFModificationTimestamp": "2026-07-27T19:48:42Z"
+"ListPrice": 409900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 490.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K7"
+"UnparsedAddress": "145 COLUMBIA Street W Unit# 131, Waterloo, Ontario N2L0K7"
+"Coordinates": array:2 [
0 => -80.5381063
1 => 43.4764261
]
+"Latitude": 43.4764261
+"Longitude": -80.5381063
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Society145, one of Waterloo's premier luxury condominium communities! This stunning 1 bedroom suite offers a rare private walkout entrance, soaring 14 ft ceilings, and a bright, open concept layout that creates an exceptional sense of space. Enjoy modern finishes throughout and the convenience of ground floor l iving with direct outdoor access. Residents of Society145 have access to outstanding amenities, including a fully equipped fitness centre, indoor baseketball court, saunas, games room, movie theatre, concierge service, study lounges, and social spaces. Ideally located just steps from the University of Waterloo and Wilfrid Laurier University, with easy access to restaurants, shopping, transit, parks, and all the conveniences of Waterloo. Whether you're a student, young professional, or investor, this is an incredible opportunity to own in one of Waterloo's most sought after new developments. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "283.06"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-27T19:48:35.594599+00:00"
+"Directions": "Columbia and Phillip"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2078123"
+"ListOfficeKey": "283397"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-07-27T18:38:21Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-27T18:38:21Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "COLUMBIA"
+"StreetNumber": "145"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3136"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1694807335"
"RoomType" => "3pc Bathroom"
"ListingId" => "40850992"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30083272"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T18:38:21.63Z"
]
1 => array:11 [
"RoomKey" => "1694807336"
"RoomType" => "Bedroom"
"ListingId" => "40850992"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30083272"
"RoomLength" => null
"RoomDimensions" => "8'5'' x 9'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T18:38:21.63Z"
]
2 => array:11 [
"RoomKey" => "1694807337"
"RoomType" => "Living room"
"ListingId" => "40850992"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30083272"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 8'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T18:38:21.63Z"
]
3 => array:11 [
"RoomKey" => "1694807338"
"RoomType" => "Eat in kitchen"
"ListingId" => "40850992"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30083272"
"RoomLength" => null
"RoomDimensions" => "15'1'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T18:38:21.63Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30083272/145-columbia-street-w-unit-131-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RN-25"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 490
+"OriginalEntryTimestamp": "2026-07-27T18:38:21.61Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1352953"
+"ListOfficeNationalAssociationId": "1328541"
+"Media": array:34 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30083272_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/144e745bf0dca134cee67189091dac45.webp"
"MediaSize" => 119641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-144e745bf0dca134cee67189091dac45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30083272_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/7f51839c087e413889d9fc13288d236e.webp"
"MediaSize" => 124318
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-7f51839c087e413889d9fc13288d236e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30083272_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/34dce1800889aa530400bdbdfb326517.webp"
"MediaSize" => 120177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-34dce1800889aa530400bdbdfb326517.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30083272_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/6ba680fecc7f9337a9c49e56c75c2de8.webp"
"MediaSize" => 75405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-6ba680fecc7f9337a9c49e56c75c2de8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30083272_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/d9fe67cd0122698e5bcc9ce9c877ec49.webp"
"MediaSize" => 90259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-d9fe67cd0122698e5bcc9ce9c877ec49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30083272_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/298aa5073208d5b59514ccfe08af4d79.webp"
"MediaSize" => 88030
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-298aa5073208d5b59514ccfe08af4d79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30083272_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/ce62723b41476e8a8e9240c217b32094.webp"
"MediaSize" => 86034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-ce62723b41476e8a8e9240c217b32094.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30083272_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/6b32691b4685a9f5127e22b9721bf5cc.webp"
"MediaSize" => 97297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-6b32691b4685a9f5127e22b9721bf5cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30083272_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/295994014a5599a6ccda3bdd84b33a9e.webp"
"MediaSize" => 92656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-295994014a5599a6ccda3bdd84b33a9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30083272_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/8fa46b373114db64e21e64f89508203a.webp"
"MediaSize" => 88123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-8fa46b373114db64e21e64f89508203a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30083272_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/de9769a48928d5f0c9ade88591e0dd7b.webp"
"MediaSize" => 88442
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-de9769a48928d5f0c9ade88591e0dd7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30083272_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/5a0c5c0d9be2425d011bca1c9cc4e73c.webp"
"MediaSize" => 88919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-5a0c5c0d9be2425d011bca1c9cc4e73c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30083272_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/1937db31fe5f2397c29174c3982db739.webp"
"MediaSize" => 92610
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-1937db31fe5f2397c29174c3982db739.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30083272_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/8fbe0445e5dd328f837e83d9913594b6.webp"
"MediaSize" => 83468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-8fbe0445e5dd328f837e83d9913594b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30083272_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/3d305a02666a1c225ae3e6098188d87d.webp"
"MediaSize" => 76679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-3d305a02666a1c225ae3e6098188d87d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30083272_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/1f255de72431add6b1904c8a71720170.webp"
"MediaSize" => 82146
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-1f255de72431add6b1904c8a71720170.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30083272_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/ab87b3050321c2d831e4fc853154a411.webp"
"MediaSize" => 79189
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-ab87b3050321c2d831e4fc853154a411.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30083272_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/2b3942eb342a14a31630db1871907779.webp"
"MediaSize" => 78868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-2b3942eb342a14a31630db1871907779.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30083272_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/56331c6a8af8bb9e48008f67e74e5820.webp"
"MediaSize" => 69262
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-56331c6a8af8bb9e48008f67e74e5820.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30083272_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/d304bd7b993375fb6ad68d9576bd3f1f.webp"
"MediaSize" => 57728
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-d304bd7b993375fb6ad68d9576bd3f1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30083272_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/0b929fdd90e60ad7aa0336d27191705e.webp"
"MediaSize" => 48722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-0b929fdd90e60ad7aa0336d27191705e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30083272_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/603987729fc81500633c4570027ecbf9.webp"
"MediaSize" => 38836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-603987729fc81500633c4570027ecbf9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30083272_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/132c2d41b063a7d464ff4ad79033732b.webp"
"MediaSize" => 37148
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-132c2d41b063a7d464ff4ad79033732b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30083272_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/3a8a670d89f9890a291c563431339a2f.webp"
"MediaSize" => 84507
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-3a8a670d89f9890a291c563431339a2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30083272_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/94b614af5bf5dff2642edb058691618c.webp"
"MediaSize" => 63081
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-94b614af5bf5dff2642edb058691618c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30083272_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/9d79021327df4f1cca066ce5589b722e.webp"
"MediaSize" => 60808
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-9d79021327df4f1cca066ce5589b722e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30083272_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/649b4e64c7c6915d60e02ac77de81aad.webp"
"MediaSize" => 144730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-649b4e64c7c6915d60e02ac77de81aad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30083272_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/00a592dfe49e25e4445fd961918347a5.webp"
"MediaSize" => 124971
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-00a592dfe49e25e4445fd961918347a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30083272_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/7e3ba330d6640c8287ebaf189fa38214.webp"
"MediaSize" => 93460
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-7e3ba330d6640c8287ebaf189fa38214.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30083272_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/e0d420cd6965beeb4b0c65ff175eeecb.webp"
"MediaSize" => 89958
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-e0d420cd6965beeb4b0c65ff175eeecb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30083272_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/f243d5cee37ef345009f16e839583379.webp"
"MediaSize" => 89081
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-f243d5cee37ef345009f16e839583379.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30083272_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/c24b80e64831e1afce56faa4d4f76fdc.webp"
"MediaSize" => 89273
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-c24b80e64831e1afce56faa4d4f76fdc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30083272_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/3b60dcfc998c79e36f965371b2c4af34.webp"
"MediaSize" => 86310
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-3b60dcfc998c79e36f965371b2c4af34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30083272_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30083272/e38e683aad962130d91e77660dabd367.webp"
"MediaSize" => 58303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30083272/thumbnail-e38e683aad962130d91e77660dabd367.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850992"
"ResourceRecordKey" => "30083272"
"ModificationTimestamp" => "2026-07-27T18:38:21.61Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30083272')"
+"ID": "1662364"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25421
+post_id: "1661082"
+post_author: 1
+"ListingKey": "30081330"
+"ListingId": "40850825"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-27T18:10:11Z"
+"RFModificationTimestamp": "2026-07-27T18:24:43Z"
+"ListPrice": 435999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 668.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E5"
+"UnparsedAddress": "158 KING Street N Unit# 2101, Waterloo, Ontario N2J2Y2"
+"Coordinates": array:2 [
0 => -80.5237304
1 => 43.4717316
]
+"Latitude": 43.4717316
+"Longitude": -80.5237304
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Sunlight, space, and an unbeatable Uptown Waterloo location! This bright fully furnished 2-bedroom, 2-bathroom condo features a spacious living area, in-suite laundry, and an oversized garage parking space. Walk to Uptown Waterloo, the University of Waterloo, Wilfrid Laurier University, shopping, restaurants, and the ION LRT. Enjoy fantastic building amenities including an exercise room, theatre room, and meeting room. A perfect opportunity for professionals, downsizers, students, or investors alike. All furniture included (except for bed/mattress in spare room). (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "483.99"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-27T14:01:24.642677+00:00"
+"Directions": "King St. N and Noecker St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2084847"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-07-27T18:03:26Z"
+"PhotosCount": 14
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-27T18:03:26Z"
+"Stories": "1.0"
+"StreetDirSuffix": "North"
+"StreetName": "KING"
+"StreetNumber": "158"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3566.33"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1694693354"
"RoomType" => "4pc Bathroom"
"ListingId" => "40850825"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30081330"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T16:38:32.99Z"
]
1 => array:11 [
"RoomKey" => "1694693355"
"RoomType" => "Bedroom"
"ListingId" => "40850825"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30081330"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T16:38:32.99Z"
]
2 => array:11 [
"RoomKey" => "1694693356"
"RoomType" => "3pc Bathroom"
"ListingId" => "40850825"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30081330"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T16:38:32.99Z"
]
3 => array:11 [
"RoomKey" => "1694693357"
"RoomType" => "Primary Bedroom"
"ListingId" => "40850825"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30081330"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T16:38:32.99Z"
]
4 => array:11 [
"RoomKey" => "1694693358"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "40850825"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30081330"
"RoomLength" => null
"RoomDimensions" => "18'4'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-27T16:38:32.99Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30081330/158-king-street-n-unit-2101-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 668
+"OriginalEntryTimestamp": "2026-07-27T13:38:45.12Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1358257"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:14 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30081330_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081330/1bc01bba48a0039cc5ee2b9d8b6771f6.webp"
"MediaSize" => 124227
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081330/thumbnail-1bc01bba48a0039cc5ee2b9d8b6771f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40850825"
"ResourceRecordKey" => "30081330"
"ModificationTimestamp" => "2026-07-27T13:52:27.57Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30081330_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30081330/c2cba24f804a689fc26a6793433f44c4.webp"
"MediaSize" => 68328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30081330/thumbnail-c2cba24f804a689fc26a6793433f44c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
…4
]
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('30081330')"
+"ID": "1661082"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25418
+post_id: "1661059"
+post_author: 1
+"ListingKey": "30081240"
+"ListingId": "40849431"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-27T13:15:07Z"
+"RFModificationTimestamp": "2026-07-27T13:36:25Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.334
+"LivingArea": 2205.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3X6"
+"UnparsedAddress": "291 VILLA Place, Waterloo, Ontario N2J3X6"
+"Coordinates": array:2 [
0 => -80.5152523
1 => 43.4831403
]
+"Latitude": 43.4831403
+"Longitude": -80.5152523
+"YearBuilt": 1965
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled on a quiet, family-friendly cul-de-sac in one of Waterloo's most desirable neighbourhoods, this raised bungalow sits on an exceptionally rare 1/3-acre lot backing directly onto the Hillside Trail and Waterloo's extensive trail network. Offering privacy, space, and an incredible connection to nature, this is the kind of property where memories are made for generations. Step outside and discover a backyard oasis unlike anything else. Surrounded by mature landscaping, the expansive yard features a large covered deck, gazebo, in-ground pool with updated liner, pump and filter, and endless space for children to play, family gatherings, and summer entertaining. Whether you're hosting friends poolside or enjoying a quiet evening overlooking the greenspace, this outdoor retreat is truly an entertainer's dream. Inside, the bright main floor offers an open-concept kitchen and dining area with stone countertops, white cabinetry, centre island, JennAir gas range, Bosch dishwasher, glass tile backsplash, and engineered hardwood flooring. The welcoming living room features a wood-burning fireplace and walkout access to the front deck. Three bedrooms and an updated four-piece bathroom complete the main level. The finished walk-up lower level provides exceptional additional living space, including a spacious recreation room with natural gas fireplace and built-in cabinetry, a large games room with bar area, a cedar closet, three-piece bathroom, and laundry room. Additional updates include vinyl windows, ront door (2019), vinyl siding and eavestroughs (2018), roof (2018), and a rebuilt chimney (2026). The tandem garage accommodates two small vehicles and offers excellent storage. Properties offering this level of privacy, outdoor living, and direct access to nature are exceptionally rare in Waterloo. Don't miss your chance to secure a truly one-of-a-kind property in a location you'll treasure for years to come. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-27T13:36:17.367494+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564224"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.334"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-27T13:08:25Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-27T13:08:25Z"
+"Stories": "1.0"
+"StreetName": "VILLA"
+"StreetNumber": "291"
+"StreetSuffix": "Place"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "6029.81"
+"VirtualTourURLUnbranded": "https://youriguide.com/291_villa_place_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30081240/291-villa-place-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1976233"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283125"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 67.0
+"AboveGradeFinishedArea": 1180
+"BelowGradeFinishedArea": 1025
+"OriginalEntryTimestamp": "2026-07-27T13:08:25.87Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1102433"
+"ListOfficeNationalAssociationId": "1378680"
+"CoListAgentNationalAssociationId": "1262688"
+"CoListOfficeNationalAssociationId": "1324759"
+"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('30081240')"
+"ID": "1661059"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25422
+post_id: "1659904"
+post_author: 1
+"ListingKey": "30079766"
+"ListingId": "40851140"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-25T23:35:16Z"
+"RFModificationTimestamp": "2026-07-25T23:39:13Z"
+"ListPrice": 489000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 612.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3W5"
+"UnparsedAddress": "246 LESTER Street Unit# 1107, Waterloo, Ontario N2L3W5"
+"Coordinates": array:2 [
0 => -80.5342054
1 => 43.4735405
]
+"Latitude": 43.4735405
+"Longitude": -80.5342054
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Prime Waterloo Location — Steps to UW & WLU. An opportunity you simply don’t want to miss! This exceptionally well-maintained 1+1 bedroom, 2-bathroom condooffers a spacious den with large windows that can easily be used as a second bedroom, home office, or study space.Enjoy breathtaking views and abundant natural sunlight from the balcony. Featuring approximately 9-foot ceilings, an open-concept layout, and a modern kitchen, this home is ideal for students, young professionals, or investors. PROPERTY HIGHLIGHTS: 1 Bedroom + Spacious Den;2 Full Bathrooms;Den with Large Windows — Perfect for a Second Bedroom;Fully Furnished;Approximately 9-Foot Ceilings;Open-Concept Living & Dining Area; Private Balcony with Beautiful Views & Plenty of sunshine ; In-Suite Laundry; MODERN KITCHEN;Open-concept design;Modern cabinetry;Quartz countertops;Stainless steel appliances. BUILDING AMENITIES: Party Room;Rooftop Terrace; Study Room;Exercise Room;Visitor Parking; Security System in Common Areas UNBEATABLE LOCATION: 5-minute walk to the University of Waterloo;Steps to Wilfrid Laurier University;Close to Plaza & Supermarket;Surrounded by Restaurants, Shops & Daily Amenities; Convenient Public Transit Access A PERFECT OPPORTUNITY FOR STUDENTS, PROFESSIONALS & INVESTORS! Don’t miss your chance to own or rent this exceptional unit in one of Waterloo’s most desirable locations! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "363.32"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "High Traffic Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-25T22:47:38.794246+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2162407"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-07-25T23:20:25Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-25T23:28:23Z"
+"Stories": "12.0"
+"StreetName": "LESTER"
+"StreetNumber": "246"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2706.98"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30079766/246-lester-street-unit-1107-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "NMU12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 612
+"OriginalEntryTimestamp": "2026-07-25T19:28:39.96Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1413428"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:40 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30079766')"
+"ID": "1659904"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25420
+post_id: "1659878"
+post_author: 1
+"ListingKey": "30079841"
+"ListingId": "40839997"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-25T20:20:10Z"
+"RFModificationTimestamp": "2026-07-25T22:42:55Z"
+"ListPrice": 272500.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1205.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5G6"
+"UnparsedAddress": "65 WESTMOUNT Road N Unit# 304, Waterloo, Ontario N2L5G6"
+"Coordinates": array:2 [
0 => -80.5394699
1 => 43.4616849
]
+"Latitude": 43.4616849
+"Longitude": -80.5394699
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Westmount Towers II-Here is your opporunity to own a bright and spacious 2 bedroom condo unit in an ideal location and at an exceptional value! Located in one of Waterloo's most desirable areas within walking distance to University's, Uptown Waterloo, numerous shops and restaurants, Waterloo Park and so much more. This unit offers low maintenance, care free living with your condo fees including ALL utilities. Unit 304 is a bright and spacious 2 bedroom, 2 bathroom unit and includes an underground parking space and storgage locker. The kitchen includes newer stainless steel appliances. The large primary bedroom includes a spacious walk in closet and a 2-piece ensuite bath. Here is your chance to get into affordable home ownership in the heart of Waterloo. (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Hood Fan"
]
+"AssociationFee": "1090"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:9 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Heat"
4 => "Electricity"
5 => "Water"
6 => "Insurance"
7 => "Parking"
8 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-07-25T22:42:43.043324+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Hot water radiator heat"
1 => "Baseboard heaters"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1935309"
+"ListOfficeKey": "292076"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Laundry- Coin operated"
2 => "No Pet Home"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-25T20:11:28Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-25T20:11:28Z"
+"Stories": "9.0"
+"StreetDirSuffix": "North"
+"StreetName": "WESTMOUNT"
+"StreetNumber": "65"
+"StreetSuffix": "Road"
+"SubdivisionName": "417 - Beechwood/University"
+"VirtualTourURLUnbranded": "https://youriguide.com/65_westmount_rd_n_304_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30079841/65-westmount-road-n-unit-304-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1904174"
+"CoListOfficeKey": "292076"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 500.0
+"AboveGradeFinishedArea": 1205
+"OriginalEntryTimestamp": "2026-07-25T20:10:13.31Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1234734"
+"ListOfficeNationalAssociationId": "1408082"
+"CoListAgentNationalAssociationId": "1219174"
+"CoListOfficeNationalAssociationId": "1408082"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30079841')"
+"ID": "1659878"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25415
+post_id: "1658885"
+post_author: 1
+"ListingKey": "30009471"
+"ListingId": "X13541492"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-12T16:30:03Z"
+"RFModificationTimestamp": "2026-07-25T07:29:27Z"
+"ListPrice": 274900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0G4"
+"UnparsedAddress": "501 - 321 SPRUCE STREET, Waterloo, Ontario N2L0G4"
+"Coordinates": array:2 [
0 => -80.52726
1 => 43.479262
]
+"Latitude": 43.479262
+"Longitude": -80.52726
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "London and St. Thomas Association of REALTORS®"
+"PublicRemarks": "Experience luxury and convenience in this bright 1+1 bedroom condo in the heart of Waterloo, just steps from University of Waterloo, Wilfrid Laurier University, and Conestoga College. Featuring high-end finishes, stainless steel appliances, quartz countertops, and floor-to-ceiling windows, this fully furnished unit offers a spacious den that can serve as a second bedroom or office, in-suite laundry, and included high-speed internet and weekly housekeeping. Residents enjoy concierge service, an exercise/recreation room, a rooftop patio, and guest suites in this well-maintained, modern building. Immediate occupancy is available book your viewing today! (id:62650)"
+"AssociationFee": "739.57"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-25T07:29:21.909464+00:00"
+"Directions": "Cross Streets: King and University. ** Directions: From Columbia St W turn onto Spruce St."
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100467"
+"ListOfficeKey": "302124"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T04:50:41Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-12T16:20:32Z"
+"StreetName": "Spruce"
+"StreetNumber": "321"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3452"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "London and St. Thomas"
+"ListAORKey": "13"
+"ListingURL": "www.realtor.ca/real-estate/30009471/501-321-spruce-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Condo Board Self Manage"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-07-09T04:50:40.98Z"
+"ListAgentNationalAssociationId": "1370499"
+"ListOfficeNationalAssociationId": "1498650"
+"Media": array:13 [
0 => array:13 [ …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]
]
+"DaysOnMarket": 18
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30009471')"
+"ID": "1658885"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23598
+post_id: "1658650"
+post_author: 1
+"ListingKey": "30078824"
+"ListingId": "40851077"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-27T14:40:19Z"
+"RFModificationTimestamp": "2026-07-27T14:51:50Z"
+"ListPrice": 629900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1536.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5E1"
+"UnparsedAddress": "506 LONELM Court Unit# A, Waterloo, Ontario N2L5E1"
+"Coordinates": array:2 [
0 => -80.5441273
1 => 43.4915382
]
+"Latitude": 43.4915382
+"Longitude": -80.5441273
+"YearBuilt": 1973
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This rare, newly renovated, and well-maintained LINK home offers unmatched privacy on a peaceful cul-de-sac. With 1,536 sq ft of finished living space, this flexible layout can accommodate up to 5 bedrooms. With no shared walls in the primary living areas and a completely detached second floor, it looks almost like a detached home from the outside. The entire home is carpet-free, with waterproof vinyl flooring, modern baseboards, and matching staircases (all 2026). It also features new LED lighting and premium SW paint throughout (all 2026). The fully updated kitchen showcases new cabinets, countertops, a stylish sink and faucet, and a built-in pantry (all 2026). Three upgraded washrooms, one on each floor, offer new vanities, flooring, and faucets (all 2026). The home also includes smart thermostats and a heat pump (2023) that can both heat and cool. A separate back entrance leads to the professionally finished lower level, featuring higher-than-average ceilings, bright egress windows, and a versatile 27-foot space ideal as a family rec room, movie theatre, or an oversized 5th bedroom. Exterior updates include a freshly painted private deck and front siding (2026). The extended carport is extremely useful as a shelter from snow, rain, and sun. The newly sealed 53-foot driveway provides parking for up to 3 cars (2026). Nestled in a mature and established community, this home is perfectly situated between the universities and Waterloo's business sector. Both UW and WLU are just 3–5 minutes by direct bus or a short bike trip away while surrounded by trails, parks, and local schools. It is also close to Conestoga Mall, St. Jacobs Market, and the Albert McCormick CC, with seamless commuter access to the LRT, major bus routes (9, 19, 91), and Hwy 85. Beautifully updated and move-in ready, this property is an ideal home for growing families and an impressive opportunity for savvy investors. Schedule your showing today! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-25T04:39:23.562790+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2251406"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-07-27T14:32:57Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-27T14:32:57Z"
+"Stories": "2.0"
+"StreetName": "LONELM"
+"StreetNumber": "506"
+"StreetSuffix": "Court"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "3895.75"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30078824/506-lonelm-court-unit-a-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 29.0
+"AboveGradeFinishedArea": 1072
+"BelowGradeFinishedArea": 464
+"OriginalEntryTimestamp": "2026-07-25T03:08:24.07Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1490334"
+"ListOfficeNationalAssociationId": "1004387"
+"Media": array:31 [
0 => array:13 [ …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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30078824')"
+"ID": "1658650"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25423
+post_id: "1658495"
+post_author: 1
+"ListingKey": "30078622"
+"ListingId": "40851073"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-25T00:45:05Z"
+"RFModificationTimestamp": "2026-07-25T01:37:15Z"
+"ListPrice": 749000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2088.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3K7"
+"UnparsedAddress": "223 CARTER Avenue, Waterloo, Ontario N2J3K7"
+"Coordinates": array:2 [
0 => -80.5143402
1 => 43.4790371
]
+"Latitude": 43.4790371
+"Longitude": -80.5143402
+"YearBuilt": 1966
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover Mid-Century Charm Re-imagined with Modern Luxury. Perfectly positioned and completely transformed, this 4-bedroom, 2-bathroom residence offers an unparalleled turnkey lifestyle. From the curb this home commands immediate attention with the poured concrete walkway, immaculate lawn, and a striking front porch overhang featuring a warm cedar ceiling—a prelude to the architectural details within. Step inside to an open-concept living space unified by rich engineered hardwood flooring and a spectacular custom cedar ceiling that radiates organic warmth. The heart of the home is the bespoke chef’s kitchen, thoughtfully designed with custom Eucalyptus green cabinetry, a sprawling island, quartz counter-tops, airy exposed shelving, and an integrated hideaway bar cabinet to elevate your hosting game. Down the hall, the main bath has been re-imagined into a spa-like oasis, boasting custom cabinetry, quartz counters, refined gold trim, heated flooring, and a heated towel rack. The finished lower level maximizes both utility and leisure. Gather for movie nights anchored by a sleek gas fireplace, or entertain at the custom bar with seating. This versatile level also hosts a spacious fourth bedroom—that could double as a home gym or office—a beautifully appointed 3-piece bathroom, and a streamlined laundry and large storage area. The sophistication extends into a private backyard sanctuary. Designed for effortless enjoyment, the yard features a custom-poured concrete patio accented with detailed architectural ledges and finishes. Surrounded by professional, low-maintenance landscaping, it is the ultimate setting for alfresco dining. A premium steel storage shed completes the outdoor space. Situated in a highly desirable, family-friendly Waterloo neighbourhood, this home is moments from top-tier schools and parks. Every detail of 223 Carter Avenue has been meticulously executed, offering a rare blend of custom craftsmanship and move-in-ready living. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-25T01:37:05.447430+00:00"
+"Directions": "Lincoln Rd, to Marshall, to Carter Ave."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "In Floor Heating"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1953837"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Crushed stone driveway"
]
+"PhotosChangeTimestamp": "2026-07-25T00:38:09Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-25T00:38:09Z"
+"Stories": "1.0"
+"StreetName": "CARTER"
+"StreetNumber": "223"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "4081.94"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/223-carter-ave"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30078622/223-carter-avenue-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1050
+"BelowGradeFinishedArea": 1038
+"OriginalEntryTimestamp": "2026-07-25T00:38:09.75Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1247007"
+"ListOfficeNationalAssociationId": "1473831"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30078622')"
+"ID": "1658495"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25424
+post_id: "1657897"
+post_author: 1
+"ListingKey": "29750999"
+"ListingId": "X13126502"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T03:15:02Z"
+"RFModificationTimestamp": "2026-07-24T23:02:12Z"
+"ListPrice": 365000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3V9"
+"UnparsedAddress": "1103 - 258A SUNVIEW STREET, Waterloo, Ontario N2L3V9"
+"Coordinates": array:2 [
0 => -80.532991
1 => 43.474108
]
+"Latitude": 43.474108
+"Longitude": -80.532991
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright & Spacious Sun-Filled Corner Unit Offering Stunning Views And Fully Furnished Convenience. Ideally Located In The Highly Sought-After Waterloo School District, Just Steps From The University of Waterloo, Wilfrid Laurier University, Conestoga College, And The Thriving Tech Hub. An Excellent Opportunity For First-Time Home Buyers, Investors, Or Students Seeking A Prime Central Location. This Well-Appointed Unit Features Two Spacious Bedrooms, A Full Bathroom, And An Open-Concept Living Area Filled With Natural Light. Enjoy A Modern Eat-In Kitchen Complete With Stainless Steel Appliances, Stylish Countertops, And Ample Cabinetry. Includes Ensuite Laundry And Wireless Internet For Added Convenience. Minutes To Major Highways With Easy Access To ION/LRT/GO Transit, Restaurants, Shopping, And Everyday Amenities. A Must See Property Offering Exceptional Value And Location. Don't Miss This Opportunity. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "343.07"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T23:02:08.721530+00:00"
+"Directions": "Cross Streets: University Ave & Sunview St. ** Directions: University ave w and hemlock st."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1803950"
+"ListOfficeKey": "283484"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-05-14T14:18:09Z"
+"PhotosCount": 7
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T03:07:45Z"
+"StreetName": "SUNVIEW"
+"StreetNumber": "258A"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3192"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29750999/1103-258a-sunview-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1499050"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "WA"
+"CoListOfficeKey": "283484"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"ZoningDescription": "NMU-12"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-05-14T14:18:09.47Z"
+"ListAgentNationalAssociationId": "1191010"
+"ListOfficeNationalAssociationId": "1330562"
+"CoListAgentNationalAssociationId": "1134677"
+"CoListOfficeNationalAssociationId": "1330562"
+"Media": array:7 [
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]
]
+"DaysOnMarket": 74
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29750999')"
+"ID": "1657897"
}
]
+success: true
+page_size: 9
+page_count: 36
+count: 318
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]