array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29966442 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: "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"
"ListingId" => "40836179"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29966442"
"RoomLength" => null
"RoomDimensions" => "13'1'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T17:33:05.45Z"
]
1 => array:11 [
"RoomKey" => "1671318305"
"RoomType" => "Cold room"
"ListingId" => "40836179"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29966442"
"RoomLength" => null
"RoomDimensions" => "7'5'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T17:33:05.45Z"
]
2 => array:11 [
"RoomKey" => "1671318306"
"RoomType" => "4pc Bathroom"
"ListingId" => "40836179"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29966442"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T17:33:05.46Z"
]
3 => array:11 [
"RoomKey" => "1671318307"
"RoomType" => "Bedroom"
"ListingId" => "40836179"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29966442"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T17:33:05.46Z"
]
4 => array:11 [
"RoomKey" => "1671318308"
"RoomType" => "Recreation room"
"ListingId" => "40836179"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29966442"
"RoomLength" => null
"RoomDimensions" => "22'1'' x 19'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T17:33:05.47Z"
]
5 => array:11 [
"RoomKey" => "1671318309"
"RoomType" => "Bedroom"
"ListingId" => "40836179"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29966442"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 16'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T17:33:05.47Z"
]
6 => array:11 [
"RoomKey" => "1671318310"
"RoomType" => "Bedroom"
"ListingId" => "40836179"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29966442"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T17:33:05.47Z"
]
7 => array:11 [
"RoomKey" => "1671318311"
"RoomType" => "Primary Bedroom"
"ListingId" => "40836179"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29966442"
"RoomLength" => null
"RoomDimensions" => "18'7'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T17:33:05.48Z"
]
8 => array:11 [
"RoomKey" => "1671318312"
"RoomType" => "3pc Bathroom"
"ListingId" => "40836179"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29966442"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T17:33:05.48Z"
]
9 => array:11 [
"RoomKey" => "1671318313"
"RoomType" => "Laundry room"
"ListingId" => "40836179"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29966442"
"RoomLength" => null
"RoomDimensions" => "5'2'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T17:33:05.49Z"
]
10 => array:11 [
"RoomKey" => "1671318314"
"RoomType" => "Kitchen"
"ListingId" => "40836179"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29966442"
"RoomLength" => null
"RoomDimensions" => "22'3'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T17:33:05.49Z"
]
11 => array:11 [
"RoomKey" => "1671318315"
"RoomType" => "Dining room"
"ListingId" => "40836179"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29966442"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 12'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T17:33:05.49Z"
]
12 => array:11 [
"RoomKey" => "1671318316"
"RoomType" => "Living room"
"ListingId" => "40836179"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29966442"
"RoomLength" => null
"RoomDimensions" => "19'5'' x 31'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T17:33:05.49Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29966442_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/2723ba53d6c8426c198d38c26b1f93e7.webp"
"MediaSize" => 144806
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-2723ba53d6c8426c198d38c26b1f93e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29966442_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/4bb50244bd930046e5cfc4e8bb13c9d3.webp"
"MediaSize" => 190438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-4bb50244bd930046e5cfc4e8bb13c9d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29966442_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/17bfeafd1fd2bcb7a9e9df413de17bea.webp"
"MediaSize" => 140233
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-17bfeafd1fd2bcb7a9e9df413de17bea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "virtually animated."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29966442_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/85c45733644542c7cf04f80687929ff2.webp"
"MediaSize" => 190425
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-85c45733644542c7cf04f80687929ff2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29966442_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/8bd55911694c4b83b763ce82b9097816.webp"
"MediaSize" => 187246
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-8bd55911694c4b83b763ce82b9097816.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29966442_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/bd4d02b9f1ab1be00aafbead9acf8a78.webp"
"MediaSize" => 179614
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-bd4d02b9f1ab1be00aafbead9acf8a78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29966442_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/fb25830487fcec2937d5c22c678411db.webp"
"MediaSize" => 73156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-fb25830487fcec2937d5c22c678411db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29966442_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/37821c1a283402e65d66f5b5e231d4cf.webp"
"MediaSize" => 63620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-37821c1a283402e65d66f5b5e231d4cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29966442_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/29124e7c6bfa49b9b894ce10e51d4987.webp"
"MediaSize" => 108872
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-29124e7c6bfa49b9b894ce10e51d4987.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "virtually staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29966442_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/37f3fe6677d30edaa725565c80ac05fd.webp"
"MediaSize" => 91053
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-37f3fe6677d30edaa725565c80ac05fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29966442_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/9c69b269b0bdb591d0935f4216110c96.webp"
"MediaSize" => 94194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-9c69b269b0bdb591d0935f4216110c96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29966442_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/b92e8d28f70686dc3b2dee2f54cd1eaf.webp"
"MediaSize" => 132354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-b92e8d28f70686dc3b2dee2f54cd1eaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29966442_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/aa44c054519480abb783befd83b7202a.webp"
"MediaSize" => 102919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-aa44c054519480abb783befd83b7202a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "virtually staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29966442_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/e0bc9e6dfa764610926a807bb6e81fd7.webp"
"MediaSize" => 86673
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-e0bc9e6dfa764610926a807bb6e81fd7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29966442_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/97a209de4be8434d82f7ccd4741f2843.webp"
"MediaSize" => 68335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-97a209de4be8434d82f7ccd4741f2843.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "virtually staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29966442_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/8b64ddeaa38c27969026bfff5fdd1cdc.webp"
"MediaSize" => 68774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-8b64ddeaa38c27969026bfff5fdd1cdc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "virtually staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29966442_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/8f7b2f40a7a34aa66b0410ca3408ae60.webp"
"MediaSize" => 64568
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-8f7b2f40a7a34aa66b0410ca3408ae60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29966442_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/9113631c9a868b419b73bb561e985c4c.webp"
"MediaSize" => 48316
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-9113631c9a868b419b73bb561e985c4c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29966442_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/b7155be66b013438eccf4211398ea7bd.webp"
"MediaSize" => 48078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-b7155be66b013438eccf4211398ea7bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29966442_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/5bd4b44ae03775ab62236e2ddcaa8b8a.webp"
"MediaSize" => 94730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-5bd4b44ae03775ab62236e2ddcaa8b8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "virtually staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29966442_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/ed703fd29eae935c80a1c97d40b65af3.webp"
"MediaSize" => 82569
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-ed703fd29eae935c80a1c97d40b65af3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "virtually staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29966442_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/7983103f53e4f53e881b19147e8f11ee.webp"
"MediaSize" => 82142
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-7983103f53e4f53e881b19147e8f11ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "virtually staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29966442_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/6dda2275b1e367397934a58f5747d9e5.webp"
"MediaSize" => 63456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-6dda2275b1e367397934a58f5747d9e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29966442_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/78238abdd9c00e50b4b121e9433884f6.webp"
"MediaSize" => 61469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-78238abdd9c00e50b4b121e9433884f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29966442_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/72686949402743942ec4565c2540f6c9.webp"
"MediaSize" => 76162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-72686949402743942ec4565c2540f6c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "virtually staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29966442_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/728a8f32725fc7a2c8675c43f134158d.webp"
"MediaSize" => 51193
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-728a8f32725fc7a2c8675c43f134158d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29966442_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/ec0d11980d943e228eb0902dfb65fdf6.webp"
"MediaSize" => 40913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-ec0d11980d943e228eb0902dfb65fdf6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29966442_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/4c486369c5bee27fabef410d06a01f20.webp"
"MediaSize" => 74892
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-4c486369c5bee27fabef410d06a01f20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "main floor"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29966442_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/a219763826792e28e151b7ad472bb40c.webp"
"MediaSize" => 61520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-a219763826792e28e151b7ad472bb40c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "virtually staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29966442_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/5df3cab7a5dd121ee8ca63599ea5f66b.webp"
"MediaSize" => 42992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-5df3cab7a5dd121ee8ca63599ea5f66b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29966442_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/b7a3020e3282965a39bfc0afa8e5e1c3.webp"
"MediaSize" => 59874
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-b7a3020e3282965a39bfc0afa8e5e1c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29966442_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/38c8282bad1ca752632318926b8b0096.webp"
"MediaSize" => 72110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-38c8282bad1ca752632318926b8b0096.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "virtually staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29966442_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/5d7ed6c3b8f6f2f2e7a1c94c2dbe0a6f.webp"
"MediaSize" => 53027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-5d7ed6c3b8f6f2f2e7a1c94c2dbe0a6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29966442_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/af61c47e532b3dc1398f65f40478ce67.webp"
"MediaSize" => 41621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-af61c47e532b3dc1398f65f40478ce67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "virtually staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29966442_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/2f4fee57938447a2cc485b50fc48c968.webp"
"MediaSize" => 81828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-2f4fee57938447a2cc485b50fc48c968.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "virtually staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29966442_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/5b15bb611e6d64607d0de4ccacb1f58d.webp"
"MediaSize" => 59727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-5b15bb611e6d64607d0de4ccacb1f58d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29966442_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/74b5ba5ecc875583d47d62b9a41c79f5.webp"
"MediaSize" => 76019
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-74b5ba5ecc875583d47d62b9a41c79f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29966442_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/e33193fc5ad246394815d866c72600b9.webp"
"MediaSize" => 41473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-e33193fc5ad246394815d866c72600b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "office of bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29966442_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/3c996976b53bba7c5ac0ba533d9dadfd.webp"
"MediaSize" => 30867
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-3c996976b53bba7c5ac0ba533d9dadfd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29966442_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/ec0b7def24eb1265599668031fce6601.webp"
"MediaSize" => 54998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-ec0b7def24eb1265599668031fce6601.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29966442_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/86c1c9ef0df06236f3e5e3731bfce67e.webp"
"MediaSize" => 193471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-86c1c9ef0df06236f3e5e3731bfce67e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29966442_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/cb581f5818a2c834ca201dee5c356a20.webp"
"MediaSize" => 137654
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-cb581f5818a2c834ca201dee5c356a20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "virtually staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29966442_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/2a6944b698bad3f47c84f8987f66f956.webp"
"MediaSize" => 154787
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-2a6944b698bad3f47c84f8987f66f956.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29966442_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/474c93653e753791c37c297c6369d462.webp"
"MediaSize" => 167996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-474c93653e753791c37c297c6369d462.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29966442_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/048f1c75b9299bb047bacec7b57bf1a6.webp"
"MediaSize" => 174785
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-048f1c75b9299bb047bacec7b57bf1a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29966442_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/e17cdc625c124e188707436814ee8a13.webp"
"MediaSize" => 165080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-e17cdc625c124e188707436814ee8a13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "sauna"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29966442_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/6cc047a019a980865de7570b1540b05c.webp"
"MediaSize" => 55216
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-6cc047a019a980865de7570b1540b05c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29966442_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/2bc7e0796edb62b76eaa84383c9e0aff.webp"
"MediaSize" => 192137
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-2bc7e0796edb62b76eaa84383c9e0aff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "29966442_4890_49"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29966442/4f8c42c4b97b2d98db516a6cdb2a0b4e.webp"
"MediaSize" => 171117
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29966442/thumbnail-4f8c42c4b97b2d98db516a6cdb2a0b4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40836179"
"ResourceRecordKey" => "29966442"
"ModificationTimestamp" => "2026-06-29T17:33:05.3Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29966442')"
+"ID": "1576317"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 289541" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24884
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1996603" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24875
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29966442'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25287
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29966442'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25303
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29966442' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5462881 43.4644504)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25376
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25370
+post_id: "1576006"
+post_author: 1
+"ListingKey": "29967155"
+"ListingId": "40843458"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T19:00:08Z"
+"RFModificationTimestamp": "2026-06-29T19:38:50Z"
+"ListPrice": 1350000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0.196
+"LivingArea": 2254.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L1L1"
+"UnparsedAddress": "200 MACDONALD Place, Waterloo, Ontario N2L1L1"
+"Coordinates": array:2 [
0 => -80.5336085
1 => 43.45156
]
+"Latitude": 43.45156
+"Longitude": -80.5336085
+"YearBuilt": 1955
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Westmount welcomes you to the established, quiet court of MacDonald Place. If the time is right to downsize then this gorgeous ranch style home will be of interest. Attractive curb appeal with no sidewalks. Wide covered front porch is ready for evening chats with a glass of wine. The aggregate driveway leads to a double car garage with finished interior & roughed-in EV charger. Renovated extensively to high standards in 2013 and very well maintained by present owner. An open concept interior with vaulted ceilings are highlighted with numerous pot lights plus windows for natural light. Walkouts to two decks with a rear stone patio waiting for you to relax in the privacy of your lushly landscaped low maintenance fenced yard. Brazilian cherry hardwood floors & tile make for a carpet free main floor. You can have one level living with two bedrooms, two bathrooms, and stackable laundry all on the main level. Fabulous kitchen with gas stove & stainless appliances, centre island with bar sink & wine racks, plus thick granite counters with breakfast bar seating at the end. The Dining room has an open flow to the Living room featuring a gas fireplace accented with custom cabinets & wall mounted TV. The primary bedroom fits a king size bed, has an inverted tray ceiling, his & her closets, luxury 5 pc ensuite with walk-in shower, jet tub & double vanities plus additional storage cabinetry. The second bedroom is presently being used as an office but has a walk-in closet for use as a bedroom. The lower level is equally spacious with an office/guest room, 3 pc bathroom, Rec room/gym area plus unfinished storage & utility room. Be over to the Private Westmount Golf & Country Club within minutes where year round activities include golf, curling, & tennis in an engaging social atmosphere. Belmont Village & two Universities beckon minutes away. You can bike & walk the Iron Horse Trail from Waterloo to Kitchener or catch the ION light rail routes to explore further. August closing! (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Wine Fridge"
7 => "Dryer"
8 => "Garburator"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T19:38:45.112482+00:00"
+"Directions": "Westmount Road South to Forsyth Drive, left on Stanley Drive, left on MacDonald Place"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564125"
+"ListOfficeKey": "76836"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.196"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T18:50:44Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T18:50:44Z"
+"Stories": "1.0"
+"StreetName": "MACDONALD"
+"StreetNumber": "200"
+"StreetSuffix": "Place"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "9080.53"
+"VirtualTourURLUnbranded": "https://youriguide.com/200_macdonald_place_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1671368962"
"RoomType" => "Office"
"ListingId" => "40843458"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29967155"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 14'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T18:50:44.21Z"
]
1 => array:11 [
"RoomKey" => "1671368963"
"RoomType" => "Recreation room"
"ListingId" => "40843458"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29967155"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 30'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T18:50:44.21Z"
]
2 => array:11 [
"RoomKey" => "1671368964"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843458"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29967155"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T18:50:44.21Z"
]
3 => array:11 [
"RoomKey" => "1671368965"
"RoomType" => "Full bathroom"
"ListingId" => "40843458"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29967155"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T18:50:44.21Z"
]
4 => array:11 [
"RoomKey" => "1671368966"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843458"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29967155"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 16'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-29T18:50:44.21Z"
]
5 => array:11 [
"RoomKey" => "1671368967"
"RoomType" => "Bedroom"
"ListingId" => "40843458"
"RoomLevel" => "Main level"
…7
]
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/29967155/200-macdonald-place-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 110.0
+"AboveGradeFinishedArea": 1707
+"BelowGradeFinishedArea": 547
+"OriginalEntryTimestamp": "2026-06-29T18:50:44.16Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1070169"
+"ListOfficeNationalAssociationId": "1004398"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29967155')"
+"ID": "1576006"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25372
+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 [ …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/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 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964973')"
+"ID": "1575466"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25369
+post_id: "1571971"
+post_author: 1
+"ListingKey": "29961135"
+"ListingId": "X13496232"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T22:25:18Z"
+"RFModificationTimestamp": "2026-06-26T23:39:42Z"
+"ListPrice": 354000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0G2"
+"UnparsedAddress": "618 - 280 LESTER STREET, Waterloo, Ontario N2L0G2"
+"Coordinates": array:2 [
0 => -80.535648
1 => 43.475678
]
+"Latitude": 43.475678
+"Longitude": -80.535648
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 618 at Sage 5, a rare opportunity to own a bright 1-bedroom, 1-bathroom suite featuring floor-to-ceiling windows, unobstructed green views, and abundant natural light throughout. Occupied by only two residents since construction and exceptionally well maintained, this carpet-free home offers a functional layout with a spacious bedroom, large granite kitchen island, stainless steel appliances, and ensuite laundry. Enjoy the spacious balcony, accessible from both the living room and bedroom, overlooking peaceful greenery. Offered fully furnished, this move-in ready unit provides added convenience for both end-users and investors. Residents enjoy excellent amenities including a rooftop terrace, theatre room, fitness centre, student lounge, and study spaces. Ideally located in the heart of Waterloo's university district, just steps from the University of Waterloo, Wilfrid Laurier University, Waterloo Collegiate Institute, shopping, restaurants, and public transit. Condo fees include heat, , A/C, water, and high-speed internet. Ideal for parents, first-time buyers, and investors. Book your showing today! (id:62783)"
+"AssociationFee": "399.02"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T23:39:32.064487+00:00"
+"Directions": "Cross Streets: Lester St & Hickory St. ** Directions: University Ave West to Lester St."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Stucco"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2248033"
+"ListOfficeKey": "291350"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T22:20:07Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T22:20:07Z"
+"StreetName": "Lester"
+"StreetNumber": "280"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3004.16"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29961135/618-280-lester-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Mgmt"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-06-26T22:20:07.24Z"
+"ListAgentNationalAssociationId": "1486907"
+"ListOfficeNationalAssociationId": "1396878"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29961135')"
+"ID": "1571971"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25373
+post_id: "1570278"
+post_author: 1
+"ListingKey": "29958902"
+"ListingId": "X13494404"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T17:35:48Z"
+"RFModificationTimestamp": "2026-06-26T18:22:55Z"
+"ListPrice": 324900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3T7"
+"UnparsedAddress": "103 - 253 ALBERT STREET, Waterloo, Ontario N2L3T7"
+"Coordinates": array:2 [
0 => -80.533259
1 => 43.47544
]
+"Latitude": 43.47544
+"Longitude": -80.533259
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 103 at 253 Albert Street, Waterloo: Modern Living in the Heart of the University District! Experience this exceptional main-floor condominium located in one of Waterloo's most sought-after buildings. Nestled in the vibrant university district, this beautifully maintained 1-bedroom, 1 Bathroom residence offers an outstanding opportunity for Students, young professionals and investors alike. From the moment you step inside, you'll be captivated by the impressive 13-ft ceilings that create a bright, open and airy atmosphere rarely found in condominium living. The thoughtfully designed kitchen offers ample cabinetry and a functional layout ideal for everyday living and entertaining. Overlooking the main living area, it provides a seamless flow that makes hosting family and friends effortless. One of the standout features of this home is the rare 1.5-bathroom layout, offering added convenience and privacy for both residents and guests. The spacious primary bedroom provides a comfortable retreat and enjoys direct access to the private outdoor patio. Step outside to your own fenced patio oasis, accessible through walkouts from both the living room and bedroom. Whether you're enjoying your morning coffee, reading a book, or unwinding after a long day, this private outdoor space offers a peaceful extension of your living area. Additional highlights include in-suite laundry, modern finishes and access to the building's rooftop terrace: an ideal space to relax, socialize and take in the surrounding city views. Situated just a walking distance from Wilfrid Laurier University and University of Waterloo, this property places you at the centre of everything: Restaurants, cafés, grocery stores, shopping and public transit are all just steps from your door. Don't miss your chance to own this rare and stylish condo offering exceptional location, impressive living space and outstanding investment potential in the heart of Waterloo. Book your showing Today! (id:62783)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Furniture"
5 => "Water Heater"
]
+"AssociationFee": "525.28"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T18:22:49.894189+00:00"
+"Directions": "Cross Streets: Albert And Hickory. ** Directions: Bridgeport Rd E To Albert Street."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T17:20:42Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T17:20:42Z"
+"StreetName": "Albert"
+"StreetNumber": "253"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3768"
+"VirtualTourURLUnbranded": "https://youriguide.com/mc8ic_103_253_albert_st_waterloo_on/"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29958902/103-253-albert-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-26T17:20:42.81Z"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29958902')"
+"ID": "1570278"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25371
+post_id: "1570279"
+post_author: 1
+"ListingKey": "29958394"
+"ListingId": "40843131"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T16:40:10Z"
+"RFModificationTimestamp": "2026-06-26T18:12:38Z"
+"ListPrice": 324900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 734.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0G3"
+"UnparsedAddress": "253 ALBERT Street Unit# 103, Waterloo, Ontario N2L0G3"
+"Coordinates": array:2 [
0 => -80.5334114
1 => 43.4754303
]
+"Latitude": 43.4754303
+"Longitude": -80.5334114
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 103 at 253 Albert Street, Waterloo: Modern Living in the Heart of the University District! Experience this exceptional main-floor condominium located in one of Waterloo's most sought-after buildings. Nestled in the vibrant university district, this beautifully maintained 1-bedroom, 1 Bathroom residence offers an outstanding opportunity for Students, young professionals and investors alike. From the moment you step inside, you'll be captivated by the impressive 13-ft ceilings that create a bright, open and airy atmosphere rarely found in condominium living. The thoughtfully designed kitchen offers ample cabinetry and a functional layout ideal for everyday living and entertaining. Overlooking the main living area, it provides a seamless flow that makes hosting family and friends effortless. One of the standout features of this home is the rare 1.5-bathroom layout, offering added convenience and privacy for both residents and guests. The spacious primary bedroom provides a comfortable retreat and enjoys direct access to the private outdoor patio. Step outside to your own fenced patio oasis, accessible through walkouts from both the living room and bedroom. Whether you're enjoying your morning coffee, reading a book, or unwinding after a long day, this private outdoor space offers a peaceful extension of your living area. Additional highlights include in-suite laundry, modern finishes and access to the building's rooftop terrace: an ideal space to relax, socialize and take in the surrounding city views. Situated just a walking distance from Wilfrid Laurier University and University of Waterloo, this property places you at the centre of everything: Restaurants, cafés, grocery stores, shopping and public transit are all just steps from your door. Don't miss your chance to own this rare and stylish condo offering exceptional location, impressive living space and outstanding investment potential in the heart of Waterloo. Book your showing Today! (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "525.28"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T18:12:19.049966+00:00"
+"Directions": "Bridgeport Rd E To Albert Street"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564507"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-26T16:32:51Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T16:32:51Z"
+"Stories": "1.0"
+"StreetName": "ALBERT"
+"StreetNumber": "253"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3768"
+"VirtualTourURLUnbranded": "https://youriguide.com/mc8ic_103_253_albert_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29958394/253-albert-street-unit-103-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 734
+"OriginalEntryTimestamp": "2026-06-26T16:32:51.84Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1123254"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29958394')"
+"ID": "1570279"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25366
+post_id: "1566543"
+post_author: 1
+"ListingKey": "29945902"
+"ListingId": "40842169"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T17:40:35Z"
+"RFModificationTimestamp": "2026-06-28T17:44:24Z"
+"ListPrice": 1925000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 4223.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L1A1"
+"UnparsedAddress": "203 FORSYTH Drive, Waterloo, Ontario N2L1A1"
+"Coordinates": array:2 [
0 => -80.5292292
1 => 43.4522978
]
+"Latitude": 43.4522978
+"Longitude": -80.5292292
+"YearBuilt": 1953
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "The perfect home in the perfect neighbourhood. Just steps from Westmount Golf & Country Club, this fully renovated 4-bedroom, 4-bathroom home offers turnkey living in Waterloo’s prestigious Westmount neighbourhood. At its heart is a stunning eat-in kitchen with a large island, flowing seamlessly into the dining area and adjacent wet bar, ideal for everyday living and entertaining. The sunken living room features vaulted ceilings, custom built-ins, and a fully retractable three-panel sliding door that opens to the home’s standout feature: the Cottage room. This four-season retreat includes heated floors, retractable screened windows, and a wood-burning fireplace for year-round comfort and enjoyment. The main floor also offers a spacious mudroom, full bathroom, and versatile fourth bedroom, perfect for guests, extended family, or a home office. Upstairs, the primary suite provides a private escape with a spa-inspired bathroom. Two additional bedrooms feature imaginative built-in “tree forts” and connected closet pass-throughs that kids will love. The finished lower level adds a two-piece bathroom, separate recreation and games areas, and a full-height fitness room. With extensive updates, timeless design, and an unrivalled location near Westmount Golf & Country Club, this is a rare opportunity to own a truly unique family home in one of Waterloo’s most sought-after neighbourhoods. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Central Vacuum"
4 => "Range - Gas"
5 => "Dishwasher"
6 => "Wine Fridge"
7 => "Dryer"
8 => "Microwave"
9 => "Window Coverings"
10 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T01:38:47.375647+00:00"
+"Directions": "Forsyth off Westmount"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Hardboard"
]
+"FireplaceFeatures": array:4 [
0 => "Wood"
1 => "Electric"
2 => "Other - See remarks"
3 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2239753"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T18:12:41Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T17:20:55Z"
+"Stories": "2.0"
+"StreetName": "FORSYTH"
+"StreetNumber": "203"
+"StreetSuffix": "Drive"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "9617"
+"VirtualTourURLUnbranded": "https://youriguide.com/0emk4_203_forsyth_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29945902/203-forsyth-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 80.0
+"AboveGradeFinishedArea": 2898
+"BelowGradeFinishedArea": 1325
+"OriginalEntryTimestamp": "2026-06-24T13:30:42.16Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1477702"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29945902')"
+"ID": "1566543"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1564961"
+post_author: 1
+"ListingKey": "29948377"
+"ListingId": "X13484680"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T19:25:05Z"
+"RFModificationTimestamp": "2026-06-26T00:49:29Z"
+"ListPrice": 469000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K7"
+"UnparsedAddress": "611 - 145 COLUMBIA STREET W, Waterloo, Ontario N2L0K7"
+"Coordinates": array:2 [
0 => -80.538414
1 => 43.476791
]
+"Latitude": 43.476791
+"Longitude": -80.538414
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This stylish suite for two offers modern finishes and a bright open-concept layout, ideally located just minutes from the University of Waterloo and Laurier University. Residents enjoy exceptional amenities, including concierge service, a fully equipped fitness centre, sauna, games room, private theatre, and study lounges. Perfect for students, young professionals, or investors seeking a blend of convenience, comfort, and upscale living. The unit also includes one parking space. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Furniture"
6 => "Window Coverings"
]
+"AssociationFee": "342.6"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T00:48:52.091411+00:00"
+"Directions": "Columbia St, Phillip St"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1594283"
+"ListOfficeKey": "285001"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Partially cleared"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T18:56:16Z"
+"PhotosCount": 11
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T19:16:05Z"
+"StreetDirSuffix": "West"
+"StreetName": "Columbia"
+"StreetNumber": "145"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2646.96"
+"View": "View"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29948377/611-145-columbia-street-w-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Craft Property Group"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Party Room"
3 => "Security/Concierge"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-24T18:56:16.35Z"
+"ListAgentNationalAssociationId": "1155343"
+"ListOfficeNationalAssociationId": "1346507"
+"Media": array:11 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29948377')"
+"ID": "1564961"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25374
+post_id: "1564004"
+post_author: 1
+"ListingKey": "29954921"
+"ListingId": "40842745"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-27T01:55:08Z"
+"RFModificationTimestamp": "2026-06-27T02:06:55Z"
+"ListPrice": 3995000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 2
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 5920.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L1H7"
+"UnparsedAddress": "230 STANLEY Drive, Waterloo, Ontario N2L1H7"
+"Coordinates": array:2 [
0 => -80.5335915
1 => 43.4538961
]
+"Latitude": 43.4538961
+"Longitude": -80.5335915
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "SOPHISTICATED CUSTOM DESIGN. 230 Stanley Drive, nestled on an expansive, mature-treed lot in one of Waterloo’s most desirable neighbourhoods. This striking custom new build seamlessly blends architectural curb appeal with 5,920 sqft of meticulously finished, high-performance living space, featuring 4+2 bedrooms and 4+2 bathrooms. Step inside to discover an airy open-concept layout adorned with wide-plank white oak flooring, modern trim, & an elegant neutral colour palette. The main level flows effortlessly from the gourmet chef’s kitchen, a culinary masterpiece with premium cabinetry, quartz countertops, a servery, and a massive walk-in pantry, open to an expansive family room anchored by an elegant linear fireplace and custom built-in shelving. The kitchen features premium, front-paneled Jenn-Air appliances, including a 48” fridge/freezer, 48” dual-fuel range, integrated dishwasher, dual-zone wine cooler, and a drawer microwave. Upstairs, the wide-plank flooring leads to a lavish primary suite with a massive, brilliantly organized custom walk-in closet system. The upper level also features a convenient laundry room. The lower level boasts a fully finished basement with 9-ft ceilings, large windows, and a versatile recreation room with a fireplace and built-in cabinetry. A private staircase connects the basement directly to the fully insulated double-tandem deep garage. Outside, the property transforms into an incredible backyard oasis with a spacious covered porch featuring a stone fireplace, plank tile flooring, a ceiling fan, and a summer kitchen with granite countertops, a built-in Weber BBQ, a drawer fridge, and a sink. Built with tomorrow's tech, this Energy Star-certified home features a high-performance building envelope, triple-pane windows, and a Control4 home automation package with multi-zone audio, exterior security cameras, a full security system, and a high-efficiency HVAC system with zoned climate control via a centralized WiFi hub. Virtually Staged. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Range - Gas"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Dryer"
6 => "Wet Bar"
7 => "Hood Fan"
8 => "Garage door opener"
9 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:40:02.578588+00:00"
+"Directions": "Westmount Road S"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750694"
+"ListOfficeKey": "285293"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Wet bar"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T21:10:58Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-27T01:50:03Z"
+"Stories": "2.0"
+"StreetName": "STANLEY"
+"StreetNumber": "230"
+"StreetSuffix": "Drive"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "18248"
+"VirtualTourURLUnbranded": "https://youriguide.com/230_stanley_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:20 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29954921/230-stanley-drive-waterloo"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 65.0
+"AboveGradeFinishedArea": 4220
+"BelowGradeFinishedArea": 1700
+"OriginalEntryTimestamp": "2026-06-25T21:10:58.64Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1066261"
+"ListOfficeNationalAssociationId": "1349925"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954921')"
+"ID": "1564004"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25375
+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"
}
]
+success: true
+page_size: 9
+page_count: 37
+count: 327
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]