array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30024404 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23470
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23472
+post_id: "1619414"
+post_author: 1
+"ListingKey": "30024404"
+"ListingId": "40847010"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T14:05:26Z"
+"RFModificationTimestamp": "2026-07-13T17:14:18Z"
+"ListPrice": 959000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 2316.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1R5"
+"UnparsedAddress": "298 ROXTON Drive, Waterloo, Ontario N2T1R5"
+"Coordinates": array:2 [
0 => -80.5631649
1 => 43.463061
]
+"Latitude": 43.463061
+"Longitude": -80.5631649
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 298 Roxton Drive, a spacious and versatile two-storey home nestled in Waterloo’s sought-after Westwinds community. Thoughtfully designed for comfortable family living and entertaining, this well-appointed home offers an exceptional layout with generous principal rooms and endless potential. The main floor features a bright eat-in kitchen, inviting family room, formal living and dining rooms, a private den ideal for a home office, convenient main floor laundry, and a powder room. Upstairs, the expansive primary suite includes a walk-in closet with built-ins and a private 4-piece ensuite. A generous second bedroom, additional 4-piece bath, and a flexible loft and sitting area provide outstanding versatility — perfect for a media room, home gym, office, or easily converted third sleeping space. The oversized basement offers incredible additional living potential, highlighted by a massive L-shaped recreation room ready to be customized to suit your lifestyle — whether as a games room, home theatre, fitness area, or multi-generational living space. Ideally located close to both University of Waterloo and Wilfrid Laurier University, this home is situated in a desirable family-friendly neighbourhood near parks, schools, shopping, and everyday amenities. Community fees conveniently include landscaping and snow removal, offering added ease and low-maintenance living. This home presents a rare opportunity to create the space you’ve been looking for in one of Waterloo’s most established communities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "376.66"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T17:14:06.646151+00:00"
+"Directions": "The Westwind Community is located of the Northern most intersection of Roxton and Fischer-Hallman"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1813557"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T14:02:19Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T14:02:19Z"
+"Stories": "2.0"
+"StreetName": "ROXTON"
+"StreetNumber": "298"
+"StreetSuffix": "Drive"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "7118.33"
+"VirtualTourURLUnbranded": "https://youriguide.com/298_roxton_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [
"RoomKey" => "1683007972"
"RoomType" => "Cold room"
"ListingId" => "40847010"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30024404"
"RoomLength" => null
"RoomDimensions" => "3'9'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:44.74Z"
]
1 => array:11 [
"RoomKey" => "1683007973"
"RoomType" => "Utility room"
"ListingId" => "40847010"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30024404"
"RoomLength" => null
"RoomDimensions" => "14'10'' x 16'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:44.74Z"
]
2 => array:11 [
"RoomKey" => "1683007974"
"RoomType" => "Recreation room"
"ListingId" => "40847010"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30024404"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 17'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:44.74Z"
]
3 => array:11 [
"RoomKey" => "1683007975"
"RoomType" => "Recreation room"
"ListingId" => "40847010"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30024404"
"RoomLength" => null
"RoomDimensions" => "15'2'' x 40'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:44.74Z"
]
4 => array:11 [
"RoomKey" => "1683007976"
"RoomType" => "4pc Bathroom"
"ListingId" => "40847010"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30024404"
"RoomLength" => null
"RoomDimensions" => "4'6'' x 9'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:44.74Z"
]
5 => array:11 [
"RoomKey" => "1683007977"
"RoomType" => "Loft"
"ListingId" => "40847010"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30024404"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 27'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:44.74Z"
]
6 => array:11 [
"RoomKey" => "1683007978"
"RoomType" => "Sitting room"
"ListingId" => "40847010"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30024404"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:44.74Z"
]
7 => array:11 [
"RoomKey" => "1683007979"
"RoomType" => "Bedroom"
"ListingId" => "40847010"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30024404"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:44.74Z"
]
8 => array:11 [
"RoomKey" => "1683007980"
"RoomType" => "Full bathroom"
"ListingId" => "40847010"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30024404"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:44.74Z"
]
9 => array:11 [
"RoomKey" => "1683007981"
"RoomType" => "Primary Bedroom"
"ListingId" => "40847010"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30024404"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 17'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:44.74Z"
]
10 => array:11 [
"RoomKey" => "1683007982"
"RoomType" => "Laundry room"
"ListingId" => "40847010"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024404"
"RoomLength" => null
"RoomDimensions" => "6'6'' x 7'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:44.74Z"
]
11 => array:11 [
"RoomKey" => "1683007983"
"RoomType" => "2pc Bathroom"
"ListingId" => "40847010"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024404"
"RoomLength" => null
"RoomDimensions" => "3'11'' x 8'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:44.74Z"
]
12 => array:11 [
"RoomKey" => "1683007984"
"RoomType" => "Den"
"ListingId" => "40847010"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024404"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 16'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:44.75Z"
]
13 => array:11 [
"RoomKey" => "1683007985"
"RoomType" => "Family room"
"ListingId" => "40847010"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024404"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:44.75Z"
]
14 => array:11 [
"RoomKey" => "1683007986"
"RoomType" => "Living room/Dining room"
"ListingId" => "40847010"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024404"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 28'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:44.75Z"
]
15 => array:11 [
"RoomKey" => "1683007987"
"RoomType" => "Eat in kitchen"
"ListingId" => "40847010"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30024404"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 14'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T13:58:44.75Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30024404/298-roxton-drive-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Monitored Alarm"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 2316
+"OriginalEntryTimestamp": "2026-07-13T13:58:44.72Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1192239"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:34 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30024404_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/8fa2e9059ad996012dd2842a39a3d227.webp"
"MediaSize" => 90912
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-8fa2e9059ad996012dd2842a39a3d227.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.65Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30024404_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/e7857a8848d41714fb06f61eb7f07878.webp"
"MediaSize" => 72277
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-e7857a8848d41714fb06f61eb7f07878.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.65Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30024404_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/8710b3a88e5b5bb68b7e27d1fe472ad9.webp"
"MediaSize" => 70402
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-8710b3a88e5b5bb68b7e27d1fe472ad9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:18.08Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30024404_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/d57d1797baa7122a9e4e3d51d81a917d.webp"
"MediaSize" => 54092
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-d57d1797baa7122a9e4e3d51d81a917d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.63Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30024404_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/065d10e39242d002cca7f07c0b76b23d.webp"
"MediaSize" => 59604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-065d10e39242d002cca7f07c0b76b23d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.63Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30024404_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/0834d505ac23db056120bd29907d367f.webp"
"MediaSize" => 66358
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-0834d505ac23db056120bd29907d367f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.64Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30024404_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/e88586aa9ddc2f19ba812c226113a0b7.webp"
"MediaSize" => 65413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-e88586aa9ddc2f19ba812c226113a0b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.64Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30024404_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/f26b68f7a1a4a8f3799f81cda6a69302.webp"
"MediaSize" => 76544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-f26b68f7a1a4a8f3799f81cda6a69302.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.63Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30024404_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/66341dff42f939e126ad96efa4690db7.webp"
"MediaSize" => 80614
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-66341dff42f939e126ad96efa4690db7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.64Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30024404_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/a315b187e37cf0400995d0ec361584ad.webp"
"MediaSize" => 64047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-a315b187e37cf0400995d0ec361584ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.66Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30024404_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/eebea773410ee6ee0f7a4921c6f0d26e.webp"
"MediaSize" => 76610
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-eebea773410ee6ee0f7a4921c6f0d26e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.64Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30024404_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/0e79a00c75cee869e59cc03613852212.webp"
"MediaSize" => 76596
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-0e79a00c75cee869e59cc03613852212.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:18.91Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30024404_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/3329dab5b60efc26fef2222286dc25b5.webp"
"MediaSize" => 66757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-3329dab5b60efc26fef2222286dc25b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:18.9Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30024404_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/ba7a2cba8c2a0ef46ce1d7204599abe2.webp"
"MediaSize" => 68819
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-ba7a2cba8c2a0ef46ce1d7204599abe2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.64Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30024404_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/9ae13b2847fef1cb95d997e990f1ef3c.webp"
"MediaSize" => 63897
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-9ae13b2847fef1cb95d997e990f1ef3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.32Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30024404_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/5692ea30806ad207319da4c10b0cbf6d.webp"
"MediaSize" => 50443
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-5692ea30806ad207319da4c10b0cbf6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.64Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30024404_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/9c8cee11021c032e3c22f6331fd42539.webp"
"MediaSize" => 60082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-9c8cee11021c032e3c22f6331fd42539.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.64Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30024404_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/e35d6627ea45171bc3943c6aed46d767.webp"
"MediaSize" => 59271
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-e35d6627ea45171bc3943c6aed46d767.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:18.93Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30024404_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/a7e405fac1e67f3ddb1215d5f77b2fe9.webp"
"MediaSize" => 62416
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-a7e405fac1e67f3ddb1215d5f77b2fe9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:18.91Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30024404_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/d7d69690695ac6131d54e4f3ec332f70.webp"
"MediaSize" => 72084
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-d7d69690695ac6131d54e4f3ec332f70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:18.91Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30024404_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/0a07891d9117c0541969ad336f72472d.webp"
"MediaSize" => 46771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-0a07891d9117c0541969ad336f72472d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:18.9Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30024404_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/eb79d4deec21157f936f57378279a09e.webp"
"MediaSize" => 58735
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-eb79d4deec21157f936f57378279a09e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.88Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30024404_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/bb805ab2205fc2dbf8544a5662b7a112.webp"
"MediaSize" => 63204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-bb805ab2205fc2dbf8544a5662b7a112.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.64Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30024404_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/afcadbe70d338ada7e986977a4020c8d.webp"
"MediaSize" => 84795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-afcadbe70d338ada7e986977a4020c8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.64Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30024404_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/33ea4c84dd775953322d598a1ab5ebdc.webp"
"MediaSize" => 78338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-33ea4c84dd775953322d598a1ab5ebdc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:18.9Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30024404_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/c046bccb81164400952e1387ddcb60b8.webp"
"MediaSize" => 96041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-c046bccb81164400952e1387ddcb60b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.65Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30024404_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/79641488571333e5d9dd9bc3ec00337d.webp"
"MediaSize" => 54527
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-79641488571333e5d9dd9bc3ec00337d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:18.9Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30024404_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/9f81d15778d2c1f1d30254ac2ed6ea92.webp"
"MediaSize" => 85115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-9f81d15778d2c1f1d30254ac2ed6ea92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.64Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30024404_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/6271142d317927f979fa076104251081.webp"
"MediaSize" => 89585
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-6271142d317927f979fa076104251081.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.8Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30024404_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/f72dd084ef72583ffd41f0fced6f00b9.webp"
"MediaSize" => 108045
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-f72dd084ef72583ffd41f0fced6f00b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.64Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30024404_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/86622bb0413d32034727567285669641.webp"
"MediaSize" => 112063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-86622bb0413d32034727567285669641.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:18.91Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30024404_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/cd58b4d5ccd74e633424b7b55b299ee4.webp"
"MediaSize" => 43239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-cd58b4d5ccd74e633424b7b55b299ee4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.11Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30024404_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/7cc3534f75227b3b1397315fb8359e8a.webp"
"MediaSize" => 42493
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-7cc3534f75227b3b1397315fb8359e8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:18.9Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30024404_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30024404/8ab87a5d12c05463abf3ca502eee184a.webp"
"MediaSize" => 39390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30024404/thumbnail-8ab87a5d12c05463abf3ca502eee184a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847010"
"ResourceRecordKey" => "30024404"
"ModificationTimestamp" => "2026-07-13T14:02:19.68Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30024404')"
+"ID": "1619414"
}
]
+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=OfficeKey eq 290168" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24974
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24918
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "519-885-0200"
+"OfficeMlsId": "KW357"
+"ModificationTimestamp": "2026-03-24T17:19:30Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "290168"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "83 ERB STREET W, SUITE B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "WATERLOO"
+"OfficePostalCode": "N2L6C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1384313"
+"OriginalEntryTimestamp": "2021-04-15T13:36:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "431113"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "290168"
"SocialMediaUrlOrId" => "http://www.remaxtwincity.com/"
"ModificationTimestamp" => "2026-03-24T16:37:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1069905"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('290168')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1813557" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24928
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30024404'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25268
+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 '30024404' AND OpenHouseDate ge '2026-07-13'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25284
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30024404' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5631649 43.463061)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25337
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25331
+post_id: "1621672"
+post_author: 1
+"ListingKey": "30026867"
+"ListingId": "40843672"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T19:35:20Z"
+"RFModificationTimestamp": "2026-07-13T23:37:01Z"
+"ListPrice": 1124900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 3445.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5N2"
+"UnparsedAddress": "94 MCCARRON Crescent, Waterloo, Ontario N2L5N2"
+"Coordinates": array:2 [
0 => -80.5521317
1 => 43.4590686
]
+"Latitude": 43.4590686
+"Longitude": -80.5521317
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover 94 McCarron Crescent, Waterloo—a spacious family home in the heart of Beechwood South, one of Waterloo's most established and sought-after neighbourhoods. More than just a house, this is a place where families can put down roots, create lifelong memories, and experience everything that makes Beechwood South so special. Designed with family living in mind, this home offers a bright, flowing layout with 4 bedrooms, 3 bathrooms, a finished basement, a double garage, and a beautifully landscaped lot. Every room has been thoughtfully planned to provide space for gathering, quiet moments, and the everyday routines that turn a house into a home. Lovingly maintained by the same owners for years, this is a home where pride of ownership is evident throughout. It has been meticulously cared for, with improvements made thoughtfully and no deferred maintenance left behind—giving the next family confidence to move in and start making memories from day one. Life in Beechwood South is about so much more than your front door. Enjoy tree-lined streets, neighbourhood parks, the Beechwood South recreation centre with swimming pool, tennis courts and programming like tennis and swimming lessons, scenic walking trails, top-rated schools, shopping, and convenient access to the University of Waterloo, Wilfrid Laurier University, and Uptown Waterloo. If you're searching for a family home in Waterloo, a property that offers generous living spaces, an exceptional community, and a lifestyle that's hard to find, 94 McCarron Crescent in Beechwood South is a home you'll want to experience in person. Come check it out today! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-13T23:36:59.018747+00:00"
+"Directions": "Keats Way to Candlewood Crescent to McCarron Crescent"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1883936"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Ravine"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T19:29:39Z"
+"PhotosCount": 47
+"PoolFeatures": array:1 [
0 => "Pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T19:29:39Z"
+"Stories": "2.0"
+"StreetName": "MCCARRON"
+"StreetNumber": "94"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "6718"
+"VirtualTourURLUnbranded": "https://youriguide.com/94_mccarron_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
0 => array:11 [
"RoomKey" => "1683315933"
"RoomType" => "Utility room"
"ListingId" => "40843672"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30026867"
"RoomLength" => null
"RoomDimensions" => "20'10'' x 17'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T19:29:39.87Z"
]
1 => array:11 [
"RoomKey" => "1683315934"
"RoomType" => "Recreation room"
"ListingId" => "40843672"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30026867"
"RoomLength" => null
"RoomDimensions" => "16'7'' x 24'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T19:29:39.87Z"
]
2 => array:11 [
"RoomKey" => "1683315935"
"RoomType" => "Cold room"
"ListingId" => "40843672"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30026867"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 7'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T19:29:39.87Z"
]
3 => array:11 [
"RoomKey" => "1683315936"
"RoomType" => "Bedroom"
"ListingId" => "40843672"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30026867"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T19:29:39.87Z"
]
4 => array:11 [
"RoomKey" => "1683315937"
"RoomType" => "Bedroom"
"ListingId" => "40843672"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30026867"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T19:29:39.88Z"
]
5 => array:11 [
"RoomKey" => "1683315938"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843672"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30026867"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 18'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-13T19:29:39.88Z"
]
6 => array:11 [
"RoomKey" => "1683315939"
"RoomType" => "Bedroom"
…9
]
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30026867/94-mccarron-crescent-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2071311"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76840"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 2207
+"BelowGradeFinishedArea": 1238
+"OriginalEntryTimestamp": "2026-07-13T19:29:39.83Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1208025"
+"ListOfficeNationalAssociationId": "1378680"
+"CoListAgentNationalAssociationId": "1346521"
+"CoListOfficeNationalAssociationId": "1004363"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30026867')"
+"ID": "1621672"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25333
+post_id: "1617217"
+post_author: 1
+"ListingKey": "30022282"
+"ListingId": "X13553300"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-12T16:50:05Z"
+"RFModificationTimestamp": "2026-07-12T16:51:27Z"
+"ListPrice": 494900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N8"
+"UnparsedAddress": "12 - 465 BEECHWOOD PLACE, Waterloo, Ontario N2T2N8"
+"Coordinates": array:2 [
0 => -80.5576348
1 => 43.4515709
]
+"Latitude": 43.4515709
+"Longitude": -80.5576348
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this spacious and well-maintained townhouse condominium, offering one of the larger floor plans in the complex. Featuring 3 generously sized bedrooms, 2 full bathrooms, and 1 convenient half bathroom, this home provides the perfect balance of comfort and functionality for families, young professionals, or those looking to downsize without sacrificing space. The inviting main living areas flow seamlessly to a private backyard patio, creating a peaceful outdoor retreat ideal for relaxing or entertaining. The finished basement adds valuable living space, perfect for a family room, with a dry bar, utility room for extra storage and laundry. An attached garage with drive adds to convenience of this home. Residents will appreciate ample visitor parking and beautifully maintained common greenspace, offering additional outdoor space to enjoy. Ideally situated close to parks, shopping, conservation areas, and a variety of everyday amenities, this home also offers convenient access to nearby post-secondary institutions, making it an excellent choice for a wide range of buyers. Don't miss this opportunity to own a spacious townhouse condominium in a desirable community that combines comfort, convenience, and a fantastic location. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Stove"
5 => "Range"
6 => "Dryer"
7 => "Microwave"
8 => "Window Coverings"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"AssociationFee": "464.82"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Water"
1 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-11T21:17:29.764179+00:00"
+"Directions": "Cross Streets: Erb St. W & Beechwood Drive. ** Directions: Take Erb St W. Turn right onto Beechwood Dr. Turn right ontoBeechwood Pl. The home is on your right."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2048116"
+"ListOfficeKey": "283586"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Flat site"
1 => "Conservation/green belt"
2 => "Lighting"
3 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-11T21:06:11Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-12T16:41:17Z"
+"Stories": "2.0"
+"StreetName": "Beechwood"
+"StreetNumber": "465"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "2936.13"
+"VirtualTourURLUnbranded": "https://riot-media.aryeo.com/sites/465-beechwood-pl-12-waterloo-on-n2t-2n8-26461533/branded"
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30022282/12-465-beechwood-place-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-07-11T19:39:08.78Z"
+"ListAgentNationalAssociationId": "1323500"
+"ListOfficeNationalAssociationId": "1331925"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30022282')"
+"ID": "1617217"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25330
+post_id: "1617069"
+post_author: 1
+"ListingKey": "30022213"
+"ListingId": "40847318"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T19:50:03Z"
+"RFModificationTimestamp": "2026-07-13T19:52:53Z"
+"ListPrice": 494900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1246.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N8"
+"UnparsedAddress": "465 BEECHWOOD Place Unit# 12, Waterloo, Ontario N2T2N8"
+"Coordinates": array:2 [
0 => -80.5579989
1 => 43.4511715
]
+"Latitude": 43.4511715
+"Longitude": -80.5579989
+"YearBuilt": 1993
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this spacious and well-maintained townhouse condominium, offering one of the larger floor plans in the complex. Featuring 3 generously sized bedrooms, 2 full bathrooms, and 1 convenient half bathroom, this home provides the perfect balance of comfort and functionality for families, young professionals, or those looking to downsize without sacrificing space. The inviting main living areas flow seamlessly to a private backyard patio, creating a peaceful outdoor retreat ideal for relaxing or entertaining. The finished basement adds valuable living space, perfect for a family room, with a dry bar, utility room for extra storage and laundry. An attached garage with drive adds to convenience of this home. Residents will appreciate ample visitor parking and beautifully maintained common greenspace, offering additional outdoor space to enjoy. Ideally situated close to parks, shopping, conservation areas, and a variety of everyday amenities, this home also offers convenient access to nearby post-secondary institutions, making it an excellent choice for a wide range of buyers. Don't miss this opportunity to own a spacious townhouse condominium in a desirable community that combines comfort, convenience, and a fantastic location. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"AssociationFee": "464.82"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-11T19:36:17.379640+00:00"
+"Directions": "Take Erb St W. Turn right onto Beechwood Dr. Turn right onto Beechwood Pl. The home is on your right."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Hot water radiator heat"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1523761"
+"ListOfficeKey": "283187"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T19:48:06Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T19:48:06Z"
+"Stories": "2.0"
+"StreetName": "BEECHWOOD"
+"StreetNumber": "465"
+"StreetSuffix": "Place"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2936.13"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://riot-media.aryeo.com/sites/465-beechwood-pl-12-waterloo-on-n2t-2n8-26461"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30022213/465-beechwood-place-unit-12-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2024789"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "283187"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "MUR1-20"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 962
+"BelowGradeFinishedArea": 284
+"OriginalEntryTimestamp": "2026-07-11T18:48:04.61Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1063598"
+"ListOfficeNationalAssociationId": "1325425"
+"CoListAgentNationalAssociationId": "1304516"
+"CoListOfficeNationalAssociationId": "1325425"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30022213')"
+"ID": "1617069"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25334
+post_id: "1612394"
+post_author: 1
+"ListingKey": "30015860"
+"ListingId": "X13547200"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T12:20:07Z"
+"RFModificationTimestamp": "2026-07-13T12:24:30Z"
+"ListPrice": 498000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2R7"
+"UnparsedAddress": "290 WESTCOURT PLACE, Waterloo, Ontario N2L2R7"
+"Coordinates": array:2 [
0 => -80.541231
1 => 43.4621815
]
+"Latitude": 43.4621815
+"Longitude": -80.541231
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 290 Westcourt Place Waterloo!!! The Spacious 3 +1 Bedroom, 4 Washroom End Unit Townhome Is Situated In A Highly Desirable Location For An Affordable Price. Low Maintenance Fee, Close To University Of Waterloo , Library, Shopping Center, T&T, Restaurants. This Beautiful TH Has Been Well Maintained And Features Numerous Upgrades, Main Floor Features Bright Open-concept Layout With High Quality Laminate Floor , Renovated Kitchen With S/S Appliances, Quartz Counter Top, Ceramic Backsplash, Plenty Of Cabinets. Hard Wood On Staircase And Second Floor. All Three Bed Rooms Boast High Ceilings Offering An Enhanced Feeling Of Spaciousness. Huge Premium Bed Room Overlooks A Vast Lawn. Second Bed Room With 3 Pieces Ensuite. Professional Finished Basement With One Bed Room And Three Pieces Washroom And Recreation Room. The Living Room Sliding Door Leads To The Privite Patio, Which Backs On A Lush Greenbelt With A Gentle Stream Flowing By, You Can Immerse Yourself In The Symphony Of Birdsong, And The Sounds Of Babbling Stream . Newly Upgrades: Freshly Painted On First floor And Most Of Second Floor . Furnace(2026), Dinning Room Ceiling Light (2026), Hot Water Tank(2026), AC (2023), Second Bed Room Ensuite (2021), Finished Basement (2021) , Range Hood(2021), Fridge(2021) (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Water Heater"
]
+"AssociationFee": "214"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-10T15:51:37.652780+00:00"
+"Directions": "Cross Streets: Westmount / Westcourt. ** Directions: Westmount To Westcourt."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:4 [
0 => "Hardwood"
1 => "Laminate"
2 => "Ceramic"
3 => "Vinyl"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1942134"
+"ListOfficeKey": "274978"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Backs on greenbelt"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-12T23:38:05Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T12:10:20Z"
+"Stories": "2.0"
+"StreetName": "WESTCOURT"
+"StreetNumber": "290"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "3523.36"
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30015860/290-westcourt-place-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Prudential Property Management"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "RUM60"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-07-10T12:08:30.88Z"
+"ListAgentNationalAssociationId": "1238753"
+"ListOfficeNationalAssociationId": "1260218"
+"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('30015860')"
+"ID": "1612394"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25332
+post_id: "1609690"
+post_author: 1
+"ListingKey": "30012918"
+"ListingId": "X13544622"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-12T12:15:29Z"
+"RFModificationTimestamp": "2026-07-12T12:18:26Z"
+"ListPrice": 1500000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2V2"
+"UnparsedAddress": "318 SHAKESPEARE PLACE, Waterloo, Ontario N2L2V2"
+"Coordinates": array:2 [
0 => -80.54875
1 => 43.466095
]
+"Latitude": 43.466095
+"Longitude": -80.54875
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 318 Shakespeare Place, an exceptional opportunity to own a spacious detached home on a spectacular 91.25 x 180 ft x 137.8 ft x 147.6 ft treed pie-shaped lot in one of Waterloo's most prestigious and sought-after neighbourhoods. Offering 4 bedrooms, 2 full bathrooms, and 2,847 sq. ft. of thoughtfully designed living space, this home blends generous proportions, timeless character, and an unbeatable location. Nestled among mature trees, the private backyard feels like your own secluded retreat. Expansive outdoor living spaces, including a large entertaining deck and elevated terrace, provide the perfect setting for summer gatherings, morning coffee, or simply enjoying the peaceful natural surroundings. Inside, oversized principal rooms and an exceptionally functional layout offer space for both everyday family living and entertaining. The renovated open-concept kitchen features a large centre island, abundant cabinetry, and seamlessly connects to a stunning family room highlighted by walls of windows, skylights, custom built-ins, and a cozy fireplace. Upstairs, the spacious bedrooms include an impressive primary suite with tranquil views. Walk to the University of Waterloo, Wilfrid Laurier University, Uptown Waterloo, parks, schools, and transit, with a nearby recreation centre offering an outdoor pool, tennis courts, and summer day camp. Road construction is scheduled for completion in October 2026, bringing the benefit of newly upgraded infrastructure. Rarely do homes combine this much living space, an extraordinary estate-sized lot, and one of Waterloo's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:5 [
0 => "Water meter"
1 => "Water softener"
2 => "Intercom"
3 => "Garage door opener remote(s)"
4 => "Water Heater"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T19:55:23.530388+00:00"
+"Directions": "West Westmount Rd, South Columbia St. W"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2237673"
+"ListOfficeKey": "294429"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "91.3 x 180 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T18:40:47Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-12T12:09:04Z"
+"Stories": "2.0"
+"StreetDirPrefix": "West"
+"StreetName": "Shakespeare"
+"StreetNumber": "318"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "10439"
+"VirtualTourURLUnbranded": "https://youtu.be/tJ2mqjMjwfs"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30012918/318-shakespeare-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Separate Electricity Meters"
1 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 91.3
+"OriginalEntryTimestamp": "2026-07-09T18:40:47.48Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1475633"
+"ListOfficeNationalAssociationId": "1438893"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30012918')"
+"ID": "1609690"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25327
+post_id: "1609411"
+post_author: 1
+"ListingKey": "30012437"
+"ListingId": "40844646"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-11T20:25:25Z"
+"RFModificationTimestamp": "2026-07-11T20:29:08Z"
+"ListPrice": 1500000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3712.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2V2"
+"UnparsedAddress": "318 SHAKESPEARE Place, Waterloo, Ontario N2L2V2"
+"Coordinates": array:2 [
0 => -80.5487439
1 => 43.4660997
]
+"Latitude": 43.4660997
+"Longitude": -80.5487439
+"YearBuilt": 1967
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 318 Shakespeare Place, an exceptional opportunity to own a spacious detached home on a spectacular 91.25 x 180 ft x 137.8 ft x 147.6 ft treed pie-shaped lot in one of Waterloo's most prestigious and sought-after neighbourhoods. Offering 4 bedrooms, 2 full bathrooms, and 2,847 sq. ft. of thoughtfully designed living space, this home blends generous proportions, timeless character, and an unbeatable location. Nestled among mature trees, the private backyard feels like your own secluded retreat. Expansive outdoor living spaces, including a large entertaining deck and elevated terrace, provide the perfect setting for summer gatherings, morning coffee, or simply enjoying the peaceful natural surroundings. Inside, oversized principal rooms and an exceptionally functional layout offer space for both everyday family living and entertaining. The renovated open-concept kitchen features a large centre island, abundant cabinetry, and seamlessly connects to a stunning family room highlighted by walls of windows, skylights, custom built-ins, and a cozy fireplace. Upstairs, the spacious bedrooms include an impressive primary suite with tranquil views. Walk to the University of Waterloo, Wilfrid Laurier University, Uptown Waterloo, parks, schools, and transit, with a nearby recreation centre offering an outdoor pool, tennis courts, and summer day camp. Road construction is scheduled for completion in October 2026, bringing the benefit of newly upgraded infrastructure. Rarely do homes combine this much living space, an extraordinary estate-sized lot, and one of Waterloo's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Dryer"
6 => "Freezer"
7 => "Oven - Built-In"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T19:02:15.320960+00:00"
+"Directions": "West Westmount Rd, South Columbia St. W"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1983712"
+"ListOfficeKey": "294394"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Skylight"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T17:59:37Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-11T20:18:38Z"
+"Stories": "2.0"
+"StreetName": "SHAKESPEARE"
+"StreetNumber": "318"
+"StreetSuffix": "Place"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "10439"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youtu.be/tJ2mqjMjwfs"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30012437/318-shakespeare-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 91.0
+"AboveGradeFinishedArea": 2847
+"BelowGradeFinishedArea": 865
+"OriginalEntryTimestamp": "2026-07-09T17:59:37.16Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1268555"
+"ListOfficeNationalAssociationId": "1438749"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30012437')"
+"ID": "1609411"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23484
+post_id: "1608040"
+post_author: 1
+"ListingKey": "30009615"
+"ListingId": "40846603"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-12T20:25:22Z"
+"RFModificationTimestamp": "2026-07-12T20:29:13Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2427.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2X5"
+"UnparsedAddress": "566 AVIGNON Place, Waterloo, Ontario N2T2X5"
+"Coordinates": array:2 [
0 => -80.5761988
1 => 43.452082
]
+"Latitude": 43.452082
+"Longitude": -80.5761988
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained double-garage home on a quiet crescent, situated on a premium pie-shaped lot with spectacular views. Enjoy a large fenced backyard with a wooden shed and easy access to nearby ponds, trails, and parks. The bright and spacious layout features 3 large bedrooms, each with ensuite access, hardwood flooring in the living room, and a finished basement with an additional bedroom, office, and 3-piece bathroom. Walking distance to schools and convenient bus routes to both universities. Close to the library, community pool, Dog Park, Costco, Movati gym, Walmart, Lowe's, and other everyday amenities. Recent updates include Roof (2018), Hot Water Heater owned (2020), Water Purification System (2020), Stove & Range Hood (2020), Fridge (2021), Washer (2021), Furnace Motor & Control Panel (2022), A/C & Thermostat (2023), Sump Pump (2023), and Dishwasher (2025). A fantastic family home in a highly sought-after neighbourhood! (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Central Vacuum - Roughed In"
9 => "Hood Fan"
10 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T14:05:02.707212+00:00"
+"Directions": "Erbsville Rd & Keats Way"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955745"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T20:40:44Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-12T20:18:23Z"
+"Stories": "2.0"
+"StreetName": "AVIGNON"
+"StreetNumber": "566"
+"StreetSuffix": "Place"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5757.68"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30009615/566-avignon-place-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1827
+"BelowGradeFinishedArea": 600
+"OriginalEntryTimestamp": "2026-07-09T11:48:52.6Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1247419"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30009615')"
+"ID": "1608040"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25335
+post_id: "1607636"
+post_author: 1
+"ListingKey": "30009396"
+"ListingId": "40846048"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T18:30:04Z"
+"RFModificationTimestamp": "2026-07-13T18:42:49Z"
+"ListPrice": 849000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2506.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2L6"
+"UnparsedAddress": "620 MUNICH Circle, Waterloo, Ontario N2V2L6"
+"Coordinates": array:2 [
0 => -80.5845235
1 => 43.4613468
]
+"Latitude": 43.4613468
+"Longitude": -80.5845235
+"YearBuilt": 2000
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 620 Munich Circle, Waterloo, a beautifully maintained carpet free detached home in the highly sought after Clair Hills community, one of Waterloo's premier family neighbourhoods. Minutes from Laurel Creek Conservation Area, The Boardwalk Shopping Centre, Costco, restaurants, both universities, and Highway 85, this location offers the perfect balance of nature and convenience. This home has been thoughtfully maintained over the years. Freshly painted, with the kitchen and much of the home fully renovated in 2015. In 2021, the furnace, air conditioner, water heater, washer, dryer, deck, and basement were all updated, along with topped up attic insulation. California blinds were added in 2022. This bright and spacious home offers a functional layout with 3 generously sized bedrooms and carpet free flooring throughout. The open concept main floor is filled with natural light, with living and dining areas flowing into a well appointed kitchen with ample cabinetry, counter space, and a breakfast area overlooking the backyard. Upstairs offers three spacious bedrooms, including a primary retreat with walk in closet and private ensuite. The fully finished basement adds great additional living space, ideal as a recreation room, home gym, or media area. Enjoy the private backyard and deck, perfect for summer barbecues or unwinding after a busy day. Families will love the excellent school options nearby, including Laurel Heights Secondary School, with school bus pickup directly in front of the home for Vista Hills students. With an attached garage, private driveway, and an unbeatable location, this move in ready home is an outstanding opportunity for growing families and professionals alike. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T06:51:17.491108+00:00"
+"Directions": "Columbia St / Salzburg Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2139059"
+"ListOfficeKey": "294394"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-13T18:21:08Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T18:21:08Z"
+"Stories": "2.0"
+"StreetName": "MUNICH"
+"StreetNumber": "620"
+"StreetSuffix": "Circle"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5507"
+"VirtualTourURLUnbranded": "https://youriguide.com/620_munich_cir_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/30009396/620-munich-circle-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 71.0
+"AboveGradeFinishedArea": 1798
+"BelowGradeFinishedArea": 709
+"OriginalEntryTimestamp": "2026-07-09T04:29:10.65Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1390808"
+"ListOfficeNationalAssociationId": "1438749"
+"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('30009396')"
+"ID": "1607636"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25336
+post_id: "1607637"
+post_author: 1
+"ListingKey": "30009521"
+"ListingId": "X13541468"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-13T12:20:05Z"
+"RFModificationTimestamp": "2026-07-13T12:24:30Z"
+"ListPrice": 849000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2L6"
+"UnparsedAddress": "620 MUNICH CIRCLE, Waterloo, Ontario N2V2L6"
+"Coordinates": array:2 [
0 => -80.584506
1 => 43.461327
]
+"Latitude": 43.461327
+"Longitude": -80.584506
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 620 Munich Circle, Waterloo, a beautifully maintained carpet free detached home in the highly sought after Clair Hills community, one of Waterloo's premier family neighbourhoods. Minutes from Laurel Creek Conservation Area, The Boardwalk Shopping Centre, Costco, restaurants, both universities, and Highway 85, this location offers the perfect balance of nature and convenience.This home has been thoughtfully maintained over the years. Freshly painted, with the kitchen and much of the home fully renovated in 2015. In 2021, the furnace, air conditioner, water heater, washer, dryer, deck, and basement were all updated, along with topped up attic insulation. California blinds were added in 2022.This bright and spacious home offers a functional layout with 3 generously sized bedrooms and carpet free flooring throughout. The open concept main floor is filled with natural light, with living and dining areas flowing into a well appointed kitchen with ample cabinetry, counter space, and a breakfast area overlooking the backyard. Upstairs offers three spacious bedrooms, including a primary retreat with walk in closet and private ensuite. The fully finished basement adds great additional living space, ideal as a recreation room, home gym, or media area. Enjoy the private backyard and deck, perfect for summer barbecues or unwinding after a busy day.Families will love the excellent school options nearby, including Laurel Heights Secondary School, with school bus pickup directly in front of the home for Vista Hills students. With an attached garage, private driveway, and an unbeatable location, this move in ready home is an outstanding opportunity for growing families and professionals alike. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Ventilation system"
]
+"CreationDate": "2026-07-09T06:45:51.501597+00:00"
+"Directions": "Columbia St / Salzburg Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2217113"
+"ListOfficeKey": "294429"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "70.9 x 99.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T05:08:04Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-13T12:10:12Z"
+"Stories": "2.0"
+"StreetName": "Munich"
+"StreetNumber": "620"
+"StreetSuffix": "Circle"
+"TaxAnnualAmount": "5507"
+"VirtualTourURLUnbranded": "https://youriguide.com/620_munich_cir_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30009521/620-munich-circle-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 70.1
+"OriginalEntryTimestamp": "2026-07-09T05:08:04.07Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1462802"
+"ListOfficeNationalAssociationId": "1438893"
+"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('30009521')"
+"ID": "1607637"
}
]
+success: true
+page_size: 9
+page_count: 15
+count: 131
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]