array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29964973 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1575466"
+post_author: 1
+"ListingKey": "29964973"
+"ListingId": "40843611"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T13:55:11Z"
+"RFModificationTimestamp": "2026-06-29T17:23:56Z"
+"ListPrice": 519900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 2092.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N3"
+"UnparsedAddress": "465 COLUMBIA Street W Unit# 4, Waterloo, Ontario N2T2N3"
+"Coordinates": array:2 [
0 => -80.5699679
1 => 43.4659574
]
+"Latitude": 43.4659574
+"Longitude": -80.5699679
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Move-in Ready. Prestigious Upper Beechwood bungalow end-unit condo nestled among the beautiful treed surroundings of Roxton Park. Offering carefree living style for the busy professional, young executive & active empty nesters. An intimate complex with 8 owners. Filled with natural light, this elegant bungalow features large windows, transoms, soaring 9’ ceilings, 3 full bathrooms, and 2 walkouts. The spacious kitchen with a dinette showcases an impressive 12’ ceiling, while the open-concept dining area and great room create an inviting atmosphere complete with oversized windows and a cozy gas fireplace. The primary bedroom retreat offers a beautifully updated 3pc ensuite featuring quartz countertops and a glass shower. Step outside from the 2nd bedroom to the oversized deck and enjoy peaceful views in a serene setting. The finished lower level adds exceptional living space with a large recreation room and an additional full bathroom. Recent Updates: Kitchen sink faucet (2026), Range Hood (2021), newly painted most walls (2026), all 3 bathroom vanities, faucets and toilets (2024, 2026). Master bedroom ensuite shower (2024). Dining room sliding door (2020). Gas Fireplace (2021). Dryer (2018). Washer (2020). Outstanding location within walking distance to Shopping, Roxton Park, Conservation area, transit, University of Waterloo, Library, YMCA. A short drive to Costco, the Boardwalk, and all other amenities. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"AssociationFee": "911.75"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T17:23:46.447783+00:00"
+"Directions": "Fischer-Hallman Rd N to Columbia St W"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1970409"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T13:50:03Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T13:50:03Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "COLUMBIA"
+"StreetNumber": "465"
+"StreetSuffix": "Street"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "4795"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/465-Columbia-St-W-unit-4"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1671177675"
"RoomType" => "Utility room"
"ListingId" => "40843611"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29964973"
"RoomLength" => null
"RoomDimensions" => "5'7'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T13:50:03.8Z"
]
1 => array:11 [
"RoomKey" => "1671177676"
"RoomType" => "Laundry room"
"ListingId" => "40843611"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29964973"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 15'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T13:50:03.81Z"
]
2 => array:11 [
"RoomKey" => "1671177677"
"RoomType" => "3pc Bathroom"
"ListingId" => "40843611"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29964973"
"RoomLength" => null
"RoomDimensions" => "5'3'' x 7'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T13:50:03.81Z"
]
3 => array:11 [
"RoomKey" => "1671177678"
"RoomType" => "Recreation room"
"ListingId" => "40843611"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29964973"
"RoomLength" => null
"RoomDimensions" => "15'4'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T13:50:03.81Z"
]
4 => array:11 [
"RoomKey" => "1671177679"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843611"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964973"
"RoomLength" => null
"RoomDimensions" => "6'5'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T13:50:03.81Z"
]
5 => array:11 [
"RoomKey" => "1671177680"
"RoomType" => "Full bathroom"
"ListingId" => "40843611"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964973"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 6'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T13:50:03.81Z"
]
6 => array:11 [
"RoomKey" => "1671177681"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843611"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964973"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T13:50:03.81Z"
]
7 => array:11 [
"RoomKey" => "1671177682"
"RoomType" => "Kitchen"
"ListingId" => "40843611"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964973"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T13:50:03.81Z"
]
8 => array:11 [
"RoomKey" => "1671177683"
"RoomType" => "Bedroom"
"ListingId" => "40843611"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964973"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 14'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T13:50:03.81Z"
]
9 => array:11 [
"RoomKey" => "1671177684"
"RoomType" => "Dining room"
"ListingId" => "40843611"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964973"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T13:50:03.81Z"
]
10 => array:11 [
"RoomKey" => "1671177685"
"RoomType" => "Living room"
"ListingId" => "40843611"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964973"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 15'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T13:50:03.81Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29964973/465-columbia-street-w-unit-4-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1301
+"BelowGradeFinishedArea": 791
+"OriginalEntryTimestamp": "2026-06-29T13:50:03.77Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1257707"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29964973_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/7dad18034b9112e5a31b5c8041aac6dc.webp"
"MediaSize" => 137846
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-7dad18034b9112e5a31b5c8041aac6dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior townhome featuring a prominent bay window, two individual garage doors, and two private balconies with dark railings"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29964973_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/28fff4134d70085575e8001c3b075e47.webp"
"MediaSize" => 165672
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-28fff4134d70085575e8001c3b075e47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29964973_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/b925b90561161d0ede7fdf944e90f567.webp"
"MediaSize" => 195597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-b925b90561161d0ede7fdf944e90f567.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior with multi-pane windows and a black balcony railing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29964973_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/69d04bc848f53425e58043186db23142.webp"
"MediaSize" => 155870
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-69d04bc848f53425e58043186db23142.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick facade exterior with two integrated garages, a second-story balcony with dark railings, and prominent bay windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29964973_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/67ca44d714b7e418b133fb67fcb45505.webp"
"MediaSize" => 234711
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-67ca44d714b7e418b133fb67fcb45505.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Yellow brick exterior with an attached garage featuring a light gray door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29964973_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/cc20170754cebb6fedece9c4c016e8a4.webp"
"MediaSize" => 154180
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-cc20170754cebb6fedece9c4c016e8a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior featuring a covered entry porch with columns, a light blue front door, and a raised wooden deck with dark railings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29964973_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/67f8af3f402e797e1ed70d18543e926b.webp"
"MediaSize" => 188990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-67f8af3f402e797e1ed70d18543e926b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick facade residence featuring a covered front entry with columns, a stone staircase, and a dedicated patio area with dark railings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29964973_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/8f439b34dbea54c312aee4171c0487f9.webp"
"MediaSize" => 221393
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-8f439b34dbea54c312aee4171c0487f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Landscaped grounds featuring a blooming tree with vibrant pink foliage, a concrete pathway with black metal handrails, and a pergola structure"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29964973_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/cc85fc8d31869195f3e4d92d99a26bc1.webp"
"MediaSize" => 232249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-cc85fc8d31869195f3e4d92d99a26bc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior featuring a covered front entry with white columns, a raised wood deck with black railings, and a vibrant red-leafed tree"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29964973_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/df276256e80e1aefc623cd44b8b7124c.webp"
"MediaSize" => 75918
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-df276256e80e1aefc623cd44b8b7124c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a white paneled door with frosted sidelight windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29964973_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/9fe957b4e549b1aea5a6a3f87e267a29.webp"
"MediaSize" => 51446
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-9fe957b4e549b1aea5a6a3f87e267a29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Foyer with wood-finish flooring, light grey wall paint, and white trim molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29964973_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/0a6d17683d411713b88016bd65ac0bc9.webp"
"MediaSize" => 72016
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-0a6d17683d411713b88016bd65ac0bc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring floor-to-ceiling windows, a contemporary pendant light fixture, a built-in wall cabinet with glass doors, a geometric tile floor, and solid colored walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29964973_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/db3788f47b136cbb93dede3cd966dba2.webp"
"MediaSize" => 61131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-db3788f47b136cbb93dede3cd966dba2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring a tall window array, a decorative pendant light fixture, and tile flooring with a checkerboard pattern"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29964973_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/1bfa23352bbee8b1936ae447c6d87326.webp"
"MediaSize" => 71300
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-1bfa23352bbee8b1936ae447c6d87326.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, stone-finish countertops, and a white appliance suite"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29964973_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/db3503b7d2097546bde1b1f04002fe17.webp"
"MediaSize" => 69152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-db3503b7d2097546bde1b1f04002fe17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring extensive white cabinetry, a double basin sink with a chrome faucet, white dishwasher, and a white electric range with an overhead vent hood"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29964973_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/b2361683044fff7e904e8d3b1b90c6ab.webp"
"MediaSize" => 63763
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-b2361683044fff7e904e8d3b1b90c6ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, stone-finish countertops, and a double basin sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29964973_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/b829c672477ee0be2836eac6197d922c.webp"
"MediaSize" => 83756
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-b829c672477ee0be2836eac6197d922c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring a dining space with a contemporary chandelier, wood-finish flooring, and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29964973_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/4688eed8fed0f9d0f6ff84a7174e82f5.webp"
"MediaSize" => 68531
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-4688eed8fed0f9d0f6ff84a7174e82f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring wood-finish flooring, a white six-panel door, and a sliding glass door leading to a balcony with black railings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29964973_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/0acd906023ed48cad80fb9e219c473ec.webp"
"MediaSize" => 63056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-0acd906023ed48cad80fb9e219c473ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring wood-finish flooring, light gray walls, a vaulted ceiling, and a chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29964973_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/ea554429523c4b13854e8c5c97a2d697.webp"
"MediaSize" => 78780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-ea554429523c4b13854e8c5c97a2d697.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright living space featuring light-toned walls and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29964973_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/5acae46c0a13497fd2e7e8c383b5b115.webp"
"MediaSize" => 87665
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-5acae46c0a13497fd2e7e8c383b5b115.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring wood-finish flooring and neutral wall tones"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29964973_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/e43903dbe78624b71da7f501aec7e8ec.webp"
"MediaSize" => 78133
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-e43903dbe78624b71da7f501aec7e8ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring, neutral wall tones, and crown molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29964973_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/e5a2cf41628a5e30537029bc5daba5ed.webp"
"MediaSize" => 97403
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-e5a2cf41628a5e30537029bc5daba5ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright living area featuring a white fireplace with a black insert, surrounded by multiple windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29964973_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/b8f94874ba6b1f628a27bb31d6b73ac4.webp"
"MediaSize" => 132234
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-b8f94874ba6b1f628a27bb31d6b73ac4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Corner windows providing ample natural light and exterior greenery"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29964973_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/3b5a5a864b3729c12ba9c0a5df2cc680.webp"
"MediaSize" => 129094
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-3b5a5a864b3729c12ba9c0a5df2cc680.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exterior balcony featuring wood plank flooring, black metal railings, and a brick facade"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29964973_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/ceec7207548a8de45ae266292609207f.webp"
"MediaSize" => 58982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-ceec7207548a8de45ae266292609207f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring wood-finish flooring, white panel doors, overhead track lighting, and a transom window above the main entry door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29964973_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/29dcb3f07e3743bd1621a6c2240ff7cb.webp"
"MediaSize" => 59396
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-29dcb3f07e3743bd1621a6c2240ff7cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring wood-finish flooring, light grey walls, and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29964973_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/bc65ecacf690d3b96233ef1260df579f.webp"
"MediaSize" => 52988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-bc65ecacf690d3b96233ef1260df579f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Wood-finish flooring throughout"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29964973_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/8940d76f11b58eed79148e631c7075f0.webp"
"MediaSize" => 170699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-8940d76f11b58eed79148e631c7075f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive outdoor deck featuring wood flooring and a black metal railing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29964973_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/29d0558dbb74ec3d705d2b20539eda85.webp"
"MediaSize" => 245734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-29d0558dbb74ec3d705d2b20539eda85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious outdoor deck featuring wood-finish flooring, black vertical railing, and a mature red-leafed tree"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29964973_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/6ea9920a168874c51966cb6d771d45fc.webp"
"MediaSize" => 240319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-6ea9920a168874c51966cb6d771d45fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive wood-plank deck with black metal railing, featuring a brick exterior and blue architectural columns"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29964973_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/d62a2b4de04e01307b4245a27c37b69c.webp"
"MediaSize" => 68203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-d62a2b4de04e01307b4245a27c37b69c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with a speckled countertop, undermount sink, and matte black faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29964973_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/510302471a77840fc0e76e90077584e9.webp"
"MediaSize" => 73830
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-510302471a77840fc0e76e90077584e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious bedroom featuring light neutral wall paint and carpeting, a large window overlooking outdoor scenery, and a tufted fabric headboard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29964973_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/3884e2c8ed815cb1afe1b1a8f4d65440.webp"
"MediaSize" => 75505
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-3884e2c8ed815cb1afe1b1a8f4d65440.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Double French doors opening to an exterior deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29964973_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/2b88726f71b981874b23431c998c1674.webp"
"MediaSize" => 57802
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-2b88726f71b981874b23431c998c1674.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted bedroom featuring light gray walls, a six-panel door, and a doorway opening to a bathroom with a white vanity"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29964973_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/d157b9414e320ac33c06a5d2246aa74b.webp"
"MediaSize" => 48345
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-d157b9414e320ac33c06a5d2246aa74b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with a light-toned countertop, a glass-enclosed shower with tiled walls, a wall-mounted light fixture, and a framed mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29964973_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/f2e246bc74bd847de889df6789d57764.webp"
"MediaSize" => 89839
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-f2e246bc74bd847de889df6789d57764.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Foyer featuring dark square floor tiles, a staircase with wood-finish railings and carpeted treads, and mirrored sliding closet doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29964973_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/46d427793956d06bdcd4e66edc455b8c.webp"
"MediaSize" => 78424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-46d427793956d06bdcd4e66edc455b8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious lower-level area featuring plush carpeting, recessed lighting, a window, and a built-in staircase with wood banister"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29964973_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/bf3651d51c186f0d344a3c301dee23e2.webp"
"MediaSize" => 74646
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-bf3651d51c186f0d344a3c301dee23e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring recessed lighting, a neutral color palette, and light brown carpeting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29964973_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/2e8f1bca55dfc110429c7d1e169d0076.webp"
"MediaSize" => 74608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-2e8f1bca55dfc110429c7d1e169d0076.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted living area featuring recessed lighting and a built-in wall niche"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29964973_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/a0e3cd5c38781b2bd6de62e6d9988671.webp"
"MediaSize" => 73268
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-a0e3cd5c38781b2bd6de62e6d9988671.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring neutral carpeting and white painted walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29964973_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/6d4409bb97ecec5921bbc0436e71dc5d.webp"
"MediaSize" => 54063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-6d4409bb97ecec5921bbc0436e71dc5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary bathroom featuring a framed mirror, a single vanity with a white countertop and integrated sink, a dark wall-mounted cabinet, a toilet, and a stand-up shower with frosted glass doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29964973_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/4576e88b0b74f417afe654bf5bf7168c.webp"
"MediaSize" => 69405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-4576e88b0b74f417afe654bf5bf7168c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry area featuring a utility sink, wall-mounted shelving, and overhead fluorescent lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29964973_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/dfe1e119aef26dc61e020df95ccd24f5.webp"
"MediaSize" => 16268
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-dfe1e119aef26dc61e020df95ccd24f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29964973_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/bcb2dd1babe41b260188bd72254f343c.webp"
"MediaSize" => 24734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-bcb2dd1babe41b260188bd72254f343c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29964973_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/2e514a614a4300f10900d56501d1b060.webp"
"MediaSize" => 129403
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-2e514a614a4300f10900d56501d1b060.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entry feature showcasing two gazebos with column supports and shingle roofs"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29964973_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/7144d754e9122e9c51fb76ebcbc56b51.webp"
"MediaSize" => 130894
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-7144d754e9122e9c51fb76ebcbc56b51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Community entrance featuring a stone and pillar structure, central landscaping with green shrubs and grass, and paved roadways"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29964973_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/4db672445030c47db927a143ac268da5.webp"
"MediaSize" => 149033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-4db672445030c47db927a143ac268da5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Decorative gazebo with a shingled roof and columnar supports"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "29964973_4890_49"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/b8ac7005e7c229ccb1859523e934380f.webp"
"MediaSize" => 180415
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-b8ac7005e7c229ccb1859523e934380f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Portico entry with columns, shaker shingle roof, and brick pavers"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
49 => array:13 [
"Order" => 50
"MediaKey" => "29964973_4890_50"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964973/f0b2eda99f67f463614fb408ac05348a.webp"
"MediaSize" => 156473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964973/thumbnail-f0b2eda99f67f463614fb408ac05348a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Paved parking area featuring a herringbone pattern, bordered by green lawn and a stone retaining wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843611"
"ResourceRecordKey" => "29964973"
"ModificationTimestamp" => "2026-06-29T13:50:03.78Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964973')"
+"ID": "1575466"
}
]
+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 295659" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24887
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1970409" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24878
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29964973'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25291
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29964973'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25306
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25307
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31719808"
+"ListingKey": "29964973"
+"ListingId": "40843611"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-12"
+"OpenHouseStartTime": "2026-07-12T14:00:00Z"
+"OpenHouseEndTime": "2026-07-12T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-29T23:35:46Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31719808')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25309
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31719809"
+"ListingKey": "29964973"
+"ListingId": "40843611"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-11"
+"OpenHouseStartTime": "2026-07-11T14:00:00Z"
+"OpenHouseEndTime": "2026-07-11T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-29T23:35:46Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31719809')"
}
]
+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 '29964973' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5699679 43.4659574)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25404
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25378
+post_id: "1576317"
+post_author: 1
+"ListingKey": "29966442"
+"ListingId": "40836179"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T17:40:45Z"
+"RFModificationTimestamp": "2026-06-29T18:49:17Z"
+"ListPrice": 1470000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2663.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2S8"
+"UnparsedAddress": "294 ALGONQUIN Drive, Waterloo, Ontario N2L2S8"
+"Coordinates": array:2 [
0 => -80.5462881
1 => 43.4644504
]
+"Latitude": 43.4644504
+"Longitude": -80.5462881
+"YearBuilt": 1961
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Architecturally Distinct Mid-Century Bungalow in Prestigious Beechwood. A rare opportunity to own a truly unique home in one of Waterloo's most sought-after neighbourhoods. Nestled within a private wooded enclave, this architecturally significant mid-century executive bungalow offers over 2,650 sq. ft. of thoughtfully designed living space and an exceptional connection to nature. Step inside and be captivated by soaring floor-to-ceiling windows that frame private views and fill the home with natural light. The spacious main level is designed for both everyday living and entertaining, featuring expansive principal rooms, a welcoming living and dining area with a striking double-sided fireplace, and multiple spaces to gather with family and friends. The lower level offers incredible flexibility with a walkout to the backyard, a large family room, two additional bedrooms or office, a full bathroom, and direct access to the garage—ideal for multi-generational living, guests, or a future in-law setup. Outside, enjoy your own private backyard retreat surrounded by mature trees, offering peace, privacy, and endless potential to create your dream outdoor oasis. Updates include windows, roof, hot water tank and boiler, electrical service, extensive landscaping. While some cosmetic updating may be desired, the home presents an outstanding opportunity to personalize a property with exceptional character in an unbeatable location. Virtual staging has been provided to show decorating potential. Situated just minutes from the University of Waterloo, top-rated schools, parks, trails, shopping, and amenities, this is a location rarely offered and highly coveted. Bring your vision and imagination or just move in—this remarkable Beechwood property is ready to become your forever home. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Sauna"
5 => "Central Vacuum"
6 => "Dishwasher"
7 => "Stove"
8 => "Dryer"
9 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:2 [
0 => "Window air conditioner"
1 => "None"
]
+"CreationDate": "2026-06-29T18:49:12.869016+00:00"
+"Directions": "Westmount Rd to Longfellow Dr. to Iroquois Pl. to Algonquin Dr."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Boiler"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1996603"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Ravine"
2 => "Paved driveway"
3 => "Automatic Garage Door Opener"
4 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T17:33:05Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T17:33:05Z"
+"Stories": "1.0"
+"StreetName": "ALGONQUIN"
+"StreetNumber": "294"
+"StreetSuffix": "Drive"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "7014"
+"VirtualTourURLUnbranded": "https://youriguide.com/7ypyq_294_algonquin_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1671318304"
"RoomType" => "Utility room"
…9
]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29966442/294-algonquin-drive-waterloo"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 100.0
+"AboveGradeFinishedArea": 1651
+"BelowGradeFinishedArea": 1011
+"OriginalEntryTimestamp": "2026-06-29T17:33:05.3Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1279276"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29966442')"
+"ID": "1576317"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25380
+post_id: "1574246"
+post_author: 1
+"ListingKey": "29963571"
+"ListingId": "40840611"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T01:30:15Z"
+"RFModificationTimestamp": "2026-06-28T04:35:44Z"
+"ListPrice": 549000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1482.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2X1"
+"UnparsedAddress": "619 WILD GINGER Avenue Unit# H45, Waterloo, Ontario N2V2X1"
+"Coordinates": array:2 [
0 => -80.5941875
1 => 43.469623
]
+"Latitude": 43.469623
+"Longitude": -80.5941875
+"YearBuilt": 2006
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to easy living in this spacious four level townhome offering a thoughtful layout and plenty of flexible space. The main level features a bright kitchen and dining area with access to a front balcony, perfect for morning coffee or summer BBQs. A convenient two piece bathroom and inviting living room overlook the private backyard, creating a comfortable space for everyday living and entertaining. Upstairs, you'll find two generously sized bedrooms and a full bathroom. The lower level rec room provides additional living space and could easily serve as a third bedroom, home office, or family room. Step outside from this level onto the deck and enjoy the privacy of your own backyard retreat. Laundry is conveniently located just inside the attached garage, adjacent to the rec room. The fourth level offers plenty of storage in the utility room and includes a bathroom rough in, providing potential for future expansion. With an attached garage, multiple outdoor living spaces, and a versatile floor plan, this home is an excellent opportunity for first-time buyers, downsizers, or investors alike. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
]
+"AssociationFee": "258"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Property Management"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-28T04:35:40.657011+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1978914"
+"ListOfficeKey": "283168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-28T01:21:05Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T01:21:04Z"
+"Stories": "3.0"
+"StreetName": "WILD GINGER"
+"StreetNumber": "619"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3685"
+"VirtualTourURLUnbranded": "https://youriguide.com/h45_619_wild_ginger_ave_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/29963571/619-wild-ginger-avenue-unit-h45-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2161263"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "283168"
+"GeocodeManualYN": true
+"ZoningDescription": "70-RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1482
+"OriginalEntryTimestamp": "2026-06-28T01:21:04.9Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1264841"
+"ListOfficeNationalAssociationId": "1325206"
+"CoListAgentNationalAssociationId": "1412362"
+"CoListOfficeNationalAssociationId": "1325206"
+"Media": array:35 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29963571')"
+"ID": "1574246"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25377
+post_id: "1574187"
+post_author: 1
+"ListingKey": "29963570"
+"ListingId": "40841161"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T02:15:21Z"
+"RFModificationTimestamp": "2026-06-28T02:17:27Z"
+"ListPrice": 539900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1800.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2P7"
+"UnparsedAddress": "350 ERBSVILLE Road Unit# 3, Waterloo, Ontario N2T2P7"
+"Coordinates": array:2 [
0 => -80.5789343
1 => 43.4607288
]
+"Latitude": 43.4607288
+"Longitude": -80.5789343
+"YearBuilt": 1994
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "There’s a reason people hold onto these units for an average of 25 years. If you’ve been looking for that perfect middle ground, more space than a starter home, a backyard that’s actually private, and a neighbourhood where kids still ride their bikes to the park, this is it. The main floor is designed for how families actually live. Flowing naturally from a bright living room into the kitchen and dining area White shaker cabinetry, stainless steel appliances, and sliding doors out to the yard. Upstairs, you’ll find three genuinely spacious bedrooms. The primary bedroom easily fits a king-sized bed and offers ensuite privilege to a bright, updated 5-piece bathroom. Need a playroom, a home office, or just somewhere to send the kids when they’re being loud? The fully finished basement has you covered. It features a massive rec room with pot lights, and a convenient 3-piece bathroom, plus dedicated laundry and storage space. Now, let’s talk about the lifestyle. You’re steps from the Laurel Creek Conservation Area, meaning weekend hikes, canoeing, and trails are practically in your backyard. You’ve got the Stork Family YMCA and the John M. Harper Library just down the street. Need to run errands? The Boardwalk and Costco are minutes away for groceries, and restaurants. Plus, you’re in the catchment for some of the best schools in the region, including Laurel Heights Secondary School. And the best part? The condo fees are only $230 a month, and they’ve barely increased in years. It’s the peace of mind of a well-managed complex with the space and privacy of a freehold feel. If you’re outgrowing your condo or starter home, this is the exact upgrade you’ve been looking for. It’s the perfect blend of space, location, and neighbourhood. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "230"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-28T01:52:07.760475+00:00"
+"Directions": "Nearest Intersection: Erbsville Rd & Columbia St. W."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027560"
+"ListOfficeKey": "289848"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-28T01:20:59Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T02:02:40Z"
+"Stories": "2.0"
+"StreetName": "ERBSVILLE"
+"StreetNumber": "350"
+"StreetSuffix": "Road"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "3425"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/cjdyt_3_350_erbsville_rd_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/29963570/350-erbsville-road-unit-3-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD-3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1275
+"BelowGradeFinishedArea": 525
+"OriginalEntryTimestamp": "2026-06-28T01:20:58.81Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1306927"
+"ListOfficeNationalAssociationId": "1381908"
+"Media": array:35 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29963570')"
+"ID": "1574187"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25381
+post_id: "1574016"
+post_author: 1
+"ListingKey": "29963363"
+"ListingId": "X13498204"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T00:30:35Z"
+"RFModificationTimestamp": "2026-06-28T00:33:22Z"
+"ListPrice": 537888.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2K7"
+"UnparsedAddress": "3 - 601 COLUMBIA FOREST BOULEVARD, Waterloo, Ontario N2V2K7"
+"Coordinates": array:2 [
0 => -80.5844243
1 => 43.4647062
]
+"Latitude": 43.4647062
+"Longitude": -80.5844243
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this exclusive Columbia Forest Estates enclave of Waterloo! This premium, turn-key townhome offers the perfect blend of modern styling, functional space, & unbeatable location convenience. Step inside to discover a freshly updated, open-concept main level featuring brand-new luxury flooring, modern trim, and an abundance of natural light. The seamlessly connected kitchen/dining area, & inviting living room complete with a cozy gas fireplace creates the ultimate hub for entertaining or everyday family living. The kitchen comes fully equipped with a suite of appliances, including a brand-new refrigerator and over-the-range microwave along with the already existing stainless dishwasher and stove. Upstairs and down, an intelligently designed layout delivers a rare 4-bedroom setup that offers privacy & flexibility. It is perfectly configured with two full 4-piece bathrooms plus a convenient main-floor powder room. The lower level adds immense value, boasting a versatile recreation or home office space, or a separate guest room, and space for dedicated laundry. Step outside to your private backyard with a natural gas hookup for seamless summer BBQs, backing directly onto the scenic Geo-Time Trail network. On top of the premium interior finishes, you will enjoy complete peace of mind with a newer, fully owned furnace and A/C system installed in 2024. Location is everything: you are steps from the region's top-rated elementary and secondary schools, and only minutes from the University Corridor-offering incredible long-term value/appreciation and high-end student occupancy in a premium location. Enjoy rapid access to major highways, the Waterloo Memorial Recreation Complex, RIM Park, Costco, and the vibrant Boardwalk shopping district. Whether you are a growing family or an astute investor looking for a premium asset, this home truly embodies the epitome of convenient modern living. Don't let this rare opportunity pass you by-schedule your private viewing today! (id:62650)"
+"Appliances": array:8 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Range"
4 => "Microwave"
5 => "Window Coverings"
6 => "Garage door opener remote(s)"
7 => "Water Heater"
]
+"AssociationFee": "646"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-27T22:24:30.467157+00:00"
+"Directions": "Cross Streets: Columbia Forest Blvd & Erbsville Rd. ** Directions: Head north on Erbsville Road past Columbia Street West. The complex is located on the left-hand side, immediately at the corner intersection of Erbsville Road and Columbia Forest Boulevard."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Tile"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2209347"
+"ListOfficeKey": "280225"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-27T23:18:05Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T00:18:54Z"
+"Stories": "3.0"
+"StreetName": "Columbia Forest"
+"StreetNumber": "601"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "3699"
+"VirtualTourURLUnbranded": "https://youtu.be/pXbuepXb0Zc"
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29963363/3-601-columbia-forest-boulevard-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Sanderson Management Inc."
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-27T21:47:19.54Z"
+"ListAgentNationalAssociationId": "1456335"
+"ListOfficeNationalAssociationId": "1310773"
+"Media": array:33 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29963363')"
+"ID": "1574016"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25379
+post_id: "1565003"
+post_author: 1
+"ListingKey": "29948730"
+"ListingId": "40842788"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T20:00:23Z"
+"RFModificationTimestamp": "2026-06-26T00:28:21Z"
+"ListPrice": 1139000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3143.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P1"
+"UnparsedAddress": "723 BROOKMILL Place, Waterloo, Ontario N2V2P1"
+"Coordinates": array:2 [
0 => -80.5842507
1 => 43.4746813
]
+"Latitude": 43.4746813
+"Longitude": -80.5842507
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 723 Brookmill Place in the desirable neighbourhood of Laurelwood in Waterloo. Just steps from the Laurel Creek Conservation area, this expansive 4 bedroom 4 bathroom family home offers over 3,000 square feet of updated living space you can move right into and immediately enjoy. Step inside through the double door entry way and appreciate the bright, open concept layout with hardwood & porcelain floors, 9 ft ceiling heights and updated finishes throughout. The chef’s kitchen has been carefully designed to cater to a passion for cooking and hosting, featuring a 10 ft quartz island, gas stove, wine bar with wine fridge, and two stainless steel dishwashers. Host a dinner party in the formal dining area with friends and family, or curl up by the gas fireplace in the family room on a cold night. Upstairs, the spacious primary suite serves as a luxurious retreat, complete with a beautifully appointed double sink ensuite bathroom with a glass shower and a functional walk-in closet. Three more generously sized bedrooms with hardwood floors and a 4 pc bathroom complete the upper level. The basement features a bright, expansive layout with brand new custom-ordered carpet, a 4th bathroom, and plenty of storage space. Outside, your backyard oasis awaits! Landscaped with both privacy and functionality in mind, this peaceful outdoor space with new sodding, solar lighting and a 12 ft gazebo makes you feel like you’ve escaped the busy city. Steps away from conservation trails, public and Catholic schools, the YMCA, shopping, dining, universities, golf courses and so much more. New furnace with air hydration system, new kitchen appliances, new hot Water heater tank. With an array of luxurious features and thoughtful touches inside & out, this distinguished residence offers a lifestyle of unparalleled comfort and convenience thats perfect for your family’s next chapter. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Wine Fridge"
7 => "Dryer"
8 => "Microwave"
9 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T00:27:20.571658+00:00"
+"Directions": "Laurelwood Dr/ Brookmill Ct"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2088817"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T19:51:09Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T19:51:09Z"
+"Stories": "2.0"
+"StreetName": "BROOKMILL"
+"StreetNumber": "723"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "6960.78"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29948730/723-brookmill-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R 5"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2459
+"BelowGradeFinishedArea": 684
+"OriginalEntryTimestamp": "2026-06-24T19:51:09.22Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1362124"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29948730')"
+"ID": "1565003"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25374
+post_id: "1564289"
+post_author: 1
+"ListingKey": "29949076"
+"ListingId": "40841876"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T21:20:13Z"
+"RFModificationTimestamp": "2026-06-25T23:48:22Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.12
+"LivingArea": 1983.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N8"
+"UnparsedAddress": "670 SALZBURG Drive, Waterloo, Ontario N2V2N8"
+"Coordinates": array:2 [
0 => -80.5864421
1 => 43.462059
]
+"Latitude": 43.462059
+"Longitude": -80.5864421
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "PRICELESS VIEW! The Holy Grail of Retirement Bungalows. Modern-build, freehold (no condo fees!), and backing onto the serene Rosewood Pond in Waterloo’s coveted Clair Hills community! This rare walkout bungalow blends elegance, comfort, and true accessibility in one perfect package. It is freshly painted and updated with new carpet, and is completely move-in ready. With 2+1 bedrooms, 3 bathrooms, and nearly 2,000 sq. ft. of beautifully finished living space, this home offers both style and ease. The sun-filled open-concept main floor showcases rich maple hardwood and ceramic tile, flowing naturally to a raised deck with glass railings where you’ll enjoy the definition of a million-dollar view. The spacious primary suite overlooks the water and features a walk-in closet and private 4-piece ensuite. The second bedroom delights with a built-in Murphy bed that easily converts the space from home office to ready-made guest room. The bright walkout basement includes oversized windows, a cozy gas fireplace, and direct yard access with a covered deck that's perfect for entertaining or quiet mornings by the water. A third bedroom with ensuite privilege, along with a spacious utility/storage room complete the lower level. Built with accessibility in mind, this home includes widened doorways, lowered light switches, and modern mechanical systems. Add the double garage, quiet low-traffic location, and a peaceful pond-side setting, and you have effortless living at its finest! Homes offering this combination of location, quality, and accessibility are seldom available, and perfect for those looking to downsize. Don’t miss your opportunity to call Rosewood Estates home! Book your private showing today!! (id:62650)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:48:02.127003+00:00"
+"Directions": "Columbia to Salzburg Drive"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564479"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T21:11:25Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T21:11:25Z"
+"Stories": "1.0"
+"StreetName": "SALZBURG"
+"StreetNumber": "670"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5446"
+"VirtualTourURLUnbranded": "https://youriguide.com/670_salzburg_drive_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/29949076/670-salzburg-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1223
+"BelowGradeFinishedArea": 760
+"OriginalEntryTimestamp": "2026-06-24T21:11:25.2Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1125580"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:42 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29949076')"
+"ID": "1564289"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1563978"
+post_author: 1
+"ListingKey": "29949431"
+"ListingId": "40842822"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T22:00:21Z"
+"RFModificationTimestamp": "2026-06-25T23:28:32Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1855.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5Y9"
+"UnparsedAddress": "206 CANDLEWOOD Crescent Unit# 13, Waterloo, Ontario N2L5Y9"
+"Coordinates": array:2 [
0 => -80.5581841
1 => 43.4593984
]
+"Latitude": 43.4593984
+"Longitude": -80.5581841
+"YearBuilt": 1978
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rarely available in sought-after Beechwood, this spacious executive condominium townhome offers the perfect blend of refined living, low-maintenance convenience, and an exceptional Waterloo location. Set within an exclusive, executive-style enclave, this beautifully maintained home delivers the space and comfort of a traditional residence with the ease of condominium living. Quality built and thoughtfully designed, the home features four levels of finished living space, including 3 bedrooms, 2.5 bathrooms, and a bright, open-concept main floor ideal for both everyday living and entertaining. The generous kitchen flows seamlessly into the dining area, while engineered hardwood flooring and a cozy wood-burning fireplace add warmth and character to the principal living space. Upstairs, the spacious primary suite offers a walk-in closet and private 3-piece ensuite, creating a comfortable retreat at the end of the day. The finished walkout basement extends the home’s versatility with a large recreation room and direct access to the private, fenced backyard. Recent updates include a new furnace in 2024. Additional highlights include an oversized single-car garage, ample visitor parking conveniently located near the front door, and reasonable condominium fees that include snow removal right to your doorstep through an exceptionally well-managed corporation. Ideally located close to parks, shopping, The Boardwalk, the University of Waterloo, and Waterloo’s thriving Tech Park, this is a rare opportunity to enjoy an executive lifestyle townhome in one of Waterloo’s most desirable communities—without compromising on space, comfort, or convenience. Book your private viewing today!! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"AssociationFee": "612"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Water"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:27:31.005349+00:00"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564479"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-24T21:50:55Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T21:50:55Z"
+"Stories": "2.0"
+"StreetName": "CANDLEWOOD"
+"StreetNumber": "206"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "3809"
+"VirtualTourURLUnbranded": "https://youriguide.com/13_206_candlewood_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29949431/206-candlewood-crescent-unit-13-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1549
+"BelowGradeFinishedArea": 306
+"OriginalEntryTimestamp": "2026-06-24T21:50:55.44Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1125580"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29949431')"
+"ID": "1563978"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25402
+post_id: "1563698"
+post_author: 1
+"ListingKey": "29949612"
+"ListingId": "X13486026"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T22:55:14Z"
+"RFModificationTimestamp": "2026-06-25T23:10:34Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N8"
+"UnparsedAddress": "670 SALZBURG DRIVE, Waterloo, Ontario N2V2N8"
+"Coordinates": array:2 [
0 => -80.586439
1 => 43.462061
]
+"Latitude": 43.462061
+"Longitude": -80.586439
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "PRICELESS VIEW! The Holy Grail of Retirement Bungalows! Modern-build, freehold (no condo fees!), and backing onto the serene Rosewood Pond in Waterloo's coveted Clair Hills community! This rare walkout bungalow blends elegance, comfort, and true accessibility in one perfect package. It is freshly painted and updated with new carpet, and is completely move-in ready. With 2+1 bedrooms, 3 bathrooms, and nearly 2,000 sq. ft. of beautifully finished living space, this home offers both style and ease. The sun-filled open-concept main floor showcases rich maple hardwood and ceramic tile, flowing naturally to a raised deck with glass railings where you'll enjoy the definition of a million-dollar view. The spacious primary suite overlooks the water and features a walk-in closet and private 4-piece ensuite. The second bedroom delights with a built-in Murphy bed that easily converts the space from home office to ready-made guest room. The bright walkout basement includes oversized windows, a cozy gas fireplace, and direct yard access with a covered deck that's perfect for entertaining or quiet mornings by the water. A third bedroom with ensuite privilege, along with a spacious utility/storage room complete the lower level. Built with accessibility in mind, this home includes widened doorways, lowered light switches, and modern mechanical systems. Add the double garage, quiet low-traffic location, and a peaceful pond-side setting, and you have effortless living at its finest! Homes offering this combination of location, quality, and accessibility are seldom available, and perfect for those looking to downsize. Don't miss your opportunity to call Rosewood Estates home! (id:62783)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
3 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:09:20.683398+00:00"
+"Directions": "Cross Streets: Columbia St W. ** Directions: Columbia to Salzburg Drive."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100955"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Backs on greenbelt"
]
+"LotSizeDimensions": "45 x 118.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T22:17:44Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T22:48:20Z"
+"Stories": "1.0"
+"StreetName": "Salzburg"
+"StreetNumber": "670"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5446"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/670_salzburg_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29949612/670-salzburg-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-24T22:17:44.25Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1370979"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:42 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29949612')"
+"ID": "1563698"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25403
+post_id: "1563603"
+post_author: 1
+"ListingKey": "29950018"
+"ListingId": "X13486204"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T23:55:33Z"
+"RFModificationTimestamp": "2026-06-25T22:48:42Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5Y9"
+"UnparsedAddress": "13 - 206 CANDLEWOOD CRESCENT, Waterloo, Ontario N2L5Y9"
+"Coordinates": array:2 [
0 => -80.5582178
1 => 43.4593845
]
+"Latitude": 43.4593845
+"Longitude": -80.5582178
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rarely available in sought-after Beechwood, this spacious executive condominium townhome offers the perfect blend of refined living, low-maintenance convenience, and an exceptional Waterloo location. Set within an exclusive, executive-style enclave, this beautifully maintained home delivers the space and comfort of a traditional residence with the ease of condominium living. Quality built and thoughtfully designed, the home features four levels of finished living space, including 3 bedrooms, 2.5 bathrooms, and a bright, open-concept main floor ideal for both everyday living and entertaining. The generous kitchen flows seamlessly into the dining area, while engineered hardwood flooring and a cozy wood-burning fireplace add warmth and character to the principal living space. Upstairs, the spacious primary suite offers a walk-in closet and private 3-piece ensuite, creating a comfortable retreat at the end of the day. The finished walkout basement extends the home's versatility with a large recreation room and direct access to the private, fenced backyard. Recent updates include a new furnace in 2024. Additional highlights include an oversized single-car garage, ample visitor parking conveniently located near the front door, and reasonable condominium fees that include snow removal right to your doorstep through an exceptionally well-managed corporation. Ideally located close to parks, shopping, The Boardwalk, the University of Waterloo, and Waterloo's thriving Tech Park, this is a rare opportunity to enjoy an executive lifestyle townhome in one of Waterloo's most desirable communities-without compromising on space, comfort, or convenience. Book your private viewing today!! (id:62783)"
+"AssociationFee": "612"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T22:47:34.405190+00:00"
+"Directions": "Fisher-Hallman Rd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100955"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T23:45:35Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T23:45:35Z"
+"Stories": "2.0"
+"StreetName": "Candlewood"
+"StreetNumber": "206"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3809"
+"VirtualTourURLUnbranded": "https://youriguide.com/13_206_candlewood_crescent_waterloo_on/"
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29950018/13-206-candlewood-crescent-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Weigel Management"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-24T23:45:35.6Z"
+"ListAgentNationalAssociationId": "1370979"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29950018')"
+"ID": "1563603"
}
]
+success: true
+page_size: 9
+page_count: 10
+count: 87
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]