array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29951642 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23418
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23420
+post_id: "1562249"
+post_author: 1
+"ListingKey": "29951642"
+"ListingId": "40842957"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T03:45:03Z"
+"RFModificationTimestamp": "2026-06-26T04:28:10Z"
+"ListPrice": 1599000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3181.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2V7"
+"UnparsedAddress": "361 COLERIDGE Place, Waterloo, Ontario N2L2V7"
+"Coordinates": array:2 [
0 => -80.5520319
1 => 43.4595088
]
+"Latitude": 43.4595088
+"Longitude": -80.5520319
+"YearBuilt": 1972
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome Home Again to 361 Coleridge Place, nestled in the heart of sought-after Beechwood in Waterloo — one of the city’s most established and family-oriented neighborhoods. Situated on a quiet court and set on a large, private lot with a pool, this beautifully renovated home offers the perfect blend of modern luxury and mature community charm. Completely transformed, this home showcases a stunning new kitchen featuring a spacious island, built-in appliances, sleek finishes, and a thoughtful design ideal for both everyday living and entertaining. Smart home technology adds convenience and efficiency throughout. Designed with families in mind, this spacious home offers four generous bedrooms upstairs and a total of four beautifully updated bathrooms, providing comfort and functionality for busy households. The fully finished basement includes a fifth bedroom and offers excellent in-law capability, creating flexible living options for multigenerational families or guests. Step outside to your backyard retreat — a large lot with mature trees and an inviting pool with a refreshed concrete poolside terrace, ready for summer gatherings and family fun. Located in a quiet, established neighbourhood known for its parks, schools, and strong sense of community, this is a rare opportunity to own a turnkey home in one of Waterloo’s most desirable areas. A perfect place to call home. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Garage door opener"
]
+"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-06-25T19:48:24.883391+00:00"
+"Directions": "Erb St or Keats Way to Amos Ave to Coleridge Place"
+"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": "2010359"
+"ListOfficeKey": "283397"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T03:20:56Z"
+"PhotosCount": 42
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T03:39:41Z"
+"Stories": "2.0"
+"StreetName": "COLERIDGE"
+"StreetNumber": "361"
+"StreetSuffix": "Place"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "6864"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/km94d_361_coleridge_pl_waterloo_on"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1668308046"
"RoomType" => "2pc Bathroom"
"ListingId" => "40842957"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29951642"
"RoomLength" => null
"RoomDimensions" => "7'3'' x 3'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T03:39:41.83Z"
]
1 => array:11 [
"RoomKey" => "1668308047"
"RoomType" => "3pc Bathroom"
"ListingId" => "40842957"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29951642"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T03:39:41.83Z"
]
2 => array:11 [
"RoomKey" => "1668308048"
"RoomType" => "Other"
"ListingId" => "40842957"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29951642"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T03:39:41.83Z"
]
3 => array:11 [
"RoomKey" => "1668308049"
"RoomType" => "Bedroom"
"ListingId" => "40842957"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29951642"
"RoomLength" => null
"RoomDimensions" => "15'5'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T03:39:41.83Z"
]
4 => array:11 [
"RoomKey" => "1668308050"
"RoomType" => "Recreation room"
"ListingId" => "40842957"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29951642"
"RoomLength" => null
"RoomDimensions" => "22'2'' x 25'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T03:39:41.83Z"
]
5 => array:11 [
"RoomKey" => "1668308051"
"RoomType" => "5pc Bathroom"
"ListingId" => "40842957"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29951642"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T03:39:41.84Z"
]
6 => array:11 [
"RoomKey" => "1668308052"
"RoomType" => "Bedroom"
"ListingId" => "40842957"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29951642"
"RoomLength" => null
"RoomDimensions" => "14'3'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T03:39:41.84Z"
]
7 => array:11 [
"RoomKey" => "1668308053"
"RoomType" => "Bedroom"
"ListingId" => "40842957"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29951642"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 12'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T03:39:41.84Z"
]
8 => array:11 [
"RoomKey" => "1668308054"
"RoomType" => "Bedroom"
"ListingId" => "40842957"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29951642"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T03:39:41.84Z"
]
9 => array:11 [
"RoomKey" => "1668308055"
"RoomType" => "Full bathroom"
"ListingId" => "40842957"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29951642"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T03:39:41.84Z"
]
10 => array:11 [
"RoomKey" => "1668308056"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842957"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29951642"
"RoomLength" => null
"RoomDimensions" => "14'4'' x 16'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T03:39:41.84Z"
]
11 => array:11 [
"RoomKey" => "1668308057"
"RoomType" => "Living room"
"ListingId" => "40842957"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29951642"
"RoomLength" => null
"RoomDimensions" => "22'10'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T03:39:41.84Z"
]
12 => array:11 [
"RoomKey" => "1668308058"
"RoomType" => "Kitchen"
"ListingId" => "40842957"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29951642"
"RoomLength" => null
"RoomDimensions" => "14'1'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T03:39:41.84Z"
]
13 => array:11 [
"RoomKey" => "1668308059"
"RoomType" => "Dining room"
"ListingId" => "40842957"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29951642"
"RoomLength" => null
"RoomDimensions" => "22'10'' x 12'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T03:39:41.84Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29951642/361-coleridge-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 2142
+"BelowGradeFinishedArea": 1039
+"OriginalEntryTimestamp": "2026-06-25T15:30:55.51Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1291922"
+"ListOfficeNationalAssociationId": "1328541"
+"Media": array:42 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29951642_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/ab1308db490c916015bdf1f2a8430503.webp"
"MediaSize" => 133945
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-ab1308db490c916015bdf1f2a8430503.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.37Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29951642_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/9be4b56ae0d3b9635fc7cdc0d4619251.webp"
"MediaSize" => 134062
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-9be4b56ae0d3b9635fc7cdc0d4619251.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.27Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29951642_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/5df211dd412aff36d217105982ed087a.webp"
"MediaSize" => 68858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-5df211dd412aff36d217105982ed087a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.29Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29951642_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/b88fa873e049b23d9724f26d6615f232.webp"
"MediaSize" => 68033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-b88fa873e049b23d9724f26d6615f232.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.35Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29951642_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/62067e50d4beb3db43872a5be3bf20be.webp"
"MediaSize" => 76427
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-62067e50d4beb3db43872a5be3bf20be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.31Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29951642_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/b49312082fd00a3a1dd6ea3d92794b7e.webp"
"MediaSize" => 73677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-b49312082fd00a3a1dd6ea3d92794b7e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.29Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29951642_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/8d23829f1565bbbc56c8fc20a33afb6e.webp"
"MediaSize" => 58977
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-8d23829f1565bbbc56c8fc20a33afb6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.32Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29951642_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/0089d4eb65560989a9f67a820495a81d.webp"
"MediaSize" => 94076
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-0089d4eb65560989a9f67a820495a81d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.4Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29951642_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/073c853a54b5cf2fc680fc78f59317ad.webp"
"MediaSize" => 88527
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-073c853a54b5cf2fc680fc78f59317ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.35Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29951642_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/d0558a1c5022ae9b52d768dd5bf6dfee.webp"
"MediaSize" => 38930
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-d0558a1c5022ae9b52d768dd5bf6dfee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.34Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29951642_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/3f9f5e8d31943009ed7f354bde0f539d.webp"
"MediaSize" => 44316
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-3f9f5e8d31943009ed7f354bde0f539d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.27Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29951642_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/1469a579faa58894ab4308753cacaafb.webp"
"MediaSize" => 48930
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-1469a579faa58894ab4308753cacaafb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, recessed lighting, a large window, and multiple interior doorways with matte black hardware"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.37Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29951642_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/ba193a3a0b56a2a015c982db20e5ba64.webp"
"MediaSize" => 48469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-ba193a3a0b56a2a015c982db20e5ba64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright, organized space featuring extensive built-in white shelving, recessed lighting, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.27Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29951642_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/7eca5c2ae479eb52f1bf3776eadd1b41.webp"
"MediaSize" => 72166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-7eca5c2ae479eb52f1bf3776eadd1b41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary bathroom featuring a walk-in shower with patterned wood-finish wall tile and matte black fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.31Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29951642_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/5c0c0b6fd5bf65c33e0822470841c58f.webp"
"MediaSize" => 42384
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-5c0c0b6fd5bf65c33e0822470841c58f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Walk-in shower featuring a rain showerhead, hand sprayer, wood-finish accent wall, large format tile, and mosaic tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.29Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29951642_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/898da639032a33ed4e29deb97a9f6c7a.webp"
"MediaSize" => 48992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-898da639032a33ed4e29deb97a9f6c7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom vanity featuring a quartz countertop with an integrated sink, matte black faucets, and an illuminated mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.29Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29951642_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/7d65c32c334dab968a9ace2d8df1971d.webp"
"MediaSize" => 41659
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-7d65c32c334dab968a9ace2d8df1971d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright interior space featuring a window with white trim, wood-finish flooring, white walls, and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.32Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29951642_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/88f9815c38712de96a27575d0f65480a.webp"
"MediaSize" => 49000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-88f9815c38712de96a27575d0f65480a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.37Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29951642_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/0184d732d8d40a2871451b75679fae59.webp"
"MediaSize" => 38506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-0184d732d8d40a2871451b75679fae59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light wood-finish flooring complemented by white baseboards and walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.27Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29951642_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/826a22d9614365501052578590cc99f3.webp"
"MediaSize" => 49926
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-826a22d9614365501052578590cc99f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dual vessel sinks with wall-mounted faucets"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.3Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29951642_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/c374d89614abf0f5f97899a4742acb76.webp"
"MediaSize" => 34158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-c374d89614abf0f5f97899a4742acb76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathtub and shower combination featuring neutral square wall tiles, a white porcelain tub, and brushed nickel fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.27Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29951642_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/d23a14ead2f186c16892f8537aa16371.webp"
"MediaSize" => 65993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-d23a14ead2f186c16892f8537aa16371.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom vanity featuring dual vessel sinks with modern faucets"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.4Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29951642_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/9ae9cced00fe9ea0aed8c3d8ea688a01.webp"
"MediaSize" => 38483
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-9ae9cced00fe9ea0aed8c3d8ea688a01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring light-colored carpeting, recessed lighting, and a prominent accent wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.35Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29951642_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/110b60161d45886162a3fae7dd4c4cec.webp"
"MediaSize" => 42354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-110b60161d45886162a3fae7dd4c4cec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious finished lower level featuring recessed lighting, light-toned carpeting, egress windows, and a staircase with a black handrail"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:56.31Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29951642_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/69a96e71543fe5ff7e36f54ad0f7bf05.webp"
"MediaSize" => 38879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-69a96e71543fe5ff7e36f54ad0f7bf05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring light-toned carpeting, neutral wall paint, recessed ceiling lighting, and two egress windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.29Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29951642_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/a36fe66c5ac616ed5d4d32d6ab942506.webp"
"MediaSize" => 47564
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-a36fe66c5ac616ed5d4d32d6ab942506.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bathroom featuring a glass-enclosed shower, single vanity with integrated sink, wood-finish flooring, and contemporary light fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:56.3Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29951642_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/0a75a941b85a680311f8f5cffc893517.webp"
"MediaSize" => 43339
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-0a75a941b85a680311f8f5cffc893517.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright room featuring wood-finish flooring, recessed lighting, and crisp white walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:56.31Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29951642_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/8661ed28a4c9a3e29727bc76a042e917.webp"
"MediaSize" => 49707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-8661ed28a4c9a3e29727bc76a042e917.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:56.33Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29951642_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/88e031be158447a601053575305d8e48.webp"
"MediaSize" => 173957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-88e031be158447a601053575305d8e48.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.36Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29951642_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/212bc71875621203adf32a1f93a39735.webp"
"MediaSize" => 183297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-212bc71875621203adf32a1f93a39735.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.29Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29951642_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/36ec58a774ea403a8b1f20702dbaa300.webp"
"MediaSize" => 134554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-36ec58a774ea403a8b1f20702dbaa300.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.36Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29951642_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/f4bd789665c58c2af19492ab481f059e.webp"
"MediaSize" => 126611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-f4bd789665c58c2af19492ab481f059e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.36Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29951642_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/c25e18dd708beb6afb28c7285422381d.webp"
"MediaSize" => 162556
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-c25e18dd708beb6afb28c7285422381d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.4Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29951642_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/3c1fef26a022752359adcfd8b2aa31c4.webp"
"MediaSize" => 149144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-3c1fef26a022752359adcfd8b2aa31c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:56.33Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29951642_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/389ada76d5d4d254c8fa2eb550e9efaa.webp"
"MediaSize" => 154814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-389ada76d5d4d254c8fa2eb550e9efaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:56.31Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29951642_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/929e7ba6b4ad7cdb7b7deee3dff65861.webp"
"MediaSize" => 143016
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-929e7ba6b4ad7cdb7b7deee3dff65861.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.38Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29951642_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/4cb4da6636dc4efaace6906823462005.webp"
"MediaSize" => 151189
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-4cb4da6636dc4efaace6906823462005.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:55.35Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29951642_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/2d8580f8897a931788e2499682ec1fcf.webp"
"MediaSize" => 135433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-2d8580f8897a931788e2499682ec1fcf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:56.29Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29951642_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/1563ae169eb53013608f96f6a2cdada2.webp"
"MediaSize" => 128139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-1563ae169eb53013608f96f6a2cdada2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:56.3Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29951642_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/7798213fe0749dd4a7a427b294f52dd1.webp"
"MediaSize" => 156691
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-7798213fe0749dd4a7a427b294f52dd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:56.3Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29951642_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/0b2efc059e0a045ebd7786fcc75a9f0e.webp"
"MediaSize" => 172368
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-0b2efc059e0a045ebd7786fcc75a9f0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:56.3Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29951642_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951642/9cdb7feec76b23c531a88ac39cd0eeeb.webp"
"MediaSize" => 148208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951642/thumbnail-9cdb7feec76b23c531a88ac39cd0eeeb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842957"
"ResourceRecordKey" => "29951642"
"ModificationTimestamp" => "2026-06-26T03:20:56.29Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29951642')"
+"ID": "1562249"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 283397" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24818
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2010359" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24814
+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 '29951642'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25261
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29951642'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25277
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29951642' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5520319 43.4595088)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25355
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25344
+post_id: "1564004"
+post_author: 1
+"ListingKey": "29954921"
+"ListingId": "40842745"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T21:20:05Z"
+"RFModificationTimestamp": "2026-06-25T23:40:16Z"
+"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. A must see! (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-25T21:10:58Z"
+"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 [
"RoomKey" => "1668038357"
"RoomType" => "Office"
"ListingId" => "40842745"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954921"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T21:10:58.86Z"
]
1 => array:11 [
"RoomKey" => "1668038358"
"RoomType" => "2pc Bathroom"
"ListingId" => "40842745"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954921"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T21:10:58.86Z"
]
2 => array:11 [
"RoomKey" => "1668038359"
"RoomType" => "Dining room"
"ListingId" => "40842745"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954921"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 17'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T21:10:58.86Z"
]
3 => array:11 [
"RoomKey" => "1668038360"
"RoomType" => "Pantry"
"ListingId" => "40842745"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954921"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T21:10:58.86Z"
]
4 => array:11 [
"RoomKey" => "1668038361"
"RoomType" => "Living room"
"ListingId" => "40842745"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954921"
"RoomLength" => null
"RoomDimensions" => "33'0'' x 19'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T21:10:58.86Z"
]
5 => array:11 [
"RoomKey" => "1668038362"
"RoomType" => "Kitchen"
"ListingId" => "40842745"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954921"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 20'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T21:10:58.87Z"
]
6 => array:11 [
"RoomKey" => "1668038363"
"RoomType" => "Mud room"
"ListingId" => "40842745"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954921"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 14'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T21:10:58.87Z"
]
7 => array:11 [
"RoomKey" => "1668038364"
"RoomType" => "2pc Bathroom"
"ListingId" => "40842745"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954921"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T21:10:58.87Z"
]
8 => array:11 [
"RoomKey" => "1668038365"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842745"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29954921"
"RoomLength" => null
"RoomDimensions" => "23'8'' x 19'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T21:10:58.87Z"
]
9 => array:11 [
"RoomKey" => "1668038366"
"RoomType" => "Full bathroom"
"ListingId" => "40842745"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29954921"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T21:10:58.87Z"
]
10 => array:11 [
"RoomKey" => "1668038367"
"RoomType" => "Bedroom"
"ListingId" => "40842745"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29954921"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T21:10:58.87Z"
]
11 => array:11 [
"RoomKey" => "1668038368"
"RoomType" => "3pc Bathroom"
"ListingId" => "40842745"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29954921"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T21:10:58.87Z"
]
12 => array:11 [
"RoomKey" => "1668038369"
"RoomType" => "Bedroom"
"ListingId" => "40842745"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29954921"
"RoomLength" => null
"RoomDimensions" => "15'7'' x 14'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T21:10:58.87Z"
]
13 => array:11 [
"RoomKey" => "1668038370"
"RoomType" => "5pc Bathroom"
"ListingId" => "40842745"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29954921"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T21:10:58.87Z"
]
14 => array:11 [
"RoomKey" => "1668038371"
"RoomType" => "Bedroom"
"ListingId" => "40842745"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29954921"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 23'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T21:10:58.87Z"
]
15 => array:11 [
"RoomKey" => "1668038372"
"RoomType" => "Recreation room"
"ListingId" => "40842745"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29954921"
"RoomLength" => null
"RoomDimensions" => "41'4'' x 30'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T21:10:58.87Z"
]
16 => array:11 [
"RoomKey" => "1668038373"
"RoomType" => "Bedroom"
"ListingId" => "40842745"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29954921"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 13'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T21:10:58.87Z"
]
17 => array:11 [
"RoomKey" => "1668038374"
"RoomType" => "Den"
"ListingId" => "40842745"
"RoomLevel" => "Basement"
…7
]
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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954921')"
+"ID": "1564004"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25351
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29949431')"
+"ID": "1563978"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25343
+post_id: "1563603"
+post_author: 1
+"ListingKey": "29950018"
+"ListingId": "X13486204"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T23:55:33Z"
+"RFModificationTimestamp": "2026-06-25T22:48:42Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5Y9"
+"UnparsedAddress": "13 - 206 CANDLEWOOD CRESCENT, Waterloo, Ontario N2L5Y9"
+"Coordinates": array:2 [
0 => -80.5582178
1 => 43.4593845
]
+"Latitude": 43.4593845
+"Longitude": -80.5582178
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rarely available in sought-after Beechwood, this spacious executive condominium townhome offers the perfect blend of refined living, low-maintenance convenience, and an exceptional Waterloo location. Set within an exclusive, executive-style enclave, this beautifully maintained home delivers the space and comfort of a traditional residence with the ease of condominium living. Quality built and thoughtfully designed, the home features four levels of finished living space, including 3 bedrooms, 2.5 bathrooms, and a bright, open-concept main floor ideal for both everyday living and entertaining. The generous kitchen flows seamlessly into the dining area, while engineered hardwood flooring and a cozy wood-burning fireplace add warmth and character to the principal living space. Upstairs, the spacious primary suite offers a walk-in closet and private 3-piece ensuite, creating a comfortable retreat at the end of the day. The finished walkout basement extends the home's versatility with a large recreation room and direct access to the private, fenced backyard. Recent updates include a new furnace in 2024. Additional highlights include an oversized single-car garage, ample visitor parking conveniently located near the front door, and reasonable condominium fees that include snow removal right to your doorstep through an exceptionally well-managed corporation. Ideally located close to parks, shopping, The Boardwalk, the University of Waterloo, and Waterloo's thriving Tech Park, this is a rare opportunity to enjoy an executive lifestyle townhome in one of Waterloo's most desirable communities-without compromising on space, comfort, or convenience. Book your private viewing today!! (id:62783)"
+"AssociationFee": "612"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T22:47:34.405190+00:00"
+"Directions": "Fisher-Hallman Rd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100955"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T23:45:35Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T23:45:35Z"
+"Stories": "2.0"
+"StreetName": "Candlewood"
+"StreetNumber": "206"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3809"
+"VirtualTourURLUnbranded": "https://youriguide.com/13_206_candlewood_crescent_waterloo_on/"
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29950018/13-206-candlewood-crescent-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Weigel Management"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-24T23:45:35.6Z"
+"ListAgentNationalAssociationId": "1370979"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29950018')"
+"ID": "1563603"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25352
+post_id: "1562794"
+post_author: 1
+"ListingKey": "29953497"
+"ListingId": "40842430"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T18:40:16Z"
+"RFModificationTimestamp": "2026-06-25T21:14:44Z"
+"ListPrice": 945000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2362.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1G2"
+"UnparsedAddress": "176 SANDFORD FLEMING Drive, Waterloo, Ontario N2T1G2"
+"Coordinates": array:2 [
0 => -80.5655765
1 => 43.4559425
]
+"Latitude": 43.4559425
+"Longitude": -80.5655765
+"YearBuilt": 1984
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 176 Sandford Fleming Drive, Waterloo! Situated on a rare 81' x 130' mature lot in one of Waterloo's most sought-after neighbourhoods, this spacious detached home presents an exceptional opportunity for both families and investors. Featuring soaring cathedral ceilings, 3 generous bedrooms, 2 bathrooms, and a mostly above-grade lower level with an additional bedroom, recreation room, and bathroom, the home offers flexible living space with excellent future potential. Located just minutes from the University of Waterloo, top-rated schools, parks, and the vibrant Boardwalk shopping district, this property is ideally positioned for growing families, student rental opportunities, or long-term investment. The roof was replaced in 2026, providing added peace of mind, while the solid structure and oversized lot offer tremendous potential to renovate, personalize, and build equity. A rare opportunity to own a home in a prime Waterloo location that combines lifestyle, convenience, and investment value. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T21:14:37.773819+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2055634"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T18:33:08Z"
+"PhotosCount": 32
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T18:33:08Z"
+"Stories": "2.0"
+"StreetName": "SANDFORD FLEMING"
+"StreetNumber": "176"
+"StreetSuffix": "Drive"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "6187.62"
+"VirtualTourURLUnbranded": "https://youriguide.com/176_sandford_fleming_dr_waterloo_on/"
+"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/29953497/176-sandford-fleming-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 81.0
+"AboveGradeFinishedArea": 1507
+"BelowGradeFinishedArea": 855
+"OriginalEntryTimestamp": "2026-06-25T18:33:08.82Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1330898"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29953497')"
+"ID": "1562794"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25350
+post_id: "1557129"
+post_author: 1
+"ListingKey": "29940575"
+"ListingId": "40842072"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T14:00:14Z"
+"RFModificationTimestamp": "2026-06-23T17:17:04Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1912.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6J5"
+"UnparsedAddress": "250 KEATS Way Unit# 6, Waterloo, Ontario N2L6J5"
+"Coordinates": array:2 [
0 => -80.5436086
1 => 43.4626712
]
+"Latitude": 43.4626712
+"Longitude": -80.5436086
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "PRIME UNIVERSITY INVESTMENT OPPORTUNITY WITH WALKOUT BASEMENT Exceptional 3-bedroom townhome with garage in the highly sought-after Keats Way complex, perfectly positioned just minutes from the University of Waterloo and Wilfrid Laurier University. This well-maintained property offers a highly desirable layout with 3 bedrooms on the upper level, a finished walkout basement with a full bathroom, and a total of 2.5 bathrooms, creating outstanding flexibility for both investors and end users. Featuring hardwood flooring, a newly renovated upper-level bathroom, and bright, functional living spaces, this home is built for both comfort and long-term durability. The walkout basement adds valuable living space and significantly enhances rental potential. This property delivers positive cash flow when fully occupied, making it a true turn-key investment in one of Waterloo's most reliable and high-demand rental markets. The inclusion of a private garage and additional parking further strengthens tenant appeal and long-term value. Located close to transit, restaurants, shopping, parks, and major commuter routes, this is a rare opportunity to secure a high-performing income property in a proven university corridor. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "720"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T17:16:42.888639+00:00"
+"Directions": "SHAKESPEARE 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": "1936827"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-23T13:52:48Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T13:52:48Z"
+"Stories": "2.0"
+"StreetName": "KEATS"
+"StreetNumber": "250"
+"StreetSuffix": "Way"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "4268"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29940575/250-keats-way-unit-6-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R-5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1312
+"BelowGradeFinishedArea": 600
+"OriginalEntryTimestamp": "2026-06-23T13:52:47.84Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1235438"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:24 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29940575')"
+"ID": "1557129"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25340
+post_id: "1557130"
+post_author: 1
+"ListingKey": "29941111"
+"ListingId": "X13477870"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T15:30:10Z"
+"RFModificationTimestamp": "2026-06-23T16:58:32Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6J5"
+"UnparsedAddress": "6 - 250 KEATS WAY, Waterloo, Ontario N2L6J5"
+"Coordinates": array:2 [
0 => -80.5438043
1 => 43.4628115
]
+"Latitude": 43.4628115
+"Longitude": -80.5438043
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "PRIME UNIVERSITY INVESTMENT OPPORTUNITY WITH WALKOUT BASEMENT Exceptional 3-bedroom townhome with garage in the highly sought-after Keats Way complex, perfectly positioned just minutes from the University of Waterloo and Wilfrid Laurier University. This well-maintained property offers a highly desirable layout with 3 bedrooms on the upper level, a finished walkout basement with a full bathroom, and a total of 2.5 bathrooms, creating outstanding flexibility for both investors and end users. Featuring hardwood flooring, a newly renovated upper-level bathroom, and bright, functional living spaces, this home is built for both comfort and long-term durability. The walkout basement adds valuable living space and significantly enhances rental potential. This property delivers positive cash flow when fully occupied, making it a true turn-key investment in one of Waterloo's most reliable and high-demand rental markets. The inclusion of a private garage and additional parking further strengthens tenant appeal and long-term value. Located close to transit, restaurants, shopping, parks, and major commuter routes, this is a rare opportunity to secure a high-performing income property in a proven university corridor. (id:62650)"
+"AssociationFee": "720"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T16:58:28.056663+00:00"
+"Directions": "Cross Streets: University and Keats Way. ** Directions: University to Keats Way."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2099844"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T15:21:21Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T15:21:21Z"
+"Stories": "2.0"
+"StreetName": "Keats"
+"StreetNumber": "250"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "4268"
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29941111/6-250-keats-way-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "wilson blanchard"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "R-5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-23T15:07:05.42Z"
+"ListAgentNationalAssociationId": "1370036"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:24 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29941111')"
+"ID": "1557130"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23432
+post_id: "1556236"
+post_author: 1
+"ListingKey": "29939963"
+"ListingId": "40842183"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T03:00:04Z"
+"RFModificationTimestamp": "2026-06-23T04:38:39Z"
+"ListPrice": 339000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1250.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6E6"
+"UnparsedAddress": "300 KEATS Way Unit# 207, Waterloo, Ontario N2L6E6"
+"Coordinates": array:2 [
0 => -80.5442195
1 => 43.4623301
]
+"Latitude": 43.4623301
+"Longitude": -80.5442195
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 300 Keats Way unit 207—a beautifully appointed 1,250 square foot condo located at the back of the building, close to traffic but away from the noise. This bright and spacious 2-bedroom, 2-bathroom condo offers an ideal blend of comfort, functionality and peace. The open-concept layout is bathed in natural light, featuring new vinyl flooring, a seamless flow from living and dining areas to a large private balcony, and a primary suite complete with a private ensuite. Additional highlights include in-suite laundry, 1 underground parking spaces, and a dedicated storage locker. The building is exceptionally well-maintained, with recent updates including a new roof, newer underground garage, upgraded intercom system, and a strengthened reserve fund. Residents enjoy amenities such as a fitness centre and billiards room. Located in the heart of Beechwood/university, moments from Uptown Waterloo, University of Waterloo, Wilfrid Laurier University, Keats way public School , WCI Secondary School, T&T Supermarket, parks, trails, and transit—this move-in-ready home offers spacious living in a quiet, amenity-rich building. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "1037.87"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:7 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Water"
4 => "Insurance"
5 => "Parking"
6 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T04:38:32.452163+00:00"
+"Directions": "UNIVERSITY AVE TO KEATS WAY"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2175198"
+"ListOfficeKey": "292482"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-23T02:50:17Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T02:50:17Z"
+"Stories": "1.0"
+"StreetName": "KEATS"
+"StreetNumber": "300"
+"StreetSuffix": "Way"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2260"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29939963/300-keats-way-unit-207-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Car Wash"
1 => "Party Room"
]
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1250
+"OriginalEntryTimestamp": "2026-06-23T02:50:16.8Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1425540"
+"ListOfficeNationalAssociationId": "1412629"
+"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('29939963')"
+"ID": "1556236"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25353
+post_id: "1556237"
+post_author: 1
+"ListingKey": "29940024"
+"ListingId": "X13477170"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T03:50:00Z"
+"RFModificationTimestamp": "2026-06-23T04:34:23Z"
+"ListPrice": 339000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6E6"
+"UnparsedAddress": "#207 - 300 KEATS WAY, Waterloo, Ontario N2L6E6"
+"Coordinates": array:2 [
0 => -80.544516
1 => 43.462144
]
+"Latitude": 43.462144
+"Longitude": -80.544516
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 300 Keats Way unit 207-a beautifully appointed 1,250 square foot condo located at the back of the building, close to traffic but away from the noise. This bright and spacious 2-bedroom, 2-bathroom condo offers an ideal blend of comfort, functionality and peace. The open-concept layout is bathed in natural light, featuring new vinyl flooring, a seamless flow from living and dining areas to a large private balcony, and a primary suite complete with a private ensuite. Additional highlights include in-suite laundry, 1 underground parking spaces, and a dedicated storage locker. The building is exceptionally well-maintained, with recent updates including a new roof, newer underground garage, upgraded intercom system, and a strengthened reserve fund. Residents enjoy amenities such as a fitness centre and billiards room. Located in the heart of Beechwood/university, moments from Uptown Waterloo, University of Waterloo, Wilfrid Laurier University, Keats way public School , WCI Secondary School, T&T Supermarket, parks, trails, and transit-this move-in-ready home offers spacious living in a quiet, amenity-rich building. (id:62650)"
+"AssociationFee": "1037.87"
+"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-23T04:34:17.703271+00:00"
+"Directions": "UNIVERSITY AVE TO KEATS WAY"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2135760"
+"ListOfficeKey": "70066"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-23T03:41:02Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T03:41:02Z"
+"StreetName": "KEATS"
+"StreetNumber": "300"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "2260"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29940024/207-300-keats-way-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "TREVARREN PROP MGMT"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-23T03:41:02.41Z"
+"ListAgentNationalAssociationId": "1388108"
+"ListOfficeNationalAssociationId": "1132867"
+"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('29940024')"
+"ID": "1556237"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25354
+post_id: "1555410"
+post_author: 1
+"ListingKey": "29938461"
+"ListingId": "X13476114"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T18:55:18Z"
+"RFModificationTimestamp": "2026-06-23T18:59:03Z"
+"ListPrice": 1290000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2R2"
+"UnparsedAddress": "450 WESTHAVEN STREET, Waterloo, Ontario N2T2R2"
+"Coordinates": array:2 [
0 => -80.566908
1 => 43.445283
]
+"Latitude": 43.445283
+"Longitude": -80.566908
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 450 Westhaven Street, a beautifully upgraded Ritz Homes residence in one of Waterloo's most sought after family neighbourhoods. Less than one year old, this stunning home offers approximately 2,320 sq ft above grade plus a finished basement, featuring quartz countertops throughout, a designer kitchen with a custom coffee bar, engineered hardwood flooring, oak staircases with black metal pickets, and no carpet throughout. The finished lower level adds exceptional versatility with a spacious recreation room, additional bedroom, full bathroom, and a convenient kitchenette complete with a sink, making it ideal for extended family, guests, or multi generational living. Complete with 200 amp service, central air conditioning, gas lines for the stove and BBQ, and numerous builder upgrades, this move in ready home offers the perfect blend of style, comfort, and functionality.Ideally situated in the highly desirable Westvale area of Waterloo, this home is surrounded by excellent schools, beautiful parks, walking trails, playgrounds, and family friendly amenities. Enjoy convenient access to shopping, restaurants, Costco, The Boardwalk, universities, public transit, and major commuter routes including Highway 7/8. Whether you're raising a family, working from home, or simply looking for a newer home in a thriving community, 450 Westhaven Street delivers exceptional value in one of Waterloo's most convenient and connected locations. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
]
+"Basement": array:7 [
0 => "Finished"
1 => "Full"
2 => "Apartment in basement"
3 => "Separate entrance"
4 => "N/A"
5 => "N/A"
6 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T21:22:19.317367+00:00"
+"Directions": "Cross Streets: Erb Street W to Westhaven Street. ** Directions: Erb Street W."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2071055"
+"ListOfficeKey": "148048"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "Guest Suite"
2 => "In-Law Suite"
]
+"LotSizeDimensions": "31.5 x 113.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T18:47:40Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T18:47:40Z"
+"Stories": "2.0"
+"StreetName": "Westhaven"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3794.36"
+"VirtualTourURLUnbranded": "https://calibre-media.aryeo.com/sites/rojnzoxv/unbranded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29938461/450-westhaven-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "SR-1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 31.6
+"OriginalEntryTimestamp": "2026-06-22T20:49:22.68Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1346258"
+"ListOfficeNationalAssociationId": "1177786"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29938461')"
+"ID": "1555410"
}
]
+success: true
+page_size: 9
+page_count: 14
+count: 119
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]