array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29139209/Property?$select=ALL&$top=20&$filter=ListingKey eq 29139209&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29139209/Property?$select=ALL&$top=20&$filter=ListingKey eq 29139209&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23512
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23514
+post_id: "446182"
+post_author: 1
+"ListingKey": "29139209"
+"ListingId": "40790670"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-30T21:41:09Z"
+"RFModificationTimestamp": "2025-11-30T21:45:07Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2780.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0B3"
+"UnparsedAddress": "140 OAK PARK Drive, Waterloo, Ontario N2K0B3"
+"Coordinates": array:2 [
0 => -80.4969292
1 => 43.5207054
]
+"Latitude": 43.5207054
+"Longitude": -80.4969292
+"YearBuilt": 2013
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "EXECUTIVE FREEHOLD TOWNHOUSE LIVING IN UPSCALE WATERLOO NEIGHBORHOOD. Welcome to this beautifully upgraded and move-in ready townhome, offering over 2,000 SQ ft of thoughtfully designed living space in a desirable Waterloo neighborhood. This spacious home features 3 large bedrooms, 4 bathrooms, and a versatile in-law suite in the fully finished basement. Step inside the grand foyer and enter a bright, modern main level with open-concept living, perfect for entertaining. The chef’s kitchen boasts stainless steel appliances, an island with seating, and ample cabinet space — a true cooking lover’s dream — flowing seamlessly into the dining area and cozy living room with gas fireplace. Walk out to your private backyard for effortless indoor-outdoor living. Upstairs, you'll find three generous bedrooms, each with its own walk-in closet, along with a convenient laundry room and full 4-piece bath. The impressive primary suite features vaulted ceilings, a luxurious 5-piece ensuite with jacuzzi soaker tub, glass shower, and double vanity with great storage. The finished basement offers excellent in-law potential, with a spacious rec room, kitchenette, new luxury vinyl flooring, and a private 3-piece bath. Other highlights include fresh paint throughout, parking for two (one in the attached garage), and modern finishes throughout. Don’t miss this exceptional opportunity to own a feature-packed, low-maintenance home in one of Waterloo’s sought-after communities. Schedule your private showing today! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Freezer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Property Management"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T19:30:50.584247+00:00"
+"Directions": "MILLENIUM BLVD"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750682"
+"ListOfficeKey": "289792"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T18:30:13Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-30T21:29:53Z"
+"Stories": "2.0"
+"StreetName": "OAK PARK"
+"StreetNumber": "140"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "5216"
+"VirtualTourURLUnbranded": "https://youriguide.com/140_oak_park_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [
"RoomKey" => "1542738342"
"RoomType" => "Utility room"
"ListingId" => "40790670"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29139209"
"RoomLength" => null
"RoomDimensions" => "15'3'' x 6'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-30T21:29:53.25Z"
]
1 => array:11 [
"RoomKey" => "1542738343"
"RoomType" => "Storage"
"ListingId" => "40790670"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29139209"
"RoomLength" => null
"RoomDimensions" => "18'6'' x 6'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-30T21:29:53.25Z"
]
2 => array:11 [
"RoomKey" => "1542738344"
"RoomType" => "Recreation room"
"ListingId" => "40790670"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29139209"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 17'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-30T21:29:53.25Z"
]
3 => array:11 [
"RoomKey" => "1542738345"
"RoomType" => "Kitchen"
"ListingId" => "40790670"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29139209"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-30T21:29:53.26Z"
]
4 => array:11 [
"RoomKey" => "1542738346"
"RoomType" => "3pc Bathroom"
"ListingId" => "40790670"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29139209"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-30T21:29:53.26Z"
]
5 => array:11 [
"RoomKey" => "1542738347"
"RoomType" => "Other"
"ListingId" => "40790670"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29139209"
"RoomLength" => null
"RoomDimensions" => "6'1'' x 7'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-30T21:29:53.26Z"
]
6 => array:11 [
"RoomKey" => "1542738348"
"RoomType" => "Primary Bedroom"
"ListingId" => "40790670"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29139209"
"RoomLength" => null
"RoomDimensions" => "15'5'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-30T21:29:53.26Z"
]
7 => array:11 [
"RoomKey" => "1542738349"
"RoomType" => "Laundry room"
"ListingId" => "40790670"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29139209"
"RoomLength" => null
"RoomDimensions" => "5'3'' x 6'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-30T21:29:53.26Z"
]
8 => array:11 [
"RoomKey" => "1542738350"
"RoomType" => "Bedroom"
"ListingId" => "40790670"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29139209"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-30T21:29:53.26Z"
]
9 => array:11 [
"RoomKey" => "1542738351"
"RoomType" => "Bedroom"
"ListingId" => "40790670"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29139209"
"RoomLength" => null
"RoomDimensions" => "12'8'' x 9'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-30T21:29:53.26Z"
]
10 => array:11 [
"RoomKey" => "1542738352"
"RoomType" => "5pc Bathroom"
"ListingId" => "40790670"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29139209"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-30T21:29:53.26Z"
]
11 => array:11 [
"RoomKey" => "1542738353"
"RoomType" => "4pc Bathroom"
"ListingId" => "40790670"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29139209"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-30T21:29:53.26Z"
]
12 => array:11 [
"RoomKey" => "1542738354"
"RoomType" => "Living room"
"ListingId" => "40790670"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29139209"
"RoomLength" => null
"RoomDimensions" => "14'4'' x 18'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-30T21:29:53.26Z"
]
13 => array:11 [
"RoomKey" => "1542738355"
"RoomType" => "Kitchen"
"ListingId" => "40790670"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29139209"
"RoomLength" => null
"RoomDimensions" => "14'4'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-30T21:29:53.26Z"
]
14 => array:11 [
"RoomKey" => "1542738356"
"RoomType" => "Foyer"
"ListingId" => "40790670"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29139209"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 7'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-30T21:29:53.26Z"
]
15 => array:11 [
"RoomKey" => "1542738357"
"RoomType" => "Dining room"
"ListingId" => "40790670"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29139209"
"RoomLength" => null
"RoomDimensions" => "14'4'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-30T21:29:53.26Z"
]
16 => array:11 [
"RoomKey" => "1542738358"
"RoomType" => "2pc Bathroom"
"ListingId" => "40790670"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29139209"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-30T21:29:53.26Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29139209/140-oak-park-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "MR-4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1888
+"BelowGradeFinishedArea": 893
+"OriginalEntryTimestamp": "2025-11-26T18:30:13.19Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:31 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6341341545"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/11f8dced8a5ac4d8a6dc77951fdfd4db.webp"
"MediaSize" => 133824
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-11f8dced8a5ac4d8a6dc77951fdfd4db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6341341561"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/b076dca1ce6107c1d6bcd5bec94c3d1d.webp"
"MediaSize" => 115424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-b076dca1ce6107c1d6bcd5bec94c3d1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6341341571"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/fc46595feae20e424c5eece88002cec9.webp"
"MediaSize" => 124739
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-fc46595feae20e424c5eece88002cec9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6341341615"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/34b262e33aa9244112f1e6b2737324cd.webp"
"MediaSize" => 33470
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-34b262e33aa9244112f1e6b2737324cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6341341630"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/0d92f3051bb3d077a64dfb7fa9f80900.webp"
"MediaSize" => 36369
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-0d92f3051bb3d077a64dfb7fa9f80900.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6341341678"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/cf26c1095dc34fdeff95d7aff22386ba.webp"
"MediaSize" => 70891
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-cf26c1095dc34fdeff95d7aff22386ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6341341741"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/49e8dbed706f01196a15e20eef69b2c9.webp"
"MediaSize" => 60166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-49e8dbed706f01196a15e20eef69b2c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6341341778"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/7c72e4a33b59cfa40ab022a406e3d71a.webp"
"MediaSize" => 76369
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-7c72e4a33b59cfa40ab022a406e3d71a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6341341819"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/499ed13bbe760298f634f8c33d42eedc.webp"
"MediaSize" => 59034
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-499ed13bbe760298f634f8c33d42eedc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6341341877"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/1620bf647f5e71486beb2c715c6cc25c.webp"
"MediaSize" => 64264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-1620bf647f5e71486beb2c715c6cc25c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6341341901"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/adf53de5dc83747537e6e0909c83c059.webp"
"MediaSize" => 66774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-adf53de5dc83747537e6e0909c83c059.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6341341963"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/9ae6e387b98bfd52bb68ee514a2cef70.webp"
"MediaSize" => 83661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-9ae6e387b98bfd52bb68ee514a2cef70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6341341999"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/9d486b6d22660cf5ee4d9f6edb42c9af.webp"
"MediaSize" => 58544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-9d486b6d22660cf5ee4d9f6edb42c9af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6341342029"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/ce387f68aa8c5b3dc5706e7042fa39d4.webp"
"MediaSize" => 61957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-ce387f68aa8c5b3dc5706e7042fa39d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6341342070"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/2bb3b417c64c8b6cbed6fc3916dda90b.webp"
"MediaSize" => 74133
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-2bb3b417c64c8b6cbed6fc3916dda90b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6341342096"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/66178d1bc03568f03fcf105aff29c2ed.webp"
"MediaSize" => 56559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-66178d1bc03568f03fcf105aff29c2ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "ENSUITE"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6341342109"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/5d53dd89b4e62a067920940c6d503a14.webp"
"MediaSize" => 47595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-5d53dd89b4e62a067920940c6d503a14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "ENSUITE"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6341342151"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/35b96a616598a455ec526dabb399f3c6.webp"
"MediaSize" => 53813
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-35b96a616598a455ec526dabb399f3c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "ENSUITE"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6341342183"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/028c6639505ffadb6513a154d669315f.webp"
"MediaSize" => 42370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-028c6639505ffadb6513a154d669315f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6341342203"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/c87eae6485d027df4cb69f5aaa8d2fc3.webp"
"MediaSize" => 65031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-c87eae6485d027df4cb69f5aaa8d2fc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6341342238"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/8f45afab18e1524fffbcc5f72aac1f93.webp"
"MediaSize" => 49192
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-8f45afab18e1524fffbcc5f72aac1f93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6341342258"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/428f2f92215de98618d468f33e1d9b8c.webp"
"MediaSize" => 85144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-428f2f92215de98618d468f33e1d9b8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6341342286"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/9b78995f621c41f5285ec0ff9cc845d0.webp"
"MediaSize" => 58547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-9b78995f621c41f5285ec0ff9cc845d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6341342313"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/d8658ee1c1f2b25a93430becfb8a55e9.webp"
"MediaSize" => 59060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-d8658ee1c1f2b25a93430becfb8a55e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6341342333"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/1d7c9c0d370eda2e66da5c5163a6232d.webp"
"MediaSize" => 58274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-1d7c9c0d370eda2e66da5c5163a6232d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6341342343"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/5d33f9c35f121243bc36c360e0d545dc.webp"
"MediaSize" => 128297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-5d33f9c35f121243bc36c360e0d545dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6341342363"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/c54f55b3bb45d6c2ffa032d968bb2a7f.webp"
"MediaSize" => 151901
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-c54f55b3bb45d6c2ffa032d968bb2a7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6341342384"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/94d0d3601044de6f8075f1379980a54b.webp"
"MediaSize" => 137390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-94d0d3601044de6f8075f1379980a54b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6341342397"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/94e52ca6604376df5dfeb089317f6253.webp"
"MediaSize" => 38400
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-94e52ca6604376df5dfeb089317f6253.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6341342418"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/2cbfe12d3364b991f84ee5dad9da0032.webp"
"MediaSize" => 48178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-2cbfe12d3364b991f84ee5dad9da0032.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6341342427"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139209/0bead703e78691b70d6fd14d18d459c2.webp"
"MediaSize" => 43654
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139209/thumbnail-0bead703e78691b70d6fd14d18d459c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790670"
"ResourceRecordKey" => "29139209"
"ModificationTimestamp" => "2025-11-26T18:30:13.21Z"
]
]
+"Member": array:1 [
0 => array:24 [
"MemberFullName" => "TONY JOHAL"
"MemberFirstName" => "TONY"
"MemberLastName" => "JOHAL"
"MemberMlsId" => "CA4118"
"OriginatingSystemName" => 26
"MemberKey" => "1750682"
"ModificationTimestamp" => "2025-10-28T23:28:48Z"
"MemberStatus" => "Active"
"OfficeKey" => "289792"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"JobTitle" => "Broker"
"MemberFax" => "519-740-7230"
"MemberCity" => "CAMBRIDGE"
"MemberType" => "Broker"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "519-740-3690"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2008-03-03T22:49:00Z"
"MemberNationalAssociationId" => "1164848"
"OfficeNationalAssociationId" => "1381240"
]
]
+"Office": array:1 [
0 => array:23 [
"OfficeName" => "RE/MAX TWIN CITY REALTY INC."
"OfficePhone" => "519-740-3690"
"OfficeMlsId" => "CA724"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "289792"
"ModificationTimestamp" => "2025-11-06T22:57:19Z"
"OfficeAddress1" => "1400 BISHOP ST. N, SUITE B"
"OfficeCity" => "CAMBRIDGE"
"OfficePostalCode" => "N1R6W"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"OfficeFax" => "519-740-7230"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2021-03-11T15:35:00Z"
"OfficeNationalAssociationId" => "1381240"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1379798"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139209')"
+"ID": "446182"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 289792/Office?$select=ALL&$top=10&$filter=OfficeKey eq 289792&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 289792/Office?$select=ALL&$top=10&$filter=OfficeKey eq 289792&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25341
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25343
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "519-740-3690"
+"OfficeMlsId": "CA724"
+"ModificationTimestamp": "2025-11-06T22:57:19Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "289792"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "1400 BISHOP ST. N, SUITE B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "CAMBRIDGE"
+"OfficePostalCode": "N1R6W"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1381240"
+"OriginalEntryTimestamp": "2021-03-11T15:35:00Z"
+"OfficeFax": "519-740-7230"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "433716"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "289792"
"SocialMediaUrlOrId" => "https://www.remaxtwincity.com/"
"ModificationTimestamp" => "2025-11-06T18:57:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1379798"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('289792')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1750682/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1750682&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1750682/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1750682&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25346
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29139209" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24974
+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 29139209/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29139209&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29139209/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29139209&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24954
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29139209 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.4969292 43.5207054)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29139209 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.4969292 43.5207054)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29139209 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.4969292 43.5207054)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29139209 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.4969292 43.5207054)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24866
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24858
+post_id: "491212"
+post_author: 1
+"ListingKey": "29196287"
+"ListingId": "40794602"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-19T17:45:10Z"
+"RFModificationTimestamp": "2025-12-19T19:12:15Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1299.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3Y8"
+"UnparsedAddress": "540 MARINER Drive, Waterloo, Ontario N2K3Y8"
+"Coordinates": array:2 [
0 => -80.507857
1 => 43.5060424
]
+"Latitude": 43.5060424
+"Longitude": -80.507857
+"YearBuilt": 1997
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A Beautiful 3 bed , 3.5 bath Freehold Townhome backing on green space with fully finished basement available for sale in Eastbridge neighborhood of Waterloo! Upon entrance through the foyer, you will find open concept main floor with spacious kitchen featuring plenty of kitchen cabinets, breakfast bar, glass tile backsplash, a powder room and a bright and spacious living room. Second floor features a huge master bedroom with 4 pc ensuite bathroom and huge closet. 2 more good sized bedrooms with huge closets and another 4 pc family bathroom. Very spacious Fully finished basement with rec room and full bath. Total 2 parking spaces - Single car garage and an asphalt private single driveway. Recent upgrades- New Roof 2023, New kitchen countertops and kitchen Appliances, Attic insulation, All bathroom fixtures, Carpet, hardwood on main floor, All door hardware's, All lights and switches, New patio sliding door, New paint, new owned water heater, New owned water softener. Conveniently located close to public schools, short walk to bus stop, parks, few minutes drive to (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Central Vacuum"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"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": "2025-12-19T19:12:07.057125+00:00"
+"Directions": "Eastbridge Blvd. & Mariner Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2000528"
+"ListOfficeKey": "291992"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Backs on greenbelt"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"PhotosChangeTimestamp": "2025-12-19T17:38:21Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-19T17:38:21Z"
+"Stories": "2.0"
+"StreetName": "MARINER"
+"StreetNumber": "540"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3782.5"
+"Utilities": array:1 [
0 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/540_mariner_dr_waterloo_on"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1551359046"
"RoomType" => "3pc Bathroom"
"ListingId" => "40794602"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 4'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.79Z"
]
1 => array:11 [
"RoomKey" => "1551359047"
"RoomType" => "Utility room"
"ListingId" => "40794602"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "17'8'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.8Z"
]
2 => array:11 [
"RoomKey" => "1551359048"
"RoomType" => "Recreation room"
"ListingId" => "40794602"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "17'7'' x 17'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.8Z"
]
3 => array:11 [
"RoomKey" => "1551359049"
"RoomType" => "Full bathroom"
"ListingId" => "40794602"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "7'3'' x 4'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.8Z"
]
4 => array:11 [
"RoomKey" => "1551359050"
"RoomType" => "4pc Bathroom"
"ListingId" => "40794602"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "5'11'' x 8'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.8Z"
]
5 => array:11 [
"RoomKey" => "1551359051"
"RoomType" => "Primary Bedroom"
"ListingId" => "40794602"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 13'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.8Z"
]
6 => array:11 [
"RoomKey" => "1551359052"
"RoomType" => "Bedroom"
"ListingId" => "40794602"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.8Z"
]
7 => array:11 [
"RoomKey" => "1551359053"
"RoomType" => "Bedroom"
"ListingId" => "40794602"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.8Z"
]
8 => array:11 [
"RoomKey" => "1551359054"
"RoomType" => "2pc Bathroom"
"ListingId" => "40794602"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "4'10'' x 5'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.8Z"
]
9 => array:11 [
"RoomKey" => "1551359055"
"RoomType" => "Dining room"
"ListingId" => "40794602"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 6'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.8Z"
]
10 => array:11 [
"RoomKey" => "1551359056"
"RoomType" => "Kitchen"
"ListingId" => "40794602"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 8'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.8Z"
]
11 => array:11 [
"RoomKey" => "1551359057"
"RoomType" => "Living room"
"ListingId" => "40794602"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29196287"
"RoomLength" => null
"RoomDimensions" => "13'8'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-19T17:38:21.8Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29196287/540-mariner-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "MD3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 22.0
+"AboveGradeFinishedArea": 1299
+"OriginalEntryTimestamp": "2025-12-19T17:38:21.77Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:41 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6376185255"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/296694bff407976861fb0d11cd606f0b.webp"
"MediaSize" => 71722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-296694bff407976861fb0d11cd606f0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6376185353"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/9dd3b2d32c6bbe44ee1f8a2db0c1b0d8.webp"
"MediaSize" => 152695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-9dd3b2d32c6bbe44ee1f8a2db0c1b0d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6376185431"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/0a6d2120f56dedc7ed0c30194f5c5d44.webp"
"MediaSize" => 44274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-0a6d2120f56dedc7ed0c30194f5c5d44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6376185499"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/5bb09d644bf73ec9c489d53a8e0d5486.webp"
"MediaSize" => 156296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-5bb09d644bf73ec9c489d53a8e0d5486.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6376185593"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/d2ba72414e903206c7f4fb6ae340112d.webp"
"MediaSize" => 66660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-d2ba72414e903206c7f4fb6ae340112d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6376185648"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/cb887d5b4f013ad61d0d43e16e9d3e92.webp"
"MediaSize" => 64046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-cb887d5b4f013ad61d0d43e16e9d3e92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6376185722"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/36e63400e33ab2f1cf3bf429fa7ba871.webp"
"MediaSize" => 42657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-36e63400e33ab2f1cf3bf429fa7ba871.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6376185832"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/d147e8aaac8416e38356bfbffa2c37ed.webp"
"MediaSize" => 50936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-d147e8aaac8416e38356bfbffa2c37ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6376185925"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/5abf518f8e8229b0c25da7920d2c1655.webp"
"MediaSize" => 59669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-5abf518f8e8229b0c25da7920d2c1655.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794602"
"ResourceRecordKey" => "29196287"
"ModificationTimestamp" => "2025-12-19T17:38:21.77Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6376185975"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29196287/dd90cfef6a5b560a4316dab25e37376f.webp"
"MediaSize" => 61090
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29196287/thumbnail-dd90cfef6a5b560a4316dab25e37376f.webp"
…7
]
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]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29196287')"
+"ID": "491212"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24801
+post_id: "473825"
+post_author: 1
+"ListingKey": "29177727"
+"ListingId": "40793297"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-19T05:40:46Z"
+"RFModificationTimestamp": "2025-12-19T05:42:36Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1836.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0E9"
+"UnparsedAddress": "271 GREY SILO Road Unit# 51, Waterloo, Ontario N2K0E9"
+"Coordinates": array:2 [
0 => -80.4951779
1 => 43.5235489
]
+"Latitude": 43.5235489
+"Longitude": -80.4951779
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this luxury Trailside Townhome located in the highly sought-after Carriage Crossing community in Waterloo! Enjoy a maintenance-free lifestyle with lawn care, landscaping, and snow removal included. This modern and elegant 4-bedroom, 4-bathroom home offers a double car garage and exceptional finishes throughout. The main floor provides a versatile office/bedroom complete with a stunning 3-piece ensuite featuring a quartz vanity and sleek tiled shower. The second level showcases an open-concept layout with a gourmet kitchen boasting an island, quartz countertops, stainless steel appliances, and a spacious walk-in pantry/storage. The adjoining great room and dining area feature warm hardwood flooring, along with a convenient 2-piece powder room and access to a balcony. On the third level, the primary bedroom offers a walk-in closet and a beautifully designed ensuite with tiled shower and quartz vanity. Two additional bedrooms share a stylish 4-piece bathroom. The upper-level laundry adds convenience, plus a second balcony for outdoor enjoyment. Situated just steps from the Walter Bean Trail, Grand River, RIM Park, Grey Silo Golf Course, and close to Conestoga Mall, Conestoga College, and University of Waterloo—this home provides an unbeatable lifestyle with easy access to premium amenities and top-rated schools. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-10T19:52:20.050381+00:00"
+"Directions": "Millennium to Crossgate"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2218013"
+"ListOfficeKey": "289539"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2025-12-10T19:31:02Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-19T05:29:47Z"
+"Stories": "3.0"
+"StreetName": "GREY SILO"
+"StreetNumber": "271"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "6247"
+"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/29177727/271-grey-silo-road-unit-51-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 3150
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "R9"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1836
+"OriginalEntryTimestamp": "2025-12-10T19:08:37.09Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:21 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29177727')"
+"ID": "473825"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24817
+post_id: "468750"
+post_author: 1
+"ListingKey": "29170241"
+"ListingId": "40791913"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-08T14:40:52Z"
+"RFModificationTimestamp": "2025-12-08T14:43:37Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1559.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4A2"
+"UnparsedAddress": "447 BRIGANTINE Drive, Waterloo, Ontario N2K4A2"
+"Coordinates": array:2 [
0 => -80.5109197
1 => 43.5063641
]
+"Latitude": 43.5063641
+"Longitude": -80.5109197
+"YearBuilt": 1997
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Perfect for families or professionals, this full-home rental is set within one of Waterloo’s most sought-after neighbourhoods. The thoughtfully designed floor plan includes 3 above-grade bedrooms, including a generous primary suite featuring a walk-in closet and private ensuite, with a second full bathroom completing the upper level. The main floor offers a bright, functional layout with a dining room, living room, kitchen, and a convenient powder room. The large front hallway closet provides exceptional storage for all your family’s needs, and the kitchen offers ample cabinetry, including a convenient pantry. Skylights bring in abundant natural light, creating a warm and inviting atmosphere, and a walkout leads to a deck overlooking a beautifully maintained garden and fully fenced backyard—ideal for relaxing, barbecuing, or entertaining. The finished basement enhances the home’s versatility with a fourth bedroom or flex room, a full bathroom, a wet bar, a laundry area, and a generous family room with a cozy gas fireplace—perfect for guests, a home office, or additional recreational space. Located close to top-rated schools, RIM Park, golf courses, trails, the river, shopping, dining, Conestoga Mall, Uptown Waterloo, and convenient public transit, this home also offers quick access to Hwy 7/8 and both universities, combining comfort, convenience, and an unbeatable location to create an exceptional place to call home. (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 => "Freezer"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-08T14:43:19.127196+00:00"
+"Directions": "Bridge St. W., to Chesapeake Drive, to Brigantine Drive"
+"ExteriorFeatures": array:3 [
0 => "Vinyl siding"
1 => "Shingles"
2 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2101905"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Skylight"
3 => "Sump Pump"
4 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-08T12:58:33Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-08T14:30:00Z"
+"Stories": "2.0"
+"StreetName": "BRIGANTINE"
+"StreetNumber": "447"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "4822"
+"VirtualTourURLUnbranded": "https://iguidephotos.com/447_brigantine_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29170241/447-brigantine-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1908292"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "289541"
+"GeocodeManualYN": true
+"TotalActualRent": 3100
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 37.0
+"AboveGradeFinishedArea": 1559
+"OriginalEntryTimestamp": "2025-12-08T12:58:32.94Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29170241')"
+"ID": "468750"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24868
+post_id: "466761"
+post_author: 1
+"ListingKey": "29166639"
+"ListingId": "40792630"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-05T18:50:28Z"
+"RFModificationTimestamp": "2025-12-05T19:18:31Z"
+"ListPrice": 650000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1120.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G8"
+"UnparsedAddress": "249 GREY SILO Road Unit# 202, Waterloo, Ontario N2K0G8"
+"Coordinates": array:2 [
0 => -80.4967199
1 => 43.5226913
]
+"Latitude": 43.5226913
+"Longitude": -80.4967199
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Prepare to fall in love with this rare corner condo where sophisticated design meets everyday indulgence with over 1100 sqft of living space. From the moment you step inside, you’re welcomed by wide hallways, 8.5 ft ceilings, and sunlight streaming through expansive windows. At the heart of the home, the chef’s kitchen commands attention with its dramatic quartzite island, custom drawers, soft-close cabinetry, and full suite of KitchenAid appliances. Subtle details—USB outlets, under-cabinet lighting, and dimmer switches—make the space as functional as it is beautiful. The living/dining area flows effortlessly to a spectacular 320 sq ft wrap-around balcony. Imagine sipping morning coffee with the sunrise, hosting dinner outdoors, or filling the space with lush container gardens—this balcony is a private oasis large enough for both lounging and entertaining. Retreat to the serene primary suite with double closets customized for style and storage, and a spa-inspired ensuite featuring a walk-in tiled shower with bench seating and sleek quartz vanity. The versatile second bedroom doubles perfectly as a guest room or home office, while the 4-piece main bath with a soaker tub offers a touch of everyday luxury. Added conveniences include in-suite laundry, engineered hardwood floors, built-in closet systems, and a smart thermostat. Life here extends far beyond your walls. Head to the rooftop terrace where panoramic views stretch over farmland and skyline. With fire tables glowing, BBQs sizzling, community gardens thriving, and stylish lounge spaces, it feels like a private resort in the heart of Waterloo. Add two parking spaces (one underground with locker, one at-grade near the entrance), plenty of visitor parking, and meticulous landscaping, and the package is complete. All this in the coveted Grey Silo community—steps to Rim Park, Grey Silo Golf Course, and endless trails, with shopping, dining, and universities just minutes away. This is condo living at its finest. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"AssociationFee": "555.81"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-05T19:18:07.773871+00:00"
+"Directions": "Old Park Drive to Grey Silo Road"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1565503"
+"ListOfficeKey": "283852"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2025-12-05T18:38:38Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-05T18:38:38Z"
+"Stories": "1.0"
+"StreetName": "GREY SILO"
+"StreetNumber": "249"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "4383.33"
+"VirtualTourURLUnbranded": "https://youriguide.com/202_249_grey_silo_rd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29166639/249-grey-silo-road-unit-202-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1565504"
+"CommonInterest": "Condo/Strata"
+"CoListAgentKey2": "1565502"
+"CoListOfficeKey": "86262"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "289848"
+"ZoningDescription": "R9"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1120
+"OriginalEntryTimestamp": "2025-12-05T18:38:37.78Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:27 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29166639')"
+"ID": "466761"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24869
+post_id: "447768"
+post_author: 1
+"ListingKey": "29139760"
+"ListingId": "X12579306"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T20:06:03Z"
+"RFModificationTimestamp": "2025-11-26T23:41:49Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0B3"
+"UnparsedAddress": "140 OAK PARK DRIVE, Waterloo, Ontario N2K0B3"
+"Coordinates": array:2 [
0 => -80.4967276
1 => 43.520707
]
+"Latitude": 43.520707
+"Longitude": -80.4967276
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "EXECUTIVE FREEHOLD TOWNHOUSE LIVING IN UPSCALE WATERLOO NEIGHBORHOOD. Welcome to this beautifully upgraded and move-in readytownhome, offering over 2,000 SQ ft of thoughtfully designed living space in a desirable Waterloo neighborhood. This spacious home features 3large bedrooms, 4 bathrooms, and a versatile in-law suite in the fully finished basement. Step inside the grand foyer and enter a bright, modernmain level with open-concept living, perfect for entertaining. The chef's kitchen boasts stainless steel appliances, an island with seating, andample cabinet space - a true cooking lover's dream - flowing seamlessly into the dining area and cozy living room with gas fireplace. Walk outto your private backyard for effortless indoor-outdoor living. Upstairs, you'll find three generous bedrooms, each with its own walk-in closet,along with a convenient laundry room and full 4-piece bath. The impressive primary suite features vaulted ceilings, a luxurious 5-piece ensuitewith jacuzzi soaker tub, glass shower, and double vanity with great storage. The finished basement offers excellent in-law potential, with aspacious rec room, kitchenette, new luxury vinyl flooring, and a private 3-piece bath. Other highlights include fresh paint throughout, parking fortwo (one in the attached garage), and modern finishes throughout. Don't miss this exceptional opportunity to own a feature-packed, lowmaintenance home in one of Waterloo's sought-after communities. Schedule your private showing today! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Freezer"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Full"
2 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T23:41:44.585257+00:00"
+"Directions": "MILLENIUM BLVD"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2182896"
+"ListOfficeKey": "289816"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "19.7 x 114.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T19:58:55Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T19:58:55Z"
+"Stories": "2.0"
+"StreetName": "Oak Park"
+"StreetNumber": "140"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5216"
+"VirtualTourURLUnbranded": "https://youriguide.com/140_oak_park_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29139760/140-oak-park-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 19.8
+"OriginalEntryTimestamp": "2025-11-26T19:58:55.51Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:31 [
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]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139760')"
+"ID": "447768"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24815
+post_id: "446181"
+post_author: 1
+"ListingKey": "29139457"
+"ListingId": "X12579086"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-19T22:00:29Z"
+"RFModificationTimestamp": "2025-12-19T22:05:32Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3Z6"
+"UnparsedAddress": "MAIN - 579 WINDJAMMER WAY, Waterloo, Ontario N2K3Z6"
+"Coordinates": array:2 [
0 => -80.5029887
1 => 43.5084069
]
+"Latitude": 43.5084069
+"Longitude": -80.5029887
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful main-floor unit in Waterloo's highly desirable East Bridge community. Bright open-concept layout with an updated kitchen featuring stone countertops and new appliances. Enjoy a cozy family room with a fireplace and a primary bedroom with a 3-piece ensuite. Private Laundry. Private backyard backing onto a park and school. Minutes to top-rated schools, RIM Park, Conestoga Mall, UW, Conestoga College, and highway access. Double garage and wide driveway, parking 1 on driveway 2 in garage! Tenants pay 80% utilities (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T19:40:52.761761+00:00"
+"Directions": "Eastbridge Blvd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Laminate"
1 => "Vinyl"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2023409"
+"ListOfficeKey": "278195"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T19:01:42Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-19T21:47:00Z"
+"Stories": "2.0"
+"StreetName": "Windjammer"
+"StreetNumber": "579"
+"StreetSuffix": "Way"
+"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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29139457/main-579-windjammer-way-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3000
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-26T19:01:42.59Z"
+"MapCoordinateVerifiedYN": false
+"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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139457')"
+"ID": "446181"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23526
+post_id: "446183"
+post_author: 1
+"ListingKey": "29139074"
+"ListingId": "40790705"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T18:30:52Z"
+"RFModificationTimestamp": "2025-11-26T18:56:49Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1991.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3Z6"
+"UnparsedAddress": "579 WINDJAMMER Way Unit# Main, Waterloo, Ontario N2K3Z6"
+"Coordinates": array:2 [
0 => -80.5028784
1 => 43.5080285
]
+"Latitude": 43.5080285
+"Longitude": -80.5028784
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful main-floor unit in Waterloo’s highly desirable East Bridge community. Bright open-concept layout with an updated kitchen featuring stone countertops and new appliances. Enjoy a cozy family room with a fireplace and a primary bedroom with a 3-piece ensuite. PrivauPrivate backyard backing onto a park and school. Minutes to top-rated schools, RIM Park, Conestoga Mall, UW, Conestoga College, and highway access. Double garage and wide driveway included—an ideal place to call home! (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T18:56:33.467036+00:00"
+"Directions": "Eastbridge Blvd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2129629"
+"ListOfficeKey": "283262"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T18:11:43Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T18:11:43Z"
+"Stories": "2.0"
+"StreetName": "WINDJAMMER"
+"StreetNumber": "579"
+"StreetSuffix": "Way"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"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/29139074/579-windjammer-way-unit-main-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3000
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 1991
+"OriginalEntryTimestamp": "2025-11-26T18:08:41.84Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139074')"
+"ID": "446183"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24867
+post_id: "441278"
+post_author: 1
+"ListingKey": "29131608"
+"ListingId": "40790134"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T17:55:51Z"
+"RFModificationTimestamp": "2025-11-26T18:23:47Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2747.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4B8"
+"UnparsedAddress": "442 CHESAPEAKE Drive, Waterloo, Ontario N2K4B8"
+"Coordinates": array:2 [
0 => -80.508133
1 => 43.506918
]
+"Latitude": 43.506918
+"Longitude": -80.508133
+"YearBuilt": 2000
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this lovely and move-in-ready 3+1 bedroom single-family home, perfectly situated in Eastbridge, one of Waterloo's most sought-after neighbourhoods. Ideally located backing onto the school yard green space with no backyard neighbours, this home offers privacy and direct access to Lester B. Pearson Public School yard, green space and playground—a rare advantage for families. Inside, you'll enter into a stylishly updated (2025) main floor including spacious foyer leading into a bright, sun filled open-concept space featuring a lovely living room with a gas fireplace, a separate dining area and convenient mudroom/laundry. The impressive upper family room with vaulted ceilings is perfect for family gatherings, or cozy movie nights. This family room offers a unique covered second-storey balcony—an ideal spot for morning coffee or unwinding in the evening. The primary suite features a renovated (2025) 5 pc ensuite and generous walk-in closet. The fully finished lower level adds even more functional space, including a fabulous rec room with rustic barn board feature wall, an additional bedroom or office area and another full bath. With approximately 2,800 sq. ft. of living space, this home is designed for comfort and versatility. Just steps from two highly rated elementary schools, the new splash pad, walking trails, Manulife RIM park including the Eastside Library and Grey Silo Golf Club this home puts recreation, learning, and convenience at your doorstep. You're also minutes from Conestoga Mall, St. Jacobs Market, LRT, Expressway access and more—everything a growing family needs. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-24T19:58:38.442364+00:00"
+"Directions": "Bridge Street to Chesapeake Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563572"
+"ListOfficeKey": "76789"
+"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": "2025-11-24T17:30:15Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T17:38:51Z"
+"Stories": "2.0"
+"StreetName": "CHESAPEAKE"
+"StreetNumber": "442"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "5680.58"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/442-Chesapeake-Dr"
+"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/29131608/442-chesapeake-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 37.0
+"AboveGradeFinishedArea": 2079
+"BelowGradeFinishedArea": 668
+"OriginalEntryTimestamp": "2025-11-24T17:30:15.59Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:47 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29131608')"
+"ID": "441278"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24889
+post_id: "439871"
+post_author: 1
+"ListingKey": "29130349"
+"ListingId": "X12570350"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-24T20:35:47Z"
+"RFModificationTimestamp": "2025-11-24T20:38:37Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3Y3"
+"UnparsedAddress": "488 CABOT TRAIL, Waterloo, Ontario N2K3Y3"
+"Coordinates": array:2 [
0 => -80.5042596
1 => 43.5042704
]
+"Latitude": 43.5042704
+"Longitude": -80.5042596
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 488 Cabot Trail. This executive bungalow nestled in a quiet, family-friendly street. Sitting on a 52.5 ft wide lot, this meticulously maintained home features a massive 4,000+ sf total livable space, including a 2,101 sf floor plan on main (per MPAC), three spacious bedrooms including a primary suite with walk-in closet and ensuite, plus a second full washroom for extra convenience, a soaring 15 ft high cathedral ceiling at foyer with double door entry, a formal dining room, an open concept kitchen combined with a large family room walk out to the deck. Numerous pot lights throughout. Downstairs, the finished basement offers the 4th bedroom with its own ensuite, a generous multi-function storage room, and a HUGE 813 sf recreation room can be used as gym, home theatre, workshop, studios, you name it. The fully fenced backyard lined with privacy trees and a large deck covered by a motorized awning, perfect for BBQs with family and friends. No sidewalk. The two-car garage with a deep driveway can park 6 vehicles. Minutes to parks, trails, top-rated schools, RIM Park, Grey Silo Golf Club, Conestoga Mall, and the St. Jacobs Market. This home offers comfort, space, flexibility, and endless potential in one of the most desirable neighbourhoods in Waterloo. A Must see! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener remote(s)"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-23T22:38:42.740659+00:00"
+"Directions": "Lexington & Bridge"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007138"
+"ListOfficeKey": "280684"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Irregular lot size"
]
+"LotSizeDimensions": "52.5 x 122 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-23T20:54:04Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-24T20:24:34Z"
+"Stories": "1.0"
+"StreetName": "Cabot"
+"StreetNumber": "488"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "7439.58"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29130349/488-cabot-trail-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 52.6
+"OriginalEntryTimestamp": "2025-11-23T20:54:03.83Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:26 [
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]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29130349')"
+"ID": "439871"
}
]
+success: true
+page_size: 9
+page_count: 4
+count: 29
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]