array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30075412 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: "1655998"
+post_author: 1
+"ListingKey": "30075412"
+"ListingId": "X13602180"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T15:50:06Z"
+"RFModificationTimestamp": "2026-07-24T16:46:27Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3E5"
+"UnparsedAddress": "34 MOORE AVENUE N, Waterloo, Ontario N2J3E5"
+"Coordinates": array:2 [
0 => -80.515934
1 => 43.467934
]
+"Latitude": 43.467934
+"Longitude": -80.515934
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A rare offering in a prime Uptown Waterloo location, 34 Moore Ave N blends timeless character with a brand-new, top-to-bottom transformation. Completely flipped by the new owners, this home now feels like a contemporary showpiece-everything updated and finished with premium details, plus all-new stainless steel appliances. Step inside to find hardwood flooring throughout, complemented by beautifully renovated living spaces designed for modern comfort. The inviting foyer flows into a bright living room with an elegant layout and large windows, while the dining area connects seamlessly to a fully updated kitchen featuring sleek finishes, abundant counter space, and brand-new stainless steel appliances. At the rear of the home, enjoy a spacious family room perfect for relaxing or entertaining, with space to suit every lifestyle. Upstairs, the primary bedroom has been thoughtfully redesigned with a walk-in closet and a luxury ensuite, creating a private retreat. Two additional well-sized bedrooms offer flexible space for family, guests, or work-from-home needs, and a fourth room-ideal as an office or easily converted back to bedroom use-adds even more versatility. A renovated additional full bath completes the upper level. The basement provides a comfortable rec space along with practical storage and laundry areas. Outside, enjoy a fully upgraded, move-in-ready home on a large lot with outdoor space made for entertaining and everyday enjoyment. With its Uptown Waterloo address just steps to parks, transit, schools, trails, cafés, and shops, while still keeping quick access to the highway and nearby universities, 34 Moore Ave N is truly one of a kind-a stunning home you can enjoy from day one. (id:62650)"
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T16:46:12.884349+00:00"
+"Directions": "Cross Streets: Bridgeport Road East. ** Directions: Bridgeport to Erb."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2213356"
+"ListOfficeKey": "296481"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "44 x 154.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T15:41:05Z"
+"PhotosCount": 29
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T15:41:05Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "Moore"
+"StreetNumber": "34"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "5233"
+"VirtualTourURLUnbranded": "https://youtube.com/watch?v=_nKm4mt_DQw"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1692466710"
"RoomType" => "Dining room"
"ListingId" => "X13602180"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.74
"ListingKey" => "30075412"
"RoomLength" => 4.17
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T15:41:05.13Z"
]
1 => array:11 [
"RoomKey" => "1692466711"
"RoomType" => "Kitchen"
"ListingId" => "X13602180"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.45
"ListingKey" => "30075412"
"RoomLength" => 4.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T15:41:05.13Z"
]
2 => array:11 [
"RoomKey" => "1692466712"
"RoomType" => "Living room"
"ListingId" => "X13602180"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.45
"ListingKey" => "30075412"
"RoomLength" => 7.06
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T15:41:05.13Z"
]
3 => array:11 [
"RoomKey" => "1692466713"
"RoomType" => "Bathroom"
"ListingId" => "X13602180"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.0
"ListingKey" => "30075412"
"RoomLength" => 2.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T15:41:05.13Z"
]
4 => array:11 [
"RoomKey" => "1692466714"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13602180"
"RoomLevel" => "Second level"
"RoomWidth" => 4.02
"ListingKey" => "30075412"
"RoomLength" => 3.12
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T15:41:05.13Z"
]
5 => array:11 [
"RoomKey" => "1692466715"
"RoomType" => "Bathroom"
"ListingId" => "X13602180"
"RoomLevel" => "Second level"
"RoomWidth" => 4.0
"ListingKey" => "30075412"
"RoomLength" => 3.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T15:41:05.13Z"
]
6 => array:11 [
"RoomKey" => "1692466716"
"RoomType" => "Bedroom"
"ListingId" => "X13602180"
"RoomLevel" => "Second level"
"RoomWidth" => 3.3
"ListingKey" => "30075412"
"RoomLength" => 2.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T15:41:05.13Z"
]
7 => array:11 [
"RoomKey" => "1692466717"
"RoomType" => "Bedroom"
"ListingId" => "X13602180"
"RoomLevel" => "Second level"
"RoomWidth" => 2.79
"ListingKey" => "30075412"
"RoomLength" => 3.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T15:41:05.13Z"
]
8 => array:11 [
"RoomKey" => "1692466718"
"RoomType" => "Bathroom"
"ListingId" => "X13602180"
"RoomLevel" => "Second level"
"RoomWidth" => 2.5
"ListingKey" => "30075412"
"RoomLength" => 2.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T15:41:05.13Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30075412/34-moore-avenue-n-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 44.0
+"OriginalEntryTimestamp": "2026-07-24T15:41:05.11Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1459149"
+"ListOfficeNationalAssociationId": "1470796"
+"Media": array:29 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30075412_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/b7ed8e32a906b826526289401048e5f0.webp"
"MediaSize" => 314864
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-b7ed8e32a906b826526289401048e5f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30075412_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/253b286bb71d3630c4feb36bacae1953.webp"
"MediaSize" => 94916
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-253b286bb71d3630c4feb36bacae1953.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30075412_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/1b8568ef40a9307c7d076080ef5a3c5d.webp"
"MediaSize" => 134385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-1b8568ef40a9307c7d076080ef5a3c5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30075412_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/d2c2688c4a0c1ae36c96fbcd0334211e.webp"
"MediaSize" => 123089
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-d2c2688c4a0c1ae36c96fbcd0334211e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30075412_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/6aa9a9476e69e57a07dadf52c2a0b4b5.webp"
"MediaSize" => 73786
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-6aa9a9476e69e57a07dadf52c2a0b4b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30075412_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/09f02dee000b3babf59c898437707088.webp"
"MediaSize" => 114793
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-09f02dee000b3babf59c898437707088.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30075412_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/9fb5b962904a1359705b34f5f7f3e827.webp"
"MediaSize" => 125710
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-9fb5b962904a1359705b34f5f7f3e827.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30075412_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/5f66946103ba05846cdbddcfdd67d027.webp"
"MediaSize" => 131800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-5f66946103ba05846cdbddcfdd67d027.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30075412_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/901be32e795c6a6e4ca69d569bafafa2.webp"
"MediaSize" => 129317
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-901be32e795c6a6e4ca69d569bafafa2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30075412_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/d874815f887c9400d733dccb56af97a0.webp"
"MediaSize" => 147813
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-d874815f887c9400d733dccb56af97a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30075412_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/abf1f2a0d983071dcec45ed234b45f74.webp"
"MediaSize" => 147919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-abf1f2a0d983071dcec45ed234b45f74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30075412_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/85ef11a3778d1b1b69ad1dd3bfe80ce5.webp"
"MediaSize" => 80655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-85ef11a3778d1b1b69ad1dd3bfe80ce5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30075412_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/7380914c817ff739e81f390e0bc58c10.webp"
"MediaSize" => 111337
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-7380914c817ff739e81f390e0bc58c10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30075412_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/357100d3b1440c5ac70c8764c5ecfbd3.webp"
"MediaSize" => 100166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-357100d3b1440c5ac70c8764c5ecfbd3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30075412_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/6440a97f0d7893f2dd4b7996cd168b0b.webp"
"MediaSize" => 92938
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-6440a97f0d7893f2dd4b7996cd168b0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30075412_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/1e6b39d71876188f8aa8e1852187c7a0.webp"
"MediaSize" => 107621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-1e6b39d71876188f8aa8e1852187c7a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30075412_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/a8f4ff3113b394ba3707cbe314cd904e.webp"
"MediaSize" => 126859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-a8f4ff3113b394ba3707cbe314cd904e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30075412_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/19a39a109577c4ad0a06c3166494e1af.webp"
"MediaSize" => 125599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-19a39a109577c4ad0a06c3166494e1af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30075412_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/f9809bd982b6f985164e16148153e7fb.webp"
"MediaSize" => 72608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-f9809bd982b6f985164e16148153e7fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30075412_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/bced00b821a30a5409710588eddd0ebb.webp"
"MediaSize" => 87706
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-bced00b821a30a5409710588eddd0ebb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30075412_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/f993d696a88ee930272aa6b88c088a45.webp"
"MediaSize" => 121820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-f993d696a88ee930272aa6b88c088a45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30075412_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/56d1d37b42ad3c0c97fa7e9c1d68a0b7.webp"
"MediaSize" => 102095
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-56d1d37b42ad3c0c97fa7e9c1d68a0b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30075412_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/312932c7f70b7bb77070b240e4a34739.webp"
"MediaSize" => 270489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-312932c7f70b7bb77070b240e4a34739.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30075412_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/864fd08459ce5e9fb3197e11ec9e99ea.webp"
"MediaSize" => 342876
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-864fd08459ce5e9fb3197e11ec9e99ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30075412_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/f337a8c414f2c024e2db6d54006dce60.webp"
"MediaSize" => 333156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-f337a8c414f2c024e2db6d54006dce60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30075412_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/0e624da105907f8c2704cbdaf4860846.webp"
"MediaSize" => 383820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-0e624da105907f8c2704cbdaf4860846.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30075412_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/6bbfa82f6cd631b56b95dd7442e4e16e.webp"
"MediaSize" => 98718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-6bbfa82f6cd631b56b95dd7442e4e16e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30075412_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/1e3610b11f468c296cbf6629d9a7905f.webp"
"MediaSize" => 112641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-1e3610b11f468c296cbf6629d9a7905f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30075412_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075412/0fcfe2b0fecb258e7b313c167e3b3e63.webp"
"MediaSize" => 86327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075412/thumbnail-0fcfe2b0fecb258e7b313c167e3b3e63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13602180"
"ResourceRecordKey" => "30075412"
"ModificationTimestamp" => "2026-07-24T15:41:05.12Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30075412')"
+"ID": "1655998"
}
]
+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 296481" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25060
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25003
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "CHESTNUT PARK REALTY(SOUTHWESTERN ONTARIO) LTD"
+"OfficeEmail": null
+"OfficePhone": "519-804-7200"
+"OfficeMlsId": "454001"
+"ModificationTimestamp": "2026-03-03T12:05:49Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "296481"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "75 KING ST SOUTH #50A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "WATERLOO"
+"OfficePostalCode": "N2J1P2"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1470796"
+"OriginalEntryTimestamp": "2024-03-21T19:18:00Z"
+"OfficeAORKey": "82"
+"FranchiseNationalAssociationId": "1230730"
+"OfficeBrokerNationalAssociationId": "1457628"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('296481')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2213356" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25083
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30075412'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25375
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30075412' AND OpenHouseDate ge '2026-07-24'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25391
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30075412' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.515934 43.467934)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25444
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25438
+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 [
"RoomKey" => "1692855074"
"RoomType" => "Storage"
"ListingId" => "40851073"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "30078622"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 7'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:38:09.81Z"
]
1 => array:11 [
"RoomKey" => "1692855075"
"RoomType" => "Workshop"
"ListingId" => "40851073"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "30078622"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:38:09.81Z"
]
2 => array:11 [
"RoomKey" => "1692855076"
"RoomType" => "Laundry room"
"ListingId" => "40851073"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "30078622"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:38:09.81Z"
]
3 => array:11 [
"RoomKey" => "1692855077"
"RoomType" => "3pc Bathroom"
"ListingId" => "40851073"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "30078622"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 5'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:38:09.81Z"
]
4 => array:11 [
"RoomKey" => "1692855078"
"RoomType" => "Bedroom"
"ListingId" => "40851073"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "30078622"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:38:09.82Z"
]
5 => array:11 [
"RoomKey" => "1692855079"
"RoomType" => "Recreation room"
"ListingId" => "40851073"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "30078622"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 27'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:38:09.82Z"
]
6 => array:11 [
"RoomKey" => "1692855080"
"RoomType" => "Bedroom"
"ListingId" => "40851073"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30078622"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:38:09.82Z"
]
7 => array:11 [
"RoomKey" => "1692855081"
"RoomType" => "Bedroom"
"ListingId" => "40851073"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30078622"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:38:09.82Z"
]
8 => array:11 [
"RoomKey" => "1692855082"
"RoomType" => "Primary Bedroom"
"ListingId" => "40851073"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30078622"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:38:09.82Z"
]
9 => array:11 [
"RoomKey" => "1692855083"
"RoomType" => "Full bathroom"
"ListingId" => "40851073"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30078622"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 6'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:38:09.82Z"
]
10 => array:11 [
"RoomKey" => "1692855084"
"RoomType" => "Kitchen"
"ListingId" => "40851073"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30078622"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 18'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:38:09.83Z"
]
11 => array:11 [
"RoomKey" => "1692855085"
"RoomType" => "Living room"
"ListingId" => "40851073"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30078622"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 16'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-25T00:38:09.83Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "30078622_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/e063dfa646b9d0416a8e7af0ff811bdd.webp"
"MediaSize" => 114103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-e063dfa646b9d0416a8e7af0ff811bdd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary bungalow featuring a covered front porch with wood-finish ceiling, recessed lighting, and black railings"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30078622_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/999b890657fe2c753e6581c053c7ff4b.webp"
"MediaSize" => 132778
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-999b890657fe2c753e6581c053c7ff4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Ranch-style exterior with yellow brick and dark blue siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30078622_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/b2386582c45e382d25e7bfce060e004c.webp"
"MediaSize" => 147823
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-b2386582c45e382d25e7bfce060e004c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30078622_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/c49a94504d8d1aa5a848e43534f8e49b.webp"
"MediaSize" => 130658
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-c49a94504d8d1aa5a848e43534f8e49b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30078622_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/557ee53973321698eb6be444f91e4e7a.webp"
"MediaSize" => 117559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-557ee53973321698eb6be444f91e4e7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30078622_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/ce1191ba98d036f7547afe2e7aaffa1b.webp"
"MediaSize" => 137980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-ce1191ba98d036f7547afe2e7aaffa1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious covered porch with composite decking, black metal railings, and a natural wood ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30078622_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/34502631c4bae0742a44e4545103d7fa.webp"
"MediaSize" => 102235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-34502631c4bae0742a44e4545103d7fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30078622_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/949e1f82325a17d087cc770d9c836bbd.webp"
"MediaSize" => 91538
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-949e1f82325a17d087cc770d9c836bbd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring ""Eucalyptus"" green cabinetry, stainless steel appliances, a white subway tile backsplash, and a large central island with a white countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30078622_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/bab139e3199b0d10baba008a2c4c16e5.webp"
"MediaSize" => 75893
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-bab139e3199b0d10baba008a2c4c16e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30078622_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/376bd1ad6723a00c07c6bf7fc50d1c9f.webp"
"MediaSize" => 71671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-376bd1ad6723a00c07c6bf7fc50d1c9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30078622_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/577d6d5bd4a78023e4d693ff0815a113.webp"
"MediaSize" => 75788
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-577d6d5bd4a78023e4d693ff0815a113.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30078622_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/bbe2f6158f471db2ac00fed3c45d69b2.webp"
"MediaSize" => 69250
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-bbe2f6158f471db2ac00fed3c45d69b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30078622_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/4f33b046a2be551f6cd25dd7c292806f.webp"
"MediaSize" => 110895
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-4f33b046a2be551f6cd25dd7c292806f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30078622_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/689ca85b9fcfee98915c4654099ef5e1.webp"
"MediaSize" => 84089
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-689ca85b9fcfee98915c4654099ef5e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30078622_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/1aaa62ebf9396f49c3a0cec78a1304cd.webp"
"MediaSize" => 100836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-1aaa62ebf9396f49c3a0cec78a1304cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30078622_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/8c579a048cf35230f84961c3cb234493.webp"
"MediaSize" => 48835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-8c579a048cf35230f84961c3cb234493.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Matte black kitchen faucet with a gold-tone accent, paired with a stainless steel sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30078622_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/bd95ffa69b181f305cd6d51a6942a434.webp"
"MediaSize" => 134903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-bd95ffa69b181f305cd6d51a6942a434.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30078622_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/4399ae6278b1df2a71905cd82d313120.webp"
"MediaSize" => 102600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-4399ae6278b1df2a71905cd82d313120.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30078622_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/8525bdd49f9323a7cee6a44375256e03.webp"
"MediaSize" => 108710
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-8525bdd49f9323a7cee6a44375256e03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30078622_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/5ada499b8a8987da67ebeabb50fc927d.webp"
"MediaSize" => 90677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-5ada499b8a8987da67ebeabb50fc927d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30078622_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/b41948d44c5720a869098d3f44d14d3a.webp"
"MediaSize" => 64363
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-b41948d44c5720a869098d3f44d14d3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom vanity with a white countertop and light wood-finish cabinetry, featuring a built-in sink and gold-tone faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30078622_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/854f9042d79e7de1ca9b64458b30bab3.webp"
"MediaSize" => 41512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-854f9042d79e7de1ca9b64458b30bab3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "White countertop featuring an integrated sink with a bronze-finish widespread faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30078622_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/ca9d1d2f2c0e6061cfa57754339fa36b.webp"
"MediaSize" => 67923
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-ca9d1d2f2c0e6061cfa57754339fa36b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathtub with subway tile surround, integrated shower niche featuring penny tile, and brushed nickel fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30078622_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/f01479716e6782c9689d178792d0ff73.webp"
"MediaSize" => 37393
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-f01479716e6782c9689d178792d0ff73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Matte black towel warmer against subway tile, complemented by wood-finish cabinetry, under-cabinet lighting, and large format tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30078622_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/f0b409679bc5f0864a6225888f859dfc.webp"
"MediaSize" => 69115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-f0b409679bc5f0864a6225888f859dfc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30078622_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/90e372f5234751f16ca3a776a4bfb951.webp"
"MediaSize" => 61008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-90e372f5234751f16ca3a776a4bfb951.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30078622_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/8928b9afed636df8f9602277da7faa3e.webp"
"MediaSize" => 66333
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-8928b9afed636df8f9602277da7faa3e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30078622_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/b69ec8746a49da3eca265e649150dafe.webp"
"MediaSize" => 26962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-b69ec8746a49da3eca265e649150dafe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40851073"
"ResourceRecordKey" => "30078622"
"ModificationTimestamp" => "2026-07-25T00:38:09.76Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30078622_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30078622/bb6f4235831acd45dab561e60b4dd9e2.webp"
"MediaSize" => 76375
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30078622/thumbnail-bb6f4235831acd45dab561e60b4dd9e2.webp"
…7
]
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('30078622')"
+"ID": "1658495"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25440
+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": 71
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29750999')"
+"ID": "1657897"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25437
+post_id: "1656848"
+post_author: 1
+"ListingKey": "30076768"
+"ListingId": "X13603310"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T18:45:07Z"
+"RFModificationTimestamp": "2026-07-24T19:48:32Z"
+"ListPrice": 553000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0G9"
+"UnparsedAddress": "113 - 288 ALBERT STREET, Waterloo, Ontario N2L0G9"
+"Coordinates": array:2 [
0 => -80.533768
1 => 43.477153
]
+"Latitude": 43.477153
+"Longitude": -80.533768
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "RARELY VACANT, Fully Furnished, Freshly Painted Turn Key Investment Steps from University of Waterloo, and Laurier University! Potential Positive Cashflow with Rent and Low Vacancy Rate due to student housing demand for Universities. COMES WITH 1 PARKING SPOT! Main Floor, Corner unit, with Three Bedrooms, Three FULL Washrooms, Large Main Floor Den, along with another lower level study Area, with 1 Surface Level Parking, Ensuite Laundry. Each Bedroom comes Fully Equipped with Bed Frame, Mattress, Side Table, and Study Desk. Open Concept Living, and Dinning with TV, Sofas and Dinning Table Set. Large U-Shaped Kitchen with stainless steel appliances, Quarts Counter Tops/Backsplash and Bar Stool Seating. Main Floor Den Also Comes with Sofas, TV, and Storage Cabinet. Must See, Everything in the Unit comes with it! Perfect for if you or a loved one will be attending University or if you are looking to build your Investment Portfolio. (id:62650)"
+"Appliances": array:5 [
0 => "All"
1 => "Washer"
2 => "Dryer"
3 => "Furniture"
4 => "Window Coverings"
]
+"AssociationFee": "582.02"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T19:48:23.436678+00:00"
+"Directions": "Cross Streets: University Ave & Albert St. ** Directions: Turn East into Complex from Albert St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Ceramic"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2087935"
+"ListOfficeKey": "292212"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T18:39:36Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T18:39:35Z"
+"StreetName": "Albert"
+"StreetNumber": "288"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4779.34"
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30076768/113-288-albert-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management Inc"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"OriginalEntryTimestamp": "2026-07-24T18:39:35.65Z"
+"ListAgentNationalAssociationId": "1361256"
+"ListOfficeNationalAssociationId": "1409372"
+"Media": array:28 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30076768')"
+"ID": "1656848"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25441
+post_id: "1655619"
+post_author: 1
+"ListingKey": "30075265"
+"ListingId": "40848352"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T17:00:06Z"
+"RFModificationTimestamp": "2026-07-24T17:02:21Z"
+"ListPrice": 279800.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 397.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0H5"
+"UnparsedAddress": "250 ALBERT Street Unit# 311, Waterloo, Ontario N2L0H5"
+"Coordinates": array:2 [
0 => -80.5326714
1 => 43.4753591
]
+"Latitude": 43.4753591
+"Longitude": -80.5326714
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Fantastic investment opportunity in Waterloo's vibrant University District! This modern studio condominium is ideally located just steps from Wilfrid Laurier University, the University of Waterloo, Conestoga College Waterloo Campus, the ION LRT, restaurants, shopping, and Waterloo's renowned technology hub. Purpose-built for today's investor, this low-maintenance suite offers the opportunity to own real estate in one of Ontario's strongest and most resilient rental markets. Professional property management is available, making ownership simple and convenient for both local and out-of-town investors. The thoughtfully designed open-concept layout features contemporary finishes, in-suite laundry, and an efficient use of space. Residents enjoy modern amenities and a location that consistently attracts students, faculty, and young professionals year after year. Whether you're expanding your investment portfolio, purchasing for a university student, or entering the real estate market for the first time, this turnkey condominium offers outstanding value in one of Waterloo's most sought-after locations. (id:62650)"
+"AssociationFee": "310.64"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T16:16:49.144495+00:00"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2239107"
+"ListOfficeKey": "295206"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-07-24T16:53:11Z"
+"PhotosCount": 15
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T16:59:48Z"
+"Stories": "6.0"
+"StreetName": "ALBERT"
+"StreetNumber": "250"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2320.26"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30075265/250-albert-street-unit-311-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1526952"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "295206"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RN-6"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 397
+"OriginalEntryTimestamp": "2026-07-24T15:30:10.44Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1476987"
+"ListOfficeNationalAssociationId": "1447908"
+"CoListAgentNationalAssociationId": "1139331"
+"CoListOfficeNationalAssociationId": "1447908"
+"Media": array:15 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30075265')"
+"ID": "1655619"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25439
+post_id: "1656000"
+post_author: 1
+"ListingKey": "30074796"
+"ListingId": "X13601642"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T14:40:06Z"
+"RFModificationTimestamp": "2026-07-24T15:03:45Z"
+"ListPrice": 369888.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2G0E4"
+"UnparsedAddress": "2214 - 15 WELLINGTON STREET, Kitchener, Ontario N2G0E4"
+"Coordinates": array:2 [
0 => -80.503066
1 => 43.453487
]
+"Latitude": 43.453487
+"Longitude": -80.503066
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome to luxury urban living in one of downtown Kitchener's premier condominium communities. This bright and beautifully appointed 1-bedroom, 1-bathroom suite features an open-concept layout, modern finishes, and the convenience of 1 owned parking space, and an owned storage locker for added convenience. Residents enjoy an exceptional collection of resort-inspired amenities, including a swim-up spa and hot tub, Peloton studio, fully equipped fitness centre, concierge service, dog wash station, party room, and outdoor BBQ area.Perfectly situated just steps from the ION LRT, GO Station, restaurants, cafés, shopping, and Kitchener's vibrant Innovation District, this is an outstanding opportunity for first-time buyers, professionals, or investors seeking luxury, convenience, and an unbeatable location. (id:59439)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
]
+"AssociationFee": "455"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:2 [
0 => "Other, See Remarks"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T15:03:36.816351+00:00"
+"Directions": "Cross Streets: king and wellington. ** Directions: king to wellington."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2024057"
+"ListOfficeKey": "85454"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-24T14:31:03Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T14:31:03Z"
+"StreetName": "Wellington"
+"StreetNumber": "15"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2591"
+"VirtualTourURLUnbranded": "https://iguidephotos.com/2214_15_wellington_st_s_kitchener_on/"
+"ListAOR": "OnePoint"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/30074796/2214-15-wellington-street-kitchener"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-07-24T14:31:03.1Z"
+"ListAgentNationalAssociationId": "1303790"
+"ListOfficeNationalAssociationId": "1187906"
+"Media": array:35 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30074796')"
+"ID": "1656000"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25434
+post_id: "1653054"
+post_author: 1
+"ListingKey": "30072770"
+"ListingId": "X13599774"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T13:45:03Z"
+"RFModificationTimestamp": "2026-07-24T13:49:58Z"
+"ListPrice": 1154000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2M3"
+"UnparsedAddress": "236 NEILSON AVENUE N, Waterloo, Ontario N2J2M3"
+"Coordinates": array:2 [
0 => -80.503783
1 => 43.473402
]
+"Latitude": 43.473402
+"Longitude": -80.503783
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "SEE I GUIDE TOUR. Completed in 2016, this beautifully crafted home offers over 4,300 sq. ft. of finished living space with 4+2 bedrooms and 5 bathrooms in Waterloo's sought-after Lincoln Heights neighbourhood. From the moment you step inside, you'll appreciate the quality and attention to detail. The open-concept main floor is perfect for everyday living and entertaining, featuring 9-foot ceilings, European windows and doors, a stunning custom kitchen with solid wood cabinetry, a 10-foot quartz island, high-end built-in appliances, and a bright sunroom with skylight. The spacious living room is enhanced with built-in shelving, a 5.1 surround sound system, and Bose ceiling speakers with multi-zone audio. Upstairs you'll find four generous bedrooms, including a spacious primary suite with a spa-inspired ensuite and roller shutters for added privacy. The finished lower level adds incredible flexibility with two additional bedrooms, a full bathroom, and a large recreation room-ideal for extended family, guests, or teenagers. Step outside to enjoy a beautifully landscaped backyard with over 1,100 sq. ft. of interlocking stone, perfect for entertaining. Additional highlights include a stamped concrete driveway with parking for six vehicles, finished garage with smart opener and storage shelving, Level 2 EV charger wiring, and security camera provisions. Ideally located close to the University of Waterloo, Wilfrid Laurier University, schools, parks, shopping, Conestoga Mall, and Highway 85. A rare opportunity to own a thoughtfully designed custom home in one of Waterloo's most desirable neighbourhoods. Sq Ft as per Mpac. Bsmt Sq Ft as per Iguide. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Gas stove(s)"
6 => "Dishwasher"
7 => "Dryer"
8 => "Microwave"
9 => "Oven - Built-In"
10 => "Hood Fan"
11 => "Garage door opener"
12 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T21:35:09.499936+00:00"
+"Directions": "Bridgeport Road/Margaret Ave."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1636726"
+"ListOfficeKey": "84654"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "Sump Pump"
]
+"LotSizeDimensions": "50 x 120 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T13:35:35Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T13:35:35Z"
+"Stories": "2.0"
+"StreetName": "Neilson"
+"StreetNumber": "236"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "9096"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/8du0p_236_neilson_ave_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30072770/236-neilson-avenue-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-07-23T21:10:15.18Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1118868"
+"ListOfficeNationalAssociationId": "1145170"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30072770')"
+"ID": "1653054"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23598
+post_id: "1652776"
+post_author: 1
+"ListingKey": "30072347"
+"ListingId": "40848580"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T13:30:01Z"
+"RFModificationTimestamp": "2026-07-24T13:34:40Z"
+"ListPrice": 399999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 633.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E7"
+"UnparsedAddress": "181 KING ST S/S Street Unit# 1111, Waterloo, Ontario N2J0E7"
+"Coordinates": array:2 [
0 => -80.5202134
1 => 43.4604895
]
+"Latitude": 43.4604895
+"Longitude": -80.5202134
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Circa in the heart of Uptown Waterloo. This move-in ready 1-bedroom, 1-bathroom condo offers approximately 633 sq. ft. of thoughtfully designed living space with floor-to-ceiling windows, hardwood flooring, upgraded cabinetry and countertops, a modern bathroom with updated shower, custom closet, in-suite laundry, a storage locker, and an assigned parking space. Step onto the approximate 107 sq. ft. west-facing balcony to enjoy outdoor living and evening sunsets. Building amenities include a fitness centre, co-working lounge, party room, outdoor terrace with pool, fireplaces, BBQs, visitor parking, and a pet-friendly environment. Condo fees include high-speed internet. Located just steps from Uptown Waterloo's restaurants, cafe, shopping, parks, and the ION LRT. Currently leased to excellent tenants, offering a turnkey investment opportunity or future owner-occupancy. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"AssociationFee": "609.8"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T20:17:07.612335+00:00"
+"Directions": "From Hwy 85, take the University Ave E exit, south on King St N, continue onto King St S. Property is located at the southeast corner of King St S & Allen St W"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2216487"
+"ListOfficeKey": "296698"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Covered"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-24T13:21:28Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T13:29:29Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "KING"
+"StreetNumber": "181"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "4253.82"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=wEpyJF9Cgg1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30072347/181-king-street-s-unit-1111-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Exercise Centre"
]
+"ZoningDescription": "MU"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 633
+"OriginalEntryTimestamp": "2026-07-23T19:59:53.73Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1462159"
+"ListOfficeNationalAssociationId": "1461275"
+"Media": array:30 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30072347')"
+"ID": "1652776"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25442
+post_id: "1652820"
+post_author: 1
+"ListingKey": "30072061"
+"ListingId": "X13599134"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T18:45:05Z"
+"RFModificationTimestamp": "2026-07-24T18:51:24Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J1J9"
+"UnparsedAddress": "199 ALLEN STREET, Waterloo, Ontario N2J1J9"
+"Coordinates": array:2 [
0 => -80.507898
1 => 43.467971
]
+"Latitude": 43.467971
+"Longitude": -80.507898
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Detached Raised Bungalow With Certified Legal Basement Apartment Having Separate Entry from the side of the house. Great Income Potential*** Attention Investors***First Time Home Buyers*** Brand New Rangehood & Stove (2026), Fridge(2021), Dishwasher(2025), Recently Brand New Renovated 2 Washrooms (2026), Laundry Pair (2021), Roof (7 Yrs), Brand New Furnace Rental (2025), Owned Air-condition, Tankless Water Heater and Water Softener(2025). Windows (2020). Close To All amenities : Conestoga College Waterloo Campus, University of Waterloo, Wilfrid Laurier University, Shopping Mall, Walmart, And Public Transit. Freshly Painted (2026)Top To Bottom Renovated. All Together Spent Over 140 K Plus In All Upgrades In last 6 Years. Buyer Can Stay On Main Floor And Let The Legal Basement Rent Pay Most Of Your Mortgage Amount. Almost New Roof and All New Windows. (New Furnace Rental installed in 2025) (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Water softener"
2 => "Dryer"
3 => "Two stoves"
4 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T19:38:21.543941+00:00"
+"Directions": "Weber St S And Erb St E"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1950910"
+"ListOfficeKey": "269129"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "Sump Pump"
]
+"LotSizeDimensions": "50 x 151 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T19:38:50Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T18:39:28Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "Allen"
+"StreetNumber": "199"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4855.36"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://drive.google.com/file/d/1iGSESEeXLfw4kjkUiOXhqken4AovzkgI/view?usp=sharing"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30072061/199-allen-street-e-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-07-23T19:10:45.05Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1244928"
+"ListOfficeNationalAssociationId": "1231804"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30072061')"
+"ID": "1652820"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25443
+post_id: "1651897"
+post_author: 1
+"ListingKey": "30071322"
+"ListingId": "40849888"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T16:35:20Z"
+"RFModificationTimestamp": "2026-07-24T16:39:27Z"
+"ListPrice": 414900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2242.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4J1"
+"UnparsedAddress": "121 UNIVERSITY Avenue E Unit# 11, Waterloo, Ontario N2J4J1"
+"Coordinates": array:2 [
0 => -80.5145945
1 => 43.4778187
]
+"Latitude": 43.4778187
+"Longitude": -80.5145945
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Don't miss this spacious end-unit townhouse in the Village on the Green! Where else can you find over 2,200 sqft of finished living space with 4+1 bedrooms and 3.5 baths at such an affordable price? The main floor features a large eat-in kitchen with updated cabinetry and walk-out to the enclosed yard, a family room, bedroom and 2pc bath. Upstairs you will find an oversized primary bedroom with 3pc ensuite and walk-in closet, two additional bedrooms and a 4pc main bath. The basement has been recently updated to include a fifth bedroom, rec room, 3 pc bath, kitchenette and laundry. This is an excellent opportunity for a turn-key investment, or for families looking for more space they can own vs rent. Enjoy low maintenance living surrounded by mature trees, maintained grounds and a very private backyard. Condo fees cover outside maintenance, lawn/snow, water usage, parking, roof and windows. Additional parking is also available for a low monthly rate. Not that you'll need it...the location is just steps from public transit, directly across from the Conestoga College Waterloo campus, walking distance to both the University of Waterloo and Wilfred Laurier campuses, and Moses Springer Community Centre. Not to mention the quick access you'll enjoy to Hwy 85, as well as numerous shopping, dining, trails and other amenities. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"AssociationFee": "766.77"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Water"
4 => "Insurance"
5 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T18:07:11.411915+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2067629"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-23T19:38:23Z"
+"PhotosCount": 38
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T16:30:14Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "UNIVERSITY"
+"StreetNumber": "121"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "3709.55"
+"VirtualTourURLUnbranded": "https://youriguide.com/121_university_ave_e_unit_11_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30071322/121-university-avenue-e-unit-11-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1547
+"BelowGradeFinishedArea": 695
+"OriginalEntryTimestamp": "2026-07-23T17:38:25.48Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1342685"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30071322')"
+"ID": "1651897"
}
]
+success: true
+page_size: 9
+page_count: 43
+count: 385
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
]