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 {#23484
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+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.13 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 {#25311
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25313
+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.11 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 {#25316
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29139209" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24937
+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 {#24919
+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 {#24849
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25156
+post_id: "528241"
+post_author: 1
+"ListingKey": "29239859"
+"ListingId": "40797385"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-12T16:10:57Z"
+"RFModificationTimestamp": "2026-01-12T20:09:59Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1785.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0A1"
+"UnparsedAddress": "875 UNIVERSITY Avenue E Unit# 35, Waterloo, Ontario N2K0A1"
+"Coordinates": array:2 [
0 => -80.4965135
1 => 43.5098035
]
+"Latitude": 43.5098035
+"Longitude": -80.4965135
+"YearBuilt": 2008
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to the Grand Bluffs, Waterloo’s premium address nestled along the scenic Grand River. This beautiful bungalow loft unit offers a unique blend of open-concept design and cozy charm, perfect for anyone seeking an upscale yet homey retreat. This unit features open and airy lofted ceilings, with abundant natural light from expansive windows and stunning river views. The spacious master suite is located on the main level with private ensuite and walk in closet. The main floor also has a formal dining space just off the living room which is open to the kitchen and dinette area with sliders to the large deck overlooking the Grand River and Snyder’s Flats. The upper loft space includes an additional bedroom with ensuite as well as a walk in closet and family room, perfect for guests! Main floor laundry with garage access and a large unfinished basement for additional storage complete this home. Located steps from walking trails, Grey Silo Golf Club, Rim Park, Conestogo Mall and highway access. Truly a rare offering in this exclusive complex. 1 year lease minimum, full credit report, application with references and confirmation of employment required. No students. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
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-01-12T20:09:34.411676+00:00"
+"Directions": "Off University between Northfield Drive and Lexington Road"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563706"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:8 [
0 => "Southern exposure"
1 => "Ravine"
2 => "Backs on greenbelt"
3 => "Conservation/green belt"
4 => "Balcony"
5 => "Paved driveway"
6 => "Sump Pump"
7 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-12T16:02:22Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-12T16:02:22Z"
+"Stories": "1.5"
+"StreetDirSuffix": "East"
+"StreetName": "UNIVERSITY"
+"StreetNumber": "875"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"View": "River view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1559466965"
"RoomType" => "Other"
"ListingId" => "40797385"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "59'5'' x 25'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
1 => array:11 [
"RoomKey" => "1559466966"
"RoomType" => "Family room"
"ListingId" => "40797385"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "19'3'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
2 => array:11 [
"RoomKey" => "1559466967"
"RoomType" => "4pc Bathroom"
"ListingId" => "40797385"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 5'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
3 => array:11 [
"RoomKey" => "1559466968"
"RoomType" => "Bedroom"
"ListingId" => "40797385"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
4 => array:11 [
"RoomKey" => "1559466969"
"RoomType" => "Primary Bedroom"
"ListingId" => "40797385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "21'3'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
5 => array:11 [
"RoomKey" => "1559466970"
"RoomType" => "Living room"
"ListingId" => "40797385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "15'1'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
6 => array:11 [
"RoomKey" => "1559466971"
"RoomType" => "Laundry room"
"ListingId" => "40797385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "7'3'' x 6'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
7 => array:11 [
"RoomKey" => "1559466972"
"RoomType" => "Kitchen"
"ListingId" => "40797385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
8 => array:11 [
"RoomKey" => "1559466973"
"RoomType" => "Dining room"
"ListingId" => "40797385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
9 => array:11 [
"RoomKey" => "1559466974"
"RoomType" => "Breakfast"
"ListingId" => "40797385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "7'4'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
10 => array:11 [
"RoomKey" => "1559466975"
"RoomType" => "Full bathroom"
"ListingId" => "40797385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
11 => array:11 [
"RoomKey" => "1559466976"
"RoomType" => "Foyer"
"ListingId" => "40797385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 5'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
12 => array:11 [
"RoomKey" => "1559466977"
"RoomType" => "2pc Bathroom"
"ListingId" => "40797385"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29239859"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 2'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-12T16:01:31.24Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29239859/875-university-avenue-e-unit-35-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 3650
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1785
+"OriginalEntryTimestamp": "2026-01-12T16:01:31.21Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:50 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6401488459"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/c1c5da983a66db237281533e58d83ebd.webp"
"MediaSize" => 164704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-c1c5da983a66db237281533e58d83ebd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.4Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6401488474"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/53a89b2284e8d748e7aca84e97c0cab5.webp"
"MediaSize" => 155144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-53a89b2284e8d748e7aca84e97c0cab5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.4Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6401488482"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/4a62bba66995e9d6d5e0059703e0698a.webp"
"MediaSize" => 157931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-4a62bba66995e9d6d5e0059703e0698a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.43Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6401488504"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/85b2314af4bf44e5f3d5e7fc674661bf.webp"
"MediaSize" => 145297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-85b2314af4bf44e5f3d5e7fc674661bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.43Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6401488564"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/1c22b5db65637b3e136bc910618c5e53.webp"
"MediaSize" => 42498
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-1c22b5db65637b3e136bc910618c5e53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.43Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6401488588"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/7eee6c9a8ec47a5953e12bca246f37ab.webp"
"MediaSize" => 74785
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-7eee6c9a8ec47a5953e12bca246f37ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.4Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6401488592"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/71981f344a4a15463010f5bed6fc231e.webp"
"MediaSize" => 76333
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-71981f344a4a15463010f5bed6fc231e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797385"
"ResourceRecordKey" => "29239859"
"ModificationTimestamp" => "2026-01-12T16:02:22.4Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6401488689"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29239859/48c0744cebe2d5131836a3912aefd0a4.webp"
"MediaSize" => 80979
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29239859/thumbnail-48c0744cebe2d5131836a3912aefd0a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
…3
]
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]
]
+"Member": []
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29239859')"
+"ID": "528241"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24830
+post_id: "527450"
+post_author: 1
+"ListingKey": "29239809"
+"ListingId": "X12686048"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-12T17:25:51Z"
+"RFModificationTimestamp": "2026-01-12T17:30:18Z"
+"ListPrice": 1250000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4N7"
+"UnparsedAddress": "201 SPRING GARDEN DRIVE, Waterloo, Ontario N2J4N7"
+"Coordinates": array:2 [
0 => -80.4926404
1 => 43.5244789
]
+"Latitude": 43.5244789
+"Longitude": -80.4926404
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautiful house located in Waterloo's prestigious Carriage Crossing neighbourhood. This sunny corner house offers large windows and plenty of natural light. Spacious great room and dinning room with hardwood floors on the main floor. Large family room with walk out balcony and four bedrooms and three full bathrooms on the second floor. The home has large windows on the basement, whole-house ventilation system, newly purchased water heater (2024), air conditioner, washer, dryer, stove, dishwasher (brand new), walk-out deck. Garage with high ceiling storage rack. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-12T16:16:36.631368+00:00"
+"Directions": "Cross Streets: University/Millennium. ** Directions: Grey Silo/Millstream."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2023362"
+"ListOfficeKey": "292792"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "49.4 x 109.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-12T15:47:36Z"
+"PhotosCount": 28
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-12T17:13:27Z"
+"Stories": "2.0"
+"StreetName": "Spring Garden"
+"StreetNumber": "201"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "8576"
+"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"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29239809/201-spring-garden-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 49.4
+"OriginalEntryTimestamp": "2026-01-12T15:47:36.7Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:28 [
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]
]
+"Member": []
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29239809')"
+"ID": "527450"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24788
+post_id: "519043"
+post_author: 1
+"ListingKey": "29228407"
+"ListingId": "40796808"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-10T21:30:34Z"
+"RFModificationTimestamp": "2026-01-10T21:31:57Z"
+"ListPrice": 599900.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# 67, Waterloo, Ontario N2K0E9"
+"Coordinates": array:2 [
0 => -80.4962059
1 => 43.5244609
]
+"Latitude": 43.5244609
+"Longitude": -80.4962059
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This brand-new move-in ready three-storey condo townhome offers a rare combination of space, flexibility, and low-maintenance living — ideal for those who want room to grow without the upkeep of a traditional freehold home. The thoughtfully designed 1,836 sq ft layout features four true bedrooms, including three on the upper level and one on the main floor, perfect for guests or a home office. With 3.5 bathrooms, busy mornings and everyday routines are made easy. East and west exposures fill the home with natural light throughout the day, while current views over open farmland provide a sense of space. Included finishes such as 9' ceilings on ground and second floors, Quartz countertops and steel backed stairs. There is a premium insulated garage door and Duradeck, aluminum and glass railing on the two balconies. Enjoy the peace of mind that comes with warranty-backed brand-new construction, along with a double car garage for secure parking and storage. Set within the highly regarded Carriage Crossing neighbourhood, families will appreciate scenic trails along the river and golf course, year-round recreation at RIM Park, and a modern community library — all just minutes from St. Jacobs Farmers’ Market, Conestoga Mall, schools, parks, and everyday conveniences. It’s a rare opportunity to enjoy the feel of countryside living while staying closely connected to the city. Experience modern, low-maintenance living at The Trailside Towns - a smart move-up option in a growing community. List price reflects all current incentives/promotions. Select images include virtual staging for illustrative purposes. Offers will be presented on Fri, Jan 16th at 11am, irrevocable until 5pm. Pre-emptive offers may be considered provided they include a minimum 24-hr irrevocable period calculated during business hours only, being Mon-Fri from 9am-5pm. (id:62650)"
+"Appliances": array:1 [
0 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"AssociationFee": "575.4"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-08T15:19:10.446789+00:00"
+"Directions": "Millennium to Crossgate"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564466"
+"ListOfficeKey": "76840"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-01-08T17:09:02Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-10T21:18:46Z"
+"Stories": "3.0"
+"StreetName": "GREY SILO"
+"StreetNumber": "271"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "6223"
+"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/29228407/271-grey-silo-road-unit-67-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2217706"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "289722"
+"GeocodeManualYN": true
+"ZoningDescription": "R9"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1836
+"OriginalEntryTimestamp": "2026-01-08T14:39:38.17Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29228407')"
+"ID": "519043"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24858
+post_id: "512605"
+post_author: 1
+"ListingKey": "29219150"
+"ListingId": "40795948"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T21:20:25Z"
+"RFModificationTimestamp": "2026-01-14T21:29:22Z"
+"ListPrice": 949000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3080.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3Y5"
+"UnparsedAddress": "537 WINDJAMMER Way, Waterloo, Ontario N2K3Y5"
+"Coordinates": array:2 [
0 => -80.5050792
1 => 43.506906
]
+"Latitude": 43.506906
+"Longitude": -80.5050792
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful Family Home in Highly Sought-After Eastbridge Community Welcome to this charming 4-bed, 3.5-bath home in the heart of Eastbridge—complete with a fully finished basement, covered outdoor living space, and no rear neighbours. With outstanding curb appeal in a family-friendly neighbourhood, this meticulously maintained home offers bright and thoughtfully designed living space. The spacious foyer includes a highly functional walk-in coat closet, ideal for busy families or hosting guests. A front living room provides the perfect spot for a home office or play area, with a clear view of the street to keep an eye on the kids. Elegant hardwood floors lead you to the renovated kitchen, featuring a gas stove, large island, and ambient pot lighting. The open-concept layout connects seamlessly to the second living area, complete with large windows and a cozy fireplace. Step through the sliding glass doors to your expansive covered deck, featuring a built-in BBQ, ample seating, and peaceful views—no rear neighbours make this private outdoor retreat exceptionally enjoyable. Upstairs, hardwood floors continue throughout. The large primary suite features two closets and a renovated spa-like 4-pc ensuite with heated floors and a steam shower. Three additional bedrooms, a linen closet, and a 5-pc bathroom complete the upper level. The fully finished basement offers engineered hardwood floors, a stone fireplace, a 3-pc bathroom, and generous storage space. This home has been exceptionally cared for and is truly move-in ready. Book your showing today! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-06T17:43:16.683185+00:00"
+"Directions": "Eastbridge Blvd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1879079"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Backs on greenbelt"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-06T15:00:44Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T21:09:21Z"
+"Stories": "2.0"
+"StreetName": "WINDJAMMER"
+"StreetNumber": "537"
+"StreetSuffix": "Way"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "6138"
+"VirtualTourURLUnbranded": "https://iguidephotos.com/95usa_537_windjammer_way_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29219150/537-windjammer-way-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2104
+"BelowGradeFinishedArea": 976
+"OriginalEntryTimestamp": "2026-01-06T15:00:44.44Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Assessor"
+"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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29219150')"
+"ID": "512605"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24828
+post_id: "498421"
+post_author: 1
+"ListingKey": "29200381"
+"ListingId": "X12646160"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T16:10:46Z"
+"RFModificationTimestamp": "2026-01-14T16:13:13Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4N3"
+"UnparsedAddress": "758 GRAND BANKS DRIVE, Waterloo, Ontario N2K4N3"
+"Coordinates": array:2 [
0 => -80.4993587
1 => 43.5135325
]
+"Latitude": 43.5135325
+"Longitude": -80.4993587
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to your new home in the highly sought-after Eastbridge community of Waterloo! This beautifully maintained 4-bedroom, 4-bathroom home offers about 2,500 sq. ft. of finished living space, perfect for families looking for comfort and convenience. new fridge and dishwasher, Freshly painted, The bright, open-concept main floor features a spacious kitchen and a breakfast bar, overlooking a warm and inviting living room. Walk out to a large deck and fully fenced backyard an ideal space for entertaining or relaxing with family and friends. Upstairs, youll find a large primary bedroom with vaulted ceilings, a walk-in closet, and a modern ensuite with a glass shower. three additional generous bedrooms and a full bath complete the upper level. The finished basement provides extra living space perfect for a family room, play area, or home office. Located close to top-rated schools, RIM Park, Grey Silo Golf Course, scenic trails, shopping, Conestoga Mall, public transit, and the expressway, this home has everything your family needs within minutes. A wonderful place to call home in one of Waterloos most desirable neighborhoods. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-22T18:26:40.072887+00:00"
+"Directions": "University Ave E/ New Bedford Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1596474"
+"ListOfficeKey": "290183"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-06T16:20:53Z"
+"PhotosCount": 24
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T15:51:18Z"
+"Stories": "2.0"
+"StreetName": "Grand Banks"
+"StreetNumber": "758"
+"StreetSuffix": "Drive"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29200381/758-grand-banks-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1598728"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "285271"
+"GeocodeManualYN": false
+"TotalActualRent": 3000
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-12-22T17:19:37.76Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:24 [
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]
]
+"Member": []
+"Office": array:1 [
0 => array:19 [ …19]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29200381')"
+"ID": "498421"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25155
+post_id: "491212"
+post_author: 1
+"ListingKey": "29196287"
+"ListingId": "40794602"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T17:50:24Z"
+"RFModificationTimestamp": "2026-01-14T17:54:43Z"
+"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 Conestoga mall, Restaurants, Highway 85, Conestoga College, University of Waterloo, Wilfrid Laurier University And Other Major Amenities. (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": "2026-01-14T17:38:53Z"
+"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 [ …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/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 [ …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]
]
+"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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23498
+post_id: "473825"
+post_author: 1
+"ListingKey": "29177727"
+"ListingId": "40793297"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T19:56:00Z"
+"RFModificationTimestamp": "2026-01-13T19:58:57Z"
+"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": "2026-01-13T19:39:29Z"
+"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": 3050
+"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"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24771
+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"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24862
+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"
}
]
+success: true
+page_size: 9
+page_count: 3
+count: 23
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]