array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29840553 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23331
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23333
+post_id: "1485148"
+post_author: 1
+"ListingKey": "29840553"
+"ListingId": "40835791"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T20:30:48Z"
+"RFModificationTimestamp": "2026-06-06T20:47:50Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2262.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3S1"
+"UnparsedAddress": "60 MAYFIELD Avenue, Waterloo, Ontario N2J3S1"
+"Coordinates": array:2 [
0 => -80.5020119
1 => 43.4782336
]
+"Latitude": 43.4782336
+"Longitude": -80.5020119
+"YearBuilt": 1981
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This charming 2+2 bed raised bungalow in Lincoln Heights is perfect for environmentally aware buyers. The fully owned roof-top solar installation brings in $5500 in revenue each year until 2031. A panel upgrade in 2014 allows for not one, but two car chargers! Inside the home you'll find a fully renoed open concept main floor. The kitchen has a centre island, induction range and a walkout to the deck. The master bedroom is truly spacious with a good sized closet and a walk out to the back yard as well. Downstairs you'll find a second full bath, a rec-room and two more bedrooms. There's also an extra bonus space that you can do up as you choose. The backyard is a quiet oasis filled with mature trees. Enjoy the backyard deck and get your veggies from the planter boxes too. His and hers sheds complete the outside space. The larger of the two is fully insulated, heated, and even has power. The roof has 40 year shingles and most of the windows were replaced in 2015. Nearby you'll find great local schools and plenty of shopping. The expressway a minute away making commuting a breeze. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Water softener"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-02T18:20:03.165942+00:00"
+"Directions": "Off Bluevale, via Bridgeport or direct via University"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1985202"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
2 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-02T17:21:27Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T20:21:11Z"
+"Stories": "1.0"
+"StreetName": "MAYFIELD"
+"StreetNumber": "60"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "5657.42"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/60_mayfield_avenue_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1653464045"
"RoomType" => "Bonus Room"
"ListingId" => "40835791"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29840553"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:21:11.85Z"
]
1 => array:11 [
"RoomKey" => "1653464046"
"RoomType" => "Bedroom"
"ListingId" => "40835791"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29840553"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:21:11.85Z"
]
2 => array:11 [
"RoomKey" => "1653464047"
"RoomType" => "Bedroom"
"ListingId" => "40835791"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29840553"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:21:11.86Z"
]
3 => array:11 [
"RoomKey" => "1653464048"
"RoomType" => "3pc Bathroom"
"ListingId" => "40835791"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29840553"
"RoomLength" => null
"RoomDimensions" => "5'10'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:21:11.86Z"
]
4 => array:11 [
"RoomKey" => "1653464049"
"RoomType" => "Recreation room"
"ListingId" => "40835791"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29840553"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 16'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:21:11.86Z"
]
5 => array:11 [
"RoomKey" => "1653464050"
"RoomType" => "3pc Bathroom"
"ListingId" => "40835791"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29840553"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:21:11.86Z"
]
6 => array:11 [
"RoomKey" => "1653464051"
"RoomType" => "Bedroom"
"ListingId" => "40835791"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29840553"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:21:11.86Z"
]
7 => array:11 [
"RoomKey" => "1653464052"
"RoomType" => "Primary Bedroom"
"ListingId" => "40835791"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29840553"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 18'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:21:11.86Z"
]
8 => array:11 [
"RoomKey" => "1653464053"
"RoomType" => "Living room/Dining room"
"ListingId" => "40835791"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29840553"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 25'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:21:11.86Z"
]
9 => array:11 [
"RoomKey" => "1653464054"
"RoomType" => "Den"
"ListingId" => "40835791"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29840553"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 14'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:21:11.86Z"
]
10 => array:11 [
"RoomKey" => "1653464055"
"RoomType" => "Kitchen"
"ListingId" => "40835791"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29840553"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:21:11.86Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29840553/60-mayfield-avenue-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1273
+"BelowGradeFinishedArea": 989
+"OriginalEntryTimestamp": "2026-06-02T17:21:27.54Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1269822"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29840553_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/0232d17e8c8db6ab097f507eada27888.webp"
"MediaSize" => 164770
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-0232d17e8c8db6ab097f507eada27888.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick-clad facade with white siding accents and a paver driveway"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29840553_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/3cac1615de63b1ac21bf19888435a881.webp"
"MediaSize" => 222244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-3cac1615de63b1ac21bf19888435a881.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Mature trees frame a landscaped outdoor space featuring ground cover and natural foliage"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29840553_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/6599b2f1c5549ad5c27ad345091be142.webp"
"MediaSize" => 180027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-6599b2f1c5549ad5c27ad345091be142.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "White lattice archway opening to a paver patio"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29840553_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/e189bd1cf7b403e4b49fd3d254c82014.webp"
"MediaSize" => 175851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-e189bd1cf7b403e4b49fd3d254c82014.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exterior brick wall with white window trim and a stone window sill"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29840553_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/07e7cfdd4ac6ef6afc18422e063f1282.webp"
"MediaSize" => 135750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-07e7cfdd4ac6ef6afc18422e063f1282.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick facade with white latticework screens"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29840553_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/ae0e4c8fb47ff87b657e41bf23ed22dc.webp"
"MediaSize" => 62463
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-ae0e4c8fb47ff87b657e41bf23ed22dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a multi-light pendant fixture, leaded glass front door, tiled flooring, wainscoting, and large windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29840553_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/5f4519d269243de6435dd2d4247ec1c5.webp"
"MediaSize" => 63697
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-5f4519d269243de6435dd2d4247ec1c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dark-stained wood stairs with a matching handrail and white balusters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29840553_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/e68c9b77bedce63fdfec1d1270d85c62.webp"
"MediaSize" => 66844
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-e68c9b77bedce63fdfec1d1270d85c62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious open-concept living area featuring light wood-finish flooring, white walls, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29840553_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/f34ecdc6a7280712090db2e09b539e9a.webp"
"MediaSize" => 63780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-f34ecdc6a7280712090db2e09b539e9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright living area featuring wood-finish flooring, a large multi-pane window, and a ceiling-mounted pendant light fixture with a decorative medallion"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29840553_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/cb0394481eeafeca3eb6e3b68983f44a.webp"
"MediaSize" => 64028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-cb0394481eeafeca3eb6e3b68983f44a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright living area featuring a large picture window, wood-finish flooring, and a decorative half-wall partition with a built-in shelf"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29840553_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/cd440c0b608fc02320dd42819c8065fb.webp"
"MediaSize" => 63416
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-cd440c0b608fc02320dd42819c8065fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring, a contemporary pendant light fixture, and a partial wall divider"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29840553_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/6767e73a27fa212f102436f69543862a.webp"
"MediaSize" => 72341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-6767e73a27fa212f102436f69543862a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring light wood-finish flooring, white walls, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29840553_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/5d0a4d2a3026547b468f760c98f27d07.webp"
"MediaSize" => 68460
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-5d0a4d2a3026547b468f760c98f27d07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29840553_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/e7c3c23bb4d297a66c75144578c4e8d7.webp"
"MediaSize" => 56622
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-e7c3c23bb4d297a66c75144578c4e8d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright interior space with light-toned walls and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29840553_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/398a22fa64aa659de34781e919e36c9b.webp"
"MediaSize" => 78692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-398a22fa64aa659de34781e919e36c9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept room featuring light wood-finish flooring, white walls, and bright natural light from multiple windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29840553_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/4d67985481e81fdbe4051e90e3bdcc51.webp"
"MediaSize" => 57915
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-4d67985481e81fdbe4051e90e3bdcc51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept kitchen featuring light-toned wood flooring, recessed lighting, and an expansive center island with seating"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29840553_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/ef9a57fd2d6833c1d14179dcecf10027.webp"
"MediaSize" => 75593
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-ef9a57fd2d6833c1d14179dcecf10027.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen island with stone-finish countertop, undermount sink, and integrated dishwasher"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29840553_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/9a933fdaf2b7eaf5e1c5c5e998c40b6e.webp"
"MediaSize" => 80350
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-9a933fdaf2b7eaf5e1c5c5e998c40b6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring a large central island with seating, stainless steel appliances, light wood-finish flooring, white cabinetry, and a stacked stone backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29840553_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/2edae60022a0477b6fca07d085125c05.webp"
"MediaSize" => 80618
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-2edae60022a0477b6fca07d085125c05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring light-toned cabinetry, multi-toned tile backsplash, dark stone countertops, and stainless steel appliances"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29840553_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/551643f29ce13eb7ff2e6b3b649b41ad.webp"
"MediaSize" => 64320
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-551643f29ce13eb7ff2e6b3b649b41ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen island featuring a dark countertop, undermount sink with a gooseneck faucet, and integrated dishwasher"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29840553_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/d8ccd64d82c145e926fbbf1b796008a5.webp"
"MediaSize" => 68005
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-d8ccd64d82c145e926fbbf1b796008a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring a central island with a dark countertop and pendant lighting, stainless steel appliances, extensive white cabinetry, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29840553_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/8e027c72943317748fb0400ccc50f840.webp"
"MediaSize" => 88775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-8e027c72943317748fb0400ccc50f840.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hardwood-finish flooring throughout, featuring a corner-mounted fireplace with a floating mantel"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29840553_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/569e93ad90bb1e76a00bd19c4554b0ba.webp"
"MediaSize" => 88991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-569e93ad90bb1e76a00bd19c4554b0ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29840553_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/175b168a5578847cabec3934a3af924f.webp"
"MediaSize" => 86372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-175b168a5578847cabec3934a3af924f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring a corner fireplace with a dark mantel, wood-finish flooring, and a ceiling fan with light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29840553_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/37c66874e3347c6649ac6270ef47253f.webp"
"MediaSize" => 51583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-37c66874e3347c6649ac6270ef47253f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway featuring wood-finish flooring, recessed lighting, and white paneled doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29840553_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/b7b0bf3c5eea3d2bfe1c3076366990a7.webp"
"MediaSize" => 63196
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-b7b0bf3c5eea3d2bfe1c3076366990a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a glass-enclosed shower with a built-in bench, subway tile surround, and dark tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29840553_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/902170cb678216391826389fe654905f.webp"
"MediaSize" => 38897
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-902170cb678216391826389fe654905f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a navy blue vanity with a white countertop and integrated sink, a glass-enclosed shower with subway tile surround, an oval mirror, and a three-light vanity fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29840553_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/1eb23d0410c7ac4c631187a0cc73c0b0.webp"
"MediaSize" => 78293
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-1eb23d0410c7ac4c631187a0cc73c0b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Parquet wood-finish flooring with a white and blue wall treatment"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29840553_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/caf95b16cca214ed381f25eca1eff426.webp"
"MediaSize" => 65075
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-caf95b16cca214ed381f25eca1eff426.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted room with a large window and double glass doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29840553_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/dbd9c93f5939e018fe87e168c9430556.webp"
"MediaSize" => 59674
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-dbd9c93f5939e018fe87e168c9430556.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted room featuring a white door, a single window with blinds, and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29840553_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/546365d30c9a81593e86a7196bf566da.webp"
"MediaSize" => 80592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-546365d30c9a81593e86a7196bf566da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Custom closet organization system featuring a central built-in wood-finish shelving unit"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29840553_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/13d14d8281a314b1688cfc194c16d76c.webp"
"MediaSize" => 57264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-13d14d8281a314b1688cfc194c16d76c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dark-toned staircase with white risers and a contrasting dark handrail"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29840553_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/55026b00d1e349ac0008285075afe53c.webp"
"MediaSize" => 68735
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-55026b00d1e349ac0008285075afe53c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted living space featuring recessed window, a flush-mounted light fixture, and white baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29840553_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/a0faedc89671a3ab85ae91f2a427e325.webp"
"MediaSize" => 77044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-a0faedc89671a3ab85ae91f2a427e325.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious recreation room featuring light-colored carpeting, white walls, and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29840553_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/045acf30805e87e69600868cf9519fa9.webp"
"MediaSize" => 78291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-045acf30805e87e69600868cf9519fa9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room with light-toned carpeting and white walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29840553_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/02ff6aa15d5461db3c984da07dbc94f0.webp"
"MediaSize" => 75292
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-02ff6aa15d5461db3c984da07dbc94f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Wall-to-wall carpeting and white walls define this room, featuring a natural wood barn door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29840553_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/202a11bf4f3f634ae58c13281f2d3a0f.webp"
"MediaSize" => 73453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-202a11bf4f3f634ae58c13281f2d3a0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted bedroom with a window, textured ceiling, and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29840553_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/d2a8965997810ed894b86ddb4b426552.webp"
"MediaSize" => 84009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-d2a8965997810ed894b86ddb4b426552.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light blue walls with a chair rail, a multi-pane window, and carpet flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29840553_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/5b480b9ce62061214476e3018fbc09d4.webp"
"MediaSize" => 74387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-5b480b9ce62061214476e3018fbc09d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with neutral carpet flooring and light blue walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29840553_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/f27e5ac205d3a2a86896c828ab09d9bb.webp"
"MediaSize" => 59334
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-f27e5ac205d3a2a86896c828ab09d9bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Interior hallway featuring wood-finish flooring, light yellow walls, and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29840553_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/4bca255d5bb52a93bd20ae3450d40251.webp"
"MediaSize" => 71570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-4bca255d5bb52a93bd20ae3450d40251.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a glass-enclosed shower with subway tile surround, dark wood-finish vanity with an undermount sink, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29840553_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/538b5d2fe30b005f25af49b51883a5b8.webp"
"MediaSize" => 81243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-538b5d2fe30b005f25af49b51883a5b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29840553_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/2c1a63b1815b7458bece5c9c9497e997.webp"
"MediaSize" => 50704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-2c1a63b1815b7458bece5c9c9497e997.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry area featuring front-loading washer and dryer units"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29840553_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/7e35671abe5fe766a0fc57c879cee7b1.webp"
"MediaSize" => 145578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-7e35671abe5fe766a0fc57c879cee7b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior with white siding accents and a pitched roofline"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29840553_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/ec122257a3ee4ca63dd2c03ddd90b2bc.webp"
"MediaSize" => 179382
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-ec122257a3ee4ca63dd2c03ddd90b2bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29840553_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/13c775d7e9de3308720c0dc052f97b2c.webp"
"MediaSize" => 141291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-13c775d7e9de3308720c0dc052f97b2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious wood-finish deck with a fabric shade canopy"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29840553_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/a2ee51e4ca7d26705593ec5a81454a79.webp"
"MediaSize" => 125283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-a2ee51e4ca7d26705593ec5a81454a79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive wood-finish deck featuring a retractable fabric awning, full-height sliding glass doors, brick exterior, and wood railing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29840553_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/6730c2f35a982ff4a5fdfeea5cbcfbb8.webp"
"MediaSize" => 204726
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-6730c2f35a982ff4a5fdfeea5cbcfbb8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Landscaped garden path featuring mature trees and established plantings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "29840553_4890_49"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/52a2c09fa72b92f309e212069c8676dc.webp"
"MediaSize" => 188963
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-52a2c09fa72b92f309e212069c8676dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Detached outbuilding with dark siding and a contrasting dark roofline"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
49 => array:13 [
"Order" => 50
"MediaKey" => "29840553_4890_50"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840553/df55d0a6b9a27fde2838266fade7a505.webp"
"MediaSize" => 113121
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840553/thumbnail-df55d0a6b9a27fde2838266fade7a505.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835791"
"ResourceRecordKey" => "29840553"
"ModificationTimestamp" => "2026-06-02T17:21:27.55Z"
]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29840553')"
+"ID": "1485148"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 289541" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24712
+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 1985202" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24797
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29840553'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25127
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29840553'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25142
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25143
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31313848"
+"ListingKey": "29840553"
+"ListingId": "40835791"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-07"
+"OpenHouseStartTime": "2026-06-07T14:00:00Z"
+"OpenHouseEndTime": "2026-06-07T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-06T20:13:09Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31313848')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25145
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31313849"
+"ListingKey": "29840553"
+"ListingId": "40835791"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-06"
+"OpenHouseStartTime": "2026-06-06T14:00:00Z"
+"OpenHouseEndTime": "2026-06-06T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-06T20:13:09Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31313849')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29840553' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5020119 43.4782336)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25240
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25214
+post_id: "1502275"
+post_author: 1
+"ListingKey": "29864897"
+"ListingId": "40837030"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T01:15:21Z"
+"RFModificationTimestamp": "2026-06-06T01:35:14Z"
+"ListPrice": 888000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2104.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3H6"
+"UnparsedAddress": "8 HICKORY Street W Unit# 1105, Waterloo, Ontario N2L3H6"
+"Coordinates": array:2 [
0 => -80.5261101
1 => 43.4781786
]
+"Latitude": 43.4781786
+"Longitude": -80.5261101
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Luxury Penthouse Living in the Heart of Waterloo – Fully Furnished, Turn-Key & Prime Investment Opportunity. Experience exceptional penthouse living in this spectacular two-level suite, perfectly positioned on the top (11th) floor of a modern, upscale Waterloo residence. Offering over 2,100 sq. ft. of beautifully finished living space, this rare property combines sophisticated design, sweeping sunset views, and unmatched convenience; just steps from Wilfrid Laurier University and the University of Waterloo. Flooded with natural light, the contemporary 5-bedroom, 5-bathroom layout includes a dramatic two-storey lounge with soaring 20-ft ceilings, an open-concept gourmet kitchen complete with a large island and walk-in pantry, and full in-suite laundry. Spacious bedrooms feature private ensuite bathrooms, while the fifth bedroom enjoys direct access to the impressive two-storey balcony; an ideal space for entertaining or relaxing with panoramic city views. Thoughtfully furnished and fully equipped with appliances, this penthouse is entirely turn-key, offering a premium rental rate already secured - a hassle-free opportunity for both student housing and executive rental investors. Located in a high-demand neighbourhood, residents also benefit from outstanding building amenities including a fitness centre, social lounge, underground parking, and secure bike storage. note: Some images include virtual staging for illustration purposes. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "998.31"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Water"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-06T01:35:03.202741+00:00"
+"Directions": "King North / Hickory"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1992499"
+"ListOfficeKey": "274404"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-06T01:11:33Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T01:11:33Z"
+"Stories": "2.0"
+"StreetDirSuffix": "West"
+"StreetName": "HICKORY"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "7878"
+"View": "City view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1652869506"
"RoomType" => "Laundry room"
"ListingId" => "40837030"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29864897"
"RoomLength" => null
"RoomDimensions" => "5'6'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T01:09:24.27Z"
]
1 => array:11 [
"RoomKey" => "1652869507"
"RoomType" => "3pc Bathroom"
"ListingId" => "40837030"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29864897"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T01:09:24.28Z"
]
2 => array:11 [
"RoomKey" => "1652869508"
"RoomType" => "3pc Bathroom"
"ListingId" => "40837030"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29864897"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T01:09:24.28Z"
]
3 => array:11 [
"RoomKey" => "1652869509"
"RoomType" => "3pc Bathroom"
"ListingId" => "40837030"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29864897"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T01:09:24.28Z"
]
4 => array:11 [
"RoomKey" => "1652869510"
"RoomType" => "Bedroom"
"ListingId" => "40837030"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29864897"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T01:09:24.28Z"
]
5 => array:11 [
"RoomKey" => "1652869511"
"RoomType" => "Bedroom"
"ListingId" => "40837030"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29864897"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 15'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T01:09:24.28Z"
]
6 => array:11 [
"RoomKey" => "1652869512"
"RoomType" => "Bedroom"
"ListingId" => "40837030"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29864897"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 15'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T01:09:24.28Z"
]
7 => array:11 [
"RoomKey" => "1652869513"
"RoomType" => "Sitting room"
"ListingId" => "40837030"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29864897"
"RoomLength" => null
"RoomDimensions" => "15'5'' x 12'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T01:09:24.28Z"
]
8 => array:11 [
"RoomKey" => "1652869514"
"RoomType" => "4pc Bathroom"
"ListingId" => "40837030"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29864897"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T01:09:24.28Z"
]
9 => array:11 [
"RoomKey" => "1652869515"
"RoomType" => "3pc Bathroom"
"ListingId" => "40837030"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29864897"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T01:09:24.28Z"
]
10 => array:11 [
"RoomKey" => "1652869516"
"RoomType" => "Bedroom"
"ListingId" => "40837030"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29864897"
"RoomLength" => null
…4
]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29864897/8-hickory-street-w-unit-1105-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Monitored Alarm"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 2104
+"OriginalEntryTimestamp": "2026-06-06T01:09:24.25Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1275774"
+"ListOfficeNationalAssociationId": "1254957"
+"Media": array:24 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29864897')"
+"ID": "1502275"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25216
+post_id: "1501614"
+post_author: 1
+"ListingKey": "29863858"
+"ListingId": "X13259750"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T22:00:35Z"
+"RFModificationTimestamp": "2026-06-05T22:47:25Z"
+"ListPrice": 349900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4T3"
+"UnparsedAddress": "302 - 55 BLUE SPRINGS DRIVE, Waterloo, Ontario N2J4T3"
+"Coordinates": array:2 [
0 => -80.5227793
1 => 43.4871052
]
+"Latitude": 43.4871052
+"Longitude": -80.5227793
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to "The Atriums" - condo living at its best! Tucked away at the end of a quiet cul-de-sac and surrounded by scenic walking trails, ponds, and lush green space, this location offers a peaceful and serene lifestyle. This exceptionally spacious 1,156 sq. ft. unit is highly recommended for seniors and downsizers seeking comfort and convenience on a single level. Featuring 2 generously sized bedrooms and 2 full 4-piece bathrooms, the functional layout provides a large living room designed for relaxation and ease of movement. Large windows throughout the home allow for incredible natural light to fill the space. The building and unit offer excellent wheelchair accessibility, featuring a secure elevator, wide common areas, step-free access from the secure underground parking space to the unit, and an owned storage locker for easy utility. This well-managed building provides a fantastic array of amenities tailored for a vibrant community lifestyle, including a cozy library, a giant party room with a kitchen, a games room, a guest suite for overnight visitors, a rooftop terrace with amazing views, and plenty of visitor parking. For ultimate convenience, the unit includes in-suite laundry and central air conditioning. Ideally situated in a prime urban location within walking distance to groceries, shops, and restaurants, and just minutes to Uptown Waterloo and Conestoga Mall. This address also offers unbeatable access to the expressway, transit, local schools, and major universities. Flexible possession is available! (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Stove"
2 => "Dryer"
3 => "Hood Fan"
]
+"AssociationFee": "709.97"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Water"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T22:47:18.676969+00:00"
+"Directions": "Cross Streets: King St. N & Blue Springs. ** Directions: King Street North to Blue Springs Dr and/or Weber St N to Forwell Creek Road."
+"ExteriorFeatures": array:2 [
0 => "Steel"
1 => "Brick Facing"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2188755"
+"ListOfficeKey": "291409"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Backs on greenbelt"
1 => "Carpet Free"
2 => "In suite Laundry"
3 => "Guest Suite"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-05T21:53:57Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T21:53:57Z"
+"StreetName": "Blue Springs"
+"StreetNumber": "55"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "2507"
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29863858/302-55-blue-springs-drive-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1418255"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "CIE Property Management"
+"CoListOfficeKey": "90198"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-05T21:53:57.32Z"
+"ListAgentNationalAssociationId": "1437820"
+"ListOfficeNationalAssociationId": "1397659"
+"CoListAgentNationalAssociationId": "1105101"
+"CoListOfficeNationalAssociationId": "1153615"
+"Media": array:44 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29863858')"
+"ID": "1501614"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25213
+post_id: "1500809"
+post_author: 1
+"ListingKey": "29863410"
+"ListingId": "40837051"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T21:20:35Z"
+"RFModificationTimestamp": "2026-06-05T21:34:33Z"
+"ListPrice": 349900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1156.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4T3"
+"UnparsedAddress": "55 BLUE SPRINGS Drive Unit# 302, Waterloo, Ontario N2J4T3"
+"Coordinates": array:2 [
0 => -80.5230914
1 => 43.4872105
]
+"Latitude": 43.4872105
+"Longitude": -80.5230914
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to The Atriums – condo living at its best! Tucked away at the end of a quiet cul-de-sac and surrounded by scenic walking trails, ponds, and lush green space, this location offers a peaceful and serene lifestyle. This exceptionally spacious 1,156 sq. ft. unit is highly recommended for seniors and downsizers seeking comfort and convenience on a single level. Featuring 2 generously sized bedrooms and 2 full 4-piece bathrooms, the functional layout provides a large living room designed for relaxation and ease of movement. Large windows throughout the home allow for incredible natural light to fill the space. The building and unit offer excellent wheelchair accessibility, featuring a secure elevator, wide common areas, step-free access from the secure underground parking space to the unit, and an owned storage locker for easy utility. This well-managed building provides a fantastic array of amenities tailored for a vibrant community lifestyle, including a cozy library, a giant party room with a kitchen, a games room, a guest suite for overnight visitors, a rooftop terrace with amazing views, and plenty of visitor parking. For ultimate convenience, the unit includes in-suite laundry and central air conditioning. Ideally situated in a prime urban location within walking distance to groceries, shops, and restaurants, and just minutes to Uptown Waterloo and Conestoga Mall. This address also offers unbeatable access to the expressway, transit, local schools, and major universities. Flexible possession is available! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
]
+"AssociationFee": "709.97"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Water"
4 => "Insurance"
5 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T21:34:26.815920+00:00"
+"Directions": "King Street North to Blue Springs Dr and/or Weber St N to Forwell Creek Road"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Metal"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2180828"
+"ListOfficeKey": "290853"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Southern exposure"
2 => "Conservation/green belt"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-05T21:10:21Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T21:10:21Z"
+"Stories": "1.0"
+"StreetName": "BLUE SPRINGS"
+"StreetNumber": "55"
+"StreetSuffix": "Drive"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "2507"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29863410/55-blue-springs-drive-unit-302-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Guest Suite"
1 => "Party Room"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1156
+"OriginalEntryTimestamp": "2026-06-05T21:10:21.1Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1430684"
+"ListOfficeNationalAssociationId": "1394395"
+"Media": array:44 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29863410')"
+"ID": "1500809"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25217
+post_id: "1499986"
+post_author: 1
+"ListingKey": "29861307"
+"ListingId": "X13248670"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T17:40:54Z"
+"RFModificationTimestamp": "2026-06-05T18:43:22Z"
+"ListPrice": 450000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2X9"
+"UnparsedAddress": "710 - 128 KING STREET N, Waterloo, Ontario N2J2X9"
+"Coordinates": array:2 [
0 => -80.523425
1 => 43.47038
]
+"Latitude": 43.47038
+"Longitude": -80.523425
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To One28 Condos On King Street. This Newest Uptown Waterloo Condo Comes With 9 Feet Ceiling. Amazing 1 Bed+Den Unit Used As 2 Bedroom or office On 7th Floor Comes With Very Open Concept. Spacious Living, Dining, Kitchen Area & Walk Out To Balcony, Stainless Steel Appliances, Quartz Countertops - In-Suite Laundry - Laminate Floors. Nice Size Bedroom With East View From Balcony, Easy Access To Ion Lrt Transit, Close Proximity To Waterloo And Laurier University, Downtown Waterloo, Shops & Nice Restaurants (id:62783)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Microwave"
]
+"AssociationFee": "370"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T18:43:16.033499+00:00"
+"Directions": "Cross Streets: King Street North & Elgin St. ** Directions: King St. North/University Ave. W/ Elgin Street."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2135106"
+"ListOfficeKey": "50929"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-05T17:33:12Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T17:33:12Z"
+"StreetDirSuffix": "North"
+"StreetName": "King"
+"StreetNumber": "128"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3754"
+"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/29861307/710-128-king-street-n-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2130202"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Cie Property Mngt & Consu"
+"CoListOfficeKey": "70066"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-05T17:33:12.21Z"
+"ListAgentNationalAssociationId": "1387492"
+"ListOfficeNationalAssociationId": "1003013"
+"CoListAgentNationalAssociationId": "1383190"
+"CoListOfficeNationalAssociationId": "1132867"
+"Media": array:27 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29861307')"
+"ID": "1499986"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25215
+post_id: "1499428"
+post_author: 1
+"ListingKey": "29858591"
+"ListingId": "40835405"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T21:10:51Z"
+"RFModificationTimestamp": "2026-06-06T21:25:03Z"
+"ListPrice": 329900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 900.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4Z5"
+"UnparsedAddress": "139 BRIGHTON Street Unit# 3C, Waterloo, Ontario N2J4Z5"
+"Coordinates": array:2 [
0 => -80.5183915
1 => 43.4711804
]
+"Latitude": 43.4711804
+"Longitude": -80.5183915
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This well maintained 2-bedroom, 1-bathroom stacked townhouse-style condo is perfect for first-time buyers, downsizers, or investors. Features an updated kitchen with stainless steel appliances, quartz counters and tiled backsplash, main floor in-suite laundry adds everyday convenience, along with main floor bedroom with generous closet space. An updated 4-piece bathroom complete the main level. Second bedroom is located on upper level. Just minutes from Wilfrid Laurier University, the University of Waterloo, major transit routes, 10min walk to uptown Waterloo, and all essential amenities, this home offers unbeatable convenience. Move-in ready and waiting for its new owner. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"AssociationFee": "377.41"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T18:05:20.855494+00:00"
+"Directions": "Noecker Street"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564020"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Paved driveway"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-05T11:49:54Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T21:01:43Z"
+"Stories": "2.0"
+"StreetName": "BRIGHTON"
+"StreetNumber": "139"
+"StreetSuffix": "Street"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "2567.19"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/139-Brighton-St-3c"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29858591/139-brighton-street-unit-3c-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 900
+"OriginalEntryTimestamp": "2026-06-05T11:49:54.31Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1120111"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29858591')"
+"ID": "1499428"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25210
+post_id: "1498869"
+post_author: 1
+"ListingKey": "29859011"
+"ListingId": "40836651"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T13:41:02Z"
+"RFModificationTimestamp": "2026-06-05T17:18:10Z"
+"ListPrice": 559900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1137.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4S3"
+"UnparsedAddress": "6 WILLOW Street Unit# 1907, Waterloo, Ontario N2J4S3"
+"Coordinates": array:2 [
0 => -80.5162327
1 => 43.4658906
]
+"Latitude": 43.4658906
+"Longitude": -80.5162327
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 1907 at 6 Willow Street in Waterloo! This bright and inviting 2-bedroom, 1-bathroom condo offers comfortable living in a quiet, well-maintained building just minutes from Uptown Waterloo. Large windows fill the home with natural light and city views as far as the eye can see. The light filled space highlights the hardwood flooring that runs throughout the main living areas and bedrooms. The functional eat-in kitchen features updated stainless steel appliances and ample cabinet space, making meal preparation a breeze. A spacious den/family room provides additional living space that can be used as a home office, reading nook, or entertainment area. The renovated 3-piece bathroom showcases a modern walk-in shower, adding both style and convenience. Residents enjoy an impressive selection of building amenities including an indoor pool, sauna, exercise room, games room, library, party room, guest suites, elevator access, and visitor parking. The unit also includes one underground parking space for added convenience. Located in a peaceful neighbourhood close to Uptown Waterloo, you'll enjoy easy access to shopping, restaurants, parks, public transit, and all the amenities this vibrant community has to offer. Whether you're a first-time buyer, downsizer, or investor, this well-appointed condo offers an excellent opportunity in a sought-after Waterloo location. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "769.92"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Water"
4 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T17:17:56.695403+00:00"
+"Directions": "Erb St. E to Willow St."
+"ExteriorFeatures": array:1 [
0 => "Other"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908292"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-05T13:30:56Z"
+"PhotosCount": 41
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T13:30:56Z"
+"Stories": "1.0"
+"StreetName": "WILLOW"
+"StreetNumber": "6"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "3973"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youriguide.com/1907_6_willow_street_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29859011/6-willow-street-unit-1907-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": "RMU-81"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1137
+"OriginalEntryTimestamp": "2026-06-05T13:30:56.63Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1221205"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29859011')"
+"ID": "1498869"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23345
+post_id: "1498871"
+post_author: 1
+"ListingKey": "29859294"
+"ListingId": "40837079"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T20:30:54Z"
+"RFModificationTimestamp": "2026-06-06T20:46:33Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1549.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3N5"
+"UnparsedAddress": "455 BOETTGER Place, Waterloo, Ontario N2K3N5"
+"Coordinates": array:2 [
0 => -80.5024643
1 => 43.4962144
]
+"Latitude": 43.4962144
+"Longitude": -80.5024643
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "OPEN HOUSE SAT. June 6th (2-4). Welcome to 455 Boettger Place, tucked away on a quiet cul-de-sac in Waterloo’s sought-after family-friendly neighbourhood of Lincoln Village. From the charming front porch to the peaceful backyard pond view, this is the kind of home that feels welcoming the moment you arrive. Step inside and appreciate the bright open-concept design that keeps everyone connected. Whether you're hosting family gatherings, helping with homework at the kitchen island, or entertaining friends, this home was designed for comfortable everyday living. The kitchen is truly the heart of the home, complete with stainless steel appliances, a large centre island that naturally becomes the gathering place, and a beautiful bay window overlooking the front yard. The spacious living room is warm and inviting with a walkout to the backyard oasis. The fully fenced backyard is where this property truly shines with mature trees, a concrete patio, and a gazebo, which creates a peaceful retreat right at home. Summer BBQs, quiet evenings and outdoor entertaining are all ready to be enjoyed. Upstairs, you’ll find three good-sized bedrooms, all with closets and natural light, along with an updated 4-piece bathroom (2024) featuring modern finishes. The finished lower level offers valuable extra living space perfect for a rec room, home gym, office, hobby room, or kids’ play area. An updated 3-piece bathroom and plenty of storage add even more function to the space. This home has been well cared for with important updates, including freshly painted neutral décor and updated lighting (2026), Furnace & A/C (2025), updated bathrooms (2024), and a durable Green Metal Roof and Eaves Guard (2021). The location is exceptional, close to golfing, Kiwanis Park, Snyder's Flats Conservation Area, RIM Park, the Walter Bean Trail, schools, shopping, and highway access. This is more than just a house... It’s a place to truly feel at home. Call your REALTOR® today and come see for yourself! (id:62783)"
+"Appliances": array:8 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T17:12:17.515342+00:00"
+"Directions": "Bridge St. W. to Dansbury Dr. to Boettger Pl."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564736"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Paved driveway"
2 => "Gazebo"
3 => "Sump Pump"
]
+"PhotosChangeTimestamp": "2026-06-05T14:20:06Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T20:20:16Z"
+"Stories": "2.0"
+"StreetName": "BOETTGER"
+"StreetNumber": "455"
+"StreetSuffix": "Place"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "3372.84"
+"VirtualTourURLUnbranded": "https://youriguide.com/455_boettger_pl_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/29859294/455-boettger-place-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SD1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 33.0
+"AboveGradeFinishedArea": 1076
+"BelowGradeFinishedArea": 473
+"OriginalEntryTimestamp": "2026-06-05T14:20:05.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1126313"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:43 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29859294')"
+"ID": "1498871"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25218
+post_id: "1497727"
+post_author: 1
+"ListingKey": "29858144"
+"ListingId": "X13245830"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T02:40:13Z"
+"RFModificationTimestamp": "2026-06-05T03:01:21Z"
+"ListPrice": 888000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3H6"
+"UnparsedAddress": "1105 - 8 HICKORY STREET W, Waterloo, Ontario N2L3H6"
+"Coordinates": array:2 [
0 => -80.5261295
1 => 43.4781827
]
+"Latitude": 43.4781827
+"Longitude": -80.5261295
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Luxury Penthouse Living in the Heart of Waterloo - Fully Furnished, Turn-Key & Prime Investment Opportunity. Experience exceptional penthouse living in this spectacular two-level suite, perfectly positioned on the top (11th) floor of a modern, upscale Waterloo residence. Offering over 2,100 sq. ft. of beautifully finished living space, this rare property combines sophisticated design, sweeping sunset views, and unmatched convenience; just steps from Wilfrid Laurier University and the University of Waterloo. Flooded with natural light, the contemporary 5-bedroom, 5-bathroom layout includes a dramatic two-storey lounge with soaring 20-ft ceilings, an open-concept gourmet kitchen complete with a large island and walk-in pantry, and full in-suite laundry. Spacious bedrooms feature private ensuite bathrooms, while the fifth bedroom enjoys direct access to the impressive two-storey balcony; an ideal space for entertaining or relaxing with panoramic city views. Thoughtfully furnished and fully equipped with appliances, this penthouse is entirely turn-key, offering a premium rental rate already secured - a hassle-free opportunity for both student housing and executive rental investors. Located in a high-demand neighbourhood, residents also benefit from outstanding building amenities including a fitness centre, social lounge, underground parking, and secure bike storage. note: Some images include virtual staging for illustration purposes. (id:66098)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "998.31"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T03:01:09.919156+00:00"
+"Directions": "Cross Streets: King. ** Directions: King North / Hickory."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Concrete Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2252863"
+"ListOfficeKey": "285253"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Other"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-05T02:32:24Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T02:32:24Z"
+"StreetDirSuffix": "West"
+"StreetName": "Hickory"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7878"
+"ListAOR": "OnePoint"
+"TaxYear": 2025
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29858144/1105-8-hickory-street-w-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 2249
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 5
+"OriginalEntryTimestamp": "2026-06-05T02:32:24.74Z"
+"ListAgentNationalAssociationId": "1491850"
+"ListOfficeNationalAssociationId": "1349485"
+"Media": array:23 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29858144')"
+"ID": "1497727"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25239
+post_id: "1493409"
+post_author: 1
+"ListingKey": "29851946"
+"ListingId": "40836587"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T20:30:52Z"
+"RFModificationTimestamp": "2026-06-06T20:47:37Z"
+"ListPrice": 475000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1245.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2C1"
+"UnparsedAddress": "279 SANDOWNE Drive Unit# 32, Waterloo, Ontario N2K2C1"
+"Coordinates": array:2 [
0 => -80.5048607
1 => 43.4910648
]
+"Latitude": 43.4910648
+"Longitude": -80.5048607
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautifully updated 3 bdrm, 2 bath townhouse in desirable Waterloo location. Just steps to Sandowne public school, the location is ideal for a young family, first-time buyer or investor. The main level features a nicely appointed kitchen with appliances included, a dining area, and a spacious living room. There is also a powder room on the main level with a convenient pocket door. Upstairs, you’ll find the modernized bathroom with gorgeous tile shower and vanity. Each bedroom is generously sized and the updated wooden stairs and railings add a modern look and feel to the home. The main living area on all floors is carpet free. The finished basement provides extra living space with a large rec room with new flooring, plenty of storage, laundry area and a rough-in for a bathroom. Step outside to enjoy your private patio and the convenient carport. This move-in ready home is in a well-established, family-friendly neighbourhood, and only minutes away from schools, parks, shopping and everyday amenities. It is close to Conestoga Mall, nearby restaurants, transit routes, and major roadways. This home has it all, from the remodeled main bathroom, updated kitchen, luxury vinyl flooring, modern stairs, nest thermostat, heat pump & furnace (2024), California stucco ceilings, and neutral décor throughout. In addition, the Condo Corp maintains the building and grounds exceptionally well with recent updates including; newer roof, concrete walkways, basement windows, eavestroughs and more. Additional parking is available at no charge and is only steps away. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"AssociationFee": "540"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T14:36:03.246715+00:00"
+"Directions": "Lexington to Dunvegan to Sandowne"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1672317"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Carport"
1 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-04T13:21:24Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T20:20:30Z"
+"Stories": "2.0"
+"StreetName": "SANDOWNE"
+"StreetNumber": "279"
+"StreetSuffix": "Drive"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "2758"
+"VirtualTourURLUnbranded": "https://youriguide.com/32_279_sandowne_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29851946/279-sandowne-drive-unit-32-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1245
+"OriginalEntryTimestamp": "2026-06-04T13:20:00.45Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1170621"
+"ListOfficeNationalAssociationId": "1004387"
+"Media": array:43 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29851946')"
+"ID": "1493409"
}
]
+success: true
+page_size: 9
+page_count: 20
+count: 175
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]