array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29912895 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23447
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23449
+post_id: "1536562"
+post_author: 1
+"ListingKey": "29912895"
+"ListingId": "X13453290"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T12:35:09Z"
+"RFModificationTimestamp": "2026-06-29T12:39:34Z"
+"ListPrice": 769000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4Y1"
+"UnparsedAddress": "591 DOGWOOD LANE, Waterloo, Ontario N2L4Y1"
+"Coordinates": array:2 [
0 => -80.560828
1 => 43.486633
]
+"Latitude": 43.486633
+"Longitude": -80.560828
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To Dogwood Lane! This Well-Maintained Bungalow Is Situated On A Quiet, Family-Friendly Street And Offers Comfortable Living With Excellent Income Potential. The Bright Living And Dining Areas Feature Hardwood Flooring And Large Windows For Plenty Of Natural Light. The Updated Kitchen Boasts Ceramic Flooring, Quartz Countertops, And A Stylish Backsplash. The Main Floor Includes Three Generously Sized Bedrooms With Parquet Flooring, Closets, And Separate Main Floor Laundry. The Fully Renovated (2022) Basement Features A Separate Entrance, Separate Laundry, Two Bedrooms, Vinyl Flooring, Pot Lights, A Cozy Fireplace, And A Spacious Living Area. The Bathroom Includes Ceramic Flooring, A Modern Vanity, And A Beautiful Clawfoot Soaker Tub. Enjoy A Large, Beautifully Landscaped Backyard Perfect For Entertaining. Recent Updates Include A.C./Heat Pump (Aug 2023), Furnace (Aug 2023), Tankless Water Heater (Aug 2023), Roof Insulation (Aug 2023), Water Purifier (Jun 2023), Water Filter (Jun 2023), And LeafFilter Gutter Protection (Aug 2023). Conveniently Located Close To Hwy 401, Schools, Shopping, Parks, Public Transit, And Within Walking Distance To The University Of Waterloo Campus. Move-In Ready Home Offering Comfort, Convenience, And Versatility. EXTRAS: Separate Entrance To Renovated Basement With Separate Laundry, Tankless Water Heater, Water Purifier, Water Filter, Heat Pump, LeafFilter Gutter Protection, Fireplace In Basement. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Water purifier"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
9 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Separate entrance"
2 => "Walk-up"
3 => "N/A"
4 => "N/A"
5 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T22:19:28.544312+00:00"
+"Directions": "Bearinger Road / Toll Gate/Dogwood Ln"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:4 [
0 => "Hardwood"
1 => "Parquet"
2 => "Ceramic"
3 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2105595"
+"ListOfficeKey": "164016"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "45 x 114 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T21:55:46Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T12:26:08Z"
+"Stories": "1.0"
+"StreetName": "Dogwood"
+"StreetNumber": "591"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "4316"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"View": "View"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1671060496"
"RoomType" => "Living room"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 3.6
"ListingKey" => "29912895"
"RoomLength" => 4.97
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T12:26:08.95Z"
]
1 => array:11 [
"RoomKey" => "1671060497"
"RoomType" => "Dining room"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29912895"
"RoomLength" => 2.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T12:26:08.95Z"
]
2 => array:11 [
"RoomKey" => "1671060498"
"RoomType" => "Kitchen"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 3.48
"ListingKey" => "29912895"
"RoomLength" => 4.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T12:26:08.95Z"
]
3 => array:11 [
"RoomKey" => "1671060499"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 3.14
"ListingKey" => "29912895"
"RoomLength" => 3.91
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T12:26:08.95Z"
]
4 => array:11 [
"RoomKey" => "1671060500"
"RoomType" => "Bedroom 2"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 2.69
"ListingKey" => "29912895"
"RoomLength" => 3.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T12:26:08.95Z"
]
5 => array:11 [
"RoomKey" => "1671060501"
"RoomType" => "Bedroom 3"
"ListingId" => "X13453290"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29912895"
"RoomLength" => 2.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T12:26:08.95Z"
]
6 => array:11 [
"RoomKey" => "1671060502"
"RoomType" => "Living room"
"ListingId" => "X13453290"
"RoomLevel" => "Basement"
"RoomWidth" => 4.72
"ListingKey" => "29912895"
"RoomLength" => 5.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T12:26:08.96Z"
]
7 => array:11 [
"RoomKey" => "1671060503"
"RoomType" => "Bedroom 4"
"ListingId" => "X13453290"
"RoomLevel" => "Basement"
"RoomWidth" => 3.96
"ListingKey" => "29912895"
"RoomLength" => 3.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T12:26:08.96Z"
]
8 => array:11 [
"RoomKey" => "1671060504"
"RoomType" => "Bedroom 5"
"ListingId" => "X13453290"
"RoomLevel" => "Basement"
"RoomWidth" => 3.02
"ListingKey" => "29912895"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T12:26:08.96Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29912895/591-dogwood-lane-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-16T21:55:46.28Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1374868"
+"ListOfficeNationalAssociationId": "1184644"
+"Media": array:38 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29912895_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/fb975b8a5449de12ebf6f2bbc2755134.webp"
"MediaSize" => 535748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-fb975b8a5449de12ebf6f2bbc2755134.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29912895_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/a1c63bdb354f10c613066fab83f1b315.webp"
"MediaSize" => 467201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-a1c63bdb354f10c613066fab83f1b315.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29912895_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/8d37c3159eedb5a52e519dfe3e28d123.webp"
"MediaSize" => 410878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-8d37c3159eedb5a52e519dfe3e28d123.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29912895_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/21b6eaffba637eadd7d7cbb83b64e548.webp"
"MediaSize" => 233326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-21b6eaffba637eadd7d7cbb83b64e548.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29912895_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/76996cf06e62124448ef7fc5a0d3ab4d.webp"
"MediaSize" => 181093
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-76996cf06e62124448ef7fc5a0d3ab4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29912895_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/b7583655d55f0c54bee9638d768aa66e.webp"
"MediaSize" => 188793
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-b7583655d55f0c54bee9638d768aa66e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29912895_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/765fd4c87d7fa914afd1e22fb78fe01f.webp"
"MediaSize" => 209197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-765fd4c87d7fa914afd1e22fb78fe01f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29912895_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/7ff4879424177e7f96f3a8e72d6c08ce.webp"
"MediaSize" => 164711
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-7ff4879424177e7f96f3a8e72d6c08ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29912895_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/3a38f301a955b2331a3f7ef232b712e3.webp"
"MediaSize" => 150405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-3a38f301a955b2331a3f7ef232b712e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29912895_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/8e43a39643f4fb4f7eaf5379ccc0319a.webp"
"MediaSize" => 154948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-8e43a39643f4fb4f7eaf5379ccc0319a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29912895_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/66cd52d9d1107e6eb72f74d278a49a46.webp"
"MediaSize" => 127490
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-66cd52d9d1107e6eb72f74d278a49a46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29912895_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/620645837387dc617bdacec22232e805.webp"
"MediaSize" => 206724
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-620645837387dc617bdacec22232e805.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29912895_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/9740899d4ed8c99bd09e163cab95ef3a.webp"
"MediaSize" => 178358
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-9740899d4ed8c99bd09e163cab95ef3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29912895_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/c1171762eccc0755a6101706ddeb7ef0.webp"
"MediaSize" => 181321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-c1171762eccc0755a6101706ddeb7ef0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29912895_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/60000bfb24cb1568204544017510f7a5.webp"
"MediaSize" => 175070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-60000bfb24cb1568204544017510f7a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29912895_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/585a01a791106aca4628eec3bc4f049a.webp"
"MediaSize" => 179129
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-585a01a791106aca4628eec3bc4f049a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29912895_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/8da9383aac5db4de0c4eb96abb9c118b.webp"
"MediaSize" => 177765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-8da9383aac5db4de0c4eb96abb9c118b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29912895_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/62367b8ee8a18f80062096452cc218a7.webp"
"MediaSize" => 147483
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-62367b8ee8a18f80062096452cc218a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29912895_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/1c42aaed56a33f8880786f0a640370e5.webp"
"MediaSize" => 170664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-1c42aaed56a33f8880786f0a640370e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29912895_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/60322702cbb69e899c1eb36a88ec3d15.webp"
"MediaSize" => 114303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-60322702cbb69e899c1eb36a88ec3d15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29912895_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/3c7f1288f42c1c5ddbefecd97391ef2b.webp"
"MediaSize" => 114303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-3c7f1288f42c1c5ddbefecd97391ef2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29912895_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/111633c212a4198625857ccaff229cf6.webp"
"MediaSize" => 98561
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-111633c212a4198625857ccaff229cf6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29912895_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/b8d9a782eddd3ded2aaa0e474a490602.webp"
"MediaSize" => 155117
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-b8d9a782eddd3ded2aaa0e474a490602.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29912895_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/85d0447ee6489d476a69bac74bc39bf5.webp"
"MediaSize" => 153346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-85d0447ee6489d476a69bac74bc39bf5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29912895_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/1fb5e580c160bfff24440230659cdda1.webp"
"MediaSize" => 184426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-1fb5e580c160bfff24440230659cdda1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29912895_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/bbc289bae1dcbf5e47eec070a65f4cb8.webp"
"MediaSize" => 197660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-bbc289bae1dcbf5e47eec070a65f4cb8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29912895_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/9192d1426936f423797abda1a119075e.webp"
"MediaSize" => 222168
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-9192d1426936f423797abda1a119075e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29912895_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/f4af648ba903233b548b26bcd4c2660d.webp"
"MediaSize" => 156100
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-f4af648ba903233b548b26bcd4c2660d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29912895_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/91c808b8a1f948023d5da8b42dcbee82.webp"
"MediaSize" => 184290
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-91c808b8a1f948023d5da8b42dcbee82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29912895_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/50aa839fab60dfd7bd57489df2b53ea7.webp"
"MediaSize" => 158156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-50aa839fab60dfd7bd57489df2b53ea7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29912895_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/3367137d8a3d2c54c8d470b4e25114a1.webp"
"MediaSize" => 141048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-3367137d8a3d2c54c8d470b4e25114a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29912895_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/3418b6af4d6de92f66e07706cac01064.webp"
"MediaSize" => 101129
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-3418b6af4d6de92f66e07706cac01064.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29912895_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/2f6f3104ec01adc7316340fa9ea99c22.webp"
"MediaSize" => 422049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-2f6f3104ec01adc7316340fa9ea99c22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29912895_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/7e38958834c7b014bc3bd0911fa76d71.webp"
"MediaSize" => 448610
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-7e38958834c7b014bc3bd0911fa76d71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29912895_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/adaac288cbc7b2fb2691ebdcc9a8f08a.webp"
"MediaSize" => 484568
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-adaac288cbc7b2fb2691ebdcc9a8f08a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29912895_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/e538792f08c3cdaaf180dd308d96edb8.webp"
"MediaSize" => 458312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-e538792f08c3cdaaf180dd308d96edb8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29912895_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/4f9c973b65673bbf310270851abc7f34.webp"
"MediaSize" => 364497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-4f9c973b65673bbf310270851abc7f34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29912895_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912895/03c84d1b2df9744c68bd73ba24cfd3a8.webp"
"MediaSize" => 485140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912895/thumbnail-03c84d1b2df9744c68bd73ba24cfd3a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13453290"
"ResourceRecordKey" => "29912895"
"ModificationTimestamp" => "2026-06-16T21:55:46.28Z"
]
]
+"DaysOnMarket": 22
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912895')"
+"ID": "1536562"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.19 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 164016" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24962
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24908
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "CENTURY 21 GREEN REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "905-565-9565"
+"OfficeMlsId": "137100"
+"ModificationTimestamp": "2026-06-30T17:49:41Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "164016"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "6980 MARITZ DR UNIT 8"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "MISSISSAUGA"
+"OfficePostalCode": "L5W1Z"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1184644"
+"OriginalEntryTimestamp": "2008-04-22T01:24:00Z"
+"OfficeFax": "905-565-9522"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"FranchiseNationalAssociationId": "1205554"
+"OfficeBrokerNationalAssociationId": "1050908"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('164016')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2105595" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24870
+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 '29912895'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25275
+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 '29912895' AND OpenHouseDate ge '2026-07-08'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25291
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29912895' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.560828 43.486633)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25364
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25358
+post_id: "1608024"
+post_author: 1
+"ListingKey": "30009620"
+"ListingId": "40846083"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T13:50:01Z"
+"RFModificationTimestamp": "2026-07-09T14:07:08Z"
+"ListPrice": 720000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1850.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2A7"
+"UnparsedAddress": "704 JACOB Lane, Waterloo, Ontario N2V2A7"
+"Coordinates": array:2 [
0 => -80.5702204
1 => 43.4978201
]
+"Latitude": 43.4978201
+"Longitude": -80.5702204
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 704 Jacob Lane, Waterloo, a beautifully maintained family home nestled in the highly desirable Clair Hills neighbourhood, where excellent schools, scenic walking trails, parks, shopping, and everyday conveniences are all just minutes away. Enjoy quick access to Laurel Creek Conservation Area, the St. Jacobs Farmers' Market, Costco, The Boardwalk Shopping Centre, the University of Waterloo, Wilfrid Laurier University, and Highway 85, making this an exceptional location for families, professionals, and commuters alike. Thoughtfully designed with over 2,000 sq. ft. of finished living space, this bright and inviting home offers the perfect blend of comfort and functionality. The welcoming main floor features a spacious living room filled with natural light, complemented by warm hardwood flooring and an elegant staircase. The heart of the home is the stylish kitchen, showcasing rich espresso cabinetry, stainless steel appliances, a centre island with additional prep space, ample storage, and a timeless subway tile backsplash. The open-concept dining area overlooks the backyard, creating an ideal setting for family dinners and entertaining. Upstairs, you'll find generously sized bedrooms, including a spacious primary retreat, while additional bedrooms provide plenty of room for a growing family, guests, or a home office. The finished lower level expands your living space with a large recreation room perfect for movie nights, a children's play area, home gym, or workspace. Step outside to enjoy the fully fenced backyard, an ideal space for summer BBQs, kids, pets, or simply relaxing after a long day. Located in one of Waterloo's most sought-after family communities, 704 Jacob Lane offers the perfect combination of modern living, everyday convenience, and an unbeatable location close to schools, parks, trails, shopping, transit, and some of the Region's most popular 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"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T14:05:02.933201+00:00"
+"Directions": "Take Westmount, turn east on Osprey, left on Jacob Lane."
+"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": "1983959"
+"ListOfficeKey": "292624"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T13:42:37Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T13:42:37Z"
+"Stories": "2.0"
+"StreetName": "JACOB"
+"StreetNumber": "704"
+"StreetSuffix": "Lane"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "4205.88"
+"VirtualTourURLUnbranded": "https://youriguide.com/704_jacob_ln_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1678927036"
"RoomType" => "Utility room"
"ListingId" => "40846083"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30009620"
"RoomLength" => null
"RoomDimensions" => "13'2'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T11:58:24.36Z"
]
1 => array:11 [
"RoomKey" => "1678927037"
"RoomType" => "Recreation room"
"ListingId" => "40846083"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30009620"
"RoomLength" => null
"RoomDimensions" => "13'9'' x 17'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T11:58:24.37Z"
]
2 => array:11 [
"RoomKey" => "1678927038"
"RoomType" => "Cold room"
"ListingId" => "40846083"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30009620"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 18'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T11:58:24.37Z"
]
3 => array:11 [
"RoomKey" => "1678927039"
"RoomType" => "2pc Bathroom"
"ListingId" => "40846083"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30009620"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T11:58:24.37Z"
]
4 => array:11 [
"RoomKey" => "1678927040"
"RoomType" => "Primary Bedroom"
"ListingId" => "40846083"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30009620"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T11:58:24.37Z"
]
5 => array:11 [
"RoomKey" => "1678927041"
"RoomType" => "Bedroom"
"ListingId" => "40846083"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30009620"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T11:58:24.37Z"
]
6 => array:11 [
"RoomKey" => "1678927042"
"RoomType" => "Bedroom"
"ListingId" => "40846083"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30009620"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T11:58:24.37Z"
]
7 => array:11 [
"RoomKey" => "1678927043"
"RoomType" => "4pc Bathroom"
"ListingId" => "40846083"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30009620"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T11:58:24.37Z"
]
8 => array:11 [
"RoomKey" => "1678927044"
"RoomType" => "Living room"
"ListingId" => "40846083"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30009620"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 19'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T11:58:24.37Z"
]
9 => array:11 [
"RoomKey" => "1678927045"
"RoomType" => "Kitchen"
"ListingId" => "40846083"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30009620"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T11:58:24.37Z"
]
10 => array:11 [
"RoomKey" => "1678927046"
"RoomType" => "Dining room"
"ListingId" => "40846083"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30009620"
"RoomLength" => null
"RoomDimensions" => "8'5'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-09T11:58:24.37Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30009620/704-jacob-lane-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2213528"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "291822"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 31.0
+"AboveGradeFinishedArea": 1250
+"BelowGradeFinishedArea": 599
+"OriginalEntryTimestamp": "2026-07-09T11:48:54.94Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1268752"
+"ListOfficeNationalAssociationId": "1414872"
+"CoListAgentNationalAssociationId": "1459332"
+"CoListOfficeNationalAssociationId": "1405037"
+"Media": array:48 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30009620_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009620/2caa7cb9a5d2d0717863610fd113b175.webp"
"MediaSize" => 142081
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009620/thumbnail-2caa7cb9a5d2d0717863610fd113b175.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40846083"
"ResourceRecordKey" => "30009620"
"ModificationTimestamp" => "2026-07-09T13:42:35.64Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30009620_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009620/09d53697c5f045eb2c66f16218fc8ff5.webp"
"MediaSize" => 125823
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30009620/thumbnail-09d53697c5f045eb2c66f16218fc8ff5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846083"
"ResourceRecordKey" => "30009620"
"ModificationTimestamp" => "2026-07-09T13:42:36.36Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30009620_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30009620/2cff94c23686e8a2e3c8380fb9ad02a7.webp"
"MediaSize" => 72412
…9
]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30009620')"
+"ID": "1608024"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25360
+post_id: "1607961"
+post_author: 1
+"ListingKey": "30009588"
+"ListingId": "X13541588"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T18:05:17Z"
+"RFModificationTimestamp": "2026-07-09T18:10:07Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4W8"
+"UnparsedAddress": "175 WOODVILLE PLACE, Waterloo, Ontario N2L4W8"
+"Coordinates": array:2 [
0 => -80.5471729
1 => 43.4904995
]
+"Latitude": 43.4904995
+"Longitude": -80.5471729
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Tucked away on a peaceful, family-friendly cul-de-sac and surrounded by towering mature trees, 175 Woodville Place offers the perfect blend of comfort, style, and privacy. From the moment you arrive, you'll feel right at home. Step inside to discover a bright, inviting main floor where natural light pours through the beautiful bay window, creating a warm and welcoming atmosphere. The spacious living room flows seamlessly into the dining area and an updated modern kitchen, thoughtfully designed for both everyday living and effortless entertaining. Down the hall, you'll find three generously sized bedrooms and a beautifully appointed full bathroom, providing comfortable accommodations for the whole family. The finished lower level expands your living space with a large fourth bedroom, a second full bathroom, and an inviting recreation room complete with a cozy fireplace, perfect for movie nights, game nights, a home office, or a private retreat for guests or teenagers. Step outside to your covered deck overlooking an expansive, private backyard, a tranquil setting for morning coffee, summer barbecues, family gatherings, or simply relaxing while enjoying the peaceful surroundings. Ideally located in one of Waterloo's most desirable neighbourhoods - just a couple minutes from Uptown Waterloo - you'll enjoy quick access to excellent schools, parks, trails, shopping, restaurants, universities, and commuter routes while still coming home to the quiet charm of a mature, established community. Bright, beautifully updated, and move-in ready, this exceptional home is a rare opportunity to enjoy the lifestyle you've been searching for. Don't miss your chance to make 175 Woodville Place your forever home, schedule your private showing today and experience everything this wonderful property has to offer! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T13:47:50.655544+00:00"
+"Directions": "Cross Streets: Mt Anne Dr. ** Directions: Parkside Dr turn onto Cedarbrae Ave, right onto Mt Anne Dr. then turn left onto Woodville Place."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2049894"
+"ListOfficeKey": "85099"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Wooded area"
2 => "Irregular lot size"
3 => "Carpet Free"
4 => "Guest Suite"
]
+"LotSizeDimensions": "68.7 x 103.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T11:39:44Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T18:00:00Z"
+"Stories": "1.0"
+"StreetName": "Woodville"
+"StreetNumber": "175"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "4617"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/175-Woodville-Pl"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "OnePoint"
+"TaxYear": 2025
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/30009588/175-woodville-place-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2157675"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "85099"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 68.8
+"OriginalEntryTimestamp": "2026-07-09T11:39:44.36Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1325241"
+"ListOfficeNationalAssociationId": "1187791"
+"CoListAgentNationalAssociationId": "1408990"
+"CoListOfficeNationalAssociationId": "1187791"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30009588')"
+"ID": "1607961"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25357
+post_id: "1607853"
+post_author: 1
+"ListingKey": "30009710"
+"ListingId": "X13541622"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T13:55:17Z"
+"RFModificationTimestamp": "2026-07-09T13:56:00Z"
+"ListPrice": 720000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2A7"
+"UnparsedAddress": "704 JACOB LANE, Waterloo, Ontario N2V2A7"
+"Coordinates": array:2 [
0 => -80.570198
1 => 43.497813
]
+"Latitude": 43.497813
+"Longitude": -80.570198
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 704 Jacob Lane, Waterloo, a beautifully maintained family home nestled in the highly desirable Clair Hills neighbourhood, where excellent schools, scenic walking trails, parks, shopping, and everyday conveniences are all just minutes away. Enjoy quick access to Laurel Creek Conservation Area, the St. Jacobs Farmers' Market, Costco, The Boardwalk Shopping Centre, the University of Waterloo, Wilfrid Laurier University, and Highway 85, making this an exceptional location for families, professionals, and commuters alike. Thoughtfully designed with over 2,000 sq. ft. of finished living space, this bright and inviting home offers the perfect blend of comfort and functionality. The welcoming main floor features a spacious living room filled with natural light, complemented by warm hardwood flooring and an elegant staircase. The heart of the home is the stylish kitchen, showcasing rich espresso cabinetry, stainless steel appliances, a centre island with additional prep space, ample storage, and a timeless subway tile backsplash. The open-concept dining area overlooks the backyard, creating an ideal setting for family dinners and entertaining. Upstairs, you'll find generously sized bedrooms, including a spacious primary retreat, while additional bedrooms provide plenty of room for a growing family, guests, or a home office. The finished lower level expands your living space with a large recreation room perfect for movie nights, a children's play area, home gym, or workspace. Step outside to enjoy the fully fenced backyard, an ideal space for summer BBQs, kids, pets, or simply relaxing after a long day. Located in one of Waterloo's most sought-after family communities, 704 Jacob Lane offers the perfect combination of modern living, everyday convenience, and an unbeatable location close to schools, parks, trails, shopping, transit, and some of the Region's most popular 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"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T13:37:30.386351+00:00"
+"Directions": "Cross Streets: Westmount Rd N. ** Directions: Take Westmount, turn east on Osprey, left on Jacob Lane."
+"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": "2213528"
+"ListOfficeKey": "297463"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "31.2 x 104.9 FT ; 104.88 ft x 31.22 ft x108.64 ftx30.93 ft"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T13:46:27Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T13:46:27Z"
+"Stories": "2.0"
+"StreetName": "Jacob"
+"StreetNumber": "704"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "4205.88"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30009710/704-jacob-lane-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 31.2
+"OriginalEntryTimestamp": "2026-07-09T12:08:02.14Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1459332"
+"ListOfficeNationalAssociationId": "1470704"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30009710')"
+"ID": "1607853"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25361
+post_id: "1604619"
+post_author: 1
+"ListingKey": "30003992"
+"ListingId": "40845860"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-08T13:25:18Z"
+"RFModificationTimestamp": "2026-07-08T17:56:27Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1814.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2S6"
+"UnparsedAddress": "400 LAUREL GATE Drive, Waterloo, Ontario N2T2S6"
+"Coordinates": array:2 [
0 => -80.5716013
1 => 43.4720344
]
+"Latitude": 43.4720344
+"Longitude": -80.5716013
+"YearBuilt": 1998
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 400 Laurel Gate Drive, Waterloo, a bright and beautifully updated freehold townhome with NO CONDO FEES, ideally situated on a quiet cul-de-sac in Laurelwood. Parks, walking trails, highly rated schools, the YMCA, Laurel Creek Conservation Area, shopping, restaurants, public transit, the University of Waterloo, and everyday amenities nearby ~ This location offers the convenience and lifestyle buyers are looking for. Freshly painted and featuring new flooring throughout, this move in ready home offers two spacious bedrooms with double closets, three bathrooms, bright sun filled living spaces, and a finished basement that provides additional living space. Step outside to your private, fully fenced backyard, perfect for relaxing, entertaining, or spending time with family and friends. The attached garage and private driveway add to the home's everyday convenience. Whether you are buying your first home, downsizing, or looking for an investment property, this is an excellent opportunity to own an updated freehold home in one of Waterloo's established family communities. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-08T17:56:18.021549+00:00"
+"Directions": "Fischer Hallman / Laurelwood / Laurel Gate"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2056862"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-08T13:18:05Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-08T13:18:05Z"
+"Stories": "2.0"
+"StreetName": "LAUREL GATE"
+"StreetNumber": "400"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "4741"
+"VirtualTourURLUnbranded": "https://youriguide.com/400_laurel_gate_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30003992/400-laurel-gate-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1242
+"BelowGradeFinishedArea": 572
+"OriginalEntryTimestamp": "2026-07-08T13:18:05.3Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1332051"
+"ListOfficeNationalAssociationId": "1473831"
+"Media": array:40 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30003992')"
+"ID": "1604619"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25359
+post_id: "1602047"
+post_author: 1
+"ListingKey": "30001669"
+"ListingId": "40845281"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T20:35:24Z"
+"RFModificationTimestamp": "2026-07-07T23:05:36Z"
+"ListPrice": 1150000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3716.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2K2"
+"UnparsedAddress": "538 SANDBANKS Crescent, Waterloo, Ontario N2V2K2"
+"Coordinates": array:2 [
0 => -80.5798863
1 => 43.4958737
]
+"Latitude": 43.4958737
+"Longitude": -80.5798863
+"YearBuilt": 2000
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 538 Sandbanks Crescent, a stunning and beautifully updated home nestled in the highly sought-after Laurelwood neighbourhood in Waterloo. From the moment you arrive it is clear this home has been cared for with exceptional pride of ownership and thoughtful attention to detail throughout. Backing onto protected green space and filled with an abundance of natural light, this home offers the perfect blend of comfort, flexibility and modern living. The layout is incredibly versatile featuring two flexible main floor rooms that can be used as a home office, den or additional bedrooms depending on your family's needs, along with a full bathroom on the main level, making it ideal for multigenerational living or aging parents. With a generous above grade footprint plus a finished walkout basement, there is no shortage of space for everyone to enjoy. Located just steps from Laurel Creek Conservation Area, 6 minutes from the charming village of St. Jacobs, and within the catchment of top ranked schools including Laurelwood Public School and Laurel Heights Secondary School. The Stork Family YMCA, Waterloo Public Library and The Boardwalk shopping district are all just minutes away. This truly is a neighbourhood people fall in love with and never want to leave. Updates include a new air conditioner (2022), quartz countertops in the kitchen (2024), new water softener (2025), updated paint throughout various areas, professionally painted entry, main and upstairs hallways and updated vanity taps in the upstairs bathroom (2026). Truly move in ready. Do not miss your opportunity to call this incredible home yours! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T23:05:29.635886+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2103569"
+"ListOfficeKey": "156376"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T20:29:28Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T20:29:27Z"
+"Stories": "2.0"
+"StreetName": "SANDBANKS"
+"StreetNumber": "538"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "7891.76"
+"VirtualTourURLUnbranded": "https://youriguide.com/538_sandbanks_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30001669/538-sandbanks-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 2492
+"BelowGradeFinishedArea": 1224
+"OriginalEntryTimestamp": "2026-07-07T20:29:27.96Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1373130"
+"ListOfficeNationalAssociationId": "1003925"
+"Media": array:45 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30001669')"
+"ID": "1602047"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25354
+post_id: "1602306"
+post_author: 1
+"ListingKey": "29998188"
+"ListingId": "40845586"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T13:55:11Z"
+"RFModificationTimestamp": "2026-07-07T17:58:04Z"
+"ListPrice": 785000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1549.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1L8"
+"UnparsedAddress": "108 CLEARWATER Crescent, Waterloo, Ontario N2V1L8"
+"Coordinates": array:2 [
0 => -80.5635421
1 => 43.4922983
]
+"Latitude": 43.4922983
+"Longitude": -80.5635421
+"YearBuilt": 1984
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled in the highly sought-after Lakeshore North community, this beautifully maintained 2-storey home offers the perfect blend of comfort, functionality, and lifestyle. Featuring 3 spacious bedrooms, 2 bathrooms, and a thoughtfully designed layout, this home is ideal for growing families, professionals, and those who love to entertain. From the upgraded vinyl flooring throughout portions of the main floor to the seamless walk-through kitchen design, every detail has been curated to enhance the natural flow of the home—making everyday living and hosting effortless. Beyond the cosmetic upgrades, this home has also been mechanically updated over the years, offering buyers peace of mind and truly worry-free ownership. The pride of ownership is evident throughout, making this a move-in-ready opportunity in one of Waterloo’s most desirable neighbourhoods. The heart of the home opens into inviting living and dining spaces perfect for gatherings with family and friends, while the fully finished basement offers endless versatility—whether you envision a yoga studio, recreation room, home gym, workshop, or additional entertaining space. Step outside to enjoy a beautifully private backyard retreat, ideal for summer evenings, barbecues, or relaxing in peace. Located just minutes from the highway, top-rated dining, gyms, shopping, and both universities, this home delivers unbeatable convenience in an area known for its strong community feel, mature surroundings, and exceptional accessibility. Complete with a double-car garage, fantastic layout for entertaining, and extensive updates throughout, this is a rare opportunity to own a turn-key home in the coveted Lakeshore North neighbourhood. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Gas stove(s)"
6 => "Dryer"
7 => "Freezer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Ductless"
]
+"CreationDate": "2026-07-07T17:57:52.057126+00:00"
+"Directions": "Wintergreen Dr. Northlake and Highpoint Ave."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2129938"
+"ListOfficeKey": "292877"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T13:48:23Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T13:48:23Z"
+"Stories": "2.0"
+"StreetName": "CLEARWATER"
+"StreetNumber": "108"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "4711"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youriguide.com/108_clearwater_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29998188/108-clearwater-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1941951"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "292877"
+"GeocodeManualYN": true
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 53.0
+"AboveGradeFinishedArea": 1549
+"OriginalEntryTimestamp": "2026-07-07T13:48:23.04Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1382907"
+"ListOfficeNationalAssociationId": "1418791"
+"CoListAgentNationalAssociationId": "1238606"
+"CoListOfficeNationalAssociationId": "1418791"
+"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('29998188')"
+"ID": "1602306"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23461
+post_id: "1602307"
+post_author: 1
+"ListingKey": "29998680"
+"ListingId": "X13531268"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-08T15:50:06Z"
+"RFModificationTimestamp": "2026-07-08T16:10:22Z"
+"ListPrice": 785000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1L8"
+"UnparsedAddress": "108 CLEARWATER CRESCENT, Waterloo, Ontario N2V1L8"
+"Coordinates": array:2 [
0 => -80.563513
1 => 43.49232
]
+"Latitude": 43.49232
+"Longitude": -80.563513
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Nestled in the highly sought-after Lakeshore North community, this beautifully maintained 2-storey home offers the perfect blend of comfort,functionality, and lifestyle. Featuring 3 spacious bedrooms, 2 bathrooms, and a thoughtfully designed layout, this home is ideal for growingfamilies, professionals, and those who love to entertain. From the upgraded vinyl flooring throughout portions of the main floor to the seamlesswalk-through kitchen design, every detail has been curated to enhance the natural flow of the home-making everyday living and hostingeffortless. Beyond the cosmetic upgrades, this home has also been mechanically updated over the years, offering buyers peace of mind and trulyworry-free ownership. The pride of ownership is evident throughout, making this a move-in-ready opportunity in one of Waterloo's mostdesirable neighbourhoods. The heart of the home opens into inviting living and dining spaces perfect for gatherings with family and friends, whilethe fully finished basement offers endless versatility-whether you envision a yoga studio, recreation room, home gym, workshop, or additionalentertaining space. Step outside to enjoy a beautifully private backyard retreat, ideal for summer evenings, barbecues, or relaxing in peace.Located just minutes from the highway, top-rated dining, gyms, shopping, and both universities, this home delivers unbeatable convenience inan area known for its strong community feel, mature surroundings, and exceptional accessibility. Complete with a double-car garage, fantasticlayout for entertaining, and extensive updates throughout, this is a rare opportunity to own a turn-key home in the coveted Lakeshore Northneighbourhood. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dryer"
5 => "Freezer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CreationDate": "2026-07-07T17:26:22.569712+00:00"
+"Directions": "Cross Streets: Wintergreen Dr. Northlake and Highpoint Ave. ** Directions: Northfield > Highpoint > Wintergreen."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2237937"
+"ListOfficeKey": "285286"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "52.9 x 108 FT ; 52.89x107.97x36.9x120.33"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T14:42:20Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-08T15:42:13Z"
+"Stories": "2.0"
+"StreetName": "Clearwater"
+"StreetNumber": "108"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4711"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/108_clearwater_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29998680/108-clearwater-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2235642"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "285286"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 52.1
+"OriginalEntryTimestamp": "2026-07-07T14:42:20.06Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1475924"
+"ListOfficeNationalAssociationId": "1349912"
+"CoListAgentNationalAssociationId": "1473542"
+"CoListOfficeNationalAssociationId": "1349912"
+"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('29998680')"
+"ID": "1602307"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25362
+post_id: "1590741"
+post_author: 1
+"ListingKey": "29986386"
+"ListingId": "40844884"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T18:55:15Z"
+"RFModificationTimestamp": "2026-07-03T19:40:13Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1618.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1P6"
+"UnparsedAddress": "315 MAYVIEW Crescent Unit# B, Waterloo, Ontario N2V1P6"
+"Coordinates": array:2 [
0 => -80.5558434
1 => 43.499126
]
+"Latitude": 43.499126
+"Longitude": -80.5558434
+"YearBuilt": 1987
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 315B Mayview Crescent! This beautifully maintained 3-bedroom, 2-bathroom home offers the perfect blend of modern updates, functional living space, and an incredible backyard retreat. Whether you're a first-time buyer, growing family, or looking to downsize, this move-in-ready home is sure to impress. Step inside to a bright, open-concept main floor featuring a spacious living and dining area that flows effortlessly into the beautifully renovated kitchen (2024), complete with contemporary finishes, ample cabinetry, and plenty of workspace. Upstairs, you'll find three generously sized bedrooms and a full bathroom, while the finished basement extends your living space with a large recreation room and an updated 3-piece bathroom (2021)—perfect for movie nights, overnight guests, or a home office. Outside, you'll discover your own private backyard oasis. The fully fenced yard is beautifully landscaped and offers mature trees for added privacy, an expansive lawn for children and pets to enjoy, and a covered gazebo that creates the perfect setting for summer entertaining or relaxing with family and friends. Additional updates include a new roof (2020) and a new furnace and central air conditioning system (2024), providing added peace of mind for years to come. Situated in a desirable, family-friendly neighbourhood close to schools, parks, shopping, trails, and everyday amenities, this home combines comfort, style, and convenience in one exceptional package. Don't miss your opportunity to make this beautifully updated property your next home! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
5 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T19:40:00.148172+00:00"
+"Directions": "Northlake Drive & Mayview Cres"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1951940"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Country residential"
2 => "Sump Pump"
]
+"PhotosChangeTimestamp": "2026-07-03T18:48:32Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:48:32Z"
+"Stories": "2.0"
+"StreetName": "MAYVIEW"
+"StreetNumber": "315"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "3523"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/315-B-Mayview-Crescent"
+"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/29986386/315-mayview-crescent-unit-b-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1113
+"BelowGradeFinishedArea": 505
+"OriginalEntryTimestamp": "2026-07-03T18:48:32.63Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1245634"
+"ListOfficeNationalAssociationId": "1324759"
+"Media": array:40 [
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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986386')"
+"ID": "1590741"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25363
+post_id: "1584362"
+post_author: 1
+"ListingKey": "29977664"
+"ListingId": "40842487"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T13:40:08Z"
+"RFModificationTimestamp": "2026-07-06T13:53:56Z"
+"ListPrice": 949900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2733.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2J3"
+"UnparsedAddress": "500 GLACIER Street, Waterloo, Ontario N2V2J3"
+"Coordinates": array:2 [
0 => -80.5790234
1 => 43.4957774
]
+"Latitude": 43.4957774
+"Longitude": -80.5790234
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 500 Glacier Street in Waterloo-your dream home with a spectacular backyard retreat, including a heated above-ground saltwater pool, backing onto greenspace & trails. Situated on an oversized corner lot in the highly desirable & family-oriented neighbourhood of Conservation Meadows, this lovely 4-bedroom, 3-bathroom home offers over 2,700 sq. ft. of finished living space, many recent updates & a bright, spacious open-concept layout perfect for entertaining or relaxing with family. The recently renovated gourmet kitchen features stainless steel appliances, a beautiful backsplash & a convenient centre island for casual dining, while the oversized dining area offers plenty of space for more formal gatherings. Relax & unwind in the sophisticated family room, complete with a gas fireplace, oversized windows & sliding door access to the expansive deck & pool area. A 2-piece bathroom & main floor laundry complete the main level. Upstairs, the stunning primary suite features vaulted ceilings, custom built-ins, two walk-in closets & a newly updated spa-like 3-piece ensuite with tiled glass shower, rain shower fixture, heated floors & heated towel rack. Two additional spacious bedrooms & a 4-piece main bathroom complete this level. The fully finished basement offers a large recreation room, a potential 4th bedroom & the added convenience of a walk-up directly into the garage.. Notable updates include furnace & air conditioning in 2017, shingles in 2015 & above-ground saltwater pool in 2018. Additional features include a carpet-free main & lower level with luxury vinyl flooring, custom blinds & more. Backing onto greenspace & walking trails, surrounded by mature trees & lush perennial gardens, this lovely home is located on a quiet, tree-lined street in a premium location close to schools, parks, Laurel Creek Conservation Area, shopping, restaurants, Starbucks, Sobeys, St. Jacobs Farmers’ Market, quick highway access & more. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T17:41:40.814366+00:00"
+"Directions": "Conservation Drive to Lake Louise to Glacier"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564122"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Corner Site"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T13:31:14Z"
+"PhotosCount": 49
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T13:31:14Z"
+"Stories": "2.0"
+"StreetName": "GLACIER"
+"StreetNumber": "500"
+"StreetSuffix": "Street"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5653"
+"VirtualTourURLUnbranded": "https://youriguide.com/500_glacier_street_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29977664/500-glacier-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 63.0
+"AboveGradeFinishedArea": 1854
+"BelowGradeFinishedArea": 879
+"OriginalEntryTimestamp": "2026-07-02T14:33:21.61Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1142829"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977664')"
+"ID": "1584362"
}
]
+success: true
+page_size: 9
+page_count: 9
+count: 74
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]