array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29986386 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
+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 [
"RoomKey" => "1674321401"
"RoomType" => "Utility room"
"ListingId" => "40844884"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986386"
"RoomLength" => null
"RoomDimensions" => "15'9'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:48:32.67Z"
]
1 => array:11 [
"RoomKey" => "1674321402"
"RoomType" => "3pc Bathroom"
"ListingId" => "40844884"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986386"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 8'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:48:32.67Z"
]
2 => array:11 [
"RoomKey" => "1674321403"
"RoomType" => "Recreation room"
"ListingId" => "40844884"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986386"
"RoomLength" => null
"RoomDimensions" => "15'9'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:48:32.67Z"
]
3 => array:11 [
"RoomKey" => "1674321404"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844884"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986386"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 8'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:48:32.67Z"
]
4 => array:11 [
"RoomKey" => "1674321405"
"RoomType" => "Bedroom"
"ListingId" => "40844884"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986386"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 15'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:48:32.67Z"
]
5 => array:11 [
"RoomKey" => "1674321406"
"RoomType" => "Bedroom"
"ListingId" => "40844884"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986386"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:48:32.67Z"
]
6 => array:11 [
"RoomKey" => "1674321407"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844884"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986386"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 13'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:48:32.68Z"
]
7 => array:11 [
"RoomKey" => "1674321408"
"RoomType" => "Living room"
"ListingId" => "40844884"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986386"
"RoomLength" => null
"RoomDimensions" => "15'11'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:48:32.68Z"
]
8 => array:11 [
"RoomKey" => "1674321409"
"RoomType" => "Dining room"
"ListingId" => "40844884"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986386"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 6'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:48:32.68Z"
]
9 => array:11 [
"RoomKey" => "1674321410"
"RoomType" => "Kitchen"
"ListingId" => "40844884"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986386"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:48:32.68Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29986386_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/edf6004f17ee07911190f726f53faa0e.webp"
"MediaSize" => 126099
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-edf6004f17ee07911190f726f53faa0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring light-colored siding and brick accents"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29986386_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/ebbd371a1b79cf34c44be0667d39d897.webp"
"MediaSize" => 137506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-ebbd371a1b79cf34c44be0667d39d897.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring light-colored siding, brickwork accents, and brown shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29986386_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/35cc87c76a129274075653fc83789d37.webp"
"MediaSize" => 125244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-35cc87c76a129274075653fc83789d37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Traditional two-story residence with a covered porch, bay window, and a combination of brick and siding exterior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29986386_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/70dbf40ecf599957677c0de3b32c0517.webp"
"MediaSize" => 120526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-70dbf40ecf599957677c0de3b32c0517.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring a brick and siding exterior with brown shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29986386_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/6ca0d2b53c651888f71e7cc336c8462b.webp"
"MediaSize" => 108394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-6ca0d2b53c651888f71e7cc336c8462b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Inviting front porch featuring a brick facade, white railing, and an architectural bay window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29986386_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/44b0b890ac50ab7203ec775064c82e58.webp"
"MediaSize" => 102394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-44b0b890ac50ab7203ec775064c82e58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Covered porch featuring a brick exterior and a bay window with white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29986386_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/5eccda1ebaff77e6355a6860498d2a27.webp"
"MediaSize" => 55381
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-5eccda1ebaff77e6355a6860498d2a27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted staircase with wooden handrail"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29986386_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/75e3b06136872bb25db64816cc5aa8ad.webp"
"MediaSize" => 57199
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-75e3b06136872bb25db64816cc5aa8ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29986386_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/dfda0a8297575b84ed469f297dca1bd9.webp"
"MediaSize" => 70572
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-dfda0a8297575b84ed469f297dca1bd9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29986386_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/bc1fdd4c80bca1321c5cf8408f371097.webp"
"MediaSize" => 63656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-bc1fdd4c80bca1321c5cf8408f371097.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white flat-panel cabinetry and white subway tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29986386_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/7786e0129a45de9b2ebee2b078c2f3ba.webp"
"MediaSize" => 66084
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-7786e0129a45de9b2ebee2b078c2f3ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white flat-panel cabinetry, white subway tile backsplash, white countertops, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29986386_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/b13b50b46037faad030f104bdc7b1849.webp"
"MediaSize" => 68833
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-b13b50b46037faad030f104bdc7b1849.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright dining area featuring a bay window, light wood-finish flooring, and white baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29986386_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/a925fee8079100225e2e883d8a44ae82.webp"
"MediaSize" => 72139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-a925fee8079100225e2e883d8a44ae82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring wood-finish flooring, a contemporary circular chandelier, and a built-in wooden sideboard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29986386_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/cc34e40db0a4142b3ed2f15a9d7ad542.webp"
"MediaSize" => 71367
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-cc34e40db0a4142b3ed2f15a9d7ad542.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open concept living area featuring light wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29986386_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/96aeec02024ad0154a1603857cbd3c93.webp"
"MediaSize" => 71457
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-96aeec02024ad0154a1603857cbd3c93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area with wood-finish flooring and a contemporary circular chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29986386_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/adfa1279cf6a63a94cacc1e7ee8b1f33.webp"
"MediaSize" => 74827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-adfa1279cf6a63a94cacc1e7ee8b1f33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring wood-finish flooring, a neutral color palette, and sliding glass doors providing outdoor access"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29986386_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/3698a2fe881f6a1c0e019eb1097bbec6.webp"
"MediaSize" => 81803
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-3698a2fe881f6a1c0e019eb1097bbec6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area with light wood-finish flooring, light gray wall color, and a sliding glass door leading to an outdoor patio with a pergola"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29986386_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/575e6cab5df5cb48f79333e9973a14fc.webp"
"MediaSize" => 82188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-575e6cab5df5cb48f79333e9973a14fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring light wood-finish flooring, light gray wall tones, and a large window with vertical blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29986386_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/d05b8ba30d5d116997b985be1e470aec.webp"
"MediaSize" => 81290
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-d05b8ba30d5d116997b985be1e470aec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring light wood-finish flooring, light gray wall paint, and a modern ceiling light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29986386_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/006f4645391d3e28f36e46ec167e149b.webp"
"MediaSize" => 46060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-006f4645391d3e28f36e46ec167e149b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29986386_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/537ad01831057100caa7769542aa5b50.webp"
"MediaSize" => 51463
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-537ad01831057100caa7769542aa5b50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway featuring light beige walls and carpeting, with white doors and black hardware"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29986386_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/f10b7f59fe1433fb661725913309f7eb.webp"
"MediaSize" => 77839
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-f10b7f59fe1433fb661725913309f7eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring light green wall paint and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29986386_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/38c2a1073b195dd30d3680d21e41a802.webp"
"MediaSize" => 76095
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-38c2a1073b195dd30d3680d21e41a802.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring hardwood flooring, a ceiling-mounted light fixture, and two white sliding closet doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29986386_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/8ee9a7307405d6bb1b69dc41ddb8c23a.webp"
"MediaSize" => 62130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-8ee9a7307405d6bb1b69dc41ddb8c23a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with a light-colored countertop, an undermount sink, and chrome fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29986386_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/a4bab9dd291c1d37e57ebafde9beec24.webp"
"MediaSize" => 48867
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-a4bab9dd291c1d37e57ebafde9beec24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29986386_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/0bb90721cfe75386e64ba554587ab07b.webp"
"MediaSize" => 50427
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-0bb90721cfe75386e64ba554587ab07b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room with wood-finish flooring, white walls, and a recessed ceiling light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29986386_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/88fcc83c0942f9005e7860018cf72c52.webp"
"MediaSize" => 70327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-88fcc83c0942f9005e7860018cf72c52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with wood-finish flooring, a window featuring white trim, and a ceiling light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29986386_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/b526c4f0c76142bb08553589dd0470ba.webp"
"MediaSize" => 63413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-b526c4f0c76142bb08553589dd0470ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring wood-finish flooring, white walls, and a recessed closet with bi-fold doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29986386_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/f25ce04491ec30b74f212723f76d5ff3.webp"
"MediaSize" => 82725
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-f25ce04491ec30b74f212723f76d5ff3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Finished lower level featuring light gray walls, carpeted flooring, and a drop ceiling with recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29986386_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/b6bfa497d07ffff11cffd8e3a68ef11a.webp"
"MediaSize" => 75642
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-b6bfa497d07ffff11cffd8e3a68ef11a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Finished recreational space featuring neutral wall tones, drop-panel ceiling, and light-toned carpet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29986386_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/ab96a5e3b679bab93ac55b895824d86f.webp"
"MediaSize" => 80239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-ab96a5e3b679bab93ac55b895824d86f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted room with light grey walls and a drop ceiling featuring recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29986386_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/6dfe1a2f34cd09152f968924b746decc.webp"
"MediaSize" => 99599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-6dfe1a2f34cd09152f968924b746decc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted lower level featuring drop ceiling with recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29986386_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/1e94d404c93a84e8738c3ee45b17dd2d.webp"
"MediaSize" => 76283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-1e94d404c93a84e8738c3ee45b17dd2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted lower-level room featuring light gray walls, white trim, and a drop ceiling with recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29986386_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/2ed48254465ff0387e5a287f6bc76d35.webp"
"MediaSize" => 48922
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-2ed48254465ff0387e5a287f6bc76d35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with matte black hardware, a rectangular mirror, a white undermount sink with a matte black faucet, a white shower stall, and dark wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29986386_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/219d9703aeefff3a332df19b2d27a167.webp"
"MediaSize" => 169441
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-219d9703aeefff3a332df19b2d27a167.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a lush lawn, a stone patio, and a gazebo with privacy curtains"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29986386_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/65795d6c9f0b914ac982b3a8e8f88470.webp"
"MediaSize" => 141674
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-65795d6c9f0b914ac982b3a8e8f88470.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29986386_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/64b760b695d0856bad338629e1cb368d.webp"
"MediaSize" => 152013
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-64b760b695d0856bad338629e1cb368d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fenced backyard featuring a freestanding gazebo with privacy screens, a paver patio area, and a manicured lawn"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29986386_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/1f2c9a45d2c8d10d5cfd5267f45feeef.webp"
"MediaSize" => 152110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-1f2c9a45d2c8d10d5cfd5267f45feeef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a manicured lawn, a gazebo with privacy curtains, and established perimeter landscaping"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29986386_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/dccfaf0047bc6687dd74d25425b8f7b1.webp"
"MediaSize" => 129727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-dccfaf0047bc6687dd74d25425b8f7b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Covered patio featuring a metal gazebo with privacy curtains, a sliding glass door, brick exterior, concrete patio flooring, and a privacy fence"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29986386_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986386/57a0745d41242edd7b4c27930d104469.webp"
"MediaSize" => 136557
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986386/thumbnail-57a0745d41242edd7b4c27930d104469.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Black metal gazebo featuring a solid roof, privacy curtains, and mesh screens"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844884"
"ResourceRecordKey" => "29986386"
"ModificationTimestamp" => "2026-07-03T18:48:32.64Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986386')"
+"ID": "1590741"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 283125" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24901
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1951940" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24859
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29986386'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25256
+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 '29986386'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25272
+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 '29986386' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5558434 43.499126)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25345
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25319
+post_id: "1584362"
+post_author: 1
+"ListingKey": "29977664"
+"ListingId": "40842487"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T16:25:14Z"
+"RFModificationTimestamp": "2026-07-03T16:29:59Z"
+"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": "**PUBLIC OPEN HOUSE: SAT & SUN 2-4 PM** 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-03T15:31:21Z"
+"PhotosCount": 49
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T16:18:39Z"
+"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 [
"RoomKey" => "1674206911"
"RoomType" => "Utility room"
"ListingId" => "40842487"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29977664"
"RoomLength" => null
"RoomDimensions" => "6'3'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T16:18:39.73Z"
]
1 => array:11 [
"RoomKey" => "1674206912"
"RoomType" => "Recreation room"
"ListingId" => "40842487"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29977664"
"RoomLength" => null
"RoomDimensions" => "22'0'' x 20'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T16:18:39.73Z"
]
2 => array:11 [
"RoomKey" => "1674206913"
"RoomType" => "Office"
"ListingId" => "40842487"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29977664"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T16:18:39.74Z"
]
3 => array:11 [
"RoomKey" => "1674206914"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842487"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29977664"
"RoomLength" => null
"RoomDimensions" => "16'0'' x 17'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T16:18:39.74Z"
]
4 => array:11 [
"RoomKey" => "1674206915"
"RoomType" => "Bedroom"
"ListingId" => "40842487"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29977664"
"RoomLength" => null
"RoomDimensions" => "14'9'' x 9'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T16:18:39.74Z"
]
5 => array:11 [
"RoomKey" => "1674206916"
"RoomType" => "Bedroom"
"ListingId" => "40842487"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29977664"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T16:18:39.74Z"
]
6 => array:11 [
"RoomKey" => "1674206917"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842487"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29977664"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T16:18:39.74Z"
]
7 => array:11 [
"RoomKey" => "1674206918"
"RoomType" => "Full bathroom"
"ListingId" => "40842487"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29977664"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T16:18:39.74Z"
]
8 => array:11 [
"RoomKey" => "1674206919"
"RoomType" => "Kitchen"
"ListingId" => "40842487"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29977664"
"RoomLength" => null
"RoomDimensions" => "13'7'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T16:18:39.74Z"
]
9 => array:11 [
"RoomKey" => "1674206920"
"RoomType" => "Living room"
"ListingId" => "40842487"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29977664"
"RoomLength" => null
"RoomDimensions" => "13'7'' x 20'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T16:18:39.74Z"
]
10 => array:11 [
"RoomKey" => "1674206921"
"RoomType" => "Dining room"
"ListingId" => "40842487"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29977664"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T16:18:39.74Z"
]
11 => array:11 [
"RoomKey" => "1674206922"
"RoomType" => "2pc Bathroom"
"ListingId" => "40842487"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29977664"
"RoomLength" => null
"RoomDimensions" => "5'11'' x 4'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T16:18:39.74Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29977664_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/cfdbd1bad1a6b8f739457d43984356b1.webp"
"MediaSize" => 123752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977664/thumbnail-cfdbd1bad1a6b8f739457d43984356b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Great curb appeal with aggregate driveway and welcoming gardens"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842487"
"ResourceRecordKey" => "29977664"
"ModificationTimestamp" => "2026-07-02T14:33:21.62Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29977664_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977664/fa985f654cffc634d0156dc72ab1a08b.webp"
"MediaSize" => 138228
"MediaType" => "webp"
…8
]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977664')"
+"ID": "1584362"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25321
+post_id: "1584541"
+post_author: 1
+"ListingKey": "29977329"
+"ListingId": "X13511442"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T15:20:05Z"
+"RFModificationTimestamp": "2026-07-03T15:27:41Z"
+"ListPrice": 949900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2J3"
+"UnparsedAddress": "500 GLACIER STREET, Waterloo, Ontario N2V2J3"
+"Coordinates": array:2 [
0 => -80.578434
1 => 43.495943
]
+"Latitude": 43.495943
+"Longitude": -80.578434
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "**PUBLIC OPEN HOUSE: SAT & SUN, 2-4 PM** 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-bed, 3-bath 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:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Water Treatment"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T15:52:13.449772+00:00"
+"Directions": "Cross Streets: Lake Louise Blvd. ** Directions: Conservation Drive to Lake Louise to Glacier."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2099842"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Wooded area"
1 => "Conservation/green belt"
2 => "Sump Pump"
]
+"LotSizeDimensions": "63.1 x 124.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T15:37:24Z"
+"PhotosCount": 45
+"PoolFeatures": array:2 [
0 => "Above ground pool"
1 => "Salt Water Pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T15:12:24Z"
+"Stories": "2.0"
+"StreetName": "Glacier"
+"StreetNumber": "500"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5653"
+"View": "View"
+"VirtualTourURLUnbranded": "https://youriguide.com/500_glacier_street_waterloo_on/doc/floorplan_imperial.pdf"
+"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"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29977329/500-glacier-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 63.1
+"OriginalEntryTimestamp": "2026-07-02T13:47:07.33Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1370032"
+"ListOfficeNationalAssociationId": "1369645"
+"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('29977329')"
+"ID": "1584541"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25318
+post_id: "1576593"
+post_author: 1
+"ListingKey": "29966567"
+"ListingId": "40843841"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T20:00:15Z"
+"RFModificationTimestamp": "2026-07-02T20:45:06Z"
+"ListPrice": 1049900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2937.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5R5"
+"UnparsedAddress": "292 THORNCREST Drive, Waterloo, Ontario N2L5R5"
+"Coordinates": array:2 [
0 => -80.5558838
1 => 43.4837447
]
+"Latitude": 43.4837447
+"Longitude": -80.5558838
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Set on a premium 66' x 114' lot, Welcome to an exceptional family home in Waterloo's prestigious Lakeshore neighbourhood, offering approx 3,000 sqft of finished living space and the perfect blend of luxury, functionality, & income potential. This beautifully updated property features 3+2 bedrooms, 4 bathrooms, & over $150,000 in recent upgrades, making it ideal for growing families, multigenerational living. A charming double-door entry leads to a bright & inviting interior featuring new ceramic tile flooring in the foyer and kitchen, hardwood floors throughout the living room, dining room, and office, elegant pot lights, and a cozy gas fireplace. The stunning brand-new kitchen, just completed in June 2026, offers modern cabinetry, a brand new stove, and a functional layout designed for everyday living and entertaining. Walk out to the huge deck overlooking a private, mature treed backyard with a peaceful trail-like setting. The second floor offers a massive primary bedroom with an ensuite bathroom and two additional spacious bedrooms sharing a full bath. The professionally finished legal second dwelling, completed in 2023 with over $100,000 invested, features two bedrooms, a full kitchen, living area, separate entrance, and private laundry, providing excellent mortgage support or space for extended family. Additional improvements include a newly constructed walkway to the basement entrance in 2023, beautifully landscaped front gardens with an irrigation system featuring 6 sprinklers, a double-car garage, and parking for 4 more vehicles, totaling 6 parkings. Ideally located just minutes from the University of Waterloo, Wilfrid Laurier University, Conestoga Mall, top-rated schools, parks, trails, and transit. This property offers unmatched convenience and long-term value in terms of a spacious family home, an income-generating investment property, or a home that allows your university-bound children to live close to campus while building equity. RSA (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Central Vacuum"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T18:57:56.523096+00:00"
+"Directions": "Bearinger Road to Glen Forrest Blvd to Thorncrest Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Sump Pump"
2 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T17:51:15Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T19:51:46Z"
+"Stories": "2.0"
+"StreetName": "THORNCREST"
+"StreetNumber": "292"
+"StreetSuffix": "Drive"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "7920.4"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youtu.be/B__MMicHLgQ"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29966567/292-thorncrest-drive-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR2A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 66.0
+"AboveGradeFinishedArea": 1989
+"BelowGradeFinishedArea": 948
+"OriginalEntryTimestamp": "2026-06-29T17:51:14.88Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1064132"
+"ListOfficeNationalAssociationId": "1269881"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29966567')"
+"ID": "1576593"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25322
+post_id: "1570523"
+post_author: 1
+"ListingKey": "29956597"
+"ListingId": "40842544"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T21:20:20Z"
+"RFModificationTimestamp": "2026-07-02T21:26:44Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.152
+"LivingArea": 1111.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4K6"
+"UnparsedAddress": "682 GLEN FORREST Boulevard, Waterloo, Ontario N2L4K6"
+"Coordinates": array:2 [
0 => -80.5523978
1 => 43.4928288
]
+"Latitude": 43.4928288
+"Longitude": -80.5523978
+"YearBuilt": 1969
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Accepting Offers Anytime - You're not going to want to miss this one! This fully updated raised bungalow offers a clean, move-in ready setup with 3 bedrooms, 2 bathrooms, as well as a single car garage. The main level features a bright, modern feel with California shutters and hardwood floors throughout. The updated kitchen complete with stainless steel appliances offers ample counter and cabinet space and overlooks the rear yard. Down the hall are the 3 bedrooms and renovated spa like family bath! Enjoy summer days outside on the elevated deck with a gazebo overlooking the private, heated in-ground pool. The lower level adds real flexibility with a separate office space that has direct outdoor access, as well as a large family room with a gas fireplace, and a second 3-piece bathroom, making it ideal for work-from-home or multi-use living. Book your private showing today and make this home your own! (id:62650)"
+"Appliances": array:1 [
0 => "Water softener"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T17:29:58.640281+00:00"
+"Directions": "Weber St N"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1600707"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "0.152"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T21:11:33Z"
+"PhotosCount": 30
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T21:11:33Z"
+"Stories": "1.0"
+"StreetName": "GLEN FORREST"
+"StreetNumber": "682"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "5069"
+"VirtualTourURLUnbranded": "https://youriguide.com/682_glen_forest_blvd_waterloo_on/"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29956597/682-glen-forrest-boulevard-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1926813"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299554"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 56.0
+"AboveGradeFinishedArea": 1111
+"OriginalEntryTimestamp": "2026-06-26T11:50:24.26Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1149297"
+"ListOfficeNationalAssociationId": "1473831"
+"CoListAgentNationalAssociationId": "1229829"
+"CoListOfficeNationalAssociationId": "1473831"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29956597')"
+"ID": "1570523"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25320
+post_id: "1571384"
+post_author: 1
+"ListingKey": "29956800"
+"ListingId": "40843284"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T00:40:03Z"
+"RFModificationTimestamp": "2026-06-29T00:54:06Z"
+"ListPrice": 875000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.12
+"LivingArea": 2776.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2J3"
+"UnparsedAddress": "491 SANDBANKS Crescent, Waterloo, Ontario N2V2J3"
+"Coordinates": array:2 [
0 => -80.5768597
1 => 43.4964463
]
+"Latitude": 43.4964463
+"Longitude": -80.5768597
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "IS THIS YOUR NEW HOME? Situated in desirable Conservation Meadows, this 2 Storey home offers a special option for those needing accessible features, including a main floor bedroom and ramp to the front door (2015) and also a ramp off the deck (2016). The stunning acacia engineered hardwood flooring (2019) greets you as you enter this bright and spacious main floor. The updates continue into the kitchen with new white cabinetry, quartz counters, stainless appliances and dimmable pot lights (2022). The sliders to the backyard walk out to the peaceful backyard showcasing lovely perennial gardens, and also features an Arctic Spa Yukon hot tub. Upstairs you will find 3 good-sized bedrooms including a spacious primary bedroom with large walk-in closet, and a long bathroom with potential for splitting it into two (a main bath and an ensuite bath). In the finished basement you will find a newly finished rec room, large utility room / workshop area, laundry room, cold cellar, and a separate den/office/storage room (potential for a 5th bedroom!). Additional updates include roof (2014), air conditioner (2017) washer/dryer (approx 2021), dishwasher (2024). (id:62650)"
+"AccessibilityFeatures": array:1 [
0 => "Accessible Approach with Ramp"
]
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T13:40:39.835887+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1990854"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Sump Pump"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T00:21:11Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T00:31:28Z"
+"Stories": "1.5"
+"StreetName": "SANDBANKS"
+"StreetNumber": "491"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "6158"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/view/?s=3148434&nohit=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29956800/491-sandbanks-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 2063
+"BelowGradeFinishedArea": 713
+"OriginalEntryTimestamp": "2026-06-26T13:01:54.37Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1274526"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29956800')"
+"ID": "1571384"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25315
+post_id: "1566184"
+post_author: 1
+"ListingKey": "29947549"
+"ListingId": "40842250"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T19:20:11Z"
+"RFModificationTimestamp": "2026-06-28T19:24:36Z"
+"ListPrice": 725000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 2273.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2H4"
+"UnparsedAddress": "658 ELLESMERE Court, Waterloo, Ontario N2V2H4"
+"Coordinates": array:2 [
0 => -80.5729223
1 => 43.4973152
]
+"Latitude": 43.4973152
+"Longitude": -80.5729223
+"YearBuilt": 1998
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautiful Thomas built Executive FREEHOLD Townhome. The bungalow feature makes it wonderful for anyone thinking of downsizing. Open concept living room and dining. Look through Galley kitchen for wonderful entertaining purposes. Backing onto the trans Canada Trail. Home is located on a wonderful cul-de-sac location in the quiet area of conservation Meadows. Parking for four cars, including a double car garage. All appliances included. Entrance to rear yard and deck off living. (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"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T01:56:05.034971+00:00"
+"Directions": "OFF LAKE LOUISE"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564596"
+"ListOfficeKey": "76831"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-27T17:20:06Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T19:10:47Z"
+"Stories": "1.0"
+"StreetName": "ELLESMERE"
+"StreetNumber": "658"
+"StreetSuffix": "Court"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "4497.29"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/658-Ellesmere-Ct"
+"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/29947549/658-ellesmere-court-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1950017"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299554"
+"GeocodeManualYN": true
+"ZoningDescription": "RB"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1133
+"BelowGradeFinishedArea": 1140
+"OriginalEntryTimestamp": "2026-06-24T17:11:15.95Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1095797"
+"ListOfficeNationalAssociationId": "1004391"
+"CoListAgentNationalAssociationId": "1244287"
+"CoListOfficeNationalAssociationId": "1473831"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947549')"
+"ID": "1566184"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1562913"
+post_author: 1
+"ListingKey": "29951568"
+"ListingId": "40842931"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T16:00:14Z"
+"RFModificationTimestamp": "2026-06-25T20:04:15Z"
+"ListPrice": 949900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2385.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2A4"
+"UnparsedAddress": "464 NORTHLAKE Drive, Waterloo, Ontario N2V2A4"
+"Coordinates": array:2 [
0 => -80.566943
1 => 43.497345
]
+"Latitude": 43.497345
+"Longitude": -80.566943
+"YearBuilt": 1998
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 464 Northlake Drive, Waterloo – nothing to do but move in and enjoy this fully updated home! From the windows to the kitchen, flooring, bathrooms, and more, this 3-bedroom, 3-bathroom home has been extensively updated throughout. Step inside through the welcoming foyer with a convenient coat closet. The renovated kitchen is designed for both style and function, featuring quartz countertops, a beautiful backsplash, ample workspace, and room for a large island. The dining area flows seamlessly into the bright living room with impressive vaulted ceilings, creating an open and airy space ideal for everyday living and entertaining. A fireplace rough-in is already in place, offering the option to add a cozy focal point. From the kitchen, step out to the professionally landscaped, fully fenced backyard complete with a spacious deck, perfect for summer gatherings. New flooring and carpeting throughout provide a fresh, move-in-ready feel. A convenient 2-piece bathroom completes the main floor. Upstairs, the spacious primary bedroom features a walk-in closet with custom California Closets organizers and a beautifully updated 3-piece ensuite. Two additional bedrooms, both with custom closet organizers, and an updated 4-piece bathroom complete the upper level. The finished basement adds valuable living space with a large recreation room ideal for a family room, games area, home gym, or home office. A rough-in for a future 4-piece bathroom offers added potential. Additional updates include attic insulation, doors, furnace, air conditioner, water softener and hot water heater for improved efficiency and peace of mind. Outside, enjoy an aggregate driveway with parking for two vehicles and a double attached garage. Located in a desirable Waterloo neighbourhood close to parks, schools, shopping, and amenities, this home offers modern updates, comfort, and outstanding value. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T20:04:02.027755+00:00"
+"Directions": "Conservation Drive to Northlake"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908292"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T15:11:20Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T15:50:44Z"
+"Stories": "2.0"
+"StreetName": "NORTHLAKE"
+"StreetNumber": "464"
+"StreetSuffix": "Drive"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "5729.04"
+"VirtualTourURLUnbranded": "https://youriguide.com/464_northlake_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29951568/464-northlake-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 1625
+"BelowGradeFinishedArea": 760
+"OriginalEntryTimestamp": "2026-06-25T15:11:20.34Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1221205"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29951568')"
+"ID": "1562913"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25323
+post_id: "1557723"
+post_author: 1
+"ListingKey": "29942117"
+"ListingId": "40841769"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T17:41:21Z"
+"RFModificationTimestamp": "2026-06-23T17:49:50Z"
+"ListPrice": 1289000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2857.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1G4"
+"UnparsedAddress": "667 FERN Road, Waterloo, Ontario N2V1G4"
+"Coordinates": array:2 [
0 => -80.5596766
1 => 43.500152
]
+"Latitude": 43.500152
+"Longitude": -80.5596766
+"YearBuilt": 1987
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare opportunity in sought-after Lakeshore North! Set on an impressive 69' x 159' mature, forested lot, this beautifully updated 4 bedroom home offers an incredible backyard oasis with a heated saltwater pool & hot tub surrounded by hardwood forest. The tranquil setting provides exceptional privacy, low maintenance landscaping & the perfect place to spend the summer relaxing, hosting family & friends, BBQing and entertaining. Inside you will find a spacious & functional layout with extensive upgrades! The kitchen is the heart of the home with an incredible 12 foot quartz island, gas stove, double ovens, updated stainless appliances, & a separate granite coffee & wine bar complete with a second sink, wine fridge & more cabinetry. The dining area is open to the cozy family room with engineered hardwood floors, overlooking the backyard with a wood burning fireplace & walkout to the deck. An additional living room provides even more space, open to the kitchen steps from the 2 pc bath and main floor laundry room. Upstairs you will find a primary bedroom with spa-like ensuite bath, 4 large bedrooms and & another renovated 4 piece bath, this is truly a family home! The finished basement offers a huge rec room with gas fireplace, 2 pc bath and spacious workshop for the woodworker or hobbyist. Many updates, including roof (2021), attic and cold cellar insulation (2018), owned water heater (2019), driveway restoration (2024), eavestroughs, soffits and leaf guards (2021), bathrooms (2024/2025). The backyard retreat has been improved with a new pool liner and heater (2024), pool pump (2026), pool cover (2025), hot tub (2024). Exceptional location, waking distance to Northlake Woods PS, nature trails, St Jacobs Farmer's Market, shopping and all amenities plus moments from expressway access. Combining modern updates, timeless character, and a spectacular natural setting, this is your chance to own a move-in-ready home on one of Lakeshore North's most desirable oversized lots. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Hood Fan"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T17:49:42.644745+00:00"
+"Directions": "Northlake Drive to Fern Road"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1909721"
+"ListOfficeKey": "77518"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T17:00:08Z"
+"PhotosCount": 41
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T17:00:08Z"
+"Stories": "2.0"
+"StreetName": "FERN"
+"StreetNumber": "667"
+"StreetSuffix": "Road"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "7439"
+"VirtualTourURLUnbranded": "https://667fern.com/idx"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29942117/667-fern-road-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2172119"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "77518"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 69.0
+"AboveGradeFinishedArea": 2181
+"BelowGradeFinishedArea": 676
+"OriginalEntryTimestamp": "2026-06-23T16:51:25.46Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1222004"
+"ListOfficeNationalAssociationId": "1186916"
+"CoListAgentNationalAssociationId": "1422636"
+"CoListOfficeNationalAssociationId": "1186916"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 10
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29942117')"
+"ID": "1557723"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25343
+post_id: "1556740"
+post_author: 1
+"ListingKey": "29940666"
+"ListingId": "40842058"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T20:20:22Z"
+"RFModificationTimestamp": "2026-06-28T20:25:26Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2034.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4W9"
+"UnparsedAddress": "176 WOODVILLE Place, Waterloo, Ontario N2L4W9"
+"Coordinates": array:2 [
0 => -80.547439
1 => 43.4910554
]
+"Latitude": 43.4910554
+"Longitude": -80.547439
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Cul-de-sac living! Welcome to 176 Woodville Place, a beautifully maintained raised bungalow situated on a quiet cul-de-sac in a prime location. This spacious 5-bedroom, 2-bathroom home is perfect for families looking for a move-in-ready property with great potential. Freshly painted throughout, the functional layout features a fully finished walk-out basement with a separate entrance, offering excellent flexibility. The bright lower level has full sized windows, making this style of home perfect for an in-law set up or totally separate rental unit conversion. Some notable updates include : Furnace/AC/Roof (2022) and most windows (2021). The home comes with an attached single-car garage and 4 car driveway offers space for everyone. No rental contracts to worry about. Relax on the raised deck with newly installed stairs, or enjoy the inground concrete pool—a true serene oasis for the summer months. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T14:36:55.431146+00:00"
+"Directions": "Parkside Dr to Cedarbrae Ave to Mt Anne Dr to Woodville Place"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2053490"
+"ListOfficeKey": "76840"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T14:11:54Z"
+"PhotosCount": 40
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T20:11:12Z"
+"Stories": "1.0"
+"StreetName": "WOODVILLE"
+"StreetNumber": "176"
+"StreetSuffix": "Place"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "4891"
+"VirtualTourURLUnbranded": "https://youriguide.com/176_woodville_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29940666/176-woodville-place-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2102262"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76840"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1198
+"BelowGradeFinishedArea": 836
+"OriginalEntryTimestamp": "2026-06-23T14:11:54.56Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1328779"
+"ListOfficeNationalAssociationId": "1004363"
+"CoListAgentNationalAssociationId": "1372011"
+"CoListOfficeNationalAssociationId": "1004363"
+"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": 10
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29940666')"
+"ID": "1556740"
}
]
+success: true
+page_size: 9
+page_count: 8
+count: 65
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]