array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30075063 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23528
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23530
+post_id: "1655783"
+post_author: 1
+"ListingKey": "30075063"
+"ListingId": "40849840"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T15:05:31Z"
+"RFModificationTimestamp": "2026-07-24T17:06:19Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1428.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1A9"
+"UnparsedAddress": "274 NORTHLAKE Drive Unit# B, Waterloo, Ontario N2V1A9"
+"Coordinates": array:2 [
0 => -80.5511816
1 => 43.4974065
]
+"Latitude": 43.4974065
+"Longitude": -80.5511816
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this well-maintained raised bungalow semi-detached home in one of Waterloo's most desirable family-friendly neighbourhoods. Backing onto beautiful parkland, this home offers privacy and a peaceful setting. Featuring 3 spacious bedrooms, 2 full bathrooms, a bright living room with a large bay window, and an eat-in kitchen with a breakfast bar. The finished lower level features a recreation room with a walkout, a 3-piece bathroom, and a laundry area, offering added flexibility and potential for an in-law setup. Step outside to the fully fenced backyard, complete with a patio and storage shed, perfect for relaxing or entertaining. Conveniently located close to schools, parks, shopping, transit, and all amenities, this is an excellent opportunity for first-time buyers, families, or investors. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T17:06:09.845889+00:00"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1897040"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T14:59:39Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T14:59:39Z"
+"Stories": "1.0"
+"StreetName": "NORTHLAKE"
+"StreetNumber": "274"
+"StreetSuffix": "Drive"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "3630"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1692439279"
"RoomType" => "Recreation room"
"ListingId" => "40849840"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30075063"
"RoomLength" => null
"RoomDimensions" => "17'6'' x 18'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T14:59:39.47Z"
]
1 => array:11 [
"RoomKey" => "1692439280"
"RoomType" => "3pc Bathroom"
"ListingId" => "40849840"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30075063"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 7'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T14:59:39.47Z"
]
2 => array:11 [
"RoomKey" => "1692439281"
"RoomType" => "Primary Bedroom"
"ListingId" => "40849840"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30075063"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T14:59:39.47Z"
]
3 => array:11 [
"RoomKey" => "1692439282"
"RoomType" => "Living room"
"ListingId" => "40849840"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30075063"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 17'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T14:59:39.47Z"
]
4 => array:11 [
"RoomKey" => "1692439283"
"RoomType" => "Kitchen"
"ListingId" => "40849840"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30075063"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T14:59:39.47Z"
]
5 => array:11 [
"RoomKey" => "1692439284"
"RoomType" => "Dining room"
"ListingId" => "40849840"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30075063"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T14:59:39.47Z"
]
6 => array:11 [
"RoomKey" => "1692439285"
"RoomType" => "Bedroom"
"ListingId" => "40849840"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30075063"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T14:59:39.47Z"
]
7 => array:11 [
"RoomKey" => "1692439286"
"RoomType" => "Bedroom"
"ListingId" => "40849840"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30075063"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 9'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T14:59:39.47Z"
]
8 => array:11 [
"RoomKey" => "1692439287"
"RoomType" => "4pc Bathroom"
"ListingId" => "40849840"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30075063"
"RoomLength" => null
"RoomDimensions" => "7'4'' x 5'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T14:59:39.47Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30075063/274-northlake-drive-unit-b-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 883
+"BelowGradeFinishedArea": 545
+"OriginalEntryTimestamp": "2026-07-24T14:59:39.45Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1215043"
+"ListOfficeNationalAssociationId": "1004370"
+"Media": array:21 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30075063_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075063/9006f1aeaa15c405490c2b38d59514ea.webp"
"MediaSize" => 183538
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075063/thumbnail-9006f1aeaa15c405490c2b38d59514ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior with light-colored siding, two bay windows, and two single-car garages"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40849840"
"ResourceRecordKey" => "30075063"
"ModificationTimestamp" => "2026-07-24T14:59:39.45Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30075063_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075063/4a4abed700b28aff5396dad06338dbe0.webp"
"MediaSize" => 160896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075063/thumbnail-4a4abed700b28aff5396dad06338dbe0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849840"
"ResourceRecordKey" => "30075063"
"ModificationTimestamp" => "2026-07-24T14:59:39.45Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30075063_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075063/7951fd50c344375e614d8b4c6ff37028.webp"
"MediaSize" => 181785
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075063/thumbnail-7951fd50c344375e614d8b4c6ff37028.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Outdoor deck with natural wood plank flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849840"
"ResourceRecordKey" => "30075063"
"ModificationTimestamp" => "2026-07-24T14:59:39.45Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30075063_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075063/626323c0e1cb7445687b1c9af9d87c8e.webp"
"MediaSize" => 74357
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075063/thumbnail-626323c0e1cb7445687b1c9af9d87c8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright kitchen featuring white cabinetry, subway tile backsplash, stainless steel appliances, and a central island with counter seating"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849840"
"ResourceRecordKey" => "30075063"
"ModificationTimestamp" => "2026-07-24T14:59:39.45Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30075063_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075063/9156188de6c451fa99378da1a8a5f93a.webp"
"MediaSize" => 71485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075063/thumbnail-9156188de6c451fa99378da1a8a5f93a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white cabinetry, stainless steel appliances, a white subway tile backsplash, and a large island with a light-toned countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849840"
"ResourceRecordKey" => "30075063"
"ModificationTimestamp" => "2026-07-24T14:59:39.45Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30075063_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075063/383862e8965f4ae196e7f79238330e2f.webp"
"MediaSize" => 83913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075063/thumbnail-383862e8965f4ae196e7f79238330e2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring light-toned walls and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849840"
"ResourceRecordKey" => "30075063"
"ModificationTimestamp" => "2026-07-24T14:59:39.45Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30075063_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075063/dc725f8a4659b524f173adb2994d3d0c.webp"
"MediaSize" => 81395
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075063/thumbnail-dc725f8a4659b524f173adb2994d3d0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring wood-finish flooring, recessed lighting, and a large window with sheer curtains"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849840"
"ResourceRecordKey" => "30075063"
"ModificationTimestamp" => "2026-07-24T14:59:39.45Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30075063_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075063/2fe5813f0f35b308e46c1990e3679b2b.webp"
"MediaSize" => 73890
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075063/thumbnail-2fe5813f0f35b308e46c1990e3679b2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright living area featuring light wood-finish flooring and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849840"
"ResourceRecordKey" => "30075063"
"ModificationTimestamp" => "2026-07-24T14:59:39.45Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30075063_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075063/e382596c599ed950c04e7081aa04bd1b.webp"
"MediaSize" => 73770
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075063/thumbnail-e382596c599ed950c04e7081aa04bd1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring light wood-finish flooring, light gray walls, and recessed ceiling lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849840"
"ResourceRecordKey" => "30075063"
"ModificationTimestamp" => "2026-07-24T14:59:39.45Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30075063_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075063/0e97bf3bb2594d888ea0d9fcd18492ae.webp"
"MediaSize" => 62753
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075063/thumbnail-0e97bf3bb2594d888ea0d9fcd18492ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Neutral white walls frame a room featuring wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849840"
"ResourceRecordKey" => "30075063"
"ModificationTimestamp" => "2026-07-24T14:59:39.45Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30075063_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075063/224a503cfd801fdcb2a2d847c7e555e1.webp"
"MediaSize" => 60654
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075063/thumbnail-224a503cfd801fdcb2a2d847c7e555e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light-colored walls, wood-finish flooring, a window with horizontal blinds, and a ceiling fan with integrated lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849840"
"ResourceRecordKey" => "30075063"
"ModificationTimestamp" => "2026-07-24T14:59:39.45Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30075063_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075063/ce1a4be114b3dd2c98b5bdded048120c.webp"
"MediaSize" => 50122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075063/thumbnail-ce1a4be114b3dd2c98b5bdded048120c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room with light blue walls, a single window, and a ceiling fan with integrated lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849840"
"ResourceRecordKey" => "30075063"
"ModificationTimestamp" => "2026-07-24T14:59:39.45Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30075063_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075063/45796a5b388491e4741bdf69d873bab5.webp"
"MediaSize" => 57304
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075063/thumbnail-45796a5b388491e4741bdf69d873bab5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a contemporary vessel sink with a single-handle faucet, a white framed mirror, and wood paneling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849840"
"ResourceRecordKey" => "30075063"
"ModificationTimestamp" => "2026-07-24T14:59:39.45Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30075063_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075063/d49867eac9d0d0e72052e3c240626508.webp"
"MediaSize" => 63264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075063/thumbnail-d49867eac9d0d0e72052e3c240626508.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "White stacked washer and dryer unit, featuring front-loading doors and a neutral-toned tile floor"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849840"
"ResourceRecordKey" => "30075063"
"ModificationTimestamp" => "2026-07-24T14:59:39.45Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30075063_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075063/2cb926e8fd2ab81b991f412852f30007.webp"
"MediaSize" => 94480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075063/thumbnail-2cb926e8fd2ab81b991f412852f30007.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849840"
"ResourceRecordKey" => "30075063"
"ModificationTimestamp" => "2026-07-24T14:59:39.45Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30075063_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075063/a6f04e7795331c2d4cbe17495d3739b6.webp"
"MediaSize" => 59390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075063/thumbnail-a6f04e7795331c2d4cbe17495d3739b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a wall-mounted vanity with integrated sink, framed mirror, and a shower enclosure with a frosted glass panel"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849840"
"ResourceRecordKey" => "30075063"
"ModificationTimestamp" => "2026-07-24T14:59:39.45Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30075063_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075063/b991d217f5bf729a04a150892177281b.webp"
"MediaSize" => 158192
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075063/thumbnail-b991d217f5bf729a04a150892177281b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive grassy area featuring a gentle slope, mature trees, and a chain-link fence border"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849840"
"ResourceRecordKey" => "30075063"
"ModificationTimestamp" => "2026-07-24T14:59:39.45Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30075063_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075063/ecef62369529d2b093efebe5850bbb2a.webp"
"MediaSize" => 222495
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075063/thumbnail-ecef62369529d2b093efebe5850bbb2a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rear yard featuring a purple storage shed with gray double doors, a concrete pad, and a chain-link fence"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849840"
"ResourceRecordKey" => "30075063"
"ModificationTimestamp" => "2026-07-24T14:59:39.45Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30075063_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075063/243e56987e74a20f25d6c3b48538cb56.webp"
"MediaSize" => 160880
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075063/thumbnail-243e56987e74a20f25d6c3b48538cb56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive green space featuring a paved pathway and mature deciduous trees"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849840"
"ResourceRecordKey" => "30075063"
"ModificationTimestamp" => "2026-07-24T14:59:39.45Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30075063_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075063/e40bd6c57a407872008efa71c9df09f1.webp"
"MediaSize" => 47961
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075063/thumbnail-e40bd6c57a407872008efa71c9df09f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849840"
"ResourceRecordKey" => "30075063"
"ModificationTimestamp" => "2026-07-24T14:59:39.45Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30075063_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075063/aab7d00066cadeca359604e7396d2272.webp"
"MediaSize" => 44033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075063/thumbnail-aab7d00066cadeca359604e7396d2272.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849840"
"ResourceRecordKey" => "30075063"
"ModificationTimestamp" => "2026-07-24T14:59:39.45Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30075063')"
+"ID": "1655783"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 76807" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24988
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24931
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "519-579-4110"
+"OfficeMlsId": "KW64"
+"ModificationTimestamp": "2026-03-24T17:19:43Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "76807"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "901 VICTORIA ST. N."
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "KITCHENER"
+"OfficePostalCode": "N2B3C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1004370"
+"OriginalEntryTimestamp": null
+"OfficeFax": "519-579-3442"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "431111"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "76807"
"SocialMediaUrlOrId" => "http://www.remaxtwincity.com/"
"ModificationTimestamp" => "2026-03-24T16:37:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1069905"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('76807')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1897040" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25011
+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 '30075063'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25295
+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 '30075063' AND OpenHouseDate ge '2026-07-23'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25311
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30075063' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5511816 43.4974065)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25364
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25358
+post_id: "1656993"
+post_author: 1
+"ListingKey": "30075685"
+"ListingId": "40850923"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T16:35:23Z"
+"RFModificationTimestamp": "2026-07-24T19:27:42Z"
+"ListPrice": 589900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.14
+"LivingArea": 2026.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4N1"
+"UnparsedAddress": "602 HIGHPOINT Avenue, Waterloo, Ontario N2L4N1"
+"Coordinates": array:2 [
0 => -80.5629215
1 => 43.4867268
]
+"Latitude": 43.4867268
+"Longitude": -80.5629215
+"YearBuilt": 1972
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "OPPORTUNITY KNOCKS IN LAKESHORE ! Welcome to 602 Highpoint Avenue, a rock-solid, all-brick raised bungalow nestled in one of Waterloo’s most desirable family neighborhoods. Offered as a clean blank canvas ready for its next chapter. The main floor features an exceptionally bright, expansive living room with a massive front bay window, a formal dining area, a functional kitchen with a rear walkout, three bedrooms, and a full 4-piece bathroom. Distinct from conventional raised bungalows, the low-profile design features a highly accessible entry with just a single step into the home. The fully finished lower level massively expands your living space, showcasing a huge family room anchored by a rustic brick feature wall and a cozy wood-burning stove. This level also includes a spacious fourth bedroom, a powder room, a dedicated laundry area, and a separate workshop/utility space with abundant storage. Step outside to your private wood deck overlooking a wide, beautifully landscaped, fully fenced yard framed by a pristine cedar hedge and mature fruit trees. Additional features include a deep asphalt driveway and vinyl windows (approximately 10 years old). Ashphalt Roof (approximately 10 years old) Walk to top-rated schools, parks, and local amenities. Unlock this home’s massive potential today! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-24T19:27:30.471780+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Other"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2214101"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.14"
+"PhotosChangeTimestamp": "2026-07-24T16:29:59Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T16:29:59Z"
+"Stories": "1.0"
+"StreetName": "HIGHPOINT"
+"StreetNumber": "602"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "3987"
+"VirtualTourURLUnbranded": "https://youriguide.com/602_highpoint_avenue_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1692509446"
"RoomType" => "2pc Bathroom"
"ListingId" => "40850923"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30075685"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 4'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T16:29:59.21Z"
]
1 => array:11 [
"RoomKey" => "1692509447"
"RoomType" => "Bedroom"
"ListingId" => "40850923"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30075685"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 15'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T16:29:59.21Z"
]
2 => array:11 [
"RoomKey" => "1692509448"
"RoomType" => "Recreation room"
"ListingId" => "40850923"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30075685"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 17'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T16:29:59.21Z"
]
3 => array:11 [
"RoomKey" => "1692509449"
"RoomType" => "Family room"
"ListingId" => "40850923"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30075685"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T16:29:59.21Z"
]
4 => array:11 [
"RoomKey" => "1692509450"
"RoomType" => "Bedroom"
"ListingId" => "40850923"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30075685"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T16:29:59.21Z"
]
5 => array:11 [
"RoomKey" => "1692509451"
"RoomType" => "Bedroom"
"ListingId" => "40850923"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30075685"
"RoomLength" => null
"RoomDimensions" => "14'8'' x 8'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T16:29:59.21Z"
]
6 => array:11 [
"RoomKey" => "1692509452"
"RoomType" => "Bedroom"
"ListingId" => "40850923"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30075685"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 8'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T16:29:59.21Z"
]
7 => array:11 [
"RoomKey" => "1692509453"
"RoomType" => "4pc Bathroom"
"ListingId" => "40850923"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30075685"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 7'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T16:29:59.21Z"
]
8 => array:11 [
"RoomKey" => "1692509454"
"RoomType" => "Kitchen"
"ListingId" => "40850923"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30075685"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T16:29:59.21Z"
]
9 => array:11 [
"RoomKey" => "1692509455"
"RoomType" => "Dining room"
"ListingId" => "40850923"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30075685"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T16:29:59.22Z"
]
10 => array:11 [
"RoomKey" => "1692509456"
"RoomType" => "Living room"
"ListingId" => "40850923"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30075685"
"RoomLength" => null
"RoomDimensions" => "16'3'' x 15'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T16:29:59.22Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30075685/602-highpoint-avenue-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 1050
+"BelowGradeFinishedArea": 976
+"OriginalEntryTimestamp": "2026-07-24T16:29:59.14Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1459821"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:36 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30075685_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/069838b4d105eee151db1209c55880ee.webp"
"MediaSize" => 172679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-069838b4d105eee151db1209c55880ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Split-level residence featuring light-colored siding and a contrasting brick foundation"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30075685_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/34f1007ad90b1467349fd1fd67bfc654.webp"
"MediaSize" => 166004
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-34f1007ad90b1467349fd1fd67bfc654.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bungalow exterior featuring brick and siding finishes, a bay window, and a paved driveway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30075685_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/57c2352c25f70de55e5978ef0f0ef177.webp"
"MediaSize" => 158717
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-57c2352c25f70de55e5978ef0f0ef177.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30075685_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/0280f5d293ac9b623fb496f0011f05ea.webp"
"MediaSize" => 179364
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-0280f5d293ac9b623fb496f0011f05ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Featuring a brick and siding exterior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30075685_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/575b1da9d0d3ab9e37e4dea836688986.webp"
"MediaSize" => 43003
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-575b1da9d0d3ab9e37e4dea836688986.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entry door with an arched transom window, paneled design, and brass hardware"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30075685_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/e181887a98dae66b82e867af62a3adcb.webp"
"MediaSize" => 100460
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-e181887a98dae66b82e867af62a3adcb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30075685_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/44164a862ddcb76836cfee6fb9a37a22.webp"
"MediaSize" => 95210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-44164a862ddcb76836cfee6fb9a37a22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30075685_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/d62ba9ece507b5f470757cca90d83a42.webp"
"MediaSize" => 92873
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-d62ba9ece507b5f470757cca90d83a42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30075685_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/2576907ae20bb8d41d63ef98a16efa04.webp"
"MediaSize" => 102820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-2576907ae20bb8d41d63ef98a16efa04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive bay window with a deep sill"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30075685_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/540694d8f1dfee262477d913793d2b9b.webp"
"MediaSize" => 81047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-540694d8f1dfee262477d913793d2b9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring patterned floor tiles, a ceiling-mounted chandelier, and a white exterior door with glass panels"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30075685_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/7674f83606605c6b436d59d8f59a08f4.webp"
"MediaSize" => 75858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-7674f83606605c6b436d59d8f59a08f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, white countertops, a double basin sink, and a window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30075685_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/60501f9d50d99fba4e95c6f5a051301c.webp"
"MediaSize" => 66177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-60501f9d50d99fba4e95c6f5a051301c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, a double basin sink with chrome faucet, and white tiled backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30075685_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/1ff9bb4540a58954eeea10edbdad0774.webp"
"MediaSize" => 89895
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-1ff9bb4540a58954eeea10edbdad0774.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30075685_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/ff2c329af7b27014c2a4e80ac058a6c3.webp"
"MediaSize" => 63600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-ff2c329af7b27014c2a4e80ac058a6c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway featuring neutral-toned carpet flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30075685_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/6e113a8928c6031d7284179a85e07332.webp"
"MediaSize" => 57965
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-6e113a8928c6031d7284179a85e07332.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30075685_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/09742823ef9f63ca180a1ebcf1c77fea.webp"
"MediaSize" => 68431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-09742823ef9f63ca180a1ebcf1c77fea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30075685_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/c0056a0d51a7102606cf6c3302605d4d.webp"
"MediaSize" => 55095
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-c0056a0d51a7102606cf6c3302605d4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30075685_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/5222d53cb4378b91be6adf1abc709d2d.webp"
"MediaSize" => 60495
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-5222d53cb4378b91be6adf1abc709d2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30075685_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/8e1ea4d00ae15a97310797fc8f02855c.webp"
"MediaSize" => 67053
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-8e1ea4d00ae15a97310797fc8f02855c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, a window with vertical blinds, and a ceiling fan with integrated lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30075685_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/7a59a6abd131d668fba242a8d793ce16.webp"
"MediaSize" => 53293
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-7a59a6abd131d668fba242a8d793ce16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, a ceiling fan with integrated lighting, a window with horizontal blinds, and neutral-toned walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30075685_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/2e96be754effde2ad3f46d71c8067639.webp"
"MediaSize" => 47436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-2e96be754effde2ad3f46d71c8067639.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, a ceiling fan with light fixture, and neutral-toned walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30075685_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/eb779f18383646f738fe9ac37a055c0b.webp"
"MediaSize" => 73258
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-eb779f18383646f738fe9ac37a055c0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring wood-finish flooring, floral-patterned wallpaper, a window with an orange valance, a textured ceiling, and a ceiling fan with integrated lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30075685_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/7bf89e78c080099b1f729fd491f92f88.webp"
"MediaSize" => 67248
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-7bf89e78c080099b1f729fd491f92f88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, floral wallpaper, and a window with a valance"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30075685_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/7cea2c2bd570a17e3a5633678274e370.webp"
"MediaSize" => 82586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-7cea2c2bd570a17e3a5633678274e370.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, floral wallpaper, and a built-in closet with bifold doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30075685_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/14d7c3df5cf331de10da97422efdeb53.webp"
"MediaSize" => 70221
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30075685/thumbnail-14d7c3df5cf331de10da97422efdeb53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850923"
"ResourceRecordKey" => "30075685"
"ModificationTimestamp" => "2026-07-24T16:29:59.15Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30075685_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30075685/63e43b7ea6f4167cc7e285c115eb9243.webp"
…10
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30075685')"
+"ID": "1656993"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25360
+post_id: "1656367"
+post_author: 1
+"ListingKey": "30076062"
+"ListingId": "40850502"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T18:40:04Z"
+"RFModificationTimestamp": "2026-07-24T18:44:07Z"
+"ListPrice": 525000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1605.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4T3"
+"UnparsedAddress": "185 CEDARVALE Crescent Unit# A, Waterloo, Ontario N2L4T3"
+"Coordinates": array:2 [
0 => -80.5470388
1 => 43.4889802
]
+"Latitude": 43.4889802
+"Longitude": -80.5470388
+"YearBuilt": 1971
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Looking for an updated home with 4 bedrooms & 2 full baths? This Semi maybe the home for you! North end of University of Waterloo & new Hospital to be built, Conestoga Mall & LRT, this 3+1 bedroom, 2 full bath move-in condition semi on quiet Cedarvale Crescent! Freshly painted throughout, carpet free home with a huge fully fenced backyard is perfectly located on a quiet street with lots of beautiful mature tall trees. The main floor features a large Living room with plenty of natural light from the very large front window as well as the brand new ceiling potlights, Dining area with beautiful contemporary chandelier and large window, open to the brand new modern white shaker style kitchen with quartz counters and white fridge and stove. Take the hardwood stairs to the second storey featureing 3 very good size bedrooms and a modern 4 piece main bathroom. The basement features a large bonus room with a good size window and a closet that can be used as a bedroom or a Recroom, a full 3 piece bathroom, Laundry and Utility room with walk up to the backyard. To access the basement, you have 3 options: from the kitchen inside the house, or the separate enterance (exterior side door) from the drive way, or the stairs from the backyard going to the back door (please don't use the back stairs - they haven't been used recently). Updates include but are not limited to: fresh paint throughout 2026, Brand new kitchen with quarz counters 2026, Fridge & Stove 2025, Pot Lights in Living room 2026, LVP flooring in basement & on stairs going to basement 2026, Main water shut-offs 2026, Dryer 2024, Furnace 2020, Roof 2018, Laminate flooring on main and second floors 2018, Hardwood stairs going to second floor 2018, All plumbing replaced on main & second floors 2018. Close to schools, shopping, busses. Shows very well! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-24T18:14:38.397112+00:00"
+"Directions": "Parkside Dr/Cedarbrae Ave"
+"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": "1564444"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-07-24T18:33:27Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T18:33:27Z"
+"Stories": "2.0"
+"StreetName": "CEDARVALE"
+"StreetNumber": "185"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "3423.1"
+"VirtualTourURLUnbranded": "https://youriguide.com/185_a_cedarvale_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30076062/185-cedarvale-crescent-unit-a-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2070594"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1600658"
+"CoListAgentKey3": "1630441"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "290620"
+"CoListOfficeKey3": "76826"
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1066
+"BelowGradeFinishedArea": 539
+"OriginalEntryTimestamp": "2026-07-24T17:08:29.5Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1122502"
+"ListOfficeNationalAssociationId": "1389824"
+"CoListAgentNationalAssociationId": "1345744"
+"CoListAgentNationalAssociationId2": "1153962"
+"CoListAgentNationalAssociationId3": "1162058"
+"CoListOfficeNationalAssociationId": "1004387"
+"CoListOfficeNationalAssociationId2": "1389824"
+"CoListOfficeNationalAssociationId3": "1004387"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30076062')"
+"ID": "1656367"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25357
+post_id: "1650469"
+post_author: 1
+"ListingKey": "30068043"
+"ListingId": "40848945"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T11:55:10Z"
+"RFModificationTimestamp": "2026-07-23T11:56:22Z"
+"ListPrice": 850000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3031.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1X2"
+"UnparsedAddress": "353 TWINFLOWER Crescent, Waterloo, Ontario N2V1X2"
+"Coordinates": array:2 [
0 => -80.5607806
1 => 43.4989658
]
+"Latitude": 43.4989658
+"Longitude": -80.5607806
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 353 Twinflower Crescent, a mature community wrapped in tree lined streets with walkable amenities. The fact that this beautifully maintained home has only had one owner since built in 1988 should tell you everything you need to know about this property. Factor in that a fully excavated addition was completed by Menno Martin in 2000, which DOUBLED THE SIZE OF THE KITCHEN, makes this truly a one of a kind offering! Inside, you are welcomed by a sweeping sunken foyer which greets your guests in style. Accompanied by the main floor living room, and just a step up to a formal dining room, this entry level is completed by a massive Chef's kitchen that everyone dreams of. The Centre Island layout allows for more than ample prep space or simply allows for company to cheerlead you on as you prepare that special family feast. The upper level of this 4 level backsplit features 3 bedrooms, a primary en-suite bath & walk-in closet while the 5 pc main bath will service others on this upper level. The lower level, allows for large look out windows for an abundance of natural daylight. This level features a bountiful family room with natural gas fireplace, a 2 pc bath, finished laundry room & 4th bedroom for the growing family or guest room needs. Down below in the FULLY FINISHED 4th level, there is an abundance of much desired space for a recreation room plus a games room & a 5th bedroom! The backyard is your private oasis. Not directly backing onto any neighbours, you can enjoy the privacy of the mature landscaping for all you outdoor gatherings. The amenities of Northlake are plenty & access to shopping at Conestoga Mall & the Expressway are just minutes away. You're also just a stones throw from St Jacobs & their famous Farmer's Market. Schools, parks, greenspace and trails are all within walking distance of Twinflower Crescent. We hope to see you either Sat or Sun between 2 & 4 pm & encourage you to call your Realtor to book a private viewing before it's too late. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Gas stove(s)"
6 => "Dishwasher"
7 => "Dryer"
8 => "Microwave"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "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-22T22:37:15.125360+00:00"
+"Directions": "Northlake Drive to Monarch Place, first right is Twinflower Crescent, first house on your left."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"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": "1854697"
+"ListOfficeKey": "76840"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
3 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T07:10:15Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T11:48:44Z"
+"Stories": "2.0"
+"StreetName": "TWINFLOWER"
+"StreetNumber": "353"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "5603"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/353-Twinflower-Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30068043/353-twinflower-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1564118"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76840"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 1747
+"BelowGradeFinishedArea": 1284
+"OriginalEntryTimestamp": "2026-07-22T22:08:23.49Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1199521"
+"ListOfficeNationalAssociationId": "1004363"
+"CoListAgentNationalAssociationId": "1126014"
+"CoListOfficeNationalAssociationId": "1004363"
+"Media": array:43 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30068043')"
+"ID": "1650469"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25361
+post_id: "1649190"
+post_author: 1
+"ListingKey": "30066608"
+"ListingId": "40849912"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T14:05:12Z"
+"RFModificationTimestamp": "2026-07-23T14:06:50Z"
+"ListPrice": 825000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1159.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2H2"
+"UnparsedAddress": "418 SANDBANKS Crescent, Waterloo, Ontario N2V2H2"
+"Coordinates": array:2 [
0 => -80.5734704
1 => 43.4964448
]
+"Latitude": 43.4964448
+"Longitude": -80.5734704
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Impeccable 2-bedroom, 3-bath bungalow in the highly sought-after Conservation Meadows neighbourhood with a double-car garage! This bright, open-concept home features vaulted ceilings in the living room and primary bedroom, a spacious eat-in kitchen with an abundance of cabinetry, newly refaced modern shaker cabinet doors, quartz countertops throughout the main floor, and updated flooring and lighting. The primary suite offers a 4-piece ensuite, while the convenient main-floor laundry adds everyday functionality. Walk out from the living room to a large deck overlooking beautifully landscaped, mature gardens with an underground sprinkler system. The finished lower level boasts a cozy rec room with a gas fireplace, a 3-piece bath, a potential third bedroom (ceiling required), and ample storage space. Numerous updates include furnace & A/C (2021), updated light fixtures with pot lights, plus central vac, reverse osmosis system, and air exchanger. Ideally located close to the farmers' market, conservation area, scenic walking trails, and with easy highway access. Pride of ownership is evident throughout. Shows exceptionally well! (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 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T19:59:12.559033+00:00"
+"Directions": "LAKE LOUISE"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564233"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T00:42:17Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T13:59:12Z"
+"Stories": "1.0"
+"StreetName": "SANDBANKS"
+"StreetNumber": "418"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5213.43"
+"VirtualTourURLUnbranded": "https://youriguide.com/418_sandbanks_crescent_waterloo_on/"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30066608/418-sandbanks-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 35.0
+"AboveGradeFinishedArea": 1159
+"OriginalEntryTimestamp": "2026-07-22T18:29:34.74Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070035"
+"ListOfficeNationalAssociationId": "1324759"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30066608')"
+"ID": "1649190"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25359
+post_id: "1646016"
+post_author: 1
+"ListingKey": "30060938"
+"ListingId": "40849990"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T17:35:20Z"
+"RFModificationTimestamp": "2026-07-21T17:44:49Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1040.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1A9"
+"UnparsedAddress": "264 NORTHLAKE Drive Unit# A, Waterloo, Ontario N2V1A9"
+"Coordinates": array:2 [
0 => -80.552536
1 => 43.4970487
]
+"Latitude": 43.4970487
+"Longitude": -80.552536
+"YearBuilt": 1978
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Set in Waterloo's established Lakeshore neighbourhood, 264A Northlake Drive offers 3 bedrooms, 2 bathrooms, a partially fenced backyard, parking for up to three vehicles, and a layout with a walkout from the living room to the backyard. Step outside and you're minutes from Laurel Creek Conservation Area, St. Jacobs Farmers' Market, Conestoga Mall, both the University of Waterloo and Wilfrid Laurier University, excellent schools, parks, shopping, public transit, and Highway 85. Whether you're searching for a place to call home or your next investment, locations like this continue to stand the test of time—and this is your chance to make it your own. (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-21T17:44:40.434218+00:00"
+"Directions": "WEBER TO GOLDEN EAGLE, LEFT ON NORTHLAKE"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2248310"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"PhotosChangeTimestamp": "2026-07-21T17:29:22Z"
+"PhotosCount": 6
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T17:29:22Z"
+"Stories": "2.0"
+"StreetName": "NORTHLAKE"
+"StreetNumber": "264"
+"StreetSuffix": "Drive"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "3365.81"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30060938/264-northlake-drive-unit-a-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1040
+"OriginalEntryTimestamp": "2026-07-21T17:29:21.98Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1487214"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:6 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30060938')"
+"ID": "1646016"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25354
+post_id: "1646017"
+post_author: 1
+"ListingKey": "30060615"
+"ListingId": "40849821"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T18:00:04Z"
+"RFModificationTimestamp": "2026-07-24T18:14:09Z"
+"ListPrice": 650000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1417.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4K4"
+"UnparsedAddress": "659 GLEN FORREST Boulevard, Waterloo, Ontario N2L4K4"
+"Coordinates": array:2 [
0 => -80.557184
1 => 43.4930419
]
+"Latitude": 43.4930419
+"Longitude": -80.557184
+"YearBuilt": 1969
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "OPEN HOUSE SUN JULY 26, 2 to 4PM. Move-in ready backsplit with major recent upgrades in family-friendly Lakeshore Village. This carpet-free home is truly move-in ready thanks to extensive recent upgrades. These updates include the roof (2020), Furnace, A/C and a smart thermostat (2025), dishwasher, washer, and dryer (2025), as well as new exterior doors, the main-floor kitchen and dining room windows, upper-level bedroom windows, eavestroughs, and an updated electrical panel (2026). The open-concept layout features hand-scraped hardwood and porcelain tile on the main and upper levels, along with a modernized kitchen with quartz countertops, stainless steel appliances, reverse osmosis filtration, custom dining built-ins, and pot lights - perfect for everyday living and entertaining. All bedrooms overlook the private backyard and the bathrooms have been tastefully refreshed. The bright lower-level rec room offers natural light and walk-up access to the fully fenced backyard, along with generous built-in storage and additional space in the large crawl space. Outside, a spacious patio is ideal for summer BBQs and time with family and friends, complemented by a large storage shed. The covered carport provides the opportunity to convert it into a full garage, adding flexibility and future value. Conveniently located near grocery stores, shopping, The Club at Northfield, the ION LRT, the expressway, Highway 401, and schools such as the University of Waterloo and Wilfrid Laurier University. Laurel Creek Conservation Area, parks, and scenic walking trails are all within easy walking distance, while the St. Jacobs Farmers’ Market is just a short drive away. This well-maintained home offers the convenience and peaceful lifestyle many families are looking for. Schedule your private showing to see it for yourself. (id:62650)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Partial"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-21T17:12:39.204493+00:00"
+"Directions": "NORTHGATE AVE AND GLEN FORREST BLVD"
+"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": "1736200"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-07-24T17:53:15Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T17:59:47Z"
+"Stories": "1.0"
+"StreetName": "GLEN FORREST"
+"StreetNumber": "659"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "4011"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/659-Glen-Forrest-Blvd"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30060615/659-glen-forrest-boulevard-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2150801"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2192963"
+"CoListOfficeKey": "283125"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "283125"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR1A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 980
+"BelowGradeFinishedArea": 437
+"OriginalEntryTimestamp": "2026-07-21T16:38:12.43Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1177848"
+"ListOfficeNationalAssociationId": "1378680"
+"CoListAgentNationalAssociationId": "1401593"
+"CoListAgentNationalAssociationId2": "1441925"
+"CoListOfficeNationalAssociationId": "1324759"
+"CoListOfficeNationalAssociationId2": "1324759"
+"Media": array:37 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30060615')"
+"ID": "1646017"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23542
+post_id: "1642697"
+post_author: 1
+"ListingKey": "30056479"
+"ListingId": "40849052"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T18:45:08Z"
+"RFModificationTimestamp": "2026-07-20T19:56:37Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2040.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4X2"
+"UnparsedAddress": "163 LYNNBROOK Crescent, Waterloo, Ontario N2L4X2"
+"Coordinates": array:2 [
0 => -80.5476163
1 => 43.4914016
]
+"Latitude": 43.4914016
+"Longitude": -80.5476163
+"YearBuilt": 1970
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautifully and professionally renovated from top to bottom, this exceptional bungalow offers the perfect blend of timeless style and modern comfort in a highly sought-after family neighbourhood...... Thoughtfully designed, the home features 3 spacious main-floor bedrooms and 2 beautifully appointed full bathrooms........ ......At the heart of the home is a stunning Barzotti eat-in kitchen, showcasing quality craftsmanship, abundant cabinetry, stainless appliances and an inviting space for everyday living and effortless entertaining...... Luxury vinyl plank flooring flows throughout, complementing the home's bright, contemporary design..... .......The fully finished basement offers exceptional additional living space, featuring a generous recreation room..... two additional rooms that can easily serve as bedrooms, a home office, or a fitness area, along with a dedicated storage area to keep everything organized..... ........Enjoy your morning coffee or unwind in the evening on the cozy front porch..... Outside, the impressive 51 x 143 ft. pool-sized lot offers endless potential to create your own private backyard retreat, while the oversized garage provides ample space for vehicles, storage, and a workshop..... ........Offering quality finishes, versatile living space, and an outstanding location close to parks, schools, and everyday amenities, this turnkey home is a rare opportunity for families seeking both style, function and location..... **** Basement Bedrooms are virtually staged**** (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-20T19:56:25.793427+00:00"
+"Directions": "Mount Anne to Lynnbrook"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1890330"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-20T18:42:05Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T18:42:05Z"
+"Stories": "1.0"
+"StreetName": "LYNNBROOK"
+"StreetNumber": "163"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "4611.88"
+"VirtualTourURLUnbranded": "https://youriguide.com/163_lynnbrook_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30056479/163-lynnbrook-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 51.0
+"AboveGradeFinishedArea": 1140
+"BelowGradeFinishedArea": 900
+"OriginalEntryTimestamp": "2026-07-20T18:38:09.23Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1211160"
+"ListOfficeNationalAssociationId": "1324759"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30056479')"
+"ID": "1642697"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25362
+post_id: "1639482"
+post_author: 1
+"ListingKey": "30052193"
+"ListingId": "40849092"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T21:25:14Z"
+"RFModificationTimestamp": "2026-07-18T21:28:57Z"
+"ListPrice": 820000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2528.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1B2"
+"UnparsedAddress": "109 WHITE OAK Place, Waterloo, Ontario N2V1B2"
+"Coordinates": array:2 [
0 => -80.5558691
1 => 43.4950613
]
+"Latitude": 43.4950613
+"Longitude": -80.5558691
+"YearBuilt": 1978
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Gorgeous oversized raised bungalow on a quiet dead end street with no traffic. No sidewalk to shovel either! This home has over 2500 square feet of finished living space offering 3+1 beds and 2 full baths. The upstairs is nicely updated with hardwood floors and a custom kitchen with stone counter-tops. The stainless appliances includes a gas stove for the resident chef. The family room has 3 skylights bathing the space in beautiful natural light. There's a walkout to the back from this room leading to a spacious and quiet backyard. Downstairs features a huge family room with tons of light and a real wood fireplace. There's an addition bedroom and 3 pc bath on this level as well as easy access to the 2 car garage. The Lakeshore North location is great for expressway and LRT access. You've got a daycare very close by, local schools and shopping like Conestoga Mall, Sobeys and the Farmers Market. Laurel Creek Conversation Area is right up the road so getting to nature is very easy. Additional improvements include fresh paint, new rear stairs (summer 2025), spray foamed garage ceiling (2023), new heat pump (2023), new roof (2026), epoxy cold room crack repair (2026), and new front stairs (2026). (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Range - Gas"
4 => "Dishwasher"
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 => "Quiet Area"
]
+"CreationDate": "2026-07-18T17:46:35.956141+00:00"
+"Directions": "Northlake to Black Oak to White Oak"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
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": "1985202"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Skylight"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-18T21:18:17Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T21:18:17Z"
+"Stories": "1.0"
+"StreetName": "WHITE OAK"
+"StreetNumber": "109"
+"StreetSuffix": "Place"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "5843.62"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youriguide.com/109_white_oak_place_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30052193/109-white-oak-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 48.0
+"AboveGradeFinishedArea": 1618
+"BelowGradeFinishedArea": 910
+"OriginalEntryTimestamp": "2026-07-18T17:18:11.42Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1269822"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30052193')"
+"ID": "1639482"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25363
+post_id: "1637109"
+post_author: 1
+"ListingKey": "30044668"
+"ListingId": "40848250"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T18:50:06Z"
+"RFModificationTimestamp": "2026-07-24T19:02:59Z"
+"ListPrice": 875000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.182
+"LivingArea": 2275.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1X2"
+"UnparsedAddress": "363 TWINFLOWER Crescent, Waterloo, Ontario N2V1X2"
+"Coordinates": array:2 [
0 => -80.5616005
1 => 43.4984169
]
+"Latitude": 43.4984169
+"Longitude": -80.5616005
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Empty nesters and not ready for condo living? Welcome to this bright, open-concept bungalow nestled in Waterloo’s highly desirable Lakeshore North neighborhood. Perfect for downsizers seeking convenient main-floor living or small families looking for a vibrant, established community. You'll love the luxurious main floor bathroom boasting a custom, spa-like 5-piece privilege ensuite bath and the convenience of main floor laundry. This home features custom finishes like 9' ceilings, hardwood flooring, 5 1/4 baseboards and pot lights. The sunken living room is an inviting space perfect for relaxation and offering a seamless transition to outdoor living. The sunny, private backyard is beautifully landscaped and fenced on 3 sides. The design is perfect for entertaining and outdoor enjoyment with a durable composite deck complete with a natural gas BBQ hookup. The rec room has space for all your toys including a snooker table. The lower level also has 9' ceilings and would accommodate a parent with a private bedroom and 3 piece bathroom. There's plenty of parking with a double garage and 3 spots outside for family and friends. All this located in one of Waterloo's premier communities, offering a peaceful, active lifestyle with everything you need just minutes away. It's located just steps from the quiet paths of Pinebrook Park and within close proximity to the stunning trails and reservoir at the Laurel Creek Conservation Area. Add in excellent local schools, community playgrounds, and the nearby Albert McCormick Community Centre and library. Enjoy easy access to premium shopping and dining at Conestoga Mall, local grocery stores, and essential services. It's also conveniently located near major transit routes, the LRT, and Highway 85, making commutes across Waterloo region a breeze. Don't miss the rare opportunity to own a turnkey bungalow in this highly coveted, friendly neighborhood! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Garburator"
9 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:49:58.803696+00:00"
+"Directions": "Northlake to Monarch Place, turn right onto Twinflower"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563807"
+"ListOfficeKey": "76849"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Corner Site"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.182"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T18:42:14Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T18:42:14Z"
+"Stories": "1.0"
+"StreetName": "TWINFLOWER"
+"StreetNumber": "363"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "5915"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/363_twinflower_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30044668/363-twinflower-crescent-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 67.0
+"AboveGradeFinishedArea": 1456
+"BelowGradeFinishedArea": 819
+"OriginalEntryTimestamp": "2026-07-16T21:18:17.35Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070148"
+"ListOfficeNationalAssociationId": "1004401"
+"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": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30044668')"
+"ID": "1637109"
}
]
+success: true
+page_size: 9
+page_count: 9
+count: 74
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]