array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29972328 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: "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 [
"RoomKey" => "1672118318"
"RoomType" => "Other"
"ListingId" => "40844069"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29972328"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 23'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:39:48.29Z"
]
1 => array:11 [
"RoomKey" => "1672118319"
"RoomType" => "Other"
"ListingId" => "40844069"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29972328"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:39:48.29Z"
]
2 => array:11 [
"RoomKey" => "1672118320"
"RoomType" => "Other"
"ListingId" => "40844069"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29972328"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 8'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:39:48.3Z"
]
3 => array:11 [
"RoomKey" => "1672118321"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844069"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29972328"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 14'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:39:48.3Z"
]
4 => array:11 [
"RoomKey" => "1672118322"
"RoomType" => "Bedroom"
"ListingId" => "40844069"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29972328"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:39:48.31Z"
]
5 => array:11 [
"RoomKey" => "1672118323"
"RoomType" => "Bedroom"
"ListingId" => "40844069"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29972328"
"RoomLength" => null
"RoomDimensions" => "14'4'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:39:48.31Z"
]
6 => array:11 [
"RoomKey" => "1672118324"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844069"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29972328"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:39:48.31Z"
]
7 => array:11 [
"RoomKey" => "1672118325"
"RoomType" => "Mud room"
"ListingId" => "40844069"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29972328"
"RoomLength" => null
"RoomDimensions" => "7'9'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:39:48.32Z"
]
8 => array:11 [
"RoomKey" => "1672118326"
"RoomType" => "Living room"
"ListingId" => "40844069"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29972328"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:39:48.32Z"
]
9 => array:11 [
"RoomKey" => "1672118327"
"RoomType" => "Kitchen"
"ListingId" => "40844069"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29972328"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:39:48.33Z"
]
10 => array:11 [
"RoomKey" => "1672118328"
"RoomType" => "Foyer"
"ListingId" => "40844069"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29972328"
"RoomLength" => null
"RoomDimensions" => "13'8'' x 3'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:39:48.33Z"
]
11 => array:11 [
"RoomKey" => "1672118329"
"RoomType" => "Dining room"
"ListingId" => "40844069"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29972328"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:39:48.34Z"
]
12 => array:11 [
"RoomKey" => "1672118330"
"RoomType" => "Bedroom"
"ListingId" => "40844069"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29972328"
"RoomLength" => null
"RoomDimensions" => "15'10'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:39:48.34Z"
]
13 => array:11 [
"RoomKey" => "1672118331"
"RoomType" => "3pc Bathroom"
"ListingId" => "40844069"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29972328"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T19:39:48.35Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29972328_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/6ec6ea62f3bc9e356e45ef7894fa40b0.webp"
"MediaSize" => 162879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-6ec6ea62f3bc9e356e45ef7894fa40b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29972328_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/be377c8a4e47554a4c17ff962492f466.webp"
"MediaSize" => 161871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-be377c8a4e47554a4c17ff962492f466.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29972328_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/1a2503a0b9949da8f8ac5b1627cd3f83.webp"
"MediaSize" => 172934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-1a2503a0b9949da8f8ac5b1627cd3f83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29972328_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/5cac7e5d3402937c9da7f2671bd34ac9.webp"
"MediaSize" => 168157
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-5cac7e5d3402937c9da7f2671bd34ac9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29972328_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/775463c8445f47cb4d8a700a0463061f.webp"
"MediaSize" => 139633
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-775463c8445f47cb4d8a700a0463061f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29972328_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/c1c6ba282a46874cfbdbbf891e3f54b3.webp"
"MediaSize" => 152043
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-c1c6ba282a46874cfbdbbf891e3f54b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29972328_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/1c400864d71aa3be7b7d2e618464a895.webp"
"MediaSize" => 126930
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-1c400864d71aa3be7b7d2e618464a895.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29972328_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/497431e490a8563b151ed06bda3ce366.webp"
"MediaSize" => 61849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-497431e490a8563b151ed06bda3ce366.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29972328_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/79f2310f776bbe1dc089342f1e639313.webp"
"MediaSize" => 64400
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-79f2310f776bbe1dc089342f1e639313.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29972328_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/29dccac62bc686d72510d0a55ae649b2.webp"
"MediaSize" => 54301
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-29dccac62bc686d72510d0a55ae649b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29972328_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/3bf63305b96b5d0224fcb8663908f373.webp"
"MediaSize" => 51291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-3bf63305b96b5d0224fcb8663908f373.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29972328_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/3befb8724b07f2f9905f88f233318b71.webp"
"MediaSize" => 60148
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-3befb8724b07f2f9905f88f233318b71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29972328_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/9922446b65d889dd0bfe8616684d7d7b.webp"
"MediaSize" => 62428
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-9922446b65d889dd0bfe8616684d7d7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29972328_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/435133e43c7a06722741508e08ec72f6.webp"
"MediaSize" => 56733
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-435133e43c7a06722741508e08ec72f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29972328_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/61cc4505a93d34cdb9f6dba96b989952.webp"
"MediaSize" => 46914
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-61cc4505a93d34cdb9f6dba96b989952.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29972328_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/7adc183bcdecb4ed458a1c9b3939bc28.webp"
"MediaSize" => 43520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-7adc183bcdecb4ed458a1c9b3939bc28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29972328_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/be2692fb6fad5223e7fe8423c39820b6.webp"
"MediaSize" => 57874
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-be2692fb6fad5223e7fe8423c39820b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29972328_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/8f1a4e0af893533f19b636fcfd9198d3.webp"
"MediaSize" => 62417
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-8f1a4e0af893533f19b636fcfd9198d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29972328_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/ce439e9ec3637e8daff445f5f8c16e75.webp"
"MediaSize" => 57014
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-ce439e9ec3637e8daff445f5f8c16e75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29972328_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/5203370520c51ac1d464671ad7d54bf5.webp"
"MediaSize" => 57161
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-5203370520c51ac1d464671ad7d54bf5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29972328_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/285c28853b2feca1ac3897bbe790dfa4.webp"
"MediaSize" => 57692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-285c28853b2feca1ac3897bbe790dfa4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29972328_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/a28dfe557c044ceea17ecc125bf9f576.webp"
"MediaSize" => 66479
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-a28dfe557c044ceea17ecc125bf9f576.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29972328_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/2cbaac7779461d8620e9b69c125237bd.webp"
"MediaSize" => 56626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-2cbaac7779461d8620e9b69c125237bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29972328_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/69bbd3cc638aec82bfa0ff5f9f059a73.webp"
"MediaSize" => 49229
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-69bbd3cc638aec82bfa0ff5f9f059a73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29972328_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/58dc66ba51871636a6366878f36d7b4e.webp"
"MediaSize" => 46059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-58dc66ba51871636a6366878f36d7b4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29972328_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/27a509d64619455f21615a1c3e1ea7a0.webp"
"MediaSize" => 32530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-27a509d64619455f21615a1c3e1ea7a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29972328_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/f81a02ff3cda64d9b8e4209b41f3638b.webp"
"MediaSize" => 42415
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-f81a02ff3cda64d9b8e4209b41f3638b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29972328_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/a4e72b3347ef4d2583d941322c8b5ab5.webp"
"MediaSize" => 53988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-a4e72b3347ef4d2583d941322c8b5ab5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29972328_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/145a62d715532b4006a8f82b5f67468e.webp"
"MediaSize" => 50078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-145a62d715532b4006a8f82b5f67468e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29972328_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/dc10660e35e679e487daab15c8e1229b.webp"
"MediaSize" => 57503
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-dc10660e35e679e487daab15c8e1229b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29972328_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/915da02fe4a08495cf0b88b911aec16c.webp"
"MediaSize" => 80411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-915da02fe4a08495cf0b88b911aec16c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29972328_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/730593b8f2882ca2fd7408408e3bdb5c.webp"
"MediaSize" => 55900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-730593b8f2882ca2fd7408408e3bdb5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29972328_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/7dbddb59528e4d206a54163b728f48e6.webp"
"MediaSize" => 44588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-7dbddb59528e4d206a54163b728f48e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29972328_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/74483d1be69a22cc96c2c29f4f087ac4.webp"
"MediaSize" => 50957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-74483d1be69a22cc96c2c29f4f087ac4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29972328_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/d7683fdc2f84f58a58dcf56e9d73588b.webp"
"MediaSize" => 50250
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-d7683fdc2f84f58a58dcf56e9d73588b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29972328_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/1523e9cb2ea93a56190c8a58193015e0.webp"
"MediaSize" => 54293
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-1523e9cb2ea93a56190c8a58193015e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29972328_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/76a2b8fd1263b82fc2a666c2b35acc07.webp"
"MediaSize" => 54835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-76a2b8fd1263b82fc2a666c2b35acc07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29972328_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/c9700a488311b300c09f9dd637501f41.webp"
"MediaSize" => 55957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-c9700a488311b300c09f9dd637501f41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29972328_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/101d96e5453e1b897d7e4142c50b8734.webp"
"MediaSize" => 47278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-101d96e5453e1b897d7e4142c50b8734.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29972328_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/1e3b85728d301a0edd7a6d982830391b.webp"
"MediaSize" => 50992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-1e3b85728d301a0edd7a6d982830391b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29972328_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/f6d9d430954ddaad5751ce3231958dcb.webp"
"MediaSize" => 46340
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-f6d9d430954ddaad5751ce3231958dcb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29972328_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/d50852a263e6c8243e5767508bb2dfc2.webp"
"MediaSize" => 79490
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-d50852a263e6c8243e5767508bb2dfc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29972328_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/9fb4d5b6515de05bb3cc05a87e17da82.webp"
"MediaSize" => 163271
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-9fb4d5b6515de05bb3cc05a87e17da82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29972328_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/26b58fc5401a7352078e4912e75f2289.webp"
"MediaSize" => 171122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-26b58fc5401a7352078e4912e75f2289.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29972328_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/83f227fd5991e8ef5844826df8da2c3b.webp"
"MediaSize" => 155601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-83f227fd5991e8ef5844826df8da2c3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29972328_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/d70b25d0efd9be40ff7f27cbeecd88ee.webp"
"MediaSize" => 154124
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-d70b25d0efd9be40ff7f27cbeecd88ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29972328_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/509770dbcaabf250d8a7cf39afa3b78d.webp"
"MediaSize" => 149444
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-509770dbcaabf250d8a7cf39afa3b78d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29972328_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/de5bb537e9e3344681fccd19b6ed0931.webp"
"MediaSize" => 46122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-de5bb537e9e3344681fccd19b6ed0931.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "29972328_4890_49"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/d372325d5b0bfa6d8c8a1537fef673eb.webp"
"MediaSize" => 47897
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-d372325d5b0bfa6d8c8a1537fef673eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
49 => array:13 [
"Order" => 50
"MediaKey" => "29972328_4890_50"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972328/3aad75c075ebc7ed2b7cb5ee6598cedf.webp"
"MediaSize" => 37105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972328/thumbnail-3aad75c075ebc7ed2b7cb5ee6598cedf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844069"
"ResourceRecordKey" => "29972328"
"ModificationTimestamp" => "2026-06-30T19:39:48Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29972328')"
+"ID": "1580518"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 289541" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24919
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1908292" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24877
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29972328'" => 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.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29972328'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25300
+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 '29972328' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5255874 43.4697719)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25373
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25367
+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 [
"RoomKey" => "1672151377"
"RoomType" => "Kitchen"
"ListingId" => "X13506576"
"RoomLevel" => "Main level"
"RoomWidth" => 3.8
"ListingKey" => "29972695"
"RoomLength" => 4.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T20:23:25.34Z"
]
1 => array:11 [
"RoomKey" => "1672151378"
"RoomType" => "Utility room"
"ListingId" => "X13506576"
"RoomLevel" => "Main level"
"RoomWidth" => 1.9
"ListingKey" => "29972695"
"RoomLength" => 2.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T20:23:25.34Z"
]
2 => array:11 [
"RoomKey" => "1672151379"
"RoomType" => "Bedroom"
"ListingId" => "X13506576"
"RoomLevel" => "Main level"
"RoomWidth" => 3.1
"ListingKey" => "29972695"
"RoomLength" => 3.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T20:23:25.34Z"
]
3 => array:11 [
"RoomKey" => "1672151380"
"RoomType" => "Living room"
"ListingId" => "X13506576"
"RoomLevel" => "Main level"
"RoomWidth" => 3.7
"ListingKey" => "29972695"
"RoomLength" => 4.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T20:23:25.34Z"
]
4 => array:11 [
"RoomKey" => "1672151381"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13506576"
"RoomLevel" => "Main level"
"RoomWidth" => 3.4
"ListingKey" => "29972695"
"RoomLength" => 4.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T20:23:25.34Z"
]
5 => array:11 [
"RoomKey" => "1672151382"
"RoomType" => "Bathroom"
"ListingId" => "X13506576"
"RoomLevel" => "Main level"
"RoomWidth" => 1.6
"ListingKey" => "29972695"
"RoomLength" => 2.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T20:23:25.34Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29972695_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972695/62a6a84cb0ad39f6adb1663c4ff48c04.webp"
"MediaSize" => 231233
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972695/thumbnail-62a6a84cb0ad39f6adb1663c4ff48c04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13506576"
"ResourceRecordKey" => "29972695"
"ModificationTimestamp" => "2026-07-01T01:13:32.99Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29972695_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972695/926b182443c38df0206d944b75d457db.webp"
"MediaSize" => 258130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972695/thumbnail-926b182443c38df0206d944b75d457db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13506576"
"ResourceRecordKey" => "29972695"
"ModificationTimestamp" => "2026-07-01T01:14:05.99Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29972695_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972695/ad9b99accb82d5a3351e20ccf84a6022.webp"
"MediaSize" => 386037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972695/thumbnail-ad9b99accb82d5a3351e20ccf84a6022.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13506576"
"ResourceRecordKey" => "29972695"
"ModificationTimestamp" => "2026-07-01T01:14:08.22Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29972695_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972695/117fe1bf6f8955f6086af274b1140ade.webp"
"MediaSize" => 79851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972695/thumbnail-117fe1bf6f8955f6086af274b1140ade.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13506576"
"ResourceRecordKey" => "29972695"
"ModificationTimestamp" => "2026-07-01T01:14:07.24Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29972695_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972695/ae9fd7928c2ffec69b460f60003c8fad.webp"
"MediaSize" => 113405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972695/thumbnail-ae9fd7928c2ffec69b460f60003c8fad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13506576"
"ResourceRecordKey" => "29972695"
"ModificationTimestamp" => "2026-07-01T01:14:07.65Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29972695_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972695/94586fa28ece5a1d59c99ad2f2960a8e.webp"
"MediaSize" => 109016
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972695/thumbnail-94586fa28ece5a1d59c99ad2f2960a8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13506576"
"ResourceRecordKey" => "29972695"
"ModificationTimestamp" => "2026-07-01T01:14:07.24Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29972695_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972695/dd97c100427a723eb2f35a28cc4ab96f.webp"
"MediaSize" => 125156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972695/thumbnail-dd97c100427a723eb2f35a28cc4ab96f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13506576"
"ResourceRecordKey" => "29972695"
"ModificationTimestamp" => "2026-07-01T01:14:07Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29972695_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29972695/9e0baf503a6be923642f588977629b0b.webp"
"MediaSize" => 101288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29972695/thumbnail-9e0baf503a6be923642f588977629b0b.webp"
"ResourceName" => "Property"
…6
]
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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29972695')"
+"ID": "1581100"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25369
+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"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25366
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29971291')"
+"ID": "1579629"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25370
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29970323')"
+"ID": "1578689"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25368
+post_id: "1576482"
+post_author: 1
+"ListingKey": "29967867"
+"ListingId": "40843784"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T20:40:14Z"
+"RFModificationTimestamp": "2026-06-30T20:41:58Z"
+"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-06-30T20:31:29Z"
+"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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25363
+post_id: "1575808"
+post_author: 1
+"ListingKey": "29966422"
+"ListingId": "40842592"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T17:40:45Z"
+"RFModificationTimestamp": "2026-06-29T18:49:29Z"
+"ListPrice": 324900.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# 1004, Waterloo, Ontario N2L0E9"
+"Coordinates": array:2 [
0 => -80.5264715
1 => 43.4789254
]
+"Latitude": 43.4789254
+"Longitude": -80.5264715
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 318 Spruce Street, where comfort, convenience, and thoughtful design come together in a well-maintained building. This pristine, fully furnished turnkey suite offers a functional layout and is vacant for immediate occupancy, making it an ideal opportunity for students, working professionals, or investors. The modern kitchen features granite countertops, a breakfast bar, stylish backsplash, and stainless steel appliances. Enjoy the convenience of in-suite laundry, a private balcony, and one secure underground parking space. Residents have access to excellent building amenities, including a fitness centre, outdoor terrace, study area, guest suite, and social room. Low condo fees add to the value and affordability of this well-managed building. Ideally located within walking distance to both universities and Conestoga College, the condo is also close to restaurants, shopping, transit, parks, and a wide range of everyday amenities. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "429.68"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T18:49:24.358366+00:00"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1910159"
+"ListOfficeKey": "246041"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-29T17:31:53Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T17:31:53Z"
+"Stories": "1.0"
+"StreetName": "SPRUCE"
+"StreetNumber": "318"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3552.01"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=z3iR41awfNp"
+"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/29966422/318-spruce-street-unit-1004-waterloo"
+"ParkingTotal": 1
+"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-06-29T17:31:52.88Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1222261"
+"ListOfficeNationalAssociationId": "1202898"
+"Media": array:30 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29966422')"
+"ID": "1575808"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1576317"
+post_author: 1
+"ListingKey": "29966442"
+"ListingId": "40836179"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T17:40:45Z"
+"RFModificationTimestamp": "2026-06-29T18:49:17Z"
+"ListPrice": 1470000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2663.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2S8"
+"UnparsedAddress": "294 ALGONQUIN Drive, Waterloo, Ontario N2L2S8"
+"Coordinates": array:2 [
0 => -80.5462881
1 => 43.4644504
]
+"Latitude": 43.4644504
+"Longitude": -80.5462881
+"YearBuilt": 1961
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Architecturally Distinct Mid-Century Bungalow in Prestigious Beechwood. A rare opportunity to own a truly unique home in one of Waterloo's most sought-after neighbourhoods. Nestled within a private wooded enclave, this architecturally significant mid-century executive bungalow offers over 2,650 sq. ft. of thoughtfully designed living space and an exceptional connection to nature. Step inside and be captivated by soaring floor-to-ceiling windows that frame private views and fill the home with natural light. The spacious main level is designed for both everyday living and entertaining, featuring expansive principal rooms, a welcoming living and dining area with a striking double-sided fireplace, and multiple spaces to gather with family and friends. The lower level offers incredible flexibility with a walkout to the backyard, a large family room, two additional bedrooms or office, a full bathroom, and direct access to the garage—ideal for multi-generational living, guests, or a future in-law setup. Outside, enjoy your own private backyard retreat surrounded by mature trees, offering peace, privacy, and endless potential to create your dream outdoor oasis. Updates include windows, roof, hot water tank and boiler, electrical service, extensive landscaping. While some cosmetic updating may be desired, the home presents an outstanding opportunity to personalize a property with exceptional character in an unbeatable location. Virtual staging has been provided to show decorating potential. Situated just minutes from the University of Waterloo, top-rated schools, parks, trails, shopping, and amenities, this is a location rarely offered and highly coveted. Bring your vision and imagination or just move in—this remarkable Beechwood property is ready to become your forever home. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Sauna"
5 => "Central Vacuum"
6 => "Dishwasher"
7 => "Stove"
8 => "Dryer"
9 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:2 [
0 => "Window air conditioner"
1 => "None"
]
+"CreationDate": "2026-06-29T18:49:12.869016+00:00"
+"Directions": "Westmount Rd to Longfellow Dr. to Iroquois Pl. to Algonquin Dr."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Boiler"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1996603"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Ravine"
2 => "Paved driveway"
3 => "Automatic Garage Door Opener"
4 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T17:33:05Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T17:33:05Z"
+"Stories": "1.0"
+"StreetName": "ALGONQUIN"
+"StreetNumber": "294"
+"StreetSuffix": "Drive"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "7014"
+"VirtualTourURLUnbranded": "https://youriguide.com/7ypyq_294_algonquin_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29966442/294-algonquin-drive-waterloo"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 100.0
+"AboveGradeFinishedArea": 1651
+"BelowGradeFinishedArea": 1011
+"OriginalEntryTimestamp": "2026-06-29T17:33:05.3Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1279276"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29966442')"
+"ID": "1576317"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25371
+post_id: "1573197"
+post_author: 1
+"ListingKey": "29962363"
+"ListingId": "X13497274"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-27T14:20:02Z"
+"RFModificationTimestamp": "2026-06-27T14:36:18Z"
+"ListPrice": 405000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3M7"
+"UnparsedAddress": "810 - 318 SPRUCE ST STREET, Waterloo, Ontario N2L3M7"
+"Coordinates": array:2 [
0 => -80.526389
1 => 43.479
]
+"Latitude": 43.479
+"Longitude": -80.526389
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Sage ll - a 23-storey tower designed as a "recreational retreat" for students and young professionals in Waterloo's university district. This suite features 2 bedrooms / 2 washrooms with laminate flooring throughout and a sleek kitchen equipped with granite countertops, stainless steel appliances (including a built-in dishwasher), and ample storage. Enjoy a large open balcony with breathtaking city views, accessible via a walk-out from the main living area. Floor-to-ceiling windows in the bedrooms and living areas ensure the space is bright and inviting with natural light. Its also an Education Hub located within walking distance of Wilfrid Laurier University and just a 6-minute drive to the University of Waterloo. The Conestoga Waterloo Campus is also just 1.5 km away. Steps away from essential shopping like Walmart and No Frills, as well as numerous cafes, restaurants, and a cinema. Close to Express Hwy 85 and the LRT, with multiple bus routes (7 King, 31 Columbia, 201 iXpress) easily accessible for commuting across the Tri-Cities. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Blinds"
6 => "Window Coverings"
]
+"AssociationFee": "588.67"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Pets not Allowed"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-27T14:36:14.306704+00:00"
+"Directions": "Cross Streets: King St N & University Ave W. ** Directions: North on King St N, Left on Hickory St W then right on Spruce St."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1409777"
+"ListOfficeKey": "275778"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-27T14:12:55Z"
+"PhotosCount": 8
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-27T14:12:55Z"
+"StreetName": "Spruce St"
+"StreetNumber": "318"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4521"
+"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"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29962363/810-318-spruce-st-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Visitor Parking"
]
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-27T14:12:55.49Z"
+"ListAgentNationalAssociationId": "1047557"
+"ListOfficeNationalAssociationId": "1268116"
+"Media": array:8 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29962363')"
+"ID": "1573197"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25372
+post_id: "1571971"
+post_author: 1
+"ListingKey": "29961135"
+"ListingId": "X13496232"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T22:25:18Z"
+"RFModificationTimestamp": "2026-06-26T23:39:42Z"
+"ListPrice": 354000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0G2"
+"UnparsedAddress": "618 - 280 LESTER STREET, Waterloo, Ontario N2L0G2"
+"Coordinates": array:2 [
0 => -80.535648
1 => 43.475678
]
+"Latitude": 43.475678
+"Longitude": -80.535648
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 618 at Sage 5, a rare opportunity to own a bright 1-bedroom, 1-bathroom suite featuring floor-to-ceiling windows, unobstructed green views, and abundant natural light throughout. Occupied by only two residents since construction and exceptionally well maintained, this carpet-free home offers a functional layout with a spacious bedroom, large granite kitchen island, stainless steel appliances, and ensuite laundry. Enjoy the spacious balcony, accessible from both the living room and bedroom, overlooking peaceful greenery. Offered fully furnished, this move-in ready unit provides added convenience for both end-users and investors. Residents enjoy excellent amenities including a rooftop terrace, theatre room, fitness centre, student lounge, and study spaces. Ideally located in the heart of Waterloo's university district, just steps from the University of Waterloo, Wilfrid Laurier University, Waterloo Collegiate Institute, shopping, restaurants, and public transit. Condo fees include heat, , A/C, water, and high-speed internet. Ideal for parents, first-time buyers, and investors. Book your showing today! (id:62783)"
+"AssociationFee": "399.02"
+"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-26T23:39:32.064487+00:00"
+"Directions": "Cross Streets: Lester St & Hickory St. ** Directions: University Ave West to Lester St."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Stucco"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2248033"
+"ListOfficeKey": "291350"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T22:20:07Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T22:20:07Z"
+"StreetName": "Lester"
+"StreetNumber": "280"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3004.16"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29961135/618-280-lester-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Mgmt"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-06-26T22:20:07.24Z"
+"ListAgentNationalAssociationId": "1486907"
+"ListOfficeNationalAssociationId": "1396878"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29961135')"
+"ID": "1571971"
}
]
+success: true
+page_size: 9
+page_count: 47
+count: 421
+after_key: ""
}
"RF Response Time" => "0.19 seconds"
]
]