array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29768533 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1434056"
+post_author: 1
+"ListingKey": "29768533"
+"ListingId": "40831205"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T23:50:23Z"
+"RFModificationTimestamp": "2026-06-09T23:53:46Z"
+"ListPrice": 825000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1795.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2T2"
+"UnparsedAddress": "350 HAVENDALE Crescent, Waterloo, Ontario N2T2T2"
+"Coordinates": array:2 [
0 => -80.5809198
1 => 43.4713359
]
+"Latitude": 43.4713359
+"Longitude": -80.5809198
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright and spacious three bedroom three bathroom double garage single family house in most desirable Laurelwood with one of best schools and amenities, walking distance for your kids from Kindergarten to high school, as well as to YMCA, library and shopping center, Laurel Creek conservation area , and on convenient bus route to both Universities. Main floor has open concept and full of sunshine in winter time, big kitchen has lots of maple cupboards and a big island, living room has a vaulted ceiling , a fireplace surrounded by huge windows. 3 spacious bedroom on second floor, master bedroom has ensuite .unspoiled basement for your personal touch. don't miss this one! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Water softener"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-19T14:42:05.615280+00:00"
+"Directions": "Laurelwood"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564082"
+"ListOfficeKey": "222711"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"PhotosChangeTimestamp": "2026-05-19T14:13:42Z"
+"PhotosCount": 14
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T23:42:36Z"
+"Stories": "2.0"
+"StreetName": "HAVENDALE"
+"StreetNumber": "350"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5639.62"
+"Utilities": array:1 [
0 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1655966607"
"RoomType" => "Full bathroom"
"ListingId" => "40831205"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29768533"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:42:36.85Z"
]
1 => array:11 [
"RoomKey" => "1655966608"
"RoomType" => "4pc Bathroom"
"ListingId" => "40831205"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29768533"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:42:36.85Z"
]
2 => array:11 [
"RoomKey" => "1655966609"
"RoomType" => "3pc Bathroom"
"ListingId" => "40831205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29768533"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:42:36.85Z"
]
3 => array:11 [
"RoomKey" => "1655966610"
"RoomType" => "Bedroom"
"ListingId" => "40831205"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29768533"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:42:36.86Z"
]
4 => array:11 [
"RoomKey" => "1655966611"
"RoomType" => "Bedroom"
"ListingId" => "40831205"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29768533"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:42:36.86Z"
]
5 => array:11 [
"RoomKey" => "1655966612"
"RoomType" => "Primary Bedroom"
"ListingId" => "40831205"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29768533"
"RoomLength" => null
"RoomDimensions" => "15'1'' x 15'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:42:36.86Z"
]
6 => array:11 [
"RoomKey" => "1655966613"
"RoomType" => "Great room"
"ListingId" => "40831205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29768533"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 21'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:42:36.86Z"
]
7 => array:11 [
"RoomKey" => "1655966614"
"RoomType" => "Dining room"
"ListingId" => "40831205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29768533"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:42:36.86Z"
]
8 => array:11 [
"RoomKey" => "1655966615"
"RoomType" => "Kitchen"
"ListingId" => "40831205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29768533"
"RoomLength" => null
"RoomDimensions" => "12'3'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:42:36.86Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29768533/350-havendale-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 35.0
+"AboveGradeFinishedArea": 1795
+"OriginalEntryTimestamp": "2026-05-19T14:11:05.19Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Appraiser"
+"ListAgentNationalAssociationId": "1130381"
+"ListOfficeNationalAssociationId": "1197443"
+"Media": array:14 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29768533_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768533/d3a44c21d9356f9cde86b17926771b48.webp"
"MediaSize" => 79254
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768533/thumbnail-d3a44c21d9356f9cde86b17926771b48.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring a brick and siding exterior with an integrated garage"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40831205"
"ResourceRecordKey" => "29768533"
"ModificationTimestamp" => "2026-05-19T14:13:39.56Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29768533_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768533/9fda3d83bad70c106b71a9cf193e4e89.webp"
"MediaSize" => 69166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768533/thumbnail-9fda3d83bad70c106b71a9cf193e4e89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring wood-finish cabinetry, stainless steel appliances, a center island with an extended countertop, a double basin sink, and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831205"
"ResourceRecordKey" => "29768533"
"ModificationTimestamp" => "2026-05-19T14:13:42.65Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29768533_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768533/509e8823e19b04475ad480cc30d3ed44.webp"
"MediaSize" => 102025
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768533/thumbnail-509e8823e19b04475ad480cc30d3ed44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring vaulted ceilings, a central fireplace with a mantel, and decorative arched windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831205"
"ResourceRecordKey" => "29768533"
"ModificationTimestamp" => "2026-05-19T14:13:42.66Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29768533_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768533/4831fb5f7ebb38c96d0997a2cb8cc614.webp"
"MediaSize" => 71834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768533/thumbnail-4831fb5f7ebb38c96d0997a2cb8cc614.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept kitchen and dining area featuring light-toned cabinetry, stainless steel appliances, and a breakfast bar"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831205"
"ResourceRecordKey" => "29768533"
"ModificationTimestamp" => "2026-05-19T14:13:39.56Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29768533_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768533/1da709b8c76e42804e9932d6b4831094.webp"
"MediaSize" => 40616
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768533/thumbnail-1da709b8c76e42804e9932d6b4831094.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring ceramic tile flooring, light tan wall paint, recessed lighting, and white bi-fold doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831205"
"ResourceRecordKey" => "29768533"
"ModificationTimestamp" => "2026-05-19T14:13:39.56Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29768533_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768533/570ef8d82fa3496601dead00abea1315.webp"
"MediaSize" => 65732
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768533/thumbnail-570ef8d82fa3496601dead00abea1315.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring a vaulted ceiling and an arched window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831205"
"ResourceRecordKey" => "29768533"
"ModificationTimestamp" => "2026-05-19T14:13:42.66Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29768533_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768533/3a41524b973e0e0d515f5244982bb5eb.webp"
"MediaSize" => 56083
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768533/thumbnail-3a41524b973e0e0d515f5244982bb5eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted room with neutral-toned walls and a single window with blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831205"
"ResourceRecordKey" => "29768533"
"ModificationTimestamp" => "2026-05-19T14:13:39.56Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29768533_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768533/98e205862f69ba250f8f2417db87c994.webp"
"MediaSize" => 44960
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768533/thumbnail-98e205862f69ba250f8f2417db87c994.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831205"
"ResourceRecordKey" => "29768533"
"ModificationTimestamp" => "2026-05-19T14:13:39.56Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29768533_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768533/3296d56d7637c0b162e24c416d6fc4b3.webp"
"MediaSize" => 44246
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768533/thumbnail-3296d56d7637c0b162e24c416d6fc4b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Recessed closet featuring bi-fold panel doors with circular hardware, set against a light purple wall and neutral carpet flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831205"
"ResourceRecordKey" => "29768533"
"ModificationTimestamp" => "2026-05-19T14:13:39.56Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29768533_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768533/d5a010898d3c1444c6053febc525514d.webp"
"MediaSize" => 44810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768533/thumbnail-d5a010898d3c1444c6053febc525514d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a built-in bathtub with shower, toilet, and vanity with countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831205"
"ResourceRecordKey" => "29768533"
"ModificationTimestamp" => "2026-05-19T14:13:39.58Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29768533_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768533/e89fa22cc53e0678b38568e93a325ff6.webp"
"MediaSize" => 58283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768533/thumbnail-e89fa22cc53e0678b38568e93a325ff6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a single basin vanity with an oval sink, an integrated countertop, and white cabinetry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831205"
"ResourceRecordKey" => "29768533"
"ModificationTimestamp" => "2026-05-19T14:13:39.56Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29768533_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768533/fb7fcf98aaba0bbaae68f7acb9cec409.webp"
"MediaSize" => 56169
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768533/thumbnail-fb7fcf98aaba0bbaae68f7acb9cec409.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom vanity featuring a laminate countertop, integrated sink, and wood cabinetry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831205"
"ResourceRecordKey" => "29768533"
"ModificationTimestamp" => "2026-05-19T14:13:39.56Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29768533_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768533/7d2b167f14b2b29076a08c214188d45f.webp"
"MediaSize" => 38638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768533/thumbnail-7d2b167f14b2b29076a08c214188d45f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a corner glass-enclosed shower, white vanity with integrated sink, light-toned countertop, and a toilet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831205"
"ResourceRecordKey" => "29768533"
"ModificationTimestamp" => "2026-05-19T14:13:39.56Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29768533_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29768533/b3dca960b7b4b2f9f118003458cdd164.webp"
"MediaSize" => 176537
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29768533/thumbnail-b3dca960b7b4b2f9f118003458cdd164.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Outdoor wood deck with a built-in wood bench"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40831205"
"ResourceRecordKey" => "29768533"
"ModificationTimestamp" => "2026-05-19T14:13:39.56Z"
]
]
+"DaysOnMarket": 43
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29768533')"
+"ID": "1434056"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 222711" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24812
+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 1564082" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24803
+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 '29768533'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25180
+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 '29768533'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25196
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29768533' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5809198 43.4713359)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25249
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25243
+post_id: "1582426"
+post_author: 1
+"ListingKey": "29975146"
+"ListingId": "40843757"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T15:00:07Z"
+"RFModificationTimestamp": "2026-07-01T16:49:13Z"
+"ListPrice": 1995000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3951.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2G3"
+"UnparsedAddress": "585 REGAL Place, Waterloo, Ontario N2V2G3"
+"Coordinates": array:2 [
0 => -80.6020125
1 => 43.4785166
]
+"Latitude": 43.4785166
+"Longitude": -80.6020125
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Positioned on a beautifully landscaped corner lot at the end of a quiet cul-de-sac, 585 Regal Place offers an exceptional blend of luxury, comfort, and everyday livability in one of Waterloo's most sought-after neighbourhoods. This former model home showcases over 4,300 sq. ft. of thoughtfully designed living space, including more than 3,500 sq. ft. on the main level, complemented by an oversized triple-car garage with soaring ceilings and a dedicated workshop area. A cobblestone driveway and covered front entrance introduce an impressive interior where 10-foot ceilings, expansive windows, and spacious principal rooms create an inviting atmosphere filled with natural light. The chef-inspired kitchen serves as the heart of the home, offering custom cabinetry, granite countertops, premium appliances, a large island, and seamless access to the breakfast area and covered outdoor living space, making entertaining effortless in every season. Elegant formal living and dining rooms provide refined spaces for hosting, accented by rich hardwood flooring, statement lighting, and walls perfectly suited for displaying artwork. The luxurious primary suite is a private sanctuary featuring a spa-inspired ensuite with a double-sided fireplace, soaker tub, and an expansive custom dressing room. Two additional bedrooms, including a private ensuite, a dedicated home office, main-floor laundry, and a beautifully finished lower level with recreation, fitness, and guest accommodations ensure flexibility for every stage of life. Professionally landscaped gardens, mature trees, and multiple outdoor seating areas create a peaceful setting to relax or entertain. Just minutes from championship golf, scenic walking trails, the St. Jacobs Farmers' Market, shopping, and highly regarded schools, this remarkable residence delivers the space, quality, and lifestyle today's discerning buyer is seeking. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Wine Fridge"
6 => "Stove"
7 => "Dryer"
8 => "Microwave"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T16:49:07.978429+00:00"
+"Directions": "Erbsville Rd to Regal Place"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564461"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T14:50:30Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T14:50:30Z"
+"Stories": "1.0"
+"StreetName": "REGAL"
+"StreetNumber": "585"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "18533"
+"VirtualTourURLUnbranded": "https://youriguide.com/585_regal_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [
"RoomKey" => "1672685731"
"RoomType" => "Utility room"
"ListingId" => "40843757"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "17'2'' x 8'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.72Z"
]
1 => array:11 [
"RoomKey" => "1672685732"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843757"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.73Z"
]
2 => array:11 [
"RoomKey" => "1672685733"
"RoomType" => "Storage"
"ListingId" => "40843757"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "22'5'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.73Z"
]
3 => array:11 [
"RoomKey" => "1672685734"
"RoomType" => "Cold room"
"ListingId" => "40843757"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "7'4'' x 8'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.73Z"
]
4 => array:11 [
"RoomKey" => "1672685735"
"RoomType" => "Bedroom"
"ListingId" => "40843757"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "16'7'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.73Z"
]
5 => array:11 [
"RoomKey" => "1672685736"
"RoomType" => "Laundry room"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "14'3'' x 8'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.73Z"
]
6 => array:11 [
"RoomKey" => "1672685737"
"RoomType" => "Full bathroom"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.73Z"
]
7 => array:11 [
"RoomKey" => "1672685738"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "19'5'' x 14'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.74Z"
]
8 => array:11 [
"RoomKey" => "1672685739"
"RoomType" => "3pc Bathroom"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.74Z"
]
9 => array:11 [
"RoomKey" => "1672685740"
"RoomType" => "Bedroom"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "15'6'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.74Z"
]
10 => array:11 [
"RoomKey" => "1672685741"
"RoomType" => "2pc Bathroom"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.74Z"
]
11 => array:11 [
"RoomKey" => "1672685742"
"RoomType" => "Office"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "16'8'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.74Z"
]
12 => array:11 [
"RoomKey" => "1672685743"
"RoomType" => "Living room"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "23'8'' x 29'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.74Z"
]
13 => array:11 [
"RoomKey" => "1672685744"
"RoomType" => "Dining room"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "15'11'' x 13'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.74Z"
]
14 => array:11 [
"RoomKey" => "1672685745"
"RoomType" => "Breakfast"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "12'8'' x 17'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.74Z"
]
15 => array:11 [
"RoomKey" => "1672685746"
"RoomType" => "Kitchen"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "14'7'' x 17'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.75Z"
]
16 => array:11 [
"RoomKey" => "1672685747"
"RoomType" => "Foyer"
"ListingId" => "40843757"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29975146"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 8'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T14:50:30.75Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29975146/585-regal-place-waterloo"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Monitored Alarm"
]
+"ZoningDescription": "SR4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 87.0
+"AboveGradeFinishedArea": 3181
+"BelowGradeFinishedArea": 770
+"OriginalEntryTimestamp": "2026-07-01T14:50:30.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1070059"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:44 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29975146_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/4c9b3f1b7028ce5f31e9490e090ff8d9.webp"
"MediaSize" => 157422
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-4c9b3f1b7028ce5f31e9490e090ff8d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29975146_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/79e71b694d192bc9867f88fed4297945.webp"
"MediaSize" => 129944
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-79e71b694d192bc9867f88fed4297945.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29975146_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/e76ebfa3ba9f6fc604ca9384a83c90d1.webp"
"MediaSize" => 146558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-e76ebfa3ba9f6fc604ca9384a83c90d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29975146_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/88dfddb51ef472fb3e74ac65c2e90860.webp"
"MediaSize" => 126567
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-88dfddb51ef472fb3e74ac65c2e90860.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29975146_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/e16ac9562baa1de9818e9a7df82669db.webp"
"MediaSize" => 105577
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-e16ac9562baa1de9818e9a7df82669db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29975146_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/2c6a752ca0e19359f2e8d9d5ec56c8ec.webp"
"MediaSize" => 94021
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-2c6a752ca0e19359f2e8d9d5ec56c8ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29975146_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/3c4140f226984726dd3da101e068673e.webp"
"MediaSize" => 98660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-3c4140f226984726dd3da101e068673e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29975146_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/1264c4e672334c51e8c4294c0bd3c153.webp"
"MediaSize" => 94198
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-1264c4e672334c51e8c4294c0bd3c153.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29975146_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/9fec1388c8422ad4488b1f3fce8c5497.webp"
"MediaSize" => 138312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-9fec1388c8422ad4488b1f3fce8c5497.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29975146_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/c41152dcc9cc981a7fb1368441d0fe9b.webp"
"MediaSize" => 128466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-c41152dcc9cc981a7fb1368441d0fe9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29975146_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/3b5107da635cca1b1f5630d4e4943c50.webp"
"MediaSize" => 95096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-3b5107da635cca1b1f5630d4e4943c50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29975146_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/2d211c78f0202481b3b76050ecafd1b1.webp"
"MediaSize" => 122086
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-2d211c78f0202481b3b76050ecafd1b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29975146_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/8a5dc8cee311ab9767ff61fa06cd5af9.webp"
"MediaSize" => 106604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-8a5dc8cee311ab9767ff61fa06cd5af9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29975146_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/c91596d6b2fd4f761e22a209f474892a.webp"
"MediaSize" => 128191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-c91596d6b2fd4f761e22a209f474892a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29975146_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/e4798c57e18ded018f700eedf2a6b9e4.webp"
"MediaSize" => 142571
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-e4798c57e18ded018f700eedf2a6b9e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29975146_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/e934e34eacaf7594428b9a4ed1cf7526.webp"
"MediaSize" => 157514
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-e934e34eacaf7594428b9a4ed1cf7526.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29975146_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/1f431697421281a7620d903e47b0924f.webp"
"MediaSize" => 143772
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-1f431697421281a7620d903e47b0924f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29975146_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/9a7dabdfb854891023175a675edbc7ad.webp"
"MediaSize" => 117750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-9a7dabdfb854891023175a675edbc7ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29975146_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/c2d1172c3a64135941698174e6186428.webp"
"MediaSize" => 110498
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-c2d1172c3a64135941698174e6186428.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29975146_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/00ccf8757e62aa47d4a7ae15e92bb343.webp"
"MediaSize" => 74988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-00ccf8757e62aa47d4a7ae15e92bb343.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29975146_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/23ecc0025e67da1bd956297984d9e989.webp"
"MediaSize" => 70948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-23ecc0025e67da1bd956297984d9e989.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29975146_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/70d7a60e752744c2ebb9ed7dbb057edc.webp"
"MediaSize" => 125647
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-70d7a60e752744c2ebb9ed7dbb057edc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29975146_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/a3f7746f23bb972a85d6c1f1d5ac48c8.webp"
"MediaSize" => 91865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-a3f7746f23bb972a85d6c1f1d5ac48c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29975146_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/aa9a6db839ab3543579aa26fb7585d3a.webp"
"MediaSize" => 55914
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-aa9a6db839ab3543579aa26fb7585d3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29975146_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/c1a74d66ba68a2e4e6eb563b34d9a600.webp"
"MediaSize" => 137910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-c1a74d66ba68a2e4e6eb563b34d9a600.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29975146_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/f0037c19b27659c02141cbd4e7414264.webp"
"MediaSize" => 104684
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-f0037c19b27659c02141cbd4e7414264.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29975146_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/373a7e07ac994faaf3607e87da446bda.webp"
"MediaSize" => 88474
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-373a7e07ac994faaf3607e87da446bda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29975146_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/834eb872e74d8adfac10f5c476fdb04d.webp"
"MediaSize" => 87990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-834eb872e74d8adfac10f5c476fdb04d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29975146_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/174506f7696285107801c9e1be0dbe20.webp"
"MediaSize" => 84287
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-174506f7696285107801c9e1be0dbe20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
"ModificationTimestamp" => "2026-07-01T14:50:30.67Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29975146_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29975146/4e0a4a24f4742cf10f12208037ba7f1c.webp"
"MediaSize" => 114592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29975146/thumbnail-4e0a4a24f4742cf10f12208037ba7f1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843757"
"ResourceRecordKey" => "29975146"
…1
]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29975146')"
+"ID": "1582426"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25245
+post_id: "1582284"
+post_author: 1
+"ListingKey": "29974955"
+"ListingId": "40840178"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T17:00:10Z"
+"RFModificationTimestamp": "2026-07-01T17:11:48Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1929.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2W5"
+"UnparsedAddress": "980 CREEKSIDE Drive, Waterloo, Ontario N2V2W5"
+"Coordinates": array:2 [
0 => -80.5995972
1 => 43.4717177
]
+"Latitude": 43.4717177
+"Longitude": -80.5995972
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 980 Creekside Drive, a move-in-ready freehold townhome in Waterloo’s highly sought-after Laurelwood community — an ideal starter home for young families looking to settle near top-rated schools, parks, shopping, and everyday conveniences. This well-maintained 3-bedroom, 3.5-bathroom two-storey home offers a bright and functional open-concept main floor with a carpet-free layout, laminate flooring, and sliding doors leading to a private deck and fully fenced backyard — perfect for children, pets, and outdoor family time. The kitchen features ample cabinetry, stainless steel appliances, and a sleek glass backsplash, creating a practical and inviting space for busy family living. Upstairs, the spacious primary bedroom includes a walk-in closet with organizer and private ensuite, while the additional bedrooms are well-sized for children, guests, or a home office. The fully finished lower level provides valuable extra living space with a recreation room, 3-piece bathroom, laundry area, and storage room — ideal for a playroom, family movie nights, or a flexible work-from-home setup. Located within walking distance to schools, shopping, public transit, and close to the YMCA, universities, The Boardwalk, St. Jacobs Farmers’ Market, and the Waterloo Costco, this home offers the perfect blend of comfort, convenience, and community. A fantastic opportunity for first-time buyers and young families to own a move-in-ready home in one of Waterloo’s most desirable family-friendly neighbourhoods. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T14:51:04.303021+00:00"
+"Directions": "Laurelwood Drive Erbsville Road"
+"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": "2130071"
+"ListOfficeKey": "300812"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T16:40:42Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T16:51:27Z"
+"Stories": "2.0"
+"StreetName": "CREEKSIDE"
+"StreetNumber": "980"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "3521"
+"VirtualTourURLUnbranded": "https://realty.pixsouls.com/980-Creekside-Dr"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29974955/980-creekside-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR50"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 22.0
+"AboveGradeFinishedArea": 1408
+"BelowGradeFinishedArea": 521
+"OriginalEntryTimestamp": "2026-07-01T14:10:29.26Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1382995"
+"ListOfficeNationalAssociationId": "1493167"
+"Media": array:46 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29974955')"
+"ID": "1582284"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25242
+post_id: "1579538"
+post_author: 1
+"ListingKey": "29971250"
+"ListingId": "40842678"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T17:46:24Z"
+"RFModificationTimestamp": "2026-06-30T18:23:55Z"
+"ListPrice": 539900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1163.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A8"
+"UnparsedAddress": "776 LAURELWOOD Drive Unit# 716, Waterloo, Ontario N2V0A8"
+"Coordinates": array:2 [
0 => -80.5986515
1 => 43.4706239
]
+"Latitude": 43.4706239
+"Longitude": -80.5986515
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Fantastic opportunity to own this one-of-a-kind corner penthouse offering stunning southwest exposure in one of the area's most desirable neighbourhoods, surrounded by conservation lands and top-rated schools. This beautifully updated condo features a renovated kitchen, carpet free flooring, and numerous upgrades throughout. The impressive kitchen boasts an oversized island with white quartz countertops, a modern white subway tile backsplash, under-cabinet lighting, and a walkout to the private balcony, where you can enjoy unobstructed panoramic city views. One of only four units in the building with a cathedral ceiling, this penthouse offers an exceptionally bright, open, and airy living space, with natural light streaming in from windows on multiple sides. The spacious primary bedroom features large windows, a private walkout to the balcony, and an updated ensuite with a glass walk-in shower. The second bedroom is thoughtfully positioned on the opposite side of the unit for added privacy and is complemented by a full 4-piece bathroom. Additional highlights include upgraded interior doors, baseboards, lighting fixtures, two owned underground parking spaces, and an oversized storage locker. Simply move in and enjoy low-maintenance condo living in an exceptional location. Be sure to check out the 360-degree panoramas! (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Microwave"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"AssociationFee": "477.11"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T18:23:23.421739+00:00"
+"Directions": "ERBSVILLE ROAD TO LAURELWOOD DRIVE"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1600658"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Balcony"
3 => "Paved driveway"
4 => "Skylight"
5 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-30T17:11:48Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T17:11:48Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "776"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4297"
+"View": "View (panoramic)"
+"VirtualTourURLUnbranded": "https://youriguide.com/716_776_laurelwood_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29971250/776-laurelwood-drive-unit-716-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2070594"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "MR100"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1163
+"OriginalEntryTimestamp": "2026-06-30T17:11:48.13Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1153962"
+"ListOfficeNationalAssociationId": "1389824"
+"CoListAgentNationalAssociationId": "1345744"
+"CoListOfficeNationalAssociationId": "1004387"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29971250')"
+"ID": "1579538"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25246
+post_id: "1575466"
+post_author: 1
+"ListingKey": "29964973"
+"ListingId": "40843611"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T13:55:11Z"
+"RFModificationTimestamp": "2026-06-29T17:23:56Z"
+"ListPrice": 519900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 2092.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N3"
+"UnparsedAddress": "465 COLUMBIA Street W Unit# 4, Waterloo, Ontario N2T2N3"
+"Coordinates": array:2 [
0 => -80.5699679
1 => 43.4659574
]
+"Latitude": 43.4659574
+"Longitude": -80.5699679
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Move-in Ready. Prestigious Upper Beechwood bungalow end-unit condo nestled among the beautiful treed surroundings of Roxton Park. Offering carefree living style for the busy professional, young executive & active empty nesters. An intimate complex with 8 owners. Filled with natural light, this elegant bungalow features large windows, transoms, soaring 9’ ceilings, 3 full bathrooms, and 2 walkouts. The spacious kitchen with a dinette showcases an impressive 12’ ceiling, while the open-concept dining area and great room create an inviting atmosphere complete with oversized windows and a cozy gas fireplace. The primary bedroom retreat offers a beautifully updated 3pc ensuite featuring quartz countertops and a glass shower. Step outside from the 2nd bedroom to the oversized deck and enjoy peaceful views in a serene setting. The finished lower level adds exceptional living space with a large recreation room and an additional full bathroom. Recent Updates: Kitchen sink faucet (2026), Range Hood (2021), newly painted most walls (2026), all 3 bathroom vanities, faucets and toilets (2024, 2026). Master bedroom ensuite shower (2024). Dining room sliding door (2020). Gas Fireplace (2021). Dryer (2018). Washer (2020). Outstanding location within walking distance to Shopping, Roxton Park, Conservation area, transit, University of Waterloo, Library, YMCA. A short drive to Costco, the Boardwalk, and all other amenities. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"AssociationFee": "911.75"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T17:23:46.447783+00:00"
+"Directions": "Fischer-Hallman Rd N to Columbia St W"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1970409"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T13:50:03Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T13:50:03Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "COLUMBIA"
+"StreetNumber": "465"
+"StreetSuffix": "Street"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "4795"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/465-Columbia-St-W-unit-4"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29964973/465-columbia-street-w-unit-4-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1301
+"BelowGradeFinishedArea": 791
+"OriginalEntryTimestamp": "2026-06-29T13:50:03.77Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1257707"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964973')"
+"ID": "1575466"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25244
+post_id: "1574246"
+post_author: 1
+"ListingKey": "29963571"
+"ListingId": "40840611"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T01:30:15Z"
+"RFModificationTimestamp": "2026-06-28T04:35:44Z"
+"ListPrice": 549000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1482.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2X1"
+"UnparsedAddress": "619 WILD GINGER Avenue Unit# H45, Waterloo, Ontario N2V2X1"
+"Coordinates": array:2 [
0 => -80.5941875
1 => 43.469623
]
+"Latitude": 43.469623
+"Longitude": -80.5941875
+"YearBuilt": 2006
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to easy living in this spacious four level townhome offering a thoughtful layout and plenty of flexible space. The main level features a bright kitchen and dining area with access to a front balcony, perfect for morning coffee or summer BBQs. A convenient two piece bathroom and inviting living room overlook the private backyard, creating a comfortable space for everyday living and entertaining. Upstairs, you'll find two generously sized bedrooms and a full bathroom. The lower level rec room provides additional living space and could easily serve as a third bedroom, home office, or family room. Step outside from this level onto the deck and enjoy the privacy of your own backyard retreat. Laundry is conveniently located just inside the attached garage, adjacent to the rec room. The fourth level offers plenty of storage in the utility room and includes a bathroom rough in, providing potential for future expansion. With an attached garage, multiple outdoor living spaces, and a versatile floor plan, this home is an excellent opportunity for first-time buyers, downsizers, or investors alike. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
]
+"AssociationFee": "258"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Property Management"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-28T04:35:40.657011+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1978914"
+"ListOfficeKey": "283168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-28T01:21:05Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T01:21:04Z"
+"Stories": "3.0"
+"StreetName": "WILD GINGER"
+"StreetNumber": "619"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3685"
+"VirtualTourURLUnbranded": "https://youriguide.com/h45_619_wild_ginger_ave_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29963571/619-wild-ginger-avenue-unit-h45-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2161263"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "283168"
+"GeocodeManualYN": true
+"ZoningDescription": "70-RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1482
+"OriginalEntryTimestamp": "2026-06-28T01:21:04.9Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1264841"
+"ListOfficeNationalAssociationId": "1325206"
+"CoListAgentNationalAssociationId": "1412362"
+"CoListOfficeNationalAssociationId": "1325206"
+"Media": array:35 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29963571')"
+"ID": "1574246"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25239
+post_id: "1574187"
+post_author: 1
+"ListingKey": "29963570"
+"ListingId": "40841161"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T02:15:21Z"
+"RFModificationTimestamp": "2026-06-28T02:17:27Z"
+"ListPrice": 539900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1800.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2P7"
+"UnparsedAddress": "350 ERBSVILLE Road Unit# 3, Waterloo, Ontario N2T2P7"
+"Coordinates": array:2 [
0 => -80.5789343
1 => 43.4607288
]
+"Latitude": 43.4607288
+"Longitude": -80.5789343
+"YearBuilt": 1994
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "There’s a reason people hold onto these units for an average of 25 years. If you’ve been looking for that perfect middle ground, more space than a starter home, a backyard that’s actually private, and a neighbourhood where kids still ride their bikes to the park, this is it. The main floor is designed for how families actually live. Flowing naturally from a bright living room into the kitchen and dining area White shaker cabinetry, stainless steel appliances, and sliding doors out to the yard. Upstairs, you’ll find three genuinely spacious bedrooms. The primary bedroom easily fits a king-sized bed and offers ensuite privilege to a bright, updated 5-piece bathroom. Need a playroom, a home office, or just somewhere to send the kids when they’re being loud? The fully finished basement has you covered. It features a massive rec room with pot lights, and a convenient 3-piece bathroom, plus dedicated laundry and storage space. Now, let’s talk about the lifestyle. You’re steps from the Laurel Creek Conservation Area, meaning weekend hikes, canoeing, and trails are practically in your backyard. You’ve got the Stork Family YMCA and the John M. Harper Library just down the street. Need to run errands? The Boardwalk and Costco are minutes away for groceries, and restaurants. Plus, you’re in the catchment for some of the best schools in the region, including Laurel Heights Secondary School. And the best part? The condo fees are only $230 a month, and they’ve barely increased in years. It’s the peace of mind of a well-managed complex with the space and privacy of a freehold feel. If you’re outgrowing your condo or starter home, this is the exact upgrade you’ve been looking for. It’s the perfect blend of space, location, and neighbourhood. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "230"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-28T01:52:07.760475+00:00"
+"Directions": "Nearest Intersection: Erbsville Rd & Columbia St. W."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027560"
+"ListOfficeKey": "289848"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-28T01:20:59Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T02:02:40Z"
+"Stories": "2.0"
+"StreetName": "ERBSVILLE"
+"StreetNumber": "350"
+"StreetSuffix": "Road"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "3425"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/cjdyt_3_350_erbsville_rd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29963570/350-erbsville-road-unit-3-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD-3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1275
+"BelowGradeFinishedArea": 525
+"OriginalEntryTimestamp": "2026-06-28T01:20:58.81Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1306927"
+"ListOfficeNationalAssociationId": "1381908"
+"Media": array:35 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29963570')"
+"ID": "1574187"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1574016"
+post_author: 1
+"ListingKey": "29963363"
+"ListingId": "X13498204"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T00:30:35Z"
+"RFModificationTimestamp": "2026-06-28T00:33:22Z"
+"ListPrice": 537888.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2K7"
+"UnparsedAddress": "3 - 601 COLUMBIA FOREST BOULEVARD, Waterloo, Ontario N2V2K7"
+"Coordinates": array:2 [
0 => -80.5844243
1 => 43.4647062
]
+"Latitude": 43.4647062
+"Longitude": -80.5844243
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this exclusive Columbia Forest Estates enclave of Waterloo! This premium, turn-key townhome offers the perfect blend of modern styling, functional space, & unbeatable location convenience. Step inside to discover a freshly updated, open-concept main level featuring brand-new luxury flooring, modern trim, and an abundance of natural light. The seamlessly connected kitchen/dining area, & inviting living room complete with a cozy gas fireplace creates the ultimate hub for entertaining or everyday family living. The kitchen comes fully equipped with a suite of appliances, including a brand-new refrigerator and over-the-range microwave along with the already existing stainless dishwasher and stove. Upstairs and down, an intelligently designed layout delivers a rare 4-bedroom setup that offers privacy & flexibility. It is perfectly configured with two full 4-piece bathrooms plus a convenient main-floor powder room. The lower level adds immense value, boasting a versatile recreation or home office space, or a separate guest room, and space for dedicated laundry. Step outside to your private backyard with a natural gas hookup for seamless summer BBQs, backing directly onto the scenic Geo-Time Trail network. On top of the premium interior finishes, you will enjoy complete peace of mind with a newer, fully owned furnace and A/C system installed in 2024. Location is everything: you are steps from the region's top-rated elementary and secondary schools, and only minutes from the University Corridor-offering incredible long-term value/appreciation and high-end student occupancy in a premium location. Enjoy rapid access to major highways, the Waterloo Memorial Recreation Complex, RIM Park, Costco, and the vibrant Boardwalk shopping district. Whether you are a growing family or an astute investor looking for a premium asset, this home truly embodies the epitome of convenient modern living. Don't let this rare opportunity pass you by-schedule your private viewing today! (id:62650)"
+"Appliances": array:8 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Range"
4 => "Microwave"
5 => "Window Coverings"
6 => "Garage door opener remote(s)"
7 => "Water Heater"
]
+"AssociationFee": "646"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-27T22:24:30.467157+00:00"
+"Directions": "Cross Streets: Columbia Forest Blvd & Erbsville Rd. ** Directions: Head north on Erbsville Road past Columbia Street West. The complex is located on the left-hand side, immediately at the corner intersection of Erbsville Road and Columbia Forest Boulevard."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Tile"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2209347"
+"ListOfficeKey": "280225"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-27T23:18:05Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T00:18:54Z"
+"Stories": "3.0"
+"StreetName": "Columbia Forest"
+"StreetNumber": "601"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "3699"
+"VirtualTourURLUnbranded": "https://youtu.be/pXbuepXb0Zc"
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29963363/3-601-columbia-forest-boulevard-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Sanderson Management Inc."
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-27T21:47:19.54Z"
+"ListAgentNationalAssociationId": "1456335"
+"ListOfficeNationalAssociationId": "1310773"
+"Media": array:33 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29963363')"
+"ID": "1574016"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25247
+post_id: "1571992"
+post_author: 1
+"ListingKey": "29960557"
+"ListingId": "X13495788"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T20:55:03Z"
+"RFModificationTimestamp": "2026-06-26T23:03:08Z"
+"ListPrice": 975000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B9"
+"UnparsedAddress": "597 SUNDEW DRIVE, Waterloo, Ontario N2V0B9"
+"Coordinates": array:2 [
0 => -80.597865
1 => 43.459722
]
+"Latitude": 43.459722
+"Longitude": -80.597865
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Vista Hills-one of Waterloo's most sought-after family communities! Set on a premium 58-foot lot with beautifully curated perennial landscaping, this stunning "White Cherry" model offers the perfect balance of upscale finishes, functional family living, and outdoor enjoyment. The fully fenced backyard feels like your own private retreat, featuring a stamped concrete patio, sleek modern pergola, and lush gardens-an ideal setting for kids to play, summer entertaining, or quiet evenings outdoors. Step inside to a bright, thoughtfully designed main floor where durable 12x24 porcelain tile and hand-scraped hardwood create a warm and timeless feel throughout. At the heart of the home is a beautifully appointed chef-inspired kitchen with granite countertops, a large island perfect for gathering, ceiling-height custom cabinetry, pantry storage, and a newer smart stove. The open-concept layout flows seamlessly into the living and dining areas, creating a welcoming space for everyday life and hosting family and friends. Upstairs, you'll find 4 spacious bedrooms along with the convenience of second-floor laundry. The primary suite offers a peaceful escape with a spa-inspired 5-piece ensuite complete with a glass shower and relaxing soaker tub. The fully finished basement adds incredible versatility with a stylish wet bar, custom entertainment feature wall, additional bedroom, and full bathroom-perfect for guests, movie nights, or multi-generational living. Additional updates include smart switches, modern lighting, owned water softener and water heater, plus a newer furnace and air conditioner (2022). With 4+1 bedrooms, 4 bathrooms, and highly rated schools including Vista Hills Public School just minutes away, this is the kind of home where families can truly settle in and grow for years to come. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Blinds"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
11 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T23:02:57.139170+00:00"
+"Directions": "Cross Streets: Columbia Street & Sundew Drive. ** Directions: Columbia Street West to Sundew Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2138804"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "57.8 x 110 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T20:48:02Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T20:48:02Z"
+"Stories": "2.0"
+"StreetName": "Sundew"
+"StreetNumber": "597"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7645"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/597_sundew_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29960557/597-sundew-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "NR"
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 57.9
+"OriginalEntryTimestamp": "2026-06-26T20:48:02.22Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1390596"
+"ListOfficeNationalAssociationId": "1385020"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29960557')"
+"ID": "1571992"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25248
+post_id: "1571642"
+post_author: 1
+"ListingKey": "29961010"
+"ListingId": "X13496142"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T21:55:08Z"
+"RFModificationTimestamp": "2026-06-26T22:37:39Z"
+"ListPrice": 769000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A3"
+"UnparsedAddress": "A3 - 795 LAURELWOOD DRIVE, Waterloo, Ontario N2V0A3"
+"Coordinates": array:2 [
0 => -80.600804
1 => 43.471001
]
+"Latitude": 43.471001
+"Longitude": -80.600804
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful family home offers spacious layout throughout with a extra large living area. Situated in a quiet cul-de-sac with privacy surrounded by mature trees and landscaping. Beautiful curve appeal complex. This unit really good size 3 bedrooms upstairs with a cozy study or a tv room. This home has extra large garage compared to other units in the complex with tall ceiling to create more storage. The laundry room spacious behind the kitchen and there is a spacious separate pantry. The kitchen has stainless steel appliances, a quartz counter top is a deep and large single sink. The island has a breakfast bar with a separate dining area. Large sliding glass doors lead to the deck, cozy for reading or entertaining during summer evenings. The basement is fully finished and very spacious that can be used as a suite or a large rec room.with a full bathroom and large open areas which can be separated into bedrooms. One of the most desired school zones, walking distance to highly rated Abraham Erb public school and Laurel Heights Secondary school, Food basics and Shoppers drug mart. Within 7 min drive to University of Waterloo, Costco, YMCA, and The Boardwalk. Many all season walking trails around the neighbourhood.. The complex is a close community with small number of units. Very safe and welcoming... Equally good for anyone downsizing or starting a new family. This unit is larger than some detached homes in the neighbourhood at 1925 sqft. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Blinds"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"AssociationFee": "314"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T22:37:28.493792+00:00"
+"Directions": "Cross Streets: Laurelwood Drive. ** Directions: Erbsville Road to Laurelwood Drive."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1412135"
+"ListOfficeKey": "280225"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T21:49:26Z"
+"PhotosCount": 25
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T21:49:26Z"
+"Stories": "2.0"
+"StreetName": "Laurelwood"
+"StreetNumber": "795"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4642.04"
+"VirtualTourURLUnbranded": "https://unbranded.iguideradix.com/3_795_laurelwood_dr_waterloo_on/"
+"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/29961010/a3-795-laurelwood-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Self Managed"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1999
+"LivingAreaMinimum": 1800
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-26T21:49:26.34Z"
+"ListAgentNationalAssociationId": "1105043"
+"ListOfficeNationalAssociationId": "1310773"
+"Media": array:25 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29961010')"
+"ID": "1571642"
}
]
+success: true
+page_size: 9
+page_count: 10
+count: 85
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]