array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29975147 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1582263"
+post_author: 1
+"ListingKey": "29975147"
+"ListingId": "40841494"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T15:00:07Z"
+"RFModificationTimestamp": "2026-07-01T16:49:14Z"
+"ListPrice": 1499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.14
+"LivingArea": 2712.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3S6"
+"UnparsedAddress": "85 ALBERT Street, Waterloo, Ontario N2L3S6"
+"Coordinates": array:2 [
0 => -80.5265075
1 => 43.468486
]
+"Latitude": 43.468486
+"Longitude": -80.5265075
+"YearBuilt": 1916
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Incredible opportunity to own a beautifully updated executive century home in one of Waterloo's most coveted locations, backing directly onto Waterloo Park and just steps from Uptown. The perfect blend of timeless character, modern luxury, and an unbeatable lifestyle. Spend summers in your own private backyard retreat, featuring a low-maintenance saltwater pool, mature trees, professional landscaping, and breathtaking views of Waterloo Park. Inside, this exceptionally bright three-storey home offers a spacious open-concept layout, elegant finishes, & sophisticated design throughout. The heart of the home is a dream kitchen designed for serious cooks, complete with professional built-in Thermador appliances, striking six-burner gas range, custom range hood, convenient pot filler, honed Carrara marble countertops, stainless apron-front sink, oversized island with built-in microwave drawer, and abundant custom cabinetry. The sun-filled main floor showcases hardwood flooring, beautiful gas fireplace with marble surround, generous dining space, and large new sliding door opening onto the backyard deck perfect for seamless indoor-outdoor entertaining. The second level features three spacious bedrooms, convenient upper-level laundry, and a luxurious main bathroom with a whirlpool tub, separate glass shower, and exceptional storage. The third floor offers outstanding flexibility with a bright family room overlooking the park, a private office, and a beautifully appointed bathroom with marble finishes. Ideal as a guest retreat, teen hideaway, home office, or potential in-law suite. Walk to everything that makes Uptown Waterloo so desirable, including boutique shopping, exceptional restaurants, Waterloo Park, the LRT, both universities, Perimeter Institute, CIGI, the Clay & Glass Gallery, trails, and countless community amenities. A rare opportunity to own a truly exceptional home where historic charm, contemporary luxury, and one of Waterloo's finest settings come together. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Oven - Built-In"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T16:49:08.954087+00:00"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stucco"
2 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Hot water radiator heat"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1727629"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Backs on greenbelt"
1 => "Conservation/green belt"
]
+"LotSizeDimensions": "0.14"
+"PhotosChangeTimestamp": "2026-07-01T14:50:54Z"
+"PhotosCount": 48
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T14:50:54Z"
+"Stories": "3.0"
+"StreetName": "ALBERT"
+"StreetNumber": "85"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "7920.4"
+"VirtualTourURLUnbranded": "https://youriguide.com/qyzis_85_albert_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1672686034"
"RoomType" => "Recreation room"
"ListingId" => "40841494"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29975147"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 26'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:54.41Z"
]
1 => array:11 [
"RoomKey" => "1672686035"
"RoomType" => "2pc Bathroom"
"ListingId" => "40841494"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975147"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:54.41Z"
]
2 => array:11 [
"RoomKey" => "1672686036"
"RoomType" => "Bedroom"
"ListingId" => "40841494"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29975147"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:54.41Z"
]
3 => array:11 [
"RoomKey" => "1672686037"
"RoomType" => "Office"
"ListingId" => "40841494"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29975147"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:54.41Z"
]
4 => array:11 [
"RoomKey" => "1672686038"
"RoomType" => "Family room"
"ListingId" => "40841494"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29975147"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 20'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:54.41Z"
]
5 => array:11 [
"RoomKey" => "1672686039"
"RoomType" => "3pc Bathroom"
"ListingId" => "40841494"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29975147"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:54.42Z"
]
6 => array:11 [
"RoomKey" => "1672686040"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841494"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29975147"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:54.42Z"
]
7 => array:11 [
"RoomKey" => "1672686041"
"RoomType" => "Bedroom"
"ListingId" => "40841494"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29975147"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:54.42Z"
]
8 => array:11 [
"RoomKey" => "1672686042"
"RoomType" => "Bedroom"
"ListingId" => "40841494"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29975147"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 14'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:54.42Z"
]
9 => array:11 [
"RoomKey" => "1672686043"
"RoomType" => "Primary Bedroom"
"ListingId" => "40841494"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29975147"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 15'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:54.42Z"
]
10 => array:11 [
"RoomKey" => "1672686044"
"RoomType" => "Living room"
"ListingId" => "40841494"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975147"
"RoomLength" => null
"RoomDimensions" => "12'3'' x 21'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:54.42Z"
]
11 => array:11 [
"RoomKey" => "1672686045"
"RoomType" => "Kitchen"
"ListingId" => "40841494"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975147"
"RoomLength" => null
"RoomDimensions" => "15'2'' x 15'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:54.42Z"
]
12 => array:11 [
"RoomKey" => "1672686046"
"RoomType" => "Dining room"
"ListingId" => "40841494"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975147"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 13'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:54.42Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29975147/85-albert-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RC1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 46.0
+"AboveGradeFinishedArea": 2712
+"OriginalEntryTimestamp": "2026-07-01T14:50:54.22Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1176146"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:48 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29975147_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/59b22c5fb033e9f607d93ec8758f2e94.webp"
"MediaSize" => 209533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-59b22c5fb033e9f607d93ec8758f2e94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Your private oasis in the city awaits!"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29975147_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/cf2865b2bc902147777c4eff96716298.webp"
"MediaSize" => 150090
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-cf2865b2bc902147777c4eff96716298.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Welcome to 85 Albert Street!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29975147_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/1979c369ca3db9b055efcebbd3d0912d.webp"
"MediaSize" => 190097
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-1979c369ca3db9b055efcebbd3d0912d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Beautiful landscaping front and back."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29975147_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/60d6cd9043d496ab35bb4f51be83d54e.webp"
"MediaSize" => 79524
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-60d6cd9043d496ab35bb4f51be83d54e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Chic right from the entry--gorgeous moulding and trim."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29975147_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/b3532bf9ac8b7d7e0a7d24a304d7f246.webp"
"MediaSize" => 86493
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-b3532bf9ac8b7d7e0a7d24a304d7f246.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright spacious living room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29975147_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/fb58deffe27bfb76cdfdb712ba5f209d.webp"
"MediaSize" => 89194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-fb58deffe27bfb76cdfdb712ba5f209d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "A great place to read, relax or entertain."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29975147_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/2ce192eb5eb125888056998be3985512.webp"
"MediaSize" => 85551
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-2ce192eb5eb125888056998be3985512.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Cozy gas fireplace with detailed mantel."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29975147_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/2a062510abdba59cf98dc85a6fcd0911.webp"
"MediaSize" => 90205
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-2a062510abdba59cf98dc85a6fcd0911.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Separate formal dining room with crystal chandelier, huge gorgeous sliding doors walk-out to deck."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29975147_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/b61e6ce046ba29263c86b1602e7ff186.webp"
"MediaSize" => 94263
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-b61e6ce046ba29263c86b1602e7ff186.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Great for family times, and celebrations with friends!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29975147_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/3fd86ecc31902557cb94e63a3d3727ba.webp"
"MediaSize" => 78610
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-3fd86ecc31902557cb94e63a3d3727ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stunning kitchen with island and built-in microwave drawer."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29975147_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/3258392961041551539ff970ac4d68ab.webp"
"MediaSize" => 74424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-3258392961041551539ff970ac4d68ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stainless apron-front sink and hi-arc faucet."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29975147_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/da69ca61f61f517296b8a02b1996e11c.webp"
"MediaSize" => 78283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-da69ca61f61f517296b8a02b1996e11c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Cook like Gordon Ramsay on this Thermador 6 burner gas range with convenient pot filler tap!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29975147_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/e4ce302dcffd10bf759549e2060913ce.webp"
"MediaSize" => 81026
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-e4ce302dcffd10bf759549e2060913ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hang out with the chef while they cook!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29975147_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/4ffd5ddb330a275cc1e0188a0b137a27.webp"
"MediaSize" => 76555
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-4ffd5ddb330a275cc1e0188a0b137a27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor to ceiling pantry cupboards - space for everything."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29975147_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/2988078b9a7fbdbd6cbce400eeab90c4.webp"
"MediaSize" => 45864
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-2988078b9a7fbdbd6cbce400eeab90c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "New powder room with gorgeous trim."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29975147_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/5b18bd38db8946cf2945d72537f3ead0.webp"
"MediaSize" => 72219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-5b18bd38db8946cf2945d72537f3ead0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious bedrooms"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29975147_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/25a32f100f60ed5f3a31181173240ed6.webp"
"MediaSize" => 80583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-25a32f100f60ed5f3a31181173240ed6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Beautiful primary bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29975147_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/9a43cec4c0b29ccd68ec34cec18e1977.webp"
"MediaSize" => 82864
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-9a43cec4c0b29ccd68ec34cec18e1977.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Another spacious bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29975147_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/27fc14e3dd79fe0c533ce712845c491b.webp"
"MediaSize" => 53561
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-27fc14e3dd79fe0c533ce712845c491b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Convenient upstairs laundry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29975147_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/33bf316b83edb4206f0e7e8bc942025c.webp"
"MediaSize" => 46782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-33bf316b83edb4206f0e7e8bc942025c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Soak your cares away."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29975147_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/f1ec78c31a26841e58366407fdf5b2d6.webp"
"MediaSize" => 66721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-f1ec78c31a26841e58366407fdf5b2d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "So much storage in this bathroom!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29975147_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/027ace22d8f15ea880e95f1b0a21bf7c.webp"
"MediaSize" => 53584
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-027ace22d8f15ea880e95f1b0a21bf7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Your spa at home."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29975147_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/6839d198d5690a7e30daf0a78a270cdd.webp"
"MediaSize" => 40972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-6839d198d5690a7e30daf0a78a270cdd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lovely shower with bench!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29975147_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/6f6d94b53819e9ed2ac154e126a09b1c.webp"
"MediaSize" => 81458
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-6f6d94b53819e9ed2ac154e126a09b1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright stairway to the third floor."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29975147_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/aeb9059ccad2aa232ee03e031a8bd0c7.webp"
"MediaSize" => 48561
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-aeb9059ccad2aa232ee03e031a8bd0c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Amazing third floor office!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29975147_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/d140fcca733b32fa5009ae698babb67a.webp"
"MediaSize" => 60168
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-d140fcca733b32fa5009ae698babb67a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Smart storage"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29975147_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/d483b124b447e444e4947689540d0b60.webp"
"MediaSize" => 76010
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-d483b124b447e444e4947689540d0b60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bonus third floor family room! Could also be great 5th bedroom."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29975147_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/f16d8978ef178729592e40a0fb804e07.webp"
"MediaSize" => 78099
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-f16d8978ef178729592e40a0fb804e07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Large windows let in so much light! Great views too!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29975147_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/41058646a5ae39ea351a7dc408e71228.webp"
"MediaSize" => 82336
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-41058646a5ae39ea351a7dc408e71228.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Your movie nights await!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29975147_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/a322b44cd01db43a0c342da94f6114cf.webp"
"MediaSize" => 85674
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-a322b44cd01db43a0c342da94f6114cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lots of possibilities for this space too! Potential in-law suite?"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29975147_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/dee55e95ec8368ffe032a4f0b6594e04.webp"
"MediaSize" => 75037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-dee55e95ec8368ffe032a4f0b6594e04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bonus 3rd floor bedroom!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29975147_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/b9a8df8fac83b54408b11f63cc629edf.webp"
"MediaSize" => 75509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-b9a8df8fac83b54408b11f63cc629edf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Beautiful bathroom with marble finishes."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29975147_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/475a2e15d081f42857fc097d976d9c14.webp"
"MediaSize" => 63561
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-475a2e15d081f42857fc097d976d9c14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement rec room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29975147_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/9799d79716d52e8efcec86a3fa3f3a18.webp"
"MediaSize" => 87360
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-9799d79716d52e8efcec86a3fa3f3a18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rec room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29975147_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/524e39544b27db26ada779c04ef2516d.webp"
"MediaSize" => 158560
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-524e39544b27db26ada779c04ef2516d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Your own backyard oasis."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29975147_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/a716196c29ca16f8631620bf67a08e4b.webp"
"MediaSize" => 186308
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-a716196c29ca16f8631620bf67a08e4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Can you believe this yard?"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29975147_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/aef6b779642c00732aad10ade09c4985.webp"
"MediaSize" => 157594
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-aef6b779642c00732aad10ade09c4985.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Enjoy drinks by the pool - your friends won't want to leave!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29975147_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/7409c66160ec9333748b5add8415d3c0.webp"
"MediaSize" => 114098
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-7409c66160ec9333748b5add8415d3c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Cocktails for everyone."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29975147_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/4f232589d5e8533df85e24c530c9181c.webp"
"MediaSize" => 168283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-4f232589d5e8533df85e24c530c9181c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive outdoor oasis featuring a freeform swimming pool, flagstone pathway, mature trees, lush landscaping, and poolside gazebo"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29975147_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/eb22f199802d6bbe01c5b01e7f8c6c00.webp"
"MediaSize" => 165526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-eb22f199802d6bbe01c5b01e7f8c6c00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "So peaceful! This is where you'll spend the summer!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29975147_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/f2721ea856876717c5ac792675ea3065.webp"
"MediaSize" => 119377
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-f2721ea856876717c5ac792675ea3065.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Arial view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29975147_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/dea4789c53d26a4f953cd1f22c814576.webp"
"MediaSize" => 119603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-dea4789c53d26a4f953cd1f22c814576.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Backing on to Waterloo Park!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29975147_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/aba50bae4fdc526cea2c669aed41d957.webp"
"MediaSize" => 154997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-aba50bae4fdc526cea2c669aed41d957.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "You'll be able to enter the park through your back gate."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29975147_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/8798c5a479b4c64a89b3986975cc3224.webp"
"MediaSize" => 100130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-8798c5a479b4c64a89b3986975cc3224.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Close to the Rec Complex!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29975147_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/b4f82a8ce5cb6ffdcbaa88bf23e29b1e.webp"
"MediaSize" => 105091
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-b4f82a8ce5cb6ffdcbaa88bf23e29b1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Close to uptown restaurants!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29975147_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/af723228c97f1467c8ee3f34b839c24d.webp"
"MediaSize" => 96362
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-af723228c97f1467c8ee3f34b839c24d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Close to LRT"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29975147_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/d21c003c846bc91eb46c336401400f53.webp"
"MediaSize" => 91772
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-d21c003c846bc91eb46c336401400f53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Steps from uptown Waterloo!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29975147_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975147/e0b739aa7e05f7e49ed23213595157f8.webp"
"MediaSize" => 88639
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975147/thumbnail-e0b739aa7e05f7e49ed23213595157f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Great walking trails around Silver Lake"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841494"
"ResourceRecordKey" => "29975147"
"ModificationTimestamp" => "2026-07-01T14:50:54.25Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29975147')"
+"ID": "1582263"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 290168" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24882
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1727629" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24873
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29975147'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25284
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29975147'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25361
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29975147' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5265075 43.468486)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25318
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25312
+post_id: "1582721"
+post_author: 1
+"ListingKey": "29974894"
+"ListingId": "X13508384"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T13:50:02Z"
+"RFModificationTimestamp": "2026-07-01T17:14:11Z"
+"ListPrice": 409900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0J1"
+"UnparsedAddress": "206 - 275A LARCH STREET, Waterloo, Ontario N2L0J1"
+"Coordinates": array:2 [
0 => -80.531024
1 => 43.476283
]
+"Latitude": 43.476283
+"Longitude": -80.531024
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Spacious, Safe For Students & Fully Furnished Two Bedrooms Two Full Washrooms, Unit Accessible By Wheelchair. Unit on 275A Larch St. Just Steps Away From The Heart Of Canada's Technology Hub, Next Door To Wilfrid Laurier's New Lazaridis School Of Business And Economics, is situation in The Prime Downtown Area And In Minutes To The University Of Waterloo. Conveniently Located Near All Of The Amenities Waterloo Has To Offer. Premier Suite Finishes 9 Foot Ceilings, Professionally Painted And Deep Cleaned, New Vinyl Flooring Through-out, Ceramic Tile In Bathroom, In Suite Laundry With Stackable Washer/Dryer, Oversized Low E Argon Windows, Texture Ceiling & More. Turnkey Real Estate Investment. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Furniture"
8 => "Window Coverings"
]
+"AssociationFee": "410.96"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Cable TV"
1 => "Heat"
2 => "Water"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T17:02:23.712706+00:00"
+"Directions": "Cross Streets: Larch St & Balsam St. ** Directions: Hickory St W & Larch St."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1419511"
+"ListOfficeKey": "90198"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T13:44:05Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T13:44:05Z"
+"StreetName": "Larch"
+"StreetNumber": "275A"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2907.48"
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1672646087"
"RoomType" => "Living room"
"ListingId" => "X13508384"
"RoomLevel" => "Main level"
"RoomWidth" => 2.96
"ListingKey" => "29974894"
"RoomLength" => 4.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-01T13:44:05.32Z"
]
1 => array:11 [
"RoomKey" => "1672646088"
"RoomType" => "Dining room"
"ListingId" => "X13508384"
"RoomLevel" => "Main level"
"RoomWidth" => 2.96
"ListingKey" => "29974894"
"RoomLength" => 4.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-01T13:44:05.32Z"
]
2 => array:11 [
"RoomKey" => "1672646089"
"RoomType" => "Kitchen"
"ListingId" => "X13508384"
"RoomLevel" => "Main level"
"RoomWidth" => 4.05
"ListingKey" => "29974894"
"RoomLength" => 2.47
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-01T13:44:05.32Z"
]
3 => array:11 [
"RoomKey" => "1672646090"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13508384"
"RoomLevel" => "Main level"
"RoomWidth" => 2.47
"ListingKey" => "29974894"
"RoomLength" => 4.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-01T13:44:05.32Z"
]
4 => array:11 [
"RoomKey" => "1672646091"
"RoomType" => "Bedroom 2"
"ListingId" => "X13508384"
"RoomLevel" => "Main level"
"RoomWidth" => 2.62
"ListingKey" => "29974894"
"RoomLength" => 3.69
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-01T13:44:05.32Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29974894/206-275a-larch-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Condo Management Corp"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Separate Electricity Meters"
1 => "Separate Heating Controls"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-01T13:44:05.28Z"
+"ListAgentNationalAssociationId": "1113778"
+"ListOfficeNationalAssociationId": "1153615"
+"Media": array:34 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29974894_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974894/f7f211936565cc05358fe0c08c17a90a.webp"
"MediaSize" => 240415
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974894/thumbnail-f7f211936565cc05358fe0c08c17a90a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13508384"
"ResourceRecordKey" => "29974894"
"ModificationTimestamp" => "2026-07-01T13:44:05.29Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29974894_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974894/0a8327bb87f97e01f5e5bb1a3987d1ec.webp"
"MediaSize" => 254004
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974894/thumbnail-0a8327bb87f97e01f5e5bb1a3987d1ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508384"
"ResourceRecordKey" => "29974894"
"ModificationTimestamp" => "2026-07-01T13:44:05.29Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29974894_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974894/7a8026bbc20147e09aef56c38aa6eafa.webp"
"MediaSize" => 213988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974894/thumbnail-7a8026bbc20147e09aef56c38aa6eafa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508384"
"ResourceRecordKey" => "29974894"
"ModificationTimestamp" => "2026-07-01T13:44:05.29Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29974894_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974894/dd87f923dfcbc6309819ddd74a2b6983.webp"
"MediaSize" => 207111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974894/thumbnail-dd87f923dfcbc6309819ddd74a2b6983.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508384"
"ResourceRecordKey" => "29974894"
"ModificationTimestamp" => "2026-07-01T13:44:05.29Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29974894_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974894/697e6441c86308e6ed711f2d208f92d9.webp"
"MediaSize" => 78010
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974894/thumbnail-697e6441c86308e6ed711f2d208f92d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508384"
"ResourceRecordKey" => "29974894"
"ModificationTimestamp" => "2026-07-01T13:44:05.29Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29974894_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974894/09e605a5cb791c353ae49c6ff2c79171.webp"
"MediaSize" => 128178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974894/thumbnail-09e605a5cb791c353ae49c6ff2c79171.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13508384"
"ResourceRecordKey" => "29974894"
…1
]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29974894')"
+"ID": "1582721"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25314
+post_id: "1582643"
+post_author: 1
+"ListingKey": "29974948"
+"ListingId": "40844402"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T14:15:06Z"
+"RFModificationTimestamp": "2026-07-01T17:13:13Z"
+"ListPrice": 295000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 527.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0E9"
+"UnparsedAddress": "318 SPRUCE Street Unit# 808, Waterloo, Ontario N2L0E9"
+"Coordinates": array:2 [
0 => -80.5264531
1 => 43.4791309
]
+"Latitude": 43.4791309
+"Longitude": -80.5264531
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 808 at 318 Spruce St.—a stylish 1-bed, 1-bath condo offering contemporary finishes, a bright open-concept layout, and stunning eighth-floor views in one of Waterloo's most sought-after locations. Whether you're a first-time buyer, investor, young professional, or university student, this move-in-ready suite combines modern comfort with exceptional convenience. Step inside to discover a thoughtfully designed interior featuring durable modern flooring, contemporary fixtures, and an abundance of natural light throughout. The sleek kitchen is both functional and inviting, showcasing granite countertops, stainless steel appliances, ample cabinetry, and a spacious peninsula with seating—perfect for casual dining or entertaining. The open-concept living area extends seamlessly to your private balcony, where you'll enjoy panoramic views of the Waterloo skyline while sipping your morning coffee or relaxing at the end of the day. The spacious bedroom offers large windows, generous closet space, and plenty of natural light, while the modern 4-piece bath and convenient in-suite laundry add everyday practicality. Residents enjoy an impressive collection of amenities including a fitness centre, an rooftop terrace with BBQs and outdoor seating, a co-working and study space, a theatre room, garbage chute, and reservable guest suites that provide comfortable accommodations for visiting family. Located steps from the University of Waterloo, Wilfrid Laurier University, Conestoga College, LRT, shopping, restaurants, cafés, parks, and countless everyday amenities, this exceptional condo offers outstanding convenience and long-term value. Condo fees include: internet, water, heat, AC, garbage, maintenance, snow & lawn care. Don't miss your next home or a turnkey investment opportunity in Waterloo's thriving university district. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFee": "316.27"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Heat"
3 => "Water"
4 => "Insurance"
5 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T16:58:12.354402+00:00"
+"Directions": "King St N & Hickory St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2047559"
+"ListOfficeKey": "283168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "None"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-01T14:09:49Z"
+"PhotosCount": 25
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T14:09:49Z"
+"Stories": "1.0"
+"StreetName": "SPRUCE"
+"StreetNumber": "318"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3366"
+"View": "City view"
+"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/29974948/318-spruce-street-unit-808-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Guest Suite"
2 => "Party Room"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 527
+"OriginalEntryTimestamp": "2026-07-01T14:09:49.47Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1322997"
+"ListOfficeNationalAssociationId": "1325206"
+"Media": array:25 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29974948')"
+"ID": "1582643"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25311
+post_id: "1582300"
+post_author: 1
+"ListingKey": "29975321"
+"ListingId": "X13508816"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T15:55:09Z"
+"RFModificationTimestamp": "2026-07-01T16:36:24Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4S3"
+"UnparsedAddress": "1603 - 6 WILLOW STREET, Waterloo, Ontario N2J4S3"
+"Coordinates": array:2 [
0 => -80.516126
1 => 43.465828
]
+"Latitude": 43.465828
+"Longitude": -80.516126
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Waterpark Place, one of Waterloo's most sought-after condominium residences! This stunning 2-bedroom, 2 full bathroom unit offers over 1200 square feet of living space, hardwood flooring throughout, an abundance of natural light, and breathtaking south-facing city views. Located in the heart of Uptown Waterloo, 6 Willow Street offers a walkable lifestyle that is steps away from vibrant restaurants, boutique shopping, groceries, the LRT, Waterloo Park, scenic trails and much more. Set on four acres of meticulously manicured and landscaped grounds, this prestigious building offers the perfect balance of luxury, comfort, and convenience. Residents enjoy exceptional amenities, including an indoor pool, sauna, fitness centre, library, billiards room, party room, conference room, controlled entry, underground parking, secure exclusive-use lockers, comprehensive security systems, and ample visitor parking. Multiple outdoor seating areas throughout the beautifully landscaped property provide the perfect place to relax and unwind. Whether you're downsizing or simply searching for maintenance-free living in one of Waterloo's most desirable addresses, this remarkable unit is an opportunity you won't want to miss! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"AssociationFee": "847.01"
+"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 not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T16:36:15.678972+00:00"
+"Directions": "Cross Streets: Erb. ** Directions: Erb St E to Willow."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2154943"
+"ListOfficeKey": "290667"
+"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-01T15:45:38Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T15:45:38Z"
+"StreetName": "Willow"
+"StreetNumber": "6"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4329"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/t7cwn_1603_6_willow_st_waterloo_on/"
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29975321/1603-6-willow-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "T & Company"
+"GeocodeManualYN": true
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Sauna"
]
+"SecurityFeatures": array:1 [
0 => "Controlled entry"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-01T15:45:38.13Z"
+"ListAgentNationalAssociationId": "1406411"
+"ListOfficeNationalAssociationId": "1390130"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29975321')"
+"ID": "1582300"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25315
+post_id: "1581100"
+post_author: 1
+"ListingKey": "29972695"
+"ListingId": "X13506576"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T03:45:12Z"
+"RFModificationTimestamp": "2026-07-01T03:50:41Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0G2"
+"UnparsedAddress": "306 - 103 ROGER STREET, Waterloo, Ontario N2J0G2"
+"Coordinates": array:2 [
0 => -80.5096531
1 => 43.4600652
]
+"Latitude": 43.4600652
+"Longitude": -80.5096531
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Experience the perfect blend of comfort, convenience, and city living at 103 Roger Street, Unit 306. This spacious 2-bedroom, 2-bathroom condo offers an inviting layout with plenty of natural light and a private balcony to enjoy your morning coffee or unwind after a busy day. Set in a secure, well-maintained building with amenities including underground parking, bicycle storage, a party room, and an outdoor parkette, you'll appreciate the ease of low-maintenance living. Located just moments from Uptown Waterloo, universities, Grand River Hospital, Google, the ION LRT, shopping, dining, and entertainment, this is an ideal home for professionals, students, downsizers, or savvy investors looking to capitalize on strong rental demand in one of Waterloo's most sought-after neighborhoods. (id:62650)"
+"AssociationFee": "484"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"CreationDate": "2026-06-30T22:50:13.864155+00:00"
+"Directions": "Cross Streets: Roger St./ Moore Ave. ** Directions: Roger St. / Moore Ave."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Electric"
1 => "Coil Fan"
2 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2034082"
+"ListOfficeKey": "264586"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-01T03:36:36Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T03:36:36Z"
+"StreetName": "Roger"
+"StreetNumber": "103"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4480"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29972695/306-103-roger-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1768115"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Duka Property Management"
+"CoListOfficeKey": "264586"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-30T20:23:25.12Z"
+"ListAgentNationalAssociationId": "1310803"
+"ListOfficeNationalAssociationId": "1225052"
+"CoListAgentNationalAssociationId": "1185774"
+"CoListOfficeNationalAssociationId": "1225052"
+"Media": array:26 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29972695')"
+"ID": "1581100"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25313
+post_id: "1580907"
+post_author: 1
+"ListingKey": "29973036"
+"ListingId": "40843175"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T21:25:01Z"
+"RFModificationTimestamp": "2026-06-30T22:54:28Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1234.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4S3"
+"UnparsedAddress": "6 WILLOW Street Unit# 1603, Waterloo, Ontario N2J4S3"
+"Coordinates": array:2 [
0 => -80.5161532
1 => 43.4658494
]
+"Latitude": 43.4658494
+"Longitude": -80.5161532
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Waterpark Place, one of Waterloo's most sought-after condominium residences! This stunning 2-bedroom, 2 full bathroom unit offers over 1200 square feet of living space, hardwood flooring throughout, an abundance of natural light, and breathtaking south-facing city views. Located in the heart of Uptown Waterloo, 6 Willow Street offers a walkable lifestyle that is steps away from vibrant restaurants, boutique shopping, groceries, the LRT, Waterloo Park, scenic trails and much more. Set on four acres of meticulously manicured and landscaped grounds, this prestigious building offers the perfect balance of luxury, comfort, and convenience. Residents enjoy exceptional amenities, including an indoor pool, sauna, fitness centre, library, billiards room, party room, conference room, controlled entry, underground parking, secure exclusive-use lockers, comprehensive security systems, and ample visitor parking. Multiple outdoor seating areas throughout the beautifully landscaped property provide the perfect place to relax and unwind. Whether you're downsizing or simply searching for maintenance-free living in one of Waterloo's most desirable addresses, this remarkable unit is an opportunity you won't want to miss! (id:62650)"
+"AccessibilityFeatures": array:1 [
0 => "Accessible Entrance"
]
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Sauna"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
]
+"AssociationFee": "847.01"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Property Management"
1 => "Water"
2 => "Insurance"
3 => "Other, See Remarks"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T22:39:55.480778+00:00"
+"Directions": "Erb St E to Willow St"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2160855"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Ravine"
2 => "Balcony"
3 => "No Pet Home"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-30T21:19:50Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T21:19:50Z"
+"Stories": "1.0"
+"StreetName": "WILLOW"
+"StreetNumber": "6"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "4329"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youriguide.com/t7cwn_1603_6_willow_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29973036/6-willow-street-unit-1603-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1563990"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "290620"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Guest Suite"
2 => "Party Room"
]
+"SecurityFeatures": array:3 [
0 => "Security system"
1 => "Smoke Detectors"
2 => "Monitored Alarm"
]
+"ZoningDescription": "RMU-81"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1234
+"OriginalEntryTimestamp": "2026-06-30T21:19:50.65Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1411946"
+"ListOfficeNationalAssociationId": "1004387"
+"CoListAgentNationalAssociationId": "1070024"
+"CoListOfficeNationalAssociationId": "1389824"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29973036')"
+"ID": "1580907"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25308
+post_id: "1580518"
+post_author: 1
+"ListingKey": "29972328"
+"ListingId": "40844069"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T19:45:02Z"
+"RFModificationTimestamp": "2026-06-30T20:23:29Z"
+"ListPrice": 949900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1773.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3A5"
+"UnparsedAddress": "25 CENTRAL Street, Waterloo, Ontario N2L3A5"
+"Coordinates": array:2 [
0 => -80.5255874
1 => 43.4697719
]
+"Latitude": 43.4697719
+"Longitude": -80.5255874
+"YearBuilt": 1896
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 25 Central Street, Waterloo—a beautifully updated century home offering timeless character, modern upgrades, and an unbeatable location in the heart of Uptown Waterloo. This charming 4-bedroom, 2-bathroom home boasts outstanding curb appeal with a spacious covered front porch, the perfect place to relax and enjoy the neighbourhood. Step inside and be welcomed by the home's stunning original curved staircase, setting the tone for the character and craftsmanship found throughout. To the right, the bright and inviting living room flows seamlessly into the formal dining room, creating an ideal space for everyday living and entertaining. Off the dining room, a second staircase leads to the upper level, adding both convenience and classic charm. The custom-designed kitchen has been thoughtfully renovated with quartz countertops, under-cabinet lighting, brand-new stainless steel appliances, and plenty of workspace. Just off the kitchen is a bright sunroom that provides additional living space and direct access to the peaceful backyard. The main floor also features a versatile bedroom that can easily serve as a home office, along with a convenient 3-piece bathroom. Upstairs you'll find three spacious bedrooms and an updated 4-piece bathroom. One of the upper bedrooms includes a staircase leading to the unfinished attic, offering excellent storage or future potential. Soaring 9-foot ceilings, new solid maple hardwood flooring, and new wood Thermopane windows throughout beautifully blend historic elegance with modern comfort. Additional updates include a recent high-efficiency forced air gas furnace and new central AC for year-round comfort. Outside, enjoy a quiet backyard complete with a garden shed and parking for two vehicles. Located in the centre of Uptown, this home is within walking distance of restaurants, shopping, Waterloo Park, Universities and countless other amenities. A rare opportunity to own a beautifully renovated character home in Waterloo! (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T20:12:52.654711+00:00"
+"Directions": "King Street to Central Street"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908292"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-30T19:39:48Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T19:39:48Z"
+"Stories": "2.0"
+"StreetName": "CENTRAL"
+"StreetNumber": "25"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "5499.88"
+"VirtualTourURLUnbranded": "https://youriguide.com/25_central_street_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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29972328/25-central-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RC1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1773
+"OriginalEntryTimestamp": "2026-06-30T19:39:47.98Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1221205"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29972328')"
+"ID": "1580518"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1579629"
+post_author: 1
+"ListingKey": "29971291"
+"ListingId": "X13505422"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T17:46:26Z"
+"RFModificationTimestamp": "2026-06-30T18:22:53Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3R2"
+"UnparsedAddress": "G104 - 275 LARCH STREET, Waterloo, Ontario N2L3R2"
+"Coordinates": array:2 [
0 => -80.531342
1 => 43.477165
]
+"Latitude": 43.477165
+"Longitude": -80.531342
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Discover exceptional value in this beautifully maintained 2-bedroom, 1-bathroom condominium located in Waterloo's highly desirable University District. Offering approximately 762 sq. ft. of thoughtfully designed living space, this bright and inviting unit features a practical layout that is ideal for both owner-occupiers and investors.Positioned within walking distance of the University of Waterloo, Wilfrid Laurier University, Conestoga College, the ION LRT, shopping, dining, parks, and everyday amenities, this location provides unmatched convenience and strong rental demand.Being sold fully furnished, the condo is ready for immediate use with minimal effort. The property is currently occupied by long-term tenants, presenting an excellent opportunity for buyers looking to generate rental income from day one while benefiting from continued leasing potential. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Furniture"
6 => "Window Coverings"
]
+"AssociationFee": "344"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T18:20:48.259501+00:00"
+"Directions": "Hickory St W & Hemlock St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2141272"
+"ListOfficeKey": "296550"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-30T17:16:20Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T17:16:20Z"
+"StreetName": "Larch"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2581.45"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29971291/g104-275-larch-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Blackline Management Services"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-30T17:16:20.88Z"
+"ListAgentNationalAssociationId": "1393034"
+"ListOfficeNationalAssociationId": "1459693"
+"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('29971291')"
+"ID": "1579629"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25316
+post_id: "1578689"
+post_author: 1
+"ListingKey": "29970323"
+"ListingId": "X13504430"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T15:25:14Z"
+"RFModificationTimestamp": "2026-06-30T16:00:30Z"
+"ListPrice": 645000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E5"
+"UnparsedAddress": "504 - 158 KING STREET N, Waterloo, Ontario N2J0E5"
+"Coordinates": array:2 [
0 => -80.523574
1 => 43.471807
]
+"Latitude": 43.471807
+"Longitude": -80.523574
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To 158 King St N Located In A Prime Location Of Downtown Waterloo! This Spacious Corner 3 Bdr Unit Offers Large Windows, Lots Of Natural Light,9 Ft Ceilings, Custom Kitchen Cabinetry, Fully furnished Appliance, Ensuite Laundry (brand new),3 Great Size Bdrms & 2 FullBaths, Newly upgraded Vinyl flooring! 5 minutes walk to Wilfrid Laurier University, 5 min bus to University Of Waterloo, Uw Tech. Park, Shops, Restaurants And More! Perfect Opportunity to Invest In One Of The Fastest Growing Communities In Waterloo! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "812.92"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T16:00:17.712374+00:00"
+"Directions": "King St N/ University Ave"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2188517"
+"ListOfficeKey": "277403"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-30T15:16:26Z"
+"PhotosCount": 16
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T15:16:26Z"
+"StreetDirSuffix": "North"
+"StreetName": "King"
+"StreetNumber": "158"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5127.5"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29970323/504-158-king-street-n-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2132538"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Grand River Property Management Inc. 519-778-5986"
+"CoListAgentKey2": "2224422"
+"CoListOfficeKey": "277403"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"CoListOfficeKey2": "277403"
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-30T15:16:26.76Z"
+"ListAgentNationalAssociationId": "1437568"
+"ListOfficeNationalAssociationId": "1282893"
+"CoListAgentNationalAssociationId": "1385216"
+"CoListAgentNationalAssociationId2": "1467766"
+"CoListOfficeNationalAssociationId": "1282893"
+"CoListOfficeNationalAssociationId2": "1282893"
+"Media": array:16 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29970323')"
+"ID": "1578689"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25317
+post_id: "1576482"
+post_author: 1
+"ListingKey": "29967867"
+"ListingId": "40843784"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T12:00:19Z"
+"RFModificationTimestamp": "2026-07-01T12:18:01Z"
+"ListPrice": 699900.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.5143455
1 => 43.4790622
]
+"Latitude": 43.4790622
+"Longitude": -80.5143455
+"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"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T21:54:15.108716+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-06-29T22:11:20Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T11:50:26Z"
+"Stories": "1.0"
+"StreetName": "CARTER"
+"StreetNumber": "223"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "4081.94"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/223-carter-ave"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29967867/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-06-29T20:51:49.12Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1247007"
+"ListOfficeNationalAssociationId": "1473831"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29967867')"
+"ID": "1576482"
}
]
+success: true
+page_size: 9
+page_count: 46
+count: 414
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]